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

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

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

Last Updated: May 19, 2011