EMPLIDEMPL_RCDEMPL_RCD_OTHPLAN_TYPELANGUAGE_CDBEN_SRH_EE_LVW(SQL View) |
Index Back |
|---|---|
BEN_SRH_EE_LVWRelated LNG for Benefits Insights employee data view |
| SELECT A.EMPLID , A.EMPL_RCD , A.EMPL_RCD_OTH , A.PLAN_TYPE , A.LANGUAGE_CD , A.COVRG_CODE_DESCR , A.NAME_DISPLAY , A.BUSINESS_DESCR , A.EMPL_TYPE_DESCR , A.REG_REGION_DESCR , A.DEPT_DESCR , A.JOBCODE_DESCR , A.BEN_PLAN_DESCR , A.PLAN_TYPE_DESCR , A.PLAN_DESCR , A.BENEFIT_PGM_DESCR , A.AGE_DESCR , A.GENDER_DESCR , A.ETHNIC_GRP_DESCR , A.LOCATION_DESCR , A.JOB_DESCR , A.FULLPART_DESCR , A.REGTEMP_DESCR , A.PLAN_CAT_FILTER , A.COVRG_ELECT_DESCR , A.PLAN_TYPE_DESCR02 FROM PS_BEN_SRH_EE_LNG A |
| # | 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 | EMPL_RCD_OTH |
Number(3,0) | SMALLINT NOT NULL | Other Employment Record |
| 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 |