Payment History Summary Master File Description

The file contains payments issued in the last 5 prior fiscal years plus the current fiscal year through the close of the prior business month. It does not contain deduction data and is available only in the Batch FOCUS environment. Note: Employees in this file may have payments that contain a summarization of other payments. For additional information, refer to the topic: Tips For Using The Payment History Summary File.

 

  • File Name:  PHS

  • Update Schedule:  Monthly. Updated at the close of the calendar month and available on the second working day of the new calendar month.  

  • Files Automatically Joined:  None

  • Pre-programmed Joins:  JPHSAG, JPHSPSAG, JPHSPSG1

  • Sample FOCUS Request:  FOC1098

  • See Also:  Payment Data Files Comparison

 


Segment Name = ONE, Segment Type = S1

Defined

Fieldname

 Format
Type

 Format
Length

 Data Element Description

  •  

PHS:SSA

A

11

Social Security Number

  •  

PHS:SSAFOUR

A

4

Social Security Number, Last 4 Digits

  •  

PHS:SSAMASK

A

11

Social Security Number, Masked

 

PHS:YEAR

DT

YY

Business Year

 

PHS:FRSTNAME

A

16

Name, First

 

PHS:LASTNAME

A

21

Name, Last

  •  

PHS:WNAME

A

39

Name, Whole

  •  

PHS:SUMEMP

A

1

Summarized Employee

 

PHS:TWOCNT

P

4

Segment Count Level Two

 

Segment Name = TWO, Parent = ONE, Segment Type = S0, Occurs = PHS:TWOCNT

Defined

Fieldname

Format
Type

Format
Length

Data Element Description

 

PHS:PSNSEQ

A

2

Position Sequence Number

  •  

PHS:SSAPSN

A

13

SSA / Position Sequence Key

 

PHS:PSNFLAG

A

1

Position Flag

 

PHS:CAMPX

A

1

Campus Alpha Code

 

PHS:THREECNT

P

4

Segment Count Level Three

 

Segment Name = TRE, Parent = TWO, Segment Type = S0, Occurs = PHS:THREECNT

 

Defined

Fieldname

Format
Type

Format
Length

Data Element Description

 

PHS:LISTCNT

P

4

List Count

  •  

PHS:PAYPERIOD

DT

YYM

Pay Period, Date

 

PY:PAYPDTYP

A

1

Pay Period, Type

  •  

PHS:CAMPUSCD

A

2

Campus Numeric Code

 

PHS:AGENCY

A

3

Agency Code

 

PHS:UNIT

A

3

Reporting Unit

 

PHS:CLASS

A

4

Class Code

 

PHS:SERIAL

A

3

Serial Number

  •  

PHS:POSIT16

A

16

Position Number

  •  

PHS:AGYUNIT

A

6

Agency and Unit Key

 

PHS:CYCLEDT

DT

YYMD

Cycle Date

  •  

PHS:WARRANT

A

8

Warrant Number

 

PHS:CLEARTYP

A

1

Clearance Type

  •  

PHS:CLASSRNG

A

5

Class and Range Key

 

PHS:EARNID1

A

4

Earnings Id

  •  

PHS:CBID

A

3

Collective Bargaining Id, Code  

 

PHS:ISSUEDTE

DT

YYMD

Issue Date

 

PHS:PAYMETYP

A

1

Payment Type

  •  

PHS:STATUS

A

1

Payroll Status

 

PHS:PAYTYPSF

A

1

Payment Type, Suffix

 

PHS:ADJCODE

A

1

Adjustment Code

 

PHS:ROLLCODE

A

1

Roll Code

  •  

PHS:RANGE

A

1

Range Code

 

PHS:GROSSTYP

A

1

Gross Type

 

PHS:SHIFTDIF

A

1

Shift Differential

 

PHS:OVERTIME

A

1

Overtime Code

 

PHS:TIMEBASE

A

6

Time Base

 

PHS:DAYSPAID

P

4

Days Paid

 

PHS:HOURSPAID

P

6.2

Hours Paid

 

PHS:UNITSPAID

P

8.2

Units Paid

 

PHS:FEDTAXGR

P

8.2

Federal Tax Gross

 

PHS:FEDWH

P

8.2

Federal Tax Withheld

 

PHS:STTAXGR

P

8.2

State Tax Gross - 1 & 2

 

PHS:STEWH

P

8.2

State Tax Withheld - 1 & 2

 

PHS:SSTAXWH

P

8.2

Social Security Withheld - Employee

 

PHS:MEDWH

P

8.2

Medicare Tax Withheld - Employee

 

PHS:GROSSPAY

P

12.2M

Gross Pay

 

PHS:ACCNTCD

A

2

Retirement System Account Code

 

PHS:SUMREC

A

1

Summarized Record

 

PHS:SALRATE

P

8.2

Salary Rate

 

PHS:MARFED

A

1

Federal - Marital Status

 

PHS:TAXEXFED

D

2

Federal - Tax Exemption

 

PHS:MARST

A

1

State Marital Status

 

PHS:TAXEXST

D

2

State Tax Exemptions

 

PHS:ITEMALLS

D

2

State Itemized Allowances

 

PHS:SSTAXWHS

P

8.2

Social Security Withheld - Employer

 

PHS:MDTAXWHS

P

8.2

Medicare Tax Withheld - Employer

 

PHS:RETIREWH

P

8.2

Retirement Withheld

 

PHS:RETSTSHR

P

8.2

Retirement System State Share Amount

 

PHS:NETPAY

P

8.2

Net Pay

 

PHS:CLRNR

A

5

Clearance Number

 

PHS:BUDFUN

A

3

Budget Function Code

 

PHS:TAXYEAR

A

4

Tax Year

 

 

 

Last Updated: April 26, 2011