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

SGHE Banner Operational Data Store
Composite View Target: AP_CERTIFICATION

Description Source composite view contains certification information relating to an employee.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
CERTIFICATION 4 character code identifying the certification.    

PPRCERT

PPRCERT_CERT_CODE

 
CERTIFICATION_DATE Date the certification was obtained.    

PPRCERT

PPRCERT_CERT_DATE

 
CERTIFICATION_DESC Certification description.    

FUNCTION

GOKODSF.F_GET_DESC

 
CERTIFICATION_EXPIRE_DATE Date the certification expires.    

PPRCERT

PPRCERT_EXPIRE_DATE

 
CERTIFICATION_NUMBER Number of the certification if applicable.    

PPRCERT

PPRCERT_CERT_NO

 
COMMENTS Free form comment on the certificates recorded for a person.    

PPRCERT

PPRCERT_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

 
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

 
NEXT_CERTIFICATION_DATE Date on which the employee is scheduled to be re-certified.    

PPRCERT

PPRCERT_NEXT_CERT_DATE

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

PPRCERT

PPRCERT_PIDM

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

NA

NA

 


Ver: 8.3