BAS_STMTCAL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	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.
5	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
8	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
9	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
10	OPTION_ID	Number(4,0)	SMALLINT NOT NULL	Option ID
11	DISPLAY_PLN_SEQ	Character(2)	VARCHAR2(2) NOT NULL	Display Plan-type Sequence
12	OPTION_CD	Character(3)	VARCHAR2(3) NOT NULL	Option Code
13	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.
14	EVENT_DT	Date(10)	DATE	Event Date
15	FLAT_AMOUNT	Signed Number(9,0)	DECIMAL(8) NOT NULL	Flat Amount
16	PREMIUM_BASE	Number(11,2)	DECIMAL(10,2) NOT NULL	Premium Base
17	CALCULATED_BASE	Number(11,2)	DECIMAL(10,2) NOT NULL	Coverage Base
18	DED_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Deduction Classification A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit
19	ANNUAL_PLEDGE	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Annual Pledge
20	EMPL_CONTRBUTN_AMT	Number(7,2)	DECIMAL(6,2) NOT NULL	Employee Contribution Amount
21	COVERAGE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field is used to define the coverage level. 1=Plan Level 2=Employee Level
22	SUM_DEP_COVG	Character(1)	VARCHAR2(1) NOT NULL	This Field determines the if need to sum the dependent coverage amount or not.
23	COVERAGE_BEGIN_DT	Date(10)	DATE	Coverage Begin Date
24	DEDUCTION_BEGIN_DT	Date(10)	DATE	Deduction Begin Date
25	VACN_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Vacation Buy/Sell Hours
26	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
27	JOB_EFFDT	Date(10)	DATE	Job Effective Date
28	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
29	ANNL_AMT_A_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.
30	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.
31	DEDN_AMT_A_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.
32	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.
33	CNSLSTX_AMT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Canadian Sales Tax Amount
34	CNSLSTX_ANN_AMT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Canadian Annual Sales Tax Amt
35	TOTAL_CREDIT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Total All Credits
36	TOTAL_ANNL_CREDIT	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	Total All Credits