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 |