EARNINGS_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	ERN_SEQUENCE	Number(3,0)	SMALLINT NOT NULL	Earnings Calculation Sequence
7	MAINTAIN_BALANCES	Character(1)	VARCHAR2(1) NOT NULL	Maintain Earnings Balances
8	BUDGET_EFFECT	Character(1)	VARCHAR2(1) NOT NULL	Budget Effect
9	ALLOW_EMPLTYPE	Character(1)	VARCHAR2(1) NOT NULL	Allowable Employee Types
10	PAYMENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payment Type CCD=Credit Card CHK=Check CSH=Cash D=Drawdown DR=Draft I=Interest Payment LC=Letter of Credit P=Paydown PTM=Payment Terms S=Scheduled Payment
11	HRLY_RT_MAXIMUM	Number(19,6)	DECIMAL(18,6) NOT NULL	Maximum Hourly Rate
12	PERUNIT_OVR_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Unit/Override Rate
13	EARN_FLAT_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Flat Amount
14	ADD_GROSS	Character(1)	VARCHAR2(1) NOT NULL	Add to Gross Pay
15	SUBJECT_FWT	Character(1)	VARCHAR2(1) NOT NULL	Subject to FWT
16	SUBJECT_FICA	Character(1)	VARCHAR2(1) NOT NULL	Subject to FICA
17	SUBJECT_FUT	Character(1)	VARCHAR2(1) NOT NULL	Subject to FUT
18	SUBJECT_CIT	Character(1)	VARCHAR2(1) NOT NULL	Subject to CIT
19	SUBJECT_CUI	Character(1)	VARCHAR2(1) NOT NULL	Subject EI Earn
20	SUBJECT_CUI_HOURS	Character(1)	VARCHAR2(1) NOT NULL	Subject EI Hrs
21	SUBJECT_CPP	Character(1)	VARCHAR2(1) NOT NULL	Subject to CPP
22	SUBJECT_QIT	Character(1)	VARCHAR2(1) NOT NULL	Subject to QIT
23	SUBJECT_QPP	Character(1)	VARCHAR2(1) NOT NULL	Subject to QPP
24	SUBJECT_TRUE_T4GRS	Character(1)	VARCHAR2(1) NOT NULL	Subject True T4
25	SUBJECT_TRUE_RVGRS	Character(1)	VARCHAR2(1) NOT NULL	Subject True RL
26	SUBJECT_PAY_TAX	Character(1)	VARCHAR2(1) NOT NULL	Subject to Payroll Tax
27	SUBJECT_REG	Character(1)	VARCHAR2(1) NOT NULL	Subject to Regular Rate
28	WITHHOLD_FWT	Character(1)	VARCHAR2(1) NOT NULL	Withhold FWT
29	HRS_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Hours Only
30	SHIFT_DIFF_ELIG	Character(1)	VARCHAR2(1) NOT NULL	Elig. for Shift Differential
31	TAX_GRS_COMPNT	Character(5)	VARCHAR2(5) NOT NULL	Taxable Gross Component ID
32	SPEC_CALC_RTN	Character(1)	VARCHAR2(1) NOT NULL	Special Calculation Routine
33	FACTOR_MULT	Signed Number(11,4)	DECIMAL(9,4) NOT NULL	Multiplication Factor
34	FACTOR_RATE_ADJ	Signed Number(11,4)	DECIMAL(9,4) NOT NULL	Rate Adjustment Factor
35	FACTOR_HRS_ADJ	Signed Number(11,4)	DECIMAL(9,4) NOT NULL	Hours Adjustment Factor
36	FACTOR_ERN_ADJ	Signed Number(11,4)	DECIMAL(9,4) NOT NULL	Earnings Adjustment Factor
37	GL_EXPENSE	Character(35)	VARCHAR2(35) NOT NULL	GL Account #-Expense
38	SUBTRACT_EARNS	Character(1)	VARCHAR2(1) NOT NULL	Subtract from this Draw
39	DEDCD_PAYBACK	Character(6)	VARCHAR2(6) NOT NULL	Payback Deduction Code
40	TAX_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Tax Method
41	EARN_YTD_MAX	Number(11,2)	DECIMAL(10,2) NOT NULL	Maximum Yearly Earnings
42	BASED_ON_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Based on Type
43	BASED_ON_ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Based on Single Earnings Code
44	BASED_ON_ACC_ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Special Accumulator Code
45	AMT_OR_HOURS	Character(1)	VARCHAR2(1) NOT NULL	Based on Amount or Hours
46	ELIG_FOR_RETROPAY	Character(1)	VARCHAR2(1) NOT NULL	Eligible for Retro Pay
47	USED_TO_PAY_RETRO	Character(1)	VARCHAR2(1) NOT NULL	Used to Pay Retro
48	EFFECT_ON_FLSA	Character(1)	VARCHAR2(1) NOT NULL	Effect on FLSA
49	FLSA_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Category for FLSA
50	REG_PAY_INCLUDED	Character(1)	VARCHAR2(1) NOT NULL	Regular Pay Included?
51	TIPS_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Tips Category
52	ADD_DE	Character(1)	VARCHAR2(1) NOT NULL	ADD_DE
53	SUBJECT_T4A	Character(1)	VARCHAR2(1) NOT NULL	Subject to T4A
54	SUBJECT_RV2	Character(1)	VARCHAR2(1) NOT NULL	Subject to RL-2
55	GVT_BENEFITS_RATE	Character(1)	VARCHAR2(1) NOT NULL	Adds to FEGLI Base Rate
56	GVT_CPDF_ERNCD	Character(1)	VARCHAR2(1) NOT NULL	CPDF Earnings Report Type
57	GVT_OTH_PAY	Character(1)	VARCHAR2(1) NOT NULL	Adds to Other Pay
58	GVT_PAY_CAP	Character(1)	VARCHAR2(1) NOT NULL	Adds to Pay Cap Calculations
59	GVT_PREM_PAY	Character(1)	VARCHAR2(1) NOT NULL	Adds to Premium Pay
60	GVT_OT_PAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Federal Overtime Indicator
61	GVT_ADD_TO_SF50_52	Character(1)	VARCHAR2(1) NOT NULL	Add to Other Pay on SF50/52
62	GVT_INCLUDE_LOC	Character(1)	VARCHAR2(1) NOT NULL	Include Locality Adjustment
63	GVT_IRR_REPORTABLE	Character(1)	VARCHAR2(1) NOT NULL	IRR Reporting Settings
64	GVT_IRR_LWOP	Character(1)	VARCHAR2(1) NOT NULL	Leave Without Pay
65	INCOME_CD_1042	Character(2)	VARCHAR2(2) NOT NULL	Income Code (for 1042-S)
66	PERMANENCY_NLD	Character(1)	VARCHAR2(1) NOT NULL	Permanency is used for HR Netherlands to track for Earnings and Deductions which are incidental, permanent or both.
67	TAX_CLASS_NLD	Character(1)	VARCHAR2(1) NOT NULL	Tax Class is used for HR Netherlands to be tracked for Earnings and Deductions.
68	HRS_DIST_SW	Character(1)	VARCHAR2(1) NOT NULL	Hours Disribution
69	HP_ADMINSTIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Administrative Stipend Flag