|
|
|
|
|
TMGT Download Tables Record Layout
The tables below include the record layout for tables that Agencies can download from TMGT.
- TMGT Table 001, Personnel Office Identifier Name and Address
- TMGT Table 002, Accounting Station Name and Address
- TMGT Table 005, Agency Organizational Structure
- TMGT Table 010, Union and Association Code Address
- TMGT Table 016, Geographical Location Codes with Names
- TMGT Table 018, Occupational Series Alpha Description
- TMGT Table 019, Functional Classification Description
- TMGT Table 025, AD-350 (Personnel Block and Description)
- TMGT Table 029, Pay Table Rates
- TMGT Table 036, School Identification
- TMGT Table 052, Remarks Codes and Descriptions
- TMGT Table 055, Minimum and Maximum Salaries
- TMGT Table 061, Nature of Action Conversion
- TMGT Table 062, 3 Digit Nature of Action
- TMGT Table 074, Official Position Title
- TMGT Table 076, Working Position Title
- TMGT Table 087, Travel Per Diem Rates
- TMGT Table 091, OPM NOA Legal Authorities
- TMGT Table 100, PACT Data Element Description
- TMGT Table 101, PACT Screen Elements
- TMGT Table 102, Pay/Pers Download Table Profile Screen
- TMGT Table 103, TMGT Download Table (1)
TMGT Table 001, Employing Office Name and Address, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Agency Code Personnel Office Identifier (POI) Filler (spaces) Record Type |
X(30) 9(03) X(02) 9(04) X(20) X(01) |
1 1 4 6 10 30 |
30 3 5 9 29 30 |
30 3 2 4 20 1 |
Table Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (Hours/Minutes[HHMM]) |
X(04) |
47 |
50 |
4 |
City Name |
X(20) |
51 |
70 |
20 |
State Abbreviation |
X(02) |
71 |
72 |
2 |
Zip Code Zip Code 5 Zip Code 4 |
X(09) X(05) X(04) |
73 73 78 |
81 77 81 |
9 5 4 |
POI |
9(04) |
82 |
85 |
4 |
Servicing Agency |
X(02) |
86 |
87 |
2 |
Central Personnel Office (CPO) Flag |
X(01) |
88 |
88 |
1 |
Name Address Line 1 |
X(35) |
89 |
123 |
35 |
Name Address Line 2 |
X(35) |
124 |
158 |
35 |
Name Address Line 3 |
X(35) |
159 |
193 |
35 |
Name Address Line 4 |
X(35) |
194 |
228 |
35 |
Name Address Line 5 |
X(35) |
229 |
263 |
35 |
Department Code |
X(02) |
264 |
265 |
2 |
Payroll Office Number |
X(04) |
266 |
269 |
4 |
Originating Phone Number |
X(10) |
270 |
279 |
10 |
Demonstration Project Indicator |
X(01) |
280 |
280 |
1 |
Filler |
X(18) |
281 |
298 |
18 |
TMGT Table 002, Accounting Station Name and Address, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Agency Code Accounting Station Code Filler (spaces) Record Type |
X(30) 9(03) X(02) 9(04) X(20) X(01) |
1 1 4 6 10 30 |
30 3 5 9 29 30 |
30 3 2 4 20 1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
City Name |
X(20) |
51 |
70 |
20 |
State Abbreviation |
X(02) |
71 |
72 |
2 |
Zip Code Zip Code 5 Zip Code 4 |
X(09) X(05) X(04) |
73 73 78 |
81 77 81 |
9 5 4 |
Name Address Line 1 |
X(35) |
82 |
116 |
35 |
Name Address Line 2 |
X(35) |
117 |
151 |
35 |
Name Address Line 3 |
X(35) |
152 |
186 |
35 |
Name Address Line 4 |
X(35) |
187 |
221 |
35 |
Name Address Line 5 |
X(35) |
222 |
256 |
35 |
Department Code |
X(02) |
257 |
258 |
2 |
Filler |
X(42) |
259 |
300 |
42 |
TMGT Table 005, Agency Organizational Structure, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Agency Code Organizational Structure Code Organizational Structure Code 2nd Level Organizational Structure Code 3rd Level Organizational Structure Code 4th Level Organizational Structure Code 5th Level Organizational Structure Code 6th Level Organizational Structure Code 7th Level Organizational Structure Code 8th Level |
X(01) 9(02) 9(16) 9(02) 9(02) 9(02) 9(02) 9(02) 9(02) 9(02) |
1 4 6 6 8 10 14 16 18 20 |
3 5 21 7 9 13 15 17 19 21 |
3 2 16 2 2 4 2 2 2 2 |
Filler (spaces) |
X(10) |
22 |
31 |
10 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Filler (spaces) |
X(09) |
42 |
50 |
09 |
Agency Abbreviation |
X(06) |
51 |
56 |
6 |
Organizational Structure Short Name |
X(30) |
57 |
86 |
30 |
Organizational Structure Name 1 |
X(75) |
87 |
161 |
75 |
Organizational Structure Name 2 |
X(75) |
162 |
236 |
75 |
Filler (spaces) |
X(02) |
237 |
238 |
02 |
Employee Express Indicator |
X(01) |
239 |
239 |
01 |
CPAS-SES |
X(01) |
240 |
240 |
01 |
CPAS-SLP |
X(01) |
241 |
241 |
01 |
Filler |
X(59) |
242 |
300 |
59 |
Action Code |
X(01) |
301 |
301 |
01 |
TMGT Table 010, Union Dues, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Union Dues Identification Number Filler (spaces) Record Type Record Status |
X(31) 9(03) X(06) X(20) X(01) X(01) |
1 1 4 10 30 31 |
31 3 9 29 30 31 |
31 3 6 20 1 1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
City Name |
X(20) |
51 |
70 |
20 |
Union Dues User Control Number |
X(12) |
71 |
82 |
12 |
Zip Code Zip Code 5 Zip Code 4 |
X(09) X(05) X(04) |
83 83 88 |
91 87 91 |
9 5 4 |
State Abbreviation |
X(02) |
92 |
93 |
2 |
Name Address Line 1 |
X(35) |
94 |
128 |
35 |
Name Address Line 2 |
X(35) |
129 |
163 |
35 |
Name Address Line 3 |
X(35) |
164 |
198 |
35 |
Revocation Effective Code |
9(01) |
199 |
199 |
1 |
Union Deduction Indicator |
9(01) |
200 |
200 |
1 |
EFT Indicator |
X(01) |
201 |
201 |
1 |
Bank Routing Number |
X(09) |
202 |
210 |
9 |
Bank EFT Account Number |
X(17) |
211 |
227 |
17 |
Union Association Code |
X(01) |
228 |
228 |
1 |
Union Amount Per Pay Period Dollars Decimal Cents |
9(04) 9(02) V 9(02) |
229 229
231 |
232 230
232 |
4 2
2 |
Union Local Amount 2 Dollars Decimal Cents |
9(04) 9(02)
9(02) |
233 233
235 |
236 234
236 |
4 2
2 |
Union Dues Percent |
9(04) |
237 |
240 |
4 |
Check Bank Type Account |
X(01) |
241 |
241 |
1 |
Taxpayer Identification Number 11 |
X(11) |
242 |
252 |
11 |
Filler |
X(48) |
253 |
300 |
48 |
TMGT Table 016, Geographical Location Codes, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code State Country Code City Code County Code Filler (spaces) Record Type |
X(30) 9(03) X(02) X(04) 9(3) X(17) X(01) |
1 1 4 6 10 13 30 |
30 3 5 9 12 29 30 |
30 3 2 4 3 17 1 |
Record Status |
(01) |
31 |
31 |
1 |
Table Entry Effective Date |
9(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
9(05) |
37 |
41 |
5 |
Table Entry Date Changed |
9(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
9(04) |
47 |
50 |
4 |
State Name |
X(20) |
51 |
70 |
20 |
City Name |
X(20) |
71 |
90 |
20 |
County Name |
X(20) |
91 |
110 |
20 |
State Abbreviation |
X(02) |
111 |
112 |
2 |
Sea Region |
X(01) |
113 |
113 |
1 |
Geographical Adjustment Rate |
V9(05) |
114 |
118 |
5 |
PMSA Code |
X(04) |
119 |
122 |
4 |
CMSA Code |
X(02) |
123 |
124 |
2 |
IGA Table Code |
X(04) |
125 |
128 |
4 |
LEO Geographical Adjustment Rate |
V9(05) |
129 |
133 |
5 |
Filler |
X(06) |
134 |
139 |
6 |
LEO Locality Code |
X(04) |
140 |
143 |
4 |
Locality Rate |
V9(05) |
144 |
148 |
5 |
Locality Table Code |
X(04) |
149 |
152 |
4 |
FDIC Locality Rate |
V9(05) |
153 |
157 |
5 |
FDIC Table Code |
X(04) |
158 |
161 |
4 |
OCC Locality Rate |
V9(05) |
162 |
166 |
5 |
OCC Table Code |
X(04) |
167 |
170 |
4 |
FCA Locality Rate |
9(05) |
171 |
175 |
5 |
FHFB Locality Rate |
V9(05) |
176 |
180 |
5 |
Agency Locality Rate |
V9(05) |
181 |
185 |
5 |
Agency Table Code |
X(04) |
186 |
189 |
4 |
Filler |
X(111) |
190 |
300 |
111 |
TMGT Table 018, Occupational Series Alpha Description, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Occupational Series Code Occupation Grade Range Indicator Filler (spaces) Record Type |
X(30) 9(03) 9(04) X(01) X(21) X(01) |
1 1 4 8 9 30 |
30 3 7 8 29 30 |
30 3 4 1 21 1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
Occupational Special Pay Code |
X(01) |
51 |
51 |
1 |
Function Class Indicator |
X(01) |
52 |
52 |
1 |
Occupational Grade Span Occupational Grade Span Low Occupational Grade Span High |
X(04) X(02) X(02) |
53 53 55 |
56 54 56 |
4 2 2 |
Occupational Group Number |
X(03) |
57 |
59 |
3 |
Occupational Series Alpha |
X(38) |
60 |
97 |
38 |
Pay Plan Indicator |
9(01) |
98 |
98 |
1 |
Filler |
X(202) |
99 |
300 |
202 |
TMGT Table 019, Functional Classification Description, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Occupational Function Code Filler (spaces) Record Type |
X(30) 9(03) 9(02) X(25) X(01) |
1 1 4 6 30 |
30 3 5 29 30 |
30 3 2 24 1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
Functional Classification Alpha |
X(35) |
51 |
85 |
35 |
Filler |
X(215) |
86 |
300 |
215 |
TMGT Table 025, AD-350 Block Number and Description, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code AD-350 Block Number AD-350 Access Code 1 Filler (spaces) Record Type |
X(30) 9(03) X(03) X(06) X(17) X(01) |
1 1 4 7 13 30 |
30 3 6 12 29 30 |
30 3 3 6 17 1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
9(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
9(05) |
37 |
41 |
5 |
Table Entry Date Changed |
9(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
9(04) |
47 |
50 |
4 |
AD-350 Block Alpha |
X(65) |
51 |
115 |
65 |
Filler |
X(185) |
116 |
300 |
185 |
TMGT Table 029, Pay Tables Rates, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Occupation Special Pay Area Pay Plan Grade Filler (spaces) Record Type |
X(30) 9(03) X(04) X(02) 9(02) X(18) X(01) |
1 1 4 8 10 12 30 |
30 3 7 9 11 29 30 |
30 3 4 2 2 18 1 |
Record Status (Zero) |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
Pay Rates (occurs 20 times) |
9(240) |
51 |
290 |
240 |
Annual Pay Dollars Decimal Cents |
9(08) 9(06) V 9(02) |
51 51
57 |
58 56
58 |
8 6
2 |
Hourly Pay Dollars Decimal Cents |
9(08) 9(06) V 9(02) |
59 59
65 |
66 64
66 |
8 6
2 |
Filler |
X(10) |
291 |
300 |
10 |
TMGT Table 036, School Identification, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code School Code |
X(08) 9(03) X(05) |
1 1 4 |
8 3 8 |
8 3 5 |
Filler (spaces) |
X(21) |
9 |
29 |
21 |
Record Type |
X(01) |
30 |
30 |
1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
School Name |
X(32) |
51 |
82 |
32 |
School State |
X(02) |
83 |
84 |
2 |
Filler |
X(216) |
85 |
300 |
216 |
TMGT Table 052, Remarks Codes and Descriptions, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Remarks Number Remarks Suffix Filler (spaces) Record Type |
X(31) X(03) X(03) X(01) X(23) X(01) |
1 1 4 7 8 31 |
31 3 6 7 30 31 |
31 3 3 1 23 1 |
Record Status |
X(01) |
32 |
32 |
1 |
Table Entry Effective Date |
X(05) |
33 |
37 |
5 |
Table Entry Last Effective Date |
X(05) |
38 |
42 |
5 |
Table Entry Date Changed |
X(05) |
43 |
47 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
48 |
51 |
4 |
Additional Data Indicator |
X(01) |
52 |
52 |
1 |
Remarks Alpha 1 |
X(75) |
53 |
127 |
75 |
Remarks Alpha 2 |
X(75) |
128 |
202 |
75 |
Remarks Alpha 3 |
X(75) |
203 |
277 |
75 |
Remarks Alpha Count |
X(01) |
278 |
278 |
1 |
Filler |
X(23) |
279 |
301 |
23 |
TMGT Table 055, Minimum and Maximum Salaries, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Filler (spaces) Record Type |
X(30) 9(03) X(26) X(01) |
1 1 4 30 |
30 3 29 30 |
30 3 26 1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
Maximum Annual Pay Dollars Decimal Cents |
9(08) 9(06) V 9(02) |
51 51
57 |
58 56
58 |
8 6
2 |
FEGLI Maximum Coverage |
9(03) |
59 |
61 |
3 |
FEGLI Minimum Coverage |
9(02) |
62 |
63 |
2 |
FmHA County Committee Salary Dollars Decimal Cents |
9(08) 9(06) V 9(02) |
64 64
70 |
71 69
71 |
8 6
2 |
FmHA Travel Allowance 1st Dollars Decimal Cents |
9(04) 9(02) V 9(02) |
72 72
74 |
75 73
75 |
4 2
2 |
FmHA Travel Allowance 2nd Dollars Decimal Cents |
9(04) 9(02) V 9(02) |
76 76
78 |
79 77
79 |
4 2
2 |
FmHA Travel Allowance 3rd Dollars Decimal Cents |
9(04) 9(02) V 9(02) |
80 80
82 |
83 81
83 |
4 2
2 |
Older American Salary High Dollars Decimal Cents |
9(08) 9(06) V 9(02) |
84 84
90 |
91 89
91 |
8 6
2 |
Older American Salary Low Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
92 92
97 |
98 96
98 |
7 5
2 |
ASCS State Committeemen 1st Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
99 99
104 |
105 103
105 |
7 5
2 |
ASCS State Committeemen 2nd Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
106 106
111 |
112 110
112 |
7 5
2 |
ASCS State Committeemen 3rd Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
113 113
118 |
119 117
119 |
7 5
2 |
Salary Range Per Annum High Dollars Decimal Cents |
9(08) 9(06) V 9(02) |
120 120
126 |
127 125
127 |
8 6
2 |
Salary Range Per Annum Low Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
128 128
133 |
134 132
134 |
7 5
2 |
Salary Range Per Hour High Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
135 135
140 |
141 139
141 |
7 5
2 |
Salary Range Per Hour Low Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
142 142
147 |
148 146
148 |
7 5
2 |
Salary Range Per Day High Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
149 149
154 |
155 153
155 |
7 5
2 |
Salary Range Per Day Low Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
156 156
161 |
162 160
162 |
7 5
2 |
YCC Enrollee Minimum Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
163 163
168 |
169 167
169 |
7 5
2 |
YCC Enrollee Maximum Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
170 170
175 |
176 174
176 |
7 5
2 |
SSNO Secretary |
9(09) |
177 |
185 |
9 |
Grade 13 Merit Pay Maximum Dollars Decimal Cents |
9(08) 9(06) V 9(02) |
186 186
192 |
193 191
193 |
8 6
2 |
Grade 14 Merit Pay Maximum Dollars Decimal Cents |
9(08) 9(06) V 9(02) |
194 194
200 |
201 199
201 |
8 6
2 |
Grade 15 Merit Pay Maximum Dollars Decimal Cents |
9(08) 9(06) V 9(02) |
202 202
208 |
209 207
209 |
8 6
2 |
Maximum Trustee Salary Dollars Decimal Cents |
9(08) 9(06) V 9(02) |
210 210
216 |
217 215
217 |
8 6
2 |
Maximum Assistant Trustee Salary Dollars Decimal Cents |
9(08) 9(06) V 9(02) |
218 218
224 |
225 223
225 |
8 6
2 |
U. S. Attorney Maximum Adjusted Salary Dollars Decimal Cents |
9(08) 9(06) V 9(02) |
226 226
232 |
233 231
233 |
8 6
2 |
Horse Allowance Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
234 234
239 |
240 238
240 |
7 5
2 |
Professional Liability Insurance Maximum Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
241 241
246 |
247 245
247 |
7 5
2 |
Park Fringe Maximum Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
248 248
253 |
254 252
254 |
7 5
2 |
Park Fringe Minimum Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
255 255
260 |
261 259
261 |
7 5
2 |
Transit Biweekly Maximum Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
262 262
267 |
268 266
268 |
7 5
2 |
Park Biweekly Maximum Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
269 269
274 |
275 273
275 |
7 5
2 |
Filler |
X(25) |
276 |
300 |
25 |
TMGT Table 061, Nature of Action Conversion, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Nature of Action (NOA)1st 3 Positions OPM Authority 1st OPM Authority 2nd Additional Key Record Type |
X(30) 9(03) 9(03) X(03) X(03) X(17) X(01) |
1 1 4 7 10 13 30 |
30 3 6 9 12 29 30 |
30 3 3 3 3 17 1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
NOA 1st 5 Positions |
9(05) |
51 |
55 |
5 |
Agency Authority Indicator |
X(01) |
56 |
56 |
1 |
Number CSC Authorizations |
9(01) |
57 |
57 |
1 |
Nature of Action Alpha |
X(35) |
58 |
92 |
35 |
CSC Other Legal Authority |
X(20) |
93 |
112 |
20 |
CSC Other Legal Authority 2nd |
X(20) |
113 |
132 |
20 |
Filler |
X(168) |
133 |
300 |
168 |
TMGT Table 062, 3-Digit Nature of Action, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Nature of Action (NOA)1st 3 Positions OPM Authority 1st Record Type |
X(30) 9(03) 9(03) X(03) X(01) |
1 1 4 7 30 |
30 3 6 29 30 |
30 3 3 23 1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
NOA Alpha |
X(35) |
51 |
85 |
35 |
SF 50 Indicator |
X(01) |
86 |
86 |
1 |
Filler |
X(214) |
87 |
300 |
214 |
TMGT Table 074, Official Position Title, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Occupational Series Code Official Title Code Filler (spaces) Record Type |
X(30) 9(03) 9(04) X(04) X(18) X(01) |
1 1 4 8 12 30 |
30 3 7 11 29 30 |
30 3 4 4 18 1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
Position Official Title |
X(38) |
51 |
88 |
38 |
Filler |
X(212) |
89 |
300 |
212 |
TMGT Table 076, Working Position Title, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Working Title Code Filler (spaces) Record Type |
X(30) 9(03) 9(04) X(22) X(01) |
1 1 4 8 30 |
30 3 7 29 30 |
30 3 4 22 1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
Position Working Title |
X(38) |
51 |
88 |
38 |
Filler |
X(212) |
89 |
300 |
212 |
TMGT Table-087, Travel Per Diem Rates, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code City - Town State Abbreviation Agency Code Filler (spaces) Record Type |
X(30) 9(03) X(20) X(02) X(02) X(02) X(01) |
1 1 4 24 26 28 30 |
30 3 23 25 27 29 30 |
30 3 20 2 2 2 1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
Lodging Expenses Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
51 51
56 |
57 55
57 |
7 5
2 |
Meals/Miscellaneous Expenses Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
58 58
63 |
64 62
64 |
7 5
2 |
Daily Rate Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
65 65
70 |
71 69
71 |
7 5
2 |
Date From Month Year |
9(04) 9(02) 9(02) |
72 72 74 |
75 73 75 |
4 2 2 |
Date Through Month Year |
9(04) 9(02) 9(02) |
76 76 78 |
79 77 79 |
4 2 2 |
Seasonal Lodging Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
80 80
85 |
86 84
86 |
7 5
2 |
Seasonal Miscellaneous & Incidentals Expenses (MIE) Dollars Decimal Cents |
9(07)
9(05) V 9(02) |
87
87
92 |
93
91
93 |
7
5
2 |
Seasonal Rate Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
94 94
99 |
100 98
100 |
7 5
2 |
Seasonal Date From Month Year |
9(04) 9(02) 9(02) |
101 101 103 |
104 102 104 |
4 2 2 |
Seasonal Date Through Month Year |
9(04) 9(02) 9(02) |
105 105 107 |
108 106 108 |
4 2 2 |
Lodging Expenses 2 Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
109 109
114 |
115 113
115 |
7 5
2 |
Rate Maximum MIE Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
116 116
121 |
122 120
122 |
7 5
2 |
Seasonal Rate 2 Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
123 123
128 |
129 127
129 |
7 5
2 |
Date Travel Advance Batch Month Year |
9(04) 9(02) 9(02) |
130 130 132 |
133 131 133 |
4 2 2 |
Date Travel Voucher Batch Month Year |
9(04) 9(02) 9(02) |
134 134 136 |
137 135 137 |
4 2 2 |
Lodging Expenses 3 Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
138 138
143 |
144 142
144 |
7 5
2 |
Seasonal MIE 3 Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
145 145
150 |
151 149
151 |
7 5
2 |
Seasonal Rate 3 Dollars Decimal Cents |
9(07) 9(05) V 9(02) |
152 152
157 |
158 156
158 |
7 5
2 |
Seasonal Date From 3 Month Year |
9(04) 9(02) 9(02) |
159 159 161 |
162 160 162 |
4 2 2 |
Seasonal Date Through 3 Month Year |
9(04) 9(02) 9(02) |
163 163 165 |
166 164 166 |
4 2 2 |
Filler |
X(134) |
167 |
300 |
134 |
TMGT Table 091, OPM NOA Legal Authorities, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
Table Key Table Code OPM NOA Legal Authority Filler (spaces) Record Type |
X(30) X(03) X(03) X(23) X(01) |
1 1 4 7 30 |
30 3 6 29 30 |
30 3 3 23 1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
CSC Other Legal Authority |
X(20) |
51 |
70 |
20 |
Authority Action Code |
X(01) |
71 |
71 |
1 |
Position Status CSC |
X(01) |
72 |
72 |
1 |
Filler |
X(228) |
73 |
300 |
228 |
TMGT Table 100, PACT Data Element Description, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Element Number Filler (spaces) |
X(30) X(03) 9(03) X(24) |
1 1 4 7 |
30 3 6 30 |
30 3 4 24 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
Element Long Name |
X(80) |
51 |
130 |
80 |
Element Short Name |
X(40) |
131 |
170 |
40 |
Element Attribute |
X(01) |
171 |
171 |
1 |
Element Length |
9(03) |
172 |
174 |
3 |
Element Decimal |
9(01) |
175 |
175 |
1 |
Filler |
X(125) |
176 |
300 |
125 |
TMGT Table 101, PACT Screen Elements, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code NOA Code Filler (spaces) |
X(30) X(03) X(03) X(24) |
1 1 4 7 |
30 3 6 30 |
30 3 3 24 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
Element Flag (occurs 210 times) |
X(01) |
51 |
51 |
1 |
Remarks Code (occurs 10 times) |
X(03) |
52 |
54 |
3 |
Filler |
X(161) |
140 |
300 |
161 |
TMGT Table 102, Pay/Pers Download, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Agency Code POI Identifier Code Profile Number Filler (spaces) Record Indicator |
X(30) X(03) X(02) 9(04) X(06) X(06) X(08) 9(01) |
1 1 4 6 10 16 22 30 |
30 3 5 9 15 21 29 30 |
30 3 2 4 6 6 8 1 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
Record Number 01 |
X(54) |
51 |
104 |
54 |
Department Code |
X(02) |
51 |
52 |
2 |
Organizational Structure Codes (occurs 5 times) Organizational Structure Code Agency Organizational Structure Code 2nd Level Organizational Structure Code 3rd Level Organizational Structure Code 4th Level Organizational Structure Code 5th Level Organizational Structure Code 6th Level Organizational Structure Code 7th Level Organizational Structure Code 8th Level |
X(18) X(02) X(02) X(02) X(04) X(02) X(02) X(02) X(02) |
53 53 55 57 59 63 65 67 69 |
142 54 56 58 62 64 66 68 70 |
18 2 2 2 4 2 2 2 2 |
POI (occurs 5 times) |
X(04) |
143 |
162 |
20 |
Include Flag |
X(01) |
163 |
163 |
1 |
Frequency |
X(01) |
164 |
164 |
1 |
Remote Identification |
X(16) |
165 |
180 |
16 |
Job Control Language (JCL) Output Name |
X(15) |
181 |
195 |
15 |
Expiration Date Month Date Year |
9(06) 9(02) 9(02) 9(02) |
196 196 198 200 |
201 197 199 201 |
6 2 2 2 |
Record Size |
9(04) |
202 |
205 |
4 |
Transmission Date Month Date Year |
9(06) 9(02) 9(02) 9(02) |
206 206 208 210 |
211 207 209 211 |
6 2 2 2 |
Transmission Time |
9(06) |
212 |
217 |
6 |
Transmission Pay Period |
9(02) |
218 |
219 |
2 |
Data Fields (occurs 131 times) |
X(01) |
220 |
350 |
131 |
Record Number 2 |
X(381) |
351 |
731 |
381 |
Data (occurs 299 times) |
X(01) |
732 |
1030 |
299 |
TMGT Table 103, TMGT Download Table, Record Layout Field Description |
Picture (PIC) |
Begin |
End |
Length |
|---|---|---|---|---|
Table Key Table Code Agency Code POI Identifier Code Profile Number Filler (spaces) |
X(30) X(03) X(02) 9(04) X(06) X(06) X(09) |
1 1 4 6 10 16 22 |
30 3 5 9 15 21 30 |
30 3 2 4 6 6 9 |
Record Status |
X(01) |
31 |
31 |
1 |
Table Entry Effective Date |
X(05) |
32 |
36 |
5 |
Table Entry Last Effective Date |
X(05) |
37 |
41 |
5 |
Table Entry Date Changed |
X(05) |
42 |
46 |
5 |
Table Entry Time Changed (HHMM) |
X(04) |
47 |
50 |
4 |
Include Flag |
X(01) |
51 |
51 |
1 |
Frequency |
X(01) |
52 |
52 |
1 |
Remote Id |
X(16) |
53 |
68 |
16 |
JCL Output Name |
X(15) |
69 |
83 |
15 |
Expiration Date Month Date Year |
9(06) 9(02) 9(02) 9(02) |
84 84 86 88 |
89 85 87 89 |
6 2 2 2 |
Record Size |
9(04) |
90 |
93 |
4 |
Transmission Date Month Date Year |
9(06) 9(02) 9(02) 9(02) |
94 94 96 98 |
99 95 97 99 |
6 2 2 2 |
Transmission Time |
9(06) |
100 |
105 |
6 |
Data Fields (occurs 25 times) Table Number Table Indicator |
X(04) 9(03) X(01) |
106 106 109 |
205 108 109 |
4 3 1 |
TB002 Scope Agency Department |
X(04) X(02) X(02) |
206 206 208 |
209 207 209 |
4 2 2 |
TB005 Scope (occurs 5 times) Organizational Level 4 |
X(10) X(10) |
210 210 |
259 219 |
10 10 |
TB010 Scope (occurs 20 times) Local |
X(02) X(02) |
260 260 |
299 261 |
2 2 |
TB016 Scope (occurs 10 times) State |
X(02) X(02) |
300 300 |
319 301 |
2 2 |
TB029 Scope (occurs 2 times) Table |
X(04) X(04) |
320 320 |
327 323 |
4 4 |
TB001 Scope Agency Department |
X(04) X(02) X(02) |
328 328 330 |
331 329 331 |
4 2 2 |
Date Covered From Year Month Date |
9(06) 9(02) 9(02) 9(02) |
332 332 334 336 |
337 333 335 337 |
6 2 2 2 |
Date Covered To Year Month Date |
9(06) 9(02) 9(02) 9(02) |
338 338 340 342 |
343 339 341 343 |
6 2 2 2 |
Pay Plan |
X(02) |
344 |
345 |
2 |
See Also |