PI_DED_BAL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PI_RUN_NUM	Number(4,0)	SMALLINT NOT NULL	Payroll Interface Run Number Prompt Table: PI_RUN_TBL
2	PI_SYSTEM_ID	Character(4)	VARCHAR2(4) NOT NULL	Payroll Interface System ID Prompt Table: PI_SYSTEM_TBL
3	PI_CONFIG_ID	Character(6)	VARCHAR2(6) NOT NULL	PI Configuration ID Prompt Table: PI_CONFIG_TBL
4	PI_PAY_GROUP1	Character(6)	VARCHAR2(6) NOT NULL	PI Paygroup 1
5	PI_PAY_GROUP2	Character(6)	VARCHAR2(6) NOT NULL	PI Paygroup 2
6	PI_EMPLID	Character(20)	VARCHAR2(20) NOT NULL	Payroll Interface EMPLID
7	PI_BALANCE_ID	Character(2)	VARCHAR2(2) NOT NULL	Balance ID
8	PI_BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	PI Balances for Year
9	PI_BALANCE_QTR	Number(3,0)	SMALLINT NOT NULL	PI Balances for Quarter
10	PI_BALANCE_PERIOD	Number(3,0)	SMALLINT NOT NULL	PI Balances for Period
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	PI_DED_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Payroll Deduction Type
13	PI_DED_CD	Character(6)	VARCHAR2(6) NOT NULL	Payroll Deduction Code
14	PI_DED_YTD	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Deduction Balance YTD
15	PI_DED_QTD	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Deduction Balance QTD
16	PI_DED_MTD	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Deduction Balance MTD
17	PI_COV_BASE_YTD	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Coverage base YTD
18	PI_COV_BASE_QTD	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Coverage base QTD
19	PI_COV_BASE_MTD	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Coverage base MTD
20	PI_ARREARS_BAL	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Arrears Balance
21	PI_BALANCE_KEY1	Character(10)	VARCHAR2(10) NOT NULL	User Defined Search Key 1
22	PI_BALANCE_KEY2	Character(10)	VARCHAR2(10) NOT NULL	User Defined Search Key 2