SAD_BR_332_VW

(SQL View)
Index Back

332 delivery record


SELECT TRANS.INSTITUTION , TRANS.SCC_BRINCD_NLD , TRANS.BATCH_SERIAL_NUM , TRANS.SAD_BR_REC_TYP_NLD , TRANS.SAD_BR_SEQ_NBR_NLD , TRANS.SAD_BR_RTP_SEQ_NLD , TRANS.SAD_BR_EDU_SEC_NLD , TRANS.CREATION_DT , TRANS.SAD_BR_ENRL_SQ_NLD , TRANS.HEGIS_CODE , TRANS.ACAD_YEAR , TRANS.SAD_BR_EX_CRSE_NLD , TRANS.SAD_BR_DPL_SBJ_NLD , TRANS.SAD_BR_APL_DPL_NLD , TRANS.SAD_BR_IND_PAP_NLD , TRANS.SAD_BR_EXA_LVL_NLD , TRANS.SAD_BR_RS_SCEX_NLD , TRANS.SAD_BR_GR_SCEX_NLD , TRANS.SAD_BR_GRA_CE1_NLD , TRANS.SAD_BR_GRA_CE2_NLD , TRANS.SAD_BR_GRA_CE3_NLD , TRANS.SAD_BR_FI_GRA1_NLD , TRANS.SAD_BR_FI_GRA2_NLD , TRANS.SAD_BR_FI_GRA3_NLD , TRANS.SAD_BR_GRA_LST_NLD , TRANS.SAD_BR_NXT_TRM_NLD , TRANS.SAD_BR_CERTIF_NLD , TRANS.SAD_BR_COM_CIJF_NL , TRANS.SAD_BR_HIGHLVL_NL , TRANS.SAD_BR_EXM_CMP_NLD , TRANS.EMPLID , TRANS.ACAD_CAREER , TRANS.STDNT_CAR_NBR , TRANS.SAD_BR_REC_STA_NLD , TRANS.SAD_BR_FI_SENT_NLD , TRANS.SAD_BR_SIGNAL_NLD , TRANS.SAD_BR_SEQ_STR_NLD , TRANS.SAD_BR_GR_SCEX_STR , TRANS.SAD_BR_GRA_CE1_STR , TRANS.SAD_BR_GRA_CE2_STR , TRANS.SAD_BR_GRA_CE3_STR , TRANS.SAD_BR_FI_GRA1_STR , TRANS.SAD_BR_FI_GRA2_STR , TRANS.SAD_BR_FI_GRA3_STR , TRANS.SAD_BR_GRA_LST_STR FROM PS_SAD_BR_332_NLD TRANS WHERE TRANS.SAD_BR_REC_STA_NLD = 'V' AND TRANS.BATCH_SERIAL_NUM = ( SELECT MAX(TRANSMAXD.BATCH_SERIAL_NUM) FROM PS_SAD_BR_332_NLD TRANSMAXD WHERE TRANS.INSTITUTION = TRANSMAXD.INSTITUTION AND TRANS.SCC_BRINCD_NLD = TRANSMAXD.SCC_BRINCD_NLD AND TRANS.SAD_BR_EDU_SEC_NLD = TRANSMAXD.SAD_BR_EDU_SEC_NLD AND TRANS.EMPLID = TRANSMAXD.EMPLID AND TRANS.SAD_BR_ENRL_SQ_NLD = TRANSMAXD.SAD_BR_ENRL_SQ_NLD AND TRANS.HEGIS_CODE = TRANSMAXD.HEGIS_CODE AND TRANS.ACAD_YEAR = TRANSMAXD.ACAD_YEAR AND TRANS.SAD_BR_EX_CRSE_NLD = TRANSMAXD.SAD_BR_EX_CRSE_NLD) AND TRANS.CREATION_DT = ( SELECT MAX(TRANSMAXD.CREATION_DT) FROM PS_SAD_BR_332_NLD TRANSMAXD WHERE TRANS.INSTITUTION = TRANSMAXD.INSTITUTION AND TRANS.SCC_BRINCD_NLD = TRANSMAXD.SCC_BRINCD_NLD AND TRANS.SAD_BR_EDU_SEC_NLD = TRANSMAXD.SAD_BR_EDU_SEC_NLD AND TRANS.EMPLID = TRANSMAXD.EMPLID AND TRANS.SAD_BR_ENRL_SQ_NLD = TRANSMAXD.SAD_BR_ENRL_SQ_NLD AND TRANS.HEGIS_CODE = TRANSMAXD.HEGIS_CODE AND TRANS.ACAD_YEAR = TRANSMAXD.ACAD_YEAR AND TRANS.SAD_BR_EX_CRSE_NLD = TRANSMAXD.SAD_BR_EX_CRSE_NLD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
3 BATCH_SERIAL_NUM Number(5,0) INTEGER NOT NULL Last Sequence Nbr
4 SAD_BR_REC_TYP_NLD Character(3) VARCHAR2(3) NOT NULL Record Type

Default Value: 332

5 SAD_BR_SEQ_NBR_NLD Number(6,0) INTEGER NOT NULL Sequence Number
6 SAD_BR_RTP_SEQ_NLD Number(3,0) SMALLINT NOT NULL BRON Recordtype Sequence number
7 SAD_BR_EDU_SEC_NLD Character(2) VARCHAR2(2) NOT NULL Educational Sector
BO=Professional Education
ED=Education
VA=VAVO
8 CREATION_DT Date(10) DATE NOT NULL Creation Date
9 SAD_BR_ENRL_SQ_NLD Character(3) VARCHAR2(3) NOT NULL Enrollment Sequence number
10 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
11 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
12 SAD_BR_EX_CRSE_NLD Character(4) VARCHAR2(4) NOT NULL Exam Subject
13 SAD_BR_DPL_SBJ_NLD Character(1) VARCHAR2(1) NOT NULL Diploma Subject
14 SAD_BR_APL_DPL_NLD Character(1) VARCHAR2(1) NOT NULL Appl. result exam subject
D=Dispensation
G=In exam Year
I=Exchanged for Diploma
V=Passed without Grade
15 SAD_BR_IND_PAP_NLD Character(1) VARCHAR2(1) NOT NULL Indication Paper
16 SAD_BR_EXA_LVL_NLD Character(3) VARCHAR2(3) NOT NULL Program Level
17 SAD_BR_RS_SCEX_NLD Character(1) VARCHAR2(1) NOT NULL Result Schoolexam
G=Good
O=Insufficient
V=Adequate
18 SAD_BR_GR_SCEX_NLD Number(3,0) SMALLINT NOT NULL Grade School Exam
19 SAD_BR_GRA_CE1_NLD Number(3,0) SMALLINT NOT NULL Grade Central Exam 1
20 SAD_BR_GRA_CE2_NLD Number(3,0) SMALLINT NOT NULL Grade Central exam 2
21 SAD_BR_GRA_CE3_NLD Number(3,0) SMALLINT NOT NULL Grade Central Exam 3
22 SAD_BR_FI_GRA1_NLD Number(2,0) SMALLINT NOT NULL Grade final exam 1
23 SAD_BR_FI_GRA2_NLD Number(2,0) SMALLINT NOT NULL Grade final exam 2
24 SAD_BR_FI_GRA3_NLD Number(2,0) SMALLINT NOT NULL Grade final exam 3
25 SAD_BR_GRA_LST_NLD Number(2,0) SMALLINT NOT NULL Grade Gradelist
26 SAD_BR_NXT_TRM_NLD Character(1) VARCHAR2(1) NOT NULL Indicator Enrollment Next Term
27 SAD_BR_CERTIF_NLD Character(1) VARCHAR2(1) NOT NULL Indicator Certificate
28 SAD_BR_COM_CIJF_NL Character(1) VARCHAR2(1) NOT NULL BRON VAVO field for interface change 8.4.0.
29 SAD_BR_HIGHLVL_NL Character(4) VARCHAR2(4) NOT NULL BRON VAVO field for interface change 8.4.0.
30 SAD_BR_EXM_CMP_NLD Character(1) VARCHAR2(1) NOT NULL Examination Component
A=General
P=Specialization
T=Test
V=Elective
31 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
32 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
33 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
34 SAD_BR_REC_STA_NLD Character(1) VARCHAR2(1) NOT NULL Record Status
A=Rejected
C=Created
G=Approved
V=Sent
35 SAD_BR_FI_SENT_NLD Date(10) DATE Date file send
36 SAD_BR_SIGNAL_NLD Character(3) VARCHAR2(3) NOT NULL BRON Signal
37 SAD_BR_SEQ_STR_NLD Character(6) VARCHAR2(6) NOT NULL Sequence Number String
38 SAD_BR_GR_SCEX_STR Character(3) VARCHAR2(3) NOT NULL Grade School Exam
39 SAD_BR_GRA_CE1_STR Character(3) VARCHAR2(3) NOT NULL Grade Central Exam 1
40 SAD_BR_GRA_CE2_STR Character(3) VARCHAR2(3) NOT NULL Grade Central exam 2
41 SAD_BR_GRA_CE3_STR Character(3) VARCHAR2(3) NOT NULL Grade Central Exam 3
42 SAD_BR_FI_GRA1_STR Character(2) VARCHAR2(2) NOT NULL Grade final exam 1
43 SAD_BR_FI_GRA2_STR Character(2) VARCHAR2(2) NOT NULL Grade final exam 2
44 SAD_BR_FI_GRA3_STR Character(2) VARCHAR2(2) NOT NULL Grade final exam 3
45 SAD_BR_GRA_LST_STR Character(2) VARCHAR2(2) NOT NULL Grade Gradelist