ECA definitions Flashcards
VisitID
Unique patient ID representing each surgery (visit)
InsertDatetime
When the visit was created in HST
UpdateDatetime
When the visist was updated in HST
UdmDatetime
The date stamp of the last time the data was updated in the UDM. This does not tie back to HST.
SourceSystem
The patient accounting system
LocalFacilityID
This field is for centers with multiple patient accounting system instances (Example: Mt. Pleasant 50016 has local facility 1 for its ASC, local facility 2 for its Anesthesia billing, and local facility 3 for its CRNA billing)
FacilityID
Unique numeric identifier for each facility
BusinessUnitID
Unique numeric identifier for each facility (same as facility ID)
LocalFacility
Unique numeric identifier for each facility (same as facility ID)
PatientID
This is a join field from multiple patient accounting tables in HST
PatientKey
This is a join field from multiple patient account tables in HST
LocalPatientID
The patient ID from HST
VisitNumber
How you differentiate in between different visits. (Example: 2= visit #2 for the patient)
AccountNumber
The same as LocalPatientID. The patient ID from HST
DateOfService
Day the surgery occurred
DateOfServiceYear
Year the surgery occurred
DateOfServiceMonth
Month the surgery occurred
DateOfServiceAccountingPeriod
The month and year of the surgery (Shown as 202201= January 2022)
ScheduledRoom
Room the surgery occurred in (examples: OR 1, OR 2)
BillingNumber
How you differentiate in between different visits that were billed. This shows which visit we are billing for. (Example: 2= visit #2 for the billed for the patient)
TotalCharges
The total billed charges on a case inclusive of all CPT and HCPCS codes. Pulled from HST/ patient accounting system.
TotalPayments
The total payments on a case inclusive of all payments (insurance and patient). Pulled from HST/ patient accounting system.
TotalContAdjustments
The total adjustments we need to take on a case based on our contract. Pulled from HST/ patient accounting system.
TotalRefunds
The total amount of money refunded to a patient or insurance provider.
TotalBaddebt
The total amount that a patient did not pay. This debt is written off and goes to collections.
TotalOtherAdjustments
An adjustment taken on an account which does not fall into any other category.
BalanceDue
The balance on the account in HST
PhysicianCode
The code assigned to a physician when a teammate at the center creates a profile for them in HST.
PhysicianName
The name of the physician performing the surgery
PhysicianSpecialtyCode
The abbreviation of the physician’s specialty performing the surgery (Examples: ORT, POD, ANS)
PhysicianSpecialtyDescription
The specialty of the physician performing the surgery (Examples: Orthopaedics, Podiatry, Pain Management)
FinancialClass
The number that correlates with a payer type. (example: 6= BCBS)
FinancialClassDescription
A grouping of different payors into similar categories for billing purposes. Rev Cycle recommends using this for analytics.
PayerAccountCode
The number that correlates with the payer name in the HST hierarchy. (example: 221= BCBS of TX HMO)
PayerName
The specific type of insurance provided by the patient. (Example: BCBS of Texas)
PayerPriority
This ranks the payers in the order they were billed. Primary payer = priority 1, secondary payer = priority 2
PayerType
A grouping of payors that shows federal health insurance, private insurance, and patient pay. (Examples: Commercial, Medicare, Medicaid, Self Pay)
PayerProduct
The same as Payer Type.
FundingPayer
The entity processing the claim.
PayerParentNatl
A mapped field of individual payers at the BUCAH level, as defined by Payer Analytics; similar to ContractedPayer, just at the higher level
ContractedPayer
A mapped field of individual payers that aligns with Funding Payer
PrimaryCPT
The five digit number representing the primary surgery being performed. Current Procedural Terminology(CPT)- used to describe the procedure performed by the healthcare provider on a patient)
PrimaryCPTDescription
The description of the primary surgery being performed
PrimaryCPTSpecialtyCode
The abbreviation of the specialty of the surgery being performed
PrimaryCPTSpecialtyDescription
The specialty of the surgery being performed
ORStartTime
The time the surgery starts in the OR
OREndTime
The time the surgery ends in the OR
ORMinutes
The number of minutes the patient is in the OR
PreparationStartTime
The time the preparation for surgery starts
PreparationEndTime
The time the preparation for surgery ends
PreparationMinutes
The number of minutes a patient is being prepared for surgery
RecoveryRoomStartTime
The time recovery starts
RecoveryRoomEndTime
The time recovery ends
RecoveryRoomMinutes
The number of minutes a patient is in recovery
CPT01_BilledCPTCode
The 1st CPT being billed to insurance based on a coder’s recommendation. This CPT is meant to encompass the core aspect of the surgery and will drive total reimbursement for the case.
CPT02_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT03_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT04_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT05_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT06_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT07_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT08_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT09_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT10_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT11_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT12_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT13_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT14_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT15_BilledCPTCode
CPT 2-15 are the 5 number codes that represent the additional procedures performed during surgery
CPT01_BilledCPTDescription
The 1st CPT description being billed to insurance based on a coder’s recommendation. This CPT is meant to encompass the core aspect of the surgery and will drive total reimbursement for the case.
CPT02_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT03_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT04_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT05_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT06_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT07_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT08_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT09_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT10_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT11_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT12_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT13_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT14_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT15_BilledCPTDescription
CPT 2-15 are the procedure descriptions that represent the additional procedures performed during surgery
CPT01_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT02_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT03_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT04_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT05_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT06_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT07_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT08_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT09_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT10_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT11_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT12_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT13_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT14_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT15_CPTModifierCode
This is a code used to supplement the information or adjust care descriptions to provide extra details concerning a procedure or service provided by a physician. For example, the LT modifier indicates the procedure was done on the patient’s left side.
CPT01_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT02_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT03_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT04_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT05_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT06_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT07_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT08_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT09_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT10_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT11_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT12_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT13_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT14_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT15_RevenueCode
A revenue code indicates the department or place where a procedure or treatment is performed.
CPT01_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master.
CPT02_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT03_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT04_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT05_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT06_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT07_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT08_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT09_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT10_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT11_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT12_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT13_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT14_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT15_BilledAmount
The total amount billed for a specific CPT code based on the facility charge master
CPT01_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT02_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT03_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT04_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT05_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT06_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT07_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT08_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT09_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT10_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT11_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT12_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT13_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT14_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT15_ICDCode
The classification system of diagnosis codes representing conditions and diseases, related health problems, and abnormal findings that are universally accepted by the medical and insurance fields. International Classification of Disease (ICD)
CPT01_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT02_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT03_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT04_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT05_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT06_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT07_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT08_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT09_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT10_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT11_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT12_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT13_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT14_ContractFee
The amount we expect to be reimbursed from the insurance provider.
CPT15_ContractFee
The amount we expect to be reimbursed from the insurance provider.
TotalContractFee
The total amount we expect to be reimbursed from the insurance provider. This takes into account our contract and necessary adjustments.
ContractID
The ID in HST that connects to the PCD (Payer Contract Database)
ContractNumber
The contract number in the Payer Contract Database.
RateStartDate
This field used to track the date the payer contract rates begins but is no longer used per SCA Data Architect Ashley Bryan.
RateEndDate
This field used to track the date the payer contract rates end but is no longer used per SCA Data Architect Ashley Bryan.
CPT01_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT02_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT03_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT04_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT05_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT06_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT07_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT08_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT09_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT10_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT11_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT12_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT13_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT14_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
CPT15_ManagedCareRate
This fields used to track the Managed Care Rate but are no longer used per SCA Data Architect Ashley Bryan.
VisitCanceledFlag
Identifies if the surgery occurred or was cancelled.
