Table Detail Report

CONTENT_PROPERTY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Content Property
Definition: Content Property Table
Table Type: REFERENCE





Column Detail - CONTENT_PROPERTY


Column Name Type Null? Definition
CHAR_LEN DOUBLE Y The character length for the content property
CSV_TEMPLATE_HELP VARCHAR(1000) Y Help text used for the CSV converter templates. This will be an explanation of how to locate and/or provide a value that will be valid in contentmanager after the csv file is converted.
DEFAULT_VALUE VARCHAR(255) Y The default value for the property
DISPLAY VARCHAR(100) Y Display for the content property
DOMAIN_NAME VARCHAR(100) Y The domain where this property belongs
LIST_IND DOUBLE Y List IndicatorColumn
PICK_FROM_LIST_IND DOUBLE Y Used to determine whether the application should limit the selection from the list only or should allow free-text.
PROPERTY_HELP_LIST VARCHAR(1000) Y Stores the user defined help as XML string.
PROPERTY_ID DOUBLE N Property IdentifierColumn
PROPERTY_LOCK_TYPE DOUBLE Y Used to determine how a content property behaves, such as locked or unlocked.
PROPERTY_TYPE DOUBLE Y Identifies the data type for the content property
PROPERTY_UPDATE_FLAG DOUBLE N Identifies whether the field is selected to update (0), not update (1), or rely on business logic script (2).
PROPERTY_VALIDATED_BY DOUBLE Y Identifies the type of validation if the property is a code set
REQUIRED_IND DOUBLE Y Whether the property is required or not.
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.
XML_DISPLAY VARCHAR(100) Y xml tag for the content property



Relationship Detail - CONTENT_PROPERTY




Parent Column in CONTENT_PROPERTY (PK) Child Table Name Child Column Name
Children: PROPERTY_ID COND_REQUIRED_PROPS COND_PROPERTY_ID
COND_REQUIRED_PROPS PROPERTY_ID
CONTENT_PROPERTY_MAP CONTENT_PROPERTY_ID
CONTENT_PROPERTY_RELTN CHILD_PROPERTY_ID
CONTENT_PROPERTY_RELTN PARENT_PROPERTY_ID


CONTENT_PROPERTY_EXTENSION



Column Section Top of Page


Table-level Detail

Description: Content Property Extension
Definition: Store additional attributes for Content Manager import domains.
Table Type: REFERENCE





Column Detail - CONTENT_PROPERTY_EXTENSION


Column Name Type Null? Definition
DOMAIN_NAME VARCHAR(100) N Domain Name. Used with Sequence to make up PK
EXTENSION_TYPE_FLAG DOUBLE N Stores the Type of Extension. 1 = allow updates (default)2 = audit mode available3 = report
EXTENSION_VALUE DOUBLE N Extension Value. 1 or 0 for types 1 and 2.Request number for type 3
SEQUENCE DOUBLE N Sequence. Used with Domain_name to make up PK
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.


CONTENT_PROPERTY_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: CONTENT PROPERTY MAP
Definition: Table to indicate field mappings for content properties
Table Type: REFERENCE





Column Detail - CONTENT_PROPERTY_MAP


Column Name Type Null? Definition
CONTENT_PROPERTY_ID DOUBLE N Child of CONTENT_PROPERTY table
CONTENT_PROPERTY_MAP_ID DOUBLE N content property map identifierColumn
CSV_MAP_FIELD VARCHAR(30) Y This field is the corresponding value from the standard csv file template.
CSV_MAP_FIELD2 VARCHAR(255) Y CSV map field used with Version 2.0 of the CSV converter. For Version 2.0 of the CSV converter this field must be unique per domain.
REQUIRED_IND DOUBLE Y Indicates whether field is required to exist on csv file.Column
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 - CONTENT_PROPERTY_MAP


Child Column in CONTENT_PROPERTY_MAP(FK) Parent Table Name Parent Column Name
Parents: CONTENT_PROPERTY_ID CONTENT_PROPERTY PROPERTY_ID


CONTENT_PROPERTY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Content Property relation
Definition: Content Property relation Table
Table Type: REFERENCE





Column Detail - CONTENT_PROPERTY_RELTN


Column Name Type Null? Definition
CHILD_PROPERTY_ID DOUBLE N Child property identifierColumn
LIST_SEQ DOUBLE N list sequenceColumn
PARENT_PROPERTY_ID DOUBLE N Parent property identifierColumn
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 - CONTENT_PROPERTY_RELTN


Child Column in CONTENT_PROPERTY_RELTN(FK) Parent Table Name Parent Column Name
Parents: CHILD_PROPERTY_ID CONTENT_PROPERTY PROPERTY_ID
PARENT_PROPERTY_ID CONTENT_PROPERTY PROPERTY_ID


DRUG_CLASS_INT_CSTM_ENTITY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: DRUG CLASS INTERACTIONS CUSTOM ENTITY RELATIONSHIP
Definition: Store the relationships between Custom group pairs and the dcp_entity_reltn table
Table Type: REFERENCE





Column Detail - DRUG_CLASS_INT_CSTM_ENTITY_R


Column Name Type Null? Definition
DCP_ENTITY_RELTN_ID DOUBLE N Foreign Key value from the DCP_ENTITY_RELTN table.
DRUG_CLASS_INT_CSTM_ENT_R_ID DOUBLE N primary key
DRUG_CLASS_INT_CUSTOM_ID DOUBLE N Foreign Key value from table DRUG_CLASS_INT_CUSTOM
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 - DRUG_CLASS_INT_CSTM_ENTITY_R


Child Column in DRUG_CLASS_INT_CSTM_ENTITY_R(FK) Parent Table Name Parent Column Name
Parents: DCP_ENTITY_RELTN_ID DCP_ENTITY_RELTN DCP_ENTITY_RELTN_ID
DRUG_CLASS_INT_CUSTOM_ID DRUG_CLASS_INT_CUSTOM DRUG_CLASS_INT_CUSTOM_ID