CAMPUS_EVENT_NBRPrompt Table: CAMPUS_EVENT
CHECKLIST_DTTMDefault Value: %date
LANGUAGE_CDEVNT_CK_SRCH_LN(SQL View) |
Index Back |
|---|---|
EVNT_CK_SRCH_LNRelated Language for EVENT_CHK_SRCH |
| SELECT a.campus_event_nbr , a.checklist_dttm , c.language_cd , c.descr FROM PS_CAMPUS_EVNT_CHK a , PS_CAMPUS_EVENT B ,PS_CAMPUS_EVNT_LNG C WHERE A.CAMPUS_EVENT_NBR = B.CAMPUS_EVENT_NBR AND A.CAMPUS_EVENT_NBR = C.CAMPUS_EVENT_NBR |
| # | 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 | CHECKLIST_DTTM |
DateTime(26) | TIMESTAMP NOT NULL |
Checklist Date Time
Default Value: %date |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |