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