INQUIRY 14-07, Attachment 1
The tables identified below are processed systematically through a system batch process when a request includes 100 or more changes to a table. To review the required file format, double click on the hyperlink located under the applicable table number.
Number Description
|
T&A Contact Point Name and Address |
|
|
Agency Organizational Structure |
|
|
Pay Table Rates |
|
|
Travel Per Diem Rates |
Format For Batch Transactions: Table 003, T&A Contact Point Name and Address
(1) TABLE-KEY -003: |
||
POSITION |
LENGTH |
DESCRIPTION |
001-003 |
(03) (REQUIRED) |
TABLE-NUMBER MUST BE 003 |
004-005 |
(02) (REQUIRED) |
AGENCY-CODE |
006-007 |
(02) (REQUIRED) |
CONTACT POINT STATE CODE |
008-011 |
(04) (REQUIRED) |
CONTACT POINT CITY CODE |
012-013 |
(02) (REQUIRED) |
CONTACT POINT UNIT CODE |
014-030 |
(17) |
FILLER - MUST BE SPACES |
(2) DATA: |
||
031-031 |
(01) (REQUIRED) |
TABLE RECORD STATUS MUST BE ZERO |
032-036 |
(05) (REQUIRED) |
TABLE ENTRY EFF DATE MUST BE JULIAN YYDDD |
037-041 |
(05) (REQUIRED) |
TABLE ENTRY LAST EFF DATE MUST BE JULIAN YYDDD IF SPACES WILL BE FILLED WITH 49365 |
042-050 |
(09) |
FILLER - MUST BE SPACES |
051-070 |
(20) |
CITY NAME |
071-072 |
(02) (REQUIRED) |
STATE ABBREVIATION (2 CHARACTER POSTAL DESIGNATION) |
073-077 |
(05) (REQUIRED) |
ZIP CODE 5 (MUST BE NUMERIC) |
078-081 |
(04) |
ZIP CODE 4 |
082-082 |
(01) |
FTS INDICATOR MUST BE 8 OR SPACE - IF 8, FTS PHONE NUMBER MUST BE GREATER THAN ZERO |
083-092 |
(10) (REQUIRED) |
FTS PHONE NUMBER (AREA-CODE, EXCHANGE, NUMBER - NO DASHES) |
093-102 |
(10) (REQUIRED) |
PHONE NUMBER (AREA CODE, EXCHANGE, NUMBER - NO DASHES) |
103-137 |
(35) (REQUIRED) |
ADDRESS LINE 1 |
138-172 |
(35) (REQUIRED) |
ADDRESS LINE 2 |
173-207 |
(35) |
FILLER - MUST BE SPACES |
208-242 |
(35) |
REMARKS 1 |
243-277 |
(35) |
REMARKS 2 |
278-279 |
(02) (REQUIRED) |
DEPARTMENT CODE |
280-300 |
(21) |
FILLER - MUST BE SPACES |
301-301 |
(01) (REQUIRED) |
ACTION CODE - MUST BE A, D, M OR R A= ADD, D= DELETE, M=MODIFY, R = REACTIVATE |
Format For Batch Transactions: Table 005, Agency Organizational Structure
(1) TABLE-KEY -005: |
||
POSITION |
LENGTH |
DESCRIPTION |
001-003 |
(03) (REQUIRED) |
TABLE-NUMBER MUST BE 005 |
004-005 |
(02) (REQUIRED) |
AGENCY-CODE |
006-021 |
(16) (REQUIRED) |
ORG-STRUCTURE-CODE |
022-031 |
(10) |
FILLER - MUST BE SPACES |
(2) DATA: |
||
032-036 |
(05) (REQUIRED) |
BEGINNING EFF DATE IN RECORD MUST BE JULIAN YYDDD |
037-041 |
(05) (REQUIRED) |
ENDING EFF DATE IN RECORD MUST BE JULIAN YYDDD IF SPACES, WILL BE FILLED WITH 49365 |
042-050 |
(09) |
FILLER - MUST BE SPACES |
051-056 |
(06) |
AGENCY -ABBR. (UP TO 6 ALPHA CHARACTERS OR SPACES) (THIS IS FOR EACH RECORD ADDED TO THE FILE) (IF ORG-STRUCTURE-CODE IN COLS 06-21 IS ALL ZEROS THAN ENTER AGENCY - ABBR (UP TO SIX CHARACTERS) ELSE IF ORG-STRUCTURE -CODE IN COLS 06-21 IS GREATER THAN ZEROS THAN AGENCY-ABBR FIELD MUST BE SPACES. |
057-086 |
(30) (REQUIRED) |
ORG-STRUCTURE-SHORT-NAME. |
087-161 |
(75) (REQUIRED) |
ORG-STRUCTURE-NAME-1 |
162-236 |
(75) (OPTIONAL) |
ORG-STRUCTURE-NAME-2 |
237-238 |
(02) |
FILLER - MUST BE SPACES |
239-239 |
(01) (OPTIONAL) |
EMPLOYEE-EXPRESS INDICATOR |
240-240 |
(01) |
CPAS INDICATOR - DEFAULT IS "N", "Y" IF THE AGENCY HAS BEEN CERTIFIED (CERTIFIED PERFORMANCE APPRAISAL SYSTEM) |
241-300 |
(60) |
FILLER - MUST BE SPACES |
301-301 |
(01) (REQUIRED) |
ACTION CODE - MUST BE A, D, M OR R A= ADD, D= DELETE, M=MODIFY, R = REACTIVATE |
Format For Batch Transactions: Table 029, Pay Table Rates
(1) TABLE-KEY -029: |
||
POSITION |
LENGTH |
DESCRIPTION |
001-003 |
(03) (REQUIRED) |
TABLE-NUMBER MUST BE 029 |
004-007 |
(04) (REQUIRED) |
PAY-AREA |
008-009 |
(02) (REQUIRED) |
PAY-PLAN |
010-011 |
(02) (REQUIRED) |
PAY-GRADE |
012-030 |
(19) |
FILLER - MUST BE SPACES |
(2) DATA: |
||
031-031 |
(01) (REQUIRED) |
TABLE RECORD STATUS MUST BE ZERO |
032-036 |
(05) (REQUIRED) |
TABLE ENTRY EFF DATE MUST BE JULIAN YYDDD (THE BEGINNING EFFECTIVE DATE IS USUALLY THE BEGINNING OF A PAY PERIOD) |
037-041 |
(05) (REQUIRED) |
TABLE ENTRY END EFF DATE MUST BE JULIAN YYDDD (THE ENDING EFFECTIVE DATE SHOULD BE 49365) |
042-050 |
(09) |
FILLER - MUST BE SPACES |
051-290 |
(240) (REQUIRED) |
PAY-AMOUNTS OCCURS 20 TIMES (EACH OCCURANCE IS A STEP) (EXAMPLE: ANNUAL SALARY-NO HOURLY RATE = 055321000000 OR HOURLY RATE-NO ANNUAL SALARY = 000000002475) THE CHARACTER "V" IN THE AMOUNT IS AN ASSUMED DECIMAL POINT ANNUAL PAY 999999V99 (RIGHT JUSTIFY ZERO FILL) FILLED IN ANNUAL SALARY WILL CALCULATE HOURLY RATE AND THE HOURLY RATE MUST BE FILLED IN WITH ZEROS HOURLY RATE 99V99 (RIGHT JUSTIFY ZERO FILL) FILLED IN HOURLY RATE WILL CALCULATE ANNUAL PAY AND THE ANNUAL PAY MUST BE FILLED IN WITH ZEROS |
291-300 |
(10) |
FILLER - MUST BE SPACES |
301-301 |
(01) (REQUIRED) |
ACTION CODE - MUST BE A, D, M OR R A= ADD, D= DELETE, M=MODIFY, R = REACTIVATE |
Format For Batch Transactions: Table 087, Travel Per Diem Rates
(1) TABLE-KEY -087: |
||
POSITION |
LENGTH |
DESCRIPTION |
001-003 |
(03) (REQUIRED) |
TABLE-NUMBER MUST BE 087 |
004-023 |
(20) (REQUIRED) |
CITY-TOWN |
024-025 |
(02) (REQUIRED) |
STATE |
026-027 |
(02) (OPTIONAL) |
AGENCY-CODE |
028-030 |
(03) |
FILLER - MUST BE SPACES |
(2) DATA: |
||
031-031 |
(01) (REQUIRED) |
TABLE RECORD STATUS MUST BE ZERO |
032-036 |
(05) (REQUIRED) |
TABLE ENTRY BEGIN EFF DATE (YYDDD) JULIAN DATE |
037-041 |
(05) (REQUIRED) |
TABLE ENTRY END EFF DATE (YYDDD) JULIAN DATE |
042-050 |
(09) (REQUIRED) |
FILLER - MUST BE SPACES |
051-057 |
(07) (REQUIRED) |
SEASONAL LODGING RATE 1 (99999V99) |
058-064 |
(07) (REQUIRED) |
SEASONAL MEAL RATE 1 (99999V99) |
065-071 |
(07) (REQUIRED) |
SEASONAL RATE 1 (99999V99) |
072-075 |
(04) (REQUIRED) |
DATE-FROM SEASONAL RATE 1 (MMDD) |
076-079 |
(04) (REQUIRED) |
DATE-THRU SEASONAL RATE 1 (MMDD) |
080-086 |
(07) (OPTIONAL) |
SEASONAL LODGING RATE 2 (99999V99) |
087-093 |
(07) (OPTIONAL) |
SEASONAL MEAL RATE 2 (99999V99) |
094-100 |
(07) (OPTIONAL) |
SEASONAL RATE 2 (99999V99) |
101-104 |
(04) (OPTIONAL) |
DATE-FROM SEASONAL RATE 2 (MMDD) |
105-108 |
(04) (OPTIONAL) |
DATE-THRU SEASONAL RATE 2 (MMDD) |
109-115 |
(07) (OPTIONAL) |
SEASONAL LODGING RATE 3 (99999V99) |
116-122 |
(07) (OPTIONAL) |
SEASONAL MEAL RATE 3 (99999V99) |
123-129 |
(07) (OPTIONAL) |
SEASONAL RATE 3 (99999V99) |
130-133 |
(04) (OPTIONAL) |
DATE-FROM SEASONAL RATE 3 (MMDD) |
134-137 |
(04) (OPTIONAL) |
DATE-THRU SEASONAL RATE 3 (MMDD) |
138-144 |
(07) (OPTIONAL) |
SEASONAL LODGING RATE 4 (99999V99) |
145-151 |
(07) (OPTIONAL) |
SEASONAL MEAL RATE 4 (99999V99) |
152-158 |
(07) (OPTIONAL) |
SEASONAL RATE 4 (99999V99) |
159-162 |
(04) (OPTIONAL) |
DATE-FROM SEASONAL RATE 4 (MMDD) |
(2) DATA: |
||
POSITION |
LENGTH |
DESCRIPTION |
163-166 |
(04) (OPTIONAL) |
DATE-THRU SEASONAL RATE 4 (MMDD) |
167-173 |
(07) (OPTIONAL) |
SEASONAL LODGING RATE 5 (99999V99) |
174-180 |
(07) (OPTIONAL) |
SEASONAL MEAL RATE 5 (99999V99) |
181-187 |
(07) (OPTIONAL) |
SEASONAL RATE 5 (99999V99) |
188-191 |
(04) (OPTIONAL) |
DATE-FROM SEASONAL RATE 5 (MMDD) |
192-195 |
(04) (OPTIONAL) |
DATE-THRU SEASONAL RATE 5 (MMDD) |
196-202 |
(07) (OPTIONAL) |
SEASONAL LODGING RATE 6 (99999V99) |
203-209 |
(07) (OPTIONAL) |
SEASONAL MEAL RATE 6 (99999V99) |
210-216 |
(07) (OPTIONAL) |
SEASONAL RATE 6 (99999V99) |
217-220 |
(04) (OPTIONAL) |
DATE-FROM SEASONAL RATE 6 (MMDD) |
221-224 |
(04) (OPTIONAL) |
DATE-THRU SEASONAL RATE 6 (MMDD) |
225-231 |
(07) (OPTIONAL) |
SEASONAL LODGING RATE 7 (99999V99) |
232-238 |
(07) (OPTIONAL) |
SEASONAL MEAL RATE 7 (99999V99) |
239-245 |
(07) (OPTIONAL) |
SEASONAL RATE 7 (99999V99) |
246-249 |
(04) (OPTIONAL) |
DATE-FROM SEASONAL RATE 7 (MMDD) |
250-253 |
(04) (OPTIONAL) |
DATE-THRU SEASONAL RATE 7 (MMDD) |
254-260 |
(07) (OPTIONAL) |
SEASONAL LODGING RATE 8 (99999V99) |
261-267 |
(07) (OPTIONAL) |
SEASONAL MEAL RATE 8 (99999V99) |
268-274 |
(07) (OPTIONAL) |
SEASONAL RATE 8 (99999V99) |
275-278 |
(04) (OPTIONAL) |
DATE-FROM SEASONAL RATE 8 (MMDD) |
279-282 |
(04) (OPTIONAL) |
DATE-THRU SEASONAL RATE 8 (MMDD) |
283-300 |
(18) (REQUIRED) |
FILLER- MUST BE SPACES |
301-301 |
(01) (REQUIRED) |
ACTION CODE - MUST BE A, D, M OR R A= ADD, D= DELETE, M=MODIFY, R = REACTIVATE |