BUSINESS_UNITDefault Value: OPR_DEF_TBL_CA.BUSINESS_UNIT
Prompt Table: SP_BU_CA_NONVW
CONTRACT_NUMPrompt Table: CA_CNTR_SRCH_VW
CHG_IDCTRL=Contract Activated
Prompt Table: CA_CHG_TYPE_TBL
Prompt Table: MEMBER_VW
CA_CHG_HDR_VW(SQL View) |
Index Back |
|---|
| SELECT CONTR.BUSINESS_UNIT , CHG.CONTRACT_NUM , CHG.CHG_ID , CONVW.NAME1 , CHG.CHG_TYPE , CHG.CHG_READY_DT , CHG.CHG_READY_DT , CHG.CHG_READY_DT , CONTR.CONTRACT_ADMIN FROM PS_CA_CHG_HDR CHG , PS_CA_CONTR_HDR CONTR , PS_CUST_SLD_VW CONVW , PS_SET_CNTRL_GROUP D WHERE CHG.CONTRACT_NUM = CONTR.CONTRACT_NUM AND CONVW.CUST_ID = CONTR.SOLD_TO_CUST_ID AND D.REC_GROUP_ID = ( SELECT REC_GROUP_ID FROM PS_REC_GROUP_REC WHERE RECNAME = 'CUSTOMER') AND CONVW.SETID = D.SETID AND CONTR.BUSINESS_UNIT = D.SETCNTRLVALUE AND CONTR.CA_PROC_STATUS = 'A' AND CHG.CHG_ID <> '0000000000' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CNTR_SRCH_VW |
| 3 | CHG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Change Package Identifier. This is sequenced from 1 to N for each contract. |
| 4 | SOLD_TO_NAME | Character(40) | VARCHAR2(40) NOT NULL | Sold To Customer Name |
| 5 | 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 |
| 6 | CHG_READY_DT | Date(10) | DATE | Process amendment on |
| 7 | FROM_DATE | Date(10) | DATE | From Date |
| 8 | TO_DATE | Date(10) | DATE | To Date |
| 9 | CONTRACT_ADMIN | Character(40) | VARCHAR2(40) NOT NULL |
Contract Administrator defined on CABU.
Prompt Table: MEMBER_VW |