PSARCH_IDPSARCH_BATCHNUMPNLGRPNAMEMARKETEOCC_KEY1_VALEOCC_KEY2_VALEOCC_KEY3_VALEOCC_KEY4_VALEOCC_KEY5_VALEOCC_KEY6_VALEOCC_KEY7_VALEOCC_KEY8_VALEOCC_KEY9_VALEOCC_KEY10_VALEOCC_KEY11_VALEOCC_KEY12_VALEOCC_TRKHDR_H7(SQL Table) |
Index Back |
|---|---|
Archival RecordArchival Record for Header Log Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 4 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 5 | EOCC_KEY1_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 1 Value |
| 6 | EOCC_KEY2_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 2 Value |
| 7 | EOCC_KEY3_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 3 Value |
| 8 | EOCC_KEY4_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 4 Value |
| 9 | EOCC_KEY5_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 5 Value |
| 10 | EOCC_KEY6_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 6 Value |
| 11 | EOCC_KEY7_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 7 Value |
| 12 | EOCC_KEY8_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 8 Value |
| 13 | EOCC_KEY9_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 9 Value |
| 14 | EOCC_KEY10_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 10 Value |
| 15 | EOCC_KEY11_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 11 Value |
| 16 | EOCC_KEY12_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 12 Value |
| 17 | EOCC_KEY1_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 1 Field Name |
| 18 | EOCC_KEY2_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 2 Field Name |
| 19 | EOCC_KEY3_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 3 Field Name |
| 20 | EOCC_KEY4_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 4 Field Name |
| 21 | EOCC_KEY5_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 5 Field Name |
| 22 | EOCC_KEY6_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 6 Field Name |
| 23 | EOCC_KEY7_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 7 Field Name |
| 24 | EOCC_KEY8_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 8 Field Name |
| 25 | EOCC_KEY9_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 9 Field Name |
| 26 | EOCC_KEY10_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 10 Field Name |
| 27 | EOCC_KEY11_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 11 Field Name |
| 28 | EOCC_KEY12_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 12 Field Name |
| 29 | EOCC_CHGTRK_LBL1 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |
| 30 | EOCC_CHGTRK_LBL2 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |
| 31 | EOCC_CHGTRK_LBL3 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |
| 32 | EOCC_CHGTRK_LBL4 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |
| 33 | EOCC_CHGTRK_LBL5 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |
| 34 | EOCC_CHGTRK_LBL6 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |
| 35 | EOCC_CHGTRK_LBL7 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |
| 36 | EOCC_CHGTRK_LBL8 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |
| 37 | EOCC_CHGTRK_LBL9 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |
| 38 | EOCC_CHGTRK_LBL10 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |
| 39 | EOCC_CHGTRK_LBL11 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |
| 40 | EOCC_CHGTRK_LBL12 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |