CATALOG_ORGPrompt Table: CATALOG_ORG_VW
SCHOOL_SUBJECTPrompt Table: SCHOOL_SUBJ_HDR
SCHOOL_CRSE_NBRPrompt Table: SCHOOL_CRSE_HDR
EFFDTLANGUAGE_CDCAT_CRSE_VW_LNG(SQL View) |
Index Back |
|---|---|
Rel Lang Vw - CAT_CRSE_VWRelated Language View of Catalog Org Course Prompt Tbl |
| SELECT DISTINCT A.CATALOG_ORG , B.SCHOOL_SUBJECT , B.SCHOOL_CRSE_NBR , B.EFFDT , C.LANGUAGE_CD , C.DESCR FROM PS_EXT_ORG_TBL_ADM A , PS_SCHOOL_CRSE_TBL B , PS_SCHOOL_CRSE_LNG C WHERE A.CATALOG_ORG = B.EXT_ORG_ID AND B.EXT_ORG_ID = C.EXT_ORG_ID AND B.SCHOOL_SUBJECT = C.SCHOOL_SUBJECT AND B.SCHOOL_CRSE_NBR = C.SCHOOL_CRSE_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CATALOG_ORG |
Character(11) | VARCHAR2(11) NOT NULL |
Catalog Organization
Prompt Table: CATALOG_ORG_VW |
| 2 | SCHOOL_SUBJECT |
Character(8) | VARCHAR2(8) NOT NULL |
School Subject
Prompt Table: SCHOOL_SUBJ_HDR |
| 3 | SCHOOL_CRSE_NBR |
Character(10) | VARCHAR2(10) NOT NULL |
School Course Nbr
Prompt Table: SCHOOL_CRSE_HDR |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |