| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 2 |
SSR_RI_EUN_COD_NLD |
Character(12) |
VARCHAR2(12) NOT NULL |
RIO STAP Educational Unit Code
|
| 3 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 4 |
END_DT |
Date(10) |
DATE |
end date
|
| 5 |
SSR_RI_DOCTP_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Document type
CERT=CERTIFICAAT
DIPL=DIPLOMA
NONE=GEEN_OFFICIEEL_DOCUMENT
SADV=SCHOOLADVIES
TSTM=GETUIGSCHRIFT
|
| 6 |
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
|
| 7 |
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
|
| 8 |
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
|
| 9 |
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
|