SAD_SL_48

(SQL Table)
 Index Back

Message 48

Message 48

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SAD_SL_TRANS_INOUT Character(1) VARCHAR2(1) NOT NULL Transaction Direction
I=Inbound
O=Outbound
2 SAD_SL_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime
3 SAD_SL_TRANS_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number
4 SAD_SL_INDEX_ID Character(40) VARCHAR2(40) NOT NULL Index ID
5 SAD_SL_STDLNK_NBR Character(9) VARCHAR2(9) NOT NULL Studielink Number
6 SAD_SL_NAME_TEXT Character(220) VARCHAR2(220) NOT NULL Merged name
7 SAD_SL_STUD_NBR Character(12) VARCHAR2(12) NOT NULL Student Number
8 SAD_SL_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
9 SAD_SL_EXT_PROG_CD Character(12) VARCHAR2(12) NOT NULL Alternative programcode
10 SAD_SL_BRIN_CODE Character(4) VARCHAR2(4) NOT NULL Brincode institution
11 SAD_SL_ACAD_LOAD Character(1) VARCHAR2(1) NOT NULL Academic load
1=Full-time
2=Part-time
3=Dual
12 SAD_SL_ACTEDU_CITY Character(24) VARCHAR2(24) NOT NULL City
13 SAD_SL_ACAD_LEVEL Character(1) VARCHAR2(1) NOT NULL Academic Level
B=Bachelor
D=Propaedeutic Bachelor
H=Main
I=Initial Phase
M=Master
P=Propaedeutic Phase
V=Continuation Phase
14 SAD_SL_ENRL_MANNER Character(1) VARCHAR2(1) NOT NULL Enrolment Manner
A=Auditor
D=Participant
E=Extraneus
S=Student
T=Coop/Dual
15 SAD_SL_ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
16 SAD_SL_START_MONTH Character(2) VARCHAR2(2) NOT NULL Start month
17 SAD_SL_SUBINST Character(2) VARCHAR2(2) NOT NULL Sub Institute
18 SAD_SL_START_OCCSN Character(12) VARCHAR2(12) NOT NULL Start Occasion
19 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
20 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
21 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
22 EFFDT Date(10) DATE Effective Date

Default Value: %date

23 SAD_SL_CIOP_NBR Character(12) VARCHAR2(12) NOT NULL Correspondence number
24 SSR_SL_CRSTAT_NLD Character(1) VARCHAR2(1) NOT NULL Status Corrected
D=Date Change
G=Cancelled/Withdrawn
U=Departed
W=Revoked
25 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL Social Fiscal Number
26 SAD_SL_O_NBR Character(9) VARCHAR2(9) NOT NULL Onumber
27 SAD_SL_ENRLSQ_NLD Character(20) VARCHAR2(20) NOT NULL Studielink Enroll Seq Nbr
28 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr