PNLGRPNAMEMARKETEOCC_KEY1_VALEOCC_KEY2_VALEOCC_KEY3_VALEOCC_KEY4_VALEOCC_KEY5_VALEOCC_KEY6_VALEOCC_KEY7_VALEOCC_KEY8_VALEOCC_KEY9_VALEOCC_KEY10_VALEOCC_KEY11_VALEOCC_KEY12_VALEOCC_FLDSEQNOEOCC_ATT_SEQEOCC_TRK_ATT1(SQL Table) |
Index Back |
|---|---|
Change Tracking Att Record 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | 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 |
| 15 | EOCC_FLDSEQNO |
Number(31,0) | DECIMAL(31) NOT NULL | Change Tracking Sequence Number |
| 16 | EOCC_ATT_SEQ |
Character(100) | VARCHAR2(100) NOT NULL | Sequences |
| 17 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 18 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 19 | EOCC_FILE_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Description |
| 20 | EOCC_ATT_DTTM | DateTime(26) | TIMESTAMP | Date/Time Stamp |
| 21 | EOCC_ATT_OPR | Character(30) | VARCHAR2(30) NOT NULL | User |