HR_LABOR_AGRMNT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_VLD_HR_14
2	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	UNION_CD	Character(3)	VARCHAR2(3) NOT NULL	Union Code
6	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2 Prompt Table: HR_BARG_U_PRMPT
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
9	CONTRACT_BEGIN_DT	Date(10)	DATE	Contract Begin Date Default Value: HR_LABOR_AGRMNT.EFFDT
10	CONTRACT_END_DT	Date(10)	DATE	Contract End Date
11	CNTRCT_RATIFY_DT	Date(10)	DATE	Contract Ratified Date
12	LBR_EXPIRY_RULE_ID	Character(11)	VARCHAR2(11) NOT NULL	Labor Recall Expiry Rule ID Prompt Table: HR_RCL_EXP_TBL
13	CARRYOVR_ACCR_TIME	Character(1)	VARCHAR2(1) NOT NULL	Wage Progression Hours Worked Y/N Table Edit Default Value: N
14	CARRYOVR_WP_STEP	Character(1)	VARCHAR2(1) NOT NULL	Step ID Y/N Table Edit Default Value: N
15	CARRYOVR_WP_STP_DT	Character(1)	VARCHAR2(1) NOT NULL	Step Entry Date Y/N Table Edit Default Value: N
16	JOBCODE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Job Codes Y/N Table Edit Default Value: N
17	SENIORITY_RULE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Seniority Rules Y/N Table Edit Default Value: N
18	FACILITY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Facilities Y/N Table Edit Default Value: N
19	COMMENTS	Long Character	CLOB	Comment