SAIF.Domain SQL catalog

SAIF.Domain has no raw SQL, stored-procedure calls, or IBusinessCriteria usage. This catalog indexes the 33 ORM operations found in this library: 18 explicit repository calls (Add/Delete/Query), 5 cascade inserts (children added to a mapped collection with Cascade.AllDeleteOrphan), and 10 implicit updates (property changes on loaded entities, persisted when the caller's IUnitOfWork flushes). NHibernate generates the actual SQL at runtime from the ClassMaps in Data/SAIF.Data.NHibernate/Mappings/**.

Create operations

SQL ID	Description	Type	Tables	Business object
SQL-001	Insert an audit note against a bill or claim	ORM	CBP_NOTE	AuditNote
SQL-002	Attach a note to its parent bill via cascade insert	ORM (cascade)*	CBP_NOTE	AuditNote
SQL-003	Create a new ebilling batch	ORM	EBILL_BATCH	Batch
SQL-004	Create a batch with clearinghouse defaults	ORM	EBILL_BATCH	Batch
SQL-005	Create a batch with default submission dates	ORM	EBILL_BATCH	Batch
SQL-006	Record a bill status-history entry	ORM (cascade)*	CBP_BILL_STATUS	Bill
SQL-007	Insert a cloned bill during regeneration	ORM	CBP_BILL	BillRegenerator
SQL-008	Cascade-insert regenerated bill service lines	ORM (cascade)*	CBP_BILL_SERVICE	BillRegenerator
SQL-009	Insert a new certificate holder	ORM	CERTIFICATE_HOLDER	CertificateHolder
SQL-010	Insert an MCO fee adjustment for an EOB	ORM	EBILL_EOB_ADJUSTMENT	EobBuilder
SQL-011	Insert an MCO fee remittance advice	ORM	EBILL_EOB_REMITTANCE_ADVICE	EobBuilder
SQL-012	Insert a service-level EOB adjustment	ORM	EBILL_EOB_ADJUSTMENT	EobBuilder
SQL-013	Insert a service-level remittance advice	ORM	EBILL_EOB_REMITTANCE_ADVICE	EobBuilder
SQL-014	Insert an ebill error/pend condition	ORM	EBILL_ERROR_CONDITION	ErrorConditionHandler
SQL-015	Cascade-insert an ebill service parsed from an 837 file	ORM (cascade)*	EBILL_SERVICE	File837Extractor
SQL-016	Insert a newly generated CBP bill	ORM	CBP_BILL	GenerateCbpBills
SQL-017	Cascade-insert generated CBP bill service lines	ORM (cascade)*	CBP_BILL_SERVICE	GenerateCbpBills

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-018	Retrieve the MCO location matching a Guidewire MCO ID	ORM (LINQ)	MCO_GSA_LOCATION	Claim
SQL-019	Retrieve the provider location for a claim's legal representative	ORM (LINQ)	PROVIDER_LOCATION	Claim
SQL-020	Retrieve provider locations for EOB generation	ORM (LINQ)	PROVIDER_LOCATION	EobBuilder
SQL-021	Retrieve ebills for a chunk of bill IDs during EOB generation	ORM (LINQ)	EBILL	EobBuilder
SQL-022	Retrieve endorsement codes eligible for renewal packets	ORM (LINQ)	ENDORSE_CODE	PacketDefinition

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-023	Update batch status to Completed	ORM (dirty-check flush)*	EBILL_BATCH	Batch
SQL-024	Update ebill status to Assigned	ORM (dirty-check flush)*	EBILL	BillAssignment
SQL-025	Update ebill status to Indexed	ORM (dirty-check flush)*	EBILL	BillServiceIndexer
SQL-026	Update certificate holder details on re-edit	ORM (dirty-check flush)*	CERTIFICATE_HOLDER	CertificateHolder
SQL-027	Update certificate holder to Expired	ORM (dirty-check flush)*	CERTIFICATE_HOLDER	CertificateHolder
SQL-028	Update certificate holder to Superseded	ORM (dirty-check flush)*	CERTIFICATE_HOLDER	CertificateHolder
SQL-029	Update ebill status to Completed after EOB attach	ORM (dirty-check flush)*	EBILL	EobBuilder
SQL-030	Update ebill status from a 277 response	ORM (dirty-check flush)*	EBILL	File277CaBuilder
SQL-031	Update ebill status after 835 file build	ORM (dirty-check flush)*	EBILL	File835Builder
SQL-032	Update ebill status to CbpSetup after CBP generation	ORM (dirty-check flush)*	EBILL	GenerateCbpBills

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-033	Delete an audit note	ORM	CBP_NOTE	AuditNote

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts.

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• API reference

Sources

• Data/SAIF.Data.NHibernate/Mappings/Claims/Bills/CbpBillMap.cs, CbpBillServiceMap.cs, CbpBillStatusMap.cs, CbpNoteMap.cs
• Data/SAIF.Data.NHibernate/Mappings/Policies/Certificates/CertificateHolderMap.cs
• Data/SAIF.Data.NHibernate/Mappings/Claims/Ebilling/EbillMap.cs, EbillBatchMap.cs, EbillEobAdjustmentMap.cs, EbillEobRemittanceAdviceMap.cs, EbillErrorConditionMap.cs, EbillServiceMap.cs
• Domain/SAIF.Domain/Model/Claims/Bills/Notes/AuditNote.cs
• Domain/SAIF.Domain/Model/Claims/Ebilling/Batch.cs
• Domain/SAIF.Domain/Model/Claims/Bills/Bill.cs
• Domain/SAIF.Domain/Claims/Bills/BillRegenerator.cs
• Domain/SAIF.Domain/Model/Policies/Certificates/CertificateHolder.cs
• Domain/SAIF.Domain/Claims/Ebilling/EobBuilder.cs, ErrorConditionHandler.cs (Model/Claims/Ebilling/ErrorConditionHandler.cs), File837Extractor.cs, GenerateCBPBills.cs, BillAssignment.cs, File277CaBuilder.cs, File835Builder.cs
• Domain/SAIF.Domain/Model/Claims/Claim.cs
• Domain/SAIF.Domain/Tasks/Documents/Packets/PacketDefinition.cs
• Domain/SAIF.Domain/Claims/Ebilling/Indexing/BillServiceIndexer.cs