Table Management System

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

003

T&A Contact Point Name and Address

005

Agency Organizational Structure

029

Pay Table Rates

087

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