RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Operational Data Store
Composite View Target: AP_HR_APPLICATION_STATUS

Description Source composite view contains status information for applicants.

Target Column Business Definition Database Data Type Source Name Source Column
APPLICATION_DATE Application submission date. DATE

PARAPST

PARAPST_APPL_DATE

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

NA

SYSDATE

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

NA

NA

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

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

NA

NA

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

PARAPST

PARAPST_PIDM

POSITION_APPLIED_FOR Position number associated with this applicant entry. VARCHAR2(6)

PARAPST

PARAPST_POSN

POSITION_APPLIED_FOR_TITLE Title or description of a position to which a candidate has applied. VARCHAR2(30)

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. VARCHAR2(5)

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. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

REQUISITION_NUMBER Requisition number to which this candidate has applied. VARCHAR2(10)

PARAPST

PARAPST_REQ_NO

SEQUENCE_NUMBER Sequence number given to each application. VARCHAR2(3)

PARAPST

PARAPST_SEQ_NO

STATUS Status of applicant. VARCHAR2(2)

PARAPST

PARAPST_APPS_CODE

STATUS_COMMENT Free form comment regarding this applicant status entry. VARCHAR2(4000)

PARAPST

PARAPST_COMMENT

STATUS_DATE Date the applicant status was entered. DATE

PARAPST

PARAPST_APPS_DATE

STATUS_DESC Status description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA



Ver: 3.1