EMPI_NAME_THESAURUS



Column Section Top of Page


Table-level Detail

Description: Table is used to store the empi AKA names.
Definition: Table is used to store the empi AKA names. A row consists of the name group name and then a member of that group. There can be multiple rows for a name group with the same name.
Table Type: REFERENCE





Column Detail - EMPI_NAME_THESAURUS


Column Name Type Null? Definition
EMPI_NAME_THESAURUS_ID DOUBLE N Unique key to identify a name pair.
MEMBER VARCHAR(40) N A member of a name group.
NAME_GROUP VARCHAR(40) N Name of a name group. Name groups will have multiple members.
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.


EPRESCRIBE_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Electronic Prescribing Detail
Definition: Stores details related to ePrescribing(SureScript) submissions.
Table Type: ACTIVITY





Column Detail - EPRESCRIBE_DETAIL


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME N 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.
CS_APPROVER_SIG_TXT VARCHAR(1000) N The signature of the approver for allowing controlled substance electronic subscribing.
CS_NOMINATOR_ID DOUBLE N The person_id of the nominator for allowing controlled substance electronic subscribing.
END_EFFECTIVE_DT_TM DATETIME N 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.
EPRESCRIBE_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the EPRESCRIBE_DETAIL table.
ERROR_CD DOUBLE N The error code of the message returned fromFSI.
ERROR_DESC VARCHAR(100) Y The error description returned from SureScripts.
MESSAGE_IDENT VARCHAR(100) Y The UUID assigned to the FSI message for SureScript submission.
PROP_SERVICE_LEVEL_NBR DOUBLE N The bit mask representing what service levels were sent to SureScripts
PRSNL_RELTN_ID DOUBLE N ID of the relationship on prsnl_reltn
SERVICE_LEVEL_NBR DOUBLE N The bit mask representing what service levels were sent to SureScripts
STATUS_CD DOUBLE N The status code of the message returned from FSI.
SUBMIT_DT_TM DATETIME N Represents the date/time the personnel was submitted to SureScripts.
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 - EPRESCRIBE_DETAIL


Child Column in EPRESCRIBE_DETAIL(FK) Parent Table Name Parent Column Name
Parents: CS_NOMINATOR_ID PRSNL PERSON_ID
PRSNL_RELTN_ID PRSNL_RELTN PRSNL_RELTN_ID


OPF_PUB_SUB_CONFIG



Column Section Top of Page


Table-level Detail

Description: OPF PUB SUB CONFIG
Definition: Contains the configurations for publish and subscribe logic.
Table Type: REFERENCE





Column Detail - OPF_PUB_SUB_CONFIG


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.
ALIAS_FLAG DOUBLE Y Flag determines whether or not aliases (MRN) will be checked for a match.
BEG_EFFECTIVE_DT_TM DATETIME N 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 N 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.
HNA_EVENT VARCHAR(10) Y The event or action that occurred at the HNAM level.
OPF_PUB_SUB_ID DOUBLE N The unique primary identifier of the opf_pub_sub_config table.
PUB_CONTRIBUTOR_SYSTEM_CD DOUBLE N The contributor_system_cd of the publisher.
PUB_TRIGGER VARCHAR(10) Y The ADT trigger sent by the publisher to HNAM.
SUB_CONTRIBUTOR_SYSTEM_CD DOUBLE N The contributor_system_cd of the subscriber.
SUB_PROC_ID DOUBLE N The proc_id of the outbound com client for the subscriber.
SUB_TRIGGER VARCHAR(10) Y The ADT trigger the subscriber wants given certain criteria.
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.


PM_AUTO_DISCH_PARM_SET_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Management Auto Discharge Parameter Set Relationship
Definition: The PM_AUTO_DISCH_PARM_SET_RELTN table stores information about the relationships between parameter sets and auto discharge criteria.
Table Type: REFERENCE





Column Detail - PM_AUTO_DISCH_PARM_SET_R


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.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
CREATE_DT_TM DATETIME N Contains the row creation date.
CREATE_PRSNL_ID DOUBLE N Contains the id of the person who created the row.
ENCNTR_TYPE_CD DOUBLE N Categorizes the encounter into a logical group or type. Examples may include inpatient, outpatient, etc.
END_EFFECTIVE_DT_TM DATETIME N 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.
LOC_FACILITY_CD DOUBLE N Patient location with a location type of facility.
LOC_NURSE_UNIT_CD DOUBLE N Patient location with a location type of nurse unit.
PM_AUTO_DISCH_PARM_SET_R_ID DOUBLE N Unique generated number that identifies a single row on the PM_AUTO_DISCH_PARM_SET_RELTN table.
RC_PARAMETER_SET_ID DOUBLE N This is the value of the unique primary identifier of the RC_PARAMETER_SET 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 - PM_AUTO_DISCH_PARM_SET_R


Child Column in PM_AUTO_DISCH_PARM_SET_R(FK) Parent Table Name Parent Column Name
Parents: LOC_FACILITY_CD LOCATION LOCATION_CD
LOC_NURSE_UNIT_CD NURSE_UNIT LOCATION_CD
RC_PARAMETER_SET_ID RC_PARAMETER_SET RC_PARAMETER_SET_ID


PM_CONV_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains relationships between a worklist and conversation(s).
Definition: This table holds the relationship between a worklist and potentially many conversations.
Table Type: REFERENCE





Column Detail - PM_CONV_RELTN


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.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
CONVERSATION_ID DOUBLE N Unique ID for the conversation.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME N The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
DEFAULT_IND DOUBLE Y Default Indicator used to tell whether conversation associated with a work list is the default.
END_EFFECTIVE_DT_TM DATETIME N 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.
PARENT_ENTITY_ID DOUBLE N This is the value of the unique primary identifier of the parent table. It is an internal system assigned number.
PARENT_ENTITY_NAME VARCHAR(32) N Name of the parent entity table.
PM_CONV_RELTN_ID DOUBLE N Primary key for PM Conv Reltn 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 - PM_CONV_RELTN


Child Column in PM_CONV_RELTN(FK) Parent Table Name Parent Column Name
Parents: CONVERSATION_ID PM_FLX_CONVERSATION CONVERSATION_ID