STATUS_AREA_CHG1=Job Opening
2=Applicant
3=Recruitment Summary
4=Route
5=Interview
6=Offer
STATUS_CODE_CHGSTATUS_REASONHRS_STSRSN_VW(SQL View) |
Index Back |
|---|---|
Status Reason ViewStatus Reason View |
| SELECT A.STATUS_AREA , A.STATUS_CODE , A.STATUS_REASON , A.DESCR , A.DESCRSHORT FROM PS_HRS_STSRSN_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATUS_AREA_CHG |
Character(1) | VARCHAR2(1) NOT NULL |
Identifies a status area that is impacted by a status change.
1=Job Opening 2=Applicant 3=Recruitment Summary 4=Route 5=Interview 6=Offer |
| 2 | STATUS_CODE_CHG |
Character(3) | VARCHAR2(3) NOT NULL | Identifies a status code that is changed or is changed to based on a status code change. |
| 3 | STATUS_REASON |
Character(3) | VARCHAR2(3) NOT NULL | Identifies a reason associated with a particular status. |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |