CONTRACT_NUMPrompt Table: CA_BU_SP_NONVW
CHG_IDPrompt Table: CA_CHG_RSN_TBL
CTRL=Contract Activated
GM_PT_CA_CHG_VW(SQL View) |
Index Back |
|---|---|
Change HeaderDefines the change change package number and type for each contract and set of packages within the contract. |
| SELECT B.BUSINESS_UNIT , A.CONTRACT_NUM , A.CHG_ID , A.CHG_CMP_DT , A.CHG_REASON , A.CHG_TYPE , A.CHG_REF1 FROM PS_CA_CHG_HDR A , PS_CA_CONTR_HDR B WHERE A.CHG_STATUS = 'C' AND B.CONTRACT_NUM = A.CONTRACT_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_BU_SP_NONVW |
| 3 | CHG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Change Package Identifier. This is sequenced from 1 to N for each contract. |
| 4 | CHG_CMP_DT | DateTime(26) | TIMESTAMP | Amend Completion Date |
| 5 | CHG_REASON | Character(4) | VARCHAR2(4) NOT NULL |
Amendment Reason
Prompt Table: CA_CHG_RSN_TBL |
| 6 | 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 |
| 7 | CHG_REF1 | Character(25) | VARCHAR2(25) NOT NULL | User Ref #1 |