SAD_SL_TRNS_INF

(SQL Table)
 Index Back

Studielink Transaction Info

Studielink Transaction Information. Contains data for contentype block.

  • Parent Record Of SAD_SL_03 SAD_SL_04 SAD_SL_05 SAD_SL_06 SAD_SL_06_VW SAD_SL_07 SAD_SL_08 SAD_SL_09 SAD_SL_10 SAD_SL_19 SAD_SL_20 SAD_SL_22 SAD_SL_25 SAD_SL_30 SAD_SL_31 SAD_SL_31_VW1 SAD_SL_34 SAD_SL_35 SAD_SL_37 SAD_SL_39 SAD_SL_45 SAD_SL_47 SAD_SL_50 SAD_SL_51 SAD_SL_52 SAD_SL_52_STU SAD_SL_53 SAD_SL_53_STU SAD_SL_54 SAD_SL_55 SAD_SL_CNVP_AET SAD_SL_IN_SUSP SAD_SL_OUT_SUSP SAD_SL_RECEIVER SAD_SL_SEL_PG_V SAD_SL_SEL_PROG

    • # 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 SAD_SL_INDEX_ID Character(40) VARCHAR2(40) NOT NULL Index ID
    5 SAD_SL_SOURCE Character(15) VARCHAR2(15) NOT NULL Source
    6 SAD_SL_SOURCE_ID Character(50) VARCHAR2(50) NOT NULL Source ID
    7 SAD_SL_SENDER Character(4) VARCHAR2(4) NOT NULL Sender
    8 SAD_SL_RECEIVER Character(4) VARCHAR2(4) NOT NULL Receiver
    9 SAD_SL_PROCESS_ID Character(40) VARCHAR2(40) NOT NULL Process ID
    10 SAD_SL_FILTER_CD Character(1) VARCHAR2(1) NOT NULL Filter Code
    11 SAD_SL_TRANS_STAT Character(1) VARCHAR2(1) NOT NULL Studielink Message Status
    C=Communication Error
    E=Transmission Error
    G=Partially Processed
    M=Manually Resolved
    O=Skip Transaction
    P=Processed
    S=Suspended
    T=Test Without XML
    U=Unprocessed

    Default Value: U

    12 SAD_SL_ACCEPTED Character(1) VARCHAR2(1) NOT NULL Accepted Indicator
    13 SAD_SL_ERROR_CODE Character(50) VARCHAR2(50) NOT NULL Error Code
    14 SAD_SL_ERROR_TEXT Character(200) VARCHAR2(200) NOT NULL Error Text
    15 SAD_SL_SUSP_REASON Character(1) VARCHAR2(1) NOT NULL Reason that the Studielink message could not be processed.
    1=Studielink Number not found
    2=Search/Match
    3=Missing Setup Data
    4=Unable to update student data
    5=Partially Processed
    6=Missing Required field
    16 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

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

    Default Value: 0

    18 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
    19 SAD_SL_PROC_SELECT Character(1) VARCHAR2(1) NOT NULL Select to Process
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    20 SAD_SL_SLCT_DT_NLD Character(10) VARCHAR2(10) NOT NULL Selection Date