STDNT_ENRL_SSLN(SQL View) |
Index Back |
---|---|
Student Enrollment Table ViewThis Student Enrollment view is used to extract key enrollment information from the graded component into the enrollment section. This is done to facilitate maintenance transactions from the enrollment section only. |
SELECT a.emplid , a.acad_career , a.institution , a.strm , b.subject , b.catalog_nbr , a.associated_class , b.class_nbr , c.language_cd , c.descr FROM ps_stdnt_enrl a , PS_CLASS_TBL b , PS_CLASS_TBL_lang c WHERE a.strm = b.strm AND a.class_nbr = b.class_nbr AND b.crse_id = c.crse_id AND b.crse_offer_nbr = c.crse_offer_nbr AND b.strm = c.strm AND b.session_code = c.session_code AND b.class_section = c.class_section |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
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 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
4 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_TBL |
5 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
6 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
7 | ASSOCIATED_CLASS | Number(4,0) | SMALLINT NOT NULL |
Associated Class
Default Value: CLASS_TBL_VW.ASSOCIATED_CLASS |
8 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL |
Class Nbr
Prompt Table: CLASS_TBL_VW |
9 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |