UPG_STATUS_AREA1=1-Job Opening
2=2-Applicant
3=3-Recruitment Summary
4=4-Route
5=5-Interview
6=6-Offer
OFFER_REJECT_RSNB=Benefits
J=Another Job
N=Not Specified
P=Personal
S=Salary
DISPOSITION_REASNUPG_ER_STS_RSN(SQL Table) |
Index Back |
|---|---|
Status Reason DefinitionDefines a set of status reasons for status codes for status areas. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | UPG_STATUS_AREA |
Character(1) | VARCHAR2(1) NOT NULL |
Defines an area in the system that track statuses.
1=1-Job Opening 2=2-Applicant 3=3-Recruitment Summary 4=4-Route 5=5-Interview 6=6-Offer |
| 2 | OFFER_REJECT_RSN |
Character(1) | VARCHAR2(1) NOT NULL |
Reject Reason
B=Benefits J=Another Job N=Not Specified P=Personal S=Salary |
| 3 | DISPOSITION_REASN |
Character(3) | VARCHAR2(3) NOT NULL | Rejected Reason |
| 4 | UPG_STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Identifies a status. |
| 5 | STATUS_REASON | Character(3) | VARCHAR2(3) NOT NULL | Identifies a reason associated with a particular status. |