W3EB_DEPBEN_SUM(SQL Table) |
Index Back |
---|---|
DependBenef Coverage SummaryThis record is used to manage a work scroll that presents a snapshot of an employee's covered Dependents or Beneficiaries 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 | DEPENDENT_BENEF | Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default |
3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
4 | RELATIONSHIP | Character(2) | VARCHAR2(2) NOT NULL | Relationship to Employee |
5 | DT_OF_DEATH | Date(10) | DATE | Date of Death |
6 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description |
7 | 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. |
8 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
9 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
10 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: PER_ORG_ASGN_VW |
11 | COBRA_EVENT_ID | Number(3,0) | SMALLINT NOT NULL | Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated. |
12 | BENEFIT_NBR | Number(3,0) | SMALLINT NOT NULL | Note! Although this field is part of the index schema for most Base Benefits enrollment-related records, it was in fact never functionally implemented. As such, it is CRITICAL that this field always be set to zero 0. |
13 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
14 | PB_WEB_DETAIL | Character(1) | VARCHAR2(1) NOT NULL |