Reporting View Target: HR_APPLICATION

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

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