GPNL_EE_ADL_DTL

(SQL Table)
Index Back

EE Additional Insurance Detail

GPNL Employee Additional Insurance Details

  • Parent record: GPNL_EE_ADL_INS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 GPNL_INS_CD Character(6) VARCHAR2(6) NOT NULL GPNL_INS_CD

    Default Value: GPNL_INS_PREMM.GPNL_INS_CD

    5 GPNL_INS_NBR Character(3) VARCHAR2(3) NOT NULL Insurance Number
    6 GPNL_ADDT_CNT_MTHD Character(2) VARCHAR2(2) NOT NULL ZFW Contribution Method
    00=No Premium
    01=Employee/Total
    02=No Employee/Total
    03=No Employee/Employer

    Default Value: 01

    7 GPNL_INS_OVRD Character(1) VARCHAR2(1) NOT NULL GPNL_INS_OVRD

    Y/N Table Edit

    Default Value: N

    8 GPNL_EE_PCT1 Number(7,3) DECIMAL(6,3) NOT NULL Employee Percentage 1
    9 GPNL_EE_PCT2 Number(7,3) DECIMAL(6,3) NOT NULL GPNL_EE_PCT2
    10 GPNL_TTL_PCT1 Number(7,3) DECIMAL(6,3) NOT NULL Total Percentage 1
    11 GPNL_TTL_PCT2 Number(7,3) DECIMAL(6,3) NOT NULL Total Percentage 2
    12 GPNL_INC_PCT_EE Number(7,3) DECIMAL(6,3) NOT NULL GPNL_INC_PCT_EE
    13 GPNL_INC_PCT_ER Number(7,3) DECIMAL(6,3) NOT NULL Increase Percentage Employer Premium