Composite View Target: AP_HR

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AP_HR_APPLICATION

Description Source composite view contains application information for persons that are applying for a position at the institution. Data includes information pertaining to requisition number, position, class, application date, skill, source, etc. The view returns one row per position applied for.

Target Column Business Definition Database Data Type Source Name Source Column

APPLICATION_DATE Application submission date. DATE
PABAPPL

PABAPPL_DATE

APPROVAL_DATE Date the position requisition was approved. DATE
PABREQU

PABREQU_APPR_DATE

CONTRACT_GROUP Specifies the EEO Contract Group to which the employees in this employee class belong. Used for EEO reporting. VARCHAR2(2)
PTRECLS

PTRECLS_EEOG_CODE

CONTRACT_GROUP_DESC Contract group description. VARCHAR2(30)
PTVEEOG

PTVEEOG_DESC

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

SYSDATE

DESIRED_HOURLY Hourly rate applicant desires. NUMBER(11, 2)
PABAPPL

PABAPPL_DESIRED_HOURLY

DESIRED_SALARY Annual salary applicant desires. NUMBER(11, 2)
PABAPPL

PABAPPL_DESIRED_SALARY

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

NA

EMPLOYEE_CLASS Employee class code. Organizes position information consistent with employee groupings. At the employee level, used to help determine controls for benefits, leave, payroll and self-service rules. VARCHAR2(2)
NBBPOSN

NBBPOSN_ECLS_CODE

EMPLOYEE_CLASS_LONG_DESC Employee class long description. VARCHAR2(30)
PTRECLS

PTRECLS_LONG_DESC

EMPLOYEE_CLASS_SHORT_DESC Employee class short description. VARCHAR2(8)
PTRECLS

PTRECLS_SHORT_DESC

EMPLOYEE_SKILL EEO skill code associated with this applicant. VARCHAR2(2)
PABAPPL

PABAPPL_ESKL_CODE

EMPLOYEE_SKILL_DESC EEO skill code description. VARCHAR2(30)
PTVESKL

PTVESKL_DESC

FULLTIME_PARTTIME_IND Indicates whether the applicant wishes to work part time of full-time. VARCHAR2(1)
PABAPPL

PABAPPL_FULL_PART_IND

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

PAID_RELOCATION_IND Indicates if relocation assistance is available for this position. VARCHAR2(1)
PABREQU

PABREQU_RELOC_IND

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

PABAPPL_PIDM

POSITION_APPLIED_FOR Position number associated with the requisition to which this applicant has applied. VARCHAR2(6)
PABAPPL

PABAPPL_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)
PABAPPL

PABAPPL_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)
NTRPCLS

NTRPCLS_DESC

POSITION_CLOSE_DATE Date the application for the position will be closed. DATE
PABREQU

PABREQU_CLOSE_DATE

POSITION_HIRE_DATE Projected date of hire for this position. DATE
PABREQU

PABREQU_HIRE_DATE

POSITION_OPEN_DATE Date the application for the position opens. DATE
PABREQU

PABREQU_OPEN_DATE

POSITION_POSTING_DATE Date the position is posted. DATE
PABREQU

PABREQU_POST_DATE

POSITION_VACANCY_DATE Date the position vacates. DATE
PABREQU

PABREQU_VACY_DATE

REQUISITION_NUMBER Requisition number to which the applicant has applied. VARCHAR2(10)
PABAPPL

PABAPPL_REQ_NO

REQUISITION_STATUS Status of the requisition (open, filled, etc.). VARCHAR2(2)
PABREQU

PABREQU_REQS_CODE

SOURCE Source where applicant found out about job opening. VARCHAR2(2)
PABAPPL

PABAPPL_ASRC_CODE

SOURCE_DESC Description of the source where applicant found out about job opening. VARCHAR2(30)
PTVASRC

PTVASRC_DESC

STATUS_DISPOSITION Applicant status disposition. VARCHAR2(1)
FUNCTION

F_DISPOSITION_IND

STATUS_DISPOSITION_DESC Status disposition description. VARCHAR2(30)
CALCULATION

DECODE(F_DISPOSITION_IND,'H','HIRED','N','NO LONGER CONSIDERED','U','UNDER CONSIDERATION')

TITLE Position title. VARCHAR2(30)
NBBPOSN

NBBPOSN_TITLE

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

NA

Ver: 8.1

Target Column	Business Definition	Database Data Type	Source Name	Source Column
APPLICATION_DATE	Application submission date.	DATE	PABAPPL	PABAPPL_DATE
APPROVAL_DATE	Date the position requisition was approved.	DATE	PABREQU	PABREQU_APPR_DATE
CONTRACT_GROUP	Specifies the EEO Contract Group to which the employees in this employee class belong. Used for EEO reporting.	VARCHAR2(2)	PTRECLS	PTRECLS_EEOG_CODE
CONTRACT_GROUP_DESC	Contract group description.	VARCHAR2(30)	PTVEEOG	PTVEEOG_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DESIRED_HOURLY	Hourly rate applicant desires.	NUMBER(11, 2)	PABAPPL	PABAPPL_DESIRED_HOURLY
DESIRED_SALARY	Annual salary applicant desires.	NUMBER(11, 2)	PABAPPL	PABAPPL_DESIRED_SALARY
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
EMPLOYEE_CLASS	Employee class code. Organizes position information consistent with employee groupings. At the employee level, used to help determine controls for benefits, leave, payroll and self-service rules.	VARCHAR2(2)	NBBPOSN	NBBPOSN_ECLS_CODE
EMPLOYEE_CLASS_LONG_DESC	Employee class long description.	VARCHAR2(30)	PTRECLS	PTRECLS_LONG_DESC
EMPLOYEE_CLASS_SHORT_DESC	Employee class short description.	VARCHAR2(8)	PTRECLS	PTRECLS_SHORT_DESC
EMPLOYEE_SKILL	EEO skill code associated with this applicant.	VARCHAR2(2)	PABAPPL	PABAPPL_ESKL_CODE
EMPLOYEE_SKILL_DESC	EEO skill code description.	VARCHAR2(30)	PTVESKL	PTVESKL_DESC
FULLTIME_PARTTIME_IND	Indicates whether the applicant wishes to work part time of full-time.	VARCHAR2(1)	PABAPPL	PABAPPL_FULL_PART_IND
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
PAID_RELOCATION_IND	Indicates if relocation assistance is available for this position.	VARCHAR2(1)	PABREQU	PABREQU_RELOC_IND
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)	PABAPPL	PABAPPL_PIDM
POSITION_APPLIED_FOR	Position number associated with the requisition to which this applicant has applied.	VARCHAR2(6)	PABAPPL	PABAPPL_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)	PABAPPL	PABAPPL_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)	NTRPCLS	NTRPCLS_DESC
POSITION_CLOSE_DATE	Date the application for the position will be closed.	DATE	PABREQU	PABREQU_CLOSE_DATE
POSITION_HIRE_DATE	Projected date of hire for this position.	DATE	PABREQU	PABREQU_HIRE_DATE
POSITION_OPEN_DATE	Date the application for the position opens.	DATE	PABREQU	PABREQU_OPEN_DATE
POSITION_POSTING_DATE	Date the position is posted.	DATE	PABREQU	PABREQU_POST_DATE
POSITION_VACANCY_DATE	Date the position vacates.	DATE	PABREQU	PABREQU_VACY_DATE
REQUISITION_NUMBER	Requisition number to which the applicant has applied.	VARCHAR2(10)	PABAPPL	PABAPPL_REQ_NO
REQUISITION_STATUS	Status of the requisition (open, filled, etc.).	VARCHAR2(2)	PABREQU	PABREQU_REQS_CODE
SOURCE	Source where applicant found out about job opening.	VARCHAR2(2)	PABAPPL	PABAPPL_ASRC_CODE
SOURCE_DESC	Description of the source where applicant found out about job opening.	VARCHAR2(30)	PTVASRC	PTVASRC_DESC
STATUS_DISPOSITION	Applicant status disposition.	VARCHAR2(1)	FUNCTION	F_DISPOSITION_IND
STATUS_DISPOSITION_DESC	Status disposition description.	VARCHAR2(30)	CALCULATION	DECODE(F_DISPOSITION_IND,'H','HIRED','N','NO LONGER CONSIDERED','U','UNDER CONSIDERATION')
TITLE	Position title.	VARCHAR2(30)	NBBPOSN	NBBPOSN_TITLE
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA