V100_TEMP_TBL

(SQL Table)
 Index Back

Vets 100 Temp Table

Used for storing temporary values before writing to disk.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CTL_ESTABID Character(12) VARCHAR2(12) NOT NULL Controlling Establishment ID
2 V100_REPORT_TYPE Character(1) VARCHAR2(1) NOT NULL VETS-100 Report Type
A=VETS-100A
B=VETS-100
C=VETS-4212

Default Value: B

3 V100_ROW Number(5,0) INTEGER NOT NULL Vets 100 Row Number
4 V100_COMPANY_NO Character(20) VARCHAR2(20) NOT NULL Vets 100 Company Number
5 V100_ENDING_PD Character(10) VARCHAR2(10) NOT NULL Vets 100 Ending Period
6 V100_ORG_TYPE Character(1) VARCHAR2(1) NOT NULL Vets 100 Organization Type
7 V100_FORM_TYPE Character(3) VARCHAR2(3) NOT NULL Vets 100 Form Type
8 V100_MSCNUMBER Number(8,0) INTEGER NOT NULL Vets 100 MSC Number
9 V100_PARENT_CO Character(40) VARCHAR2(40) NOT NULL Vets 100 Parent Company
10 V100_STREET Character(55) VARCHAR2(55) NOT NULL Vets 100 Street Address
11 V100_STREET2 Character(55) VARCHAR2(55) NOT NULL Vets 100 Street Address2
12 V100_CITY Character(20) VARCHAR2(20) NOT NULL Vets 100 City
13 V100_COUNTY Character(20) VARCHAR2(20) NOT NULL Vets 100 County
14 V100_STATE Character(2) VARCHAR2(2) NOT NULL Vets 100 State
15 V100_ZIPCODE Character(10) VARCHAR2(10) NOT NULL Vets 100 Zip Code
16 V100_HIRING_LOC Character(20) VARCHAR2(20) NOT NULL Vets 100 Hiring Location
17 V100_HL_NAME Character(40) VARCHAR2(40) NOT NULL Vets 100 Hiring Location Name
18 V100_HL_STREET Character(40) VARCHAR2(40) NOT NULL Vets 100 Hiring Location Stree
19 V100_HL_STREET2 Character(40) VARCHAR2(40) NOT NULL Vets 100 Hiring Location St2
20 V100_HL_CITY Character(20) VARCHAR2(20) NOT NULL Vets 100 Hiring Location City
21 V100_HL_COUNTY Character(20) VARCHAR2(20) NOT NULL Vets 100 Hiring Location Count
22 V100_HL_STATE Character(2) VARCHAR2(2) NOT NULL Vets 100 Hiring Location State
23 V100_HL_ZIP Character(10) VARCHAR2(10) NOT NULL Vets 100 Hiring Location Zip
24 V100_SIC Character(10) VARCHAR2(10) NOT NULL Vets 100 SIC
25 V100_NAICS Character(10) VARCHAR2(10) NOT NULL Vets 100 NAICS
26 V100_DUNS_NUM Character(20) VARCHAR2(20) NOT NULL Vets 100 DUNS Number
27 V100_EIN Character(20) VARCHAR2(20) NOT NULL Vets 100 EIN
28 V100_A1 Number(8,0) INTEGER NOT NULL Vets 100
29 V100_A2 Number(8,0) INTEGER NOT NULL Vets 100
30 V100_A3 Number(8,0) INTEGER NOT NULL Vets 100
31 V100_A4 Number(8,0) INTEGER NOT NULL Vets 100
32 V100_A5 Number(8,0) INTEGER NOT NULL Vets 100
33 V100_A6 Number(8,0) INTEGER NOT NULL Vets 100
34 V100_A7 Number(8,0) INTEGER NOT NULL Vets 100
35 V100_A8 Number(8,0) INTEGER NOT NULL Vets 100
36 V100_A9 Number(8,0) INTEGER NOT NULL Vets 100
37 V100_A10 Number(8,0) INTEGER NOT NULL Vets 100
38 V100_A11 Number(8,0) INTEGER NOT NULL Vets 100
39 V100_B1 Number(8,0) INTEGER NOT NULL Vets 100
40 V100_B2 Number(8,0) INTEGER NOT NULL Vets 100
41 V100_B3 Number(8,0) INTEGER NOT NULL Vets 100
42 V100_B4 Number(8,0) INTEGER NOT NULL Vets 100
43 V100_B5 Number(8,0) INTEGER NOT NULL Vets 100
44 V100_B6 Number(8,0) INTEGER NOT NULL Vets 100
45 V100_B7 Number(8,0) INTEGER NOT NULL Vets 100
46 V100_B8 Number(8,0) INTEGER NOT NULL Vets 100
47 V100_B9 Number(8,0) INTEGER NOT NULL Vets 100
48 V100_B10 Number(8,0) INTEGER NOT NULL Vets 100
49 V100_B11 Number(8,0) INTEGER NOT NULL Vets 100
50 V100_C1 Number(8,0) INTEGER NOT NULL Vets 100
51 V100_C2 Number(8,0) INTEGER NOT NULL Vets 100
52 V100_C3 Number(8,0) INTEGER NOT NULL Vets 100
53 V100_C4 Number(8,0) INTEGER NOT NULL Vets 100
54 V100_C5 Number(8,0) INTEGER NOT NULL Vets 100
55 V100_C6 Number(8,0) INTEGER NOT NULL Vets 100
56 V100_C7 Number(8,0) INTEGER NOT NULL Vets 100
57 V100_C8 Number(8,0) INTEGER NOT NULL Vets 100
58 V100_C9 Number(8,0) INTEGER NOT NULL Vets 100
59 V100_C10 Number(8,0) INTEGER NOT NULL Vets 100
60 V100_C11 Number(8,0) INTEGER NOT NULL Vets 100
61 V100_D1 Number(8,0) INTEGER NOT NULL Vets 100
62 V100_D2 Number(8,0) INTEGER NOT NULL Vets 100
63 V100_D3 Number(8,0) INTEGER NOT NULL Vets 100
64 V100_D4 Number(8,0) INTEGER NOT NULL Vets 100
65 V100_D5 Number(8,0) INTEGER NOT NULL Vets 100
66 V100_D6 Number(8,0) INTEGER NOT NULL Vets 100
67 V100_D7 Number(8,0) INTEGER NOT NULL Vets 100
68 V100_D8 Number(8,0) INTEGER NOT NULL Vets 100
69 V100_D9 Number(8,0) INTEGER NOT NULL Vets 100
70 V100_D10 Number(8,0) INTEGER NOT NULL Vets 100
71 V100_D11 Number(8,0) INTEGER NOT NULL Vets 100
72 V100_L1 Number(8,0) INTEGER NOT NULL Vets 100
73 V100_M1 Number(8,0) INTEGER NOT NULL Vets 100
74 V100_N1 Number(8,0) INTEGER NOT NULL Vets 100
75 V100_O1 Number(8,0) INTEGER NOT NULL Vets 100
76 V100_P1 Number(8,0) INTEGER NOT NULL Vets 100
77 V100_Q1 Number(8,0) INTEGER NOT NULL Vets 100
78 V100_R1 Number(8,0) INTEGER NOT NULL Vets 100
79 V100_S1 Number(8,0) INTEGER NOT NULL Vets 100
80 V100_T1 Number(8,0) INTEGER NOT NULL Vets 100
81 V100_U1 Number(8,0) INTEGER NOT NULL Vets 100
82 V100_L2 Number(8,0) INTEGER NOT NULL Vets 100
83 V100_M2 Number(8,0) INTEGER NOT NULL Vets 100
84 V100_N2 Number(8,0) INTEGER NOT NULL Vets 100
85 V100_O2 Number(8,0) INTEGER NOT NULL Vets 100
86 V100_P2 Number(8,0) INTEGER NOT NULL Vets 100
87 V100_Q2 Number(8,0) INTEGER NOT NULL Vets 100
88 V100_R2 Number(8,0) INTEGER NOT NULL Vets 100
89 V100_S2 Number(8,0) INTEGER NOT NULL Vets 100
90 V100_T2 Number(8,0) INTEGER NOT NULL Vets 100
91 V100_U2 Number(8,0) INTEGER NOT NULL Vets 100
92 V100_L3 Number(8,0) INTEGER NOT NULL Vets 100
93 V100_M3 Number(8,0) INTEGER NOT NULL Vets 100
94 V100_N3 Number(8,0) INTEGER NOT NULL Vets 100
95 V100_O3 Number(8,0) INTEGER NOT NULL Vets 100
96 V100_P3 Number(8,0) INTEGER NOT NULL Vets 100
97 V100_Q3 Number(8,0) INTEGER NOT NULL Vets 100
98 V100_R3 Number(8,0) INTEGER NOT NULL Vets 100
99 V100_S3 Number(8,0) INTEGER NOT NULL Vets 100
100 V100_T3 Number(8,0) INTEGER NOT NULL Vets 100
101 V100_U3 Number(8,0) INTEGER NOT NULL Vets 100
102 V100_L4 Number(8,0) INTEGER NOT NULL Vets 100
103 V100_M4 Number(8,0) INTEGER NOT NULL Vets 100
104 V100_N4 Number(8,0) INTEGER NOT NULL Vets 100
105 V100_O4 Number(8,0) INTEGER NOT NULL Vets 100
106 V100_P4 Number(8,0) INTEGER NOT NULL Vets 100
107 V100_Q4 Number(8,0) INTEGER NOT NULL Vets 100
108 V100_R4 Number(8,0) INTEGER NOT NULL Vets 100
109 V100_S4 Number(8,0) INTEGER NOT NULL Vets 100
110 V100_T4 Number(8,0) INTEGER NOT NULL Vets 100
111 V100_U4 Number(8,0) INTEGER NOT NULL Vets 100
112 V100_L5 Number(8,0) INTEGER NOT NULL Vets 100
113 V100_M5 Number(8,0) INTEGER NOT NULL Vets 100
114 V100_N5 Number(8,0) INTEGER NOT NULL Vets 100
115 V100_O5 Number(8,0) INTEGER NOT NULL Vets 100
116 V100_P5 Number(8,0) INTEGER NOT NULL Vets 100
117 V100_Q5 Number(8,0) INTEGER NOT NULL Vets 100
118 V100_R5 Number(8,0) INTEGER NOT NULL Vets 100
119 V100_S5 Number(8,0) INTEGER NOT NULL Vets 100
120 V100_T5 Number(8,0) INTEGER NOT NULL Vets 100
121 V100_U5 Number(8,0) INTEGER NOT NULL Vets 100
122 V100_L6 Number(8,0) INTEGER NOT NULL Vets 100
123 V100_M6 Number(8,0) INTEGER NOT NULL Vets 100
124 V100_N6 Number(8,0) INTEGER NOT NULL Vets 100
125 V100_O6 Number(8,0) INTEGER NOT NULL Vets 100
126 V100_P6 Number(8,0) INTEGER NOT NULL Vets 100
127 V100_Q6 Number(8,0) INTEGER NOT NULL Vets 100
128 V100_R6 Number(8,0) INTEGER NOT NULL Vets 100
129 V100_S6 Number(8,0) INTEGER NOT NULL Vets 100
130 V100_T6 Number(8,0) INTEGER NOT NULL Vets 100
131 V100_U6 Number(8,0) INTEGER NOT NULL Vets 100
132 V100_L7 Number(8,0) INTEGER NOT NULL Vets 100
133 V100_M7 Number(8,0) INTEGER NOT NULL Vets 100
134 V100_N7 Number(8,0) INTEGER NOT NULL Vets 100
135 V100_O7 Number(8,0) INTEGER NOT NULL Vets 100
136 V100_P7 Number(8,0) INTEGER NOT NULL Vets 100
137 V100_Q7 Number(8,0) INTEGER NOT NULL Vets 100
138 V100_R7 Number(8,0) INTEGER NOT NULL Vets 100
139 V100_S7 Number(8,0) INTEGER NOT NULL Vets 100
140 V100_T7 Number(8,0) INTEGER NOT NULL Vets 100
141 V100_U7 Number(8,0) INTEGER NOT NULL Vets 100
142 V100_L8 Number(8,0) INTEGER NOT NULL Vets 100
143 V100_M8 Number(8,0) INTEGER NOT NULL Vets 100
144 V100_N8 Number(8,0) INTEGER NOT NULL Vets 100
145 V100_O8 Number(8,0) INTEGER NOT NULL Vets 100
146 V100_P8 Number(8,0) INTEGER NOT NULL Vets 100
147 V100_Q8 Number(8,0) INTEGER NOT NULL Vets 100
148 V100_R8 Number(8,0) INTEGER NOT NULL Vets 100
149 V100_S8 Number(8,0) INTEGER NOT NULL Vets 100
150 V100_T8 Number(8,0) INTEGER NOT NULL Vets 100
151 V100_U8 Number(8,0) INTEGER NOT NULL Vets 100
152 V100_L9 Number(8,0) INTEGER NOT NULL Vets 100
153 V100_M9 Number(8,0) INTEGER NOT NULL Vets 100
154 V100_N9 Number(8,0) INTEGER NOT NULL Vets 100
155 V100_O9 Number(8,0) INTEGER NOT NULL Vets 100
156 V100_P9 Number(8,0) INTEGER NOT NULL Vets 100
157 V100_Q9 Number(8,0) INTEGER NOT NULL Vets 100
158 V100_R9 Number(8,0) INTEGER NOT NULL Vets 100
159 V100_S9 Number(8,0) INTEGER NOT NULL Vets 100
160 V100_T9 Number(8,0) INTEGER NOT NULL Vets 100
161 V100_U9 Number(8,0) INTEGER NOT NULL Vets 100
162 V100_L10 Number(8,0) INTEGER NOT NULL Vets 100
163 V100_M10 Number(8,0) INTEGER NOT NULL Vets 100
164 V100_N10 Number(8,0) INTEGER NOT NULL Vets 100
165 V100_O10 Number(8,0) INTEGER NOT NULL Vets 100
166 V100_P10 Number(8,0) INTEGER NOT NULL Vets 100
167 V100_Q10 Number(8,0) INTEGER NOT NULL Vets 100
168 V100_R10 Number(8,0) INTEGER NOT NULL Vets 100
169 V100_S10 Number(8,0) INTEGER NOT NULL Vets 100
170 V100_T10 Number(8,0) INTEGER NOT NULL Vets 100
171 V100_U10 Number(8,0) INTEGER NOT NULL Vets 100
172 V100_L11 Number(8,0) INTEGER NOT NULL Vets 100
173 V100_M11 Number(8,0) INTEGER NOT NULL Vets 100
174 V100_N11 Number(8,0) INTEGER NOT NULL Vets 100
175 V100_O11 Number(8,0) INTEGER NOT NULL Vets 100
176 V100_P11 Number(8,0) INTEGER NOT NULL Vets 100
177 V100_Q11 Number(8,0) INTEGER NOT NULL Vets 100
178 V100_R11 Number(8,0) INTEGER NOT NULL Vets 100
179 V100_S11 Number(8,0) INTEGER NOT NULL Vets 100
180 V100_T11 Number(8,0) INTEGER NOT NULL Vets 100
181 V100_U11 Number(8,0) INTEGER NOT NULL Vets 100
182 V100_MAX_NUMBER Number(8,0) INTEGER NOT NULL Vets 100
183 V100_MIN_NUMBER Number(8,0) INTEGER NOT NULL Vets 100