EMPLIDEMPL_RCDPLAN_TYPE01=default
W3EB_SUMBYNM_VW(SQL View) |
Index Back |
|---|---|
Summary by Name ViewSummary by Name View |
| SELECT A.EMPLID , B.EMPL_RCD , B.PLAN_TYPE , A.DEPENDENT_BENEF , C.COVERAGE_BEGIN_DT , A.EFFDT , D.EFFDT , C.BENEFIT_PLAN , A.NAME , D.RELATIONSHIP FROM PS_DEP_BEN_NAME A , PS_DEP_BEN_EFF D , PS_HEALTH_DEPENDNT B , PS_HEALTH_BENEFIT C WHERE A.EMPLID = B.EMPLID AND A.EMPLID = D.EMPLID AND A.DEPENDENT_BENEF = B.DEPENDENT_BENEF AND B.EMPLID=C.EMPLID AND B.EMPL_RCD=C.EMPL_RCD AND B.COBRA_EVENT_ID = C.COBRA_EVENT_ID AND B.PLAN_TYPE=C.PLAN_TYPE AND B.BENEFIT_NBR = C.BENEFIT_NBR AND B.EFFDT = C.EFFDT AND C.COVERAGE_ELECT = 'E' AND A.DEPENDENT_BENEF = D.DEPENDENT_BENEF |
| # | 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 | DEPENDENT_BENEF | Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default |
| 5 | EFFDT | Date(10) | DATE | Effective Date |
| 6 | EFFDT_NM | Date(10) | DATE | Field for keeping the effdt for names field for a duplicate row check. |
| 7 | EFFDT_NEW | Date(10) | DATE | New Effective Date |
| 8 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 9 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 10 | RELATIONSHIP | Character(2) | VARCHAR2(2) NOT NULL | Relationship to Employee |