Skip to Main Content

Front-End System Interface (FESI)

Previous Topic

Next Topic

Book Contents

Book Index

Special Downloading Instructions for TMGT Tables 102 and 103

Agencies can specify whether the tables are to be downloaded daily, weekly, by pay period, or monthly. If an Agency elects to receive daily or weekly downloads, the same records could be received more than once in a pay period. Therefore, daily and weekly downloads should be for one-time, immediate use.

The FESI job that reads table records requesting downloads runs on the nights that PINE and/or BEAR process. The FESI job processes after PINE and/or BEAR are complete. If you change the frequency of a table record, it may impact the data received. Below are guidelines for download schedules.

The required entries for Tables 102 and 103 are Department, Agency, POI, identifier, and profile. The identifier is an Agency-assigned alphanumeric, 6-position field that prevents users in the same Agency and personnel office from modifying each other’s entries. The profile is an Agency-assigned alphanumeric, 6-position field that identifies multiple entries within a selected identifier in Table 102. Downloading is canceled on the date presented in the Last-Eff-Date or Expiration Date field of Table 102, whichever is earlier.

Table 102 Download File is below.

TMGT Table 102 Download File Field Description

Picture (PIC)

Begin

End

Length

05 ANNUAL-LEAVE-CATEGORY

9(01)

1

1

1

05 BARGAINING-UNIT-STATUS

9(04)

2

5

4

05 BASE CONTRACT-STATUS

9(06)V9(02)

6

13

8

05 CITIZENSHIP-CODE

9(01)

14

14

1

05 CLASSIFICATION-STANDARD-CODE

X(01)

15

15

1

05 CSC-AUTHORITY (AUTH)-CODE-1ST-NOA

X(03)

16

18

3

05 CSC-AUTH-2ND-1ST-NOA

X(03)

19

21

3

05 CSC-AUTH-CODE-2ND-NOA

X(03)

22

24

3

05 CSC-AUTH-2ND-2ND-NOA

X(03)

25

27

3

05 DATE-DEGREE-CERT-RCVD-CENTURY

9(02)

28

29

2

05 DATE-DEGREE-CERT-RCVD-YEAR

9(02)

30

31

2

05 DATE-EMP-ASSIGNED-MONTH

9(02)

32

33

2

05 DATE-EMP-ASSIGNED-DAY

9(02)

34

35

2

05 DATE-EMP-ASSIGNED-CENTURY

9(02)

36

37

2

05 DATE-EMP-ASSIGNED-YEAR

9(02)

38

39

2

05 DATE-ENTERED-PRES-GRADE-MONTH

9(02)

40

41

2

05 DATE-ENTERED-PRES-GRADE-DAY

9(02)

42

43

2

05 DATE-ENTERED-PRES-GRADE-CENTURY

9(02)

44

45

2

05 DATE-ENTERED-PRES-GRADE-YEAR

9(02)

46

47

2

05 DATE-OF-BIRTH-MONTH

9(02)

48

49

2

05 DATE-OF-BIRTH-DAY

9(02)

50

51

2

05 DATE-OF-BIRTH-CENTURY

9(02)

52

53

2

05 DATE-OF-BIRTH-YEAR

9(02)

54

55

2

05 DATE-PER-EVAL-ANNIV-MONTH

9(02)

56

57

2

05 DATE-PER-EVAL-ANNIV-DAY

9(02)

58

59

2

05 DATE-PER-EVAL-ANNIV-CENTURY

9(02)

60

61

2

05 DATE-PER-EVAL-ANNIV-YEAR

9(02)

62

63

2

05 DATE-SCD-CSR-MONTH

9(02)

64

65

2

05 DATE-SCD-CSR-DAY

9(02)

66

67

2

05 DATE-SCD-CSR-CENTURY

9(02)

68

69

2

05 DATE-SCD-CSR-YEAR

9(02)

70

71

2

05 DATE-SCD-LEAVE-MONTH

9(02)

72

73

2

05 DATE-SCD-LEAVE-DAY

9(02)

74

75

2

05 DATE-SCD-LEAVE-CENTURY

9(02)

76

77

2

05 DATE-SCD-LEAVE-YEAR

9(02)

78

79

2

05 DATE-SCD-RIF-MONTH

9(02)

80

81

2

05 DATE-SCD-RIF-DAY

9(02)

82

83

2

05 DATE-SCD-RIF-CENTURY

9(02)

84

85

2

05 DATE-SCD-RIF-YEAR

9(02)

86

87

2

05 DATE-SCD-WGI-MONTH

9(02)

88

89

2

05 DATE-SCD-WGI-DAY

9(02)

90

91

2

05 DATE-SCD-WGI-CENTURY

9(02)

92

93

2

05 DATE-SCD-WGI-YEAR

9(02)

94

95

2

05 DUTY-STATION-CITY-CODE

9(04)

96

99

4

05 DUTY-STATION-CNTY-CODE

9(03)

100

102

3

05 DUTY-STATION-STATE-CODE

X(02)

103

104

2

05 EDUCATION-LEVEL

9(02)

105

106

2

05 FAIR-LABOR-STANDARDS-CODE

X(01)

107

107

1

05 FEGLI-INDICATOR-1

X(01)

108

108

1

05 FEHB-COVERAGE-CODE

9(01)

109

109

1

05 FINANCIAL-DISCLOSURE-REQUIRED

9(01)

110

110

1

05 GRADE

9(02)

111

112

2

05 HB-PLAN-CODE

X(02)

113

114

2

05 INSTRUCTIONAL-PROGRAM

9(06)

115

120

6

05 MASTER-RECORD-NUMBER

X(06)

121

126

6

05 NAME-EMPLOYEE-FIRST

X(12)

127

138

12

05 NAME-EMPLOYEE-LAST

X(17)

139

155

17

05 NAME-EMPLOYEE-MIDDLE

X(12)

156

167

12

05 NATURE-ACTION-1ST-3-POS

9(03)

168

170

3

05 NATURE-ACTION-2ND-3-POS

9(03)

171

173

3

05 OCCUPATIONAL-SERIES-CODE

9(04)

174

177

4

05 OFFICIAL-TITLE-CODE

X(04)

178

181

4

05 ORG-STRUCTURE-CODE-2ND-LEVEL

