AV_CAE_WRK(SQL Table) |
Index Back |
---|---|
CAE Report Work tableCAE Report Work table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | AV_CAE1 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
4 | AV_CAE10 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
5 | AV_CAE100 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
6 | AV_CAE101 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
7 | AV_CAE102 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
8 | AV_CAE103 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
9 | AV_CAE104 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
10 | AV_CAE105 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
11 | AV_CAE106 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
12 | AV_CAE107 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
13 | AV_CAE108 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
14 | AV_CAE109 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
15 | AV_CAE11 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
16 | AV_CAE110 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
17 | AV_CAE111 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
18 | AV_CAE112 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
19 | AV_CAE113 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
20 | AV_CAE114 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
21 | AV_CAE115 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
22 | AV_CAE116 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
23 | AV_CAE117 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
24 | AV_CAE118 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
25 | AV_CAE119 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
26 | AV_CAE12 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
27 | AV_CAE120 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
28 | AV_CAE121 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
29 | AV_CAE122 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
30 | AV_CAE123 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
31 | AV_CAE124 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
32 | AV_CAE125 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
33 | AV_CAE126 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
34 | AV_CAE127 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
35 | AV_CAE128 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
36 | AV_CAE129 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
37 | AV_CAE13 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
38 | AV_CAE130 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
39 | AV_CAE131 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
40 | AV_CAE132 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
41 | AV_CAE133 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
42 | AV_CAE134 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
43 | AV_CAE135 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
44 | AV_CAE136 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
45 | AV_CAE137 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
46 | AV_CAE138 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
47 | AV_CAE139 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
48 | AV_CAE14 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
49 | AV_CAE140 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
50 | AV_CAE141 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
51 | AV_CAE142 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
52 | AV_CAE143 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
53 | AV_CAE144 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
54 | AV_CAE145 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
55 | AV_CAE146 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
56 | AV_CAE147 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
57 | AV_CAE148 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
58 | AV_CAE149 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
59 | AV_CAE15 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
60 | AV_CAE150 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
61 | AV_CAE151 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
62 | AV_CAE152 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
63 | AV_CAE153 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
64 | AV_CAE154 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
65 | AV_CAE155 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
66 | AV_CAE156 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
67 | AV_CAE157 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
68 | AV_CAE158 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
69 | AV_CAE159 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
70 | AV_CAE16 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
71 | AV_CAE160 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
72 | AV_CAE161 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
73 | AV_CAE162 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
74 | AV_CAE163 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
75 | AV_CAE164 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
76 | AV_CAE165 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
77 | AV_CAE166 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
78 | AV_CAE167 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
79 | AV_CAE168 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
80 | AV_CAE169 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
81 | AV_CAE17 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
82 | AV_CAE170 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
83 | AV_CAE171 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
84 | AV_CAE172 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
85 | AV_CAE173 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
86 | AV_CAE174 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
87 | AV_CAE175 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
88 | AV_CAE176 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
89 | AV_CAE177 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
90 | AV_CAE178 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
91 | AV_CAE179 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
92 | AV_CAE18 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
93 | AV_CAE180 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
94 | AV_CAE181 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
95 | AV_CAE182 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
96 | AV_CAE183 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
97 | AV_CAE184 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
98 | AV_CAE185 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
99 | AV_CAE186 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
100 | AV_CAE187 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
101 | AV_CAE188 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
102 | AV_CAE189 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
103 | AV_CAE19 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
104 | AV_CAE190 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
105 | AV_CAE191 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
106 | AV_CAE192 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
107 | AV_CAE193 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
108 | AV_CAE194 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
109 | AV_CAE195 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
110 | AV_CAE196 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
111 | AV_CAE197 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
112 | AV_CAE198 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
113 | AV_CAE199 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
114 | AV_CAE2 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
115 | AV_CAE20 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
116 | AV_CAE200 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
117 | AV_CAE201 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
118 | AV_CAE202 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
119 | AV_CAE203 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
120 | AV_CAE204 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
121 | AV_CAE205 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
122 | AV_CAE206 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
123 | AV_CAE207 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
124 | AV_CAE208 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
125 | AV_CAE209 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
126 | AV_CAE21 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
127 | AV_CAE210 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
128 | AV_CAE22 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
129 | AV_CAE23 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
130 | AV_CAE24 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
131 | AV_CAE25 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
132 | AV_CAE26 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
133 | AV_CAE27 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
134 | AV_CAE28 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
135 | AV_CAE29 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
136 | AV_CAE3 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
137 | AV_CAE30 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
138 | AV_CAE31 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
139 | AV_CAE32 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
140 | AV_CAE33 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
141 | AV_CAE34 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
142 | AV_CAE35 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
143 | AV_CAE36 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
144 | AV_CAE37 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
145 | AV_CAE38 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
146 | AV_CAE39 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
147 | AV_CAE4 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
148 | AV_CAE40 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
149 | AV_CAE41 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
150 | AV_CAE42 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
151 | AV_CAE43 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
152 | AV_CAE44 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
153 | AV_CAE45 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
154 | AV_CAE46 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
155 | AV_CAE47 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
156 | AV_CAE48 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
157 | AV_CAE49 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
158 | AV_CAE5 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
159 | AV_CAE50 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
160 | AV_CAE51 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
161 | AV_CAE52 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
162 | AV_CAE53 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
163 | AV_CAE54 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
164 | AV_CAE55 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
165 | AV_CAE56 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
166 | AV_CAE57 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
167 | AV_CAE58 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
168 | AV_CAE59 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
169 | AV_CAE6 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
170 | AV_CAE60 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
171 | AV_CAE61 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
172 | AV_CAE62 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
173 | AV_CAE63 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
174 | AV_CAE64 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
175 | AV_CAE65 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
176 | AV_CAE66 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
177 | AV_CAE67 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
178 | AV_CAE68 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
179 | AV_CAE69 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
180 | AV_CAE7 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
181 | AV_CAE70 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
182 | AV_CAE71 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
183 | AV_CAE72 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
184 | AV_CAE73 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
185 | AV_CAE74 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
186 | AV_CAE75 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
187 | AV_CAE76 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
188 | AV_CAE77 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
189 | AV_CAE78 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
190 | AV_CAE79 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
191 | AV_CAE8 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
192 | AV_CAE80 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
193 | AV_CAE81 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
194 | AV_CAE82 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
195 | AV_CAE83 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
196 | AV_CAE84 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
197 | AV_CAE85 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
198 | AV_CAE86 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
199 | AV_CAE87 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
200 | AV_CAE88 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
201 | AV_CAE89 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
202 | AV_CAE9 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
203 | AV_CAE90 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
204 | AV_CAE91 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
205 | AV_CAE92 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
206 | AV_CAE93 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
207 | AV_CAE94 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
208 | AV_CAE95 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
209 | AV_CAE96 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
210 | AV_CAE97 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
211 | AV_CAE98 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |
212 | AV_CAE99 | Number(15,2) | DECIMAL(14,2) NOT NULL | CAE Data Field |