HRS_JO_SCR_LVL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_JO_SCR_SUMM_ID	Number(15,0)	DECIMAL(15) NOT NULL	JO Screening Summary ID Prompt Table: HRS_JO_SCR_SUMM
2	HRS_JO_SCR_SEQ	Number(3,0)	SMALLINT NOT NULL	Job opening screening sequence
3	HRS_SCREENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Screening ID Prompt Table: HRS_SCREEN_VW
4	HRS_SCR_PCT_PASS	Number(3,0)	SMALLINT NOT NULL	Percent needed to pass a screening level
5	HRS_SCR_PT_PASS	Number(4,0)	SMALLINT NOT NULL	Points assigned for passing a screening level
6	HRS_SCR_USE_RAW_PT	Character(1)	VARCHAR2(1) NOT NULL	Assign raw points during screening Y/N Table Edit Default Value: N
7	HRS_SCR_MAX_PT	Signed Number(5,0)	DECIMAL(4) NOT NULL	Maximum points assigned for passing a screening level
8	HRS_SCR_PT_FAIL	Signed Number(4,0)	DECIMAL(3) NOT NULL	Points assigned for failing screening
9	HRS_SCR_STS_PASS	Character(3)	VARCHAR2(3) NOT NULL	Status to assign when pass screening Prompt Table: HRS_STS_REC_I Set Control Field: STATUS_AREA
10	HRS_SCR_RSN_PASS	Character(3)	VARCHAR2(3) NOT NULL	Reason to assign when pass screening Prompt Table: HRS_RSN_PASS Set Control Field: STATUS_AREA
11	HRS_SCR_STS_FAIL	Character(3)	VARCHAR2(3) NOT NULL	Status to assign when fail screening Prompt Table: HRS_STS_REC_I Set Control Field: STATUS_AREA
12	HRS_SCR_RSN_FAIL	Character(3)	VARCHAR2(3) NOT NULL	Reason to assign when fail screening Prompt Table: HRS_RSN_FAIL Set Control Field: STATUS_AREA
13	HRS_REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	The Fusion Publisher Report Definition ID used by Recruiting
14	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
15	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
16	HRS_JO_SCR_DTTM	DateTime(26)	TIMESTAMP	Job opening screening level date/time run
17	HRS_JO_SCR_CHG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Job opening screening criteria changed flag Y/N Table Edit Default Value: N
18	HRS_SCR_REQ_PT	Signed Number(5,0)	DECIMAL(4) NOT NULL	Maximum points assigned for passing a screening level
19	HRS_SCR_TOT_PT	Signed Number(5,0)	DECIMAL(4) NOT NULL	Maximum points assigned for passing a screening level
20	HRS_EMSG_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_ONL_EMSG_VW
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_ONL_PMSG_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_ONL_FMSG_VW
23	HRS_FAIL_EMAIL_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field determines that a Screening Level definition is to be used for Online Screening.
24	HRS_PASS_EMAIL_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field determines that a Screening Level definition is to be used for Online Screening.
25	HRS_REJT_EMAIL_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field determines that a Screening Level definition is to be used for Online Screening. N=No Y=Yes
26	HRS_SCR_TRANSMUTE	Character(1)	VARCHAR2(1) NOT NULL	Transmutation flag Y/N Table Edit Default Value: N
27	HRS_TRANSMUTE_SCOR	Number(3,0)	SMALLINT NOT NULL	The score to which raw score is transmuted.
28	HRS_HOURLY	Character(1)	VARCHAR2(1) NOT NULL	Hourly Transmutation check flag Y/N Table Edit Default Value: N
29	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
30	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
31	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
32	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id