CALC_RULES_TBL (SQL Table)	Index Back
Benefit Calculation Rules This table is used to define rules for determining rates and calculating deduction amounts for certain rate-driven benefits, such as health, life, and disability (and rate-based flexible credits).

CALC_RULES_TBL

(SQL Table)

Benefit Calculation Rules

This table is used to define rules for determining rates and calculating deduction amounts for certain rate-driven benefits, such as health, life, and disability (and rate-based flexible credits).

Related Language Record: CALC_RULES_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CALC_RULES_ID Character(4) VARCHAR2(4) NOT NULL Calculation Rules Table ID

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

5 AGE_AS_OF_CD Character(1) VARCHAR2(1) NOT NULL This rule tells the system what reference date to use when determining the Age needed for a rate calculation.
C=Check Date
E=Initial Coverage Date
L=Last Year On
N=Next/Check Date
P=Pay End Date
T=This Year On
Default Value: C

6 AGE_AS_OF_MM Number(2,0) SMALLINT NOT NULL Age As Of Month

7 AGE_AS_OF_DD Number(2,0) SMALLINT NOT NULL Age As Of Day

8 SERVICE_AS_OF_CD Character(1) VARCHAR2(1) NOT NULL This rule tells the system what reference date to use when determining length of Service as a criteria for a rate calculation.
C=Check Date
L=Last Year On
P=Pay End Date
T=This Year On
Default Value: C

9 SERVICE_AS_OF_MM Number(2,0) SMALLINT NOT NULL Service As Of Month

10 SERVICE_AS_OF_DD Number(2,0) SMALLINT NOT NULL Service As Of Day

11 AGE_SOURCE Character(1) VARCHAR2(1) NOT NULL This rule tells the system where to obtain demographic information when needed by a benefit rate. It instructs the system to either use the Employee's data, or to use data specific to the individual(s) being covered.
D=Covered Dependent
E=Employee
S=Spouse/Partner
Default Value: E

12 BENBASE_AS_OF_CD Character(1) VARCHAR2(1) NOT NULL This rule tells the system what reference date to use when determining the Benefits Base needed for a rate calculation.
C=Check Date
L=Last Year On
P=Pay End Date
T=This Year On
Default Value: C

13 BENBASE_AS_OF_MM Number(2,0) SMALLINT NOT NULL When a Benefits Base "As-Of" rule indicates a derived calendar date, this field specifies the month to be used.

14 BENBASE_AS_OF_DD Number(2,0) SMALLINT NOT NULL When a Benefits Base "As-Of" rule indicates a derived calendar date, this field specifies the day of the month to be used.

15 BENEFITS_BASE Character(1) VARCHAR2(1) NOT NULL Benefits Base
1=Annual Rate
2=Annual Benefits Base Rate
Default Value: 1

16 BN_ANNL_BENBASE_CD Character(4) VARCHAR2(4) NOT NULL Identifies the type of Annual Benefits Base Rate
Default Value: PRIM
Prompt Table: ABBR_TYPE_TBL

17 COMBINE_MULT_SAL Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether salary or benefit base should be combined across multiple jobs into an aggregate base for use in a rate or coverage calculation.
Y/N Table Edit
Default Value: N

18 GRP_MTHD Character(1) VARCHAR2(1) NOT NULL Group Method
1=Primary Job in Benefit Record
2=Flagged Jobs in Benefit Record
3=All Flagged Jobs
Default Value: 1

19 EVAL_ACTV Character(1) VARCHAR2(1) NOT NULL Consider Active Jobs Only
Y/N Table Edit
Default Value: N

20 MAX_PAY_DED_LIM Number(6,3) DECIMAL(5,3) NOT NULL This field is used to define an optional limit on the amount of a deduction, expressed as a maximum percentage of the employee's gross pay.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CALC_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Calculation Rules Table ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
5	AGE_AS_OF_CD	Character(1)	VARCHAR2(1) NOT NULL	This rule tells the system what reference date to use when determining the Age needed for a rate calculation. C=Check Date E=Initial Coverage Date L=Last Year On N=Next/Check Date P=Pay End Date T=This Year On Default Value: C
6	AGE_AS_OF_MM	Number(2,0)	SMALLINT NOT NULL	Age As Of Month
7	AGE_AS_OF_DD	Number(2,0)	SMALLINT NOT NULL	Age As Of Day
8	SERVICE_AS_OF_CD	Character(1)	VARCHAR2(1) NOT NULL	This rule tells the system what reference date to use when determining length of Service as a criteria for a rate calculation. C=Check Date L=Last Year On P=Pay End Date T=This Year On Default Value: C
9	SERVICE_AS_OF_MM	Number(2,0)	SMALLINT NOT NULL	Service As Of Month
10	SERVICE_AS_OF_DD	Number(2,0)	SMALLINT NOT NULL	Service As Of Day
11	AGE_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	This rule tells the system where to obtain demographic information when needed by a benefit rate. It instructs the system to either use the Employee's data, or to use data specific to the individual(s) being covered. D=Covered Dependent E=Employee S=Spouse/Partner Default Value: E
12	BENBASE_AS_OF_CD	Character(1)	VARCHAR2(1) NOT NULL	This rule tells the system what reference date to use when determining the Benefits Base needed for a rate calculation. C=Check Date L=Last Year On P=Pay End Date T=This Year On Default Value: C
13	BENBASE_AS_OF_MM	Number(2,0)	SMALLINT NOT NULL	When a Benefits Base "As-Of" rule indicates a derived calendar date, this field specifies the month to be used.
14	BENBASE_AS_OF_DD	Number(2,0)	SMALLINT NOT NULL	When a Benefits Base "As-Of" rule indicates a derived calendar date, this field specifies the day of the month to be used.
15	BENEFITS_BASE	Character(1)	VARCHAR2(1) NOT NULL	Benefits Base 1=Annual Rate 2=Annual Benefits Base Rate Default Value: 1
16	BN_ANNL_BENBASE_CD	Character(4)	VARCHAR2(4) NOT NULL	Identifies the type of Annual Benefits Base Rate Default Value: PRIM Prompt Table: ABBR_TYPE_TBL
17	COMBINE_MULT_SAL	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether salary or benefit base should be combined across multiple jobs into an aggregate base for use in a rate or coverage calculation. Y/N Table Edit Default Value: N
18	GRP_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Group Method 1=Primary Job in Benefit Record 2=Flagged Jobs in Benefit Record 3=All Flagged Jobs Default Value: 1
19	EVAL_ACTV	Character(1)	VARCHAR2(1) NOT NULL	Consider Active Jobs Only Y/N Table Edit Default Value: N
20	MAX_PAY_DED_LIM	Number(6,3)	DECIMAL(5,3) NOT NULL	This field is used to define an optional limit on the amount of a deduction, expressed as a maximum percentage of the employee's gross pay.