Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Common Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AP_SKILL

Description Source composite view contains skill information for an employee or person applying for a position at the institution.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
COMMENTS Free text comments related to the skill.    

PPRSKIL

PPRSKIL_COMMENTS

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
END_DATE Date the skill was ended.    

PPRSKIL

PPRSKIL_END_DATE

 
LAST_DATE Date the skill was last used.    

PPRSKIL

PPRSKIL_LAST_DATE

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

NA

NA

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

NA

NA

 
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

 
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

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

NA

NA

 


Ver: 8.3