UPG_APP_RT_TAO (SQL Table)	Index Back
Application Routing Use APPLICATN_ROUTE to record who an application for employment was routed to, the date it was routed, and the date it's due back. This data is used primarily in Recruitment. You can create multiple APPLICATN_ROUTE records for an applicant.

UPG_APP_RT_TAO

(SQL Table)

Application Routing

Use APPLICATN_ROUTE to record who an application for employment was routed to, the date it was routed, and the date it's due back. This data is used primarily in Recruitment. You can create multiple APPLICATN_ROUTE records for an applicant.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID

2 APP_DT Date(10) DATE NOT NULL Date an application was submitted

3 JOB_REQ_NBR Character(6) VARCHAR2(6) NOT NULL Job requisition number

4 STATUS_DT Date(10) DATE Status Date
Default Value: %date

5 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

6 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	APPLID	Character(11)	VARCHAR2(11) NOT NULL	External Job Applicant ID
2	APP_DT	Date(10)	DATE NOT NULL	Date an application was submitted
3	JOB_REQ_NBR	Character(6)	VARCHAR2(6) NOT NULL	Job requisition number
4	STATUS_DT	Date(10)	DATE	Status Date Default Value: %date
5	STATUS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Identifies a status.
6	STATUS_REASON	Character(3)	VARCHAR2(3) NOT NULL	Identifies a reason associated with a particular status.