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 |