SAD_SL_TR_K_VW(SQL View) |
Index Back |
|---|---|
Studielink Transaction InfoStudielink Transaction Information view/search record. |
| SELECT B.SAD_SL_STDLNK_NBR ,A.SAD_SL_TRANS_DTTM ,A.SAD_SL_TRANS_INOUT ,A.SAD_SL_TRANS_SEQ ,A.SAD_SL_INDEX_ID ,%DatePart(A.SAD_SL_TRANS_DTTM) ,A.SAD_SL_SOURCE ,A.SAD_SL_SOURCE_ID ,A.SAD_SL_SENDER ,A.SAD_SL_PROCESS_ID ,A.SAD_SL_FILTER_CD ,A.SAD_SL_TRANS_STAT ,A.SAD_SL_ACCEPTED ,A.SAD_SL_ERROR_CODE ,A.SAD_SL_ERROR_TEXT ,B.SAD_SL_SUSP_REASON ,B.MESSAGE_SET_NBR ,B.MESSAGE_NBR FROM PS_SAD_SL_TRNS_INF A ,PS_SAD_SL_IN_SUSP B WHERE A.SAD_SL_TRANS_INOUT = B.SAD_SL_TRANS_INOUT AND A.SAD_SL_TRANS_DTTM = B.SAD_SL_TRANS_DTTM AND A.SAD_SL_TRANS_SEQ = B.SAD_SL_TRANS_SEQ AND A.SAD_SL_INDEX_ID = B.SAD_SL_INDEX_ID AND A.SAD_SL_TRANS_INOUT = 'I' AND A.SAD_SL_TRANS_STAT <> 'P' AND B.SAD_SL_SUSP_REASON = '7' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SAD_SL_STDLNK_NBR |
Character(9) | VARCHAR2(9) NOT NULL | Studielink Number |
| 2 | SAD_SL_TRANS_DTTM |
DateTime(26) | TIMESTAMP | Transaction DateTime |
| 3 | SAD_SL_TRANS_INOUT |
Character(1) | VARCHAR2(1) NOT NULL |
Transaction Direction
I=Inbound O=Outbound |
| 4 | SAD_SL_TRANS_SEQ |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | SAD_SL_INDEX_ID |
Character(40) | VARCHAR2(40) NOT NULL | Index ID |
| 6 | SAD_SL_TRANS_DATE | Date(10) | DATE | Transmission date |
| 7 | SAD_SL_SOURCE | Character(15) | VARCHAR2(15) NOT NULL | Source |
| 8 | SAD_SL_SOURCE_ID | Character(50) | VARCHAR2(50) NOT NULL | Source ID |
| 9 | SAD_SL_SENDER | Character(4) | VARCHAR2(4) NOT NULL | Sender |
| 10 | SAD_SL_PROCESS_ID | Character(40) | VARCHAR2(40) NOT NULL | Process ID |
| 11 | SAD_SL_FILTER_CD | Character(1) | VARCHAR2(1) NOT NULL | Filter Code |
| 12 | 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 |
| 13 | SAD_SL_ACCEPTED | Character(1) | VARCHAR2(1) NOT NULL | Accepted Indicator |
| 14 | SAD_SL_ERROR_CODE | Character(50) | VARCHAR2(50) NOT NULL | Error Code |
| 15 | SAD_SL_ERROR_TEXT | Character(200) | VARCHAR2(200) NOT NULL | Error Text |
| 16 | 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 |
| 17 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 18 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |