EMPLIDPrompt Table: PERSON
EMPL_RCDPLAN_TYPEBENEFIT_NBREFFDTCAR_IDPrompt Table: CAR_DATA
START_DTCAR_NOTINUSE(SQL Table) |
Index Back |
|---|---|
Car Unavailability - UKCar Unavailability - UK |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 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_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. |
| 5 | EFFDT |
Date(10) | DATE | Effective Date |
| 6 | CAR_ID |
Character(7) | VARCHAR2(7) NOT NULL |
Car Identification Number used in Administer Company Cars module.
Prompt Table: CAR_DATA |
| 7 | START_DT |
Date(10) | DATE | Start Date |
| 8 | END_DT | Date(10) | DATE | end date |
| 9 | REASON_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Reason for Unavailability |