| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
HCR_PERSON_I
|
| 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
Prompt Table:
STDNT_CAREER
|
| 3 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 5 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 6 |
SSR_PRG_ACTION_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Progr Action Higher Education
CENR=Change Enrollment
DATA=Data Change
DSAC=Departure Accepted
DSNA=Departure Not Accepted
ENRL=Enrollment
EXAM=Examination
MATR=Matriculation
NRNR=No Re-Enrollment
PAYM=Payment
RENR=Re-Enrollment
SLCN=Studielink Conversion
|
| 7 |
SSR_PRG_STATUS_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Progr Status Higher Education
E=Enrollment
R=Result
|
| 8 |
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
|
| 9 |
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
|
| 10 |
SSR_FUNDING_CD_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Funding Applies
Y/N Table Edit
Default Value: N
|
| 11 |
SSR_PROG_UNITS_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Units Apply
Y/N Table Edit
Default Value: N
|
| 12 |
SSR_PAYMT_FORM_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
Form of Payment
BNK=Bank
CHK=Cheque
CSH=Cash
GIR=Giro
GLD=Loan
INE=2nd Enrl.Other Institution)
INI=2nd Enrollment
MCH=Refund Request
SCH=I Owe You
VRY=No Payment Necessary
|
| 13 |
ACAD_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Year
Prompt Table:
TERM_YR1_VW
|
| 14 |
SSR_CONSENT_NLD |
Character(60) |
VARCHAR2(60) NOT NULL |
Authorized for Payment
|
| 15 |
ACTION_DT |
Date(10) |
DATE |
Action Date
Default Value: %date
|
| 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 |
SCC_STDY_PRGRS_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Study Progress
Y/N Table Edit
Default Value: N
|
| 18 |
SSR_PRG_UNITS_NLD |
Number(3,0) |
SMALLINT NOT NULL |
Program Units Apply
|
| 19 |
SSR_SL_PROG_CD_NLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Studielink Program Code
Prompt Table:
CIP_CODE_TBL
|
| 20 |
SCC_BRINCD_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table:
SCC_BRIN_CD_VW
|
| 21 |
SCC_SUBBRINCD_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
Sub Institute
Prompt Table:
SCC_SUBBRIN_NLD
|
| 22 |
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
|
| 23 |
SSR_SL_PAIDBY_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Paid by
A=Other
E=Another Institution
O=Parents
X=Already Paid
Z=Student
|
| 24 |
SSR_SL_BL_TRMS_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Payment Terms
F=False
T=True
|
| 25 |
SSR_SL_TUITIND_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Indicator
F=Not Paid
O=Undo Previous Payment
T=Paid
|
| 26 |
SSR_SL_TUITAMT_NLD |
Character(13) |
VARCHAR2(13) NOT NULL |
Payment Amount
|
| 27 |
SSR_SL_TUITNBR_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
Number of Payments
|
| 28 |
SSR_SL_BARCODE_NLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Barcode
|
| 29 |
SSR_SL_ORDRNBR_NLD |
Character(30) |
VARCHAR2(30) NOT NULL |
Ordernumber
|
| 30 |
SSR_SL_PDINST_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Paid at Brincode
|
| 31 |
SSR_SL_PDINSTN_NLD |
Character(70) |
VARCHAR2(70) NOT NULL |
paidatinstitutename
paidatins
|
| 32 |
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
|
| 33 |
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
|
| 34 |
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
|
| 35 |
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
|
| 36 |
SSR_SL_FIRSTYR_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Higher Year
F=False
T=True
|
| 37 |
SSR_SL_STARTOC_NLD |
Character(12) |
VARCHAR2(12) NOT NULL |
Start Occasion
|
| 38 |
SSR_SL_STARTMO_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
Start Month
Prompt Table:
SSR_SL_STRMO_VW
|
| 39 |
SAD_BR_FND_RSN_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Funding Reason
Prompt Table:
SAD_BR_FNDR_VW
|
| 40 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
SAD_BR_FNEXO_VW
|
| 41 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 42 |
SAD_BR_EX_BRON_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude From Sending To BRON
Y/N Table Edit
Default Value: N
|
| 43 |
SAD_BR_NO_DEL_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Do Not Send Deletion To BRON
Y/N Table Edit
Default Value: N
|
| 44 |
SSR_BRHO_ENRSQ_NLD |
Character(20) |
VARCHAR2(20) NOT NULL |
BRON Enrolment Seq Nbr
|
| 45 |
SSR_BRHO_RESEQ_NLD |
Character(20) |
VARCHAR2(20) NOT NULL |
BRON Result Seq Nbr
|
| 46 |
SAD_SL_ENRLSQ_NLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Studielink Enroll Seq Nbr
|
| 47 |
SAD_SL_PARTICP_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Participation
F=False
T=True
|
| 48 |
SAD_SL_ADM_DDL_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Admission Deadline
F=False
T=True
|
| 49 |
SAD_SL_ADM_DT_NLD |
Date(10) |
DATE |
First Admission Date
|
| 50 |
SSR_BR_INTPRG_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Indication Intensive Program
0=No
1=Yes
Default Value: 0
|
| 51 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 52 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 53 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 54 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|