| Business Data Model Data Model |
| Description | A procedure that a dental practitioner performs on a patient. |
| Generalization | |
 Dental Treatment_Procedure_Gen |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Dental Procedure Cnt
| Description | A count of the number of procedures involved in the dental treatment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Dental Surgery Type
| Description | Indicates the type of any surgery involved in the dental treatment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Oral Cavity Designation Code
| Description | Identifies an oral cavity involved in the treatment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Orthodontic Banding Date
| Description | The date upon which orthodontic bands were applied. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Orthodontic Treatment Ind
| Description | Indicates that reported treatment was for orthodontic purposes. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Orthodontic Treatment Months Cnt
| Description | The estimated number of months over which the orthodontic treatment will take place. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Orthodontic Treatment Months Remaining Cnt
| Description | The estimated number of months remaining before the orthodontic treatment will be complete. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Prior Placement Date
| Description | The date upon which a prosthesis, crown or inlay was previously installed if this service is a replacement. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Prosthesis Crown or Inlay Code
| Description | Identifies the placement status for the dental work involving an appliance or prosthesis. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Prosthesis Replacement Date
| Description | The date upon which an appliance or prosthesis was replaced. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Tooth Code
| Description | An indication of the tooth on which services were performed or will be performed. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Tooth Num
| Description | Standard identification number of a tooth. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Small [SHORT] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Tooth Status
| Description | Classification of the status of a tooth |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Tooth Surface
| Description | The surface(s) of the tooth on which services were performed or will be performed. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Generalization Details |
Dental Treatment_Procedure_Gen
| Supertype | Procedure |
| Subtype | Dental Treatment |
| Transform As | TABLE |
| Business Data Model Data Model |