SAIF.Data database tables

This page catalogs the 141 database tables accessed by this library's query providers via NHibernate LINQ (saif-data-db-analysis.md). All access is ORM-based; there are no raw SQL statements or stored procedures**.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
ADDRESS_VERIFICATION_REQUEST	Oracle*	[unqualified]**	R	Accessed by AddressVerificationQueryProvider	AddressVerificationQueryProvider
ADP_EMPLOYEE	Unknown**	Unknown**	R	Accessed by LegalQueryProvider	LegalQueryProvider
APPEAL	Oracle*	[unqualified]**	R	Accessed by LegalQueryProvider	LegalQueryProvider
ATTENDING_PHYSICIAN	Oracle*	[unqualified]**	R	Accessed by ReportQueryProvider	ReportQueryProvider
ATTORNEY_PROFILE	Oracle*	[unqualified]**	R	Accessed by LegalQueryProvider	LegalQueryProvider
Agency	Oracle*	[unqualified]**	CR	Accessed by PolicyExtensions	PolicyExtensions
Agent	Oracle*	[unqualified]**	CR	Accessed by PolicyExtensions, PolicyOutputDocumentExtensions	PolicyExtensions, PolicyOutputDocumentExtensions
App_Error	Oracle*	[unqualified]**	R	Accessed by OnlineSupportExtensions	OnlineSupportExtensions
BUSINESS	Oracle*	[unqualified]**	R	Accessed by PolicyQueryProvider	PolicyQueryProvider
CASE_COST	Oracle*	[unqualified]**	R	Accessed by LegalQueryProvider	LegalQueryProvider
CASE_STATUS_CODE	Oracle*	[unqualified]**	R	Accessed by LegalQueryProvider	LegalQueryProvider
CBP_AUDIT	Oracle*	[unqualified]**	R	Accessed by AuditQueryProvider, BillQueryProvider, EbillEobQueryProvider	AuditQueryProvider, BillQueryProvider, EbillEobQueryProvider
CBP_AUDITED_SERVICE	Oracle*	[unqualified]**	R	Accessed by AuditQueryProvider, BillQueryProvider	AuditQueryProvider, BillQueryProvider
CBP_AUDIT_ADJUSTMENT_TYPE	Oracle*	[unqualified]**	R	Accessed by AuditQueryProvider	AuditQueryProvider
CBP_BILL	Oracle*	[unqualified]**	R	Accessed by AuditQueryProvider, BillQueryProvider, EbillEobQueryProvider, EbillQueryProvider, ProviderQueryProvider	AuditQueryProvider, BillQueryProvider, EbillEobQueryProvider, EbillQueryProvider, ProviderQueryProvider
CBP_BILL_ENTRY_SOURCE_CODE	Oracle*	[unqualified]**	R	Accessed by BillQueryProvider	BillQueryProvider
CBP_BILL_STATUS	Oracle*	[unqualified]**	R	Accessed by BillQueryProvider	BillQueryProvider
CBP_BILL_STATUS_CODE	Oracle*	[unqualified]**	R	Accessed by BillQueryProvider	BillQueryProvider
CBP_BILL_TYPE_CODE	Oracle*	[unqualified]**	R	Accessed by BillQueryProvider	BillQueryProvider
CBP_CPT_SERVICE	Oracle*	[unqualified]**	R	Accessed by ServiceCodeMaintenanceQueryProvider	ServiceCodeMaintenanceQueryProvider
CBP_DIAGNOSIS	Oracle*	[unqualified]**	R	Accessed by BillQueryProvider	BillQueryProvider
CBP_DIAGNOSIS_TYPE_CODE	Oracle*	[unqualified]**	R	Accessed by BillQueryProvider	BillQueryProvider
CBP_NATIONAL_DRUG	Oracle*	[unqualified]**	R	Accessed by AuditQueryProvider, BillQueryProvider	AuditQueryProvider, BillQueryProvider
CBP_NOTE	Oracle*	[unqualified]**	R	Accessed by AuditNoteQueryProvider	AuditNoteQueryProvider
CBP_NOTE_CATEGORY_CODE	Oracle*	[unqualified]**	R	Accessed by AuditNoteQueryProvider	AuditNoteQueryProvider
CBP_NOTE_TYPE_CODE	Oracle*	[unqualified]**	R	Accessed by AuditNoteQueryProvider	AuditNoteQueryProvider
CBP_PROCEDURE_CODE	Oracle*	[unqualified]**	R	Accessed by BillQueryProvider, ServiceCodeQueryProvider	BillQueryProvider, ServiceCodeQueryProvider
CBP_SERVICE_CODE	Oracle*	[unqualified]**	R	Accessed by AuditQueryProvider, BillQueryProvider, ServiceCodeMaintenanceQueryProvider, ServiceCodeQueryProvider	AuditQueryProvider, BillQueryProvider, ServiceCodeMaintenanceQueryProvider, ServiceCodeQueryProvider
CBP_SERVICE_DESCRIPTION	Oracle*	[unqualified]**	R	Accessed by BillQueryProvider, ServiceCodeMaintenanceQueryProvider	BillQueryProvider, ServiceCodeMaintenanceQueryProvider
CBP_SERVICE_FEE	Unknown**	Unknown**	R	Accessed by ServiceCodeMaintenanceQueryProvider	ServiceCodeMaintenanceQueryProvider
CBP_SERVICE_PHYSICAL_MEDICINE	Oracle*	[unqualified]**	R	Accessed by AuditQueryProvider	AuditQueryProvider
CBP_SERVICE_TYPE_CODE	Oracle*	[unqualified]**	R	Accessed by BillQueryProvider	BillQueryProvider
CERTIFICATE_HOLDER	Oracle*	[unqualified]**	R	Accessed by CertificateHolderQueryProvider	CertificateHolderQueryProvider
CLAIM_ADDRESS_TYPE_CODE	Oracle*	[unqualified]**	R	Accessed by AddressBuilder, ClaimCodeTableBuilder	AddressBuilder, ClaimCodeTableBuilder
CL_CLAIM_LEGAL_REPRESENTATIVE	Oracle*	[unqualified]**	R	Accessed by ClaimQueryProvider, ReportQueryProvider	ClaimQueryProvider, ReportQueryProvider
CL_CLAIM_PERSON	Oracle*	[unqualified]**	R	Accessed by ClaimQueryProvider	ClaimQueryProvider
CL_CLAIM_PERSON_ADDRESS	Oracle*	[unqualified]**	R	Accessed by ClaimQueryProvider	ClaimQueryProvider
CL_CLAIM_REQUEST_DECISION	Oracle*	[unqualified]**	R	Accessed by ClaimQueryProvider	ClaimQueryProvider
CL_CLAIM_RESPONSIBILITY	Oracle*	[unqualified]**	CR	Accessed by ClaimCodeTableBuilder	ClaimCodeTableBuilder
CL_CLAIM_STATUS_ACTIVITY	Oracle*	[unqualified]**	CR	Accessed by ClaimBuilder, ClaimQueryProvider	ClaimBuilder, ClaimQueryProvider
CL_CLAIM_SUPPORT_ORDER	Oracle*	[unqualified]**	R	Accessed by WorkerQueryProvider	WorkerQueryProvider
CL_CLAIM_TYPE_ACTIVITY	Oracle*	[unqualified]**	C	Accessed by ClaimBuilder	ClaimBuilder
CL_CLAIM_TYPE_CODE	Oracle*	[unqualified]**	R	Accessed by ClaimBuilder, ClaimCodeTableBuilder, ClaimQueryProvider	ClaimBuilder, ClaimCodeTableBuilder, ClaimQueryProvider
CL_INCURRED_COST_HISTORY	Oracle*	[unqualified]**	R	Accessed by ReserveQueryProvider	ReserveQueryProvider
CL_INJURY_CLAIM	Oracle*	[unqualified]**	R	Accessed by ClaimQueryProvider, WorkerQueryProvider	ClaimQueryProvider, WorkerQueryProvider
CL_JURISDICTION_CODE	Oracle*	[unqualified]**	R	Accessed by ClaimCodeTableBuilder	ClaimCodeTableBuilder
CL_MEDICAL_CONDITION	Oracle*	[unqualified]**	R	Accessed by ClaimQueryProvider	ClaimQueryProvider
CL_OVERPAYMENT	Oracle*	[unqualified]**	R	Accessed by OverpaymentQueryProvider	OverpaymentQueryProvider
CL_PAYMENT_SPCL_HANDLING_CODE	Oracle*	[unqualified]**	R	Accessed by ClaimPaymentQueryProvider	ClaimPaymentQueryProvider
CL_PAYMENT_TOTAL	Oracle*	[unqualified]**	R	Accessed by ReserveQueryProvider	ReserveQueryProvider
CL_PHARMACY_DAW_CODE	Oracle*	[unqualified]**	R	Accessed by BillQueryProvider	BillQueryProvider
CL_PHARMACY_ELIGIBILITY_REPORT	Oracle*	[unqualified]**	R	Accessed by ClaimQueryProvider	ClaimQueryProvider
CL_SECURITY_OVERRIDE	Oracle*	[unqualified]**	R	Accessed by ClaimSecurityOverrideProvider	ClaimSecurityOverrideProvider
CONSOLIDATED_CASE	Oracle*	[unqualified]**	R	Accessed by LegalQueryProvider	LegalQueryProvider
CONTACT	Oracle*	[unqualified]**	R	Accessed by LocationQueryProvider	LocationQueryProvider
EAIP_PERIOD	Oracle*	[unqualified]**	R	Accessed by ClaimQueryProvider	ClaimQueryProvider
EBILL	Oracle*	[unqualified]**	R	Accessed by EbillDocumentQueryProvider, EbillEobQueryProvider, EbillQueryProvider, EbillServiceQueryProvider	EbillDocumentQueryProvider, EbillEobQueryProvider, EbillQueryProvider, EbillServiceQueryProvider
EBILL_ADDRESS	Oracle*	[unqualified]**	R	Accessed by EbillAddressQueryProvider	EbillAddressQueryProvider
EBILL_ADDRESS_OVERRIDE	Oracle*	[unqualified]**	R	Accessed by EbillAddressQueryProvider	EbillAddressQueryProvider
EBILL_ADDRESS_TYPE_CODE	Oracle*	[unqualified]**	R	Accessed by EbillAddressQueryProvider, EbillingExtensions	EbillAddressQueryProvider, EbillingExtensions
EBILL_ASSIGNMENT_RULE	Oracle*	[unqualified]**	R	Accessed by EbillQueryProvider	EbillQueryProvider
EBILL_BATCH	Oracle*	[unqualified]**	R	Accessed by EbillBatchQueryProvider, EbillEobQueryProvider, EbillQueryProvider	EbillBatchQueryProvider, EbillEobQueryProvider, EbillQueryProvider
EBILL_BATCH_STATUS_CODE	Oracle*	[unqualified]**	CR	Accessed by EbillBatchQueryProvider, EbillingExtensions	EbillBatchQueryProvider, EbillingExtensions
EBILL_BATCH_TYPE_CODE	Oracle*	[unqualified]**	CR	Accessed by EbillBatchQueryProvider, EbillingExtensions	EbillBatchQueryProvider, EbillingExtensions
EBILL_CLEARINGHOUSE	Oracle*	[unqualified]**	R	Accessed by EbillClearinghouseQueryProvider, EbillingQueryProvider	EbillClearinghouseQueryProvider, EbillingQueryProvider
EBILL_DOCUMENT	Oracle*	[unqualified]**	R	Accessed by EbillDocumentQueryProvider	EbillDocumentQueryProvider
EBILL_DOCUMENT_OVERRIDE	Oracle*	[unqualified]**	R	Accessed by EbillDocumentQueryProvider	EbillDocumentQueryProvider
EBILL_DOCUMENT_TYPE_CODE	Oracle*	[unqualified]**	R	Accessed by EbillDocumentQueryProvider, EbillingExtensions	EbillDocumentQueryProvider, EbillingExtensions
EBILL_EOB	Oracle*	[unqualified]**	R	Accessed by EbillEobQueryProvider	EbillEobQueryProvider
EBILL_ERROR_CONDITION	Oracle*	[unqualified]**	R	Accessed by EbillQueryProvider	EbillQueryProvider
EBILL_HEALTH_INFORMATION	Oracle*	[unqualified]**	R	Accessed by EbillHealthInformationQueryProvider	EbillHealthInformationQueryProvider
EBILL_HEALTH_INFO_TYPE_CODE	Oracle*	[unqualified]**	R	Accessed by EbillHealthInformationQueryProvider	EbillHealthInformationQueryProvider
EBILL_INVOICE	Oracle*	[unqualified]**	R	Accessed by EbillInvoiceQueryProvider	EbillInvoiceQueryProvider
EBILL_INVOICE_BILL	Oracle*	[unqualified]**	R	Accessed by EbillInvoiceQueryProvider	EbillInvoiceQueryProvider
EBILL_INVOICE_ERROR	Oracle*	[unqualified]**	R	Accessed by EbillInvoiceQueryProvider	EbillInvoiceQueryProvider
EBILL_PATIENT	Oracle*	[unqualified]**	R	Accessed by EbillPatientQueryProvider, EbillQueryProvider	EbillPatientQueryProvider, EbillQueryProvider
EBILL_PROVIDER	Oracle*	[unqualified]**	R	Accessed by EbillPatientQueryProvider, EbillProviderQueryProvider, EbillQueryProvider	EbillPatientQueryProvider, EbillProviderQueryProvider, EbillQueryProvider
EBILL_RESPONSE_SET	Oracle*	[unqualified]**	R	Accessed by EbillQueryProvider	EbillQueryProvider
EBILL_SERVICE	Oracle*	[unqualified]**	RU	Accessed by EbillQueryProvider, EbillServiceQueryProvider	EbillQueryProvider, EbillServiceQueryProvider
EBILL_SET_TYPE_CODE	Oracle*	[unqualified]**	CR	Accessed by EbillQueryProvider, EbillingExtensions	EbillQueryProvider, EbillingExtensions
EBILL_STATUS_CODE	Oracle*	[unqualified]**	CR	Accessed by EbillQueryProvider, EbillingExtensions	EbillQueryProvider, EbillingExtensions
EDI_BILL	Oracle*	[unqualified]**	R	Accessed by EdiQueryProvider	EdiQueryProvider
EDI_BILL_REPORT	Oracle*	[unqualified]**	R	Accessed by EdiQueryProvider	EdiQueryProvider
EDI_PLACE_OF_SERVICE_CODE	Oracle*	[unqualified]**	R	Accessed by EbillQueryProvider	EbillQueryProvider
ENDORSE_CODE	Oracle*	[unqualified]**	R	Accessed by PolicyOutputDocumentExtensions	PolicyOutputDocumentExtensions
ERROR_ENVIRONMENT	Oracle*	[unqualified]**	R	Accessed by OnlineSupportExtensions	OnlineSupportExtensions
ERROR_GROUP_CODE	Oracle*	[unqualified]**	R	Accessed by OnlineSupportExtensions	OnlineSupportExtensions
ERROR_GROUP_ENVIRONMENT	Oracle*	[unqualified]**	C	Accessed by OnlineSupportExtensions	OnlineSupportExtensions
IMAGE_AFFILIATION	Oracle*	Unknown**	R	Accessed by ImageQueryProvider	ImageQueryProvider
IMGSYS	Oracle*	Unknown**	R	Accessed by ImageQueryProvider	ImageQueryProvider
IcdVersionCode	Unknown**	Unknown**	R	Accessed by BillQueryProvider	BillQueryProvider
LEGAL_BILL	Oracle*	[unqualified]**	R	Accessed by LegalQueryProvider	LegalQueryProvider
LEGAL_CASE	Oracle*	[unqualified]**	R	Accessed by ImageQueryProvider, LegalQueryProvider	ImageQueryProvider, LegalQueryProvider
LEGAL_PERSON	Oracle*	[unqualified]**	R	Accessed by LegalQueryProvider	LegalQueryProvider
LEGAL_PERSON_ADDRESS	Oracle*	[unqualified]**	R	Accessed by LegalQueryProvider	LegalQueryProvider
LOCATION	Oracle*	[unqualified]**	R	Accessed by LocationQueryProvider	LocationQueryProvider
LOCATION_VERIFICATION_REQUEST	Oracle*	[unqualified]**	R	Accessed by AddressVerificationQueryProvider	AddressVerificationQueryProvider
LPT_CLAIM_CROSS_REFERENCE	Oracle*	[unqualified]**	R	Accessed by ClaimQueryProvider	ClaimQueryProvider
MARKET_TYPE_CODE	Oracle*	[unqualified]**	R	Accessed by PolicyExtensions	PolicyExtensions
MCO_PROVIDER	Oracle*	[unqualified]**	R	Accessed by ProviderQueryProvider	ProviderQueryProvider
MEDICARE_BENEFICIARY_QUERY	Oracle*	[unqualified]**	R	Accessed by MedicareQueryProvider	MedicareQueryProvider
MEDICARE_BENEFICIARY_QUERY_BAT	Oracle*	[unqualified]**	R	Accessed by MedicareQueryProvider	MedicareQueryProvider
MEDICARE_QUERY_HISTORY	Oracle*	[unqualified]**	R	Accessed by MedicareQueryProvider	MedicareQueryProvider
NON_EMPR_ACCT	Oracle*	[unqualified]**	R	Accessed by PolicyQueryProvider	PolicyQueryProvider
OFFICE_CODE	Oracle*	[unqualified]**	CR	Accessed by LocationQueryProvider, PolicyExtensions	LocationQueryProvider, PolicyExtensions
OTHER_FIRM	Oracle*	[unqualified]**	R	Accessed by LegalQueryProvider	LegalQueryProvider
PAYMENT_TRANSACTION_STAT	Oracle*	[unqualified]**	R	Accessed by PaymentsQueryProvider	PaymentsQueryProvider
PAYMENT_TRANSACTION_TYPE_CODE	Oracle*	[unqualified]**	R	Accessed by PaymentsQueryProvider	PaymentsQueryProvider
POLICY	Oracle*	[unqualified]**	CRU	Accessed by OutputDocumentQueryProvider, PolicyQueryProvider, ClaimBuilder, PolicyExtensions, PolicyOutputDocumentExtensions	OutputDocumentQueryProvider, PolicyQueryProvider, ClaimBuilder, PolicyExtensions, PolicyOutputDocumentExtensions
POLICY_PERIOD_GROUP_ASSOC	Oracle*	[unqualified]**	R	Accessed by PolicyQueryProvider	PolicyQueryProvider
POLICY_PERIOD_PAYROLL_AUDIT	Oracle*	[unqualified]**	R	Accessed by PolicyQueryProvider	PolicyQueryProvider
POLICY_RELATIONSHIP_CODE	Oracle*	[unqualified]**	R	Accessed by PolicyExtensions	PolicyExtensions
POLICY_TEAM_FUNCTION	Oracle*	[unqualified]**	CR	Accessed by PolicyExtensions, PolicyQueryProvider	PolicyExtensions, PolicyQueryProvider
PROVIDER	Oracle*	[unqualified]**	R	Accessed by ProviderQueryProvider	ProviderQueryProvider
PROVIDER_ADDRESS	Oracle*	[unqualified]**	R	Accessed by ProviderQueryProvider	ProviderQueryProvider
PROVIDER_IDENTITY	Oracle*	[unqualified]**	R	Accessed by ProviderQueryProvider	ProviderQueryProvider
PROVIDER_LOCATION	Oracle*	[unqualified]**	R	Accessed by ClaimQueryProvider, ProviderQueryProvider	ClaimQueryProvider, ProviderQueryProvider
PROVIDER_RELATIONSHIP	Oracle*	[unqualified]**	R	Accessed by ProviderQueryProvider	ProviderQueryProvider
PROVIDER_TAX_ID	Oracle*	[unqualified]**	R	Accessed by ProviderQueryProvider	ProviderQueryProvider
RTW_CASE	Oracle*	[unqualified]**	R	Accessed by ClaimQueryProvider	ClaimQueryProvider
SUBPOENA	Oracle*	[unqualified]**	R	Accessed by LegalQueryProvider	LegalQueryProvider
TASK	Oracle*	[unqualified]**	R	Accessed by TaskQueryProvider	TaskQueryProvider
TASK_ACTION_CODE	Oracle*	[unqualified]**	R	Accessed by TaskExtensions, TaskQueryProvider	TaskExtensions, TaskQueryProvider
TASK_CATEGORY_CODE	Oracle*	[unqualified]**	CR	Accessed by TaskExtensions, TaskQueryProvider	TaskExtensions, TaskQueryProvider
TASK_PRIORITY_CODE	Oracle*	[unqualified]**	R	Accessed by TaskExtensions, TaskQueryProvider	TaskExtensions, TaskQueryProvider
TASK_SOURCE_CODE	Oracle*	[unqualified]**	R	Accessed by TaskExtensions, TaskQueryProvider	TaskExtensions, TaskQueryProvider
THRDPARTY_CASE	Oracle*	[unqualified]**	R	Accessed by ClaimQueryProvider	ClaimQueryProvider
VERIFIED_ADDRESS	Oracle*	[unqualified]**	R	Accessed by AddressVerificationQueryProvider	AddressVerificationQueryProvider
WCIS_Employee	Oracle*	Unknown**	R	Accessed by EmployeeQueryProvider	EmployeeQueryProvider
batch_process_log	Oracle*	[unqualified]**	CR	Accessed by OutputDocumentQueryProvider, PolicyOutputDocumentExtensions	OutputDocumentQueryProvider, PolicyOutputDocumentExtensions
cl_pref_contact_method_code	Oracle*	[unqualified]**	R	Accessed by WorkerQueryProvider	WorkerQueryProvider
claim_status_code	Oracle*	[unqualified]**	R	Accessed by ClaimBuilder, ClaimCodeTableBuilder, ClaimQueryProvider	ClaimBuilder, ClaimCodeTableBuilder, ClaimQueryProvider
document_status_code	Oracle*	[unqualified]**	R	Accessed by OutputDocumentQueryProvider, PolicyOutputDocumentExtensions	OutputDocumentQueryProvider, PolicyOutputDocumentExtensions
image	Oracle*	Unknown**	R	Accessed by ImageQueryProvider	ImageQueryProvider
image_category_code	Oracle*	[unqualified]**	CR	Accessed by PolicyOutputDocumentExtensions	PolicyOutputDocumentExtensions
image_document_type_code	Oracle*	[unqualified]**	CR	Accessed by ImageQueryProvider, PolicyOutputDocumentExtensions	ImageQueryProvider, PolicyOutputDocumentExtensions
output_doc_notify_text_code	Oracle*	[unqualified]**	CR	Accessed by PolicyOutputDocumentExtensions	PolicyOutputDocumentExtensions
output_document	Oracle*	[unqualified]**	C	Accessed by PolicyOutputDocumentExtensions	PolicyOutputDocumentExtensions
output_document_category_code	Oracle*	[unqualified]**	CR	Accessed by OutputDocumentQueryProvider, PolicyOutputDocumentExtensions	OutputDocumentQueryProvider, PolicyOutputDocumentExtensions
output_document_type_code	Oracle*	[unqualified]**	CR	Accessed by OutputDocumentQueryProvider, PolicyOutputDocumentExtensions	OutputDocumentQueryProvider, PolicyOutputDocumentExtensions
policy_output_document	Oracle*	[unqualified]**	CR	Accessed by OutputDocumentQueryProvider, PolicyOutputDocumentExtensions	OutputDocumentQueryProvider, PolicyOutputDocumentExtensions

