SCHL_CRSE_TRVW(SQL View) |
Index Back |
---|---|
School Courses Viewselect a.EXT_ORG_ID , a.SCHOOL_SUBJECT , a.SCHOOL_CRSE_NBR , a.EFFDT , a.EFF_STATUS , a.EXT_SUBJECT_AREA , a.EXT_CAREER , a.EXT_CRSE_TYPE , a.COURSE_LEVEL , a.DESCR , a.DESCRSHORT , a.EXT_UNITS from PS_SCHOOL_CRSE_TBL a |
select a.EXT_ORG_ID , a.SCHOOL_SUBJECT , a.SCHOOL_CRSE_NBR , a.EFFDT , a.EFF_STATUS , a.EXT_SUBJECT_AREA , a.EXT_CAREER , a.EXT_CRSE_TYPE , a.COURSE_LEVEL , a.DESCR , a.DESCRSHORT , a.EXT_UNITS from PS_SCHOOL_CRSE_TBL a |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CATALOG_ORG | Character(11) | VARCHAR2(11) NOT NULL | Catalog Organization |
2 | SCHOOL_SUBJECT | Character(8) | VARCHAR2(8) NOT NULL |
School Subject
Prompt Table: SCHOOL_SUBJ_HDR |
3 | SCHOOL_CRSE_NBR | Character(10) | VARCHAR2(10) NOT NULL | School Course Nbr |
4 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
6 | EXT_SUBJECT_AREA | Character(4) | VARCHAR2(4) NOT NULL |
External Subject Area
Default Value: SCHOOL_SUBJ_TBL.EXT_SUBJECT_AREA Prompt Table: EXT_SUBJECT_TBL |
7 | EXT_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
External Career
GRAD=Graduate HS=High School LAW=Law MED=Medical UGRD=Undergraduate |
8 | EXT_CRSE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
External Course Type
C=Challenge CRS=Course E=Equivalency EVT=Event or Summary N/A=Course - Not Applicable REP=Course - Repeated WTH=Course - Withdrawn |
9 | COURSE_LEVEL | Character(2) | VARCHAR2(2) NOT NULL |
Course Level
11=Grade 11 12=Grade 12 AP=Advanced Placement DR=Graduate/Doctoral FR=Freshman GR=Graduate HN=Honors IB=International Baccalaureate JR=Junior LD=Lower Division MS=Graduate/Master RG=Regular SO=Sophomore SR=Senior UD=Upper Division |
10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
11 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: SCHOOL_CRSE_TBL.DESCR |
12 | EXT_UNITS | Number(6,2) | DECIMAL(5,2) NOT NULL | External Units |