Payment History Data Master File Description

This file contains payment and deduction information for payments issued in the prior business month, or during a given fiscal year, back to 1984. The prior business month and current fiscal year are available in the Online FOCUS Environment. The remainder of the fiscal year files must be accessed through Batch. This file contains all payments for your employees, INCLUDING those issued by other campuses. 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 Data File.

File Name: PH

Update Schedule: Monthly. Updated after the last daily payroll cycle of the business month. Refer to the PH Update Schedule.
Files Automatically Joined: None

Pre-Programmed Joins: JPHAG, JPHPSAG, JPHPSAG1
Sample FOCUS Request: FOC1060, FOC1090
See Also: Payment Data Files Comparison

Segment Name = ONE, Segment Type = S1

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PH:SSA	A	11	Social Security Number
	PH:SSAFOUR	A	4	Social Security Number, Last 4 Digits
	PH:SSAMASK	A	11	Social Security Number, Masked
	PH:FRSTINT	A	1	Name, First Initial
	PH:MDLEINT	A	1	Name, Middle Initial
	PH:LASTNAME	A	21	Name, Last
	PH:WNAME	A	25	Name, Whole
	PH:CAMPALL	A	1	All Campuses
	PH:SUMEMP	A	1	Summarized Employee
	PH:TWOCNT	P	4	Segment Count Level Two
	PH:DAO	A	22	Data as of Date

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

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PH:PSNSEQ	A	2	Position Sequence Number
	PH:SSAPSN	A	13	SSA/Position Sequence Key
	PH:PSNFLAG	A	1	Position Flag
	PH:CAMPX	A	1	Campus Alpha Code
	PH:THREECNT	P	4	Segment Count Level Three

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

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PH:LISTCNT	P	4	List Count
	PH:PAYPERIOD	DT	YYM	Pay Period, Date
	PH:PAYPDTYP	A	1	Pay Period, Type
	PH:AGENCY	A	3	Agency Code
	PH:CAMPUSCD	A	2	Campus Numeric Code
	PH:UNIT	A	3	Reporting Unit
	PH:CLASS	A	4	Class Code
	PH:SERIAL	A	3	Serial Number
	PH:POSIT16	A	16	Position Number
	PH:AGYUNIT	A	6	Agency and Unit Key
	PH:CYCLEDT	DT	YYMD	Cycle Date
	PH:WARRANT	A	8	Warrant Number
	PH:CLEARTYP	A	1	Clearance Type
	PH:CLASSRNG	A	5	Class and Range Key
	PH:EARNID1	A	4	Earnings Id
	PH:CBID	A	3	Collective Bargaining Id, Code
	PH:ISSUEDTE	DT	YYMD	Issue Date
	PH:REGWAR	A	1	Registered Warrant
	PH:PAYMETYP	A	1	Payment Type
	PH:PAYTYPSF	A	1	Payment Type, Suffix
	PH:STATUS	A	1	Payroll Status
	PH:ADJCODE	A	1	Adjustment Code
	PH:ACTRECCD	A	1	Accounts Receivable Code
	PH:ROLLCODE	A	1	Roll Code
	PH:RANGE	A	1	Range Code
	PH:FLSA	A	4	Fair Labor Standards Act Status
	PH:SALTYPE	A	1	Salary Type
	PH:GROSSTYP	A	1	Gross Type
	PH:SHIFTDIF	A	1	Shift Differential
	PH:OVERTIME	A	1	Overtime Code
	PH:TIMEBASE	A	6	Time Base
	PH:DAYSPAID	P	4	Days Paid
	PH:HOURSPAID	P	6.2	Hours Paid
	PH:UNITSPAID	P	8.2	Units Paid
	PH:DOCKDAY	P	4	Dock, Days
	PH:DOCKHRS	P	4.2	Dock, Hours
	PH:FEDTAXGR	P	8.2	Federal Tax Gross
	PH:FEDWH	P	8.2	Federal Tax Withheld
	PH:STCD	A	2	State Code 1 & 2
	PH:STTAXGR	P	8.2	State Tax Gross - 1 & 2
	PH:STEWH	P	8.2	State Tax Withheld - 1 & 2
	PH:STCD2	A	2	State Code 1 & 2
	PH:STTAXGR2	P	8.2	State Tax Gross - 1 & 2
	PH:STEWH2	P	8.2	State Tax Withheld - 1 & 2
	PH:SSTAXGR	P	8.2	Social Security Tax Gross, Employee
	PH:SSTAXWH	P	8.2	Social Security Withheld, Employee
	PH:MEDGR	P	8.2	Medicare Tax Gross, Employee
	PH:MEDWH	P	8.2	Medicare Tax Withheld, Employee
	PH:GROSSPAY	P	12.2M	Gross Pay
	PH:ACCNTCD	A	2	Retirement System Account Code
	PH:FISCALYR	DT	YY	Fiscal Year Ending, Year
	PH:ARTYPE	A	1	Accounts Receivable Type
	PH:LMPSUMDT	DT	YYM	Lump Sum Pay Period
	PH:SUMREC	A	1	Summarized Record
	PH:ARDOCT	A	1	Accounts Receivable Dock Time Code
	PH:SALRATE	P	8.2	Salary Rate
	PH:SALFULL	P	8.2	Salary Full
	PH:MARFED	A	1	Federal Marital Status
	PH:TAXEXFED	D	2	Federal Tax Exemption
	PH:MARST	A	1	State Marital Status
	PH:TAXEXST	D	2	State Tax Exemptions
	PH:ITEMALLS	D	2	State Itemized Allowances
	PH:SSTAXGRS	P	8.2	Social Security Tax Gross, Employer
	PH:SSTAXWHS	P	8.2	Social Security Withheld, Employer
	PH:MDTAXGRS	P	8.2	Medicare Tax Gross, Employer
	PH:MDTAXWHS	P	8.2	Medicare Tax Withheld, Employer
	PH:RETRATE	P	6.5	Retirement Rate
	PH:GRRET	P	8.2	Gross Subject to Retirement
	PH:RETIREWH	P	8.2	Retirement Withheld
	PH:RETSTSHR	P	8.2	Retirement System State Share Amount
	PH:RETEPMC	P	8.2	Retirement Employee Paid Member Contrib.
	PH:IDLOFF	P	8.2	IDL Offset Amount
	PH:NETPAY	P	8.2	Net Pay
	PH:CLRNR	A	5	Clearance Number
	PH:BUDFUN	A	3	Budget Function Code
	PH:FOURCNT	P	4	Segment Count Level Four

