HRS_JO_SCR_SUMM

#	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
2	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone Prompt Table: HRS_JOB_OPENING
3	HRS_JO_RQMT_SEQ	Number(3,0)	SMALLINT NOT NULL	Job opening requirement sequence Prompt Table: HRS_JO_RQMT
4	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: HRS_JO_RQMT
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_G_JO_WQL_SCR	Number(3,0)	SMALLINT NOT NULL	Job opening well qualified score
22	HRS_G_JO_BQL_SCR	Number(3,0)	SMALLINT NOT NULL	Job opening best qualified score
23	HRS_HOURLY	Character(1)	VARCHAR2(1) NOT NULL	Hourly Transmutation check flag Y/N Table Edit Default Value: N
24	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
25	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
26	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
27	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id