CAN_DENTAL_ELIG(SQL Table) |
Index Back |
|---|---|
Can Dental Care EligibilityCanadian Dental Care Eligibility Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: PY_COMPANY_VW |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PY_CO_EMP_VW
|
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: PY_CO_EM_RCD_VW |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | CAN_DEN_ACCESS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Level of access for Dental Cares Eligibility.
1=No Dental Access or coverage 2=Payee 3=Payee, Spouse and Dependents 4=Payee and Spouse 5=Payee and Dependents |