Table Detail Report

HIM_EVENT_ALLOCATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table stores physician/document allocation dates.
Definition: This table stores allocation dates for physicians assigned deficiencies for a particular document. This allocation date is the starting point for tracking turn around metrics on physician dication/signature requirements.
Table Type: ACTIVITY





Column Detail - HIM_EVENT_ALLOCATION


Column Name Type Null? Definition
ACTION_STATUS_CD DOUBLE N CODE SET:103 Action Status code from codeset 103.
ACTION_TYPE_CD DOUBLE N Action Type code from codeset 21.
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.
ALLOCATION_DT_TM DATETIME Y Date/time field storing the starting tracking point for an individual physician on a single document.
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.
CE_EVENT_PRSNL_ID DOUBLE Y Identifier for the row on the Ce_event_prsnl table.
COMPLETED_DT_TM DATETIME Y Date and time specified document deficiency was completed.
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.
EVENT_CD DOUBLE N Event code
EVENT_ID DOUBLE N This is the value of the unique primary identifier of the clinical_event table. It is an internal system assigned number.
HIM_EVENT_ALLOCATION_ID DOUBLE N Unique ID for the him_event_allocation table.
PRSNL_ID DOUBLE N Provider responsible for deficiency
REQUEST_DT_TM DATETIME Y Date and time document deficiency was requested in system
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 - HIM_EVENT_ALLOCATION


Child Column in HIM_EVENT_ALLOCATION(FK) Parent Table Name Parent Column Name
Parents: CE_EVENT_PRSNL_ID CE_EVENT_PRSNL CE_EVENT_PRSNL_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PRSNL_ID PRSNL PERSON_ID


HIM_EVENT_EXTENSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table stores event information for ProFile documents
Definition: Stores fields like anticipated ind and multiple anticipated reports ind.
Table Type: REFERENCE





Column Detail - HIM_EVENT_EXTENSION


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.
COSIGN_IND DOUBLE Y Indicates if this document type requires a co-signature
COSIGN_PRSNL_TYPE_CD DOUBLE N This is the type of physician that needs to cosign the document.
DICTATION_DELINQUENCY_TIME DOUBLE Y This is the time in minutes, that the dictation needs to be completed by before the document is considered delinquent
DICTATION_TURNAROUND_TIME DOUBLE Y This is the time that the document should be dictated after an event (i.e. discharge event).
DOCUMENT_DISPLAY_ORDER DOUBLE Y This is the display order for document type that is used by the frontend and reports.
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.
EVENT_CD DOUBLE N This is the document type.
MATCHING_PHYSICIAN_IND DOUBLE Y When matching a new report to anticipated reports, should we match an physician also.
MULTIPLE_EVENT_FLAG DOUBLE Y Can we create multiple document for the same encounter.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
SERV_RES_CD DOUBLE N The service resource that this document type is associated with.
SIGNATURE_DELINQUENCY_TIME DOUBLE Y This is the amount of time that is allowed for a signature before it becomes delinquent
SIGNATURE_REQUIRED_IND DOUBLE Y Is there a signature requirement for this document type
SIGNATURE_TURNAROUND_TIME DOUBLE Y This is the turnaround time for signatures
TRANSCRIPTION_TURNAROUND_TIME DOUBLE Y This is the amount of time allotted for transcription turnaround
TRAN_TIME_IND DOUBLE Y This indicator is used to determine if a client wants to include the time a document is in a Requested Transcribe status when calculating the age of a document. If set to 1, it will be included.
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 - HIM_EVENT_EXTENSION


Child Column in HIM_EVENT_EXTENSION(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


HIM_GROUPER_INFO



Column Section Top of Page


Table-level Detail

Description: HIM Grouper Information table
Definition: This table stores information collected for a given grouper vocabulary (i.e. - DRGs, APCs, CMGs, etc).
Table Type: REFERENCE





Column Detail - HIM_GROUPER_INFO


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.
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.
HIM_GROUPER_INFO_ID DOUBLE N Unique identifier for this table.
INFO_TYPE_CD DOUBLE N Codeset defining what the information is that's being stored for a given value.
INFO_VALUE VARCHAR(255) Y Discrete value of the information being stored in the table for a given row.
SOURCE_VOCABULARY_CD DOUBLE N Vocabulary code of the specified grouper (i.e. - DRG, APC, CMG, etc.)
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.


HIM_HAC_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Health Information Management Hospital Acquired Condition Criteria Table
Definition: Stores the criteria combinations of diagnosis codes and procedures codes that qualify for hospital acquired conditions.
Table Type: REFERENCE





Column Detail - HIM_HAC_CRITERIA


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 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.
COMPARE_DX_NOMEN_ID DOUBLE N The diagnosis nomenclature identifier to compare exists in combination with the nomenclature defined for the criteria.
COMPARE_DX_PRIMARY_ONLY_IND DOUBLE N This indicator determines whether the compare diagnosis nomenclature identifier needs to be primary.
COMPARE_PX_NOMEN_ID DOUBLE N The procedure nomenclature identifier to compare exists in combination with the nomenclature defined for the criteria.
COMPARE_PX_PRIMARY_ONLY_IND DOUBLE N This indicator determines whether the compare procedure nomenclature identifier needs to be primary.
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.
HAC_NOMENCLATURE_ID DOUBLE N The hospital acquired condition nomenclature identifier to have criteria rules defined.
HAC_PRIMARY_ONLY_IND DOUBLE N This indicator determines whether the hospital acquired condition nomenclature identifier needs to be primary.
HIM_HAC_CRITERIA_ID DOUBLE N This is the unique identifier for the HIM hospital acquired condition code criteria 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 - HIM_HAC_CRITERIA


Child Column in HIM_HAC_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: COMPARE_DX_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
COMPARE_PX_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
HAC_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


HIM_LABEL_FLEX



Column Section Top of Page


Table-level Detail

Description: flex the label format for media labels. Not Used!
Definition: flex format based on encounter type and location
Table Type: REFERENCE





Column Detail - HIM_LABEL_FLEX


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 Y 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 Y 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_TYPE_CD DOUBLE Y This is the encounter type code
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.
HIM_LABEL_FLEX_ID DOUBLE N This is the value of the unique primary identifier of the him_lable_flex table. It is an internal system assigned number
HIM_PRINTER_FORMATS_ID DOUBLE Y This is the value of the unique primary identifier of the Him Printer Formats table. It is an internal system assigned number.
LABEL_PRINTER VARCHAR(40) Y This is the Printer queue name
LOCATION_CD DOUBLE Y This is the location code
MEDIA_TYPE_CD DOUBLE Y This is the type of media i.e. PC, UR...
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.