| # |
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_BU_SP_NONVW
|
| 4 |
CHG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Change Package Identifier. This is sequenced from 1 to N for each contract.
|
| 5 |
CHG_CMP_DT |
DateTime(26) |
TIMESTAMP |
Amend Completion Date
|
| 6 |
CHG_ORD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Change Order Id.
|
| 7 |
CHG_RCVD_BY |
Character(8) |
VARCHAR2(8) NOT NULL |
This is the user ID of the person who has received the changed document initially. This may or may not be the person to enter the changes or approves changes. This will be used to gather metrics.
|
| 8 |
CHG_RCVD_DT |
DateTime(26) |
TIMESTAMP |
Change Received Date
Default Value: %datetime
|
| 9 |
CHG_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Amendment Reason
Prompt Table:
CA_CHG_RSN_TBL
|
| 10 |
CHG_READY_BY |
Character(8) |
VARCHAR2(8) NOT NULL |
User Preparing Chg. Pkg.
|
| 11 |
CHG_READY_DT |
Date(10) |
DATE NOT NULL |
Process amendment on
Default Value: %DATE
|
| 12 |
CHG_REF1 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Ref #1
|
| 13 |
CHG_REF2 |
Character(25) |
VARCHAR2(25) NOT NULL |
User Ref #2
|
| 14 |
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
Default Value: P
|
| 15 |
CHG_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Change Type is the key to change management functionality. It dictates which fields will be ungrayed and available for edit. This is a key to CA_CHG_TMPL, the change template.
CTRL=Contract Activated
Prompt Table:
CA_CHG_TYPE_TBL
|
| 16 |
ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered by
|
| 17 |
ENTERED_ON |
DateTime(26) |
TIMESTAMP |
Entered On
|
| 18 |
GROSS_CHANGE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Negotiated Amount
|
| 19 |
GROSS_CHANGE_REV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Fixed Revenue Adjustment
|
| 20 |
REDUCT_CHANGE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Change
|
| 21 |
REDUCT_CHANGE_REV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Revenue Discounts/Surcharges
|
| 22 |
CONTRACT_TOTAL_BIL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Contracts total billing amount
|
| 23 |
CONTRACT_TOTAL_REV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Revenue Amount
|
| 24 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CA_CONTR_HDR.CURRENCY_CD
|
| 25 |
ALLOCATION_DONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocation is complete
N=Incomplete
Y=Complete
Default Value: N
|
| 26 |
ALLOCATION_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenue Allocation is complete
N=Incomplete
Y=Complete
Default Value: N
|
| 27 |
DFR_REV_ACCT_DT |
Date(10) |
DATE |
Deferred Revenue Acctg Date
Default Value: %date
|
| 28 |
CA_PRV_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Status
Y/N Table Edit
Default Value: N
|
| 29 |
CA_AP_CREATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Revenue Plans
|
| 30 |
CA_BP_CREATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Billing Plans
|
| 31 |
CA_RNW_CREATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Renewal Plans
|
| 32 |
BASIS_OF_ALLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Basis of Allocation
C=Current Revenue
E=Extended Revenue Price
M=Manual
N=New Lines Only
Default Value: M
|