Table Detail Report

HIM_UNSIGNED_ORDERS



Column Section Relationship Section Top of Page


Table-level Detail

Description: HIM_UNSIGNED_ORDERS
Definition: Denormalization table for orders requiring co-signature by physician.
Table Type: ACTIVITY





Column Detail - HIM_UNSIGNED_ORDERS


Column Name Type Null? Definition
ACTION_PERSONNEL_ID DOUBLE N The id of the personnel that generated this action.
ACTION_PRSNL_NAME VARCHAR(100) Y Full name of the Action Personnel
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CONTRIBUTOR_SYSTEM_DISPLAY VARCHAR(40) Y Display value for the Contributor system, identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DISCH_DT_TM DATETIME Y The actual date/time that the patient was discharged from the facility. For most outpatients, this column may be null unless the user process requires capturing this data, for example, day surgery. Auto discharge will populate this column. This also may or may not be a system assigned date and time depending on the discharge process used.
ENCNTR_ID DOUBLE N Foreign Key to the Encntr table identifying the encounter.
ENCNTR_TYPE_CD DOUBLE N The encounter type code assigned to the patient for the order.
ENCNTR_TYPE_DISPLAY VARCHAR(40) Y The display value for the encounter type.
FACILITY_CD DOUBLE N This field is the current patient location with a location type of facility.
FACILITY_NAME VARCHAR(40) Y The name of the facility.
FIN_NBR_ALIAS VARCHAR(200) Y Financial Number alias for the encounter.
HIM_UNSIGNED_ORDERS_ID DOUBLE N Unique generated number that identifies a single row on the HIM_UNSIGNED_ORDERS table.
LAST_COMM_TYPE_DISPLAY VARCHAR(40) Y The latest communication type display value.
LATEST_COMMUNICATION_TYPE_CD DOUBLE Y CODE SET: 6006.The code value identifying the communication type of the order on the last action where it was present. For example, on initial ordering if a communication type of "FAX" is populated and then a modify action is performed on the order without populating the communication type, then this field will have a communication type of "FAX", which is the last valued communication type cd. To obtain values for each action, the communication_type_cd from the order_action should be read.
MRN_ALIAS VARCHAR(200) Y Person level medical record number.
NOTIFICATION_DT_TM DATETIME Y The time that the notification is created.
NOTIFICATION_TZ DOUBLE Y Time Zone the notification date and time should be displayed in.
ORDERED_AS_MNEMONIC VARCHAR(1000) Y The mnemonic used by direct care providers (physicians, nurses, etc.) when they place orders in applications such as PowerOrders. This field is important for free text orderables, since hna_order_mnemonic is a generic name and ordered_as_mnemonic carries specific information about the order. The field is truncated and will contain a maximum of 99 characters. Ellipses are not appended if the field is truncated.
ORDER_ACTION_DT_TM DATETIME Y The Date and Time of the order action.
ORDER_ACTION_SEQ DOUBLE N The action sequence at the time of task for tasks with an order_id context.
ORDER_ACTION_TZ DOUBLE Y Time Zone to apply to the Order Action Date and Time.
ORDER_DT_TM DATETIME Y The original order date and time for this order.
ORDER_ID DOUBLE N The id of the order.
ORDER_NOTIFICATION_ID DOUBLE N Unique ID for Order_Notification.
ORDER_STATUS_CD DOUBLE N The code for the status the order is in.
ORDER_STATUS_DISPLAY VARCHAR(40) Y The display value from the order_status _cd.
ORDER_TZ DOUBLE Y Time Zone of the user who placed the order.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number. This column is either valued with the facility or the client organization for the encounter.
ORGANIZATION_NAME VARCHAR(100) Y The name of the organization.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_NAME_FULL_FORMATTED VARCHAR(100) Y Full name of the Person
REG_DT_TM DATETIME Y Registration date/time of encounter.
TO_PRSNL_ID DOUBLE N The PERSON_ID of the person from the personnel table (PRSNL) to whom the notification should be sent.
TO_PRSNL_NAME_FULL_FORMATTED VARCHAR(100) Y Full name of the Personnel to sign the Order.
TO_PRSNL_ROLE_CD DOUBLE N Default Role of the Personnel to sign the order.
TO_PRSNL_ROLE_DISPLAY VARCHAR(40) Y Display for the default role of the personnel to sign the order.
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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - HIM_UNSIGNED_ORDERS


Child Column in HIM_UNSIGNED_ORDERS(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
FACILITY_CD LOCATION LOCATION_CD
ORDER_ID ORDERS ORDER_ID
ORDER_NOTIFICATION_ID ORDER_NOTIFICATION ORDER_NOTIFICATION_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
ACTION_PERSONNEL_ID PRSNL PERSON_ID
TO_PRSNL_ID PRSNL PERSON_ID


MEDIA_ENCNTR_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Media Encounter Reltn
Definition: Media Encntr Reltn
Table Type: ACTIVITY





Column Detail - MEDIA_ENCNTR_RELTN


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.
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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
MEDIA_ENCNTR_RELTN_ID DOUBLE N This is the unique identifier for this table
MEDIA_MASTER_ID DOUBLE N This is the unique identifier for the media master table
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - MEDIA_ENCNTR_RELTN


Child Column in MEDIA_ENCNTR_RELTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
MEDIA_MASTER_ID MEDIA_MASTER MEDIA_MASTER_ID
PERSON_ID PERSON PERSON_ID


MEDIA_MASTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores Media Master information
Definition: Stores current location, permanent location, media type , etc for each media.
Table Type: ACTIVITY





Column Detail - MEDIA_MASTER


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.
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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_DT_TM DATETIME Y The date and time that the media was created
CREATE_PRSNL_ID DOUBLE N The personnel id of the user that created the row, from the personnel table (prsnl). This is the value of the unique primary identifier of the personnel table. It is an internal system assigned number
CURRENT_LOC_CD DOUBLE N The coded value for the current location of the media
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EPISODE_ID DOUBLE N This is the value of the unique primary identifier of the episode table. It is an internal system assigned number
FRAME VARCHAR(15) Y Stores an alphanumeric frame number for a microfilm frame. (varchar 15)
FREETEXT_ROLL_FRAME VARCHAR(255) Y For use with microfilm functionality that requires the roll and frame information to be stored in the same field. (varchar 255)
MEDIA_COMMENT VARCHAR(255) Y Comment field for use with microfilm information. (varchar 255)
MEDIA_MASTER_ID DOUBLE N This is the value of the unique primary identifier of the media master table. It is an internal system assigned number
MEDIA_STATUS_CD DOUBLE N Identifies if the media is available, loaned, lost, etc.
MEDIA_TYPE_CD DOUBLE N Identifies the type of media (e.g., unit record, patient chart, microfilm, chart container)
MOVEMENT_DT_TM DATETIME Y The date and time the media's location/parent media was last inserted/updated
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PARENT_MEDIA_MASTER_ID DOUBLE N This is the value of the unique primary identifier of the media master table for the parent of this record.
PERMANENT_LOC_CD DOUBLE N The permanent location where the media is stored.
PERSON_ALIAS_ID DOUBLE N Links a row in this table to the person_alias table.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PREV_INTERNAL_LOC_CD DOUBLE N Previous internal location code is populated when a media is moved to an external location.
RETURN_LOC_CD DOUBLE N Only filled out if the media needs to return to a different location than the permanent_loc_cd.
ROLL VARCHAR(15) Y Stores an alphanumeric roll number for a microfilm roll. (varchar 15)
STORAGE_CD DOUBLE N Identifies the type of location/media that the media is currently stored (e.g., chart container, unit record, perm loc, cur loc).
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.
VOLUME_NBR DOUBLE Y Identifies the specific instance of which media this is in a series.



Relationship Detail - MEDIA_MASTER


Child Column in MEDIA_MASTER(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
EPISODE_ID EPISODE EPISODE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PERSON_ALIAS_ID PERSON_ALIAS PERSON_ALIAS_ID
CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in MEDIA_MASTER (PK) Child Table Name Child Column Name
Children: MEDIA_MASTER_ID BATCH_LABEL MEDIA_MASTER_ID
HIM_PV_CHART MEDIA_MASTER_ID
HIM_REQUEST_CRITERIA MEDIA_MASTER_ID
MEDIA_ENCNTR_RELTN MEDIA_MASTER_ID
MEDIA_MASTER_ALIAS MEDIA_MASTER_ID
MEDIA_MASTER_HIST MEDIA_MASTER_ID
MEDIA_MOVEMENT MEDIA_MASTER_ID


MEDIA_MASTER_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores an identifier for a Media Master record
Definition: Stores alias identifier to a Media Master record and alias type for that identifier
Table Type: ACTIVITY





Column Detail - MEDIA_MASTER_ALIAS


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.
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 Y 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.
ALIAS DOUBLE Y The alias is an identifier (I.e., tracking id, container id) for a media master record. The alias may be unique or non-unique depending on the type of alias.
ALIAS_POOL_CD DOUBLE N Identifies a kind or type of alias (i.e., system defined number, etc.). They are Cerner pre-defined meanings in the common data foundation table allowing HNA applications to look for a specific kind of alias.
ALIAS_STR VARCHAR(200) Y Alias field taking the place of "alias" (I4) to store the alpha-numeric alias for media.
ALIAS_TYPE_CD DOUBLE N Identifies a kind or type of alias (i.e., system defined number, etc.). They are Cerner pre-defined meanings in the common data foundation table allowing HNA applications to look for a specific kind of alias.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
MEDIA_MASTER_ALIAS_ID DOUBLE N This is the value of the unique primary identifier of the media master alias table. It is an internal system assigned number.
MEDIA_MASTER_ID DOUBLE N This is the value of the unique primary identifier of the media master table. It is an internal system assigned number.
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 - MEDIA_MASTER_ALIAS


Child Column in MEDIA_MASTER_ALIAS(FK) Parent Table Name Parent Column Name
Parents: MEDIA_MASTER_ID MEDIA_MASTER MEDIA_MASTER_ID


MEDIA_MASTER_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Media Master History
Definition: Stores the history of changes for the media_master table.
Table Type: ACTIVITY





Column Detail - MEDIA_MASTER_HIST


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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
MEDIA_MASTER_HIST_ID DOUBLE N Stores the history of changes for the media_master table.
MEDIA_MASTER_ID DOUBLE N This is the value of the unique primary identifier of the media_master table. It identifies what row on trhe medai_master table that this history row is for.
PERSON_ALIAS_ID DOUBLE N Links a row in this table to the person_alias table.
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 - MEDIA_MASTER_HIST


Child Column in MEDIA_MASTER_HIST(FK) Parent Table Name Parent Column Name
Parents: MEDIA_MASTER_ID MEDIA_MASTER MEDIA_MASTER_ID