OR_CASE_IB_HIST

Description: |
The OR_CASE_IB_HIST table contains OR management system case In Basket history.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
OR_CASE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | OR_CASE_ID | VARCHAR | No |
The unique ID of the case record.
2 | LINE | INTEGER | No |
The number of the line of the In Basket history for the case.
3 | IB_HIST_ACTION_C_NAME | VARCHAR | No |
The category value which indicates the type of action the message serves to notify.
May contain organization-specific values: Yes
Category Entries:
Approved
Denied
Request More Info
Moved
Removed
Canceled
Scheduled
Potential Procedure Mismatch Detected
4 | IB_HIST_SENDER_ID | VARCHAR | No |
The unique ID of the user who sent the message.
5 | IB_HIST_SENDER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | IB_HIST_RECP_ID | VARCHAR | No |
The unique ID of the user who is the first recipient of the message.
7 | IB_HIST_RECP_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
8 | IB_HIST_DATE | DATETIME (Local) | No |
The date and time the message was sent.
9 | IB_HIST_SUBJECT | VARCHAR | No |
The subject line of the message.
10 | IB_HIST_BODY_LINE | INTEGER | No |
The line number where the message body begins in the case record.
11 | IB_HIST_BODY_LEN | INTEGER | No |
The length of the message body in the case record.
12 | IB_HIST_RECIP_INI | VARCHAR | No |
The database initials of the recipient registry in the message.
13 | IB_HIST_MESSAGE_ID | VARCHAR | No |
The message ID of the message.