AC_CLASS_DEF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Ambulatory Care Class Definition |
Definition: | Defines a classification that care coordinators use to build filters on patients. |
Table Type: | REFERENCE |
Column Detail - AC_CLASS_DEF
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
AC_CLASS_DEF_ID | DOUBLE | N | Unique, generated number that will identify a single row on the AC_CLASS_DEF table. |
BEGIN_EFFECTIVE_DT_TM | DATETIME | N | The date and time that the classification became active. |
CLASS_DISPLAY_NAME | VARCHAR(255) | N | The description for the classification. |
CLASS_DISPLAY_NAME_KEY | VARCHAR(255) | N | Similar to CLASS_DISPLAY_NAME but contains only upper case and alphanumeric characters without any special characters or embedded spaces; Typically used in index to improve query performance. |
CLASS_DISPLAY_NAME_KEY_A_NLS | VARCHAR(1020) | N | Similar to CLASS_DISPLAY_NAME but contains only upper case and alphanumeric characters without any special characters or embedded spaces; Typically used in index to improve query performance |
CLASS_TYPE_FLAG | DOUBLE | N | The type of classification. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, if you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - AC_CLASS_DEF
Child Column in AC_CLASS_DEF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
Parent Column in AC_CLASS_DEF (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | AC_CLASS_DEF_ID | AC_CLASS_HE_RULE | AC_CLASS_DEF_ID |
AC_CLASS_PERSON_RELTN | AC_CLASS_DEF_ID |
AC_CLASS_HE_RULE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Ambulatory Care Health Expert Rule |
Definition: | Maps classifications of type "Condition" to one or more Health Expert rules that result in the condition. |
Table Type: | REFERENCE |
Column Detail - AC_CLASS_HE_RULE
Column Name | Type | Null? | Definition |
---|---|---|---|
AC_CLASS_DEF_ID | DOUBLE | N | The classification that this health expert rule is grouped under. |
AC_CLASS_HE_RULE_ID | DOUBLE | N | Unique generated number that identifies a single row on the AC_CLASS_HE_RULE table. |
HEALTH_EXPERT_RULE_TXT | VARCHAR(255) | N | The name of a condition that could result in the classification. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - AC_CLASS_HE_RULE
Child Column in AC_CLASS_HE_RULE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AC_CLASS_DEF_ID | AC_CLASS_DEF | AC_CLASS_DEF_ID |
AC_CLASS_PERSON_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Ambulatory Care Classification Person Relation |
Definition: | Identifies classifications that apply to a person and how the classifications relate to one another. |
Table Type: | ACTIVITY |
Column Detail - AC_CLASS_PERSON_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
AC_CLASS_DEF_ID | DOUBLE | N | The classification that this person is grouped under. |
AC_CLASS_PERSON_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the AC_CLASS_PERSON_RELTN table. |
BEGIN_EFFECTIVE_DT_TM | DATETIME | N | The date and time the row is considered to be valid for use. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
INDEPENDENT_PARENT_IND | DOUBLE | N | Indicates if this level is tracked independently. |
LOCATION_CD | DOUBLE | N | The location for this person and classification. |
ORGANIZATION_ID | DOUBLE | N | The organization associated with this person and classification. |
PARENT_CLASS_PERSON_RELTN_ID | DOUBLE | N | The parent relationship of this person and classification. |
PERSON_ID | DOUBLE | N | The person assigned to this classification. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - AC_CLASS_PERSON_RELTN
Child Column in AC_CLASS_PERSON_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AC_CLASS_DEF_ID | AC_CLASS_DEF | AC_CLASS_DEF_ID |
PARENT_CLASS_PERSON_RELTN_ID | AC_CLASS_PERSON_RELTN | AC_CLASS_PERSON_RELTN_ID | |
LOCATION_CD | LOCATION | LOCATION_CD | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in AC_CLASS_PERSON_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | AC_CLASS_PERSON_RELTN_ID | AC_CLASS_PERSON_RELTN | PARENT_CLASS_PERSON_RELTN_ID |