HRS_SCR_TMPL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_SCR_TMPL_ID	Number(15,0)	DECIMAL(15) NOT NULL	Screening template 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_TTL_PT	Signed Number(5,0)	DECIMAL(4) NOT NULL	Maximum points for all of screening
6	HRS_SCR_TRANSMUTE	Character(1)	VARCHAR2(1) NOT NULL	Transmutation flag Y/N Table Edit Default Value: N
7	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
8	GVT_TIE_BREAKER	Number(1,0)	SMALLINT NOT NULL	Tie Break Number
9	GVT_VP_SCORE_LMT	Number(3,0)	SMALLINT NOT NULL	Raw Veterans Pref Score Limit
10	GVT_AUG_SCORE_LMT	Number(3,0)	SMALLINT NOT NULL	Raw Augmented Score Limit
11	GVT_RANK_COMP_CAT1	Character(1)	VARCHAR2(1) NOT NULL	Rank Candidates of Category 1 Y/N Table Edit Default Value: N
12	GVT_RANK_COMP_CAT2	Character(1)	VARCHAR2(1) NOT NULL	Rank Candidates of Category 2 Y/N Table Edit Default Value: N
13	GVT_RANK_COMP_CAT3	Character(1)	VARCHAR2(1) NOT NULL	Rank Candidates of Category 3 Y/N Table Edit Default Value: N
14	GVT_RANK_COMP_CAT4	Character(1)	VARCHAR2(1) NOT NULL	Rank Candidates of Category 4 Y/N Table Edit Default Value: N
15	GVT_CONSID_VP_COMP	Character(1)	VARCHAR2(1) NOT NULL	Veteran Preferred in Tie Break Y/N Table Edit Default Value: N
16	GVT_RANK_NCMP_CAT1	Character(1)	VARCHAR2(1) NOT NULL	Rank Candidates of Category 1 Y/N Table Edit Default Value: N
17	GVT_RANK_NCMP_CAT2	Character(1)	VARCHAR2(1) NOT NULL	Rank Candidates of Category 2 Y/N Table Edit Default Value: N
18	GVT_RANK_NCMP_CAT3	Character(1)	VARCHAR2(1) NOT NULL	Rank Candidates of Category 3 Y/N Table Edit Default Value: N
19	GVT_RANK_NCMP_CAT4	Character(1)	VARCHAR2(1) NOT NULL	Rank Candidates of Category 4 Y/N Table Edit Default Value: N
20	GVT_CONSID_VP_NCMP	Character(1)	VARCHAR2(1) NOT NULL	Veteran Preferred in Tie Break Y/N Table Edit Default Value: N
21	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
22	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
23	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
24	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id