Entity Name | Entity Type | Entity Attribute Name | Entity Attribute Required | Entity Attribute Is PK | Entity Attribute Is FK | Entity Attribute Domain Name |
---|---|---|---|---|---|---|
CERTIFICATION REQUIREMENT | Dependent | HEALTH CARE OFFERING ID | Yes | Yes | Yes | ID |
CERTIFICATION REQUIREMENT | Dependent | CERTIFICATION TYPE ID | Yes | Yes | Yes | ID |
CERTIFICATION STATUS | Dependent | STATUS TYPE ID | Yes | Yes | Yes | ID |
CERTIFICATION STATUS | Dependent | HEALTH CARE DELIVERY ID | Yes | Yes | Yes | ID |
CERTIFICATION STATUS | Dependent | STATUS DATE | Yes | Yes | No | Datetime |
CERTIFICATION STATUS TYPE | Dependent | STATUS TYPE ID | Yes | Yes | Yes | ID |
CERTIFICATION TYPE | Independent | CERTIFICATION TYPE ID | Yes | Yes | No | ID |
CERTIFICATION TYPE | Independent | DESCRIPTION | Yes | No | No | Description |
DELIVERY OUTCOME | Dependent | HEALTH CARE DELIVERY ID | Yes | Yes | Yes | ID |
DELIVERY OUTCOME | Dependent | DELIVERY OUTCOME ID | Yes | Yes | No | ID |
DELIVERY OUTCOME | Dependent | OUTCOME TYPE ID | No | No | Yes | ID |
DELIVERY OUTCOME | Dependent | OUTCOME EXPLANATION | Yes | No | No | Long varchar |
DIAGNOSIS | Independent | DIAGNOSIS ID | Yes | Yes | No | ID |
DIAGNOSIS | Independent | HEALTH CARE EPISODE ID | No | No | Yes | ID |
DIAGNOSIS | Independent | DIAGNOSIS TYPE ID | Yes | No | Yes | ID |
DIAGNOSIS | Independent | DIAGNOSIS DATE | Yes | No | No | Datetime |
DIAGNOSIS TREATMENT | Dependent | DIAGNOSIS ID | Yes | Yes | Yes | ID |
DIAGNOSIS TREATMENT | Dependent | HEALTH CARE DELIVERY ID | Yes | Yes | Yes | ID |
DIAGNOSIS TYPE | Independent | DIAGNOSIS TYPE ID | Yes | Yes | No | ID |
DIAGNOSIS TYPE | Independent | DESCRIPTION | Yes | No | No | Description |
DIAGNOSIS TYPE | Independent | ABBREVIATION | Yes | No | No | Short varchar |
DME DELIVERY | Dependent | HEALTH CARE DELIVERY ID | Yes | Yes | Yes | ID |
DRUG ADMINISTRATION | Dependent | HEALTH CARE DELIVERY ID | Yes | Yes | Yes | ID |
EPISODE OUTCOME | Dependent | HEALTH CARE EPISODE ID | Yes | Yes | Yes | ID |
EPISODE OUTCOME | Dependent | EPISODE OUTCOME ID | Yes | Yes | No | ID |
EPISODE OUTCOME | Dependent | OUTCOME TYPE ID | No | No | Yes | ID |
EPISODE OUTCOME | Dependent | OUTCOME EXPLANATION | Yes | No | No | Long varchar |
EXAMINATION | Dependent | HEALTH CARE DELIVERY ID | Yes | Yes | Yes | ID |
HEALTH CARE DELIVERY | Independent | HEALTH CARE DELIVERY ID | Yes | Yes | No | ID |
HEALTH CARE DELIVERY | Independent | HEALTH CARE VISIT ID | Yes | No | Yes | ID |
HEALTH CARE DELIVERY | Independent | HEALTH CARE EPISODE ID | Yes | No | Yes | ID |
HEALTH CARE DELIVERY | Independent | HEALTH CARE OFFERING ID | Yes | No | Yes | ID |
HEALTH CARE DELIVERY | Independent | FROM DATE | No | No | No | Datetime |
HEALTH CARE DELIVERY | Independent | THRU DATE | No | No | No | Datetime |
HEALTH CARE DELIVERY | Independent | DELIVERY NOTES | Yes | No | No | Long varchar |
HEALTH CARE DELIVERY ASSOCIATION | Dependent | HEALTH CARE DELIVERY ID FROM | Yes | Yes | Yes | ID |
HEALTH CARE DELIVERY ASSOCIATION | Dependent | HEALTH CARE DELIVERY ID TO | Yes | Yes | Yes | ID |
HEALTH CARE DELIVERY ROLE | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
HEALTH CARE DELIVERY ROLE | Dependent | FROM DATE | Yes | Yes | No | Datetime |
HEALTH CARE DELIVERY ROLE | Dependent | PARTY ID | Yes | Yes | Yes | ID |
HEALTH CARE DELIVERY ROLE | Dependent | HEALTH CARE DELIVERY ID | Yes | Yes | Yes | ID |
HEALTH CARE DELIVERY ROLE | Dependent | THRU DATE | No | No | No | Datetime |
HEALTH CARE DELIVERY ROLE TYPE | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
HEALTH CARE EPISODE | Independent | HEALTH CARE EPISODE ID | Yes | Yes | No | ID |
HEALTH CARE EPISODE | Independent | INCIDENT ID | Yes | No | No | ID |
HEALTH CARE EPISODE | Independent | PARTY ID | Yes | No | No | ID |
HEALTH CARE EPISODE | Independent | ROLE TYPE ID | Yes | No | No | ID |
HEALTH CARE EPISODE | Independent | PATIENT TYPE ID | Yes | No | No | ID |
HEALTH CARE EPISODE | Independent | HOUR ID | Yes | No | No | Datetime |
HEALTH CARE EPISODE | Independent | EPISODE CREATE DATE | Yes | No | No | Datetime |
HEALTH CARE EPISODE | Independent | DESCRIPTION | Yes | No | No | Description |
HEALTH CARE EPISODE | Independent | EPISODE TYPE ID | Yes | No | No | ID |
HEALTH CARE GOOD OFFERING | Dependent | HEALTH CARE OFFERING ID | Yes | Yes | Yes | ID |
HEALTH CARE OFFERING | Independent | HEALTH CARE OFFERING ID | Yes | Yes | No | ID |
HEALTH CARE OFFERING | Independent | NAME | No | No | No | Name |
HEALTH CARE SERVICE OFFERING | Dependent | HEALTH CARE OFFERING ID | Yes | Yes | Yes | ID |
HEALTH CARE VISIT | Independent | HEALTH CARE VISIT ID | Yes | Yes | No | ID |
HEALTH CARE VISIT | Independent | CONTACT MECHANISM ID | No | No | No | ID |
HEALTH CARE VISIT | Independent | PARTY ID | No | No | No | ID |
HEALTH CARE VISIT | Independent | ROLE TYPE ID | No | No | No | ID |
HEALTH CARE VISIT | Independent | FACILITY ID | No | No | No | ID |
HEALTH CARE VISIT | Independent | FROM DATE | Yes | No | No | Datetime |
HEALTH CARE VISIT | Independent | THRU DATE | No | No | No | Datetime |
INDIVIDUAL HEALTH CARE PRACTITIONER | Independent | PARTY ID | Yes | Yes | No | ID |
INDIVIDUAL HEALTH CARE PRACTITIONER | Independent | ROLE TYPE ID | Yes | Yes | No | ID |
OUTCOME TYPE | Independent | OUTCOME TYPE ID | Yes | Yes | No | ID |
OUTCOME TYPE | Independent | DESCRIPTION | Yes | No | No | Description |
PARTY | Independent | PARTY ID | Yes | Yes | No | ID |
PRACTITIONER DIAGNOSIS | Dependent | DIAGNOSIS ID | Yes | Yes | Yes | ID |
PRACTITIONER DIAGNOSIS | Dependent | PARTY ID | Yes | Yes | Yes | ID |
PRACTITIONER DIAGNOSIS | Dependent | ROLE TYPE ID | Yes | Yes | Yes | ID |
PROCEDURE | Dependent | HEALTH CARE DELIVERY ID | Yes | Yes | Yes | ID |
ROLE TYPE | Independent | ROLE TYPE ID | Yes | Yes | No | ID |
ROLE TYPE | Independent | DESCRIPTION | Yes | No | No | Description |
STATUS TYPE | Independent | STATUS TYPE ID | Yes | Yes | No | ID |
STATUS TYPE | Independent | DESCRIPTION | Yes | No | No | Description |
SUPPLY ADMINISTRATION | Dependent | HEALTH CARE DELIVERY ID | Yes | Yes | Yes | ID |