CP_COMPONENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Care Planning Component |
Definition: | Contain definition and links for configuration of a care planning component |
Table Type: | REFERENCE |
Column Detail - CP_COMPONENT
Column Name | Type | Null? | Definition |
---|---|---|---|
COMPONENT_DISPLAY | VARCHAR(255) | N | Optional display value for the component. |
COMPONENT_SEQ_TXT | VARCHAR(10) | Y | This will be a textual representation of how the component Is layed out on the screen in the format of "GROUP:ROW:COL" |
COMP_TYPE_CD | DOUBLE | N | Type of care planning component |
CONCEPT_GROUP_CD | DOUBLE | N | The concept group that this component loads configuration data from. |
CP_COMPONENT_ID | DOUBLE | N | Primary Key |
CP_NODE_ID | DOUBLE | N | Node that this component is linked to |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - CP_COMPONENT
Child Column in CP_COMPONENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CP_NODE_ID | CP_NODE | CP_NODE_ID |
Parent Column in CP_COMPONENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CP_COMPONENT_ID | CP_COMPONENT_DETAIL | CP_COMPONENT_ID |
CP_PATHWAY_ACTION | CP_COMPONENT_ID |
CP_COMPONENT_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Care Planning Component Detail |
Definition: | Contain detailed configuration information for a care planning component |
Table Type: | REFERENCE |
Column Detail - CP_COMPONENT_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
COLLATION_SEQ | DOUBLE | N | This column is used to order all the items in the table. |
COMPONENT_DETAIL_RELTN_CD | DOUBLE | N | Code Value identifying component relationship detail |
COMPONENT_ENTITY_ID | DOUBLE | N | Contains the PK value of a row in table idenitified in COMPONENT_ENTITY_NAME. If COMPONENT is not related to a table/value, then this value is 0 |
COMPONENT_ENTITY_NAME | VARCHAR(30) | Y | Contains name of table if the COMPONENT ENTITY is related to a table |
COMPONENT_IDENT | VARCHAR(255) | Y | Identifier for COMPONENT DETAIL - only used when COMPONENT_ENTITY_ID = 0 |
COMPONENT_TEXT | VARCHAR(255) | Y | Detail text associated with the named detail. Contains a value when COMPONENT_IDENT is used and COMPONENT_ENTITY_ID = 0 |
CP_COMPONENT_DETAIL_ID | DOUBLE | N | Primary Key |
CP_COMPONENT_ID | DOUBLE | N | Foreign Key to Component this detail config is associated to |
DEFAULT_IND | DOUBLE | N | The latest row that will default the build tool |
SELECTED_IND | DOUBLE | N | This field is used to determine if an item should be pre-selected when the page loads. |
SOURCE_FLAG | DOUBLE | N | The source of the component detail for documentation content |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
VERSION_FLAG | DOUBLE | N | The Version Flag will control the severity of versioning changes for the detail |
VERSION_NBR | DOUBLE | N | Version is controlled by outside source and intended to match up with DD_SREF_TEMPLATE.VERSION_NBR |
VERSION_TEXT | VARCHAR(255) | Y | Text that will show the user what content changes have occurred |
Relationship Detail - CP_COMPONENT_DETAIL
Child Column in CP_COMPONENT_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CP_COMPONENT_ID | CP_COMPONENT | CP_COMPONENT_ID |
CP_CONCEPT_GROUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CARE PLANNING CONCEPT GROUP |
Definition: | Define relationship Groups to apply to Concept Details |
Table Type: | REFERENCE |
Column Detail - CP_CONCEPT_GROUP
Column Name | Type | Null? | Definition |
---|---|---|---|
CONCEPT_CD | DOUBLE | N | The concept code this relationship is defined for. |
CONCEPT_GROUP_CD | DOUBLE | N | How the entity is related to the concept |
CP_CONCEPT_GROUP_ID | DOUBLE | N | PRIMARY KEY |
INTENTION_CD | DOUBLE | N | The intention for this relationship group |
RULE_IND | DOUBLE | N | Equal 1 if there is a Rule associated with this relationship. |
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 - CP_CONCEPT_GROUP
Parent Column in CP_CONCEPT_GROUP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CP_CONCEPT_GROUP_ID | CP_CONCEPT_GROUP_DTL | CP_CONCEPT_GROUP_ID |
CP_CONCEPT_GROUP_DTL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Care Planning Concept Group Detail |
Definition: | Contains Detailed Configuraton for a Concept Group |
Table Type: | REFERENCE |
Column Detail - CP_CONCEPT_GROUP_DTL
Column Name | Type | Null? | Definition |
---|---|---|---|
CONCEPT_ENTITY_ID | DOUBLE | N | Foreign Key from related table (table name in CONCEPT_ENTITY_NAME) |
CONCEPT_ENTITY_IDENT | VARCHAR(255) | N | Identifier for when row is not using entity_name, entity_id. |
CONCEPT_ENTITY_NAME | VARCHAR(30) | Y | Table from which this concept is related to. |
CONCEPT_ENTITY_TEXT | VARCHAR(255) | N | Text field for value |
CP_CONCEPT_GROUP_DTL_ID | DOUBLE | N | PRIMARY KEY |
CP_CONCEPT_GROUP_ID | DOUBLE | N | Foreign Key value from CP_CONCEPT_GROUP |
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 - CP_CONCEPT_GROUP_DTL
Child Column in CP_CONCEPT_GROUP_DTL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CP_CONCEPT_GROUP_ID | CP_CONCEPT_GROUP | CP_CONCEPT_GROUP_ID |
Parent Column in CP_CONCEPT_GROUP_DTL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CP_CONCEPT_GROUP_DTL_ID | CP_CONCEPT_GROUP_DTL_ATTR | CP_CONCEPT_GROUP_DTL_ID |
CP_CONCEPT_GROUP_DTL_ATTR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CP CONEPT GROUP DETAIL ATTRIBUTES |
Definition: | Contains attribute information for concept details. This will allow for flexibly grouping, and describing of additional parameters to flex by for detail entries. |
Table Type: | REFERENCE |
Column Detail - CP_CONCEPT_GROUP_DTL_ATTR
Column Name | Type | Null? | Definition |
---|---|---|---|
ATTRIBUTE_ENTITY_ID | DOUBLE | N | Foreign Key to table the Attribute is related to. |
ATTRIBUTE_ENTITY_NAME | VARCHAR(30) | Y | Name of Table Attribute ID is linked to. |
ATTRIBUTE_ENTITY_TEXT | VARCHAR(255) | N | Value for which entity name if it's not linked to another table. |
CP_CONCEPT_GROUP_DTL_ATTR_ID | DOUBLE | N | PRIMARY KEY |
CP_CONCEPT_GROUP_DTL_ID | DOUBLE | N | Foreign key value from CP_CONCEPT_GROUP_DTL |
DETAIL_ATTRIBUTE_TYPE_CD | DOUBLE | N | Detail Attribute Type Code. |
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 - CP_CONCEPT_GROUP_DTL_ATTR
Child Column in CP_CONCEPT_GROUP_DTL_ATTR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CP_CONCEPT_GROUP_DTL_ID | CP_CONCEPT_GROUP_DTL | CP_CONCEPT_GROUP_DTL_ID |