CA_LMT_FEE_DT_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 Prompt Table: CA_CNTR_SRCH_VW
4	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
5	AWARDED_BASE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Awarded Base/Cost/T&M Amount
6	AWARDED_FEE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Awarded Fee Amount
7	LIMIT_AMT_BIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded/Billing Limit Amount
8	LIMIT_AMT_REV	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Limit Amount
9	LIMIT_FEE_BIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded / Billing Fee Limit Amount
10	FEE_PCT_BIL	Number(12,8)	DECIMAL(11,8) NOT NULL	Billing Fee Percent
11	FEE_OPT_AAWD	Character(1)	VARCHAR2(1) NOT NULL	Additional Award Option A=Amount P=Percent Default Value: P
12	FEE_PCT_AAWD	Number(12,8)	DECIMAL(11,8) NOT NULL	Additional Award Percent
13	FEE_AMT_AAWD_BIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Additional Funded /Billing Award Amount
14	FEE_PCT_CST_U_INC	Number(12,8)	DECIMAL(11,8) NOT NULL	Cost Percent Underrun
15	FEE_PCT_CST_O_INC	Number(12,8)	DECIMAL(11,8) NOT NULL	Cost Share Percent Overrun
16	FEE_PCT_TARGET_INC	Number(12,8)	DECIMAL(11,8) NOT NULL	Target Fee Percent
17	FEE_PCT_MIN_INC	Number(12,8)	DECIMAL(11,8) NOT NULL	Minimum Fee Percent
18	FEE_PCT_MAX_INC	Number(12,8)	DECIMAL(11,8) NOT NULL	Maximum Fee Percent
19	FEE_AMT_OTH_BIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Other Billing Fee Amount
20	LMT_PROC_AMT_B	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded / Billing Processed Amount
21	LMT_PROC_AMT_R	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Processed Amount
22	LMT_EXCESS_AMT_B	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded / Billing Excess Amount
23	LMT_EXCESS_AMT_R	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Excess Amount
24	LMT_LAST_PROC_DT_B	Date(10)	DATE	Last Funded / Billing Processed Date
25	LMT_LAST_PROC_DT_R	Date(10)	DATE	Last Revenue Processed Date
26	LMT_LAST_TXN_DT_B	Date(10)	DATE	Last Funded / Billing Transaction Date
27	LMT_LAST_TXN_DT_R	Date(10)	DATE	Last Revenue Transaction Date
28	LIMIT_RCHD_DT_BIL	Date(10)	DATE	Date Funded / Billing Limit Reached Date
29	LIMIT_RCHD_DT_REV	Date(10)	DATE	Date Revenue Limit Reached
30	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CA_DETAIL.CURRENCY_CD
31	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
32	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