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 |