Table Detail Report

HIM_PV_PHYSICIAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: HIM PV PHYSICIAN
Definition: ProFile summary table for Powervision
Table Type: ACTIVITY





Column Detail - HIM_PV_PHYSICIAN


Column Name Type Null? Definition
ALIAS VARCHAR(200) Y Alias of the deficiency physician
CHART_AGE DOUBLE Y Age of the chart associated to the physician
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
HIM_PV_PHYSICIAN_ID DOUBLE N Unique identifier of the table
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRSNL_POSITION_DESC VARCHAR(40) Y Physician position
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_PV_PHYSICIAN


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


HIM_REQUEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: HIM REQUEST
Definition: This is a table that holds top-level information about request
Table Type: ACTIVITY





Column Detail - HIM_REQUEST


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.
CANCEL_PRSNL_ID DOUBLE N The person_id of a prsnl that cancels this request
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_PRSNL_ID DOUBLE N The id of the person who created the request.
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_ID DOUBLE N The primary key of this table
LAST_UPDATE_PRSNL_ID DOUBLE N The id of the person who last updated the request
LOCKED_IND DOUBLE Y if the request hast status of cancel, rejected, or completed, then this field will be set to 1
ONSITE_IND DOUBLE Y Indicator to specify if the request will be executed on-site
ORGANIZATION_ID DOUBLE N The primary key of organization table
PHONE_ID DOUBLE N The primary key of phone table
PULL_LIST_PRINTED_DT_TM DATETIME Y The date and time of the pull list got printed
PULL_LIST_PRINTED_IND DOUBLE Y if pull list is printed, this indicator will be set to 1
REQUESTER_ID DOUBLE N The id of a person who has requested a request
REQUEST_DT_TM DATETIME Y The date and time of request
REQUEST_NUMBER DOUBLE Y The number of request
REQUEST_NUMBER_POOL_CD DOUBLE N The pool where we get request numbers from
REQUEST_STATUS_CD DOUBLE N The code values of request status
REQUEST_STATUS_DT_TM DATETIME Y The date and time of request status has been changed
REQUEST_STATUS_PRSNL_ID DOUBLE N The id of a person that changed the request status
REQUEST_TYPE_CD DOUBLE N The code values of request type
REQUIRED_DT_TM DATETIME Y The date and time of the request was required
ROI_REQUESTER_ID DOUBLE N The ID of a person or organization requesting and ROI request
SCH_EVENT_ID DOUBLE N This column ties the request to the scheduled appointment that was used by the rules to create the request.
TO_LOCATION_CD DOUBLE N The code_value of location where the request will be sent
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_REQUEST


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




Parent Column in HIM_REQUEST (PK) Child Table Name Child Column Name
Children: HIM_REQUEST_ID HIM_REQUEST_CRITERIA HIM_REQUEST_ID
HIM_REQUEST_PATIENT HIM_REQUEST_ID
HIM_RESTRICT_VIEW_HIST HIM_REQUEST_ID
REQUEST_EVENT_RELTN HIM_REQUEST_ID
ROI_REJECT_REASON HIM_REQUEST_ID
ROI_REQUEST HIM_REQUEST_ID


HIM_REQUEST_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table holds criterias for requests.
Definition: This table holds criterias for requests. The criterias could be clinical events, patient charts, or unit records
Table Type: ACTIVITY