9(02)

182

183

2

05 ORG-STRUCTURE-CODE-3RD-LEVEL

9(02)

184

185

2

05 ORG-STRUCTURE-CODE-4TH-LEVEL

9(04)

186

189

4

05 ORG-STRUCTURE-CODE-5TH-LEVEL

9(02)

190

191

2

05 ORG-STRUCTURE-CODE-6TH-LEVEL

9(02)

192

193

2

05 ORG-STRUCTURE-CODE-7TH-LEVEL

9(02)

194

195

2

05 ORG-STRUCTURE-CODE-8TH-LEVEL

9(02)

196

197

2

05 ORG-STRUCTURE-CODE-AGCY

X(02)

198

199

2

05 PAY-PLAN

X(02)

200

201

2

05 PERFORMANCE-EVALUATION-RATING

X(02)

202

203

2

05 PHYSICAL-HANDICAP-CODE

9(02)

204

205

2

05 POSITION-NUMBER

X(08)

206

213

8

05 POSITION-OFFICIAL-TITLE

X(38)

214

251

38

05 POSITION-SENSITIVITY-CODE

X(02)

252

253

2

05 POSITION-SUPERVISORY-CODE

X(01)

254

254

1

05 RETIREMENT-COVERAGE-CODE

X(01)

255

255

1

05 RNO-CODE

X(01)

256

256

1

05 SALARY-RATE-CODE

X(02)

257

258

2

05 SEX-CODE

X(01)

259

259

1

05 SPECIAL-EMPLOYMENT-PGMS-CODE

X(02)

260

261

2

05 SPECIAL-EMPLOYEE-CODE

9(02)

262

263

2

05 SSNO

9(09)

264

272

9

05 STEP

9(02)

273

274

2

05 TENURE-GROUP

9(01)

275

275

1

05 TYPE-APPOINTMENT-CODE

9(02)

276

277

2

05 VETERAN-PREFERENCE-CODE

9(01)

278

278

1

05 VETERANS-STATUS

X(01)

279

279

1

05 WORK-SCHEDULE

X(01)

280

280

1

05 WORKING-TITLE-CODE

9(04)

281

284

4

05 ACCESSION-1ST-AUTH-CODE

X(03)

285

287

3

05 ACCESSION-2ND-AUTH-CODE

X(03)

288

290

3

05 ACCESSION-NAT-OF-ACTION-CODE

9(03)

291

293

3

05 ACCOUNTING-STATION-CODE

9(04)

294

297

4

05 ACCTG-DIST-SUB-LEVEL-CODES

X(24)

298

321

24

05 AGENCY-USE-PMSO

X(12)

322

333

12

05 AGENCY-USE-PAYPERS

X(12)

334

345

12

05 AGCY-USE-1

X(01)

346

346

1

05 AGCY-USE-2

X(02)

347

348

2

05 AGCY-USE-3

X(04)

349

352

4

05 AGCY-USE-4

9(05)

353

357

5

05 AGCY-USE-5

9(06)

358

363

6

05 ANNUITANT-INDICATOR

X(01)

364

364

1

05 APPNT-1ST-AUTH-CODE

X(03)

365

367

3

05 APPNT-2ND-AUTH-CODE

X(03)

368

370

3

05 BASE-PAY-YTD

S9(06)V9(02)

371

378

8

05 CIVIL-SER-ANNUITANT-SHARE

9(06)V9(02)

379

386

8

05 COMPETITIVE-LV-CODE

X(04)

387

390

4

05 CREDITABLE-MLTRY-SRVC

9(04)

391

394

4

05 CSC-OTHER-LEGAL-AUTH (OCCURS 5 TIMES)

N/A

N/A

N/A

N/A

05 CSC-OTHER-LEGAL-AUTH-1

X(20)

395

414

20

05 CSC-OTHER-LEGAL-AUTH-2

X(20)

415

434

20

05 CSC-OTHER-LEGAL-AUTH-3

X(20)

435

454

20

05 CSC-OTHER-LEGAL-AUTH-4

X(20)

455

474

20

05 CSC-OTHER-LEGAL-AUTH-5

X(20)

475

494

20

05 CSRS-COVERAGE-AT-APPNT

X(01)

495

495

1

05 CURRENT-EMPLOYMENT-STATUS

9(02)

496

497

2

05 DATE-AGENCY-EOD-MONTH

9(02)

498

499

2

05 DATE-AGENCY-EOD-DAY

9(02)

500

501

2

05 DATE-AGENCY-EOD-CENTURY

9(02)

502

503

2

05 DATE-AGENCY-EOD-YEAR

9(02)

504

505

2

05 DATE-APPOINTMENT-NTE-MONTH

9(02)

506

507

2

05 DATE-APPOINTMENT-NTE-DAY

9(02)

508

509

2

05 DATE-APPOINTMENT-NTE-CENTURY

9(02)

510

511

2

05 DATE-APPOINTMENT-NTE-YEAR

9(02)

512

513

2

05 DATE-CAR-PERM-TEN-START-MONTH

9(02)

514

515

2

05 DATE-CAR-PERM-TEN-START-DAY

9(02)

516

517

2

05 DATE-CAR-PERM-TEN-START-CENTURY

9(02)

518

519

2

05 DATE-CAR-PERM-TEN-START-YEAR

9(02)

520

521

2

05 DATE-CONV-CAREER-TENURE-MONTH

9(02)

522

523

2

05 DATE-CONV-CAREER-TENURE-DAY

9(02)

524

525

2

05 DATE-CONV-CAREER-TENURE-CENTURY

9(02)

526

527

2

05 DATE-CONV-CAREER-TENURE-YEAR

9(02)

528

529

2

05 DATE-DEGREE-RCVD (OCCURS 3 TIMES)

N/A

N/A

N/A

N/A

05 DATE-DEGREE-RCVD-CENTURY-1

9(02)

530

531

2

05 DATE-DEGREE-RCVD-YEAR-1

9(02)

532

533

2

05 DATE-DEGREE-RCVD-CENTURY-2

9(02)

534

535

2

05 DATE-DEGREE-RCVD-YEAR-2

9(02)

536

537

2

05 DATE-DEGREE-RCVD-CENTURY-3

9(02)

538

539

2

05 DATE-DEGREE-RCVD-YEAR-3

9(02)

540

541

2

05 DATE-DETAIL-EXPIR-MONTH

9(02)

542

543

2

05 DATE-DETAIL-EXPIR-DAY

9(02)

544

545

2

05 DATE-DETAIL-EXPIR-CENTURY

9(02)

546

547

2

05 DATE-DETAIL-EXPIR-YEAR

9(02)

548

549

2

05 DATE-ENTERED-POI-MONTH

9(02)

550

551

2

05 DATE-ENTERED-POI-DAY

9(02)

552

553

2

05 DATE-ENTERED-POI-CENTURY

9(02)

554

555

2

05 DATE-ENTERED-POI-YEAR

9(02)

556

557

2

05 DATE-NON-PAY-NTE-MONTH

9(02)

558

559

2

05 DATE-NON-PAY-NTE-DAY

9(02)

560

561

2

05 DATE-NON-PAY-NTE-CENTURY

9(02)

562

563

2

05 DATE-NON-PAY-NTE-YEAR

9(02)

564

565

2

05 DATE-PERS-ACTION-EFF-SAL-MONTH

9(02)

566

567

2

05 DATE-PERS-ACTION-EFF-SAL-DAY

9(02)

568

569

2

05 DATE-PERS-ACTION-EFF-SAL-CENTURY

9(02)

570

571

2

05 DATE-PERS-ACTION-EFF-SAL-YEAR

9(02)

572

573

2

05 DATE-POS-ESTABLISHED-MONTH

9(02)

574

575

2

05 DATE-POS-ESTABLISHED-DAY

9(02)

576

577

2

05 DATE-POS-ESTABLISHED-CENTURY

9(02)

578

579

2

05 DATE-POS-ESTABLISHED-YEAR

9(02)

580

581

2

05 DATE-POS-LAST-AUD-REV-MONTH

9(02)

582

583

2

05 DATE-POS-LAST-AUD-REV-DAY

9(02)

584

585

2

05 DATE-POS-LAST-AUD-REV-CENTURY

9(02)

586

587

2

05 DATE-POS-LAST-AUD-REV-YEAR

9(02)

588

589

2

05 DATE-POSITION-CLASSIF-MONTH

9(02)

590

591

2

05 DATE-POSITION-CLASSIF-DAY

9(02)

592

593

2

05 DATE-POSITION-CLASSIF-CENTURY

9(02)

594

595

2

05 DATE-POSITION-CLASSIF-YEAR

9(02)

596

597

2

05 DATE-POSITION-NTE-MONTH

9(02)

598

599

2

05 DATE-POSITION-NTE-DAY

9(02)

600

601

2

05 DATE-POSITION-NTE-CENTURY

9(02)

602

603

2

05 DATE-POSITION-NTE-YEAR

9(02)

604

605

2

05 DATE-PROB-PERIOD-START-MONTH

9(02)

606

607

2

05 DATE-PROB-PERIOD-START-DAY

9(02)

608

609

2

05 DATE-PROB-PERIOD-START-CENTURY

9(02)

610

611

2

05 DATE-PROB-PERIOD-START-YEAR

9(02)

612

613

2

05 DATE-PROMOTION-NTE-MONTH

9(02)

614

615

2

05 DATE-PROMOTION-NTE-DAY

9(02)

616

617

2

05 DATE-PROMOTION-NTE-CENTURY

9(02)

618

619

2

05 DATE-PROMOTION-NTE-YEAR

9(02)

620

621

2

05 DATE-RETAIN-RATE-EXPIR-MONTH

9(02)

622

623

2

05 DATE-RETAIN-RATE-EXPIR-DAY

9(02)

624

625

2

05 DATE-RETAIN-RATE-EXPIR-CENTURY

9(02)

626

627

2

05 DATE-RETAIN-RATE-EXPIR-YEAR

9(02)

628

629

2

05 DATE-RETEN-RIGHTS-END-MONTH

9(02)

630

631

2

05 DATE-RETEN-RIGHTS-END-DAY

9(02)

632

633

2

05 DATE-RETEN-RIGHTS-END-CENTURY

9(02)

634

635

2

05 DATE-RETEN-RIGHTS-END-YEAR

9(02)

636

637

2

05 DATE-RETIRED-MILITARY-MONTH

9(02)

638

639

2

05 DATE-RETIRED-MILITARY-DAY

9(02)

640

641

2

05 DATE-RETIRED-MILITARY-CENTURY

9(02)

642

643

2

05 DATE-RETIRED-MILITARY-YEAR

9(02)

644

645

2

05 DATE-SCD-TSP-MONTH

9(02)

646

647

2

05 DATE-SCD-TSP-DAY

9(02)

648

649

2

05 DATE-SCD-TSP-CENTURY

9(02)

650

651

2

05 DATE-SCD-TSP-YEAR

9(02)

652

653

2

05 DATE-SUPV-MGR-PROB-MONTH

9(02)

654

655

2

05 DATE-SUPV-MGR-PROB-DAY

9(02)

656

657

2

05 DATE-SUPV-MGR-PROB-CENTURY

9(02)

658

659

2

05 DATE-SUPV-MGR-PROB-YEAR

9(02)

660

661

2

05 DATE-TSP-ELIG-MONTH

9(02)

662

663

2

05 DATE-TSP-ELIG-DAY

9(02)

664

665

2

05 DATE-TSP-ELIG-CENTURY

9(02)

666

667

2

05 DATE-TSP-ELIG-YEAR

9(02)

668

669

2

05 DATE-WGI-PROJ-EFFECTIVE-MONTH

9(02)

670

671

2

05 DATE-WGI-PROJ-EFFECTIVE-DAY

9(02)

672

673

2

05 DATE-WGI-PROJ-EFFECTIVE-CENTURY

9(02)

674

675

2

05 DATE-WGI-PROJ-EFFECTIVE-YEAR

9(02)

676

677

2

05 DEPARTMENT-CODE

9(02)

678

679

2

05 DETAIL-AGENCY

9(02)

680

681

2

05 DETAIL-DEPT-CODE

9(02)

682

683

2

05 DETAIL-GRADE

9(02)

684

685

2

05 DETAIL-MASTER-RECORD-NUMBER

X(06)

686

691

6

05 DETAIL-POSITION-NUMBER

X(08)

692

699

8

05 DETAIL-PERSONNEL OFFICE IDENTIFIER

9(04)

700

703

4

05 DRUG-TEST

X(01)

704

704

1

05 EARLY-RETIREMENT-INDICATOR

9(01)

705

705

1

05 FERS-COVERAGE-CODE

X(01)

706

706

1

05 FROZEN-CSRS-SERVICE

9(04)

707

710

4

05 GEOGRAPHIC-ADJ-RATE

9(06)V9(02)

711

718

8

05 GRADE-BASIS-INDICATOR

X(01)

719

719

1

05 HB-DATE-EFF-MONTH

9(02)

720

721

2

05 HB-DATE-EFF-DAY

9(02)

722

723

2

05 HB-DATE-EFF-CENTURY

9(02)

724

725

2

05 HB-DATE-EFF-YEAR

9(02)

726

727

2

05 HEADQUARTERS-FIELD-CODE

X(01)

728

728

1

05 LANGUAGE-REQUIRED

X(04)

729

732

4

05 LEO-INDICATOR

X(01)

733

733

1

05 LOCALITY-TABLE-CODE

X(06)

734

739

6

05 OCCUPATIONAL-FUNCTION-CODE

9(02)

740

741

2

05 OFFICIAL-TITLE-PREFIX

X(01)

742

742

1

05 OFFICIAL-TITLE-SUFFIX

X(01)

743

743

1

05 PATCO-CODE

X(01)

744

744

1

05 PAY-RATE-DETERMINANT-CODE

X(01)

745

745

1

05 PAY-TABLE-CODE

X(06)

746

751

6

05 POSITION-SCHEDULE

X(01)

752

752

1

05 POSITION-STATUS-BUDGET

X(01)

753

753

1

05 POSITION-STATUS-CSC

9(01)

754

754

1

05 POSITION-TARGET-GRADE

9(02)

755

756

2

05 POSITION-WORKING-TITLE

X(38)

757

794

38

05 PROC-INTEGRITY-ACTION-FLAG

X(01)

795

795

1

05 PROFESSIONAL-CATEGORY

X(01)

796

796

1

05 PROJECTED-DUTIES-INDICATOR

X(01)

797

797

1

05 REMARK-CODES

X(30)

798

827

30

05 RESIDENCE-ADR-1ST-LINE-ST

X(25)

828

852

25

05 RESIDENCE-ADR-CITY-NAME

X(20)

853

872

20

05 RESIDENCE-ADR-ST-CNTRY-CODE

X(02)

873

874

2

05 RESIDENCE-ADR-ZIP-5

X(05)

875

879

5

05 RETENTION-ALLOWANCE

9(06)V9(02)

880

887

8

05 SEPARATION-ACCESSION-TYPE

9(01)

888

888

1

05 PERSONNEL-OFFICE-IDENTIFIER

9(04)

889

892

4

05 TOUR-OF-DUTY-HOURS

9(03)V9(02)

893

897

5

05 TSP-ELIGIBILITY-CODE

X(01)

898

898

1

05 UNIFORM-SERVICE-STATUS

9(01)

899

899

1

05 VETERAN-PREFERENCE-RIF

X(01)

900

900

1

05 ANNUAL-LEAVE-CURRENT-BALANCE

S9(04)V9(02)

901

906

6

05 DATE-ACCESSION-MONTH

9(02)

907

908

2

05 DATE-ACCESSION-DAY

9(02)

909

910

2

05 DATE-ACCESSION-CENTURY

9(02)

911

912

2

05 DATE-ACCESSION-YEAR

9(02)

913

914

2

05 ACTION-CODE

9(01)

915

915

1

05 AGENCY-USE

X(10)

916

925

10

05 AGENCY-INFO-1

X(20)

926

945

20

05 AGENCY-INFO-2

X(20)

946

965

20

05 AGENCY-INFO-3

X(20)

966

985

20

05 AGENCY-INFO-4

X(20)

986

1005

20

05 AGENCY-INFO-5

X(20)

1006

1025

20

05 ALTERNATE-WORK-SCHEDULE

9(01)

1026

1026

1

05 ANNUAL-LEAVE-45-DAY-CODE

X(01)

1027

1027

1

05 APPNT-LIMIT-DAYS-BALANCE

S9(03)

1028

1030

3

05 APPNT-LIMIT-DAYS-TOTAL

9(03)

1031

1033

3

05 APPNT-LIMIT-DOLR-BALANCE

S9(06)V9(02)

1034

1041

8

05 APPNT-LIMIT-DOLR-TOTAL

S9(06)V9(02)

1042

1049

8

05 APPNT-LIMIT-HOURS-BALANCE

S9(04)V9(02)

1050

1055

6

05 APPNT-LIMIT-HOURS-TOTAL

S9(04)V9(02)

1056

1061

6

05 AUO-PROJECTED-ANNUAL-AMOUNT

9(05)V9(02)

1062

1068

7

05 CASH-AWARD-AMOUNT

9(06)V9(02)

1069

1076

8

05 CASH-AWARD-EFF-PAY-PERIOD

9(02)

1077

1078

2

05 CASH-AWARD-EFF-CENTURY

9(02)

1079

1080

2

05 CASH-AWARD-EFF-YEAR

9(02)

1081

1082

2

05 DATE-CHG-TENURE-MONTH

9(02)

1083

1084

2

05 DATE-CHG-TENURE-DAY

9(02)

1085

1086

2

05 DATE-CHG-TENURE-CENTURY

9(02)

1087

1088

2

05 DATE-CHG-TENURE-YEAR

9(02)

1089

1090

2

05 DATE-LAST-PAID-BEGINS-MONTH

9(02)

1091

1092

2

05 DATE-LAST-PAID-BEGINS-DAY

9(02)

1093

1094

2

05 DATE-LAST-PAID-BEGINS-CENTURY

9(02)

1095

1096

2

05 DATE-LAST-PAID-BEGINS-YEAR

9(02)

1097

1098

2

05 DATE-LAST-PAY-STAT-RET-MONTH

9(02)

1099

1100

2

05 DATE-LAST-PAY-STAT-RET-DAY

9(02)

1101

1102

2

05 DATE-LAST-PAY-STAT-RET-CENTURY

9(02)

1103

1104

2

05 DATE-LAST-PAY-STAT-RET-YEAR

9(02)

1105

1106

2

05 DATE-PERS-ACTION-VALID-MONTH

9(02)

1107

1108

2

05 DATE-PERS-ACTION-VALID-DAY

9(02)

1109

1110

2

05 DATE-PERS-ACTION-VALID-CENTURY

9(02)

1111

1112

2

05 DATE-PERS-ACTION-VALID-YEAR

9(02)

1113

1114

2

05 DATE-PROJECTED-SICK-MONTH

9(02)

1115

1116

2

05 DATE-PROJECTED-SICK-DAY

9(02)

1117

1118

2

05 DATE-PROJECTED-SICK-CENTURY

9(02)

1119

1120

2

05 DATE-PROJECTED-SICK-YEAR

9(02)

1121

1122

2

05 DATE-SERVICE-YEAR-START-MONTH

9(02)

1123

1124

2

05 DATE-SERVICE-YEAR-START-DAY

9(02)

1125

1126

2

05 DATE-SERVICE-YEAR-START-CENTURY

9(02)

1127

1128

2

05 DATE-SERVICE-YEAR-START-YEAR

9(02)

1129

1130

2

05 DUTY-STATION-CITY-NAME

X(20)

1131

1150

20

05 DUTY-STATION-COUNTY-NAME

X(20)

1151

1170

20

05 DUTY-STATION-STATE-NAME

X(02)

1171

1172

2

05 FED-TAX-NUMBER-EXEMPTIONS

X(03)

1173

1175

3

05 GAIN-LOSE-DEPT-NON-USDA

X(02)

1176

1177

2

05 GEOGRAPHIC-ADJ-PERCENT

V9(04)

1178

1181

4

05 GROSS-PAY-YTD

S9(06)V9(02)

1182

1189

8

05 HB-COVERAGE-CODE

X(01)

1190

1190

1

05 INTER-OCC-SERIES-CODE

9(04)

1191

1194

4

05 INTERDISC-SERIES-CODE (OCCURS 10 TIMES)

N/A

N/A

N/A

N/A

05 INTERDISC-SERIES-CODE-1

9(04)

1195

1198

4

05 INTERDISC-SERIES-CODE-2

9(04)

1199

1202

4

05 INTERDISC-SERIES-CODE-3

9(04)

1203

1206

4

05 INTERDISC-SERIES-CODE-4

9(04)

1207

1210

4

05 INTERDISC-SERIES-CODE-5

9(04)

1211

1214

4

05 INTERDISC-SERIES-CODE-6

9(04)

1215

1218

4

05 INTERDISC-SERIES-CODE-7

9(04)

1219

1222

4

05 INTERDISC-SERIES-CODE-8

9(04)

1223

1226

4

05 INTERDISC-SERIES-CODE-9

9(04)

1227

1230

4

05 INTERDISC-SERIES-CODE-10

9(04)

1231

1234

4

05 INTERDISC-TITLE (OCCURS 10 TIMES)

N/A

N/A

N/A

N/A

05 INTERDISC-TITLE-PREFIX-CODE-1

X(01)

1235

1235

1

05 INTERDISC-TITLE-CODE-1

9(04)

1236

1239

4

05 INTERDISC-TITLE-SUFFIX-1

X(01)

1240

1240

1

05 INTERDISC-TITLE-PREFIX-2

X(01)

1241

1241

1

05 INTERDISC-TITLE-CODE-2

9(04)

1242

1245

4

05 INTERDISC-TITLE-SUFFIX-2

X(01)

1246

1246

1

05 INTERDISC-TITLE-PREFIX-3

X(01)

1247

1247

1

05 INTERDISC-TITLE-CODE-3

9(04)

1248

1251

4

05 INTERDISC-TITLE-SUFFIX-3

X(01)

1252

1252

1

05 INTERDISC-TITLE-PREFIX-4

X(01)

1253

1253

1

05 INTERDISC-TITLE-CODE-4

9(04)

1254

1257

4

05 INTERDISC-TITLE-SUFFIX-4

X(01)

1258

1258

1

05 INTERDISC-TITLE-PREFIX-5

X(01)

1259

1259

1

05 INTERDISC-TITLE-CODE-5

9(04)

1260

1263

4

05 INTERDISC-TITLE-SUFFIX-5

X(01)

1264

1264

1

05 INTERDISC-TITLE-PREFIX-6

X(01)

1265

1265

1

05 INTERDISC-TITLE-CODE-6

9(04)

1266

1269

4

05 INTERDISC-TITLE-SUFFIX-6

X(01)

1270

1270

1

05 INTERDISC-TITLE-PREFIX-7

X(01)

1271

1271

1

05 INTERDISC-TITLE-CODE-7

9(04)

1272

1275

4

05 INTERDISC-TITLE-SUFFIX-7

X(01)

1276

1276

1

05 INTERDISC-TITLE-PREFIX-8

X(01)

1277

1277

1

05 INTERDISC-TITLE-CODE-8

9(04)

1278

1281

4

05 INTERDISC-TITLE-SUFFIX-8

X(01)

1282

1282

1

05 INTERDISC-TITLE-PREFIX-9

X(01)

1283

1283

1

05 INTERDISC-TITLE-CODE-9

9(04)

1284

1287

4

05 INTERDISC-TITLE-SUFFIX-9

X(01)

1288

1288

1

05 INTERDISC-TITLE-PREFIX-10

X(01)

1289

1289

1

05 INTERDISC-TITLE-CODE-10

9(04)

1290

1293

4

05 INTERDISC-TITLE-SUFFIX-10

9X01)

1294

1294

1

05 INTERDISCIPLINARY-CODE

9(01)

1295

1295

1

05 LEAVE-EARNING-STATUS-PAY PERIOD

X(01)

1296

1296

1

05 LI-COVERAGE-CODE-SALARY

X(02)

1297

1298

2

05 LI-COVERAGE-AMOUNT-SALARY

9(04)

1299

1302

4

05 LI-PLAN-CODE-SALARY

X(02)

1303

1304

2

05 PAID-STATUS-CODE

9(01)

1305

1305

1

05 LAST-063-PAY PERIOD

9(02)

1306

1307

2

05 LAST-063-CENTURY

9(02)

1308

1309

2

05 LAST-063-YEAR

9(02)

1310

1311

2

05 PERFORMANCE-EVALUATION-CENTURY

9(02)

1312

1313

2

05 PERFORMANCE-EVALUATION-YEAR

9(02)

1314

1315

2

05 QUARTERS-DEDUCTION-CODE

9(01)

1316

1316

1

05 QUARTERS-DEDUCTION-RATE

9(03)V9(02)

1317

1321

5

05 RECRUITMENT-BONUS

9(06)V9(02)

1322

1329

8

05 RELOCATION-BONUS

9(06)V9(02)

1330

1337

8

05 RESIDENCE-ADDITIONAL-ADR-1

X(25)

1338

1362

25

05 RESIDENCE-ADDITIONAL-ADR-2

X(25)

1363

1387

25

05 RESIDENCE-ADR-CITY-CODE

9(04)

1388

1391

4

05 RESIDENCE-ADR-COUNTY-CODE

9(03)

1392

1394

3

05 RESIDENCE-ADR-ST-COUNTRY-NAME

X(02)

1395

1396

2

05 RESIDENCE-ADR-ZIP-4

X(04)

1397

1400

4

05 SICK-LV-CURRENT-BALANCE

S9(04)V9(02)

1401

1406

6

05 COOP-ANNUIT-SHARE-CODE

9(01)

1407

1407

1

05 SCHEDULED-SALARY

9(06)V9(02)

1408

1415

8

05 SCHOOL-CODE (OCCURS 5 TIMES)

N/A

N/A

N/A

N/A

05 SCHOOL-CODE-1

X(05)

1416

1420

5

05 SCHOOL-CODE-2

X(05)

1421

1425

5

05 SCHOOL-CODE-3

X(05)

1426

1430

5

05 SCHOOL-CODE-4

X(05)

1431

1435

5

05 SCHOOL-CODE-5

X(05)

1436

1440

5

05 SCHOOL-STATE (OCCURS 5 TIMES)

N/A

N/A

N/A

N/A

05 SCHOOL-STATE-1

X(02)

1441

1442

2

05 SCHOOL-STATE-2

X(02)

1443

1444

2

05 SCHOOL-STATE-3

X(02)

1445

1446

2

05 SCHOOL-STATE-4

X(02)

1447

1448

2

05 SCHOOL-STATE-5

X(02)

1449

1450

2

05 SEPARATION-RECORD-STATUS-CODE

9(01)

1451

1451

1

05 DATE-PERS-ACTION-EFF-SEP-MONTH

9(02)

1452

1453

2

05 DATE-PERS-ACTION-EFF-SEP-DAY

9(02)

1454

1455

2

05 DATE-PERS-ACTION-EFF-SEP-CENTURY

9(02)

1456

1457

2

05 DATE-PERS-ACTION-EFF-SEP-YEAR

9(02)

1458

1459

2

05 SSNO-OLD

9(09)

1460

1468

9

05 STAFFING-DIFF-RATE

9(06)V9(02)

1469

1476

8

05 SUPERVISORY-DIFFERENTIAL-RATE

9(06)V9(02)

1477

1484

8

05 TA-CONTACT-PT-TIMEKPR-CODE

9(02)

1485

1486

2

05 TS-DATE-EFF-MONTH

9(02)

1487

1488

2

05 TS-DATE-EFF-DAY

9(02)

1489

1490

2

05 TS-DATE-EFF-CENTURY

9(02)

1491

1492

2

05 TS-DATE-EFF-YEAR

9(02)

1493

1494

2

05 TSP-EMPLOYEE-DEDUCTION-AMOUNT

9(04)

1495

1498

4

05 FILLER

9(02)

1499

1500

2

05 TSP-STATUS-CODE

X(01)

1501

1501

1

05 TSP-STATUS-DATE-MONTH

9(02)

1502

1503

2

05 TSP-STATUS-DATE-DAY

9(02)

1504

1505

2

05 TSP-STATUS-DATE-CENTURY

9(02)

1506

1507

2

05 TSP-STATUS-DATE-YEAR

9(02)

1508

1509

2

10 UNION-CODE-1

9(02)

1510

1511

2

10 UNION-CODE-2

9(02)

1512

1513

2

10 UNION-LOCAL-CODE-1

9(04)

1514

1517

4

10 UNION-LOCAL-CODE-2

9(04)

1518

1521

4

05 USER-ID

X(07)

1522

1528

7

05 WGI-DUE-CODE

9(01)

1529

1529

1

05 ACCESSION-BREAK-SERVICE-INDICATOR

9(01)

1530

1530

1

05 ACCESSION-AUTHORITY

X(20)

1531

1550

20

05 ALLOWANCE-COLA-CODE

X(01)

1551

1551

1

05 ANN-LEAVE-USED-YTD-40-MX

S9(03)V9(02)

1552

1556

5

05 APPNT-AUTHORITY

X(20)

1557

1576

20

05 COMP-LV-EARNED-PAY-PERIOD

9(02)

1577

1578

2

05 COMP-LV-EARNED-YTD

S9(04)V9(02)

1579

1584

6

05 COMP-LV-PRIOR-YEAR-BALANCE

S9(04)V9(02)

1585

1590

6

05 COMP-LV-TOTAL-CURRENT-BALANCE

S9(04)V9(02)

1591

1596

6

05 COMP-LV-USED-YTD

S9(04)V9(02)

1597

1602

6

05 CASH-AWARD-INDICATOR

X(01)

1603

1603

1

05 CMSA-CODE

X(02)

1604

1605

2

05 COLA-POST-DIFF-CODE

9(01)

1606

1606

1

05 CONFLICT-OF-INTEREST

X(01)

1607

1607

1

05 CONV-TO-TAPER-NOTIF-GIVEN

IX(01)

1608

1608

1

05 CUM-RETIREMENT-DEDUCTS-CONV

S9(05)V9(02)

1609

1615

7

05 CUM-RETIREMENT-DEDUCTIONS

S9(05)V9(02)

1616

1622

7

05 DATE-6C-RETIREMENT-MONTH

9(02)

1623

1624

2

