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. |