PNLGRPNAMEEOCC_MARKETEOCC_KEY1_VALEOCC_KEY2_VALEOCC_KEY3_VALEOCC_KEY4_VALEOCC_KEY5_VALEOCC_KEY6_VALEOCC_KEY7_VALEOCC_KEY8_VALEOCC_KEY9_VALEOCC_KEY10_VALEOCC_KEY11_VALEOCC_KEY12_VALEOCC_CHGTRK_SVW(SQL View) |
Index Back |
|---|---|
Change TrackingSearch View for change tracking (classic) |
| SELECT PNLGRPNAME ,MARKET ,EOCC_KEY1_VAL ,EOCC_KEY2_VAL ,EOCC_KEY3_VAL ,EOCC_KEY4_VAL ,EOCC_KEY5_VAL ,EOCC_KEY6_VAL ,EOCC_KEY7_VAL ,EOCC_KEY8_VAL ,EOCC_KEY9_VAL ,EOCC_KEY10_VAL ,EOCC_KEY11_VAL ,EOCC_KEY12_VAL FROM PS_EOCC_CHGTRK_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | EOCC_MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | EOCC_KEY1_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 1 Value |
| 4 | EOCC_KEY2_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 2 Value |
| 5 | EOCC_KEY3_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 3 Value |
| 6 | EOCC_KEY4_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 4 Value |
| 7 | EOCC_KEY5_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 5 Value |
| 8 | EOCC_KEY6_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 6 Value |
| 9 | EOCC_KEY7_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 7 Value |
| 10 | EOCC_KEY8_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 8 Value |
| 11 | EOCC_KEY9_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 9 Value |
| 12 | EOCC_KEY10_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 10 Value |
| 13 | EOCC_KEY11_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 11 Value |
| 14 | EOCC_KEY12_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 12 Value |