COM_IDMEET_IDGM_MEET_SRCH(SQL View) |
Index Back |
|---|---|
Protocol Committee Meeting SetControl Table to capture the Protocol Committee Meeting . Setup Table for Grants Protocol Management |
| SELECT A.COM_ID , A.MEET_ID , A.MEET_DT , A.DESCR , A.START_TIME , A.END_TIME , A.PCL_MAX , A.NOTES , A.CONVENE_TIME , A.ADJ_TIME FROM PS_GM_PCL_COM_MEET A WHERE A.MEET_DT >= %CurrentDateIn |
| # | 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 |