RPT_REASON Table
The RPT_REASON table holds the key-value pairs of reason IDs to their text strings describing the reasons for denial or check-in. This is a look-up table; the data in this table is never altered (inserted, edited, or deleted).
(This table is not shown in the reporting schema diagram.)
|
Column Name |
Data Type |
Data Length |
Description |
Constraints |
|
REASON_ID |
Integer |
1 |
The ID that is the key to the reason for denial or check-in. It is cross-referenced with denial and check-in events from the RPT_USAGE_NOLIC_EVENT_153 Table. |
Not nullable. Part of the primary key of the table. |
|
REASON |
Nullable String |
255 |
The text strings describing the reasons for denials and check-ins. |
|