CRSECATVWLNG(SQL View) |
Index Back |
---|---|
Rel Lang Course Catalog ViewCRSECATVWLNG is the language record related to CRSE_CAT_VW A related language record enables text fields on a table to be translated into various languages for use in other countries. |
SELECT DISTINCT B.INSTITUTION ,A.CRSE_ID ,C.LANGUAGE_CD ,C.DESCR FROM PS_CRSE_CATALOG A , PS_CRSE_OFFER B , PS_CRSE_CATLG_LNG C WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_CRSE_CATLG_LNG A_ED WHERE C.CRSE_ID = A_ED.CRSE_ID AND A_ED.EFFDT <= %CurrentDateIn ) AND C.CRSE_ID = B.CRSE_ID AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_CRSE_OFFER B_ED WHERE B.CRSE_ID = B_ED.CRSE_ID AND B_ED.EFFDT <= A.EFFDT) AND EFF_STATUS = 'A' AND A.CRSE_ID=C.CRSE_ID AND A.EFFDT=C.EFFDT |
# | 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 |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |