EOCC_TRKDTL_H6

(SQL Table)
Index Back

Archival Record

Archival 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
1=LIKE
2=NOT LIKE
3==
4=>
5=<
6=<>
7=>=
8=<=
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