IMP_CALC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
3	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
4	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Prompt Table: PAY_CALENDAR
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	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.
8	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan Prompt Table: BEN_PROG_BENPLN
9	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code Prompt Table: BEN_PROG_BENDED
10	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
11	DED_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Deduction
12	DED_CUR_PAYBK	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Deduction Payback
13	CALCULATED_BASE	Number(11,2)	DECIMAL(10,2) NOT NULL	Coverage Base
14	ADJ_CO	Character(3)	VARCHAR2(3) NOT NULL	Adjustment Company
15	ADJ_PG	Character(3)	VARCHAR2(3) NOT NULL	Adjustment Paygroup
16	ADJ_DT	Date(10)	DATE	Adjustment Pay End Dt
17	GTL_DPL_EFFECT	Character(1)	VARCHAR2(1) NOT NULL	GTL/DPL Effect - Impute Income D=Add to Dependent Life G=Add to Group Term Life N=No Imputed Income Calculated