Departmental logs
Departmental logs are data sent from the Customer’s Clinical System that provides key data to the Cost Allocations provided by TrueCost. Inputs used by the cost allocation are also derived from the department logs.
The logs are uploaded and processed in Infor Birst and combined with the data from the TrueCost application.
These are the departmental logs list of files:
load_DepartmentMappings
This log contains the mapping of EMR Departments to CSF Departments.
This table shows the fields in load_DepartmentMappings source file:
| Source file | Field name |
|---|---|
| load_DepartmentMappings | EMR_Department_Code |
| EMR_Department_Desc | |
| Finance_Enterprise_Group | |
| Accounting_Entity | |
| FinanceDimension1 | |
| FinanceDimension2 | |
| FinanceDimension3 | |
| FinanceDimension4 | |
| FinanceDimension5 | |
| FinanceDimension6 | |
| FinanceDimension7 | |
| FinanceDimension8 | |
| FinanceDimension9 | |
| FinanceDimension10 |
load_Encounter
This log contains encounters or patient visits.
This table shows the fields in load_Encounter source file:
| Source file | Field name |
|---|---|
| load_Encounters | Encounter_ID |
| Admission_Source_Code | |
| Admission_Source_Desc | |
| Admission_Type_Code | |
| Admission_Type_Desc | |
| Admit_Date | |
| Admitting_Provider_ID | |
| Admitting_Provider_Name | |
| Admitting_Provider_Specialty_Code | |
| Admitting_Provider_Specialty_Desc | |
| Attending_Provider_ID | |
| Attending_Provider_Name | |
| Attending_Provider_Specialty_Code | |
| Attending_Provider_Specialty_Desc | |
| Consulting_Provider_ID | |
| Consulting_Provider_Name | |
| Consulting_Provider_Specialty_Code | |
| Consulting_Provider_Specialty_Desc | |
| DRG_Code | |
| DRG_Code_and_Desc | |
| DRG_Desc | |
| DRG_MDC_Code | |
| DRG_MDC_Desc | |
| DRG_Type | |
| Discharge_Date | |
| Discharge_Provider_ID | |
| Discharge_Provider_Name | |
| Discharge_Provider_Specialty_Code | |
| Discharge_Provider_Specialty_Desc | |
| Discharge_Status_Code | |
| Discharge_Status_Desc | |
| Encounter_Department_Code | |
| Financial_Class_Code | |
| Financial_Class_Desc | |
| Payer_Code | |
| Payer_Name | |
| Insurance_Code | |
| Insurance_Name | |
| Length_of_Stay | |
| Patient_ID | |
| Patient_Location_Code | |
| Patient_Location_Level_1 | |
| Patient_Location_Level_2 | |
| Patient_Location_Level_3 | |
| Patient_Location_Level_4 | |
| Patient_Location_Level_5 | |
| Patient_Type_Code | |
| Patient_Type_Desc | |
| Primary_Discharge_Diagnosis_Code | |
| Primary_Discharge_Diagnosis_Desc | |
| Readmission_Indicator | |
| Referring_Provider_ID | |
| Referring_Provider_Name | |
| Referring_Provider_Specialty_Code | |
| Referring_Provider_Specialty_Desc | |
| Service_Line_Code | |
| Service_Line_Desc | |
| Service_Line_Code_and_Desc |
load_Events
This log contains patient activities.
This table shows the fields in load_Events source file:
| Source file | Field name |
|---|---|
| load_Events | Coding_Scheme_Code |
| Coding_Scheme_Name | |
| Cost_Object | |
| EMR_Department_Code | |
| Encounter_ID | |
| Event_Posted_Date | |
| Event_End_Time | |
| Event_ID | |
| Event_Start_Time | |
| Location_Code | |
| Ordering_Provider_ID | |
| Ordering_Provider_Name | |
| Ordering_Provider_Specialty_Code | |
| Ordering_Provider_Specialty_Desc | |
| Performing_Provider_ID | |
| Performing_Provider_Name | |
| Performing_Provider_Specialty_Code | |
| Performing_Provider_Specialty_Desc | |
| Unit_of_Measure | |
| Detail_Event_Duration | |
| Detail_Event_Quantity | |
| Event_Type |
load_ARTransactions
This log contains patient charges from the Billing system.
This table shows the fields in load_ARTransactions source file:
| Source file | Field name |
|---|---|
| load_ARTransactions | AR_Transaction_ID |
| Encounter_ID | |
| Transaction_Date | |
| Transaction_Type | |
| Payer_Code | |
| COB_Order | |
| Adjustment_Code | |
| Payment_Type | |
| Transaction_Amount |