HP_GRSFRG_DATA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
3	PAY_END_DT	Date(10)	DATE	Pay Period End Date
4	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
5	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
6	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
7	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
8	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
9	HP_GROSS	Character(1)	VARCHAR2(1) NOT NULL	This field identifies if the report column is for Gross wages or Fringe Benefits (taxes). E=Gross F=Fringe
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
12	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
13	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
14	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
15	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Accounting Period
16	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
17	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
18	HP_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Secondary Department Id when Dept more than once on one record.
19	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
20	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
21	POSITION_POOL_ID	Character(3)	VARCHAR2(3) NOT NULL	Position Pool ID
22	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
23	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
24	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
25	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
26	DED_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Deduction Classification A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit
27	DED_SLSTX_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Type B=None G=Goods and Services Tax H=Harmonized Sales Tax I=Provincial Sales Tax Insurance P=Provincial Sales Tax Q=QC Prov Sales Tax Insurance S=QC Provincial Sales Tax T=Provincial Premium Tax U=QC Provincial Premium Tax
28	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
29	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
30	TAX_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Tax Balance Class
31	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
32	TAX_CLASS_CAN	Character(3)	VARCHAR2(3) NOT NULL	Canadian Tax Class ALL=Total Gross CBT=Canadian Bonus Tax CIT=Canadian Income Tax (T4) CP2=CPP Second Additional Employee CPA=Pension Adjustment CPP=Canada Pension Plan Employee CPR=Canada Pension Plan Employer CR2=CPP Second Additional Employer EIE=Employment Insurance Employee EIR=Employment Insurance Employer HTX=Provincial Health Tax PYT=Payroll Tax QBT=Quebec Bonus Tax QCD=Quebec Tax Deduction QIE=Quebec Parental Plan Employee QIR=Quebec Parental Plan Employer QIT=Quebec Income Tax (RL-1) QP2=QPP Second Additional Employee QPP=Quebec Pension Plan Employee QPR=Quebec Pension Plan Employer QR2=QPP Second Additional Employer RV2=Quebec Income Tax (RL-2) T4A=Canadian Income Tax (T4A) TRV=True RL TT4=True T4
33	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
34	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
35	DEPTID_CF	Character(10)	VARCHAR2(10) NOT NULL	Department
36	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
37	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
38	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
39	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
40	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
41	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
42	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
43	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
44	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Chartfield
45	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 1
46	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
47	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
48	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
49	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate2
50	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Business Unit
51	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
52	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Type
53	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Category
54	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Sub Category
55	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
56	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
57	REVERSED	Character(1)	VARCHAR2(1) NOT NULL	Reversed
58	HP_RETDIST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Indicates the status of retro distribution on the current distribution record 0=Not changed D=Reversing Entry R=Redistributed
59	HP_RETDIST_PAY_DT	Date(10)	DATE	Retro Dist Pay End Date
60	HP_RETRODIST_CHG	Character(1)	VARCHAR2(1) NOT NULL	Retroactive Distribution Change mad to Budgets