Posted by: Deke April 21, 2022
Login in to Rate this Post:
0
?
Anybody up for a sample SQL help.
ClaimHeader
PK-claimid
FK-enrollid
FK-providerid
StartDate
EndDate
PlaceOfService
TotalBilledAmount
ClaimDetail
PK-claimid
PK-claimline
ServiceCode
LineBilledAmount
Member
PK-memberid
FirstName
LastName
Gender
Enrollment
PK-enrollmentid
FK-memberid
Program
Network
Display the claim ID, member ID and sum of line billed amounts for members enrolled in the “Medi-Cal” program in the “HIL” network where the service code begins with “G”
ClaimHeader
PK-claimid
FK-enrollid
FK-providerid
StartDate
EndDate
PlaceOfService
TotalBilledAmount
ClaimDetail
PK-claimid
PK-claimline
ServiceCode
LineBilledAmount
Member
PK-memberid
FirstName
LastName
Gender
Enrollment
PK-enrollmentid
FK-memberid
Program
Network
Display the claim ID, member ID and sum of line billed amounts for members enrolled in the “Medi-Cal” program in the “HIL” network where the service code begins with “G”