Segment Name = FOR, Parent = TRE, Segment Type = S0, Occurs = PH:FOURCNT

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PH:DEDID	A	6	Deduction ID
	PH:DEDCODE	A	3	Deduction Code
	PH:DEDNAME	A	11	Deduction Code Name
	PH:ORGCODE	A	3	Organization Code
	PH:DEDAMT	P	12.2	Deduction Amount
	PH:DEDPPDTE	DT	YYM	Deduction Pay Period Date
	PH:DEDPPTP	A	1	Deduction Pay Period Type
	PH:DEDTAX	A	1	Deduction Tax Gross Indicator
	PH:DEDTYPE	A	2	Deduction Type
	PH:DED1	A	1	Deduction Type, Character 1
	PH:DED2	A	1	Deduction Type, Character 2

The following is the variable deduction portion.

The fields are determined by deduction type.

Deduction Types (PH:DEDTYPE): HB, HD, HV, FH, FD, FA, FB, FC, FF, FL

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PH:HBSTATE	P	8.2	Health Benefits State Share Amount
	PH:HBADCST	P	8.2	Health Benefits Administrative Cost
	PH:HBPRTCD	A	1	Health Benefits Party Rate Code
	PH:HBPLAN	A	1	Health Benefits Plan Type
	PH:HBAGY	A	3	Health Benefits Agency Code
	PH:HBUNIT	A	3	Health Benefits Reporting Unit

Deduction Type (PH:DEDTYPE): BL

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PH:BLSTATE	P	8.2	Basic Life Share Amount
	PH:BLAGY	A	3	Basic Life Agency Code
	PH:BLUNIT	A	3	Basic Life Reporting Unit
	PH:BLCBID	A	3	Basic Life CBID

Deduction Type (PH:DEDTYPE): SS

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PH:SSAISYY	A	2	Social Security Arrears Issue Year
	PH:SSAFIYY	A	2	Social Security Arrears Fiscal Year
	PH:SSAQTR	A	1	Social Security Arrears Quarter
	PH:SSAAGY	A	3	Social Security Agency Code
	PH:SSAUNIT	A	3	Social Security Arrears Reporting Unit
	PH:SSAGR	P	8.2	Social Security Arrears Employee Gross
	PH:SSASTGR	P	8.2	Social Security Arrears Employer Gross
	PH:SSASTWH	P	8.2	Social Security Arrears Employer Withheld

Deduction Type (PH:DEDTYPE): MD

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PH:MEDISYR	A	2	Medicare Arrears Issue Year
	PH:MEDFIYR	A	2	Medicare Arrears Fiscal Year
	PH:MEDQTR	A	1	Medicare Arrears Quarter
	PH:MEDAGY	A	3	Medicare Arrears Agency Code
	PH:MEDUNIT	A	3	Medicare Arrears Reporting Unit
	PH:MEDGR	P	8.2	Medicare Arrears Employee Gross
	PH:MEDSTGR	P	8.2	Medicare Arrears Employer Gross
	PH:MEDSTWH	P	8.2	Medicare Arrears Employer Withheld

Deduction Type (PH:DEDTYPE): AR

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PH:ARNO	A	5	Accounts Receivable Number
	PH:ARPAYTYP	A	1	Accounts Receivable Payment Type
	PH:ARTAXGR	P	8.2	Accounts Receivable Taxable Gross

Deduction Type (PH:DEDTYPE): GA

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PH:GAEFFDATE	DT	MDYY	Garnishment Effective Date
	PH:GATERMDATE	A	8YYMD	Garnishment Termination Date
	PH:GAAMOUNT	P	8.2M	Garnishment Original Amount

Deduction Type (PH:DEDTYPE): RP, RT

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PH:RASALTYPE	A	1	Retirement Arrears Salary Type
	PH:RASALRATE	A	1	Retirement Arrears Salary Rate
	PH:RAGRRET	P	8.2	Retirement Arrears Gross Subject to Retirement
	PH:RARETSTSHR	P	8.2	Retirement Arrears State Share Amount
	PH:RARETRATE	P	8.2	Retirement Arrears Retirement Rate
	PH:RAACCNTCD	A	2	Retirement Arrears Account Code
	PH:RAAGENCY	P	8.2	Retirement Arrears Agency Code
	PH:RAUNIT	A	3	Retirement Arrears Reporting Unit
	PH:RAPAYMETYP	A	1	Retirement Arrears Payment Type
	PH:RAADJCODE	A	1	Retirement Arrears Adjustment Code

Last Updated: April 26, 2011