Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: SKILL

Description Contains data related to a person's skills.
Key & Frequency One row per person per skill.
Recommended Search Columns PERSON_UID

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
COMMENTS Free text comments related to the skill.    

PPRSKIL

PPRSKIL_COMMENTS

 
END_DATE Date the skill was ended.    

PPRSKIL

PPRSKIL_END_DATE

 
ID Person's or organization's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
LAST_DATE Date the skill was last used.    

PPRSKIL

PPRSKIL_LAST_DATE

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
NAME Name of the person (last name, first name, middle initial) or organization.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
NATIVE_IND Indicates if this language is the native language of this individual.    

PPRSKIL

PPRSKIL_NATIVE_IND

 
PERSON_UID System generated, unique, internal identification number assigned to this person.    

PPRSKIL

PPRSKIL_PIDM

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
READ_IND Indicates if person can read this skill.    

PPRSKIL

PPRSKIL_READ_IND

 
SKILL Identifies the type of skill.    

PPRSKIL

PPRSKIL_SKIL_CODE

 
SKILL_DESC Skill description.    

FUNCTION

GOKODSF.F_GET_DESC

 
SKILL_LEVEL Identifies the level of expertise achieved within the skill.    

PPRSKIL

PPRSKIL_SKLV_CODE

 
SKILL_LEVEL_DESC Skill Level description.    

FUNCTION

GOKODSF.F_GET_DESC

 
SPEAK_IND Indicates if person can speak this language skill.    

PPRSKIL

PPRSKIL_SPEAK_IND

 
START_DATE Date the skill was learned.    

PPRSKIL

PPRSKIL_START_DATE

 
TEACH_IND Indicates if person can teach this skill.    

PPRSKIL

PPRSKIL_TEACH_IND

 
TRANSLATE_IND Indicates if person can translate this language skill.    

PPRSKIL

PPRSKIL_TRANS_IND

 
WRITE_IND Indicates if person can write with this language skill.    

PPRSKIL

PPRSKIL_WRITE_IND

 


Ver: 8.3