UPG_APP_RTE_TAO(SQL Table) |
Index Back |
|---|---|
Application RoutingUse 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 | ROUTE_DT |
Date(10) | DATE NOT NULL |
Route Date
Default Value: %date |
| 5 | ROUTE_TO_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Route To ID
Prompt Table: PERSON_NAME |
| 6 | RESPONSE_DUE_DT | Date(10) | DATE | Response Due Date |
| 7 | STATUS_DT | Date(10) | DATE |
Status Date
Default Value: %date |
| 8 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Identifies a status. |
| 9 | STATUS_REASON | Character(3) | VARCHAR2(3) NOT NULL | Identifies a reason associated with a particular status. |
| 10 | RESPONSE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Response Code
HOL=Hold on File INV=Invite for Interview NOR=No Response RIE=Reject-Insufficent Experience RIS=Reject-Insufficent Skills RNO=Reject-No Opening ROR=Reject-Other |