BEN_DEFN_PGM (SQL Table)	Index Back
Benefit Program Definition Tbl BEN_DEFN_PGM is a record that contains information on all the Benefit Programs offered by a company. This table is used as a prompt table for many panels and accessed often by the batch processing of the Benefits Administration product.

BEN_DEFN_PGM

(SQL Table)

Benefit Program Definition Tbl

BEN_DEFN_PGM is a record that contains information on all the Benefit Programs offered by a company. This table is used as a prompt table for many panels and accessed often by the batch processing of the Benefits Administration product.

Related Language Record: BENEF_PGM_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.

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 PROGRAM_TYPE Character(1) VARCHAR2(1) NOT NULL Program Type
A=Automated
M=Manual

7 FSA_RUN_ID Character(3) VARCHAR2(3) NOT NULL Flexible Spending Acct Run ID

8 FSA_MIN_CHECK_AMT Number(7,2) DECIMAL(6,2) NOT NULL FSA Minimum Check Amount

9 FSA_MAX_ANNL_PLDG Number(9,2) DECIMAL(8,2) NOT NULL FSA Maximum Annual Pledge

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL

11 DFLT_EXPIRATION_DD Number(3,0) SMALLINT NOT NULL Number of Days Before Defaults

12 DFLT_CREDIT_RLLOVR Character(1) VARCHAR2(1) NOT NULL Apply Excess Credits to
C=Cash
D=FSA - Dependent Care
F=Forfeit Excess Credits
H=FSA - Health Care
R=FSA-Retirement Counseling
S=Savings - 401(k)
Default Value: C

13 COBRA_SURCHARGE Number(2,0) SMALLINT NOT NULL COBRA Surcharge %

14 COBRA_DISABL_SURCG Number(2,0) SMALLINT NOT NULL COBRA Disabled Surcharge %

15 DEPENDENT_MARRIAGE Character(1) VARCHAR2(1) NOT NULL Dep Ineligible if Married
Y/N Table Edit
Default Value: N

16 FMLA_PLAN_ID Character(3) VARCHAR2(3) NOT NULL FMLA Plan ID

17 DEP_AGE_LIMIT Number(2,0) SMALLINT NOT NULL COBRA Dependent Age Limit
Default Value: 99

18 EXCL_DISABLED_AGE Character(1) VARCHAR2(1) NOT NULL Exclude Disabled from Age Lmt.
Y/N Table Edit
Default Value: Y

19 STUDENT_AGE_LIMIT Number(2,0) SMALLINT NOT NULL COBRA Student Age Limit
Default Value: 99

20 SHOW_CREDIT Character(1) VARCHAR2(1) NOT NULL This field tells the system whether or not to show credits on the enrollment form.
Y/N Table Edit
Default Value: Y

21 COST_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Cost Freq on Enrollment Form
A=Annual Frequency
D=Deduction Frequency
Default Value: A

22 HANDBOOK_URL_ID Character(30) VARCHAR2(30) NOT NULL This field holds the ID of a URL object. The URL object points to the companies enrollment handbook.
Prompt Table: PSURLDEFN

23 INCLD_CNSLSTX Character(1) VARCHAR2(1) NOT NULL Include Can Sales Tax on Form
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
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	PROGRAM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Program Type A=Automated M=Manual
7	FSA_RUN_ID	Character(3)	VARCHAR2(3) NOT NULL	Flexible Spending Acct Run ID
8	FSA_MIN_CHECK_AMT	Number(7,2)	DECIMAL(6,2) NOT NULL	FSA Minimum Check Amount
9	FSA_MAX_ANNL_PLDG	Number(9,2)	DECIMAL(8,2) NOT NULL	FSA Maximum Annual Pledge
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value. Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
11	DFLT_EXPIRATION_DD	Number(3,0)	SMALLINT NOT NULL	Number of Days Before Defaults
12	DFLT_CREDIT_RLLOVR	Character(1)	VARCHAR2(1) NOT NULL	Apply Excess Credits to C=Cash D=FSA - Dependent Care F=Forfeit Excess Credits H=FSA - Health Care R=FSA-Retirement Counseling S=Savings - 401(k) Default Value: C
13	COBRA_SURCHARGE	Number(2,0)	SMALLINT NOT NULL	COBRA Surcharge %
14	COBRA_DISABL_SURCG	Number(2,0)	SMALLINT NOT NULL	COBRA Disabled Surcharge %
15	DEPENDENT_MARRIAGE	Character(1)	VARCHAR2(1) NOT NULL	Dep Ineligible if Married Y/N Table Edit Default Value: N
16	FMLA_PLAN_ID	Character(3)	VARCHAR2(3) NOT NULL	FMLA Plan ID
17	DEP_AGE_LIMIT	Number(2,0)	SMALLINT NOT NULL	COBRA Dependent Age Limit Default Value: 99
18	EXCL_DISABLED_AGE	Character(1)	VARCHAR2(1) NOT NULL	Exclude Disabled from Age Lmt. Y/N Table Edit Default Value: Y
19	STUDENT_AGE_LIMIT	Number(2,0)	SMALLINT NOT NULL	COBRA Student Age Limit Default Value: 99
20	SHOW_CREDIT	Character(1)	VARCHAR2(1) NOT NULL	This field tells the system whether or not to show credits on the enrollment form. Y/N Table Edit Default Value: Y
21	COST_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Cost Freq on Enrollment Form A=Annual Frequency D=Deduction Frequency Default Value: A
22	HANDBOOK_URL_ID	Character(30)	VARCHAR2(30) NOT NULL	This field holds the ID of a URL object. The URL object points to the companies enrollment handbook. Prompt Table: PSURLDEFN
23	INCLD_CNSLSTX	Character(1)	VARCHAR2(1) NOT NULL	Include Can Sales Tax on Form Y/N Table Edit Default Value: N