BEN_SRCH_HST_VW

(SQL View)
 Index Back

Benefits migration view

Migration data for Benefits Insights

SELECT A.EMPLID , A.EMPL_RCD , A.PLAN_TYPE , A.EFFDT , A.BENEFIT_PROGRAM , A.COVERAGE_ELECT , A.COVRG_CODE_DESCR , A.BENEFIT_PLAN , A.CALENDAR_YR , A.COVRG_CD , A.PLAN_CATEGORY , A.NAME_DISPLAY , A.BUSINESS_UNIT , A.BUSINESS_DESCR , A.DEPTID , A.JOBCODE , A.REG_TEMP , A.FULL_PART_TIME , A.EMPL_TYPE , A.EMPL_TYPE_DESCR , A.REG_REGION , 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 , A.AGE_DESCR , A.GENDER_DESCR , A.ETHNIC_GRP_DESCR , A.LOCATION_DESCR , A.JOB_DESCR , A.COUNTRY , A.CITY , A.STATE , A.POSTAL , A.FULLPART_DESCR , A.REGTEMP_DESCR , A.PLAN_CAT_FILTER , A.COVRG_ELECT_DESCR , A.PLAN_TYPE_DESCR02 , A.COVERAGE_BEGIN_DT , A.ASOFDATE FROM PS_BEN_SRCH_PLNHST A

  • Related Language Record: BEN_SRH_HST_LVW

    • # 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 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
    6 COVERAGE_ELECT Character(1) VARCHAR2(1) NOT NULL Coverage Election
    E=Elect
    T=Terminate
    W=Waive
    7 COVRG_CODE_DESCR Character(30) VARCHAR2(30) NOT NULL Coverage Code Descr
    8 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
    9 CALENDAR_YR Number(4,0) SMALLINT NOT NULL Year
    10 COVRG_CD Character(2) VARCHAR2(2) NOT NULL Coverage Code
    11 PLAN_CATEGORY Character(1) VARCHAR2(1) NOT NULL This is used to identify a category of Benefits Plans, based on their common functional attributes.
    1=Health Benefits
    2=Life and Accidental Death
    3=Disability Insurance
    4=Savings Plans
    5=Leave
    6=Spending Accounts
    7=Retirement Plans
    8=Pension Plans
    9=Vacation Buy and Sell
    A=Simple Benefits
    12 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    14 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description
    15 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    16 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    17 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    18 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    19 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    20 EMPL_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Employee Type
    21 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    22 REG_REGION_DESCR Character(50) VARCHAR2(50) NOT NULL Regulatory Region
    23 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
    24 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description
    25 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").
    26 PLAN_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Plan Type Description
    27 PLAN_DESCR Character(40) VARCHAR2(40) NOT NULL Plan Description
    28 BENEFIT_PGM_DESCR Character(30) VARCHAR2(30) NOT NULL Benefit Program description
    29 AGE Number(3,0) SMALLINT NOT NULL Age
    30 AGE_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
    31 GENDER_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
    32 ETHNIC_GRP_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
    33 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description
    34 JOB_DESCR Character(30) VARCHAR2(30) NOT NULL Job Description
    35 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    36 CITY Character(30) VARCHAR2(30) NOT NULL City
    37 STATE Character(6) VARCHAR2(6) NOT NULL State
    38 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    39 FULLPART_DESCR Character(30) VARCHAR2(30) NOT NULL Full and Part Time Descr
    40 REGTEMP_DESCR Character(30) VARCHAR2(30) NOT NULL Regular Temp description
    41 PLAN_CAT_FILTER Character(40) VARCHAR2(40) NOT NULL Filter used for Benefits Insights
    42 COVRG_ELECT_DESCR Character(20) VARCHAR2(20) NOT NULL Filter for Benefit Insights
    43 PLAN_TYPE_DESCR02 Character(30) VARCHAR2(30) NOT NULL Plan Type Descr for Insights
    44 COVERAGE_BEGIN_DT Date(10) DATE Coverage Begin Date
    45 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.