SQL Report for 270/271 Responses
Willett,Cerene J
Does anyone have a report that is used to identify patient responsibility based on the response from the 270/271 message in STAR? The goal is to work by exception and only bring results back for in-house accounts that has financial responsibility.
- Eligibility status
- Admit date
- Process date
- Patient type
- Account number
- FC
- Last name
- First name
- Room number
- Payer ID (returned)
- Payer ID (initial)
- Subscriber member ID
- Discrepancy
- Part A Deductible Met (R)
- Part A Deductible Remaining (R)
- Mcare Hosp Copay Days Remaining (1-60) (R)
- Mcare Hosp Copay Days Remaining (61-90) (R)
- InN Hosp InP Fam Annual Remaining (R)
- InN Hosp InP Fam Annual Max (R)
- InN Hosp InP Fam Annual Met (R)
- InN Hosp InP Ind Annual Remaining (R)
- InN Hosp InP Ind Annual Max (R)
- InN Hosp InP Ind Annual Met (R)
- InN Out of Pocket Ind Remaining (R)
- InN Out of Pocket Ind Annual Max (R)
- InN Out of Pocket Fam Remaining (R)
- InN Out of Pocket Fam Annual Max (R)
- InN Out of Pocket Fam Annual Met (R)
- In Network Inpatient Copay
- Deductible Individual
- InN Inpatient Coinsurance (R)
- Inpatient Copay Days (R)
- Policy Number
- COB
- HMO Name
- HIC Number (R)
- Plan Number
- Plan Name(R)
- Group Number(R)
- Group Name(R)
- Group or Policy Name(R)
- Group Policy Number(R)
- InN Out of Pocket Ind Annual Met (R)
Cerene Willett
Systems Manager, Revenue Operations
Health First, Inc
3300 Fiske Blvd
Building A
Rockledge, Fl 32955