EMPLIDEMPL_RCDEFFDTDefault Value: %date
PLAN_TYPEDEPENDENT_BENEF01=default
LANGUAGE_CDBEN_SRH_DEP_LNG(SQL Table) |
Index Back |
|---|---|
BEN_SRH_DEP_LNGRelated LNG for Benefits Insights dependent 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 | DEPENDENT_BENEF |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | RELATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Relationship Descr |
| 8 | COVRG_CODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Coverage Code Descr |
| 9 | 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"). |
| 10 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 11 | BUSINESS_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Business Description |
| 12 | EMPL_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Employee Type |
| 13 | REG_REGION_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Regulatory Region |
| 14 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 15 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |
| 16 | PLAN_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Plan Type Description |
| 17 | PLAN_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Plan Description |
| 18 | BENEFIT_PGM_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Benefit Program description |
| 19 | AGE_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status). |
| 20 | GENDER_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status). |
| 21 | ETHNIC_GRP_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status). |
| 22 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 23 | JOB_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Description |
| 24 | FULLPART_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Full and Part Time Descr |
| 25 | REGTEMP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Regular Temp description |
| 26 | PLAN_CAT_FILTER | Character(40) | VARCHAR2(40) NOT NULL | Filter used for Benefits Insights |
| 27 | COVRG_ELECT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Filter for Benefit Insights |
| 28 | PLAN_TYPE_DESCR02 | Character(30) | VARCHAR2(30) NOT NULL | Plan Type Descr for Insights |