CASE_SPEC_ROOM_TXT
Description:
This table contains any free text comments about room special needs in the case record.
Primary Key
Column Name
Ordinal Position
CASE_ID
1
LINE
2
Column Information
Name
Type
Discontinued?
1
CASE_ID
VARCHAR
No
The unique identifier for the case request record.
2
LINE
INTEGER
No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3
ROOM_FREETEXT
VARCHAR
No
The category number for the special room needs required for a case request.