EMPLIDPrompt Table: PEOPLE_SRCH
CAMPUS_EVENT_NBRPrompt Table: EVENT_SRCH
CAMPUS_EVENT_ATNDLANGUAGE_CDEVENT_ATT_VWLNG(SQL View) |
Index Back |
|---|---|
Event Attendees ViewEVENT_ATT_VW is a view of CAMPUS_EVNT_ATT, it is used in the PERSON EVENT summary panels. |
| SELECT a.emplid , a.campus_event_nbr , a.campus_event_atnd ,B.LANGUAGE_CD , B.descr FROM PS_CAMPUS_EVNT_ATT A ,PS_CMP_EVNT_ATT_LN B WHERE A.CAMPUS_EVENT_NBR=B.CAMPUS_EVENT_NBR AND A.CAMPUS_EVENT_ATND=B.CAMPUS_EVENT_ATND |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | CAMPUS_EVENT_NBR |
Character(9) | VARCHAR2(9) NOT NULL |
Event ID
Prompt Table: EVENT_SRCH |
| 3 | CAMPUS_EVENT_ATND |
Character(5) | VARCHAR2(5) NOT NULL | Campus Event Attendee |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |