A54 Transaction Data Master File Description

This file contains selected fields from A54 transactions for employees at your campus.  It contains all A54 transactions effective on or after 01/01/1990 and is frequently used to obtain A54 transaction counts and for historical reporting.  For additional information, refer to the topic: Tips For Using The A54 Transaction Data File.

 

Due to the number of A54 transactions that can accumulate for a single employee, employees with A54 transactions posted on or after 10/01/2003 will only have A54 transactions effective 01/01/1990 or later in this file.  This is to avoid data overflow, while still providing the employee's most recent A54 transactions for reporting purposes.  If you need to access A54 transactions prior to 1990, create an Employment History Extract file for the employee.  Note:  Employees who do not have A54 transactions posted after 10/01/2003 will have all A54 transactions keyed by your campus in this file.  

 

  • File Name:  A54  

  • Update Schedule: Daily. Updated at close of business each weekday.

  • Files Automatically Joined:  None  

  • Pre-programmed Joins:  JA54PSAG

  • Sample FOCUS Request:   A54STUDY

 


Segment Name = LEV1,  Segment Type = S1

Defined

Fieldname

Format
Type

Format
Length

Data Element Description

  •  

A54:SSA

A

11

Social Security Number

  •  

A54:SSAFOUR

A

4

Social Security Number, Last 4 Digits

  •  

A54:SSAMASK

A

11

Social Security Number, Masked

  •  

A54:CAMPALL

A

16

All Campuses

  •  

A54:LSTUPD

P

7

Last Update

 

A54:LASTNAME

A

21

Name, Last

 

A54:FRSTNAME

A

16

Name, First

  •  

A54:WNAME

A

39

Name, Whole

 

A54:SEX

A

1

Sex Code

 

A54:ETHNIC

A

1

Ethnic Origin

  •  

A54:ETHNICGRP*

A

3

Ethnic Group

 

A54:TWOCNT

P

4

Segment Count Level Two

*This defined field retrieves data (A54:EFFDATE) from the lower segment.

 

Segment Name = LEV2,  Parent = LEV1,  Segment Type = S1

Defined

Fieldname

Format
Type

Format
Length

Data Element Description

 

A54:LISTCNT

P

4

List Count

 

A54:PSNSEQ

A

2

Position Sequence Number

  •  

A54:SSAPSN

A

11

SSA / Position Sequence Key

 

A54:TRANCODE

A

3

Transaction Code, Personnel

 

A54:SUFFIX

A

1

Suffix

  •  

A54:TRANNAME

A

35

Transaction Code Name

  •  

A54:TRANTYPE

A

24

Transaction Code Type

 

A54:TIMEBASE

A

6

Time Base

  •  

A54:EFFYMD

DT

YYMD

Effective Date

  •  

A54:EFFMM

DT

M

Effective Month

  •  

A54:EFFDD

DT

D

Effective Day

  •  

A54:EFFYYYY

DT

YY

Effective Year

  •  

A54:EFFDATE

DT

MDYY

Effective Date

  •  

A54:ENTRYDTE

DT

MDYY

Entry Date

 

A54:AGENCY

A

3

Agency Code

 

A54:UNIT

A

3

Reporting Unit

 

A54:CLASS

A

4

Class Code

 

A54:SERIAL

A

3

Serial Number

 

A54:RANGE

A

1

Range Code

 

A54:SPECPAY

P

9.2M

Special Pay, Amount Due

  •  

A54:SPECDAY1

I

2

Special Pay, Days 1 & 2

  •  

A54:SPECDAY2

I

2

Special Pay, Days 1 & 2

  •  

A54:SPECHOURS1

P

6.2

Special Pay, Hours 1 & 2

  •  

A54:SPECHOURS2

P

6.2

Special Pay, Hours 1 & 2

  •  

A54:SPECUNITS1

P

6.1

Special Pay, Units 1 & 2

  •  

A54:SPECUNITS2

P

6.1

Special Pay, Units 1 & 2

 

A54:SPECRATE1

P

8.2M

Special Pay, Rate 1 & 2

 

A54:SPECRATE2

P

8.2M

Special Pay, Rate 1 & 2

 

A54:LASTWORK

DT

MDYY

Last Day Physically Worked

 

A54:CAMPX

A

1

Campus Alpha Code

  •  

A54:POSIT16

A

16

Position Number

  •  

A54:POSITION

A

13

Position

  •  

A54:FTE

P

11.5

Full-Time Equivalent

  •  

A54:NUMER

I

3

Time Base, Numerator

  •  

A54:DENOM

I

3

Time Base, Denominator

  •  

A54:FTE3

P

9.3

Full-Time Equivalent 3 Decimal Places

 

 

Last Updated: May 19, 2011