RC_WR_REC_BRA

(SQL Table)
 Index Back

Run Control Work Risk BRA

Run Control Work Risk BRA

  • Parent Record Of RC_WR_DEP_BRA RC_WR_EMP_BRA RC_WR_EST_BRA RC_WR_INC_BRA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPERATOR_VW

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    4 CAT_VIANUMBER_BRA Number(2,0) SMALLINT NOT NULL Via number CAT

    Default Value: 1

    5 CAT_DATE_BRA Date(10) DATE Date CAT Brazil
    6 CAT_END_DATE_BRA Date(10) DATE CAT end Date Brazil
    7 CAT_EMITED_BY_BRA Character(1) VARCHAR2(1) NOT NULL CAT Emitted by
    1=Employer
    2=Union
    3=Doctor
    4=Seg o Dependen
    5=Authority Public
    8 DATE_FROM Date(10) DATE Date From
    9 CAT_LOC_DESCR_BRA Character(200) VARCHAR2(200) NOT NULL Location description CAT Brazil
    10 CAT_EMIT_NAME_BRA Character(30) VARCHAR2(30) NOT NULL Emitted Name
    11 CAT_LIST_OPT_BRA Character(1) VARCHAR2(1) NOT NULL CAT List Options
    1=All Establishments & Payees
    2=Select Establishment ID
    3=Select Employee
    4=Select Group ID
    5=Select Pay Group
    6=Select Hire Date
    7=Select Department ID
    8=Select Incident ID

    Default Value: 2

    12 CAT_EXCL_FLG_BRA Character(1) VARCHAR2(1) NOT NULL Exclude Flag 1 Run Control CAT Brazil

    Y/N Table Edit

    Default Value: N