MARS_ATTRIBUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MARS_ATTRIBUTE
Definition: Identifies an attribute of a unique MARS_NODE row
Table Type: REFERENCE





Column Detail - MARS_ATTRIBUTE


Column Name Type Null? Definition
ATTRIBUTE_NAME VARCHAR(100) N The attribute name is unique to the MARS_NODE.MARS_NODE_ID and contains attribute names such as name, required etc
ATTRIBUTE_TEXT VARCHAR(4000) Y Text contained within the attribute tag itself, this is usually the result of a documentation node
ATTRIBUTE_VALUE VARCHAR(255) N The attribute value is the data within the attribute name.
MARS_ATTRIBUTE_ID DOUBLE N PRIMAY KEY
MARS_NODE_ID DOUBLE N Parent MARS_NODE.MARS_NODE_ID identifying the parent for this attribute.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - MARS_ATTRIBUTE


Child Column in MARS_ATTRIBUTE(FK) Parent Table Name Parent Column Name
Parents: MARS_NODE_ID MARS_NODE MARS_NODE_ID




Parent Column in MARS_ATTRIBUTE (PK) Child Table Name Child Column Name
Children: MARS_ATTRIBUTE_ID MARS_MAPPING MARS_ATTRIBUTE_ID


MARS_MAPPING



Column Section Relationship Section Top of Page


Table-level Detail

Description: MARS_MAPPING
Definition: Identifies one of more mapping of a unique MARS_ATTRIBUTE row
Table Type: REFERENCE





Column Detail - MARS_MAPPING


Column Name Type Null? Definition
ENTITY_FIELD_TXT VARCHAR(255) Y The entity field of the entity to which the attribute is mapped.
ENTITY_MAPPED_TXT VARCHAR(255) Y The MARS entity concept to which the attribute is mapped - such as: PATIENT. ENCOUNTER, CLINICALEVENT
ENTITY_TYPE_TXT VARCHAR(100) Y An entity type for each mapping - such as: VALUE, COUNT, OCCURENCES
MARS_ATTRIBUTE_ID DOUBLE N An attribute identifier for each unique mapping
MARS_MAPPING_ID DOUBLE N PRIMARY KEY
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - MARS_MAPPING


Child Column in MARS_MAPPING(FK) Parent Table Name Parent Column Name
Parents: MARS_ATTRIBUTE_ID MARS_ATTRIBUTE MARS_ATTRIBUTE_ID




Parent Column in MARS_MAPPING (PK) Child Table Name Child Column Name
Children: MARS_MAPPING_ID MARS_MAPPING_METADATA MARS_MAPPING_ID


MARS_MAPPING_METADATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: MARS Mapping Metadata
Definition: Identifies a report and its implementation
Table Type: REFERENCE





Column Detail - MARS_MAPPING_METADATA


Column Name Type Null? Definition
MARS_MAPPING_ID DOUBLE Y Reference to a row in the MARS_MAPPING Table
MARS_MAPPING_METADATA_ID DOUBLE N PRIMARY KEY
METADATA_TYPE VARCHAR(40) Y Type of Mapping Resolution - CODE_VALUE, EVENT_CD, ORDER_CATALOG_CD
METADATA_TYPE_SEQ DOUBLE Y Order of precedence for the metadata values
METADATA_VALUE VARCHAR(40) Y A resolvable value such as CKI, Concept CKI, code value or other UID
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - MARS_MAPPING_METADATA


Child Column in MARS_MAPPING_METADATA(FK) Parent Table Name Parent Column Name
Parents: MARS_MAPPING_ID MARS_MAPPING MARS_MAPPING_ID


MARS_NODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MARS_NODE
Definition: Hierarchically defines a node of an XML Schema Document.
Table Type: REFERENCE





Column Detail - MARS_NODE


Column Name Type Null? Definition
MARS_NODE_ID DOUBLE N PRIMARY KEY
MARS_REPORT_ID DOUBLE Y Report to which this node belongs.
NODE_NAME VARCHAR(255) Y Name of the schema node - ELEMENT - ATTRIBUTE - ENUMERATION etc.
NODE_TEXT VARCHAR(255) Y Text within the node.
NODE_TYPE_NBR DOUBLE Y Type of the schema node
PARENT_NODE_ID DOUBLE Y Parent MARS_NODE_ID. Zero where Node is root.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - MARS_NODE


Child Column in MARS_NODE(FK) Parent Table Name Parent Column Name
Parents: PARENT_NODE_ID MARS_NODE MARS_NODE_ID
MARS_REPORT_ID MARS_REPORT MARS_REPORT_ID




Parent Column in MARS_NODE (PK) Child Table Name Child Column Name
Children: MARS_NODE_ID MARS_ATTRIBUTE MARS_NODE_ID
MARS_NODE PARENT_NODE_ID


MARS_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: MARS_REPORT
Definition: Identifies a report and its implementation
Table Type: REFERENCE





Column Detail - MARS_REPORT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
MARS_REPORT_ID DOUBLE N PRIMARY KEY
PARENT_REPORT_ID DOUBLE Y This field associates sub- reports to a Parent MARS Report. It is either null or a PK value of a row in this table.
REPORT_IMPLEMENTATION_TXT VARCHAR(100) Y The MARS report implementation containing the report logic.
REPORT_NAME VARCHAR(100) N A unique report name that identifies an XML schema document.
REPORT_NAME_KEY VARCHAR(100) N Unique report name that identifies an XML schema document - upper case and alphanumeric.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - MARS_REPORT


Child Column in MARS_REPORT(FK) Parent Table Name Parent Column Name
Parents: PARENT_REPORT_ID MARS_REPORT MARS_REPORT_ID




Parent Column in MARS_REPORT (PK) Child Table Name Child Column Name
Children: MARS_REPORT_ID MARS_NODE MARS_REPORT_ID
MARS_REPORT PARENT_REPORT_ID
MARS_SUITE_REPORT_RELTN MARS_REPORT_ID
MARS_SUITE_RESPONSE MARS_REPORT_ID