UPG_BN1_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	PGM_FLOW_CNTL	Character(1)	VARCHAR2(1) NOT NULL	Convenient AE State Record field for receiving result of a Do-When, Do-While, Do-Until, or other program flow control flag.
5	FACTOR_XSALARY	Number(5,3)	DECIMAL(4,3) NOT NULL	Factor
6	FLAT_AMOUNT	Signed Number(9,0)	DECIMAL(8) NOT NULL	Flat Amount
7	CALC_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Calculation Rules Table ID
8	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
9	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.
10	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.
11	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
12	COVRG_AS_OF_DD	Number(2,0)	SMALLINT NOT NULL	Coverage Salary As Of Day
13	COVRG_AS_OF_MM	Number(2,0)	SMALLINT NOT NULL	Coverage Salary As Of Month
14	BENEFITS_BASE	Character(1)	VARCHAR2(1) NOT NULL	Benefits Base 1=Annual Rate 2=Annual Benefits Base Rate
15	BN_ANNL_BENBASE_CD	Character(4)	VARCHAR2(4) NOT NULL	Identifies the type of Annual Benefits Base Rate
16	MAX_BENEF_BASE	Number(11,2)	DECIMAL(10,2) NOT NULL	Maximum Benefit Base
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.
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
19	EVAL_ACTV	Character(1)	VARCHAR2(1) NOT NULL	Consider Active Jobs Only
20	USE_ROUNDING_RULES	Character(1)	VARCHAR2(1) NOT NULL	Use Rounding Rules
21	ROUND_BASE	Character(1)	VARCHAR2(1) NOT NULL	Round Benefits Base
22	ROUND_BASE_FLAT	Character(1)	VARCHAR2(1) NOT NULL	Round Benefits Base + Flat Amt
23	ROUND_FACTORED	Character(1)	VARCHAR2(1) NOT NULL	Round Factored Base W/O Flat
24	ROUND_FINAL	Character(1)	VARCHAR2(1) NOT NULL	Round Final Calced Coverage
25	ADD_FLAT_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Round Benefits Base
26	ROUND_TO	Number(5,0)	INTEGER NOT NULL	Round to Multiple of
27	ROUND_UP_AMT	Number(7,2)	DECIMAL(6,2) NOT NULL	Round Up Amount
28	COVERAGE_MAXIMUM	Number(8,0)	INTEGER NOT NULL	Coverage Maximum
29	COVERAGE_MINIMUM	Number(8,0)	INTEGER NOT NULL	Coverage Minimum
30	FORMULA_ID	Character(10)	VARCHAR2(10) NOT NULL	Calculation Formula ID
31	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.
32	FORMULA_ROOT	Character(9)	VARCHAR2(9) NOT NULL	Calculation Formula ID
33	MAXIMUM_TAX	Number(8,2)	DECIMAL(7,2) NOT NULL	Maximum Tax
34	SALARY_REPLACE_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Salary Replacement %