SSR_BR_TRIN_NLD

(SQL Table)
 Index Back

BRON-HO Message Transaction

BRON-HO Message Transaction Rec

  • Parent Record Of SSR_BR_DACFB_ER SSR_BR_DGAC_FBK SSR_BR_DGRM_FBK SSR_BR_ENDL_DUM SSR_BR_ENDL_WRK SSR_BR_ENRDL_VW SSR_BR_ENRL_DEL SSR_BR_ENRL_FBK SSR_BR_ENRL_REM SSR_BR_ENRM_FBK SSR_BR_FNDER_VW SSR_BR_FND_VW SSR_BR_FUND_NLD SSR_BR_FUND_STA SSR_BR_FUND_VW SSR_BR_MENR_DEL SSR_BR_MENR_DUM SSR_BR_MENR_WRK SSR_BR_MRST_DEL SSR_BR_MRST_WRK SSR_BR_RECEIVER SSR_BR_RESTA_VW SSR_BR_RSLT_DEL SSR_BR_RSLT_DUM SSR_BR_RSLT_REM SSR_BR_RSLT_VW SSR_BR_RSLT_WRK SSR_BR_TFBK_NLD SSR_BR_TRANS_VW SSR_BR_TUTF_AET SSR_BR_TUTF_FBK SSR_BR_TUTF_REQ

    • # 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_SOURCE_ID Character(50) VARCHAR2(50) NOT NULL Source ID
    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_VERSION Character(1) VARCHAR2(1) NOT NULL Studielink Version
    1=Vers. 2.9
    2=Vers. 3.0
    3=Vers. 4.0
    4=Vers. 5.0
    16 COMMENTS Long Character CLOB Comment
    17 SSR_BR_MSG_RCV_NLD Character(1) VARCHAR2(1) NOT NULL Message Received
    N=No
    Y=Yes
    18 SSR_BR_MSGRCV_DTTM DateTime(26) TIMESTAMP Message Received DateTime
    19 SSR_BR_MSG_PRC_NLD Character(1) VARCHAR2(1) NOT NULL Message Processed
    A=Approved
    D=Denied
    20 SSR_BR_MSGPRC_DTTM DateTime(26) TIMESTAMP Message Processed DateTime
    21 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    22 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    23 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    24 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time