OR_CASE_MATERIALS_SPEC_ND
Description:
Case materials special needs table.

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 CASE_MATERIALS_SPEC_NDS_C_NAME VARCHAR No
This item stores the case materials special needs.
May contain organization-specific values: Yes
No Entries Defined
4 CASE_MATERIALS_SPEC_NDS_QTY INTEGER No
This item stores the materials special needs quantity.
5 CASE_MATERIALS_SPEC_NDS_SIZE INTEGER No
This item stores the materials special needs size.
6 CASE_MATERIALS_SPEC_NDS_FT VARCHAR No
This item stores the free text for case materials special needs.
7 CASE_MATERIALS_SPEC_NDS_SZ_FT VARCHAR No
This item stores the free text information for the case materials size special needs.
8 MATERIALS_SITE_MOD_C_NAME VARCHAR No
This item stores the materials special needs site modifier
May contain organization-specific values: Yes
No Entries Defined
9 MATERIALS_POWER_C_NAME VARCHAR No
This item stores the materials special needs power
May contain organization-specific values: Yes
No Entries Defined
10 MATERIALS_SIZE_C_NAME VARCHAR No
This item stores the materials special needs size category
May contain organization-specific values: Yes
No Entries Defined
11 MATERIALS_MODEL_C_NAME VARCHAR No
This item stores the materials special needs model
May contain organization-specific values: Yes
No Entries Defined