OR_CASE_IMP_FIN_COUNSEL
Description:
Stores the implant financial counseling information.

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 IMPLANT_INV_ITEM_ID VARCHAR No
Stores the supply record for a requested implant.
4 IMPLANT_INV_ITEM_ID_SUPPLY_NAME VARCHAR No
The name of the inventory item.
5 IMPLANT_CLASS_C_NAME VARCHAR No
Stores the class of the implant.
May contain organization-specific values: Yes
No Entries Defined
6 PATIENT_REQUESTED_C_NAME VARCHAR No
Stores if the implant was requested by the patient.
May contain organization-specific values: Yes
No Entries Defined
7 IMPLANT_CLIN_CMTS VARCHAR No
Stores the comment for the implant.
8 CLINICAL_IND_C_NAME VARCHAR No
Stores the clinical indication for the requested implant.
May contain organization-specific values: Yes
Category Entries:
None