QCK_POST_ERR_VW

(SQL View)
 Index Back

Quick Posting Error View


SELECT a.business_unit , a.oprid , a.grp_timestamp , a.line_seq_nbr , b.message_nbr , b.message_set_nbr , a.payment_id_nbr , b.ssf_error_warn , a.emplid FROM PS_QUICK_POST_TBL a , ps_quick_post_err b , ps_payment_tbl c WHERE a.business_unit = b.business_unit AND a.oprid = b.oprid AND a.grp_timestamp = b.grp_timestamp AND a.line_seq_nbr = b.line_seq_nbr AND a.business_unit = c.business_unit AND a.payment_id_nbr = c.payment_id_nbr AND a.emplid = c.common_id AND c.sa_id_type = 'P'

  • 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 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    5 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    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 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
    8 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
    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID