BN_FORMULA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BN_FORMULA_ID	Character(10)	VARCHAR2(10) NOT NULL	This field is key for defining the formula and formula can be uniquely identified by this field.
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	BENEFITS_BASE	Character(1)	VARCHAR2(1) NOT NULL	Benefits Base 1=Annual Rate 2=Annual Benefits Base Rate Default Value: 1
6	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
7	COVRG_AS_OF_CD	Character(1)	VARCHAR2(1) NOT NULL	Coverage Salary As Of Code C=Check Date L=Last Year On P=Pay End Date T=This Year On Default Value: C
8	COVRG_AS_OF_MM	Number(2,0)	SMALLINT NOT NULL	Coverage Salary As Of Month
9	COVRG_AS_OF_DD	Number(2,0)	SMALLINT NOT NULL	Coverage Salary As Of Day
10	PREM_AS_OF_CD	Character(1)	VARCHAR2(1) NOT NULL	Premium Salary As Of Code C=Check Date L=Last Year On P=Pay End Date T=This Year On Default Value: C
11	PREM_AS_OF_DD	Number(2,0)	SMALLINT NOT NULL	Premium Salary As Of Day
12	PREM_AS_OF_MM	Number(2,0)	SMALLINT NOT NULL	Premium Salary As Of Month
13	MAX_BENEF_BASE	Number(11,2)	DECIMAL(10,2) NOT NULL	Maximum Benefit Base
14	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
15	EVAL_ACTV	Character(1)	VARCHAR2(1) NOT NULL	Consider Active Jobs Only Y/N Table Edit Default Value: N
16	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
17	COVERAGE_MINIMUM	Number(8,0)	INTEGER NOT NULL	Coverage Minimum
18	COVERAGE_MAXIMUM	Number(8,0)	INTEGER NOT NULL	Coverage Maximum