ATTENDEE_VW(SQL View) |
Index Back |
---|---|
Campus Event Attendees viewThis view is used to display the name of attendee |
SELECT campus_event_nbr , campus_event_atnd , name FROM PS_CAMPUS_EVNT_ATT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CAMPUS_EVENT_NBR | Character(9) | VARCHAR2(9) NOT NULL |
Event ID
Prompt Table: CAMPUS_EVENT |
2 | CAMPUS_EVENT_ATND | Character(5) | VARCHAR2(5) NOT NULL | Campus Event Attendee |
3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |