GPBR_ACM_INSS_T

(SQL Table)
Index Back

Accum Type INSS - MANAD

Accum Type INSS - Purpose : Used in MANAD Report

  • Parent record: EMPLMT_SRCH_GBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    5 GP_RPT_KEY Character(22) VARCHAR2(22) NOT NULL Output Result Key
    6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    7 GPBR_INSS_BSE_TYPE Character(1) VARCHAR2(1) NOT NULL INSS Base Type
    1=1-Monthly Salary Base
    2=2-13th Salary Base
    3=3-Payee Discounted Amount
    4=4-Family Salary Paid
    5=5-Maternity Salary Base
    6=6-Exclusive for FGTS Base
    7=7-Base Discount
    9=9-Other INSS Bases