You must create this file
before it can be used for reporting. Refer to the CIRS User Manual
for instructions on creating a Payment
History Extract file.
This file contains payment
and deduction information extracted from the online payment history file.
Up to 36 months of data, plus activity during the current business
month, is available. Users are restricted to only their campus data.
Note: PY files created for more than 1 pay period may contain employees
who are missing records due to data
overflow. For additional information, refer to the topic: Tips
For Using The Payment History Extract File.
Update Schedule:
N/A. Created on
demand per user specifications. The source file for the extract function
is updated after each payroll cycle and emptied at the end of each
month. Refer to the PY Update
Schedule.
Files
Automatically Joined: None
Segment Name = ONE, Segment Type = S1
Segment Name = TWO, Parent = ONE, Segment
Type = S0, Occurs = PY:TWOCNT
Segment Name = TRE, Parent = TWO, Segment
Type = S0, Occurs = PY:THREECNT
|
PY:LISTCNT |
P |
4 |
List
Count |
|
PY:PAYPERIOD |
DT |
YYM |
Pay
Period, Date |
|
PY:PAYPDTYP |
A |
1 |
Pay
Period, Type |
|
PY:AGENCY |
A |
3 |
Agency Code |
|
PY:CAMPUSCD |
A |
2 |
Campus
Numeric Code |
|
PY:UNIT |
A |
3 |
Reporting
Unit |
|
PY:CLASS |
A |
4 |
Class
Code |
|
PY:SERIAL |
A |
3 |
Serial
Number |
|
PY:POSIT16 |
A |
16 |
Position
Number |
|
PY:AGYUNIT |
A |
6 |
Agency
and Unit Key |
|
PY:CYCLEDT |
DT |
YYMD |
Cycle
Date |
|
PY:WARRANT |
A |
8 |
Warrant
Number |
|
PY:CLEARTYP |
A |
1 |
Clearance
Type |
|
PY:CLASSRNG |
A |
5 |
Class
and Range Key |
|
PY:EARNID1 |
A |
4 |
Earnings
Id |
|
PY:CBID |
A |
3 |
Collective
Bargaining Id, Code |
|
PY:ISSUEDTE |
DT |
YYMD |
Issue
Date |
|
PY:REGWAR |
A |
1 |
Registered
Warrant |
|
PY:PAYMETYP |
A |
1 |
Payment
Type |
|
PY:PAYTYPSF |
A |
1 |
Payment
Type, Suffix |
|
PY:STATUS |
A |
1 |
Payroll
Status |
|
PY:ADJCODE |
A |
1 |
Adjustment
Code |
|
PY:ACTRECCD |
A |
1 |
Accounts
Receivable Code |
|
PY:ROLLCODE |
A |
1 |
Roll
Code |
|
PY:RANGE |
A |
1 |
Range
Code |
|
PY:FLSA |
A |
4 |
Fair
Labor Standards Act Status |
|
PY:SALTYPE |
A |
1 |
Salary
Type |
|
PY:GROSSTYP |
A |
1 |
Gross
Type |
|
PY:SHIFTDIF |
A |
1 |
Shift
Differential |
|
PY:OVERTIME |
A |
1 |
Overtime
Code |
|
PY:TIMEBASE |
A |
6 |
Time
Base |
|
PY:DAYSPAID |
P |
4 |
Days
Paid |
|
PY:HOURSPAID |
P |
6.2 |
Hours
Paid |
|
PY:UNITSPAID |
P |
8.2 |
Units
Paid |
|
PY:DOCKDAY |
P |
4 |
Dock,
Days |
|
PY:DOCKHRS |
P |
4.2 |
Dock,
Hours |
|
PY:FEDTAXGR |
P |
8.2 |
Federal
Tax Gross |
|
PY:FEDWH |
P |
8.2 |
Federal
Tax Withheld |
|
PY:STCD1 |
A |
2 |
State
Code 1 & 2 |
|
PY:STTAXGR |
P |
8.2 |
State
Tax Gross - 1 & 2 |
|
PY:STEWH |
P |
8.2 |
State
Tax Withheld - 1 & 2 |
|
PY:STCD2 |
A |
2 |
State
Code 1 & 2 |
|
PY:STTAXGR2 |
P |
8.2 |
State
Tax Gross - 1 & 2 |
|
PY:STEWH2 |
P |
8.2 |
State
Tax Withheld - 1 & 2 |
|
PY:SSTAXGR |
P |
8.2 |
Social
Security Tax Gross, Employee |
|
PY:SSTAXWH |
P |
8.2 |
Social
Security Withheld, Employee |
|
PY:MEDGR |
P |
8.2 |
Medicare
Tax Gross, Employee |
|
PY:MEDWH |
P |
8.2 |
Medicare
Tax Withheld, Employee |
|
PY:GROSSPAY |
P |
12.2M |
Gross
Pay |
|
PY:ACCNTCD |
A |
2 |
Retirement
System Account Code |
|
PY:FISCALYR |
DT |
YY |
Fiscal
Year Ending, Year |
|
PY:ARTYPE |
A |
1 |
Accounts
Receivable Type |
|
PY:LMPSUMDT |
DT |
YYM |
Lump
Sum Pay Period |
|
PY:ARDOCT |
A |
1 |
Accounts
Receivable Dock Time Code |
|
PY:SALRATE |
P |
8.2 |
Salary
Rate |
|
PY:SALFULL |
P |
8.2 |
Salary
Full |
|
PY:MARFED |
A |
1 |
Federal
Marital Status |
|
PY:TAXEXFED |
D |
2 |
Federal
Tax Exemption |
|
PY:MARST |
A |
1 |
State
Marital Status |
|
PY:TAXEXST |
D |
2 |
State
Tax Exemptions |
|
PY:ITEMALLS |
D |
2 |
State
Itemized Allowances |
|
PY:SSTAXGRS |
P |
8.2 |
Social
Security Tax Gross, Employer |
|
PY:SSTAXWHS |
P |
8.2 |
Social
Security Withheld, Employer |
|
PY:MDTAXGRS |
P |
8.2 |
Medicare
Tax Gross, Employer |
|
PY:MDTAXWHS |
P |
8.2 |
Medicare
Tax Withheld, Employer |
|
PY:RETRATE |
P |
6.5 |
Retirement
Rate |
|
PY:GRRET |
P |
8.2 |
Gross
Subject to Retirement |
|
PY:RETIREWH |
P |
8.2 |
Retirement
Withheld |
|
PY:RETSTSHR |
P |
8.2 |
Retirement
System State Share Amount |
|
PY:RETEPMC |
P |
8.2 |
Retirement
Employee Paid Member Contrib. |
|
PY:IDLOFF |
P |
8.2 |
IDL
Offset Amount |
|
PY:NETPAY |
P |
8.2 |
Net
Pay |
|
PY:CLRNR |
A |
5 |
Clearance
Number |
|
PY:BUDFUN |
A |
3 |
Budget
Function Code |
|
PY:FOURCNT |
P |
4 |
Segment
Count Level Four |
Segment Name = FOR, Parent = TRE, Segment
Type = S0, Occurs = PY:FOURCNT
The following is the variable deduction
portion.
The fields are determined by deduction
type.
Deduction Types (PY:DEDTYPE): HB, HD,
HV, FH, FD, FA, FB, FC, FF, FL
Deduction Type (PY:DEDTYPE): BL
Deduction Type (PY:DEDTYPE): SS
Deduction Type (PY:DEDTYPE): MD
Deduction Type (PY:DEDTYPE): AR
Deduction Type (PY:DEDTYPE): GA
Deduction Type (PY:DEDTYPE): RP, RT
Last Updated: April 26, 2011