EMPLIDEMPL_RCDEFFDTDefault Value: %date
PLAN_TYPELANGUAGE_CDBEN_SRH_HST_LNG(SQL Table) |
Index Back |
|---|---|
BEN_SRH_HST_LNGRelated LNG for Benefits Insights history migration data |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | 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. |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | COVRG_CODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Coverage Code Descr |
| 7 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 8 | BUSINESS_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Business Description |
| 9 | EMPL_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Employee Type |
| 10 | REG_REGION_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Regulatory Region |
| 11 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 12 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |
| 13 | BEN_PLAN_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Benefit Plan Description. May include a description of coverage (e.g. "3 times Salary", "$50,000"). |
| 14 | PLAN_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Plan Type Description |
| 15 | PLAN_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Plan Description |
| 16 | BENEFIT_PGM_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Benefit Program description |
| 17 | AGE_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status). |
| 18 | GENDER_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status). |
| 19 | ETHNIC_GRP_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status). |
| 20 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 21 | JOB_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Description |
| 22 | FULLPART_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Full and Part Time Descr |
| 23 | REGTEMP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Regular Temp description |
| 24 | PLAN_CAT_FILTER | Character(40) | VARCHAR2(40) NOT NULL | Filter used for Benefits Insights |
| 25 | COVRG_ELECT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Filter for Benefit Insights |
| 26 | PLAN_TYPE_DESCR02 | Character(30) | VARCHAR2(30) NOT NULL | Plan Type Descr for Insights |