05 DATE-6C-RETIREMENT-DAY

9(02)

1625

1626

2

05 DATE-6C-RETIREMENT-CENTURY

9(02)

1627

1628

2

05 DATE-6C-RETIREMENT-YEAR

9(02)

1629

1630

2

05 DATE-APPNT-EFF-MONTH

9(02)

1631

1632

2

05 DATE-APPNT-EFF-DAY

9(02)

1633

1634

2

05 DATE-APPNT-EFF-CENTURY

9(02)

1635

1636

2

05 DATE-APPNT-EFF-YEAR

9(02)

1637

1638

2

05 DATE-CORR-NATURE-ACTION-MONTH

9(02)

1639

1640

2

05 DATE-CORR-NATURE-ACTION-DAY

9(02)

1641

1642

2

05 DATE-CORR-NATURE-ACTION-CENTURY

9(02)

1643

1644

2

05 DATE-CORR-NATURE-ACTION-YEAR

9(02)

1645

1646

2

05 DATE-LAST-ADJ-SCD-LV-MONTH

9(02)

1647

1648

2

05 DATE-LAST-ADJ-SCD-LV-DAY

9(02)

1649

1650

2

05 DATE-LAST-ADJ-SCD-LV-CENTURY

9(02)

1651

1652

2

05 DATE-LAST-ADJ-SCD-LV-YEAR

9(02)

1653

1654

2

05 DATE-LAST-ADJ-SCD-RET-MONTH

9(02)

1655

1656

2

05 DATE-LAST-ADJ-SCD-RET-DAY

9(02)

1657

1658

2

05 DATE-LAST-ADJ-SCD-RET-CENTURY

9(02)

1659

1660

2

05 DATE-LAST-ADJ-SCD-RET-YEAR

9(02)

1661

1662

2

05 DATE-LAST-ADJ-SCD-RIF-MONTH

9(02)

1663

1664

2

05 DATE-LAST-ADJ-SCD-RIF-DAY

9(02)

1665

1666

2

05 DATE-LAST-ADJ-SCD-RIF-CENTURY

9(02)

1667

1668

2

05 DATE-LAST-ADJ-SCD-RIF-YEAR

9(02)

1669

1670

2

05 DATE-PLACE-FOL-UP-REQ-MONTH

9(02)

1671

1672

2

05 DATE-PLACE-FOL-UP-REQ-DAY

9(02)

1673

1674

2

05 DATE-PLACE-FOL-UP-REQ-CENTURY

9(02)

1675

1676

2

05 DATE-PLACE-FOL-UP-REQ-YEAR

9(02)

1677

1678

2

05 DATE-REINVESTIGATE-REQ-MONTH

9(02)

1679

1680

2

05 DATE-REINVESTIGATE-REQ-DAY

9(02)

1681

1682

2

05 DATE-REINVESTIGATE-REQ-CENTURY

9(02)

1683

1684

2

05 DATE-REINVESTIGATE-REQ-YEAR

9(02)

1685

1686

2

05 DATE-SCD-FEHB-TEMP-MONTH

9(02)

1687

1688

2

05 DATE-SCD-FEHB-TEMP-DAY

9(02)

1689

1690

2

05 DATE-SCD-FEHB-TEMP-CENTURY

9(02)

1691

1692

2

05 DATE-SCD-FEHB-TEMP-YEAR

9(02)

1693

1694

2

05 DATE-SERV-AGREE-EXPIR-MONTH

9(02)

1695

1696

2

05 DATE-SERV-AGREE-EXPIR-DAY

9(02)

1697

1698

2

05 DATE-SERV-AGREE-EXPIR-CENTURY

9(02)

1699

1700

2

05 DATE-SERV-AGREE-EXPIR-YEAR

9(02)

1701

1702

2

05 EARNINGS-LIMITATION-CODE

X(01)

1703

1703

1

05 EMPLOYEE-CEILING-INDICATOR

9(01)

1704

1704

1

05 EMPLOYMENT-TYPE

X(01)

1705

1705

1

05 EXP-APPNT-LMT-PAY-PERIOD

9(02)

1706

1707

2

05 EXP-APPNT-LMT-REPORT-CODE

X(01)

1708

1708

1

05 EXP-APPNT-LMT-CENTURY

9(02)

1709

1710

2

05 EXP-APPNT-LMT-YEAR

9(02)

1711

1712

2

05 FED-TAX-DOC-PROC-PAY-PERIOD

9(02)

1713

1714

2

05 FED-TAX-DOC-PROC-CENTURY

9(02)

1715

1716

2

05 FED-TAX-DOC-PROC-YEAR

9(02)

1717

1718

2

05 FICA-DEDUCTIONS-YTD

S9(04)V9(02)

1719

1724

6

05 FICA-WAGES-YTD

S9(06)V9(02)

1725

1732

8

05 FOREIGN-LANG-ALLOWANCE

9(06)V9(02)

1733

1740

8

05 FOREIGN-POST-PAY-DIFF-CODE

X(01)

1741

1741

1

05 FREQUENCY-PAID-CODE

9(01)

1742

1742

1

05 FROM-TO-CODE

9(01)

1743

1743

1

05 HB-CHANGE-INDICATOR

X(01)

1744

1744

1

05 HB-CONTRIBUTION-AMOUNT

S9(03)V9(02)

1745

1749

5

05 HB-DEDUCTS-YTD-DEFERRED

S9(05)V9(02)

1750

1756

7

05 HB-OPTION-CODE

9(01)

1757

1757

1

05 HOME-LV-CURRENT-BAL

S9(04)V9(02)

1758

1763

6

05 HOSP-INS-TAX-DEDUCT-YTD

S9(04)V9(02)

1764

1769

6

05 HOSP-INS-TAX-WAGES-YTD

S9(06)V9(02)

1770

1777

8

05 LAST-ACTION-PP-NUMBER

9(02)

1778

1779

2

05 LAW-BAR-MEMBERSHIP-CODE

9(01)

1780

1780

1

05 LOCATION-CODE

9(01)

1781

1781

1

05 LWOP-SINCE-LAST-WGI

S9(04)V9(02)

1782

1787

6

05 PAY-PERIOD-LAST-TIME-PAID

9(02)

1788

1789

2

05 PERF-EVAL-AGENCY (OCCURS 5 TIMES)

