BEN_SRCH_DEP_VW

(SQL View)
 Index Back

Benefits DEP Search

dependent data

SELECT A.EMPLID , A.EMPL_RCD , A.PLAN_TYPE , A.EFFDT , A.DEPENDENT_BENEF , A.RELATIONSHIP , A.RELATION_DESCR , A.COVERAGE_ELECT , A.COVRG_CODE_DESCR , A.BENEFIT_PLAN , A.BEN_PLAN_DESCR , A.BENEFIT_PROGRAM , 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.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.ASOFDATE FROM PS_BEN_SRCH_PLNDEP A

  • Related Language Record: BEN_SRH_DEP_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 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
    01=default
    6 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
    7 RELATION_DESCR Character(30) VARCHAR2(30) NOT NULL Relationship Descr
    8 COVERAGE_ELECT Character(1) VARCHAR2(1) NOT NULL Coverage Election
    E=Elect
    T=Terminate
    W=Waive
    9 COVRG_CODE_DESCR Character(30) VARCHAR2(30) NOT NULL Coverage Code Descr
    10 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
    11 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").
    12 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
    13 CALENDAR_YR Number(4,0) SMALLINT NOT NULL Year
    14 COVRG_CD Character(2) VARCHAR2(2) NOT NULL Coverage Code
    15 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
    16 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    17 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    18 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description
    19 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    20 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    21 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    22 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    23 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    24 EMPL_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Employee Type
    25 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    26 REG_REGION_DESCR Character(50) VARCHAR2(50) NOT NULL Regulatory Region
    27 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
    28 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description
    29 PLAN_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Plan Type Description
    30 PLAN_DESCR Character(40) VARCHAR2(40) NOT NULL Plan Description
    31 BENEFIT_PGM_DESCR Character(30) VARCHAR2(30) NOT NULL Benefit Program description
    32 AGE Number(3,0) SMALLINT NOT NULL Age
    33 AGE_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
    34 GENDER_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
    35 ETHNIC_GRP_DESCR Character(100) VARCHAR2(100) NOT NULL Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
    36 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description
    37 JOB_DESCR Character(30) VARCHAR2(30) NOT NULL Job Description
    38 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    39 CITY Character(30) VARCHAR2(30) NOT NULL City
    40 STATE Character(6) VARCHAR2(6) NOT NULL State
    41 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    42 FULLPART_DESCR Character(30) VARCHAR2(30) NOT NULL Full and Part Time Descr
    43 REGTEMP_DESCR Character(30) VARCHAR2(30) NOT NULL Regular Temp description
    44 PLAN_CAT_FILTER Character(40) VARCHAR2(40) NOT NULL Filter used for Benefits Insights
    45 COVRG_ELECT_DESCR Character(20) VARCHAR2(20) NOT NULL Filter for Benefit Insights
    46 PLAN_TYPE_DESCR02 Character(30) VARCHAR2(30) NOT NULL Plan Type Descr for Insights
    47 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.