CANC_MSG_BAT_VW

(SQL View)
 Index Back

Canc Msg Batch View


SELECT DISTINCT business_unit , batch_id , oprid , batch_run_date FROM PS_CANC_MESSAGES

  • Parent Record Of CANC_MSG_EMP_VW LATE_MSG_B_E_VW LATE_MSG_B_O_VW LATE_MSG_EMP_VW LATE_MSG_ORG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

    Prompt Table: SP_BU_SF_NONVW

    2 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID
    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 BATCH_RUN_DATE Date(10) DATE Batch Run Date