Table Detail Report

HIM_LETTERS_TEMP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores information retrieved when first determining what letters to print.
Definition: HIM Letters Temp
Table Type: ACTIVITY





Column Detail - HIM_LETTERS_TEMP


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N Identifier for an order from the order_action table.
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.
AGE DOUBLE Y Age of the document
BATCH_NBR DOUBLE Y Number for grouping Letter jobs together.
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.
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_LETTERS_TEMP_ID DOUBLE N This is the value of the unique primary identifier of the him_letters_temp table. It is an internal system assigned number.
ORDER_ID DOUBLE N Unique identifier for an order from the orders table.
PRSNL_ID DOUBLE N Physician associated with the information in the row.
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_LETTERS_TEMP


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


HIM_LOC_EXTENSION



Column Section Top of Page


Table-level Detail

Description: HIM Location extensions
Definition: These are values associated with a location that are used for tracking and completion of a patients chart
Table Type: REFERENCE





Column Detail - HIM_LOC_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.
AUTO_HOLD_IND DOUBLE Y Indicates if a chart should be put on hold by the system when moved to this location
AUTO_REQUEST_IND DOUBLE Y Indicates it a request for the patient chart be made when a patient is moved to this location
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.
CHARTLOAN_DAYS DOUBLE Y This is the number of days that a chart will be loaned before it becomes delinquent
CONTACT_PERSON_ID DOUBLE N This the contact person for this location
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.
LOCATION_CD DOUBLE N This is the codeset for the location
MEDICAL_RECORDS_LOC_IND DOUBLE Y this field is used to indicate if the location is considered a Medical Records Location
MICROFILM_IND DOUBLE Y Value to define if a location is a microfilm location. (number)
PERMANENT_LOC_IND DOUBLE Y Indicates if this is a permanent storage location for patient charts
RECORD_AVAILABLE_IND DOUBLE Y Indicates if the chart is available for request when it is in this location
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_PRINTER_FORMATS



Column Section Top of Page


Table-level Detail

Description: This table holds the formats for printing labels
Definition: Has fields like dispay and format.
Table Type: REFERENCE





Column Detail - HIM_PRINTER_FORMATS


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.
DIRECTORY_IND DOUBLE Y Indicates if this form prints to que or a directory
DIRECTORY_NAME VARCHAR(255) Y This is the name of the directory that the label would print to
DISPLAY VARCHAR(255) Y This is the display the user will see when selecting a format
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.
FORMAT VARCHAR(255) Y This is the name of the ccl program that will print the label
HIM_PRINTER_FORMATS_ID DOUBLE N This is the value of the unique primary identifier of the Him Printer Formats table. It is an internal system assigned number.
SORT_ORDER_FLAG DOUBLE Y Flag indicating how labels will be sorted when printing them in batch mode.
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_PV_CHART



Column Section Relationship Section Top of Page


Table-level Detail

Description: HIM PV CHART
Definition: Visit information for Powervision
Table Type: ACTIVITY





Column Detail - HIM_PV_CHART


Column Name Type Null? Definition
ADMITTING_PERSON_ID DOUBLE N Person_Id of the admitting physician
ALLOCATION_DT_FLAG DOUBLE Y This flexes how allocation date is calculated
ALLOCATION_DT_MODIFIER DOUBLE Y The number of days to add to an event's date in calculating the allocation date.
ALLOCATION_DT_TM DATETIME Y Allocation date of the visit
ATTENDING_PERSON_ID DOUBLE N Person_Id of the attending physician
BIRTH_DT_TM DATETIME Y Birth date of the patient
CHART_AGE DOUBLE Y Chart age of the visit
CHART_STATUS_CD DOUBLE N Status of the visit
CURRENT_LOC_CD DOUBLE N Location of the chart
DEFICIENCY_IND DOUBLE Y Indicator that states if the chart is deficient
DEF_ALLOCATION_DATE_IND DOUBLE Y The indicator for any allocation date not equal to null
DELINQUENT_IND DOUBLE Y Indicator that states if the chart is delinquent
DISCH_DT_TM DATETIME Y Disch date of the visit
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_TYPE_CD DOUBLE N Type of the visit (Inpatient, etc.)
FINANCIAL_CLASS_CD DOUBLE N Financial class of the encounter
HIM_PV_CHART_ID DOUBLE N Unique identifier of the table
MEDIA_MASTER_ID DOUBLE N Unique id of the media from the media_master table
MEDIA_TYPE_CD DOUBLE N Type of the media
MED_SERVICE_CD DOUBLE N Type of medical service
ORGANIZATION_ID DOUBLE N Id of the organization tied to the encounter
ORG_NAME VARCHAR(100) Y name of the organization tied to the encounter
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REG_DT_TM DATETIME Y Admission date of the visit
SEX_CD DOUBLE N Sex of the patient
SUSPENDED_IND DOUBLE Y Indicator that tells if the chart is suspended
TRACKING_ID VARCHAR(35) Y Tracking id of the chart
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.
VOLUME_NBR DOUBLE Y Volume number of the chart



Relationship Detail - HIM_PV_CHART


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


HIM_PV_DOCUMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: HIM PV DOCUMENT
Definition: Summary table for document information in Powervision
Table Type: ACTIVITY





Column Detail - HIM_PV_DOCUMENT


Column Name Type Null? Definition
ACTION_PRSNL_ID DOUBLE N Person_Id of the deficient physician
ACTION_STATUS_CD DOUBLE N Status of the deficiency
ACTION_TYPE_CD DOUBLE N Action that is requested
CE_EVENT_PRSNL_ID DOUBLE Y Identifier for the respective row on the Ce_event_prsnl table Contains the ce_event_prsnl_id of the document row.
CHART_AGE DOUBLE Y Age of the visit
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EVENT_ALLOCATION_DT_TM DATETIME Y Allocation date for a specific document deficiency
EVENT_CD DOUBLE N Deficient document
EVENT_END_DT_TM DATETIME Y Event_End_Dt_Tm
EVENT_END_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
EVENT_ID DOUBLE N Unique event_id of the deficiency
HIM_PV_DOCUMENT_ID DOUBLE N Unique identifier for the table
ORGANIZATION_ID DOUBLE N Organization_Id of the organization tied to the document
ORG_NAME VARCHAR(100) Y Organization_Name of the organization tied to the document
PARENT_EVENT_ID DOUBLE N Provides a mechanism for logical grouping of events. i.e. supergroup and group tests. Same as event_id if current row is the highest level parent.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
POSITION_CD DOUBLE N Physical position code
PROFILE_STATUS VARCHAR(25) Y The status of the documents related to Profile
PROFILE_STATUS_CD DOUBLE N Statuses code values of documents throughout the completion module
PRSNL_ALIAS VARCHAR(25) Y Alias of the physician
PRSNL_GROUP_NAME VARCHAR(255) Y Name of the group physician tied to
PRSNL_POSITION_DESC VARCHAR(40) Y Physician position
PUBLISH_FLAG DOUBLE N States whether the item in this record is viewable via "normal" applications (e.g., charts, on-line inquiries, etc.). Audit and/or administrative applications would be able to view non-publishable results.
REQUEST_DT_TM DATETIME Y Date/Time of the request
REQUEST_PRSNL_FT VARCHAR(255) Y Free text field with the requesting prsnl
REQUEST_PRSNL_ID DOUBLE N Person_Id of the requester
REQUEST_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RESULT_STATUS_CD DOUBLE N Document result status code
STORAGE_CD DOUBLE N Identifies location/device where blob is stored. For example, Blob Table, Dictation System, Image Server, HSM, etc.
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.
VALID_FROM_DT_TM DATETIME N The date and time that this row became valid.
VALID_UNTIL_DT_TM DATETIME N Date row is valid until
VIEW_LEVEL DOUBLE N Controls viewability of an Event row.



Relationship Detail - HIM_PV_DOCUMENT


Child Column in HIM_PV_DOCUMENT(FK) Parent Table Name Parent Column Name
Parents: CE_EVENT_PRSNL_ID CE_EVENT_PRSNL CE_EVENT_PRSNL_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
REQUEST_PRSNL_ID PRSNL PERSON_ID