| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
HRS_JO_SCR_SUMM_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
JO Screening Summary ID
Prompt Table:
HRS_JO_SCR_SM_I
|
| 3 |
HRS_JO_SCR_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Job opening screening sequence
Prompt Table:
HRS_JO_SCR_LV_I
|
| 4 |
HRS_JO_RQMT |
Character(3) |
VARCHAR2(3) NOT NULL |
Job opening requirement
010=Regular / Temp
020=Full / Part Time
030=Desired Start Date
040=Standard Hours
050=Shift
060=Travel Percent
070=Minimum Salary
080=Minimum Age
090=Maximum Age
100=Sex
110=Citizenship Status
120=Minimum Grade
130=RS Location
140=Military Rank
150=Military Service
160=Location
170=Recruiting Type
|
| 5 |
POINTS |
Number(4,0) |
SMALLINT NOT NULL |
Points
|
| 6 |
HRS_JO_SCR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Opening Screening Requirement Required
Y/N Table Edit
Default Value: N
|
| 7 |
HRS_JO_SCR_AUGMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Augmentation factor
Y/N Table Edit
Default Value: N
|
| 8 |
HRS_JO_SCR_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Selective factor
Y/N Table Edit
Default Value: N
|