SAD_SL_TRNS_VW(SQL View) |
Index Back |
|---|---|
Studielink Transaction Info vwStudielink Transaction Information. |
| SELECT 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_RECEIVER , 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 , A.SAD_SL_SUSP_REASON , A.MESSAGE_SET_NBR , A.MESSAGE_NBR FROM PS_SAD_SL_TRNS_INF A |
| # | 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_TRANS_DATE | Date(10) | DATE | Transmission date |
| 6 | SAD_SL_SOURCE | Character(15) | VARCHAR2(15) NOT NULL | Source |
| 7 | SAD_SL_SOURCE_ID | Character(50) | VARCHAR2(50) NOT NULL | Source ID |
| 8 | SAD_SL_SENDER | Character(4) | VARCHAR2(4) NOT NULL | Sender |
| 9 | SAD_SL_RECEIVER | Character(4) | VARCHAR2(4) NOT NULL | Receiver |
| 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.
Default Value: 0 |
| 18 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Default Value: 0 |