Column Detail - HIM_REQUEST_CRITERIA


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.
CRITERIA_STATUS_CD DOUBLE Y The code value of criteria status
CRITERIA_STATUS_DT_TM DATETIME Y The date and time of a criteria status
CRITERIA_STATUS_PRSNL_ID DOUBLE Y The person id of a prsnl that is in charge of criteria status
CRITERIA_TYPE_CD DOUBLE Y The code values of criteria types
DOCUMENT_STATUS_FLAG DOUBLE N The valid flag values are 1 - Selected; 2 - Ready to send; 3 - Sent
ENCNTR_ID DOUBLE Y 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 Y Unique identifier for an event.
HIM_REQUEST_CRITERIA_ID DOUBLE N The primary key of this table
HIM_REQUEST_ID DOUBLE Y The primary key of him_request table
HIM_REQUEST_PATIENT_ID DOUBLE Y The primary key of him_request_patient table
LONG_TEXT_ID DOUBLE N The unique primary identifier of the long_text table. Stores the reference ID to the paper document comment.
MEDIA_MASTER_ID DOUBLE Y The primary key of media master table
MRP_SELECTED_IND DOUBLE N MRP selected indicator
PAPER_DOCUMENT_COMMENT VARCHAR(255) Y paper document comment
PAPER_EVENT_DISPLAY_KEY VARCHAR(100) Y This field stores the name of the paper document that is being released.
PAPER_TYPE_CD DOUBLE Y The code values of paper type
PERSON_ID DOUBLE Y This is the value of the unique primary identifier of the person 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 - HIM_REQUEST_CRITERIA


Child Column in HIM_REQUEST_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
HIM_REQUEST_ID HIM_REQUEST HIM_REQUEST_ID
HIM_REQUEST_PATIENT_ID HIM_REQUEST_PATIENT HIM_REQUEST_PATIENT_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
MEDIA_MASTER_ID MEDIA_MASTER MEDIA_MASTER_ID
PERSON_ID PERSON PERSON_ID


HIM_REQUEST_HISTORY



Column Section Top of Page


Table-level Detail

Description: This table stores a history of changes to requests
Definition: This table stores a history of changes to requests. Status change and date correction history information is stored for documentation purposes
Table Type: ACTIVITY





Column Detail - HIM_REQUEST_HISTORY


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 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.
HIM_REQUEST_HISTORY_ID DOUBLE N Primary Key - system generated - uniquely identifies a row in the table
HIM_REQUEST_ID DOUBLE N Id of the request for which the history is being documented
ONSITE_IND DOUBLE N Indicator to specify if the request will be executed on-site
REQUEST_STATUS_CD DOUBLE N The status of the patient request before the update was done
REQUEST_STATUS_DT_TM DATETIME Y The date and time when the update to the patient request was done
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_REQUEST_PATIENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: HIM REQUEST PATIENT
Definition: This is a table that holds request information at patient level
Table Type: ACTIVITY





Column Detail - HIM_REQUEST_PATIENT


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.
APPROVAL_IND DOUBLE Y This is an indicator the is valued when a request needing approval is approved.
AUTHORIZED_IND DOUBLE Y Indicates if we have an authorization to fill this request
AUTHORIZED_REJECT_REASON_CD DOUBLE N This is the code value for the authorize reject reason
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.
CANCEL_PRSNL_ID DOUBLE N The id of the person who cancelled the request
CREATE_PRSNL_ID DOUBLE N The id of the person who created the request.
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.
HIM_REQUEST_ID DOUBLE N The primary key of him_request table
HIM_REQUEST_PATIENT_ID DOUBLE N The primary key of this table
LAST_UPDATE_PRSNL_ID DOUBLE N The id of the person who last updated the request.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REJECTED_REASON_CD DOUBLE N This is the reason that the request was rejected
REQUEST_STATUS_CD DOUBLE N This is the reason that the request was rejected
REQUEST_STATUS_DT_TM DATETIME Y This is the date and time that the status was set/changed
REQUEST_STATUS_PRSNL_ID DOUBLE N This is the person id of the person who is requesting this information
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_PATIENT


Child Column in HIM_REQUEST_PATIENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
HIM_REQUEST_ID HIM_REQUEST HIM_REQUEST_ID
PERSON_ID PERSON PERSON_ID
CANCEL_PRSNL_ID PRSNL PERSON_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
LAST_UPDATE_PRSNL_ID PRSNL PERSON_ID
REQUEST_STATUS_PRSNL_ID PRSNL PERSON_ID




Parent Column in HIM_REQUEST_PATIENT (PK) Child Table Name Child Column Name
Children: HIM_REQUEST_PATIENT_ID HIM_REQUEST_CRITERIA HIM_REQUEST_PATIENT_ID
HIM_RESTRICT_VIEW_HIST HIM_REQUEST_PATIENT_ID