GPBR_ST_ESTABID

(SQL Table)
 Index Back

Establishments by S. Taker

Establishments by Service Taker

  • Parent record: GPBR_SERV_TAKER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPBR_SERVICE_TAKER Character(3) VARCHAR2(3) NOT NULL Service Taker

    Prompt Table: GPBR_SERV_TAKER

    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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

    Prompt Table: GPBR_ESTAB2_VW

    4 TP_SERV_TAKER_BRA Character(2) VARCHAR2(2) NOT NULL Service Taker Type
    04=Legal Entity
    05=ST-Temp Work- Replace of Staff
    06=ST-Temp Work- Contingent Work

    Default Value: 04

    5 TP_OWNER_BRA Character(1) VARCHAR2(1) NOT NULL CNO Owner
    0=Not Applicable
    1=Estab
    2=Service Taker
    3=Other CNPJ
    4=Other CPF

    Default Value: 0

    6 OWNER_INSCR_BRA Character(14) VARCHAR2(14) NOT NULL CNPJ of the CNO Owner's
    7 GPBR_CNTRCT_BGN_DT Date(10) DATE NOT NULL Contract Begin Date for Service Takers Bra