EMPLIDPrompt Table: PEOPLE_SRCH
CAMPUS_EVENT_NBRPrompt Table: CAMPUS_EVENT
Prompt Table: CAMPUS_EVNT_ATT
BRTH=Brother
COWK=Co-Worker
EMPL=Employee
FRND=Friend
FTHR=Father
MTHR=Mother
RLTV=Relative
SIST=Sister
SPSE=Spouse
UNKN=Unknown
CAMPUS_GUEST_VW(SQL View) |
Index Back |
|---|---|
Campus Event Guests View |
| SELECT b.emplid ,a.CAMPUS_EVENT_NBR ,a.CAMPUS_EVENT_ATND ,a.name ,a.guest_relationship FROM PS_CAMPUS_EVNT_ATT a ,PS_CAMPUS_EVNT_ATT B WHERE A.guest_attendee <> '0' AND A.GUEST_ATTENDEE = B.CAMPUS_EVENT_ATND AND a.CAMPUS_EVENT_NBR = b.CAMPUS_EVENT_NBR |
| # | 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: CAMPUS_EVENT |
| 3 | CAMPUS_EVENT_ATND | Character(5) | VARCHAR2(5) NOT NULL |
Campus Event Attendee
Prompt Table: CAMPUS_EVNT_ATT |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | GUEST_RELATIONSHIP | Character(4) | VARCHAR2(4) NOT NULL |
Guest Relationship
BRTH=Brother COWK=Co-Worker EMPL=Employee FRND=Friend FTHR=Father MTHR=Mother RLTV=Relative SIST=Sister SPSE=Spouse UNKN=Unknown |