SSR_BR_TRANS_VW

(SQL View)
 Index Back

BRON HO Transaction Info vw

BRON HO Transaction Information.

SELECT A.SAD_SL_TRANS_DTTM , A.SAD_SL_TRANS_INOUT , A.SAD_SL_TRANS_SEQ , A.SSR_BR_INDEXID_NLD , %DatePart(A.SAD_SL_TRANS_DTTM) , A.SSR_BR_SENDER_NLD , A.SSR_BR_RECEIVR_NLD , A.SSR_BR_TRN_STA_NLD , A.SAD_SL_ACCEPTED , A.SAD_SL_ERROR_CODE , A.SAD_SL_ERROR_TEXT , A.SSR_BR_SUS_RSN_NLD , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.SAD_SL_SOURCE_ID FROM PS_SSR_BR_TRIN_NLD A

  • Parent record: SSR_BR_TRIN_NLD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SAD_SL_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime
    2 SAD_SL_TRANS_INOUT Character(1) VARCHAR2(1) NOT NULL Transaction Direction
    I=Inbound
    O=Outbound
    3 SAD_SL_TRANS_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number
    4 SSR_BR_INDEXID_NLD Character(50) VARCHAR2(50) NOT NULL Index ID
    5 SAD_SL_TRANS_DATE Date(10) DATE Transmission date
    6 SSR_BR_SENDER_NLD Character(6) VARCHAR2(6) NOT NULL Sender
    7 SSR_BR_RECEIVR_NLD Character(6) VARCHAR2(6) NOT NULL Receiver
    8 SSR_BR_TRN_STA_NLD Character(1) VARCHAR2(1) NOT NULL BRON-HO Message Status
    A=Pending Approval
    C=Communication Error
    M=Manually Resolved
    O=Skip Transaction
    P=Processed
    R=Ready to Send
    S=Suspended
    U=Unprocessed
    X=Approved

    Default Value: U

    9 SAD_SL_ACCEPTED Character(1) VARCHAR2(1) NOT NULL Accepted Indicator
    10 SAD_SL_ERROR_CODE Character(50) VARCHAR2(50) NOT NULL Error Code
    11 SAD_SL_ERROR_TEXT Character(200) VARCHAR2(200) NOT NULL Error Text
    12 SSR_BR_SUS_RSN_NLD Character(1) VARCHAR2(1) NOT NULL Reason that the BRON HO message could not be processed.
    2=Nat Id, Edu Nbr match error
    4=Unable to update Student Data
    6=Missing Required Field
    8=Communication Error
    13 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Default Value: 0

    14 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Default Value: 0

    15 SAD_SL_SOURCE_ID Character(50) VARCHAR2(50) NOT NULL Source ID