OWNERSHIP_IDBUSINESS_UNITAGENDA_IDLANGUAGE_CDFO_BRN_AGNDA_LN(SQL View) |
Index Back |
|---|---|
Related Language RecordRelated language record for open agenda items |
| SELECT DTL.OWNERSHIP_ID , DTL.BUSINESS_UNIT , DTL.AGENDA_ID , LANG.LANGUAGE_CD , LANG.DESCR FROM PS_FO_AGENDA_DTL DTL , PS_FO_EVENTS_SETUP STP , PS_FO_EVENTSET_LNG LANG WHERE DTL.COMPLETED = 'N' AND STP.EVENT='TMP' AND STP.EVENT_TYPE=DTL.EVENT_TYPE AND STP.FO_EVNT_PROC<>'Y' AND STP.FO_CHECK1_PB='Y' AND LANG.EVENT = STP.EVENT AND LANG.EVENT_TYPE = STP.EVENT_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OWNERSHIP_ID |
Character(30) | VARCHAR2(30) NOT NULL | Owning Organization |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | AGENDA_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Agenda ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |