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 |