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 |