SAD_SL_LDTRN_VW(SQL View) |
Index Back |
|---|---|
Studielink Transaction Info vwStudielink Transaction Information view for Load student process |
| SELECT A.SAD_SL_TRANS_DTTM , A.SAD_SL_TRANS_INOUT , A.SAD_SL_TRANS_SEQ , A.SAD_SL_INDEX_ID , A.SAD_SL_TRANS_STAT , A.SAD_SL_PROC_SELECT FROM PS_SAD_SL_TRNS_INF A WHERE A.SAD_SL_SOURCE_ID = 'vchmsg52studentendeelnameselectie' AND A.SAD_SL_TRANS_STAT IN ('U', 'G', 'E') |
| # | 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_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 |
| 6 | SAD_SL_PROC_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Select to Process
N=No Y=Yes Y/N Table Edit Default Value: N |