EMPLIDINSTITUTIONSSR_APT_INSTANCESSR_ITEM_IDSSR_AR_CRSE_VW(SQL View) |
Index Back |
|---|---|
AR Crse Offering View |
| SELECT HDR.EMPLID , HDR.INSTITUTION , HDR.SSR_APT_INSTANCE , HDR.SSR_ITEM_ID , HDR.DESCR50 , REF.crse_offer_nbr , REF.crs_topic_id , REF.ssr_ac_content_id FROM PS_SSR_REQ_DESCR_V HDR , PS_SSR_AC_CRSEREF REF , PS_SSR_AIR_H_CRSE CRSE WHERE REF.INSTITUTION = CRSE.INSTITUTION AND REF.CRSE_ID = CRSE.CRSE_ID AND REF.EFF_STATUS = 'A' AND HDR.INSTITUTION = REF.INSTITUTION AND HDR.SSR_ITEM_ID = CRSE.SSR_ITEM_ID AND %EffdtCheck(SSR_AC_CRSEREF REF_ED, REF, %CurrentDateIn) AND %EffdtCheck(SSR_AIR_H_CRSE CRSE_ED, CRSE, %CurrentDateIn) |
| # | 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 |
| 3 | SSR_APT_INSTANCE |
Number(3,0) | SMALLINT NOT NULL | Academic Progress Tracker Instance Number |
| 4 | SSR_ITEM_ID |
Character(11) | VARCHAR2(11) NOT NULL | Academic Item ID |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 6 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 7 | CRS_TOPIC_ID | Number(3,0) | SMALLINT NOT NULL | Course Topic ID |
| 8 | SSR_AC_CONTENT_ID | Character(13) | VARCHAR2(13) NOT NULL | Activity Registry ID |