SETIDPrompt Table: SETID_TBL
ACAD_ORGPrompt Table: ACAD_ORG_SRCH
LANGUAGE_CDEFFDTDefault Value: %date
ACAD_ORG_TB2_LN(SQL View) |
Index Back |
|---|---|
Academic Org Table View 2This view is a prompt table for Facility Table Academic Organization. It restricts the list of possible values to Academic Organizations within Institution(s) the current Facility Table SetID maps to. This is the related language view for ACAD_ORG_TB2_VW |
| SELECT A.SETID , B.ACAD_ORG , C.LANGUAGE_CD , B.EFFDT , C.DESCR FROM PS_SET_CNTRL_GROUP A , PS_ACAD_ORG_TBL B , PS_ACAD_ORG_LANG C WHERE REC_GROUP_ID = 'FACILITY' AND A.SETCNTRLVALUE = B.INSTITUTION AND B.ACAD_ORG = C.ACAD_ORG AND B.EFFDT = C.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | ACAD_ORG |
Character(10) | VARCHAR2(10) NOT NULL |
Academic Organization
Prompt Table: ACAD_ORG_SRCH |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |