EOCC_TRKDTL_H1(SQL Table) |
Index Back |
|---|---|
Archival RecordArchival Record for Detail 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 | OPERATOR |
Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 18 | EOCC_FLDSEQNO |
Number(31,0) | DECIMAL(31) NOT NULL | Change Tracking Sequence Number |
| 19 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 20 | EOCC_ACTION_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Action Code
A=Field Add D=Field Delete RA=Row Add RD=Row Delete U=Field Update |
| 21 | EOCC_ACTION_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Actions |
| 22 | MENUACTION | Character(1) | VARCHAR2(1) NOT NULL |
Menu Action
0=Add 1=Update 2=Update All 3=Correction |
| 23 | EOCC_CHGTRK_MODE_D | Character(30) | VARCHAR2(30) NOT NULL | Mode |
| 24 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 25 | EOCC_DATETIME | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 26 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 27 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 28 | FIELDLABEL | Character(30) | VARCHAR2(30) NOT NULL | Field Label |
| 29 | EOCC_ORIG_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Original Value |
| 30 | EOCC_CHGD_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Changed Value |
| 31 | EOCC_XLT_ORIG | Character(4) | VARCHAR2(4) NOT NULL | The Translate code before the change |
| 32 | EOCC_XLT_CHGD | Character(4) | VARCHAR2(4) NOT NULL | The Translate code before the change |
| 33 | EOCC_CHGTRK_REASON | Character(254) | VARCHAR2(254) NOT NULL | Comments/Reason |
| 34 | EOCC_KEY15_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 15 Field Name |
| 35 | EOCC_KEY15_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 15 Value |
| 36 | EOCC_CHGTRK_LBL15 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking |
| 37 | EOCC_KEY16_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 16 Field Name |
| 38 | EOCC_KEY16_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 16 Value |
| 39 | EOCC_CHGTRK_LBL16 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 40 | EOCC_KEY17_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 17 Field Name |
| 41 | EOCC_KEY17_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 17 Value |
| 42 | EOCC_CHGTRK_LBL17 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 43 | EOCC_KEY18_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 18 Field Name |
| 44 | EOCC_KEY18_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 18 Value |
| 45 | EOCC_CHGTRK_LBL18 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 46 | EOCC_KEY19_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 19 Field Name |
| 47 | EOCC_KEY19_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 19 Value |
| 48 | EOCC_CHGTRK_LBL19 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 49 | EOCC_KEY20_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 20 Field Name |
| 50 | EOCC_KEY20_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 20 Value |
| 51 | EOCC_CHGTRK_LBL20 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 52 | EOCC_KEY21_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 21 Field Name |
| 53 | EOCC_KEY21_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 21 Value |
| 54 | EOCC_CHGTRK_LBL21 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 55 | EOCC_KEY22_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 22 Field Name |
| 56 | EOCC_KEY22_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 22 Value |
| 57 | EOCC_CHGTRK_LBL22 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 58 | EOCC_KEY23_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 23 Field Name |
| 59 | EOCC_KEY23_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 23 Value |
| 60 | EOCC_CHGTRK_LBL23 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 61 | EOCC_KEY24_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 24 Field Name |
| 62 | EOCC_KEY24_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 24 Value |
| 63 | EOCC_CHGTRK_LBL24 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 64 | EOCC_KEY25_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 25 Field Name |
| 65 | EOCC_KEY25_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 25 Value |
| 66 | EOCC_CHGTRK_LBL25 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 67 | EOCC_KEY26_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 26 Field Name |
| 68 | EOCC_KEY26_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 26 Value |
| 69 | EOCC_CHGTRK_LBL26 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 70 | EOCC_KEY27_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 27 Field Name |
| 71 | EOCC_KEY27_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 27 Value |
| 72 | EOCC_CHGTRK_LBL27 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 73 | EOCC_KEY28_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 28 Field Name |
| 74 | EOCC_KEY28_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 28 Value |
| 75 | EOCC_CHGTRK_LBL28 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 76 | EOCC_KEY29_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 29 Field Name |
| 77 | EOCC_KEY29_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 29 Value |
| 78 | EOCC_CHGTRK_LBL29 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 79 | EOCC_KEY30_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 30 Field Name |
| 80 | EOCC_KEY30_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 30 Value |
| 81 | EOCC_CHGTRK_LBL30 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 82 | EOCC_KEY31_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 31 Field Name |
| 83 | EOCC_KEY31_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 31 Value |
| 84 | EOCC_CHGTRK_LBL31 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 85 | EOCC_KEY32_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 32 Field Name |
| 86 | EOCC_KEY32_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 32 Value |
| 87 | EOCC_CHGTRK_LBL32 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 88 | EOCC_KEY33_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 33 Field Name |
| 89 | EOCC_KEY33_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 33 Value |
| 90 | EOCC_CHGTRK_LBL33 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 91 | EOCC_KEY34_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 34 Field Name |
| 92 | EOCC_KEY34_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 34 Value |
| 93 | EOCC_CHGTRK_LBL34 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 94 | EOCC_KEY35_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 35 Field Name |
| 95 | EOCC_KEY35_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 35 Value |
| 96 | EOCC_CHGTRK_LBL35 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 97 | EOCC_KEY36_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 36 Field Name |
| 98 | EOCC_KEY36_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 36 Value |
| 99 | EOCC_CHGTRK_LBL36 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 100 | EOCC_KEY37_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 37 Field Name |
| 101 | EOCC_KEY37_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 37 Value |
| 102 | EOCC_CHGTRK_LBL37 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 103 | EOCC_KEY38_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 38 Field Name |
| 104 | EOCC_KEY38_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 38 Value |
| 105 | EOCC_CHGTRK_LBL38 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 106 | EOCC_KEY39_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 39 Field Name |
| 107 | EOCC_KEY39_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 39 Value |
| 108 | EOCC_CHGTRK_LBL39 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 109 | EOCC_KEY40_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 40 Field Name |
| 110 | EOCC_KEY40_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 40 Value |
| 111 | EOCC_CHGTRK_LBL40 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 112 | EOCC_KEY41_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 41 Field Name |
| 113 | EOCC_KEY41_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 41 Value |
| 114 | EOCC_CHGTRK_LBL41 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 115 | EOCC_KEY42_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 42 Field Name |
| 116 | EOCC_KEY42_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 42 Value |
| 117 | EOCC_CHGTRK_LBL42 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 118 | EOCC_KEY43_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 43 Field Name |
| 119 | EOCC_KEY43_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 43 Value |
| 120 | EOCC_CHGTRK_LBL43 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 121 | EOCC_KEY44_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 44 Field Name |
| 122 | EOCC_KEY44_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 44 Value |
| 123 | EOCC_CHGTRK_LBL44 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 124 | EOCC_KEY45_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 45 Field Name |
| 125 | EOCC_KEY45_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 45 Value |
| 126 | EOCC_CHGTRK_LBL45 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |
| 127 | EOCC_KEY46_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 46 Field Name |
| 128 | EOCC_KEY46_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 46 Value |
| 129 | EOCC_CHGTRK_LBL46 | Character(90) | VARCHAR2(90) NOT NULL | Change Tracking Label |