UPG_BN_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
4	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
5	AE_STEP	Character(8)	VARCHAR2(8) NOT NULL	Name
6	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.
7	SQL_ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.
8	RESULT_CD	Number(3,0)	SMALLINT NOT NULL	Convenient AE State Record field for managing the Return Code from a PeopleCode Call.
9	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
11	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
14	EFFDT	Date(10)	DATE	Effective Date
15	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
16	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID
17	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification
18	EVENT_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Event Classification
19	EVENT_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Event Priority
20	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
21	COBRA_EVENT_ID	Number(3,0)	SMALLINT NOT NULL	Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
22	COBRA_EVENT_CLASS	Character(3)	VARCHAR2(3) NOT NULL	COBRA Event Classification
23	DUMMY_KEY_NUM	Number(11,0)	DECIMAL(11) NOT NULL	Dummy Key
24	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
25	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
26	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
27	PRIOR_CALENDAR_YR	Number(4,0)	SMALLINT NOT NULL	Prior Calendar Year
28	BEGIN_DT	Date(10)	DATE	Begin Date
29	END_DT	Date(10)	DATE	end date
30	DED_YTD_MAX	Number(11,2)	DECIMAL(10,2) NOT NULL	Maximum Yearly Deduction
31	BENEF_CONTACT_ID	Number(3,0)	SMALLINT NOT NULL	Used to identify a contact name/address
32	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name
33	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
34	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
35	AGE_RATE_SEX	Character(1)	VARCHAR2(1) NOT NULL	Insurance Rate Sex
36	AGE_RATE_TBL_ID	Character(4)	VARCHAR2(4) NOT NULL	Age-Graded Rate Table ID
37	END_DATE	Date(10)	DATE	End Date
38	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
39	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
40	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
41	FACTOR_XSALARY	Number(5,3)	DECIMAL(4,3) NOT NULL	Factor
42	FLAT_AMOUNT	Signed Number(9,0)	DECIMAL(8) NOT NULL	Flat Amount
43	CALC_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Calculation Rules Table ID
44	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
45	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.
46	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.
47	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
48	COVRG_AS_OF_DD	Number(2,0)	SMALLINT NOT NULL	Coverage Salary As Of Day
49	COVRG_AS_OF_MM	Number(2,0)	SMALLINT NOT NULL	Coverage Salary As Of Month
50	BENEFITS_BASE	Character(1)	VARCHAR2(1) NOT NULL	Benefits Base 1=Annual Rate 2=Annual Benefits Base Rate
51	BN_ANNL_BENBASE_CD	Character(4)	VARCHAR2(4) NOT NULL	Identifies the type of Annual Benefits Base Rate
52	MAX_BENEF_BASE	Number(11,2)	DECIMAL(10,2) NOT NULL	Maximum Benefit Base
53	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.
54	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
55	EVAL_ACTV	Character(1)	VARCHAR2(1) NOT NULL	Consider Active Jobs Only
56	USE_ROUNDING_RULES	Character(1)	VARCHAR2(1) NOT NULL	Use Rounding Rules
57	ROUND_BASE	Character(1)	VARCHAR2(1) NOT NULL	Round Benefits Base
58	ROUND_BASE_FLAT	Character(1)	VARCHAR2(1) NOT NULL	Round Benefits Base + Flat Amt
59	ROUND_FACTORED	Character(1)	VARCHAR2(1) NOT NULL	Round Factored Base W/O Flat
60	ROUND_FINAL	Character(1)	VARCHAR2(1) NOT NULL	Round Final Calced Coverage
61	ADD_FLAT_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Round Benefits Base
62	ROUND_TO	Number(5,0)	INTEGER NOT NULL	Round to Multiple of
63	ROUND_UP_AMT	Number(7,2)	DECIMAL(6,2) NOT NULL	Round Up Amount
64	COVERAGE_MAXIMUM	Number(8,0)	INTEGER NOT NULL	Coverage Maximum
65	COVERAGE_MINIMUM	Number(8,0)	INTEGER NOT NULL	Coverage Minimum
66	FORMULA_ID	Character(10)	VARCHAR2(10) NOT NULL	Calculation Formula ID
67	FORMULA_ROOT	Character(9)	VARCHAR2(9) NOT NULL	Calculation Formula ID
68	MAXIMUM_TAX	Number(8,2)	DECIMAL(7,2) NOT NULL	Maximum Tax
69	SALARY_REPLACE_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Salary Replacement %
70	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.
71	ASOFDATE	Date(10)	DATE	As of Date
72	BASE_ANNUAL_RATE	Number(19,3)	DECIMAL(18,3) NOT NULL	Base Annual Rate
73	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
74	ANNL_BENEF_BASE_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.
75	FSA_MIN_CHECK_AMT	Number(7,2)	DECIMAL(6,2) NOT NULL	FSA Minimum Check Amount
76	YTD_402G_CAP_USED	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	402(g) Cap Extension Used YTD
77	TEXT_ID	Character(18)	VARCHAR2(18) NOT NULL	Text ID
78	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
79	ANNL_AMT_B_TAX	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This field holds the tax-class detail for an Option's annual cost as calculated by Benefits Administration. The "employer" cost represents the sum of any N-Tax and T-Tax cost components.
80	DEDN_AMT_B_TAX	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This field holds the tax-class detail for an Option's per-pay-period cost as calculated by Benefits Administration. The "employer" cost represents the sum of any N-Tax and T-Tax cost components.
81	W3EB_TEXT	Long Character(8095)	CLOB	Text