BN_SNAP_JOB

(SQL Table)
 Index Back

Snapshot EE Benefit Rcd Data

BN_SNAP_JOB is a "snapshot" of all Benefit Records held by an employee as of the user spcified "As Of" date. In addition, there will be one row per Benefit Record / Cobra Event whenever the employee has any enrollments due to Cobra. An index on COMPANY was added to improve the performance of the HIPAA EDI 834 Extract process.

  • Parent record: BN_SNAP_PER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
    3 COBRA_EVENT_ID Number(3,0) SMALLINT NOT NULL Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    5 HIRE_DT Date(10) DATE First Start Date
    6 JOB_EFFDT Date(10) DATE Job Effective Date
    7 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence
    8 EFFDT Date(10) DATE Effective Date
    9 SERVICE_DT Date(10) DATE Service Date
    10 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
    11 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    12 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    14 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
    GP=Global Payroll
    NA=Payroll for North America
    OT=Other
    PI=Payroll Interface
    15 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Pay
    Q=Retired With Pay
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Pay
    V=Terminated Pension Pay Out
    W=Short Work Break
    X=Retired-Pension Administration
    16 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    17 ACTION Character(3) VARCHAR2(3) NOT NULL Action
    18 ACTION_DT Date(10) DATE Action Date
    19 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    20 BN_ACA_ELIG_IND Character(1) VARCHAR2(1) NOT NULL ACA (Affordable Care Act) Eligibility Indicator
    A=Always Eligible
    E=Eligible
    I=Ineligible
    U=To be determined
    X=Excluded