CA_BONUS_PENLTY

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

2 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
Default Value: 0

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

4 INCENTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Incentive Status
A=Active
I=Inactive
Default Value: A

5 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.

6 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

7 CA_INCENTIVE_TYP Character(4) VARCHAR2(4) NOT NULL Incentive Type
B=Bonus
P=Penalty

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

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

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

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

12 APPROVAL_DT Date(10) DATE Date of Approval

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

14 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

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

16 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	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
2	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 0
3	INCENTIVE_ID	Character(10)	VARCHAR2(10) NOT NULL	Investment Incentive ID
4	INCENTIVE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Incentive Status A=Active I=Inactive Default Value: A
5	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
6	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
7	CA_INCENTIVE_TYP	Character(4)	VARCHAR2(4) NOT NULL	Incentive Type B=Bonus P=Penalty
8	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
9	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
10	CONTR_INCEN_STAT	Character(4)	VARCHAR2(4) NOT NULL	Contract Incentive Status
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	APPROVAL_DT	Date(10)	DATE	Date of Approval
13	APPROVAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Item Definition Approved A=Approved D=Denied P=Pending Y/N Table Edit Default Value: N
14	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
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CA_CONTR_HDR.CURRENCY_CD
16	CALCULATION_CD	Character(3)	VARCHAR2(3) NOT NULL	Calculation_cd AMT=Amount PCT=Percentage Default Value: AMT