INSTITUTIONPrompt Table: INSTITUTION_TBL
ACAD_ORGPrompt Table: ACAD_ORG_TBL_VW
SUBJECTEFFDTDefault Value: %date
LANGUAGE_CDSSR_SUBORG_LNG(SQL View) |
Index Back |
|---|---|
Subject ViewThis Subject Table view should be used as the prompt table for Subject if it is in a search record. Effective Status is not in the view so inactive Subjects will be included in the list of valid values. |
| SELECT S.INSTITUTION , %Substring(E.TREE_NODE,1,10) , S.SUBJECT , S.EFFDT , L.LANGUAGE_CD , L.DESCR , L.DESCRSHORT FROM PS_SUBJECT_TBL S , PS_SUBJECT_TBL_LV L ,PSTREENODE E WHERE E.SETID=' ' AND E.TREE_NAME='ACAD_ORGANIZATION' AND E.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN ES WHERE ES.SETID = E.SETID AND ES.TREE_NAME = E.TREE_NAME AND ES.EFFDT <= %CurrentDateIn) AND S.ACAD_ORG IN ( SELECT %Substring(EC.TREE_NODE,1,10) FROM PSTREENODE EC WHERE EC.SETID = E.SETID AND EC.TREE_NAME = E.TREE_NAME AND EC.EFFDT = E.EFFDT AND EC.TREE_NODE_NUM BETWEEN E.TREE_NODE_NUM AND E.TREE_NODE_NUM_END) AND S.INSTITUTION = L.INSTITUTION AND S.SUBJECT = L.SUBJECT AND S.EFFDT = L.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | ACAD_ORG |
Character(10) | VARCHAR2(10) NOT NULL |
Academic Organization
Prompt Table: ACAD_ORG_TBL_VW |
| 3 | SUBJECT |
Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |