W3EB_BENEF_SMRY(SQL Table) |
Index Back |
|---|---|
Benefit Election SummaryThis record is used to manage a work scroll that presents a snapshot of an employee's Benefits elections at a point in time. It is populated and used by the employee self-service InterNet/IntraNet application "Benefits Summary" . |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | 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. |
| 4 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 5 | COVERAGE_ELECT | Character(1) | VARCHAR2(1) NOT NULL |
Coverage Election
E=Elect T=Terminate W=Waive |
| 6 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | COVERAGE_BEGIN_DT | Date(10) | DATE | Coverage Begin Date |
| 10 | EFFDT | Date(10) | DATE | Effective Date |
| 11 | COVRG_CD | Character(2) | VARCHAR2(2) NOT NULL | Coverage Code |
| 12 | FLAT_AMOUNT | Signed Number(9,0) | DECIMAL(8) NOT NULL | Flat Amount |
| 13 | SAVINGS_COVRG | Character(1) | VARCHAR2(1) NOT NULL |
Savings Coverage
1=Flat Amount 2=Percent of Gross |
| 14 | FLAT_DED_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Flat Deduction Amount |
| 15 | PCT_GROSS | Number(7,3) | DECIMAL(6,3) NOT NULL | Percent of Gross |
| 16 | SAVINGS_COVRG_ATAX | Character(1) | VARCHAR2(1) NOT NULL |
Savings Coverage After-Tax
1=Flat Amount 2=Percent of Gross |
| 17 | FLAT_DED_AMT_ATAX | Number(9,2) | DECIMAL(8,2) NOT NULL | Flat Deduction Amt After-Tax |
| 18 | PCT_GROSS_ATAX | Number(7,3) | DECIMAL(6,3) NOT NULL | Percent of Gross After-Tax |
| 19 | ANNUAL_PLEDGE | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Annual Pledge |
| 20 | VOLUNTARY_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Voluntary Contribution Amount |
| 21 | VOLUNTARY_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Voluntary Contrib Pct |
| 22 | VACN_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Vacation Buy/Sell Hours |
| 23 | GVT_ASSIGNED | Character(1) | VARCHAR2(1) NOT NULL | Assigned? |
| 24 | GVT_DESCR8 | Character(8) | VARCHAR2(8) NOT NULL | Total Days in Service |
| 25 | INVESTMENT_CNT | Number(2,0) | SMALLINT NOT NULL | Investment Count |
| 26 | PB_WEB_DETAIL | Character(1) | VARCHAR2(1) NOT NULL |