INSTR_ORG_VW2(SQL View) |
Index Back |
|---|---|
Instr Advisor View - SubjectsInstructor Edit in the Academic Organization Table indicates if Class Instructor ID should prompt on Personal Data or Instructor Advisor Table. This view is used as the prompt table for Class Instructor ID if Instructor Edit is set to Instructor Advisor Table and NO checkboxes are on. Instructors who are defined as Advisors Only are excluded. |
| SELECT C.ACAD_ORG , C.INSTITUTION , B.EMPLID , B.EFFDT , C.CRSE_ID , C.CRSE_OFFER_NBR , C.CAMPUS , C.SUBJECT , B.INSTR_AVAILABLE , B.INSTR_TYPE , B.EFF_STATUS , A.NAME , D.CAMPUS_ID , A.LAST_NAME_SRCH , A.FIRST_NAME_SRCH FROM PS_SCC_CUR_NM_VW2 A , PS_INSTR_ADVISOR B , PS_INSTR_CRSE C , PS_SCC_PERS_SA_VW D WHERE B.INSTR_TYPE <> 'ADV' AND B.INSTR_AVAILABLE = 'A' AND A.EMPLID = B.EMPLID AND B.EMPLID = C.EMPLID AND C.EMPLID = D.EMPLID AND A.EMPLID = D.EMPLID AND B.EMPLID = D.EMPLID AND B.EFFDT=C.EFFDT AND B.INSTITUTION=C.INSTITUTION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ACAD_ORG |
Character(10) | VARCHAR2(10) NOT NULL |
Academic Organization
Prompt Table: ACAD_ORG_TBL |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EFFDT | Date(10) | DATE | Effective Date |
| 5 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 6 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 7 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL | Campus |
| 8 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 9 | INSTR_AVAILABLE | Character(2) | VARCHAR2(2) NOT NULL |
Instructor Available
A=Available S=Sabbatical U=Unavailable |
| 10 | INSTR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Instructor Type
ADJ=Adjunct Professor ADV=Advisor Only ASSC=Associate Professor ASST=Assistant Professor EMRT=Emeritus INST=Instructor LECT=Lecturer PROF=Professor TA=Teaching Assistant UNDF=Undefined VLEC=Visiting Lecturer VPRF=Visiting Professor |
| 11 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 12 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 13 | CAMPUS_ID | Character(16) | VARCHAR2(16) NOT NULL | Campus ID |
| 14 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 15 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |