Table Detail Report

PATIENT_EVENT_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Event History
Definition: Used for tracking history of changes to patient event.
Table Type: ACTIVITY





Column Detail - PATIENT_EVENT_HIST


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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
EVENT_DT_TM DATETIME Y The date and time the event took place.
EVENT_TYPE_CD DOUBLE N Identifies the type of event being written.
PATIENT_EVENT_HIST_ID DOUBLE N Uniquely identifies a historical record of a change to the person event table.
PATIENT_EVENT_ID DOUBLE N Uniquely identifies the related patient event.
PM_HIST_TRACKING_ID DOUBLE N This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME Y ** OBSOLETE **. Use column updt_dt_tm for any filtering/ordering query. If transaction date time is needed, it should be retrieved from pm_hist_tracking table. Note that its date may be in the past, as in before the update date time.
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 - PATIENT_EVENT_HIST


Child Column in PATIENT_EVENT_HIST(FK) Parent Table Name Parent Column Name
Parents: PATIENT_EVENT_ID PATIENT_EVENT PATIENT_EVENT_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PM_INFO_HIST



Column Section Top of Page


Table-level Detail

Description: PM Infomormation History Table
Definition: This is a generic history table that contains history for a few tables. Waitlist letter history and mental health history are included in this table.
Table Type: ACTIVITY





Column Detail - PM_INFO_HIST


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.
C01_CD DOUBLE N Code 01
C02_CD DOUBLE N Code 02
D01_DT_TM DATETIME Y Date and Time 01
D02_DT_TM DATETIME Y Date and Time 02
D03_DT_TM DATETIME Y Date and Time 03
D04_DT_TM DATETIME Y Date and Time 04
DESCRIPTION VARCHAR(200) N textual description
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.
HIST_TYPE_CD DOUBLE N Type of History for a given Information Type.
INFO_TYPE_CD DOUBLE N Type of History Information, such as Wait List Letter History, etc..
PARENT_ENTITY_ID DOUBLE N Primary key of table defined by the parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(32) N Name of the parent table.
PM_INFO_HIST_ID DOUBLE N Unique identifier for each pm_info_hist row. Servers as the primary key.
T01_TXT VARCHAR(200) N Text 01
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_LOCATOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Managemetn Locator table
Definition: This table stores information used to locate patients.
Table Type: ACTIVITY





Column Detail - PM_LOCATOR


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.
LOCATOR_ID DOUBLE N This is the primary key for this table. It is a numeric value.
NAME_FIRST_KEY VARCHAR(100) Y This is the person's first given name all capitals with punctuation removed. This field is used for indexing and searching for a person by name.
NAME_FIRST_KEY_A_NLS VARCHAR(400) Y NAME_FIRST_KEY_A_NLS column
NAME_FIRST_KEY_NLS VARCHAR(202) Y First Name Key field converted to NLS format for internationalization requirements.
NAME_LAST_KEY VARCHAR(100) Y This is the person's last name all capitals with punctuation removed. This field is used for indexing and searching for a person by name.
NAME_LAST_KEY_A_NLS VARCHAR(400) Y NAME_LAST_KEY_A_NLS column
NAME_LAST_KEY_NLS VARCHAR(202) Y Last Name Key field converted to NLS format for internationalization requirements.
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_LOCATOR


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


PM_MENTAL_HEALTH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pm Mental Health
Definition: Pm Mental Health
Table Type: ACTIVITY





Column Detail - PM_MENTAL_HEALTH


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.
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.
FIRST_DT_TM DATETIME Y First form 4 date and time
FIRST_FAC_CD DOUBLE N First form 4 facility
FIRST_PRSNL_ID DOUBLE N First form 4 prsnl
NEXT_PANEL_DT_TM DATETIME Y next panel date and time
PM_MENTAL_HEALTH_ID DOUBLE N pm mental health id
RENEWAL_DETERMINATION_DT_TM DATETIME Y renewal determination date and time
SECOND_DT_TM DATETIME Y second form 4 date and time
SECOND_FAC_CD DOUBLE N second form 4 facility
SECOND_PRSNL_ID DOUBLE N second form 4 prsnl 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 - PM_MENTAL_HEALTH


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


PM_MOH_INPAT_CENSUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM MOH INPAT CENSUS
Definition: Ministry of Health (Canada) inpatient census.
Table Type: ACTIVITY





Column Detail - PM_MOH_INPAT_CENSUS


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.
ADMITTED_DAY DOUBLE Y Admitted day.
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.
DATE_START DATETIME N Date start.
DECEASED_DAY DOUBLE Y Deceased count for the day.
DISCHARGED_DAY DOUBLE Y Discharge count for the day.
ENCNTR_REPORT_TYPE CHAR(30) N Encounter report type.
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.
INPATIENT_START DOUBLE Y Inpatient start.
INTENSIVE_DAY DOUBLE Y Intensive care count for the day.
LOCATION_CD DOUBLE N Location code value
MEDICAL_DAY DOUBLE Y Medical count for the day.
NB_ADMITTED_DAY DOUBLE Y Newborn count for the day.
NB_DECEASED_DAY DOUBLE Y Newborn death count for the day.
NB_DISCHARGED_DAY DOUBLE Y Newborn discharge count for the day.
NB_SAME_DAY DOUBLE Y Newborn same day count for the day.
NB_START DOUBLE Y Newborn start count.
OBGYN_DAY DOUBLE Y OBGYN count for the day.
OTHER_DAY DOUBLE Y Other count for the day.
PEDIATRIC_DAY DOUBLE Y Pediatric count for the day.
PM_MOH_INPAT_CENSUS_ID DOUBLE N Primary key.
PSYCHIATRIC_DAY DOUBLE Y Pshychiatric count for the day.
SAME_DAY DOUBLE Y Same day visit count for the day.
SURGICAL_DAY DOUBLE Y Surgical count for the day.
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_MOH_INPAT_CENSUS


Child Column in PM_MOH_INPAT_CENSUS(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD