GPBR_MANAD_RESP

(SQL Table)
Index Back

MANAD Parameters BRA

MANAD Parameters BRA

  • Parent record: GPBR_ESTAB2_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

    Prompt Table: GPBR_ESTAB2_VW

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 GPBR_RESP_TYPE Character(1) VARCHAR2(1) NOT NULL Responsible Type
    1=Company
    2=Employee
    3=Non Employee
    4=Establishment

    Default Value: 1

    5 GPBR_RESP_NAME Character(50) VARCHAR2(50) NOT NULL MANAD Responsible
    6 GPBR_END_DATE Date(10) DATE End Date End Date Service for MANAD
    7 GPBR_RESP_ID Character(10) VARCHAR2(10) NOT NULL Responsible ID DIRF

    Prompt Table: %GP_EDIT_FLD3

    8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_SRCH_EMP

    9 GPBR_RESP_COMPANY Character(50) VARCHAR2(50) NOT NULL MANAD Responsible
    10 GPBR_RESP_CNPJ Character(15) VARCHAR2(15) NOT NULL CNPJ of MANAD's Responsible
    11 GPBR_RESP_CPF Character(15) VARCHAR2(15) NOT NULL CPF of MANAD's Responsible
    12 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    13 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
    14 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address