| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SSR_BR_INDEX_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction Index ID
|
| 2 |
SSR_BR_MSGUUID |
Character(50) |
VARCHAR2(50) NOT NULL |
Message ID
|
| 3 |
SSR_BR_TRANS_INOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Direction
I=Inbound
O=Outbound
|
| 4 |
SSR_BR_TRANS_DTTM |
DateTime(26) |
TIMESTAMP |
Transaction DateTime
|
| 5 |
SSR_BR_TRANS_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Studielink Message Status
A=Partly processed
C=Created
P=Processed
R=Received
S=Suspended
T=Error
U=Unprocessed
V=Sent
|
| 6 |
SERVICENAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Service name
|
| 7 |
SSR_BR_MSGBO |
Character(50) |
VARCHAR2(50) NOT NULL |
Message
|
| 8 |
SSR_BR_SENDER |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Sender
|
| 9 |
SSR_BR_RECEIVER |
Character(4) |
VARCHAR2(4) NOT NULL |
Receiver
|
| 10 |
SSR_BR_ACCEPTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Accepted Indicator
J=Accepted
N=Rejected
|
| 11 |
IBPUBTRANSACTID |
Character(36) |
VARCHAR2(36) NOT NULL |
Orig Transaction ID
|
| 12 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 13 |
SSR_RI_EDU_GOV_NLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Educational Board Code
|
| 14 |
SSR_RI_EUN_COD_NLD |
Character(12) |
VARCHAR2(12) NOT NULL |
RIO STAP Educational Unit Code
|
| 15 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 16 |
END_DT |
Date(10) |
DATE |
end date
|
| 17 |
SSR_RI_DOCTP_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Document type
CERT=CERTIFICAAT
DIPL=DIPLOMA
NONE=GEEN_OFFICIEEL_DOCUMENT
SADV=SCHOOLADVIES
TSTM=GETUIGSCHRIFT
|
| 18 |
SSR_BR_LVL_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
/* 2021-10-13: fix for Bug-ID: 32929597 - RIOv3 */
Additional translate value U.
1=MBO-1
2=MBO-2
3=MBO-3
4=MBO-4
U=Undetermined
|
| 19 |
SSR_RI_EQF_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
RIO STAP European Qualification Framework
1=1
2=2
3=3
4=4
5=5
6=6
7=7
8=8
|
| 20 |
SSR_RI_NLQF_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
RIO STAP NLD Qualification Framework
1=1
2=2
3=3
4=4
4P=4p
5=5
6=6
7=7
8=8
|
| 21 |
SSR_RI_CAT_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
/* 2022-10-13: fix for Bug-ID: 34695718 - RIOv4 */
BDPR=BEDRIJFS_PROJECTONDERSTEUNING
ECON=ECONOMIE
GDMY=GEDRAG_EN_MAATSCHAPPIJ
GZSP=GEZONDHEID_ZORG_EN_SPORT
HBVT=HOBBY_EN_VRIJE_TIJD
LVNO=LANDBW_VOEDSEL_EN_NAT_OMGEVING
MNPR=MANAGEMENT_EN_PROJECTMNGT
NATR=NATUUR
ONDW=ONDERWIJS
RCHT=RECHT
SCTO=SECTOROVERSTIJGEND
TECH=TECHNIEK_EN_ICT
THRC=TOERISME_HORECA_EN_RECREATIE
TLCL=TAAL_EN_CULTUUR
TRLG=TRANSPORT_EN_LOGISTIEK
VLDF=VEILIGHEID_EN_DEFENSIE
|
| 22 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
|
| 23 |
SSR_RI_MUT_TYP_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Mutation Type
T=Addition
V=Removal
W=Change
|