COM_IDMEET_IDGM_PCL_COM_MEET(SQL Table) |
Index Back |
|---|---|
Protocol Committee Meeting SetControl Table to capture the Protocol Committee Meeting . Setup Table for Grants Protocol Management |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COM_ID |
Character(5) | VARCHAR2(5) NOT NULL | Committee Id. Used in Grants Protocol Setup |
| 2 | MEET_ID |
Character(5) | VARCHAR2(5) NOT NULL | Meeting Id. Used in Grants Protocol Setup |
| 3 | MEET_DT | Date(10) | DATE | Meeting date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 6 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 7 | PCL_MAX | Number(4,0) | SMALLINT NOT NULL | Maximum Number of Protocols |
| 8 | NOTES | Long Character | CLOB | Budget Notes |
| 9 | CONVENE_TIME | Time(15) | TIMESTAMP | Meeting Convened Time |
| 10 | ADJ_TIME | Time(15) | TIMESTAMP | Meeting Adjourned Time |