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 |