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