EMPLIDCAMPUS_EVENT_NBRPrompt Table: CAMPUS_EVENT
EVENT_MTG_NBRPrompt Table: EVENT_MTG
INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
SCC_PS_EVNT_BND(SQL View) |
Index Back |
|---|---|
PopSel Bind Record for EVNT |
| SELECT A.EMPLID , A.CAMPUS_EVENT_NBR , A.EVENT_MTG_NBR ,B.INSTITUTION , C.NAME FROM PS_CAMPUS_MTG_SEL A , PS_CAMPUS_EVENT B , PS_CAMPUS_EVNT_ATT C WHERE A.CAMPUS_EVENT_NBR = B.CAMPUS_EVENT_NBR AND A.CAMPUS_EVENT_NBR = C.CAMPUS_EVENT_NBR AND A.EMPLID = C.EMPLID AND A.EMPLID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CAMPUS_EVENT_NBR |
Character(9) | VARCHAR2(9) NOT NULL |
Event ID
Prompt Table: CAMPUS_EVENT |
| 3 | EVENT_MTG_NBR |
Number(4,0) | SMALLINT NOT NULL |
Event Meeting Nbr
Prompt Table: EVENT_MTG |
| 4 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |