AUTHORIZATION_AGE_RANGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: AUTHORIZATION_AGE_RANGE
Definition: Stores age ranges for a given domain or logical domain and authorization profile type used to determine access to patient data.
Table Type: REFERENCE





Column Detail - AUTHORIZATION_AGE_RANGE


Column Name Type Null? Definition
AGE_LOWER_BOUND_VAL DOUBLE N The lower end of the age range (in years).
AGE_UPPER_BOUND_VAL DOUBLE N The upper end of the age range (in years).
AUTHORIZATION_AGE_RANGE_ID DOUBLE N PRIMARY KEY
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PROFILE_TYPE_CD DOUBLE N The profile type associated with the age range.
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 - AUTHORIZATION_AGE_RANGE


Child Column in AUTHORIZATION_AGE_RANGE(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


AUTHORIZATION_PROFILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization Profile
Definition: Contains the Authorization Profiles for a given domain or logical domain and authorization profile type that are used to process data.
Table Type: REFERENCE





Column Detail - AUTHORIZATION_PROFILE


Column Name Type Null? Definition
AUTHORIZATION_PROFILE_ID DOUBLE N Unique generated number that identifies a single row on the Authorization_Profile table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PROFILE_PRSNL_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROFILE_TYPE_CD DOUBLE N Authorization Profile Type code identifies the profile relationship a given personnel has for a given logical domain.
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 - AUTHORIZATION_PROFILE


Child Column in AUTHORIZATION_PROFILE(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PROFILE_PRSNL_ID PRSNL PERSON_ID


CHART_LISTVIEW_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart List View Format
Definition: Stores configuration data related to the list view chart section (CHART_GROUP_ID should be the MUI)
Table Type: REFERENCE





Column Detail - CHART_LISTVIEW_FORMAT


Column Name Type Null? Definition
ACCESSION_SEQ DOUBLE N Sequence of the "Accession Number" column, if appearing on the chart
ACCESSION_TXT VARCHAR(32) Y Label appearing on the chart when the "Accession Number" column appears
CHART_GROUP_ID DOUBLE N Refers to the group_id on chart_group
CHART_LISTVIEW_FORMAT_ID DOUBLE N System-assigned ID column.
COLLECTED_DT_TM_SEQ DOUBLE N Sequence of the "Collected dt/tm" column, if appearing on the chart
COLLECTED_TXT VARCHAR(32) Y Label appearing on the chart when the "Collected dt/tm" column appears
DATE_MASK VARCHAR(32) Y Formatting attribute for dates displayed on printed chart. Ex: "mm/dd/yyyy"
GROUP_RESULT_SEQ DOUBLE N Sequence of the "Result" column, if appearing on the chart.
PERF_VER_PRSNL_SEQ DOUBLE N Sequence of the "Performed/Verified By:" column, if appearing on the chart
PERF_VER_PRSNL_TXT VARCHAR(32) Y Label appearing on the chart when the "Performed/Verified By" column appears
PROCEDURE_SEQ DOUBLE N Sequence of the "Procedure" column, if appearing on the chart
PROCEDURE_TXT VARCHAR(32) Y Label appearing on the chart when the "Procedure" column appears
RECEIVED_DT_TM_SEQ DOUBLE N Sequence of the "Received dt/tm" column, if appearing on the chart
RECEIVED_TXT VARCHAR(32) Y Label appearing on the chart when the "Received dt/tm" column appears
REFRANGE_SEQ DOUBLE N Sequence of the "Reference Range" column, if appearing on the chart
REFRANGE_TXT VARCHAR(32) Y Label appearing on the chart when the "Reference Range" column appears
REF_RNG_FORM_FLAG DOUBLE N Stores a value indicating which of the two options for displaying the reference range has been selected.
RESULT_SEQ DOUBLE N Sequence of the "Result" column, if appearing on the chart.
RESULT_TXT VARCHAR(32) Y Label appearing on the chart when the "Result" column appears
SPECTYPE_SEQ DOUBLE N Sequence of the "Specimen Type" column, if appearing on the chart
SPECTYPE_TXT VARCHAR(32) Y Label appearing on the chart when the "Specimen Type" column appears
TIME_MASK VARCHAR(32) Y Formatting attribute for times displayed on printed chart. Ex: "hh:mm:ss"
UNITS_SEQ DOUBLE N Sequence of the "Units" column, if appearing on the chart
UNITS_TXT VARCHAR(32) Y Label appearing on the chart when the "Units" column appears
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.
VERIFIED_DT_TM_SEQ DOUBLE N Sequence of the "Verified dt/tm" column, if appearing on the chart
VERIFIED_TXT VARCHAR(32) Y Label appearing on the chart when the "Verified dt/tm" column appears



Relationship Detail - CHART_LISTVIEW_FORMAT


Child Column in CHART_LISTVIEW_FORMAT(FK) Parent Table Name Parent Column Name
Parents: CHART_GROUP_ID CHART_GROUP CHART_GROUP_ID


CR_DESTINATION_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Reporting Destination Cross Reference
Definition: This table lists cross reference between an Entity PRSNL, ORGANIZATION, SERVICE_RESOUCE and LOCATION) and Devices specific to Clinical Reporting workflows
Table Type: REFERENCE





Column Detail - CR_DESTINATION_XREF


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CR_DESTINATION_XREF_ID DOUBLE N PRIMARY KEY
DESTINATION_TYPE_CD DOUBLE N Destination type specific to device and dms_service_identifier FROM CODE SET: 4636013
DEVICE_CD DOUBLE N Foreign Key value from DEVICE table
DMS_SERVICE_IDENTIFIER VARCHAR(110) Y Indicates ( identifies ) the DMS service
PARENT_ENTITY_ID DOUBLE N Parent entity id for destination type. A PK value from table identified in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N name of the destination type parent table entity
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 - CR_DESTINATION_XREF


Child Column in CR_DESTINATION_XREF(FK) Parent Table Name Parent Column Name
Parents: DEVICE_CD DEVICE DEVICE_CD


CR_DIST_EXEC



Column Section Relationship Section Top of Page


Table-level Detail

Description: CR_DIST_EXEC
Definition: This tables stores the execute date/times of Clinical Reporting distributions.
Table Type: ACTIVITY





Column Detail - CR_DIST_EXEC


Column Name Type Null? Definition
CR_DIST_EXEC_ID DOUBLE N This is the unique key and is generated by a new sequence from "CHART_SEQ".
DISTRIBUTION_ID DOUBLE N FK value from the PK of Distribution_ID
DIST_RUN_DT_TM DATETIME N Distribution Run Date/Time
DIST_RUN_TYPE_CD DOUBLE N Distribution Run 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 - CR_DIST_EXEC


Child Column in CR_DIST_EXEC(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID CHART_DISTRIBUTION DISTRIBUTION_ID