HIST_TERM_ENRL(SQL Table) |
Index Back |
---|---|
Historical Term Enrollment |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: STDNT_CAR_SRCH.EMPLID |
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: STDNT_CAR_SRCH.ACAD_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_VAL_TBL |
5 | HIST_ENRL_SEQ | Number(3,0) | SMALLINT NOT NULL | Enrollment Sequence Number |
6 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Prompt Table: SUBJECT_TBL |
7 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
8 | UNT_TAKEN | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Taken |
9 | UNT_PASSED | Number(6,2) | DECIMAL(5,2) NOT NULL | Unit Passed |
10 | CRSE_GRADE_OFF | Character(3) | VARCHAR2(3) NOT NULL | Official Grade |
11 | GRADE_POINTS | Number(10,3) | DECIMAL(9,3) NOT NULL | Grade Points |
12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
13 | START_DT | Date(10) | DATE | Start Date |
14 | END_DT | Date(10) | DATE | end date |
15 | TRANSCRIPT_TEXT | Character(90) | VARCHAR2(90) NOT NULL | Transcript Text |