EMPLIDEMPL_RCDEFFDTE=Elect
T=Terminate
W=Waive
ST_SAV_PLAN_VW(SQL View) |
Index Back |
|---|---|
Savings Plan View |
| SELECT B.EMPLID ,B.EMPL_RCD ,B.EFFDT ,B.EFFDT ,B.DEDUCTION_END_DT ,B.COVERAGE_BEGIN_DT ,B.COVERAGE_END_DT ,B.COVERAGE_ELECT ,B.COVERAGE_ELECT_DT ,B.BENEFIT_PLAN ,B.FLAT_DED_AMT_ATAX ,B.PCT_GROSS_ATAX FROM PS_SAVINGS_PLAN B WHERE B.PLAN_TYPE = '4A' |
| # | 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 Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | DEDUCTION_BEGIN_DT | Date(10) | DATE | Deduction Begin Date |
| 5 | DEDUCTION_END_DT | Date(10) | DATE | Deduction End Date |
| 6 | COVERAGE_BEGIN_DT | Date(10) | DATE | Coverage Begin Date |
| 7 | COVERAGE_END_DT | Date(10) | DATE | Coverage End Date |
| 8 | COVERAGE_ELECT | Character(1) | VARCHAR2(1) NOT NULL |
Coverage Election
E=Elect T=Terminate W=Waive |
| 9 | COVERAGE_ELECT_DT | Date(10) | DATE | Coverage Elect Date |
| 10 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 11 | FLAT_DED_AMT_ATAX | Number(9,2) | DECIMAL(8,2) NOT NULL | Flat Deduction Amt After-Tax |
| 12 | PCT_GROSS_ATAX | Number(7,3) | DECIMAL(6,3) NOT NULL | Percent of Gross After-Tax |