PA_SP_CNFG_BP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan Prompt Table: PA_BEN_PLAN_VW
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	LIFETIME_MAX_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Lifetime Max
4	LIFEMAX_AMT_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Frequency M=Months Y=Years Default Value: Y
5	SP_MINIMUM_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Service Purchase Min
6	MIN_AMT_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Frequency M=Months Y=Years Default Value: Y
7	SP_MAXIMUM_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Service Purchase Max Default Value: 0
8	MAX_AMT_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Frequency M=Months Y=Years Default Value: Y
9	EXPIRY_DUR	Number(3,0)	SMALLINT NOT NULL	Expire Duration Default Value: 0
10	EXPIRY_DUR_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Expire Duration Frequency D=Days M=Months Default Value: D
11	OVERRIDE_EXP_DUR	Character(1)	VARCHAR2(1) NOT NULL	Override Expiration Date Y/N Table Edit Default Value: N
12	TOLERANCE1	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Tolerance Amount Default Value: 0
13	SERVICE_OVRD	Character(1)	VARCHAR2(1) NOT NULL	Service Override Allowed Y/N Table Edit Default Value: N
14	ALLOW_PAY_DED	Character(1)	VARCHAR2(1) NOT NULL	Allow Payroll Deductions Y/N Table Edit Default Value: N
15	COST_SP_DED_MIN	Number(11,2)	DECIMAL(10,2) NOT NULL	Minimum Cost
16	NUM_PAY_DED_MAX	Number(3,0)	SMALLINT NOT NULL	Maximum Deductions Default Value: 999
17	PAY_DED_INT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Interest Type C=Compound Interest S=Simple Interest Default Value: C
18	DEDUCTION_INT_RATE	Number(16,6)	DECIMAL(15,6) NOT NULL	Interest Rate
19	INT_TO_BEGIN_DT	Character(1)	VARCHAR2(1) NOT NULL	Interest to Begin Date N=No Y=Yes Default Value: N
20	DEDUCTION_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Deduction Frequency B=Bi-Monthly M=Monthly Q=Quarterly S=Semi-Monthly W=Weekly Default Value: M
21	ALLOW_INSTALLMENT	Character(1)	VARCHAR2(1) NOT NULL	Allow Installments Y/N Table Edit Default Value: Y
22	COST_SP_INSTL_MIN	Number(11,2)	DECIMAL(10,2) NOT NULL	Minimum Cost
23	NUM_INSTALL_MAX	Number(3,0)	SMALLINT NOT NULL	Maximum Installments Default Value: 999
24	INSTALL_INT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Interest Type C=Compound Interest S=Simple Interest Default Value: C
25	INSTALL_INT_RATE	Number(16,6)	DECIMAL(15,6) NOT NULL	Interest Rate
26	INT_TO_START_DT	Character(1)	VARCHAR2(1) NOT NULL	Interest to Begin Date N=No Y=Yes Default Value: N
27	INSTALLMENT_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Installment Frequency B=Bi-Monthly M=Monthly Q=Quarterly S=Semi-Monthly W=Weekly Default Value: M
28	ALLOW_LUMP_SUM	Character(1)	VARCHAR2(1) NOT NULL	Allow Lump Sum Y/N Table Edit Default Value: Y
29	ALLOW_CANCELLATION	Character(1)	VARCHAR2(1) NOT NULL	Allow Cancellation Y/N Table Edit Default Value: N
30	ALLOW_REFUND	Character(1)	VARCHAR2(1) NOT NULL	Allow Refund Y/N Table Edit Default Value: N
31	REFUND_OVER_PYMT	Character(1)	VARCHAR2(1) NOT NULL	Refund Overpayments Y/N Table Edit Default Value: Y
32	ALLOW_INT_OVRD	Character(1)	VARCHAR2(1) NOT NULL	Override Interest Rate Y/N Table Edit Default Value: N
33	LS_INT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Interest Type C=Compound Interest S=Simple Interest Default Value: C
34	LS_INT_RATE	Number(16,6)	DECIMAL(15,6) NOT NULL	Interest Rate
35	LS_INT_TO_START_DT	Character(1)	VARCHAR2(1) NOT NULL	Interest to Begin Date N=No Y=Yes Default Value: N
36	COST_SP_LUMSUM_MIN	Number(11,2)	DECIMAL(10,2) NOT NULL	Minimum Cost
37	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit Prompt Table: BUS_UNIT_TBL_FS