LH_CNT_IRFPAI



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IRFPAI
Definition: This table is used to store information related to IRFPAI reports and exports. When a report is executed, the date for that type of report will be saved. That date can then be seen when the MPage is loaded again for that patient encounter.
Table Type: ACTIVITY





Column Detail - LH_CNT_IRFPAI


Column Name Type Null? Definition
ADMIT_EXPORT_DT_TM DATETIME Y Date and time of last admission export
DISCH_EXPORT_DT_TM DATETIME Y Date and time of last discharge export
ENCNTR_ID DOUBLE N Encounter ID for the given person encounter
LH_CNT_IRFPAI_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IRFPAI table.
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 - LH_CNT_IRFPAI


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


LH_CNT_IRFPAI_CHANGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Content IRF-PAI Change
Definition: This table will hold user selected values for the IRF-PAI report. This is necessary to allow users to select values other than the default selected values when exporting a report.
Table Type: ACTIVITY





Column Detail - LH_CNT_IRFPAI_CHANGE


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N Encounter ID this specific row is related to.
FORM_QUESTION_IDENTIFIER VARCHAR(20) N The section of the IRF-PAI report this saved change is for.
FORM_QUESTION_VALUE VARCHAR(20) N The actual value selected in the IRF-PAI report for this section.
LH_CNT_IRFPAI_CHANGE_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IRFPAI_CHANGE table.
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 - LH_CNT_IRFPAI_CHANGE


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


LH_CNT_IRFPAI_ENCNTR



Column Section Top of Page


Table-level Detail

Description: Lighthouse Content IRFPAI Encounter
Definition: IRFPAI (Inpatient Rehab Facility Patient Assessment Instrument) encounter specific reporting information.
Table Type: ACTIVITY





Column Detail - LH_CNT_IRFPAI_ENCNTR


Column Name Type Null? Definition
ARTHRITIS_IND DOUBLE N An arthritic condition recorded in Impairment Group, Etiologic Diagnosis or Comorbid Conditions.
ENCNTR_ID DOUBLE N The encounter ID of the patient associated to the reporting information.
LH_CNT_IRFPAI_ENCNTR_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IRFPAI_ENCNTR table.
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.


LH_CNT_IRFPAI_ICD



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IRFPAI_ICD
Definition: This table is used to store the sequence of ICD codes for a given encounter. These codes can be freetext as well as having a sequence set. It is possible that a user can start the process, need to save the results, and come back to finish. That is when the data will be retrieved from this table.
Table Type: ACTIVITY





Column Detail - LH_CNT_IRFPAI_ICD


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N Foreign Key to Encounter table
ICD_CODE_SEQ DOUBLE N The set sequence for ICD codes for the given encounter
ICD_CODE_TEXT VARCHAR(20) N ICD Display of the given code
LH_CNT_IRFPAI_ICD_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IRFPAI_ICD table.
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 - LH_CNT_IRFPAI_ICD


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


LH_CNT_REHAB_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_REHAB_EVENT
Definition: This table will store rehab productivity events as defined in bedrock.
Table Type: ACTIVITY





Column Detail - LH_CNT_REHAB_EVENT


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.
EVAL_EVENT_FLAG DOUBLE N This field indicates whether the event is an evaluation, re-evaluation, or neither. 0 - Neither , 1 - Evaluation, 2 - Reevaluation.
EVENT_END_DT_TM DATETIME Y Date/time that the event occurred.
EVENT_ID DOUBLE N Event_ID of the rehab productivity event from clinical_event.
LH_CNT_REHAB_EVENT_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_REHAB_EVENT table.
MISSED_IND DOUBLE N Designates an event as a 'units lost' event.
PERFORM_PRSNL_ID DOUBLE N Person_ID of the personnel who performed the event.
REASON_EVENT_ID DOUBLE N Event_ID of the rehab productivity reason from clinical_event.
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 - LH_CNT_REHAB_EVENT


Child Column in LH_CNT_REHAB_EVENT(FK) Parent Table Name Parent Column Name
Parents: PERFORM_PRSNL_ID PRSNL PERSON_ID