INSTITUTIONPrompt Table: INSTITUTION_TBL
ACAD_ORGPrompt Table: ACAD_ORG_TBL
EFFDTDefault Value: %date
A=Active
I=Inactive
Prompt Table: CAMPUS_TBL
ACADORG_TREE_VW(SQL View) |
Index Back |
|---|---|
Acad Org Tbl & PSTREENODEThis view lists maximum effdt of Academic Organizations within a given institution "WHERE ACAD_TBL.ACAD_ORG =PSTREENODE.TREE_NODE" . Outside of the ACAD_ORG_TBL panel user can only choose ORGs that have nodes on the trees. |
| SELECT DISTINCT A.INSTITUTION, A.ACAD_ORG, A.EFFDT, A.EFF_STATUS, A.DESCR, A.CAMPUS, B.TREE_NODE FROM PS_ACAD_ORG_TBL A ,PSTREENODE B WHERE A.ACAD_ORG=B.TREE_NODE AND A.EFFDT =(SELECT MAX(EFFDT) FROM PS_ACAD_ORG_TBL C WHERE A.ACAD_ORG = C.ACAD_ORG 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
Prompt Table: INSTITUTION_TBL |
| 2 | ACAD_ORG |
Character(10) | VARCHAR2(10) NOT NULL |
Academic Organization
Prompt Table: ACAD_ORG_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL |
Campus
Prompt Table: CAMPUS_TBL |
| 7 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |