PA_SP_CNFG_SPT (SQL Table)	Index Back
SP Config Sp type Lvl This tables holds service purchase configuration service purchase type level values

PA_SP_CNFG_SPT

(SQL Table)

SP Config Sp type Lvl

This tables holds service purchase configuration service purchase type level values

# 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 SVC_PURCHASE_TYPE Character(4) VARCHAR2(4) NOT NULL Service Purchase Type
Prompt Table: PA_SP_TYPE_DEFN

4 CUSTOM_STMT_NAME Character(10) VARCHAR2(10) NOT NULL Custom Statement Name
Prompt Table: PA_CUSTOM6_VW

5 EMPL_ACCT_FR_NAME Character(10) VARCHAR2(10) NOT NULL Employee Contribution Account
Prompt Table: PA_SP_EAC_FR_VW

6 OVERRIDE_ELIG Character(1) VARCHAR2(1) NOT NULL Sp Eligibility
Y/N Table Edit
Default Value: Y

7 SP_MINIMUM_AMT Number(10,2) DECIMAL(9,2) NOT NULL Service Purchase Min
Default Value: 0

8 MIN_AMT_FREQ Character(1) VARCHAR2(1) NOT NULL Frequency
M=Months
Y=Years
Default Value: Y

9 SP_MAXIMUM_AMT Number(10,2) DECIMAL(9,2) NOT NULL Service Purchase Max
Default Value: 0

10 MAX_AMT_FREQ Character(1) VARCHAR2(1) NOT NULL Frequency
M=Months
Y=Years
Default Value: Y

11 CREDIT_IN_ARRAY Character(1) VARCHAR2(1) NOT NULL Apply Service
C=Payment Period
W=Date of leave/Withdrawal date
Default Value: W

12 ALLOW_COST_OVRD Character(1) VARCHAR2(1) NOT NULL Allow Cost Override
Y/N Table Edit
Default Value: N

13 COST_BASIS Character(1) VARCHAR2(1) NOT NULL Cost Basis
C=Use Calculation
E=App Engine process
O=Enter Cost
W=Use Contribution Withdrawal
Default Value: O

14 CUSTSTMT_NM_COST Character(10) VARCHAR2(10) NOT NULL Custom Statement Name
Prompt Table: PA_CUSTOM7_VW

15 BFT_BASIS_NO_SP Character(1) VARCHAR2(1) NOT NULL Benefit Basis
C=Use Calculation
O=Enter Amount
Default Value: O

16 FNCT_RSLT_NO_SP Character(10) VARCHAR2(10) NOT NULL Function Result Name
Prompt Table: PA_SP_CSBENPLN

17 BEN_CMDT_ALIAS_SPB Character(10) VARCHAR2(10) NOT NULL Benefit Commencement Dt Alias
Prompt Table: PA_DT_AND_AL_V3

18 BEN_CMDT_ALS_SPBT Character(2) VARCHAR2(2) NOT NULL Ben Com Dt Alias Type

19 BFT_BASIS_SP Character(1) VARCHAR2(1) NOT NULL Benefit Basis
C=Use Calculation
O=Enter Amount
Default Value: O

20 FNCT_RSLT_SP Character(10) VARCHAR2(10) NOT NULL Function Result Name
Prompt Table: PA_SP_CSBENPLN

21 BEN_CMDT_ALIAS_SP Character(10) VARCHAR2(10) NOT NULL Benefit Commencement Dt Alias
Prompt Table: PA_DT_AND_AL_V4

22 BEN_CMDT_ALIAS_SPT Character(2) VARCHAR2(2) NOT NULL Ben Com Dt Alias Type

23 DB_PRE_ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL Pre-Tax Entry Type
Prompt Table: ENTRY_TYPE_TBL

24 DB_PRE_ENTRY_RESN Character(5) VARCHAR2(5) NOT NULL Pre-Tax Entry Reason
Prompt Table: PA_SP_ERESN_VW

25 DB_POST_ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL Post-Tax Entry Type
Prompt Table: ENTRY_TYPE_TBL

