EOCC_TRK_DTL1

(SQL Table)
Index Back

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