ADDRESS_VERIFICATION_REQUEST

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AddressVerificationQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped ADDR_VERIFICATION_REQ_SEQ; no insert in this library)
Related tables	LOCATION_VERIFICATION_REQUEST, VERIFIED_ADDRESS
Business objects	AddressVerificationQueryProvider

Operations referencing ADDRESS_VERIFICATION_REQUEST

• Other query providers

SQL referencing ADDRESS_VERIFICATION_REQUEST

• SQL-001: GetRepository<LocationVerificationRequest>().Query()
• SQL-002: GetRepository<AddressVerificationRequest>().Query()

---

ADP_EMPLOYEE

Field	Value
Database	Unknown**
Schema/Link	Unknown**
Purpose	Accessed by LegalQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	LegalQueryProvider

SQL referencing ADP_EMPLOYEE

• SQL-159: GetRepository<EmployeeData.Employee>().Query()

---

APPEAL

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LegalQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped APPEAL_SEQ; no insert in this library)
Related tables	LEGAL_CASE
Business objects	LegalQueryProvider

Operations referencing APPEAL

• Legal case queries

Business rules referencing APPEAL

• SD-BR-060 Case-to-claim resolution precedence
• SD-BR-061 Preferred employee name takes precedence

SQL referencing APPEAL

• SQL-158: GetRepository<Appeal>().Query()

---

ATTENDING_PHYSICIAN

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ReportQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped ATTENDING_PHYSICIAN_SEQ; no insert in this library)
Related tables	CL_INJURY_CLAIM, PROVIDER_LOCATION
Business objects	ReportQueryProvider

Operations referencing ATTENDING_PHYSICIAN

• Other query providers

Business rules referencing ATTENDING_PHYSICIAN

• SD-BR-093 Active report record has a null expiration date

SQL referencing ATTENDING_PHYSICIAN

• SQL-218: GetRepository<AttendingPhysician>().Query()
• SQL-220: GetRepository<AttendingPhysician>().Query()

---

ATTORNEY_PROFILE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LegalQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	LegalQueryProvider

Operations referencing ATTORNEY_PROFILE

• Legal case queries

Business rules referencing ATTORNEY_PROFILE

• SD-BR-060 Case-to-claim resolution precedence
• SD-BR-061 Preferred employee name takes precedence

SQL referencing ATTORNEY_PROFILE

• SQL-161: GetRepository<AttorneyProfile>().Query()

---

Agency

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	agency_seq
Related tables	Agent
Business objects	PolicyExtensions

SQL referencing Agency

• SQL-246: GetRepository<Agency>().Add(entity)
• SQL-280: GetRepository<Agency>().Query()

---

Agent

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyExtensions, PolicyOutputDocumentExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	Agency, POLICY
Business objects	PolicyExtensions, PolicyOutputDocumentExtensions

SQL referencing Agent

• SQL-247: GetRepository<Agent>().Add(entity)
• SQL-286: GetRepository<Policy>().Query()
• SQL-287: GetRepository<Policy>().Query()

---

App_Error

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by OnlineSupportExtensions for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	OnlineSupportExtensions

SQL referencing App_Error

• SQL-276: GetRepository<ErrorLog>().Query()

---

BUSINESS

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	PolicyQueryProvider

Operations referencing BUSINESS

• Other query providers

SQL referencing BUSINESS

• SQL-197: GetRepository<Business>().Query()

---

CASE_COST

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LegalQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped CASE_COST_SEQ; no insert in this library)
Related tables	LEGAL_CASE
Business objects	LegalQueryProvider

Operations referencing CASE_COST

• Legal case queries

Business rules referencing CASE_COST

• SD-BR-060 Case-to-claim resolution precedence
• SD-BR-061 Preferred employee name takes precedence

SQL referencing CASE_COST

• SQL-155: GetRepository<CaseCost>().Query()

---

CASE_STATUS_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LegalQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	LEGAL_CASE
Business objects	LegalQueryProvider

Operations referencing CASE_STATUS_CODE

• Legal case queries

Business rules referencing CASE_STATUS_CODE

• SD-BR-060 Case-to-claim resolution precedence
• SD-BR-061 Preferred employee name takes precedence

SQL referencing CASE_STATUS_CODE

• SQL-160: GetRepository<LegalCase>().Query()

---

CBP_AUDIT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AuditQueryProvider, BillQueryProvider, EbillEobQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	CBP_AUDITED_SERVICE, CBP_BILL
Business objects	AuditQueryProvider, BillQueryProvider, EbillEobQueryProvider

Operations referencing CBP_AUDIT

• Bill audit evaluation
• E-bill processing queries

Business rules referencing CBP_AUDIT

• SD-BR-030 Nurse review required if any audited service code flags it
• SD-BR-031 Duplicate services excluded from count
• SD-BR-032 Unset thru-date treated as open-ended
• SD-BR-054 Zero-pay EOB candidate criteria

SQL referencing CBP_AUDIT

• SQL-013: GetRepository<CbpAudit>().Query()
• SQL-014: GetRepository<CbpAudit>().Query()
• SQL-017: GetRepository<CbpAuditedService>().Query()
• SQL-018: GetRepository<CbpAuditedService>().Query()
• SQL-019: GetRepository<CbpAuditedService>().Query()
• SQL-020: GetRepository<CbpAuditedService>().Query()
• SQL-032: GetRepository<CbpBill>().Query()
• SQL-033: GetRepository<CbpBill>().Query()
• SQL-100: GetRepository<Ebill>().Query()
• SQL-101: GetRepository<Ebill>().Query()

---

CBP_AUDITED_SERVICE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AuditQueryProvider, BillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	CBP_AUDIT, CBP_BILL
Business objects	AuditQueryProvider, BillQueryProvider

Operations referencing CBP_AUDITED_SERVICE

• Bill audit evaluation
• Bill queries

Business rules referencing CBP_AUDITED_SERVICE

• SD-BR-030 Nurse review required if any audited service code flags it
• SD-BR-031 Duplicate services excluded from count
• SD-BR-032 Unset thru-date treated as open-ended
• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing CBP_AUDITED_SERVICE

• SQL-017: GetRepository<CbpAuditedService>().Query()
• SQL-018: GetRepository<CbpAuditedService>().Query()
• SQL-019: GetRepository<CbpAuditedService>().Query()
• SQL-020: GetRepository<CbpAuditedService>().Query()
• SQL-021: GetRepository<CbpAuditedService>().Query()
• SQL-022: GetRepository<CbpServicePhysicalMedicine>().Query()
• SQL-032: GetRepository<CbpBill>().Query()
• SQL-033: GetRepository<CbpAuditedService>().Query()

---

CBP_AUDIT_ADJUSTMENT_TYPE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AuditQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	AuditQueryProvider

Operations referencing CBP_AUDIT_ADJUSTMENT_TYPE

• Bill audit evaluation

Business rules referencing CBP_AUDIT_ADJUSTMENT_TYPE

• SD-BR-030 Nurse review required if any audited service code flags it
• SD-BR-031 Duplicate services excluded from count
• SD-BR-032 Unset thru-date treated as open-ended

SQL referencing CBP_AUDIT_ADJUSTMENT_TYPE

• SQL-023: GetRepository<CbpAuditAdjustmentType>().Query()

---

CBP_BILL

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AuditQueryProvider, BillQueryProvider, EbillEobQueryProvider, EbillQueryProvider, ProviderQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped CBP_BILL_SEQ; no insert in this library)
Related tables	CBP_AUDIT, CBP_AUDITED_SERVICE, CBP_BILL_STATUS, CBP_NOTE, EBILL, CBP_BILL_STATUS_CODE, PROVIDER_LOCATION
Business objects	AuditQueryProvider, BillQueryProvider, EbillEobQueryProvider, EbillQueryProvider, ProviderQueryProvider

Operations referencing CBP_BILL

• Bill audit evaluation
• Audit note concurrency check
• Bill queries
• E-bill processing queries
• Provider queries

Business rules referencing CBP_BILL

• SD-BR-030 Nurse review required if any audited service code flags it
• SD-BR-031 Duplicate services excluded from count
• SD-BR-032 Unset thru-date treated as open-ended
• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null
• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug
• SD-BR-054 Zero-pay EOB candidate criteria
• SD-BR-080 Provider identity relationship and address code sets
• SD-BR-082 Dismissed bills excluded from provider location ids
• SD-BR-083 Provider in MCO only within date window

SQL referencing CBP_BILL

• SQL-019: GetRepository<CbpAuditedService>().Query()
• SQL-021: GetRepository<CbpAuditedService>().Query()
• SQL-022: GetRepository<CbpServicePhysicalMedicine>().Query()
• SQL-024: GetRepository<CbpBill>().Query()
• SQL-025: GetRepository<CbpBill>().Query()
• SQL-026: GetRepository<CbpBill>().Query()
• SQL-027: GetRepository<CbpBill>().Query()
• SQL-032: GetRepository<CbpBill>().Query()
• SQL-033: GetRepository<CbpBill>().Query()
• SQL-100: GetRepository<Ebill>().Query()
• SQL-101: GetRepository<Ebill>().Query()
• SQL-117: GetRepository<Ebill>().Query()
• SQL-210: GetRepository<CbpBill>().Query()

---

CBP_BILL_ENTRY_SOURCE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by BillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	BillQueryProvider

Operations referencing CBP_BILL_ENTRY_SOURCE_CODE

• Bill queries

Business rules referencing CBP_BILL_ENTRY_SOURCE_CODE

• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing CBP_BILL_ENTRY_SOURCE_CODE

• SQL-031: GetRepository<CbpBillEntrySourceCode>().Query()
• SQL-037: GetRepository<CbpBillEntrySourceCode>().Query()

---

CBP_BILL_STATUS

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by BillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped BILL_STATUS_SEQ; no insert in this library)
Related tables	CBP_BILL
Business objects	BillQueryProvider

Operations referencing CBP_BILL_STATUS

• Bill queries

Business rules referencing CBP_BILL_STATUS

• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing CBP_BILL_STATUS

• SQL-030: GetRepository<CbpBillStatus>().Query()

---

CBP_BILL_STATUS_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by BillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	CBP_BILL
Business objects	BillQueryProvider

Operations referencing CBP_BILL_STATUS_CODE

• Bill queries
• E-bill processing queries
• Provider queries

Business rules referencing CBP_BILL_STATUS_CODE

• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null
• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug
• SD-BR-054 Zero-pay EOB candidate criteria
• SD-BR-080 Provider identity relationship and address code sets
• SD-BR-082 Dismissed bills excluded from provider location ids
• SD-BR-083 Provider in MCO only within date window

SQL referencing CBP_BILL_STATUS_CODE

• SQL-029: GetRepository<CbpBillStatusCode>().Query()

---

CBP_BILL_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by BillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	BillQueryProvider

Operations referencing CBP_BILL_TYPE_CODE

• Bill queries

Business rules referencing CBP_BILL_TYPE_CODE

• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing CBP_BILL_TYPE_CODE

• SQL-028: GetRepository<CbpBillTypeCode>().Query()
• SQL-038: GetRepository<CbpBillTypeCode>().Query()

---

CBP_CPT_SERVICE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ServiceCodeMaintenanceQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	CBP_SERVICE_CODE
Business objects	ServiceCodeMaintenanceQueryProvider

Operations referencing CBP_CPT_SERVICE

• Other query providers

SQL referencing CBP_CPT_SERVICE

• SQL-225: GetRepository<CbpCptService>().Query()

---

CBP_DIAGNOSIS

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by BillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	BillQueryProvider

Operations referencing CBP_DIAGNOSIS

• Bill queries

Business rules referencing CBP_DIAGNOSIS

• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing CBP_DIAGNOSIS

• SQL-034: GetRepository<CbpDiagnosis>().Query()
• SQL-035: GetRepository<CbpDiagnosis>().Query()

---

CBP_DIAGNOSIS_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by BillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	BillQueryProvider

Operations referencing CBP_DIAGNOSIS_TYPE_CODE

• Bill queries

Business rules referencing CBP_DIAGNOSIS_TYPE_CODE

• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing CBP_DIAGNOSIS_TYPE_CODE

• SQL-036: GetRepository<CbpDiagnosisTypeCode>().Query()

---

CBP_NATIONAL_DRUG

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AuditQueryProvider, BillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	AuditQueryProvider, BillQueryProvider

Operations referencing CBP_NATIONAL_DRUG

• Bill audit evaluation
• Bill queries

Business rules referencing CBP_NATIONAL_DRUG

• SD-BR-030 Nurse review required if any audited service code flags it
• SD-BR-031 Duplicate services excluded from count
• SD-BR-032 Unset thru-date treated as open-ended
• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing CBP_NATIONAL_DRUG

• SQL-015: GetRepository<CbpNationalDrug>().Query()
• SQL-047: GetRepository<CbpNationalDrug>().Query()

---

CBP_NOTE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AuditNoteQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped CBP_NOTE_SEQ; no insert in this library)
Related tables	CBP_BILL
Business objects	AuditNoteQueryProvider

Operations referencing CBP_NOTE

• Audit note concurrency check

Business rules referencing CBP_NOTE

• SD-BR-033 Audit note save allowed only under optimistic concurrency match

SQL referencing CBP_NOTE

• SQL-004: GetRepository<CbpNote>().Query()
• SQL-005: GetRepository<CbpNote>().Query()
• SQL-006: GetRepository<CbpNote>().Query()
• SQL-007: GetRepository<CbpNote>().Query()
• SQL-012: GetRepository<CbpNote>().Query()

---

CBP_NOTE_CATEGORY_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AuditNoteQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	CBP_NOTE_TYPE_CODE
Business objects	AuditNoteQueryProvider

Operations referencing CBP_NOTE_CATEGORY_CODE

• Audit note concurrency check

SQL referencing CBP_NOTE_CATEGORY_CODE

• SQL-009: GetRepository<CbpNoteCategoryCode>().Query()

---

CBP_NOTE_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AuditNoteQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	CBP_NOTE_CATEGORY_CODE
Business objects	AuditNoteQueryProvider

Operations referencing CBP_NOTE_TYPE_CODE

• Audit note concurrency check

SQL referencing CBP_NOTE_TYPE_CODE

• SQL-008: GetRepository<CbpNoteTypeCode>().Query()
• SQL-010: GetRepository<CbpNoteTypeCode>().Query()
• SQL-011: GetRepository<CbpNoteTypeCode>().Query()

---

CBP_PROCEDURE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by BillQueryProvider, ServiceCodeQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	BillQueryProvider, ServiceCodeQueryProvider

Operations referencing CBP_PROCEDURE_CODE

• Bill queries
• Other query providers

Business rules referencing CBP_PROCEDURE_CODE

• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing CBP_PROCEDURE_CODE

• SQL-049: GetRepository<CbpProcedureCode>().Query()
• SQL-230: GetRepository<CbpProcedureCode>().Query()

---

CBP_SERVICE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AuditQueryProvider, BillQueryProvider, ServiceCodeMaintenanceQueryProvider, ServiceCodeQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	CBP_CPT_SERVICE, CBP_SERVICE_DESCRIPTION, CBP_SERVICE_TYPE_CODE
Business objects	AuditQueryProvider, BillQueryProvider, ServiceCodeMaintenanceQueryProvider, ServiceCodeQueryProvider

Operations referencing CBP_SERVICE_CODE

• Bill audit evaluation
• Bill queries
• Other query providers

Business rules referencing CBP_SERVICE_CODE

• SD-BR-030 Nurse review required if any audited service code flags it
• SD-BR-031 Duplicate services excluded from count
• SD-BR-032 Unset thru-date treated as open-ended
• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing CBP_SERVICE_CODE

• SQL-016: GetRepository<CbpServiceCode>().Query()
• SQL-039: GetRepository<CbpServiceCode>().Query()
• SQL-040: GetRepository<CbpServiceCode>().Query()
• SQL-041: GetRepository<CbpServiceCode>().Query()
• SQL-045: GetRepository<CbpServiceCode>().Query()
• SQL-046: GetRepository<CbpServiceCodeStateless>().Query()
• SQL-228: GetRepository<CbpServiceCode>().Query()
• SQL-229: GetRepository<CbpServiceCode>().Query()

---

CBP_SERVICE_DESCRIPTION

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by BillQueryProvider, ServiceCodeMaintenanceQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	CBP_SERVICE_CODE
Business objects	BillQueryProvider, ServiceCodeMaintenanceQueryProvider

Operations referencing CBP_SERVICE_DESCRIPTION

• Bill queries
• Other query providers

Business rules referencing CBP_SERVICE_DESCRIPTION

• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing CBP_SERVICE_DESCRIPTION

• SQL-042: GetRepository<CbpServiceDescription>().Query()
• SQL-043: GetRepository<CbpServiceDescriptionStateless>().Query()
• SQL-226: GetRepository<CbpServiceDescription>().Query()

---

CBP_SERVICE_FEE

Field	Value
Database	Unknown**
Schema/Link	Unknown**
Purpose	Accessed by ServiceCodeMaintenanceQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ServiceCodeMaintenanceQueryProvider

SQL referencing CBP_SERVICE_FEE

• SQL-227: GetRepository<CbpServiceFee>().Query()

---

CBP_SERVICE_PHYSICAL_MEDICINE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AuditQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	AuditQueryProvider

Operations referencing CBP_SERVICE_PHYSICAL_MEDICINE

• Bill audit evaluation

Business rules referencing CBP_SERVICE_PHYSICAL_MEDICINE

• SD-BR-030 Nurse review required if any audited service code flags it
• SD-BR-031 Duplicate services excluded from count
• SD-BR-032 Unset thru-date treated as open-ended

SQL referencing CBP_SERVICE_PHYSICAL_MEDICINE

• SQL-021: GetRepository<CbpAuditedService>().Query()
• SQL-022: GetRepository<CbpServicePhysicalMedicine>().Query()

---

CBP_SERVICE_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by BillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	CBP_SERVICE_CODE
Business objects	BillQueryProvider

Operations referencing CBP_SERVICE_TYPE_CODE

• Bill queries
• Other query providers

Business rules referencing CBP_SERVICE_TYPE_CODE

• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing CBP_SERVICE_TYPE_CODE

• SQL-044: GetRepository<CbpServiceTypeCode>().Query()

---

CERTIFICATE_HOLDER

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by CertificateHolderQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped CERT_HOLD_SEQUENCE; no insert in this library)
Related tables	None identified
Business objects	CertificateHolderQueryProvider

Operations referencing CERTIFICATE_HOLDER

• Other query providers

Business rules referencing CERTIFICATE_HOLDER

• SD-BR-090 Superseded certificate holders excluded from search

SQL referencing CERTIFICATE_HOLDER

• SQL-051: GetRepository<CertificateHolder>().Query()
• SQL-052: GetRepository<CertificateHolder>().Query()
• SQL-053: GetRepository<CertificateHolder>().Query()

---

CLAIM_ADDRESS_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AddressBuilder, ClaimCodeTableBuilder for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	AddressBuilder, ClaimCodeTableBuilder

SQL referencing CLAIM_ADDRESS_TYPE_CODE

• SQL-255: GetRepository<ClaimAddressTypeCode>().Query()
• SQL-264: GetRepository<ClaimAddressTypeCode>().Query()

---

CL_CLAIM_LEGAL_REPRESENTATIVE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimQueryProvider, ReportQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	PROVIDER_LOCATION
Business objects	ClaimQueryProvider, ReportQueryProvider

Operations referencing CL_CLAIM_LEGAL_REPRESENTATIVE

• Claim status and compensability
• Other query providers

Business rules referencing CL_CLAIM_LEGAL_REPRESENTATIVE

• SD-BR-093 Active report record has a null expiration date

SQL referencing CL_CLAIM_LEGAL_REPRESENTATIVE

• SQL-064: GetRepository<ClaimLegalRepresentative>().Query()
• SQL-219: GetRepository<ClaimLegalRepresentative>().Query()
• SQL-221: GetRepository<ClaimLegalRepresentative>().Query()

---

CL_CLAIM_PERSON

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	CL_CLAIM_SUPPORT_ORDER, CL_INJURY_CLAIM, CL_OVERPAYMENT
Business objects	ClaimQueryProvider

Operations referencing CL_CLAIM_PERSON

• Recoverable overpayment balance
• Claim data-quality queries
• Other query providers

Business rules referencing CL_CLAIM_PERSON

• SD-BR-021 Recoverable balance sums outstanding amount for non-amended overpayments
• SD-BR-049 Missing tax id identified by a single space
• SD-BR-092 Active support order has no termination date

SQL referencing CL_CLAIM_PERSON

• SQL-060: GetRepository<InjuryClaim>().Query()

---

CL_CLAIM_PERSON_ADDRESS

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ClaimQueryProvider

Operations referencing CL_CLAIM_PERSON_ADDRESS

• Claim status and compensability

SQL referencing CL_CLAIM_PERSON_ADDRESS

• SQL-059: GetRepository<ClaimPersonAddress>().Query()

---

CL_CLAIM_REQUEST_DECISION

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ClaimQueryProvider

Operations referencing CL_CLAIM_REQUEST_DECISION

• Claim status and compensability

Business rules referencing CL_CLAIM_REQUEST_DECISION

• SD-BR-041 Latest claim status falls back to WCD status when no history
• SD-BR-042 Compensability status mapping
• SD-BR-043 Original acceptance requires request type I with decision A

SQL referencing CL_CLAIM_REQUEST_DECISION

• SQL-062: GetRepository<ClaimRequestDecision>().Query()
• SQL-063: GetRepository<ClaimRequestDecision>().Query()

---

CL_CLAIM_RESPONSIBILITY

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimCodeTableBuilder for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ClaimCodeTableBuilder

SQL referencing CL_CLAIM_RESPONSIBILITY

• SQL-244: GetRepository<ClaimResponsibility>().Add(entity)
• SQL-265: GetRepository<ClaimResponsibility>().Query()

---

CL_CLAIM_STATUS_ACTIVITY

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimBuilder, ClaimQueryProvider for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ClaimBuilder, ClaimQueryProvider

Operations referencing CL_CLAIM_STATUS_ACTIVITY

• Claim status and compensability

Business rules referencing CL_CLAIM_STATUS_ACTIVITY

• SD-BR-041 Latest claim status falls back to WCD status when no history
• SD-BR-042 Compensability status mapping
• SD-BR-043 Original acceptance requires request type I with decision A

SQL referencing CL_CLAIM_STATUS_ACTIVITY

• SQL-058: GetRepository<ClaimStatusActivity>().Query()
• SQL-061: GetRepository<ClaimStatusActivity>().Query()
• SQL-242: GetRepository<ClaimStatusActivity>().Add(entity)
• SQL-259: GetRepository<ClaimStatusActivity>().Query()

---

CL_CLAIM_SUPPORT_ORDER

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by WorkerQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped SUPPORT_ORDER_ID_SEQ; no insert in this library)
Related tables	CL_CLAIM_PERSON
Business objects	WorkerQueryProvider

Operations referencing CL_CLAIM_SUPPORT_ORDER

• Other query providers

Business rules referencing CL_CLAIM_SUPPORT_ORDER

• SD-BR-092 Active support order has no termination date

SQL referencing CL_CLAIM_SUPPORT_ORDER

• SQL-237: GetRepository<SupportOrder>().Query()

---

CL_CLAIM_TYPE_ACTIVITY

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimBuilder for C-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ClaimBuilder

SQL referencing CL_CLAIM_TYPE_ACTIVITY

• SQL-241: GetRepository<ClaimTypeActivity>().Add(entity)

---

CL_CLAIM_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimBuilder, ClaimCodeTableBuilder, ClaimQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ClaimBuilder, ClaimCodeTableBuilder, ClaimQueryProvider

Operations referencing CL_CLAIM_TYPE_CODE

• Claim status and compensability

SQL referencing CL_CLAIM_TYPE_CODE

• SQL-072: GetRepository<ClaimTypeCode>().Query()
• SQL-257: GetRepository<ClaimTypeCode>().Query()
• SQL-262: GetRepository<ClaimTypeCode>().Query()

---

CL_INCURRED_COST_HISTORY

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ReserveQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped CL_INCURRED_COST_HIST_SEQ; no insert in this library)
Related tables	CL_INJURY_CLAIM
Business objects	ReserveQueryProvider

Operations referencing CL_INCURRED_COST_HISTORY

• Other query providers

SQL referencing CL_INCURRED_COST_HISTORY

• SQL-222: GetRepository<IncurredCostHistory>().Query()
• SQL-223: GetRepository<IncurredCostHistory>().Query()

---

CL_INJURY_CLAIM

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimQueryProvider, WorkerQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped CLAIM_ID_SEQ; no insert in this library)
Related tables	CL_CLAIM_PERSON, ATTENDING_PHYSICIAN, CL_INCURRED_COST_HISTORY, CL_MEDICAL_CONDITION, CL_PAYMENT_TOTAL, EAIP_PERIOD
Business objects	ClaimQueryProvider, WorkerQueryProvider

Operations referencing CL_INJURY_CLAIM

• Claim status and compensability
• Claim data-quality queries
• Other query providers

Business rules referencing CL_INJURY_CLAIM

• SD-BR-049 Missing tax id identified by a single space
• SD-BR-092 Active support order has no termination date
• SD-BR-093 Active report record has a null expiration date

SQL referencing CL_INJURY_CLAIM

• SQL-060: GetRepository<InjuryClaim>().Query()
• SQL-066: GetRepository<InjuryClaim>().Query()
• SQL-239: GetRepository<InjuryClaim>().Query()

---

CL_JURISDICTION_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimCodeTableBuilder for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ClaimCodeTableBuilder

SQL referencing CL_JURISDICTION_CODE

• SQL-261: GetRepository<JurisdictionCode>().Query()

---

CL_MEDICAL_CONDITION

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	CL_INJURY_CLAIM
Business objects	ClaimQueryProvider

Operations referencing CL_MEDICAL_CONDITION

• Claim status and compensability

SQL referencing CL_MEDICAL_CONDITION

• SQL-065: GetRepository<MedicalCondition>().Query()

---

CL_OVERPAYMENT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by OverpaymentQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped CL_OVERPAYMENT_SEQ; no insert in this library)
Related tables	CL_CLAIM_PERSON
Business objects	OverpaymentQueryProvider

Operations referencing CL_OVERPAYMENT

• Recoverable overpayment balance

Business rules referencing CL_OVERPAYMENT

• SD-BR-021 Recoverable balance sums outstanding amount for non-amended overpayments

SQL referencing CL_OVERPAYMENT

• SQL-190: GetRepository<Overpayment>().Query()

---

CL_PAYMENT_SPCL_HANDLING_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimPaymentQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ClaimPaymentQueryProvider

Operations referencing CL_PAYMENT_SPCL_HANDLING_CODE

• Other query providers

SQL referencing CL_PAYMENT_SPCL_HANDLING_CODE

• SQL-054: GetRepository<SpecialHandlingCode>().Query()
• SQL-055: GetRepository<SpecialHandlingCode>().Query()

---

CL_PAYMENT_TOTAL

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ReserveQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	CL_INJURY_CLAIM
Business objects	ReserveQueryProvider

Operations referencing CL_PAYMENT_TOTAL

• Other query providers

SQL referencing CL_PAYMENT_TOTAL

• SQL-224: GetRepository<PaymentTotal>().Query()

---

CL_PHARMACY_DAW_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by BillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	BillQueryProvider

Operations referencing CL_PHARMACY_DAW_CODE

• Bill queries

Business rules referencing CL_PHARMACY_DAW_CODE

• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing CL_PHARMACY_DAW_CODE

• SQL-048: GetRepository<PharmacyDispenseAsWrittenCode>().Query()

---

CL_PHARMACY_ELIGIBILITY_REPORT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ClaimQueryProvider

Operations referencing CL_PHARMACY_ELIGIBILITY_REPORT

• Claim status and compensability

SQL referencing CL_PHARMACY_ELIGIBILITY_REPORT

• SQL-067: GetRepository<PharmacyEligibilityReport>().Query()

---

CL_SECURITY_OVERRIDE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimSecurityOverrideProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped CL_OVERRIDE_SECURITY_SEQ; no insert in this library)
Related tables	None identified
Business objects	ClaimSecurityOverrideProvider

Operations referencing CL_SECURITY_OVERRIDE

• Claim security override check

Business rules referencing CL_SECURITY_OVERRIDE

• SD-BR-020 Employee has claim security override only when override row matches claim and employee within EffDate to ExpDate window

SQL referencing CL_SECURITY_OVERRIDE

• SQL-073: GetRepository<SecurityOverride>().Query()

---

CONSOLIDATED_CASE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LegalQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped CONSOLIDATED_CASE_SEQ; no insert in this library)
Related tables	LEGAL_CASE
Business objects	LegalQueryProvider

Operations referencing CONSOLIDATED_CASE

• Legal case queries

Business rules referencing CONSOLIDATED_CASE

• SD-BR-060 Case-to-claim resolution precedence
• SD-BR-061 Preferred employee name takes precedence

SQL referencing CONSOLIDATED_CASE

• SQL-165: GetRepository<ConsolidatedCase>().Query()

---

CONTACT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LocationQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	LocationQueryProvider

Operations referencing CONTACT

• Location lookups

Business rules referencing CONTACT

• SD-BR-062 Location code and contact-type precedence

SQL referencing CONTACT

• SQL-171: GetRepository<Contact>().Query()
• SQL-173: GetRepository<Contact>().Query()

---

EAIP_PERIOD

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EAIP_PERIOD_SEQ; no insert in this library)
Related tables	CL_INJURY_CLAIM
Business objects	ClaimQueryProvider

Operations referencing EAIP_PERIOD

• Claim status and compensability

SQL referencing EAIP_PERIOD

• SQL-068: GetRepository<EaipPeriod>().Query()

---

EBILL

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillDocumentQueryProvider, EbillEobQueryProvider, EbillQueryProvider, EbillServiceQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_SEQ; no insert in this library)
Related tables	CBP_BILL, EBILL_DOCUMENT, EBILL_ERROR_CONDITION, EBILL_HEALTH_INFORMATION, EBILL_SERVICE, EBILL_BATCH, EBILL_EOB, EBILL_PATIENT, EBILL_STATUS_CODE
Business objects	EbillDocumentQueryProvider, EbillEobQueryProvider, EbillQueryProvider, EbillServiceQueryProvider

Operations referencing EBILL

• E-bill processing queries

Business rules referencing EBILL

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug
• SD-BR-054 Zero-pay EOB candidate criteria
• SD-BR-055 DRG code identified by health information type

SQL referencing EBILL

• SQL-093: GetRepository<EbillDocument>().Query()
• SQL-096: GetRepository<EbillDocument>().Query()
• SQL-100: GetRepository<Ebill>().Query()
• SQL-101: GetRepository<Ebill>().Query()
• SQL-114: GetRepository<Ebill>().Query()
• SQL-115: GetRepository<Ebill>().Query()
• SQL-116: GetRepository<Ebill>().Query()
• SQL-117: GetRepository<Ebill>().Query()
• SQL-118: GetRepository<Ebill>().Query()
• SQL-119: GetRepository<Ebill>().Query()
• SQL-120: GetRepository<Ebill>().Query()
• SQL-122: GetRepository<Ebill>().Query()
• SQL-123: GetRepository<Ebill>().Query()
• SQL-124: GetRepository<Ebill>().Query()
• SQL-125: GetRepository<Ebill>().Query()
• SQL-126: GetRepository<Ebill>().Query()
• SQL-127: GetRepository<Ebill>().Query()
• SQL-140: GetRepository<Ebill>().Query()

---

EBILL_ADDRESS

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillAddressQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_ADDRESS_SEQ; no insert in this library)
Related tables	EBILL_BATCH
Business objects	EbillAddressQueryProvider

Operations referencing EBILL_ADDRESS

• E-bill processing queries

SQL referencing EBILL_ADDRESS

• SQL-074: GetRepository<EbillAddress>().Query()
• SQL-076: GetRepository<EbillAddress>().Query()

---

EBILL_ADDRESS_OVERRIDE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillAddressQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	EbillAddressQueryProvider

Operations referencing EBILL_ADDRESS_OVERRIDE

• E-bill processing queries

SQL referencing EBILL_ADDRESS_OVERRIDE

• SQL-077: GetRepository<EbillAddressOverride>().Query()

---

EBILL_ADDRESS_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillAddressQueryProvider, EbillingExtensions for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	EbillAddressQueryProvider, EbillingExtensions

Operations referencing EBILL_ADDRESS_TYPE_CODE

• E-bill processing queries

SQL referencing EBILL_ADDRESS_TYPE_CODE

• SQL-075: GetRepository<EbillAddressTypeCode>().Query()
• SQL-269: GetRepository<EbillAddressTypeCode>().Query()

---

EBILL_ASSIGNMENT_RULE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_ASSIGNMENT_RULE_SEQ; no insert in this library)
Related tables	None identified
Business objects	EbillQueryProvider

Operations referencing EBILL_ASSIGNMENT_RULE

• E-bill processing queries

Business rules referencing EBILL_ASSIGNMENT_RULE

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug

SQL referencing EBILL_ASSIGNMENT_RULE

• SQL-133: GetRepository<EbillAssignmentRule>().Query()

---

EBILL_BATCH

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillBatchQueryProvider, EbillEobQueryProvider, EbillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_BATCH_SEQ; no insert in this library)
Related tables	EBILL, EBILL_ADDRESS, EBILL_EOB, EBILL_PROVIDER, EBILL_BATCH_STATUS_CODE, EBILL_BATCH_TYPE_CODE, EBILL_CLEARINGHOUSE
Business objects	EbillBatchQueryProvider, EbillEobQueryProvider, EbillQueryProvider

Operations referencing EBILL_BATCH

• E-bill processing queries

Business rules referencing EBILL_BATCH

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug
• SD-BR-053 E-bill batch type classification
• SD-BR-054 Zero-pay EOB candidate criteria

SQL referencing EBILL_BATCH

• SQL-078: GetRepository<EbillBatch>().Query()
• SQL-079: GetRepository<EbillBatch>().Query()
• SQL-080: GetRepository<EbillBatch>().Query()
• SQL-081: GetRepository<EbillBatch>().Query()
• SQL-082: GetRepository<EbillBatch>().Query()
• SQL-083: GetRepository<EbillBatch>().Query()
• SQL-084: GetRepository<EbillBatch>().Query()
• SQL-085: GetRepository<EbillBatch>().Query()
• SQL-086: GetRepository<EbillBatch>().Query()
• SQL-100: GetRepository<Ebill>().Query()
• SQL-115: GetRepository<Ebill>().Query()
• SQL-117: GetRepository<Ebill>().Query()
• SQL-120: GetRepository<Ebill>().Query()

---

EBILL_BATCH_STATUS_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillBatchQueryProvider, EbillingExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	EBILL_BATCH
Business objects	EbillBatchQueryProvider, EbillingExtensions

Operations referencing EBILL_BATCH_STATUS_CODE

• E-bill processing queries

Business rules referencing EBILL_BATCH_STATUS_CODE

• SD-BR-053 E-bill batch type classification

SQL referencing EBILL_BATCH_STATUS_CODE

• SQL-089: GetRepository<EbillBatchStatusCode>().Query()
• SQL-266: GetRepository<EbillBatchStatusCode>().Query()

---

EBILL_BATCH_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillBatchQueryProvider, EbillingExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	EBILL_BATCH
Business objects	EbillBatchQueryProvider, EbillingExtensions

Operations referencing EBILL_BATCH_TYPE_CODE

• E-bill processing queries

Business rules referencing EBILL_BATCH_TYPE_CODE

• SD-BR-053 E-bill batch type classification

SQL referencing EBILL_BATCH_TYPE_CODE

• SQL-087: GetRepository<EbillBatchTypeCode>().Query()
• SQL-088: GetRepository<EbillBatchTypeCode>().Query()
• SQL-271: GetRepository<EbillBatchTypeCode>().Query()

---

EBILL_CLEARINGHOUSE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillClearinghouseQueryProvider, EbillingQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_CLEARINGHOUSE_SEQ; no insert in this library)
Related tables	EBILL_BATCH
Business objects	EbillClearinghouseQueryProvider, EbillingQueryProvider

Operations referencing EBILL_CLEARINGHOUSE

• E-bill processing queries

Business rules referencing EBILL_CLEARINGHOUSE

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug
• SD-BR-053 E-bill batch type classification
• SD-BR-054 Zero-pay EOB candidate criteria
• SD-BR-056 Active clearinghouse has a null end date

SQL referencing EBILL_CLEARINGHOUSE

• SQL-090: GetRepository<EbillClearinghouse>().Query()
• SQL-091: GetRepository<EbillClearinghouse>().Query()
• SQL-142: GetRepository<EbillClearinghouse>().Query()

---

EBILL_DOCUMENT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillDocumentQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_DOCUMENT_SEQ; no insert in this library)
Related tables	EBILL
Business objects	EbillDocumentQueryProvider

Operations referencing EBILL_DOCUMENT

• E-bill processing queries

SQL referencing EBILL_DOCUMENT

• SQL-092: GetRepository<EbillDocument>().Query()
• SQL-093: GetRepository<EbillDocument>().Query()
• SQL-094: GetRepository<EbillDocument>().Query()
• SQL-095: GetRepository<EbillDocument>().Query()
• SQL-096: GetRepository<EbillDocument>().Query()

---

EBILL_DOCUMENT_OVERRIDE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillDocumentQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	EbillDocumentQueryProvider

Operations referencing EBILL_DOCUMENT_OVERRIDE

• E-bill processing queries

SQL referencing EBILL_DOCUMENT_OVERRIDE

• SQL-099: GetRepository<EbillDocumentOverride>().Query()

---

EBILL_DOCUMENT_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillDocumentQueryProvider, EbillingExtensions for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	EBILL_SET_TYPE_CODE
Business objects	EbillDocumentQueryProvider, EbillingExtensions

Operations referencing EBILL_DOCUMENT_TYPE_CODE

• E-bill processing queries

SQL referencing EBILL_DOCUMENT_TYPE_CODE

• SQL-097: GetRepository<EbillDocumentTypeCode>().Query()
• SQL-098: GetRepository<EbillDocumentTypeCode>().Query()
• SQL-270: GetRepository<EbillDocumentTypeCode>().Query()
• SQL-272: GetRepository<EbillDocumentTypeCode>().Query()

---

EBILL_EOB

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillEobQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_EOB_SEQ; no insert in this library)
Related tables	EBILL_BATCH, EBILL
Business objects	EbillEobQueryProvider

Operations referencing EBILL_EOB

• E-bill processing queries

Business rules referencing EBILL_EOB

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug
• SD-BR-054 Zero-pay EOB candidate criteria

SQL referencing EBILL_EOB

• SQL-102: GetRepository<EbillEob>().Query()
• SQL-103: GetRepository<EbillEob>().Query()

---

EBILL_ERROR_CONDITION

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_ERROR_CONDITION_SEQ; no insert in this library)
Related tables	EBILL, EBILL_PATIENT, EBILL_PROVIDER
Business objects	EbillQueryProvider

Operations referencing EBILL_ERROR_CONDITION

• E-bill processing queries

Business rules referencing EBILL_ERROR_CONDITION

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug

SQL referencing EBILL_ERROR_CONDITION

• SQL-129: GetRepository<EbillErrorCondition>().Query()
• SQL-130: GetRepository<EbillErrorCondition>().Query()
• SQL-131: GetRepository<EbillErrorCondition>().Query()
• SQL-132: GetRepository<EbillErrorCondition>().Query()

---

EBILL_HEALTH_INFORMATION

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillHealthInformationQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_HEALTH_INFORMATION_SEQ; no insert in this library)
Related tables	EBILL, EBILL_HEALTH_INFO_TYPE_CODE
Business objects	EbillHealthInformationQueryProvider

Operations referencing EBILL_HEALTH_INFORMATION

• E-bill processing queries

Business rules referencing EBILL_HEALTH_INFORMATION

• SD-BR-055 DRG code identified by health information type

SQL referencing EBILL_HEALTH_INFORMATION

• SQL-104: GetRepository<EbillHealthInformation>().Query()
• SQL-106: GetRepository<EbillHealthInformation>().Query()

---

EBILL_HEALTH_INFO_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillHealthInformationQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	EBILL_HEALTH_INFORMATION
Business objects	EbillHealthInformationQueryProvider

Operations referencing EBILL_HEALTH_INFO_TYPE_CODE

• E-bill processing queries

Business rules referencing EBILL_HEALTH_INFO_TYPE_CODE

• SD-BR-055 DRG code identified by health information type

SQL referencing EBILL_HEALTH_INFO_TYPE_CODE

• SQL-105: GetRepository<EbillHealthInfoTypeCode>().Query()

---

EBILL_INVOICE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillInvoiceQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_INVOICE_SEQ; no insert in this library)
Related tables	EBILL_INVOICE_BILL, EBILL_INVOICE_ERROR
Business objects	EbillInvoiceQueryProvider

Operations referencing EBILL_INVOICE

• E-bill processing queries

SQL referencing EBILL_INVOICE

• SQL-107: GetRepository<EbillInvoice>().Query()

---

EBILL_INVOICE_BILL

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillInvoiceQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_INVOICE_BILL_SEQ; no insert in this library)
Related tables	EBILL_INVOICE
Business objects	EbillInvoiceQueryProvider

Operations referencing EBILL_INVOICE_BILL

• E-bill processing queries

SQL referencing EBILL_INVOICE_BILL

• SQL-108: GetRepository<EbillInvoiceBill>().Query()

---

EBILL_INVOICE_ERROR

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillInvoiceQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_INVOICE_ERROR_SEQ; no insert in this library)
Related tables	EBILL_INVOICE
Business objects	EbillInvoiceQueryProvider

Operations referencing EBILL_INVOICE_ERROR

• E-bill processing queries

SQL referencing EBILL_INVOICE_ERROR

• SQL-109: GetRepository<EbillInvoiceError>().Query()

---

EBILL_PATIENT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillPatientQueryProvider, EbillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_PATIENT_SEQ; no insert in this library)
Related tables	EBILL, EBILL_ERROR_CONDITION, EBILL_PROVIDER
Business objects	EbillPatientQueryProvider, EbillQueryProvider

Operations referencing EBILL_PATIENT

• E-bill processing queries

Business rules referencing EBILL_PATIENT

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug

SQL referencing EBILL_PATIENT

• SQL-110: GetRepository<EbillPatient>().Query()
• SQL-111: GetRepository<EbillPatient>().Query()
• SQL-122: GetRepository<Ebill>().Query()
• SQL-123: GetRepository<Ebill>().Query()
• SQL-125: GetRepository<Ebill>().Query()
• SQL-126: GetRepository<Ebill>().Query()

---

EBILL_PROVIDER

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillPatientQueryProvider, EbillProviderQueryProvider, EbillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_PROVIDER_SEQ; no insert in this library)
Related tables	EBILL_BATCH, EBILL_ERROR_CONDITION, EBILL_PATIENT, PROVIDER_LOCATION
Business objects	EbillPatientQueryProvider, EbillProviderQueryProvider, EbillQueryProvider

Operations referencing EBILL_PROVIDER

• E-bill processing queries

Business rules referencing EBILL_PROVIDER

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug

SQL referencing EBILL_PROVIDER

• SQL-111: GetRepository<EbillPatient>().Query()
• SQL-112: GetRepository<EbillProvider>().Query()
• SQL-113: GetRepository<EbillProvider>().Query()
• SQL-122: GetRepository<Ebill>().Query()
• SQL-123: GetRepository<Ebill>().Query()
• SQL-125: GetRepository<Ebill>().Query()
• SQL-126: GetRepository<Ebill>().Query()

---

EBILL_RESPONSE_SET

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_RESPONSE_SEQ; no insert in this library)
Related tables	None identified
Business objects	EbillQueryProvider

Operations referencing EBILL_RESPONSE_SET

• E-bill processing queries

Business rules referencing EBILL_RESPONSE_SET

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug

SQL referencing EBILL_RESPONSE_SET

• SQL-121: GetRepository<EbillResponseSet>().Query()

---

EBILL_SERVICE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillQueryProvider, EbillServiceQueryProvider for RU-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read, Update
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EBILL_SERVICE_SEQ; no insert in this library)
Related tables	EBILL
Business objects	EbillQueryProvider, EbillServiceQueryProvider

Operations referencing EBILL_SERVICE

• E-bill processing queries

Business rules referencing EBILL_SERVICE

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug

SQL referencing EBILL_SERVICE

• SQL-137: GetRepository<EbillService>().Query()
• SQL-138: GetRepository<EbillService>().Query()
• SQL-139: GetRepository<EbillService>().Query()
• SQL-141: GetRepository<EbillService>().Query()
• SQL-240: EbillService property change (flush)*

---

EBILL_SET_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillQueryProvider, EbillingExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	EBILL_DOCUMENT_TYPE_CODE
Business objects	EbillQueryProvider, EbillingExtensions

Operations referencing EBILL_SET_TYPE_CODE

• E-bill processing queries

Business rules referencing EBILL_SET_TYPE_CODE

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug

SQL referencing EBILL_SET_TYPE_CODE

• SQL-134: GetRepository<EbillSetTypeCode>().Query()
• SQL-135: GetRepository<EbillSetTypeCode>().Query()
• SQL-268: GetRepository<EbillSetTypeCode>().Query()
• SQL-272: GetRepository<EbillDocumentTypeCode>().Query()
• SQL-273: GetRepository<EbillSetTypeCode>().Query()

---

EBILL_STATUS_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillQueryProvider, EbillingExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	EBILL
Business objects	EbillQueryProvider, EbillingExtensions

Operations referencing EBILL_STATUS_CODE

• E-bill processing queries

Business rules referencing EBILL_STATUS_CODE

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug

SQL referencing EBILL_STATUS_CODE

• SQL-128: GetRepository<EbillStatusCode>().Query()
• SQL-267: GetRepository<EbillStatusCode>().Query()

---

EDI_BILL

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EdiQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EDI_BILL_SEQ; no insert in this library)
Related tables	EDI_BILL_REPORT
Business objects	EdiQueryProvider

Operations referencing EDI_BILL

• Other query providers

SQL referencing EDI_BILL

• SQL-144: GetRepository<Bill>().Query()
• SQL-145: GetRepository<Bill>().Query()

---

EDI_BILL_REPORT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EdiQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped EDI_BILL_REPORT_SEQ; no insert in this library)
Related tables	EDI_BILL
Business objects	EdiQueryProvider

Operations referencing EDI_BILL_REPORT

• Other query providers

SQL referencing EDI_BILL_REPORT

• SQL-143: GetRepository<BillReport>().Query()

---

EDI_PLACE_OF_SERVICE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by EbillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	EbillQueryProvider

Operations referencing EDI_PLACE_OF_SERVICE_CODE

• E-bill processing queries

Business rules referencing EDI_PLACE_OF_SERVICE_CODE

• SD-BR-050 E-bill status and assignment-rule code sets
• SD-BR-051 Bill included in clearinghouse response file by response-batch state
• SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug

SQL referencing EDI_PLACE_OF_SERVICE_CODE

• SQL-136: GetRepository<EdiPlaceOfServiceCode>().Query()

---

ENDORSE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyOutputDocumentExtensions for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	PolicyOutputDocumentExtensions

SQL referencing ENDORSE_CODE

• SQL-294: GetRepository<EndorseCode>().Query()

---

ERROR_ENVIRONMENT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by OnlineSupportExtensions for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	OnlineSupportExtensions

SQL referencing ERROR_ENVIRONMENT

• SQL-275: GetRepository<ErrorEnvironment>().Query()

---

ERROR_GROUP_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by OnlineSupportExtensions for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	OnlineSupportExtensions

SQL referencing ERROR_GROUP_CODE

• SQL-274: GetRepository<ErrorGroupCode>().Query()

---

ERROR_GROUP_ENVIRONMENT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by OnlineSupportExtensions for C-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	OnlineSupportExtensions

SQL referencing ERROR_GROUP_ENVIRONMENT

• SQL-245: GetRepository<ErrorGroupEnvironment>().Add(entity)

---

IMAGE_AFFILIATION

Field	Value
Database	Oracle*
Schema/Link	Unknown**
Purpose	Accessed by ImageQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	image
Business objects	ImageQueryProvider

SQL referencing IMAGE_AFFILIATION

• SQL-148: GetRepository<Image>().Query()

---

IMGSYS

Field	Value
Database	Oracle*
Schema/Link	Unknown**
Purpose	Accessed by ImageQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ImageQueryProvider

SQL referencing IMGSYS

• SQL-149: GetRepository<ImageSystem>().Query()

---

IcdVersionCode

Field	Value
Database	Unknown**
Schema/Link	Unknown**
Purpose	Accessed by BillQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	BillQueryProvider

Operations referencing IcdVersionCode

• Bill queries

Business rules referencing IcdVersionCode

• SD-BR-034 Bill entry source classification
• SD-BR-035 Bill allowed total treats null as zero
• SD-BR-036 Service code current only when expiration date is null

SQL referencing IcdVersionCode

• SQL-050: GetRepository<IcdVersionCode>().Query()

---

LEGAL_BILL

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LegalQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped LEGAL_BILL_SEQ; no insert in this library)
Related tables	LEGAL_CASE
Business objects	LegalQueryProvider

Operations referencing LEGAL_BILL

• Legal case queries

Business rules referencing LEGAL_BILL

• SD-BR-060 Case-to-claim resolution precedence
• SD-BR-061 Preferred employee name takes precedence

SQL referencing LEGAL_BILL

• SQL-156: GetRepository<LegalBill>().Query()

---

LEGAL_CASE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ImageQueryProvider, LegalQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped LEGAL_CASE_SEQ; no insert in this library)
Related tables	CASE_STATUS_CODE, APPEAL, CASE_COST, CONSOLIDATED_CASE, LEGAL_BILL, SUBPOENA
Business objects	ImageQueryProvider, LegalQueryProvider

Operations referencing LEGAL_CASE

• Legal case queries
• Other query providers

Business rules referencing LEGAL_CASE

• SD-BR-060 Case-to-claim resolution precedence
• SD-BR-061 Preferred employee name takes precedence

SQL referencing LEGAL_CASE

• SQL-151: GetRepository<LegalCase>().Query()
• SQL-152: GetRepository<LegalCase>().Query()
• SQL-153: GetRepository<LegalCase>().Query()
• SQL-154: GetRepository<LegalCase>().Query()
• SQL-160: GetRepository<LegalCase>().Query()
• SQL-166: GetRepository<LegalCase>().Query()

---

LEGAL_PERSON

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LegalQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped LEGAL_PERSON_SEQ; no insert in this library)
Related tables	LEGAL_PERSON_ADDRESS
Business objects	LegalQueryProvider

Operations referencing LEGAL_PERSON

• Legal case queries

Business rules referencing LEGAL_PERSON

• SD-BR-060 Case-to-claim resolution precedence
• SD-BR-061 Preferred employee name takes precedence

SQL referencing LEGAL_PERSON

• SQL-163: GetRepository<LegalPerson>().Query()

---

LEGAL_PERSON_ADDRESS

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LegalQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	LEGAL_PERSON
Business objects	LegalQueryProvider

Operations referencing LEGAL_PERSON_ADDRESS

• Legal case queries

Business rules referencing LEGAL_PERSON_ADDRESS

• SD-BR-060 Case-to-claim resolution precedence
• SD-BR-061 Preferred employee name takes precedence

SQL referencing LEGAL_PERSON_ADDRESS

• SQL-164: GetRepository<LegalPersonAddress>().Query()

---

LOCATION

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LocationQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped LOCATION_SEQ; no insert in this library)
Related tables	None identified
Business objects	LocationQueryProvider

Operations referencing LOCATION

• Location lookups

Business rules referencing LOCATION

• SD-BR-062 Location code and contact-type precedence

SQL referencing LOCATION

• SQL-167: GetRepository<Location>().Query()
• SQL-168: GetRepository<Location>().Query()
• SQL-169: GetRepository<Location>().Query()
• SQL-170: GetRepository<Location>().Query()
• SQL-172: GetRepository<Location>().Query()
• SQL-175: GetRepository<Location>().Query()

---

LOCATION_VERIFICATION_REQUEST

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AddressVerificationQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	ADDRESS_VERIFICATION_REQUEST
Business objects	AddressVerificationQueryProvider

Operations referencing LOCATION_VERIFICATION_REQUEST

• Other query providers

SQL referencing LOCATION_VERIFICATION_REQUEST

• SQL-001: GetRepository<LocationVerificationRequest>().Query()

---

LPT_CLAIM_CROSS_REFERENCE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ClaimQueryProvider

Operations referencing LPT_CLAIM_CROSS_REFERENCE

• Claim status and compensability

SQL referencing LPT_CLAIM_CROSS_REFERENCE

• SQL-056: GetRepository<InjuryClaimCrossReference>().Query()

---

MARKET_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyExtensions for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	PolicyExtensions

SQL referencing MARKET_TYPE_CODE

• SQL-277: GetRepository<MarketTypeCode>().Query()
• SQL-282: GetRepository<MarketTypeCode>().Query()
• SQL-284: GetRepository<MarketTypeCode>().Query()

---

MCO_PROVIDER

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ProviderQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ProviderQueryProvider

Operations referencing MCO_PROVIDER

• Provider queries

Business rules referencing MCO_PROVIDER

• SD-BR-080 Provider identity relationship and address code sets
• SD-BR-082 Dismissed bills excluded from provider location ids
• SD-BR-083 Provider in MCO only within date window

SQL referencing MCO_PROVIDER

• SQL-215: GetRepository<MCOProvider>().Query()
• SQL-216: GetRepository<MCOProvider>().Query()

---

MEDICARE_BENEFICIARY_QUERY

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by MedicareQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped MEDICARE_QUERY_SEQ; no insert in this library)
Related tables	None identified
Business objects	MedicareQueryProvider

Operations referencing MEDICARE_BENEFICIARY_QUERY

• Other query providers

Business rules referencing MEDICARE_BENEFICIARY_QUERY

• SD-BR-095 Medicare history match requires all fields equal

SQL referencing MEDICARE_BENEFICIARY_QUERY

• SQL-178: GetRepository<MedicareBeneficiaryQuery>().Query()
• SQL-180: GetRepository<MedicareBeneficiaryQuery>().Query()

---

MEDICARE_BENEFICIARY_QUERY_BAT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by MedicareQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	MedicareQueryProvider

Operations referencing MEDICARE_BENEFICIARY_QUERY_BAT

• Other query providers

Business rules referencing MEDICARE_BENEFICIARY_QUERY_BAT

• SD-BR-095 Medicare history match requires all fields equal

SQL referencing MEDICARE_BENEFICIARY_QUERY_BAT

• SQL-176: GetRepository<MedicareBeneficiaryQueryBatch>().Query()

---

MEDICARE_QUERY_HISTORY

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by MedicareQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped MEDICARE_QUERY_HISTORY_SEQ; no insert in this library)
Related tables	None identified
Business objects	MedicareQueryProvider

Operations referencing MEDICARE_QUERY_HISTORY

• Other query providers

Business rules referencing MEDICARE_QUERY_HISTORY

• SD-BR-095 Medicare history match requires all fields equal

SQL referencing MEDICARE_QUERY_HISTORY

• SQL-177: GetRepository<MedicareQueryHistory>().Query()
• SQL-179: GetRepository<MedicareQueryHistory>().Query()

---

NON_EMPR_ACCT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	PolicyQueryProvider

Operations referencing NON_EMPR_ACCT

• Other query providers

SQL referencing NON_EMPR_ACCT

• SQL-195: GetRepository<NonEmployerAccount>().Query()

---

OFFICE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LocationQueryProvider, PolicyExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	POLICY
Business objects	LocationQueryProvider, PolicyExtensions

Operations referencing OFFICE_CODE

• Location lookups

Business rules referencing OFFICE_CODE

• SD-BR-062 Location code and contact-type precedence

SQL referencing OFFICE_CODE

• SQL-174: GetRepository<OfficeCode>().Query()
• SQL-279: GetRepository<OfficeCode>().Query()
• SQL-283: GetRepository<OfficeCode>().Query()

---

OTHER_FIRM

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LegalQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped LEGAL_PERSON_SEQ; no insert in this library)
Related tables	None identified
Business objects	LegalQueryProvider

Operations referencing OTHER_FIRM

• Legal case queries

Business rules referencing OTHER_FIRM

• SD-BR-060 Case-to-claim resolution precedence
• SD-BR-061 Preferred employee name takes precedence

SQL referencing OTHER_FIRM

• SQL-162: GetRepository<OtherFirm>().Query()

---

PAYMENT_TRANSACTION_STAT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PaymentsQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped PAYMENT_TRANSACTION_STAT_SEQ; no insert in this library)
Related tables	PAYMENT_TRANSACTION_TYPE_CODE
Business objects	PaymentsQueryProvider

Operations referencing PAYMENT_TRANSACTION_STAT

• Other query providers

Business rules referencing PAYMENT_TRANSACTION_STAT

• SD-BR-094 MA code identifies medical audit payment type

SQL referencing PAYMENT_TRANSACTION_STAT

• SQL-191: GetRepository<PaymentTransactionStatistic>().Query()
• SQL-192: GetRepository<PaymentTransactionStatistic>().Query()

---

PAYMENT_TRANSACTION_TYPE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PaymentsQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	PAYMENT_TRANSACTION_STAT
Business objects	PaymentsQueryProvider

Operations referencing PAYMENT_TRANSACTION_TYPE_CODE

• Other query providers

Business rules referencing PAYMENT_TRANSACTION_TYPE_CODE

• SD-BR-094 MA code identifies medical audit payment type

SQL referencing PAYMENT_TRANSACTION_TYPE_CODE

• SQL-193: GetRepository<PaymentTransactionTypeCode>().Query()

---

POLICY

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by OutputDocumentQueryProvider, PolicyQueryProvider, ClaimBuilder, PolicyExtensions, PolicyOutputDocumentExtensions for CRU-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read, Update
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	Agent, OFFICE_CODE, POLICY_PERIOD_GROUP_ASSOC
Business objects	OutputDocumentQueryProvider, PolicyQueryProvider, ClaimBuilder, PolicyExtensions, PolicyOutputDocumentExtensions

Operations referencing POLICY

• Output document queries
• Other query providers

Business rules referencing POLICY

• SD-BR-070 Output document status code set
• SD-BR-071 Document date defaults from batch process log
• SD-BR-075 Child documents only retrievable for a released parent

SQL referencing POLICY

• SQL-182: GetRepository<Policy>().Query()
• SQL-194: GetRepository<Policy>().Query()
• SQL-243: GetRepository<Policy>().Add(entity)
• SQL-249: GetRepository<Policy>().Add(entity)
• SQL-250: GetRepository<Policy>().Add(entity)
• SQL-260: GetRepository<Policy>().Query()
• SQL-286: GetRepository<Policy>().Query()
• SQL-287: GetRepository<Policy>().Query()
• SQL-296: GetRepository<Policy>().Query()

---

POLICY_PERIOD_GROUP_ASSOC

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	POLICY
Business objects	PolicyQueryProvider

Operations referencing POLICY_PERIOD_GROUP_ASSOC

• Other query providers

SQL referencing POLICY_PERIOD_GROUP_ASSOC

• SQL-198: GetRepository<PolicyPeriodGroupAssoc>().Query()

---

POLICY_PERIOD_PAYROLL_AUDIT

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	PolicyQueryProvider

Operations referencing POLICY_PERIOD_PAYROLL_AUDIT

• Other query providers

SQL referencing POLICY_PERIOD_PAYROLL_AUDIT

• SQL-199: GetRepository<PolicyPeriodPayrollAudit>().Query()

---

POLICY_RELATIONSHIP_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyExtensions for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	PolicyExtensions

SQL referencing POLICY_RELATIONSHIP_CODE

• SQL-278: GetRepository<PolicyRelationshipCode>().Query()
• SQL-285: GetRepository<PolicyRelationshipCode>().Query()

---

POLICY_TEAM_FUNCTION

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyExtensions, PolicyQueryProvider for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	PolicyExtensions, PolicyQueryProvider

Operations referencing POLICY_TEAM_FUNCTION

• Other query providers

SQL referencing POLICY_TEAM_FUNCTION

• SQL-196: GetRepository<PolicyTeamFunction>().Query()
• SQL-248: GetRepository<PolicyTeamFunction>().Add(entity)
• SQL-281: GetRepository<PolicyTeamFunction>().Query()

---

PROVIDER

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ProviderQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped PROVIDER_SEQ; no insert in this library)
Related tables	PROVIDER_LOCATION
Business objects	ProviderQueryProvider

Operations referencing PROVIDER

• Provider queries

Business rules referencing PROVIDER

• SD-BR-080 Provider identity relationship and address code sets
• SD-BR-082 Dismissed bills excluded from provider location ids
• SD-BR-083 Provider in MCO only within date window

SQL referencing PROVIDER

• SQL-202: GetRepository<Provider>().Query()
• SQL-204: GetRepository<Provider>().Query()

---

PROVIDER_ADDRESS

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ProviderQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped PROVIDER_ADDRESS_SEQ; no insert in this library)
Related tables	PROVIDER_LOCATION
Business objects	ProviderQueryProvider

Operations referencing PROVIDER_ADDRESS

• Provider queries

Business rules referencing PROVIDER_ADDRESS

• SD-BR-080 Provider identity relationship and address code sets
• SD-BR-082 Dismissed bills excluded from provider location ids
• SD-BR-083 Provider in MCO only within date window

SQL referencing PROVIDER_ADDRESS

• SQL-200: GetRepository<ProviderAddress>().Query()
• SQL-201: GetRepository<BatchProviderAddress>().Query()
• SQL-206: GetRepository<ProviderAddress>().Query()
• SQL-207: GetRepository<ProviderAddress>().Query()
• SQL-208: GetRepository<ProviderAddress>().Query()
• SQL-209: GetRepository<ProviderAddress>().Query()

---

PROVIDER_IDENTITY

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ProviderQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ProviderQueryProvider

Operations referencing PROVIDER_IDENTITY

• Provider queries

Business rules referencing PROVIDER_IDENTITY

• SD-BR-080 Provider identity relationship and address code sets
• SD-BR-082 Dismissed bills excluded from provider location ids
• SD-BR-083 Provider in MCO only within date window

SQL referencing PROVIDER_IDENTITY

• SQL-211: GetRepository<ProviderIdentity>().Query()

---

PROVIDER_LOCATION

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimQueryProvider, ProviderQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped PROVIDER_LOCATION_SEQ; no insert in this library)
Related tables	PROVIDER, ATTENDING_PHYSICIAN, CBP_BILL, CL_CLAIM_LEGAL_REPRESENTATIVE, EBILL_PROVIDER, PROVIDER_ADDRESS, PROVIDER_RELATIONSHIP
Business objects	ClaimQueryProvider, ProviderQueryProvider

Operations referencing PROVIDER_LOCATION

• Attending physician resolution
• E-bill processing queries
• Provider queries
• Other query providers

Business rules referencing PROVIDER_LOCATION

• SD-BR-040 Physician without facility is invalid
• SD-BR-080 Provider identity relationship and address code sets
• SD-BR-082 Dismissed bills excluded from provider location ids
• SD-BR-083 Provider in MCO only within date window
• SD-BR-093 Active report record has a null expiration date

SQL referencing PROVIDER_LOCATION

• SQL-057: GetRepository<ProviderLocation>().Query()
• SQL-205: GetRepository<ProviderLocation>().Query()
• SQL-206: GetRepository<ProviderAddress>().Query()
• SQL-207: GetRepository<ProviderAddress>().Query()

---

PROVIDER_RELATIONSHIP

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ProviderQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	PROVIDER_LOCATION
Business objects	ProviderQueryProvider

Operations referencing PROVIDER_RELATIONSHIP

• Provider queries

Business rules referencing PROVIDER_RELATIONSHIP

• SD-BR-080 Provider identity relationship and address code sets
• SD-BR-082 Dismissed bills excluded from provider location ids
• SD-BR-083 Provider in MCO only within date window

SQL referencing PROVIDER_RELATIONSHIP

• SQL-212: GetRepository<ProviderRelationship>().Query()
• SQL-213: GetRepository<ProviderRelationship>().Query()
• SQL-214: GetRepository<ProviderRelationship>().Query()
• SQL-217: GetRepository<ProviderRelationship>().Query()

---

PROVIDER_TAX_ID

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ProviderQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ProviderQueryProvider

Operations referencing PROVIDER_TAX_ID

• Provider queries

Business rules referencing PROVIDER_TAX_ID

• SD-BR-080 Provider identity relationship and address code sets
• SD-BR-082 Dismissed bills excluded from provider location ids
• SD-BR-083 Provider in MCO only within date window

SQL referencing PROVIDER_TAX_ID

• SQL-203: GetRepository<ProviderTaxId>().Query()

---

RTW_CASE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ClaimQueryProvider

Operations referencing RTW_CASE

• Claim status and compensability

SQL referencing RTW_CASE

• SQL-070: GetRepository<RTWCase>().Query()

---

SUBPOENA

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by LegalQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped SUBPOENA_SEQ; no insert in this library)
Related tables	LEGAL_CASE
Business objects	LegalQueryProvider

Operations referencing SUBPOENA

• Legal case queries

Business rules referencing SUBPOENA

• SD-BR-060 Case-to-claim resolution precedence
• SD-BR-061 Preferred employee name takes precedence

SQL referencing SUBPOENA

• SQL-157: GetRepository<Subpoena>().Query()

---

TASK

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by TaskQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped TASK_SEQ; no insert in this library)
Related tables	None identified
Business objects	TaskQueryProvider

Operations referencing TASK

• Other query providers

Business rules referencing TASK

• SD-BR-091 Task codes compared case-insensitively

SQL referencing TASK

• SQL-235: GetRepository<Task>().Query()
• SQL-236: GetRepository<Task>().Query()

---

TASK_ACTION_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by TaskExtensions, TaskQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	TaskExtensions, TaskQueryProvider

Operations referencing TASK_ACTION_CODE

• Other query providers

Business rules referencing TASK_ACTION_CODE

• SD-BR-091 Task codes compared case-insensitively

SQL referencing TASK_ACTION_CODE

• SQL-232: GetRepository<TaskAction>().Query()
• SQL-303: GetRepository<TaskAction>().Query()
• SQL-306: GetRepository<TaskAction>().Query()

---

TASK_CATEGORY_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by TaskExtensions, TaskQueryProvider for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	TaskExtensions, TaskQueryProvider

Operations referencing TASK_CATEGORY_CODE

• Other query providers

Business rules referencing TASK_CATEGORY_CODE

• SD-BR-091 Task codes compared case-insensitively

SQL referencing TASK_CATEGORY_CODE

• SQL-234: GetRepository<TaskCategory>().Query()
• SQL-254: GetRepository<TaskCategory>().Add(entity)

---

TASK_PRIORITY_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by TaskExtensions, TaskQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	TaskExtensions, TaskQueryProvider

Operations referencing TASK_PRIORITY_CODE

• Other query providers

Business rules referencing TASK_PRIORITY_CODE

• SD-BR-091 Task codes compared case-insensitively

SQL referencing TASK_PRIORITY_CODE

• SQL-233: GetRepository<TaskPriority>().Query()
• SQL-304: GetRepository<TaskPriority>().Query()
• SQL-305: GetRepository<TaskPriority>().Query()

---

TASK_SOURCE_CODE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by TaskExtensions, TaskQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	TaskExtensions, TaskQueryProvider

Operations referencing TASK_SOURCE_CODE

• Other query providers

Business rules referencing TASK_SOURCE_CODE

• SD-BR-091 Task codes compared case-insensitively

SQL referencing TASK_SOURCE_CODE

• SQL-231: GetRepository<TaskSource>().Query()
• SQL-302: GetRepository<TaskSource>().Query()
• SQL-307: GetRepository<TaskSource>().Query()

---

THRDPARTY_CASE

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped THRDPARTY_CASE_SEQ; no insert in this library)
Related tables	None identified
Business objects	ClaimQueryProvider

Operations referencing THRDPARTY_CASE

• Claim status and compensability

SQL referencing THRDPARTY_CASE

• SQL-069: GetRepository<ThirdPartyCase>().Query()

---

VERIFIED_ADDRESS

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by AddressVerificationQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A (mapped VERIFIED_ADDRESS_SEQ; no insert in this library)
Related tables	ADDRESS_VERIFICATION_REQUEST
Business objects	AddressVerificationQueryProvider

Operations referencing VERIFIED_ADDRESS

• Other query providers

SQL referencing VERIFIED_ADDRESS

• SQL-003: GetRepository<VerifiedAddress>().Query()

---

WCIS_Employee

Field	Value
Database	Oracle*
Schema/Link	Unknown**
Purpose	Accessed by EmployeeQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	EmployeeQueryProvider

SQL referencing WCIS_Employee

• SQL-146: GetRepository<WcisEmployee>().Query()

---

batch_process_log

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by OutputDocumentQueryProvider, PolicyOutputDocumentExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	OutputDocumentQueryProvider, PolicyOutputDocumentExtensions

Operations referencing batch_process_log

• Output document queries

Business rules referencing batch_process_log

• SD-BR-070 Output document status code set
• SD-BR-071 Document date defaults from batch process log
• SD-BR-075 Child documents only retrievable for a released parent

SQL referencing batch_process_log

• SQL-183: GetRepository<BatchProcessLog>().Query()
• SQL-251: GetRepository<BatchProcessLog>().Add(entity)

---

cl_pref_contact_method_code

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by WorkerQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	WorkerQueryProvider

Operations referencing cl_pref_contact_method_code

• Other query providers

Business rules referencing cl_pref_contact_method_code

• SD-BR-092 Active support order has no termination date

SQL referencing cl_pref_contact_method_code

• SQL-238: GetRepository<PreferredContactMethodCode>().Query()

---

claim_status_code

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ClaimBuilder, ClaimCodeTableBuilder, ClaimQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	ClaimBuilder, ClaimCodeTableBuilder, ClaimQueryProvider

Operations referencing claim_status_code

• Claim status and compensability

Business rules referencing claim_status_code

• SD-BR-041 Latest claim status falls back to WCD status when no history
• SD-BR-042 Compensability status mapping
• SD-BR-043 Original acceptance requires request type I with decision A

SQL referencing claim_status_code

• SQL-071: GetRepository<ClaimStatusCode>().Query()
• SQL-258: GetRepository<ClaimStatusCode>().Query()
• SQL-263: GetRepository<ClaimStatusCode>().Query()

---

document_status_code

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by OutputDocumentQueryProvider, PolicyOutputDocumentExtensions for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	OutputDocumentQueryProvider, PolicyOutputDocumentExtensions

Operations referencing document_status_code

• Output document queries

Business rules referencing document_status_code

• SD-BR-070 Output document status code set
• SD-BR-071 Document date defaults from batch process log
• SD-BR-075 Child documents only retrievable for a released parent

SQL referencing document_status_code

• SQL-181: GetRepository<DocumentStatusCode>().Query()
• SQL-189: GetRepository<DocumentStatusCode>().Query()
• SQL-288: GetRepository<DocumentStatusCode>().Query()
• SQL-295: GetRepository<DocumentStatusCode>().Query()

---

image

Field	Value
Database	Oracle*
Schema/Link	Unknown**
Purpose	Accessed by ImageQueryProvider for R-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	IMAGE_AFFILIATION
Business objects	ImageQueryProvider

SQL referencing image

• SQL-147: GetRepository<Image>().Query()
• SQL-148: GetRepository<Image>().Query()

---

image_category_code

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyOutputDocumentExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	image_document_type_code
Business objects	PolicyOutputDocumentExtensions

SQL referencing image_category_code

• SQL-290: GetRepository<ImageCategoryCode>().Query()
• SQL-291: GetRepository<ImageDocumentTypeCode>().Query()

---

image_document_type_code

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by ImageQueryProvider, PolicyOutputDocumentExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	image_category_code, output_doc_notify_text_code, output_document_category_code, output_document_type_code
Business objects	ImageQueryProvider, PolicyOutputDocumentExtensions

SQL referencing image_document_type_code

• SQL-150: GetRepository<ImageDocumentTypeCode>().Query()
• SQL-291: GetRepository<ImageDocumentTypeCode>().Query()
• SQL-293: GetRepository<OutputDocumentTypeCode>().Query()

---

output_doc_notify_text_code

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyOutputDocumentExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	output_document_type_code
Business objects	PolicyOutputDocumentExtensions

SQL referencing output_doc_notify_text_code

• SQL-292: GetRepository<OutputDocumentNotifyTextCode>().Query()
• SQL-293: GetRepository<OutputDocumentTypeCode>().Query()

---

output_document

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by PolicyOutputDocumentExtensions for C-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	output_document_seq
Related tables	None identified
Business objects	PolicyOutputDocumentExtensions

SQL referencing output_document

• SQL-252: GetRepository<OutputDocument>().Add(entity)

---

output_document_category_code

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by OutputDocumentQueryProvider, PolicyOutputDocumentExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	OutputDocumentQueryProvider, PolicyOutputDocumentExtensions

Operations referencing output_document_category_code

• Output document queries

Business rules referencing output_document_category_code

• SD-BR-070 Output document status code set
• SD-BR-071 Document date defaults from batch process log
• SD-BR-075 Child documents only retrievable for a released parent

SQL referencing output_document_category_code

• SQL-188: GetRepository<OutputDocumentCategoryCode>().Query()
• SQL-289: GetRepository<OutputDocumentCategoryCode>().Query()
• SQL-293: GetRepository<OutputDocumentTypeCode>().Query()

---

output_document_type_code

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by OutputDocumentQueryProvider, PolicyOutputDocumentExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	ENDORSE_CODE, image_document_type_code, output_doc_notify_text_code, output_document_category_code
Business objects	OutputDocumentQueryProvider, PolicyOutputDocumentExtensions

SQL referencing output_document_type_code

• SQL-187: GetRepository<OutputDocumentTypeCode>().Query()
• SQL-293: GetRepository<OutputDocumentTypeCode>().Query()
• SQL-294: GetRepository<EndorseCode>().Query()
• SQL-297: GetRepository<OutputDocumentTypeCode>().Query()
• SQL-298: GetRepository<OutputDocumentTypeCode>().Query()
• SQL-299: GetRepository<OutputDocumentTypeCode>().Query()
• SQL-300: GetRepository<OutputDocumentTypeCode>().Query()
• SQL-301: GetRepository<OutputDocumentTypeCode>().Query()

---

policy_output_document

Field	Value
Database	Oracle*
Schema/Link	[unqualified]**
Purpose	Accessed by OutputDocumentQueryProvider, PolicyOutputDocumentExtensions for CR-type operations*
Access pattern	ORM (NHibernate LINQ)
CRUD operations	Create, Read
Key columns used	See individual SQL documents for bound parameters and predicates
Sequence	N/A
Related tables	None identified
Business objects	OutputDocumentQueryProvider, PolicyOutputDocumentExtensions

Operations referencing policy_output_document

• Output document queries

Business rules referencing policy_output_document

• SD-BR-070 Output document status code set
• SD-BR-071 Document date defaults from batch process log
• SD-BR-075 Child documents only retrievable for a released parent

SQL referencing policy_output_document

• SQL-185: GetRepository<PolicyOutputDocument>().Query()
• SQL-186: GetRepository<PolicyOutputDocument>().Query()
• SQL-253: GetRepository<PolicyOutputDocument>().Add(entity)

---

Table relationship diagram

The following diagram shows relationships between tables used by this library, derived from 68 verified ORM mapping join pairs.

erDiagram
    ADDRESS_VERIFICATION_REQUEST ||--o{ LOCATION_VERIFICATION_REQUEST : "one-to-many"
    Agency ||--o{ Agent : "one-to-many"
    Agent ||--o{ POLICY : "one-to-many"
    CASE_STATUS_CODE ||--o{ LEGAL_CASE : "one-to-many"
    CBP_AUDIT ||--o{ CBP_AUDITED_SERVICE : "one-to-many"
    CBP_BILL ||--o{ CBP_AUDIT : "one-to-many"
    CBP_BILL ||--o{ CBP_AUDITED_SERVICE : "one-to-many"
    CBP_BILL ||--o{ CBP_BILL_STATUS : "one-to-many"
    CBP_BILL ||--o{ CBP_NOTE : "one-to-many"
    CBP_BILL ||--o{ EBILL : "one-to-many"
    CBP_BILL_STATUS_CODE ||--o{ CBP_BILL : "one-to-many"
    CBP_NOTE_CATEGORY_CODE ||--o{ CBP_NOTE_TYPE_CODE : "one-to-many"
    CBP_SERVICE_CODE ||--o{ CBP_CPT_SERVICE : "one-to-many"
    CBP_SERVICE_CODE ||--o{ CBP_SERVICE_DESCRIPTION : "one-to-many"
    CBP_SERVICE_TYPE_CODE ||--o{ CBP_SERVICE_CODE : "one-to-many"
    CL_CLAIM_PERSON ||--o{ CL_CLAIM_SUPPORT_ORDER : "one-to-many"
    CL_CLAIM_PERSON ||--o{ CL_INJURY_CLAIM : "one-to-many"
    CL_CLAIM_PERSON ||--o{ CL_OVERPAYMENT : "one-to-many"
    CL_INJURY_CLAIM ||--o{ ATTENDING_PHYSICIAN : "one-to-many"
    CL_INJURY_CLAIM ||--o{ CL_INCURRED_COST_HISTORY : "one-to-many"
    CL_INJURY_CLAIM ||--o{ CL_MEDICAL_CONDITION : "one-to-many"
    CL_INJURY_CLAIM ||--o{ CL_PAYMENT_TOTAL : "one-to-many"
    CL_INJURY_CLAIM ||--o{ EAIP_PERIOD : "one-to-many"
    EBILL ||--o{ EBILL_DOCUMENT : "one-to-many"
    EBILL ||--o{ EBILL_ERROR_CONDITION : "one-to-many"
    EBILL ||--o{ EBILL_HEALTH_INFORMATION : "one-to-many"
    EBILL ||--o{ EBILL_SERVICE : "one-to-many"
    EBILL_BATCH ||--o{ EBILL : "one-to-many"
    EBILL_BATCH ||--o{ EBILL_ADDRESS : "one-to-many"
    EBILL_BATCH ||--o{ EBILL_EOB : "one-to-many"
    EBILL_BATCH ||--o{ EBILL_PROVIDER : "one-to-many"
    EBILL_BATCH_STATUS_CODE ||--o{ EBILL_BATCH : "one-to-many"
    EBILL_BATCH_TYPE_CODE ||--o{ EBILL_BATCH : "one-to-many"
    EBILL_CLEARINGHOUSE ||--o{ EBILL_BATCH : "one-to-many"
    EBILL_EOB ||--o{ EBILL : "one-to-many"
    EBILL_HEALTH_INFO_TYPE_CODE ||--o{ EBILL_HEALTH_INFORMATION : "one-to-many"
    EBILL_INVOICE ||--o{ EBILL_INVOICE_BILL : "one-to-many"
    EBILL_INVOICE ||--o{ EBILL_INVOICE_ERROR : "one-to-many"
    EBILL_PATIENT ||--o{ EBILL : "one-to-many"
    EBILL_PATIENT ||--o{ EBILL_ERROR_CONDITION : "one-to-many"
    EBILL_PROVIDER ||--o{ EBILL_ERROR_CONDITION : "one-to-many"
    EBILL_PROVIDER ||--o{ EBILL_PATIENT : "one-to-many"
    EBILL_SET_TYPE_CODE ||--o{ EBILL_DOCUMENT_TYPE_CODE : "one-to-many"
    EBILL_STATUS_CODE ||--o{ EBILL : "one-to-many"
    EDI_BILL_REPORT ||--o{ EDI_BILL : "one-to-many"
    LEGAL_CASE ||--o{ APPEAL : "one-to-many"
    LEGAL_CASE ||--o{ CASE_COST : "one-to-many"
    LEGAL_CASE ||--o{ CONSOLIDATED_CASE : "one-to-many"
    LEGAL_CASE ||--o{ LEGAL_BILL : "one-to-many"
    LEGAL_CASE ||--o{ SUBPOENA : "one-to-many"
    LEGAL_PERSON_ADDRESS ||--o{ LEGAL_PERSON : "one-to-many"
    OFFICE_CODE ||--o{ POLICY : "one-to-many"
    PAYMENT_TRANSACTION_TYPE_CODE ||--o{ PAYMENT_TRANSACTION_STAT : "one-to-many"
    POLICY ||--o{ POLICY_PERIOD_GROUP_ASSOC : "one-to-many"
    PROVIDER ||--o{ PROVIDER_LOCATION : "one-to-many"
    PROVIDER_LOCATION ||--o{ ATTENDING_PHYSICIAN : "one-to-many"
    PROVIDER_LOCATION ||--o{ CBP_BILL : "one-to-many"
    PROVIDER_LOCATION ||--o{ CL_CLAIM_LEGAL_REPRESENTATIVE : "one-to-many"
    PROVIDER_LOCATION ||--o{ EBILL_PROVIDER : "one-to-many"
    PROVIDER_LOCATION ||--o{ PROVIDER_ADDRESS : "one-to-many"
    PROVIDER_LOCATION ||--o{ PROVIDER_RELATIONSHIP : "one-to-many"
    VERIFIED_ADDRESS ||--o{ ADDRESS_VERIFICATION_REQUEST : "one-to-many"
    image ||--o{ IMAGE_AFFILIATION : "one-to-many"
    image_category_code ||--o{ image_document_type_code : "one-to-many"
    image_category_code ||--o{ output_document_type_code : "one-to-many"
    image_document_type_code ||--o{ output_document_type_code : "one-to-many"
    output_doc_notify_text_code ||--o{ output_document_type_code : "one-to-many"
    output_document_category_code ||--o{ output_document_type_code : "one-to-many"

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Configuration
• Operations and processes
• Business rules
• Security and authorization
• SQL catalog
• API reference

Sources

• Data/SAIF.Data.NHibernate/Mappings/**