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_HR_APPLICATION_STATUS

Description Source composite view contains status information for applicants.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
APPLICATION_DATE Application submission date.    

PARAPST

PARAPST_APPL_DATE

 
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

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

PARAPST

PARAPST_PIDM

 
POSITION_APPLIED_FOR Position number associated with this applicant entry.    

PARAPST

PARAPST_POSN

 
POSITION_APPLIED_FOR_TITLE Title or description of a position to which a candidate has applied.    

NBBPOSN

NBBPOSN_TITLE

 
POSITION_CLASS Position class associated with the requisition to which this applicant has applied. Organizes the job classifications for the institution and holds attributes that control title, employee class, eel code and wage and salary data. Also, the primary organizer for the design and maintenance of the position definition. These attributes are inherited when the employee is assigned to the position.    

PARAPST

PARAPST_PCLS_CODE

 
POSITION_CLASS_DESC Position class description or title. Organizes the job classifications for the institution and holds attributes that control title, employee class, eel code and wage and salary data. Also, the primary organizer for the design and maintenance of the position definition. These attributes are inherited when the employee is assigned to the position.    

FUNCTION

GOKODSF.F_GET_DESC

 
REQUISITION_NUMBER Requisition number to which this candidate has applied.    

PARAPST

PARAPST_REQ_NO

 
SEQUENCE_NUMBER Sequence number given to each application.    

PARAPST

PARAPST_SEQ_NO

 
STATUS Status of applicant.    

PARAPST

PARAPST_APPS_CODE

 
STATUS_COMMENT Free form comment regarding this applicant status entry.    

PARAPST

PARAPST_COMMENT

 
STATUS_DATE Date the applicant status was entered.    

PARAPST

PARAPST_APPS_DATE

 
STATUS_DESC Status description.    

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

 


Ver: 8.3