GPBR_RC_SALCON

(SQL Table)
 Index Back

INSS Salary Contrib Report BRA

Run control table INSS Salary Contribution Report for Brazil

  • Parent Record Of GPBR_RC_SALCONE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 GPBR_LIST_OPTION Character(1) VARCHAR2(1) NOT NULL List Option Brazil Run Control
    1=All Establishments & Employees
    2=Select Establishment ID
    3=Select Employees
    4=Select Group ID
    5=Select Pay Group
    6=All Employees
    7=Select Department ID

    Default Value: 1

    4 LEGAL_ENT_TYPE_BRA Character(3) VARCHAR2(3) NOT NULL Legal Entity Type Brazil (Company Name for Legal Reports)
    COM=Company
    EST=Establishment

    Default Value: COM

    5 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

    Prompt Table: ESTAB_TBL

    6 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

    Prompt Table: GB_GROUP_TBL

    7 GPBR_CRED_BGN_DT Date(10) DATE NOT NULL Credit Begin Date -- Vacations Brazil
    8 GPBR_CRED_END_DT Date(10) DATE NOT NULL Credit End Date Vacations Brazil