| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SCC_TEMP_ID |
Number(16,0) |
DECIMAL(16) NOT NULL |
Temp Constituent ID
|
| 2 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Default Value: OPR_DEF_TBL_CS.ACAD_CAREER
|
| 3 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
|
| 4 |
ADM_APPL_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Application Nbr
Prompt Table:
ADM_APPL_DATA
|
| 5 |
APPL_PROG_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Application Program Nbr
Prompt Table:
ADM_APP_CAR_SEQ
|
| 6 |
SSR_FORM_STUDY_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Form of Study Higher Education
A=Auditor
D=Participant
E=Extraneus
S=Student
T=Coop/Dual
|
| 7 |
SSR_ACAD_LEVEL_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Academ. Level Higher Education
A=Associate Degree
B=Bachelor
D=Propaedeutic Bachelor
H=Main
I=Initial Phase
K=Candidate
L=University teacher education
M=Master
P=Propaedeutic Phase
Q=Post-Initial
T=Interim Doctoral Exam
V=Continuation Phase
W=Continuing study
|
| 8 |
SSR_FUNDING_CD_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Funding Applies
Y/N Table Edit
Default Value: N
|
| 9 |
SCC_BRINCD_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table:
SCC_BRIN_CD_VW
|
| 10 |
SSR_SL_PROG_CD_NLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Studielink Program Code
Prompt Table:
CIP_CODE_TBL
|
| 11 |
SSR_SL_ACAD_YR_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Year
Prompt Table:
TERM_YR1_VW
|
| 12 |
SSR_SL_FIRSTYR_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Higher Year
F=False
T=True
|
| 13 |
SSR_SL_PAYMODE_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Studielink Form of Payment
0=Payment Transfer
1=Auth Printed by Institution
2=Auth Printed by Student
3=Foreign Account Number
4=Other
5=E-Payment
6=Electronic Direct Debit
7=Via Institution
8=Non SEPA Country
|
| 14 |
SSR_SL_PAIDBY_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Paid by
A=Other
E=Another Institution
O=Parents
X=Already Paid
Z=Student
|
| 15 |
SSR_SL_BL_TRMS_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Payment Terms
F=False
T=True
|
| 16 |
SSR_SL_STATUS_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Studielink Status
B=Continuing Application
G=Cancelled/Withdrawn
I=Registered/Enrolled
N=No Re-Enrollment
R=Rejected/Denied
S=Study Suspended
U=Departed
V=Enrollment Requested
X=Not a Studielink Participant
|
| 17 |
SSR_SL_DEFSTAT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Deficiency Status
D=Deficient via Institution
J=Deficient via IBG counter
N=Not yet determined
S=Sufficient
T=Not Deficient via IBG Counter
V=Provisional IBG
W=Provisional Institution
|
| 18 |
SSR_SL_JOBSTAT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Prof Requirements Status
A=Rejected
G=Selected/passed
N=Not Applicable
O=Open, not yet determined
|
| 19 |
SSR_SL_ACTSTAT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Professional Duties Status
A=Rejected
G=Selected/passed
N=Not applicable
O=Open, not yet determined
|
| 20 |
SSR_SL_DRAWOPT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Lot Drawing Type
C=Central
I=Local
N=None
S=Selection & Placement
|
| 21 |
SSR_SL_STATLNG_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Language Test Status
A=Rejected
G=Selected/passed
H=Passed
N=Not applicable
O=Open, not yet determined
|
| 22 |
SSR_SL_IBGSTAT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
IBG Status
A=Rejected by RASP
G=Sent
N=Not sent
V=Processed in RASP
|
| 23 |
SSR_SL_IBGSRSN_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
IBG Status Reason
B=Identity not timely verifieD
C=Transcript too late
I=Declaration too late
L=Too often entered in lotterey
M=Not permitted to enter lottery
N=Not complied Admin Requisites
O=Deceased
P=No placement certificate
S=Too often selected
T=Applied after close date
V=No temp placement certificate
W=Correspon.nbr changed
|
| 24 |
SSR_SL_IBGDEFI_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
IBG Deficiency Status
|
| 25 |
SSR_SL_TUITAMT_NLD |
Character(13) |
VARCHAR2(13) NOT NULL |
Payment Amount
|
| 26 |
SSR_SL_TUITIND_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Indicator
F=Not Paid
O=Undo Previous Payment
T=Paid
|
| 27 |
SSR_SL_DRAW_DT_NLD |
Date(10) |
DATE |
Lot Drawing Date
|
| 28 |
SSR_SL_DRAWRST_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Lot Drawing Result
D=Locally Drawn
I=Selected
J=Selected (decentralized)
M=Locally Not Participated
N=Locally Not Selected
O=Conditionally Selected
S=Locally Selected
U=Centrally Not Selected
V=Temp placement certificate
|
| 29 |
SSR_SL_DRAWRSN_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Lot Drawing Result Reason
D=Several
H=Hardship Clause
N=Language Test
O=Supremacy
V=Not yet sufficient
|
| 30 |
SSR_SL_DRAWSEQ_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
Lot Drawing Number
|
| 31 |
SCC_SUBBRINCD_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
Sub Institute
Prompt Table:
SCC_SUBBRIN_NLD
|
| 32 |
SSR_SL_PDINST_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Paid at Brincode
|
| 33 |
SSR_SL_PDINSTN_NLD |
Character(70) |
VARCHAR2(70) NOT NULL |
paidatinstitutename
paidatins
|
| 34 |
SSR_SL_BARCODE_NLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Barcode
|
| 35 |
SSR_SL_ORDRNBR_NLD |
Character(30) |
VARCHAR2(30) NOT NULL |
Ordernumber
|
| 36 |
SSR_SL_TUITNBR_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
Number of Payments
|
| 37 |
SSR_SL_STARTMO_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
Start Month
|
| 38 |
SSR_SL_STARTOC_NLD |
Character(12) |
VARCHAR2(12) NOT NULL |
Start Occasion
|
| 39 |
SAD_SL_ENRLSQ_NLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Studielink Enroll Seq Nbr
|
| 40 |
SAD_SL_PARTICP_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Participation
F=False
T=True
|
| 41 |
SAD_SL_ADM_DDL_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Admission Deadline
F=False
T=True
|
| 42 |
SAD_SL_ADM_DT_NLD |
Date(10) |
DATE |
First Admission Date
|
| 43 |
SSR_BR_INTPRG_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Indication Intensive Program
0=No
1=Yes
Default Value: 0
|
| 44 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 45 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 46 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 47 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|