Table Management System (TMGT)

001-003

(03) Required

Table - Number must be 005

004-005

(02) Required

Agency-Code - (Two-position Agency acronym, ex: 34)

006-021

(16) Required

Org-Structure-Code - (Includes Levels 02-08, e.g., 01 02 03 04 05 06 07 08)

022-022

(01) Optional

Data-2-Ind - (Used by Agencies 07, 10, and 16 with a value of 2 inserted. Field must be blank if not used.)

023-031

(09) Filler

Must be spaces

(2) DATA Position

Length

Description

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 six alpha characters or spaces, for each record added to the file.)

If Org-Structure-Code in column 06-21 is all zeros than enter Agency-Abbr (up to six characters)

or

If Org-Structure-Code in column 06-21 is greater than zeros than Agency-Abbr field must be spaces.

057-086

(30) Required

Org-Structure-Short-Name. Required if position 22 is spaces.

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)

Employee-Express-Indicator (Must be a Y or N or blank. A blank is the same as submitting an N.)

240-240

(01)

CPAS-SES (formerly CPAS-IND) - Default is N. Y indicates that OPM has certified the Agency’s SES Performance Appraisal System and sets the SES pay ceiling. Y can only be used on the first level (highest level) of the organizational structure (e.g. 90 00 00 0000 00 00 00 00).

241-241

(01)

CPAS-SLP - Default is N. Y indicates that OPM has certified the Agency’s SL/ST Performance Appraisal System and sets the SL/ST pay ceiling. Y can only be used on the first level (highest level) of the organizational structure (e.g. 90 00 00 0000 00 00 00 00)

242-300

(59) 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