HRS_JOB_OPENING_ID1=1-Job Opening
2=2-Applicant
3=3-Recruitment Summary
4=4-Route
5=5-Interview
6=6-Offer
1=1-Applied
2=2-Reviewed
3=3-Screen
4=4-Route
5=5-Interview
6=6-Offer
7=7-Hire
8=8-Hold
9=9-Reject
HRS_JO_STS_VW(SQL View) |
Index Back |
|---|---|
Job Opening Status ViewJob Opening Status View |
| SELECT A.HRS_JOB_OPENING_ID ,B.STATUS_AREA ,B.STATUS_CODE ,B.STATUS_PHASE ,B.OPEN_STS_IND FROM PS_HRS_JOB_OPENING A , PS_HRS_STS_TBL B WHERE A.STATUS_CODE = B.STATUS_CODE AND B.STATUS_AREA = '1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 2 | 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 |
| 3 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Identifies a status. |
| 4 | STATUS_PHASE | Character(1) | VARCHAR2(1) NOT NULL |
Identifies a phase within a status area.
1=1-Applied 2=2-Reviewed 3=3-Screen 4=4-Route 5=5-Interview 6=6-Offer 7=7-Hire 8=8-Hold 9=9-Reject |
| 5 | OPEN_STS_IND | Character(1) | VARCHAR2(1) NOT NULL | Indicates an open state. |