CA_BONUS_PENL_H

(SQL Table)

# 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
Default Value: 0

5 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

6 INCENTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Incentive 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 CA_INCENTIVE_TYP Character(4) VARCHAR2(4) NOT NULL Incentive Type
B=Bonus
P=Penalty

10 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

11 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage

12 CONTR_INCEN_STAT Character(4) VARCHAR2(4) NOT NULL Contract Incentive Status

13 DESCR Character(30) VARCHAR2(30) NOT NULL Description

14 APPROVAL_DT Date(10) DATE Date of Approval

15 APPROVAL_FLAG Character(1) VARCHAR2(1) NOT NULL Item Definition Approved
A=Approved
D=Denied
P=Pending
Y/N Table Edit
Default Value: N

16 APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved
D=Denied
E=Sent Back for Revision
H=On Hold
I=Initial
M=Resubmitted
P=In Process
R=Rerouted
S=Submitted

17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: CA_CONTR_HDR.CURRENCY_CD

18 CALCULATION_CD Character(3) VARCHAR2(3) NOT NULL Calculation_cd
AMT=Amount
PCT=Percentage
Default Value: AMT

#	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 Default Value: 0
5	INCENTIVE_ID	Character(10)	VARCHAR2(10) NOT NULL	Investment Incentive ID
6	INCENTIVE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Incentive 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	CA_INCENTIVE_TYP	Character(4)	VARCHAR2(4) NOT NULL	Incentive Type B=Bonus P=Penalty
10	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
11	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
12	CONTR_INCEN_STAT	Character(4)	VARCHAR2(4) NOT NULL	Contract Incentive Status
13	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
14	APPROVAL_DT	Date(10)	DATE	Date of Approval
15	APPROVAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Item Definition Approved A=Approved D=Denied P=Pending Y/N Table Edit Default Value: N
16	APPROVAL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval Status A=Approved D=Denied E=Sent Back for Revision H=On Hold I=Initial M=Resubmitted P=In Process R=Rerouted S=Submitted
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CA_CONTR_HDR.CURRENCY_CD
18	CALCULATION_CD	Character(3)	VARCHAR2(3) NOT NULL	Calculation_cd AMT=Amount PCT=Percentage Default Value: AMT