PPP_RC_BRA

(SQL Table)
 Index Back

PPP Run Control

PPP Run Control

  • Parent Record Of PPP_RC_ACT_BRA PPP_RC_DEPT_BRA PPP_RC_EMPL_BRA PPP_RC_EST_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).
    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 BEGIN_DT Date(10) DATE NOT NULL Begin Date
    5 END_DT Date(10) DATE NOT NULL end date
    6 PPP_PARAM_ID Character(10) VARCHAR2(10) NOT NULL PPP Parameter ID

    Prompt Table: PPP_PARAM_BRA

    7 RESPONSIBLE_ID_BRA Character(11) VARCHAR2(11) NOT NULL PPP Responsible Name

    Prompt Table: PERSON_NAME

    8 PPP_SEL_CRIT_BRA Character(1) VARCHAR2(1) NOT NULL PPP Selection Criteria
    1=Select Establishment ID
    2=Select Department ID
    3=Select Worker
    4=Select Group ID

    Default Value: 1

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

    Prompt Table: GB_GROUP_TBL

    10 PPP_OBSERV_OPT_BRA Character(3) VARCHAR2(3) NOT NULL Observation Option Brazil
    NOP=No Observation
    OVR=Override Observation
    PRI=Print Observation

    Default Value: NOP

    11 LOCATION_DTL_BRA Long Character CLOB Detailed Local Description
    12 DT_ISSUED Date(10) DATE NOT NULL Issue Date

    Default Value: %date