| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 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 |
STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status.
Prompt Table:
HRS_STS_TBL
|
| 3 |
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
|
| 4 |
AFFECTED_APPLICANT |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies the applicant / job req combination that is affected by a status change when the position applied for status is modified. The choices are current applicant for the current job requisition, current applicant for other job requisitions, and other applicants for the current job requisition.
0=Current Appl / Current Req
1=Current Appl / Other Job Reqs
2=Other Appl / Current Req
|
| 5 |
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.
Prompt Table:
HRS_STATUS_VW
|
| 6 |
STATUS_RSN_CHG |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status reason to change or to change to based on a status change.
Prompt Table:
HRS_STSRSN_VW
|
| 7 |
ALL_REASONS |
Character(1) |
VARCHAR2(1) NOT NULL |
All Reasons
Y/N Table Edit
Default Value: Y
|
| 8 |
DATA_TYPE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
|
| 9 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 10 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 11 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 12 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|