SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
CHG_TYPECTRL=Contract Activated
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
UPG_CA_CHG_TYPE(SQL Table) |
Index Back |
|---|---|
Upgrade: Amendment TypesUsed in UPG_CAG01, section CAK01_CH, as a working table. This section is used to upgrade from 8.0x and 8.4x paths. This is not a record that requires customer activities in the prep phase of the upgrade (Chapter 1 doc). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | 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 |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | DESCR20_MIXED | Character(20) | VARCHAR2(20) NOT NULL | Description 20 characters, mixed case |