INSTITUTIONCRSE_IDPrompt Table: SSR_AC_OFFVW
CRSE_OFFER_NBRPrompt Table: CRSE_OFFER
CRS_TOPIC_IDPrompt Table: CRSE_TOPICS
SSR_CW_EFF_DA=Active
I=Inactive
SSR_AC_CRSE_VW(SQL View) |
Index Back |
|---|---|
Academic Item Reg Header |
| SELECT A.INSTITUTION , A.CRSE_ID , A.CRSE_OFFER_NBR , A.CRS_TOPIC_ID , A.EFFDT , A.EFF_STATUS , A.SSR_AC_CONTENT_ID FROM PS_SSR_AC_CRSEREF A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL |
Course ID
Prompt Table: SSR_AC_OFFVW |
| 3 | CRSE_OFFER_NBR |
Number(2,0) | SMALLINT NOT NULL |
Course Offering Nbr
Prompt Table: CRSE_OFFER |
| 4 | CRS_TOPIC_ID |
Number(3,0) | SMALLINT NOT NULL |
Course Topic ID
Prompt Table: CRSE_TOPICS |
| 5 | SSR_CW_EFF_D |
Date(10) | DATE | Effective Date |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | SSR_AC_CONTENT_ID | Character(13) | VARCHAR2(13) NOT NULL | Activity Registry ID |