CLASSRSTSRCOVLN(SQL View) |
Index Back |
|---|---|
Rel lang Class Roster SearchCLASSRSTSRCOVLN is the language record related to CLASS_RST_SRCOV A related language record enables text fields on a table to be translated into various languages for use in other countries. |
| SELECT A.INSTITUTION ,A.STRM ,A.SUBJECT ,A.CATALOG_NBR ,A.CLASS_NBR ,F.OPRID ,D.LANGUAGE_CD ,A.DESCR FROM PS_CLASS_TBL A , PS_CLASS_MTG_PAT B , PS_CLASS_INSTR C , PSOPRDEFN F , PS_CLASS_TBL_LANG D WHERE A.CRSE_ID = B.CRSE_ID AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND A.STRM = B.STRM AND A.SESSION_CODE = B.SESSION_CODE AND A.CLASS_SECTION = B.CLASS_SECTION AND C.CRSE_ID = B.CRSE_ID AND C.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND C.STRM = B.STRM AND C.SESSION_CODE = B.SESSION_CODE AND C.CLASS_SECTION = B.CLASS_SECTION AND C.CLASS_MTG_NBR = B.CLASS_MTG_NBR AND C.EMPLID = F.EMPLID AND A.CRSE_ID =D.CRSE_ID AND A.CRSE_OFFER_NBR =D.CRSE_OFFER_NBR AND A.STRM =D.STRM AND A.SESSION_CODE =D.SESSION_CODE AND A.CLASS_SECTION=D.CLASS_SECTION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | STRM |
Character(4) | VARCHAR2(4) NOT NULL |
Term
Default Value: OPR_DEF_TBL_CS.STRM Prompt Table: TERM_VAL_TBL |
| 3 | SUBJECT |
Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Default Value: OPR_DEF_TBL_CS.SUBJECT Prompt Table: SUBJECT_TBL |
| 4 | CATALOG_NBR |
Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 5 | CLASS_NBR |
Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 6 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |