SSR_IAM_APTSQVW(SQL View) |
Index Back |
|---|---|
APT Item Seq ViewAPT Item Seq View - used by AM |
| SELECT DISTINCT C.EMPLID , C.INSTITUTION , C.SSR_APT_INSTANCE , C.SSR_APT_ITEM_SEQ , C.SSR_ITEM_ID , C.SSR_ITEM_TYPE , B.CLASS_NBR , O1.SSR_COMPONENT FROM PS_SSR_APT_ITEM A , PS_SSR_APT_ENRL B , PS_SSR_APT_ITEM C LEFT OUTER JOIN PS_SSR_AIR_H_CMPNT O1 ON C.INSTITUTION = O1.INSTITUTION AND C.SSR_ITEM_ID = O1.SSR_ITEM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | SSR_APT_INSTANCE |
Number(3,0) | SMALLINT NOT NULL | Academic Progress Tracker Instance Number |
| 4 | SSR_APT_ITEM_SEQ |
Number(6,0) | INTEGER NOT NULL | APT Item Seq |
| 5 | SSR_ITEM_ID | Character(11) | VARCHAR2(11) NOT NULL | Academic Item ID |
| 6 | SSR_ITEM_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Academic Item Type |
| 7 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 8 | SSR_COMPONENT | Character(3) | VARCHAR2(3) NOT NULL |
Course Component.
CLN=Clinical CON=Continuance DIS=Discussion FLD=Field Studies IND=Independent Study LAB=Laboratory LEC=Lecture PRA=Practicum RSC=Research SEM=Seminar SUP=Supervision THE=Thesis Research TUT=Tutorial |