CA_EARLY_OPTI_H

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
4	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	EARLY_OUT_CD	Character(4)	VARCHAR2(4) NOT NULL	Early Out Option Code Prompt Table: CA_EARLYOUT_TBL
6	EARLY_OUT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Early Out Status A=Active I=Inactive Default Value: A
7	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
8	CHG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Change Status indicates if this change package is open for further edit: pending, ready for processing by the app. engine component of contract change management (ready) or complete, meaning that no further edit is possible and all changes have been aplied. C=Complete P=Pending R=Ready X=Cancelled
9	START_DT	Date(10)	DATE	Start Date
10	END_DT	Date(10)	DATE	End Date
11	PENALTY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Penalty Applicable Y/N Table Edit
12	PENALTY_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Penalty Amount
13	PENALTY_NOTIFY_DT	Number(3,0)	SMALLINT NOT NULL	Notification Days
14	PENALTY_PCNT	Number(3,0)	SMALLINT NOT NULL	Penalty Percent
15	PENALTY_TYP	Character(1)	VARCHAR2(1) NOT NULL	Penalty type A=Amount P=Percent
16	EARLY_OUT_REAS	Character(4)	VARCHAR2(4) NOT NULL	Early Out Reason Code