HRS_SCRLVL_TAO

#	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
4	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone Prompt Table: HRS_JO_I
5	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: HRS_JO_JOBCD_I
6	HRS_JO_RQMT_SEQ	Number(3,0)	SMALLINT NOT NULL	Job opening requirement sequence Prompt Table: HRS_JO_RQMT_I
7	HRS_SCREENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Screening ID Prompt Table: HRS_SCREEN_I
8	HRS_SCR_TTL_PT	Signed Number(5,0)	DECIMAL(4) NOT NULL	Maximum points for all of screening
9	HRS_SCR_TRANSMUTE	Character(1)	VARCHAR2(1) NOT NULL	Transmutation flag Y/N Table Edit Default Value: N
10	HRS_SCR_DEPENDENT	Character(1)	VARCHAR2(1) NOT NULL	Flag to determine whether a previous level must be passed in order to be considered for next level Y/N Table Edit Default Value: N
11	GVT_VP_SCORE_LMT	Number(3,0)	SMALLINT NOT NULL	Raw Veterans Pref Score Limit
12	GVT_AUG_SCORE_LMT	Number(3,0)	SMALLINT NOT NULL	Raw Augmented Score Limit
13	HRS_SCR_PCT_PASS	Number(3,0)	SMALLINT NOT NULL	Percent needed to pass a screening level
14	HRS_SCR_PT_PASS	Number(4,0)	SMALLINT NOT NULL	Points assigned for passing a screening level
15	HRS_SCR_USE_RAW_PT	Character(1)	VARCHAR2(1) NOT NULL	Assign raw points during screening Y/N Table Edit Default Value: N
16	HRS_SCR_MAX_PT	Signed Number(5,0)	DECIMAL(4) NOT NULL	Maximum points assigned for passing a screening level
17	HRS_SCR_PT_FAIL	Signed Number(4,0)	DECIMAL(3) NOT NULL	Points assigned for failing screening
18	HRS_SCR_STS_PASS	Character(3)	VARCHAR2(3) NOT NULL	Status to assign when pass screening
19	HRS_SCR_RSN_PASS	Character(3)	VARCHAR2(3) NOT NULL	Reason to assign when pass screening
20	HRS_SCR_STS_FAIL	Character(3)	VARCHAR2(3) NOT NULL	Status to assign when fail screening
21	HRS_SCR_RSN_FAIL	Character(3)	VARCHAR2(3) NOT NULL	Reason to assign when fail screening
22	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