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