CA_CHG_HDR(SQL Table) |
Index Back |
|---|---|
Change HeaderDefines the change change package number and type for each contract and set of packages within the contract. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_BU_SP_NONVW |
| 2 | CHG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Change Package Identifier. This is sequenced from 1 to N for each contract. |
| 3 | CHG_CMP_DT | DateTime(26) | TIMESTAMP | Amend Completion Date |
| 4 | CHG_ORD_ID | Character(10) | VARCHAR2(10) NOT NULL | Change Order Id. |
| 5 | 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. |
| 6 | CHG_RCVD_DT | DateTime(26) | TIMESTAMP |
Change Received Date
Default Value: %datetime |
| 7 | CHG_REASON | Character(4) | VARCHAR2(4) NOT NULL |
Amendment Reason
Prompt Table: CA_CHG_RSN_TBL |
| 8 | CHG_READY_BY | Character(8) | VARCHAR2(8) NOT NULL | User Preparing Chg. Pkg. |
| 9 | CHG_READY_DT | Date(10) | DATE NOT NULL |
Process amendment on
Default Value: %DATE |
| 10 | CHG_REF1 | Character(25) | VARCHAR2(25) NOT NULL | User Ref #1 |
| 11 | CHG_REF2 | Character(25) | VARCHAR2(25) NOT NULL | User Ref #2 |
| 12 | 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 |
| 13 | 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 |
| 14 | ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered by |
| 15 | ENTERED_ON | DateTime(26) | TIMESTAMP | Entered On |
| 16 | GROSS_CHANGE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Negotiated Amount |
| 17 | GROSS_CHANGE_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Fixed Revenue Adjustment |
| 18 | REDUCT_CHANGE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Change |
| 19 | REDUCT_CHANGE_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Revenue Discounts/Surcharges |
| 20 | CONTRACT_TOTAL_BIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Contracts total billing amount |
| 21 | CONTRACT_TOTAL_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Revenue Amount |
| 22 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CA_CONTR_HDR.CURRENCY_CD |
| 23 | ALLOCATION_DONE | Character(1) | VARCHAR2(1) NOT NULL |
Allocation is complete
N=Incomplete Y=Complete Default Value: N |
| 24 | ALLOCATION_REV | Character(1) | VARCHAR2(1) NOT NULL |
Revenue Allocation is complete
N=Incomplete Y=Complete Default Value: N |
| 25 | DFR_REV_ACCT_DT | Date(10) | DATE |
Deferred Revenue Acctg Date
Default Value: %date |
| 26 | CA_PRV_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Previous Status
Y/N Table Edit Default Value: N |
| 27 | CA_AP_CREATE | Character(1) | VARCHAR2(1) NOT NULL | Create Revenue Plans |
| 28 | CA_BP_CREATE | Character(1) | VARCHAR2(1) NOT NULL | Create Billing Plans |
| 29 | CA_RNW_CREATE | Character(1) | VARCHAR2(1) NOT NULL | Create Renewal Plans |
| 30 | 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 |