QCK_POST_ERRVW3

(SQL View)
 Index Back

Quick Posting Error View 2


SELECT DISTINCT a.business_unit , a.oprid , a.grp_timestamp , b.message_nbr , c.language_cd , b.message_set_nbr , b.ssf_error_warn FROM ps_quick_post_tbl a , ps_quick_post_err b , PSOPRDEFN c WHERE a.business_unit = b.business_unit AND a.oprid = b.oprid AND a.grp_timestamp = b.grp_timestamp AND a.oprid = c.oprid

  • Parent record: GROUP_LINE

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

    Prompt Table: SP_BU_SF_NONVW

    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPR_DEF_TBL_CS

    3 GRP_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Group Line Time Stamp
    4 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    7 SSF_ERROR_WARN Character(1) VARCHAR2(1) NOT NULL Field to hold translate values for Message Types - Error/Warning/Message
    E=Error
    M=Message
    W=Warning