N/A

N/A

N/A

N/A

05 PERF-EVAL-AGENCY-USE-1

X(12)

1790

1801

12

05 PERF-EVAL-AGENCY-USE-2

X(12)

1802

1813

12

05 PERF-EVAL-AGENCY-USE-3

X(12)

1814

1825

12

05 PERF-EVAL-AGENCY-USE-4

X(12)

1826

1837

12

05 PERF-EVAL-AGENCY-USE-5

X(12)

1838

1849

12

05 PERF-EVAL-CHG-INDICATOR

X(01)

1850

1850

1

05 PERF-EVAL-ELIGIBILITY-CODE

X(01)

1851

1851

1

05 PERF-EVAL-GENERATED-PP

9(02)

1852

1853

2

05 PERF-EVAL-GENERATED-CENTURY

9(02)

1854

1855

2

05 PERF-EVAL-GENERATED-YEAR

9(02)

1856

1857

2

05 PERF-EVAL-PAY-PERIOD

9(02)

1858

1859

2

05 PHYSICAL-LOCATION

X(06)

1860

1865

6

05 PLACEMENT-FOLLOW-UP-INDICATOR

X(01)

1866

1866

1

05 PMSA-CODE

X(04)

1867

1870

4

05 PREMIUM-PAY-YTD

S9(06)V9(02)

1871

1878

8

05 PROB-PERIOD-EXPIR-INDICATOR

9(01)

1879

1879

1

05 RECRUITMENT-PERCENT

V9(02)

1880

1881

2

05 RELOCATION-PERCENT

V9(02)

1882

1883

2

05 RETENTION-PERCENT

V9(02)

1884

1885

2

05 SAVED-GRADE-GRADE

9(02)

1886

1887

2

05 SEVERANCE-PAY-CODE

9(01)

1888

1888

1

05 SICK-LEAVE-USED-YTD

S9(04)V9(02)

1889

1894

6

05 SUP-MGR-PROB-PER-REQ

9(01)

1895

1895

1

05 SUPV-MGR-PROB-PD-EXP-NOTIF

X(01)

1896

1896

1

05 TA-CONTACT-PT-CITY-CODE

9(04)

1897

1900

4

05 TA-CONTACT-PT-STATE-CODE

9(02)

1901

1902

2

05 TA-CONTACT-PT-UNIT-CODE

9(02)

1903

1904

2

05 TS-DATE-DEDUCTS-BEGAN-MONTH

9(02)

1905

1906

2

05 TS-DATE-DEDUCTS-BEGAN-DAY

9(02)

1907

1908

2

05 TS-DATE-DEDUCTS-BEGAN-CENTURYc

9(02)

1909

1910

2

05 TS-DATE-DEDUCTS-BEGAN-YEAR

9(02)

1911

1912

2

05 TSP-EMPLOYEE-DEDUCTION -RATE

9(03)

1913

1915

3

05 COMP-LV-TRAVEL-BAL

S9(04)V9(02)

1916

1921

6

05 RT-PLAN-CODE

X(2)

1922

1923

2

05 FILLER

X(22)

1924

1945

22

05 WGI-DUE-CODED-PP

9(02)

1946

1947

2

05 WGI-DUE-CODED-CENTURY

9(02)

1948

1949

2

05 WGI-DUE-CODED-YEAR

9(02)

1950

1951

2

05 WGI-NOTIFICATION-GIVEN-CODE

9(01)

1952

1952

1

05 WGI-PP-NOTIFICATION-GIVEN

9(02)

1953

1954

2

05 WGI-WITHHELD-NOT-RETURNED

9(01)

1955

1955

1

05 STATE-TAX-WH-STATE-CODE

X(02)

1956

1957

2

05 WORK-PHONE-AREA-CODE

X(03)

1958

1960

3

05 WORK-PHONE-EXCH

9(03)

1961

1963

3

05 WORK-PHONE-NUMBER

9(04)

1964

1967

4

05 FEGLI-COVERAGE-CODE

X(2)

1968

1969

2

05 FEGLI-GROUP-ADDED (OCCURS 3 TIMES)

N/A

N/A

N/A

N/A

05 LI-COVERAGE-CODE-ADDED-1

X(02)

1970

1971

2

05 LI-COVERAGE-AMOUNT-ADDED-1

9(04)

1972

1975

4

05 LI-PLAN-CODE-ADDED-1

X(02)

1976

1977

2

05 LI-COVERAGE-CODE-ADDED-2

X(02)

1978

1979

2

05 LI-COVERAGE-AMOUNT-ADDED-2

9(04)

1980

1983

4

05 LI-PLAN-CODE-ADDED-2

X(02)

1984

1985

2

05 LI-COVERAGE-CODE-ADDED-3

X(02)

1986

1987

2

05 LI-COVERAGE-AMOUNT-ADDED-3

9(04)

1988

1991

4

05 LI-PLAN-CODE-ADDED-3

X(02)

1992

1993

2

05 LAST ACTION

X(12)

1994

2005

12

05 DOCUMENT JULIAN YEAR

X(02)

2006

2007

2

05 DOCUMENT JULIAN DATE

X(03)

2008

2010

3

05 ERI-HISPANIC

9(01)

2011

2011

1

05 ERI-NATIVE-AMERICAN

9(01)

2012

2012

1

05 ERI-ASIAN

9(01)

2013

2013

1

05 ERI-AFRICAN-AMERICAN

9(01)

2014

2014

1

05 ERI-HAWAIIAN-PACIFIC-AMERICAN

9(01)

2015

2016

1

05 ERI-WHITE

9(01)

2016

2016

1

05 V2-DISABLED-VETS-LV-START-MO

9(02)

2017

2018

2

05 V2-DISABLED-VETS-LV-START-DA

9(02)

2019

2020

2

05 V2-DISABLED-VETS-LV-START-CN

9(02)

2021

2022

2

05 V2-DISABLED-VETS-LV-START-YR

9(02)

2023

2024

2

05 V2-DISABLED-VETS-LEAVE-BAL

S9(03)V9(02)

2025

2029

5

 

See Also

Downloading TMGT Tables

TMGT Download Tables

Special Downloading Instructions for FESI 102

TMGT Download Tables Record Layout