EOCC_TRKDTL_H10(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(60) | VARCHAR2(60) 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 |