| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HRS_SCREENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Screening ID
|
| 2 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
Default Value: A
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 5 |
HRS_SCR_PCT_PASS |
Number(3,0) |
SMALLINT NOT NULL |
Percent needed to pass a screening level
|
| 6 |
HRS_SCR_PT_PASS |
Number(4,0) |
SMALLINT NOT NULL |
Points assigned for passing a screening level
|
| 7 |
HRS_SCR_USE_RAW_PT |
Character(1) |
VARCHAR2(1) NOT NULL |
Assign raw points during screening
Y/N Table Edit
Default Value: N
|
| 8 |
HRS_SCR_MAX_PT |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Maximum points assigned for passing a screening level
|
| 9 |
HRS_SCR_PT_FAIL |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Points assigned for failing screening
|
| 10 |
HRS_SCR_STS_PASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Status to assign when pass screening
Prompt Table:
HRS_STS_REC_I
|
| 11 |
HRS_SCR_RSN_PASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason to assign when pass screening
Prompt Table:
HRS_RSN_PASS
|
| 12 |
HRS_SCR_STS_FAIL |
Character(3) |
VARCHAR2(3) NOT NULL |
Status to assign when fail screening
Prompt Table:
HRS_STS_REC_I
|
| 13 |
HRS_SCR_RSN_FAIL |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason to assign when fail screening
Prompt Table:
HRS_RSN_FAIL
|
| 14 |
HRS_REPORT_DEFN_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The Fusion Publisher Report Definition ID used by Recruiting
|
| 15 |
HRS_REPORT_TMPL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
The Fusion publisher Report template ID used by RS.
Prompt Table:
HRS_XP_APPTMP_V
|
| 16 |
HRS_SCR_MANUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to determine if screening level is to be done manually.
Y/N Table Edit
Default Value: N
|
| 17 |
HRS_ONLINE_SCR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field determines that a Screening Level definition is to be used for Online Screening.
Y/N Table Edit
Default Value: N
|
| 18 |
HRS_NOTIFICATION |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to display online pass notification when an applicant applies online. If this is set to 'N' then no online notification will be shown, only an email notification will be sent.
A=None
B=Fail Screen Only
C=Pass Screen Only
D=Pass and Fail Screen Only
E=Fail Email Only
F=Pass Email Only
G=Pass and Fail Email Only
H=Fail Screen and Email
I=Pass Screen and Email
J=Fail Screen, Pass Email
K=Pass Screen, Fail Email
L=Fail Screen, Pass & Fail Email
M=Pass Screen, Pass & Fail Email
N=Pass & Fail Screen, Fail Email
O=Pass & Fail Screen, Pass Email
P=All
Default Value: A
|
| 19 |
HRS_RANDOM_QA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag determines if both the Questions and Multiple Answer selection are to be shown in a random manner or not.
Y/N Table Edit
Default Value: Y
|
| 20 |
HRS_SCRN_LVL_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Stores the Screening Level Description
|
| 21 |
HRS_PASS_TEXT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
When an applicant passes Online Screening this text id is used to obtain the text from the HR_SSTEXT_TEXT table if online notification is set to on.
Prompt Table:
HRS_PASS_MSG_VW
|
| 22 |
HRS_FAIL_TEXT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
When an applicant fails Online Screening this text id is used to obtain the text from the HR_SSTEXT_TEXT table
Prompt Table:
HRS_FAIL_MSG_VW
|
| 23 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 24 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 25 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 26 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|