26 DB_POST_ENTRY_RESN Character(5) VARCHAR2(5) NOT NULL Post-Tax Entry Reason
Prompt Table: PA_SP_ERESN_VW

27 CR_PRE_ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL Pre-Tax Entry Type
Prompt Table: ENTRY_TYPE_TBL

28 CR_PRE_ENTRY_RESN Character(5) VARCHAR2(5) NOT NULL Pre-Tax Entry Reason
Prompt Table: PA_SP_ERESN_VW

29 CR_POST_ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL Post-Tax Entry Type
Prompt Table: ENTRY_TYPE_TBL

30 CR_POST_ENTRY_RESN Character(5) VARCHAR2(5) NOT NULL Post-Tax Entry Reason
Prompt Table: PA_SP_ERESN_VW

31 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

32 DB_PRETAX_ACCT_CD Character(25) VARCHAR2(25) NOT NULL Pre-Tax Account Code

33 DB_POSTTAX_ACCT_CD Character(25) VARCHAR2(25) NOT NULL Post-Tax Account Code

34 CR_PRETAX_ACCT_CD Character(25) VARCHAR2(25) NOT NULL Pre-Tax Account Code

35 CR_POSTTAX_ACCT_CD Character(25) VARCHAR2(25) NOT NULL Post-Tax Account Code

36 ALLOW_NO_COST Character(1) VARCHAR2(1) NOT NULL Allow Zero Cost
Y/N Table Edit

37 CALC_AGE_DT Character(1) VARCHAR2(1) NOT NULL Used on Service Purchase Calc Defaults
A=Age Specified
D=Date Specified
L=Alias Date
Default Value: A

38 BEN_CMDT_ALIAS Character(10) VARCHAR2(10) NOT NULL Benefit Commencement Dt Alias
Prompt Table: PA_DT_AND_AL_VW

39 BEN_CMDT_ALIAST Character(2) VARCHAR2(2) NOT NULL Ben Com Dt Alias Type

40 EVENT_DT_ALIAS Character(10) VARCHAR2(10) NOT NULL Event Date Alias
Prompt Table: PA_DT_AND_AL_V1

41 EVENT_DT_ALIAST Character(2) VARCHAR2(2) NOT NULL Event Age Alias Type

42 EVENT_DT_ALIAS2 Character(10) VARCHAR2(10) NOT NULL Event Date Alias
Prompt Table: PA_DT_AND_AL_V2

43 EVENT_DT_ALIAST2 Character(2) VARCHAR2(2) NOT NULL Event Age Alias Type

44 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
Prompt Table: PSAEAPPLDEFN

#	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	SVC_PURCHASE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Service Purchase Type Prompt Table: PA_SP_TYPE_DEFN
4	CUSTOM_STMT_NAME	Character(10)	VARCHAR2(10) NOT NULL	Custom Statement Name Prompt Table: PA_CUSTOM6_VW
5	EMPL_ACCT_FR_NAME	Character(10)	VARCHAR2(10) NOT NULL	Employee Contribution Account Prompt Table: PA_SP_EAC_FR_VW
6	OVERRIDE_ELIG	Character(1)	VARCHAR2(1) NOT NULL	Sp Eligibility Y/N Table Edit Default Value: Y
7	SP_MINIMUM_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Service Purchase Min Default Value: 0
8	MIN_AMT_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Frequency M=Months Y=Years Default Value: Y
9	SP_MAXIMUM_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Service Purchase Max Default Value: 0
10	MAX_AMT_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Frequency M=Months Y=Years Default Value: Y
11	CREDIT_IN_ARRAY	Character(1)	VARCHAR2(1) NOT NULL	Apply Service C=Payment Period W=Date of leave/Withdrawal date Default Value: W
12	ALLOW_COST_OVRD	Character(1)	VARCHAR2(1) NOT NULL	Allow Cost Override Y/N Table Edit Default Value: N
13	COST_BASIS	Character(1)	VARCHAR2(1) NOT NULL	Cost Basis C=Use Calculation E=App Engine process O=Enter Cost W=Use Contribution Withdrawal Default Value: O
14	CUSTSTMT_NM_COST	Character(10)	VARCHAR2(10) NOT NULL	Custom Statement Name Prompt Table: PA_CUSTOM7_VW
15	BFT_BASIS_NO_SP	Character(1)	VARCHAR2(1) NOT NULL	Benefit Basis C=Use Calculation O=Enter Amount Default Value: O
16	FNCT_RSLT_NO_SP	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name Prompt Table: PA_SP_CSBENPLN
17	BEN_CMDT_ALIAS_SPB	Character(10)	VARCHAR2(10) NOT NULL	Benefit Commencement Dt Alias Prompt Table: PA_DT_AND_AL_V3
18	BEN_CMDT_ALS_SPBT	Character(2)	VARCHAR2(2) NOT NULL	Ben Com Dt Alias Type
19	BFT_BASIS_SP	Character(1)	VARCHAR2(1) NOT NULL	Benefit Basis C=Use Calculation O=Enter Amount Default Value: O
20	FNCT_RSLT_SP	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name Prompt Table: PA_SP_CSBENPLN
21	BEN_CMDT_ALIAS_SP	Character(10)	VARCHAR2(10) NOT NULL	Benefit Commencement Dt Alias Prompt Table: PA_DT_AND_AL_V4
22	BEN_CMDT_ALIAS_SPT	Character(2)	VARCHAR2(2) NOT NULL	Ben Com Dt Alias Type
23	DB_PRE_ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Pre-Tax Entry Type Prompt Table: ENTRY_TYPE_TBL
24	DB_PRE_ENTRY_RESN	Character(5)	VARCHAR2(5) NOT NULL	Pre-Tax Entry Reason Prompt Table: PA_SP_ERESN_VW
25	DB_POST_ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Post-Tax Entry Type Prompt Table: ENTRY_TYPE_TBL
26	DB_POST_ENTRY_RESN	Character(5)	VARCHAR2(5) NOT NULL	Post-Tax Entry Reason Prompt Table: PA_SP_ERESN_VW
27	CR_PRE_ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Pre-Tax Entry Type Prompt Table: ENTRY_TYPE_TBL
28	CR_PRE_ENTRY_RESN	Character(5)	VARCHAR2(5) NOT NULL	Pre-Tax Entry Reason Prompt Table: PA_SP_ERESN_VW
29	CR_POST_ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Post-Tax Entry Type Prompt Table: ENTRY_TYPE_TBL
30	CR_POST_ENTRY_RESN	Character(5)	VARCHAR2(5) NOT NULL	Post-Tax Entry Reason Prompt Table: PA_SP_ERESN_VW
31	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
32	DB_PRETAX_ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Pre-Tax Account Code
33	DB_POSTTAX_ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Post-Tax Account Code
34	CR_PRETAX_ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Pre-Tax Account Code
35	CR_POSTTAX_ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Post-Tax Account Code
36	ALLOW_NO_COST	Character(1)	VARCHAR2(1) NOT NULL	Allow Zero Cost Y/N Table Edit
37	CALC_AGE_DT	Character(1)	VARCHAR2(1) NOT NULL	Used on Service Purchase Calc Defaults A=Age Specified D=Date Specified L=Alias Date Default Value: A
38	BEN_CMDT_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Benefit Commencement Dt Alias Prompt Table: PA_DT_AND_AL_VW
39	BEN_CMDT_ALIAST	Character(2)	VARCHAR2(2) NOT NULL	Ben Com Dt Alias Type
40	EVENT_DT_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Event Date Alias Prompt Table: PA_DT_AND_AL_V1
41	EVENT_DT_ALIAST	Character(2)	VARCHAR2(2) NOT NULL	Event Age Alias Type
42	EVENT_DT_ALIAS2	Character(10)	VARCHAR2(10) NOT NULL	Event Date Alias Prompt Table: PA_DT_AND_AL_V2
43	EVENT_DT_ALIAST2	Character(2)	VARCHAR2(2) NOT NULL	Event Age Alias Type
44	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN). Prompt Table: PSAEAPPLDEFN