Abortion IndAnesthesia IndComplication IndC Section IndLaboratory Process IndNewborn IndProcedure CodeProcedure Code DescrProcedure NameProcess Class IndRBRVS NumReport Result IndRequired DocumentationVaginal Delivery Ind
| Business Data Model Data Model |
| Description | A code that identifies a procedure within a code set or code type. Standard procedure code sets include Current Procedural Terminology (CPT) and Universal Billing (UB) Revenue codes. |
| Relationship | |
 Procedure Code_Coding System Version_FK |
|
| Procedure Code_Procedure Code_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Abortion Ind
| Description | Indicates whether or not this procedure involved an abortion. |
| 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 |
Anesthesia Ind
| Description | Indicates whether or not this procedure involved the use of anesthesia. |
| 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 |
Complication Ind
| Description | Indicates whether or not this procedure is due to a complication. |
| 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 |
C Section Ind
| Description | Indicates whether or not this procedure involved a C Section. |
| 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 |
Laboratory Process Ind
| Description | Indicates whether or not this procedure is a laboratory procedure. |
| 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 |
Newborn Ind
| Description | Indicates whether or not this procedure is performed on a new born. |
| 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 |
Procedure Code
| Description | A unique code that identifies a procedure within a coding system. Standard procedure code sets include Current Procedural Terminology (CPT), SNOMED and Healthcare Common and Universal Billing (UB) Revenue codes. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Procedure Code Descr
| Description | A textual description of the procedure or service. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Procedure Name
| Description | Name of the procedure. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Process Class Ind
| Description | Indicates whether or not this procedure is a complication or co-morbidity. |
| 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 |
RBRVS Num
| Description | Identifies the Resource Based Relative Value Scale (RBRVS) number for the procedure code. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Report Result Ind
| Description | Indicates whether or not the Procedure has a result that is reportable to the requester. |
| 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 |
Required Documentation
| Description | Supporting documentation that is required when processing a claim for this procedure code. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Vaginal Delivery Ind
| Description | Indicates whether or not this procedure involved a vaginal delivery. |
| 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 |
| Relationship Details |
Procedure Code_Coding System Version_FK
| Is Identifying Relationship | true |
| Child Table | Procedure Code |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Coding System Version |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Procedure Code_Procedure Code_FK
| Is Identifying Relationship | false |
| Child Table | Procedure Code |
| Child Role Name | is associated to |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Procedure Code |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |