| Data element |
Definition |
|
CREATE_DT
Indexed - no
Format - date
May be null? no
|
The creation date of the record.
|
| CREATE_ID
Indexed - no
Format - varchar2(12)
May be null? no
|
The Penn ID of the person who created the record. |
| ID
Indexed - yes (primary key)
Format - numbe
May be null? no
|
A unique identifier of each meeting record. |
| LAST_UPD
Indexed - no
Format - timespamp
May be null? yes |
The date/time on which the meeting record was last updated.
|
| MEET_DATE
Indexed - no
Format - date
May be null? no |
The date of the PSC or PSCS meeting. |
| MEET_NUM
Indexed - no
Format - number
May be null? yes |
The sequence number of the meeting, as assigned by the Office of the Provost. |
| STATUS
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the status of the meeting. Use this to join to the FIS_MEETING_STATUS_LOOKUP table on the MESSAGE_ID field. NAME_FRIENDLY is contains the meeting status description (e.g., Not Reviewable, Reviewable, Closed to Review, Done, Cancelled). |
| TYPE
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the type of meeting. Use this to join to the FIS_MEETING_TYPE_LOOKUP table on the MESSAGE_ID field. NAME_FRIENDLY is contains the meeting type description (e.g., PSC, PSCS, Trustees). |
| UPD_DT
Indexed - no
Format - date
May be null? no
|
The date the address record was last updated. |
| UPD_ID
Indexed - no
Format - varchar2(12)
May be null? no
|
The Penn ID of the person who last updated the record. |
