SSR_AC_CONTX_TYPECRSE=Coursework
SSR_ADC_ACTN_IDEFFDTSSR_AC_CONTENT_TPPrompt Table: SSR_ADC_COSRCVW
SSR_ADC_ACTCOVW(SQL View) |
Index Back |
|---|---|
Source View SSR_ADC_ID_CONTSource View for SSR_ADC_ID_CONT |
| SELECT DISTINCT A.SSR_AC_CONTX_TYPE , A.SSR_ADC_ACTN_ID , A.EFFDT , A.SSR_AC_CONTENT_TP FROM PS_SSR_ADC_ACT_CON A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_AC_CONTX_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Academic Content Context Type
CRSE=Coursework |
| 2 | SSR_ADC_ACTN_ID |
Character(20) | VARCHAR2(20) NOT NULL | Action Date ID |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | SSR_AC_CONTENT_TP |
Character(20) | VARCHAR2(20) NOT NULL |
Academic Content Type
Prompt Table: SSR_ADC_COSRCVW |