CNT_TYP_FRA_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number Default Value: 1
5	CDD_CNTRCT_RSN_FRA	Character(4)	VARCHAR2(4) NOT NULL	CDD Contract reason DUSG=Employment Use TEMP=Temporary Increase
6	SOC_POLICY_MSR_FRA	Character(3)	VARCHAR2(3) NOT NULL	Social Policy Measure 21=21 40=40 40=40 41=41 42=42 50=50 51=51 61=61 64=64 65=65 70=70 71=71 80=80 81=81 92=92 93=93 94=94 99=99
7	AGREEMENT_DATE_FRA	Date(10)	DATE	Date of Agreement
8	RSN_CTRCT_BRCH_FRA	Character(10)	VARCHAR2(10) NOT NULL	Reason for breach of contract Prompt Table: BRCH_CNTRCT_FRA
9	CTRCT_BRCH_DT_FRA	Date(10)	DATE	Contract breach notification date
10	TER_SIGN_DT_FRA	Date(10)	DATE	Terminatgion Agreement Sign Date
11	DISMISS_PRC_DT_FRA	Date(10)	DATE	Dismissal Procedure Date
12	PRT_FUND_CTRCT_FRA	Character(10)	VARCHAR2(10) NOT NULL	Portability Fund Contract Prompt Table: FUND_CNTRCT_FRA
13	NOTICE_MONTHS_FRA	Number(4,0)	SMALLINT NOT NULL	Months of Notice
14	EMPL_SPCL_STS_FRA	Character(10)	VARCHAR2(10) NOT NULL	Employee Special Status Prompt Table: EMP_SPL_STS_FRA
15	NOTICE_END_PAY_FRA	Character(10)	VARCHAR2(10) NOT NULL	Notice's Completion & Payment Prompt Table: NTY_END_PAY_FRA
16	NOTICE_BGN_DT_FRA	Date(10)	DATE	Notice's Completion Begin Date
17	NOTICE_END_DT_FRA	Date(10)	DATE	Notice's Completion End Date
18	COLL_CONTR_AFFLTN	Character(10)	VARCHAR2(10) NOT NULL	Continuation of the Employee's Affiliation to the Collective Contract Prompt Table: FUND_CNTRCT_FRA
19	DECLR_CONTRACT_END	Character(10)	VARCHAR2(10) NOT NULL	Declaration of End of Contract Prompt Table: DCL_CTR_END_FRA
20	NOTICE_MNTH_PC_FRA	Number(5,0)	INTEGER NOT NULL	Months of Notice (PAP CALC)
21	RFUSE_ULMT_CNT_FRA	Character(10)	VARCHAR2(10) NOT NULL	Refuse unlimited contract flag Prompt Table: RFUSE_U_CNT_FRA