| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HEGIS_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
HEGIS Code
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
UNITS_ACAD_PROG |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Academic Progress Units
|
| 4 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_VW
|
| 5 |
SSR_PART_QUAL_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Qualification
Y/N Table Edit
Default Value: N
|
| 6 |
SSR_FINAL_QUAL_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Qualification
Y/N Table Edit
Default Value: N
|
| 7 |
SCC_CRSE_CODE_NLD |
Character(10) |
VARCHAR2(10) NOT NULL |
Course Reference Code
|
| 8 |
SCC_LOB_CODE_NLD |
Character(10) |
VARCHAR2(10) NOT NULL |
Lob Code
|
| 9 |
SCC_EDU_LEVEL_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Education level
ATH=Atheneum
BB=VMBO Basic Professional Ed
GL=VMBO Mixed Professional Ed
GYM=Gymnasium
HA=HAVO
HBO=College Degree
KB=VMBO Kader Professional Ed
KSB1=Kwalification Structure PrEd 1
KSB2=Kwalification Structure PrEd 2
KSB3=Kwalification Structure PrEd 3
KSB4=Kwalification Structure PrEd 4
TL=VMBO Theoretic Professional Ed
VWO=VWO
WO=University Degree
|
| 10 |
SCC_HEGIS_TYPE_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Hegis Code Type
C=Course
E=Elective
K=Elective
P=Program
T=Testimony
|
| 11 |
SCC_SEC_DOMAIN_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
Qualification Domain
EK=End Qualification
KD=Qualification Dossier
KW=Qualification
OD=Education Domain
|