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

SGHE Banner Operational Data Store
Reporting View Target: HR_APPLICATION_STATUS

Description Contains status for employment applications.
Key & Frequency One row per person per requisition number per sequence number per status per position applied for.
Recommended Search Columns PERSON_UID
STATUS, STATUS_DATE

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPLICATION_DATE Application submission date. DATE

PARAPST

PARAPST_APPL_DATE

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

NA

NA

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

NA

NA

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

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(63)

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(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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(63)

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(255)

FUNCTION

GOKODSF.F_GET_DESC



Ver: 8.5