Table Detail Report

HIM_REQUEST_TEMPLATE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: HIM Request/Letters to be printed relationships.
Definition: This table stores the relationship between HIM Requests and the letters to be printed for each status of the request.
Table Type: ACTIVITY





Column Detail - HIM_REQUEST_TEMPLATE_R


Column Name Type Null? Definition
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_REQUEST_TEMPLATE_R_ID DOUBLE N Primary Key - system generated - uniquely identifies a row in the table
LETTER_TYPE_CD DOUBLE N Identified the type of letter that the template will be used for.
REQUEST_STATUS_CD DOUBLE N The status of the request to which the letter template needs to be associated
REQUEST_TYPE_CD DOUBLE N Identifies the type of request for which the letter template would be used to print letters
TEMPLATE_ID DOUBLE N Identifies the letter template which is to be associated with the request status
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_REQUEST_TEMPLATE_R


Child Column in HIM_REQUEST_TEMPLATE_R(FK) Parent Table Name Parent Column Name
Parents: TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID


HIM_RESTRICT_VIEW_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: HIM RESTRICT VIEW HIST
Definition: HIM restrict view history
Table Type: ACTIVITY





Column Detail - HIM_RESTRICT_VIEW_HIST


Column Name Type Null? Definition
HIM_REQUEST_ID DOUBLE N The primary key of him_request table
HIM_REQUEST_PATIENT_ID DOUBLE N him request patient identifier
HIM_RESTRICT_VIEW_HIST_ID DOUBLE N him restrict view history identifier
OVERRIDE_COMMENT VARCHAR(255) Y override comment
OVERRIDE_DT_TM DATETIME Y override date and time
OVERRIDE_PRSNL_ID DOUBLE N override personnel identifier
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.
VIEW_DT_TM DATETIME N view date and time
VIEW_PRSNL_ID DOUBLE N view personnel identifier
VIEW_STATUS_FLAG DOUBLE N The status of the restriction Values: 1 - Not Applicable, 2 - Overridden, 3 - Rejected



Relationship Detail - HIM_RESTRICT_VIEW_HIST


Child Column in HIM_RESTRICT_VIEW_HIST(FK) Parent Table Name Parent Column Name
Parents: HIM_REQUEST_ID HIM_REQUEST HIM_REQUEST_ID
HIM_REQUEST_PATIENT_ID HIM_REQUEST_PATIENT HIM_REQUEST_PATIENT_ID
OVERRIDE_PRSNL_ID PRSNL PERSON_ID
VIEW_PRSNL_ID PRSNL PERSON_ID


HIM_SYSTEM_PARAMS



Column Section Top of Page


Table-level Detail

Description: Profile system parameters
Definition: Holds ProFile system parameters such as assigned allocation date ind.
Table Type: REFERENCE





