CAMPUS_EVNT_CHK(SQL Table) |
Index Back |
|---|---|
Event ChecklistCAMPUS_EVNT_CHK is used to create a list of requirements relative to an event. There is one record in this table for each dated list. |
| # | 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 | CHECKLIST_CD | Character(6) | VARCHAR2(6) NOT NULL |
Checklist Code
Prompt Table: EVE_CHKLST_VW |
| 4 | CHECKLIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Checklist Status
C=Completed I=Initiated Default Value: I |
| 5 | STATUS_DT | Date(10) | DATE |
Status Date
Default Value: %date |
| 6 | STATUS_CHANGE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Status Change ID
Prompt Table: PEOPLE_SRCH |
| 7 | DUE_DT | Date(10) | DATE | Due Date |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Default Value: OPR_DEF_TBL_CS.DEPTID Prompt Table: DEPT_TBL |
| 9 | RESPONSIBLE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Responsible ID
Default Value: CAMPUS_EVNT_CHK.STATUS_CHANGE_ID Prompt Table: PEOPLE_SRCH |
| 10 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 11 | CAMPUS_MTG_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Campus Meeting
Y/N Table Edit Default Value: N |
| 12 | EVENT_MTG_NBR | Number(4,0) | SMALLINT NOT NULL |
Event Meeting Nbr
Prompt Table: EVENT_MTG |
| 13 | COMMENTS | Long Character | CLOB | Comment |