Column Detail - HIM_SYSTEM_PARAMS


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.
ALPHA_TRACKING_IND DOUBLE N Indicates if client intends to upload alpha numeric tracking media identifiers.
ASSIGN_ALLOCATION_DT_CD DOUBLE N Used to determine which event is used to set the allocation date and time
AUTO_MATCH_IND DOUBLE Y When using Imaging, determines whether we use auto-matching logic when scanning in documents.
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.
CMPL_AUTO_HOLD_IND DOUBLE Y This indicates if we put a visit on hold for a physician when all deficient documents are in a pending transcription state
COSIGNATURE_IND DOUBLE Y Indicates if we are using the cosign logic
DAYS_TO_DELINQUENT DOUBLE Y Number of days before a deficiency is considered delinquent
DAYS_TO_QUALIFY_ORDER DOUBLE Y Days elapsed after the ordered date before the order will no longer qualify for a letter.
DAYS_TO_SUSPEND DOUBLE Y Number of days before a delinquency is a candidate for suspension.
DOCAGING_IND DOUBLE Y This indicator is used to determine if a facility is using document-level aging metrics to track against physicians for dictation and signature completion.
DOCAGING_PHYS_HOLD_IND DOUBLE Y Indicator specifying whether we stop the document aging process when a physician is currently on hold.
DOCAGING_VISIT_HOLD_IND DOUBLE Y Indicator specifying whether we stop the document aging process when a visit is currently on hold.
DOCUMENTS_IND DOUBLE Y The indicator of documents
ELECTRONIC_OP_MODE_IND DOUBLE Y Indicates if this sight is electronic or using paper
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.
FACILITY_LOGIC_IND DOUBLE Y Is this group of facilities using facility logic?
HIM_SYSTEM_PARAMS_ID DOUBLE N Unique identifier for this table
LOADING_LETTERS_IND DOUBLE Y Indicates whether a load of letters is being performed.
LOADING_POWERVISION_IND DOUBLE Y Indicates whether a load of the PowerVision summary table is taking place.
MANUAL_ALLOC_DT_UPDT_IND DOUBLE Y Indicates if we allow use to manually update the allocation date
MULTIPLE_PATIENTS_IND DOUBLE Y An indicator that distinguishes between allowing one or multiple patients per Patient Information Request (PIR). Possible values: 0 -- Multiple Patients can be in one PIR 1 -- Only one patient allowed in a PIR.
MULTI_ORG_ENCNTR_DISP_IND DOUBLE Y Applies only when multiple institution logic is enabled. An indicator that determines how and if encounters/visits from institutions other than the requestor's institution are displayed. Possible values: 0 -- Those encounters/visits are hidden 1 -- They are displayed as read-only.
ORDER_DELINQUENT_DAYS DOUBLE N This is the number of days before an unsigned order qualifies the physician to be delinquent.
ORDER_SUSPENSION_DAYS DOUBLE N This is the number of days before an unsigned order qualifies the physician to be suspended.
ORDER_TRACKING_IND DOUBLE N Indicates whether or not to track orders.
PAT_INFO_REQ_IND DOUBLE Y Is facility using Patient Information Request module
PENDING_SIGNS_IND DOUBLE N Indicates if the site is using pending signs functionality. This flag is not visible in himSystemParams.exe and cannot be turned off once it is turned on via the conversion script.
PUBLISH_IND DOUBLE Y Indicates whether anticipated documents should be published in powerchart.
REQUEST_NOTIFY_IND DOUBLE Y Indicator to whether site wants to be notified of outstanding requests when checking charts in.
ROI_CREDIT_CARD_IND DOUBLE N ROI credit card indicator
ROI_DEFAULT_ADDR_TYPE_CD DOUBLE N This is the primary address type used to get the facilities address that will be printed on the ROI Invoice
ROI_IND DOUBLE Y Is facility using the Release of Information module
ROI_INVOICE_IND DOUBLE Y Is this institution using the request of information invoices?
ROI_PRIMARY_ADDR_TYPE_CD DOUBLE N This is the address type that will be defaulted to if the primary does not exist for printing the facility address on the Invoice.
SINGLE_SCAN_IND DOUBLE Y Determines whether using document imaging capability in Completion applications
TAG_COLOR_ACTIVE_IND DOUBLE Y Indicates if we are using tag colors.
TAG_COLOR_COMMON_IND DOUBLE Y Indicator to whether site is maintaining same tag color for a physician across all patient's visits.
TASK_PLAN_ACTIVE_IND DOUBLE Y Indicates if task plans are used
TRACK_AUTO_HOLD_IND DOUBLE Y Indicate if auto holds are used for the tracking module
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.
VISITAGING_IND DOUBLE Y This indicator is used to determine if a facility is using visit-level aging metrics to track against physicians for signature of all relevant documents


HIM_TASK_DETAIL



Column Section Top of Page


Table-level Detail

Description: HIM Task Detail
Definition: Options associated with HIM tasks are stored in this table.
Table Type: REFERENCE





Column Detail - HIM_TASK_DETAIL


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.
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.
HIM_TASK_DETAIL_ID DOUBLE N This is the unique primary identifier of the him_task_detail table. SEQUENCE NAME: PROFILE_SEQ
PRIMARY_COLOR_VALUE DOUBLE N The primary background color that will be shown based on the PRIMARY_TASK_AGE_DAYS value.
PRIMARY_TASK_AGE_DAYS DOUBLE N The low limit number of days that the primary coloring should be used.
SECONDARY_COLOR_VALUE DOUBLE N The secondary background color that will be shown based on the SECONDARY_TASK_AGE_DAYS value.
SECONDARY_TASK_AGE_DAYS DOUBLE N The low limit number of days that the secondary coloring should be used.
TASK_TYPE_CD DOUBLE N Identifies the HIM Task Type. CODE SET: 6026
TERTIARY_COLOR_VALUE DOUBLE N The tertiary background color that will be shown based on the TERTIARY_TASK_AGE_DAYS value.
TERTIARY_TASK_AGE_DAYS DOUBLE N The low limit number of days that the tertiary coloring should be used.
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.
USE_TASK_AGE_COLOR_IND DOUBLE N Indicates whether or not Task Age Coloring is being used for the task type.


HIM_TEMP_REQUEST_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains request infomation to be processed after loading of summary tables.
Definition: This table contains information for requests to be processed by pfmt scripts after the loading of ProFile's PowerVision summary tables and him_event_allocation letters table.
Table Type: ACTIVITY





Column Detail - HIM_TEMP_REQUEST_LOG


Column Name Type Null? Definition
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_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_TEMP_REQUEST_LOG_ID DOUBLE N Unique ID for the him_temp_request_log table.
REQUEST_NBR DOUBLE N Stores the number of the request that caused the row to be written to the table.
SOURCE_FLAG DOUBLE N Indicates whether row is posted during loading of powervision summary tables or the letters' him_event_allocation table.
TABLE_ID DOUBLE N Based on the request number, stores the relevant table id to complete the processing of the request. Ex. media_master_id, chart_completion_hold_id, him_alloc_storage_id.
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_TEMP_REQUEST_LOG


Child Column in HIM_TEMP_REQUEST_LOG(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID