SAIF.Services database tables

This page catalogs the 183 Oracle database tables reached by SAIF.Services through NHibernate-mapped business objects (GetRepository<T>()), plus 17 generic-repository entity types whose backing table could not be resolved to a ClassMap from static analysis alone (marked ** below and listed in Unmapped entities). This library declares no ClassMaps of its own, executes no raw SQL/ADO.NET, and holds no connection strings — every table below is reached indirectly through SAIF.Data / SAIF.Data.NHibernate repositories and query providers.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
ADJUSTMENT_REASON_CODE	Oracle	[unqualified]**	R	Backing store for AdjustmentReason	AdjustmentReason
ADP_EMPLOYEE	Oracle	[unqualified]**	R	Backing store for Employee, accessed via non-identifier navigation from AttorneyProfile, CreditRepUser, WriteOffApprovalUser, and EmployeeAuthorityLimit/EmployeeAuthorityPaymentLimitHistory, and directly via IUnitOfWork.GetRepository<Employee>()	Employee
ADP_EMPLOYEE_FEED	Oracle	[unqualified]**	R	Backing store for AdpEmployeeFeed	AdpEmployeeFeed
AGENCY	Oracle	[unqualified]**	R	Backing store for Agency	Agency
AGENCY_PAPERLESS_UPDATE_VIEW	Oracle	[unqualified]**	R	Backing store for AgencyPaperless	AgencyPaperless
AGENT	Oracle	[unqualified]**	R	Backing store for Agent	Agent
APP_ERROR	Oracle	[unqualified]**	R	Backing store for ErrorLog	ErrorLog
ATTORNEY_PROFILE	Oracle	[unqualified]**	R	Backing store for AttorneyProfile	AttorneyProfile
AUTO_IMPORT_INDEX_DEFAULTS	Oracle	[unqualified]**	R	Backing store for AutoImportIndexDefaults	AutoImportIndexDefaults
BATCH_PROCESS_LOG	Oracle	[unqualified]**	C/R/U	Backing store for BatchProcessLog	BatchProcessLog
BILL_SERVICE_CODE	Oracle	[unqualified]**	R	Backing store for BillService	BillService
BILL_SERVICE_FEE	Oracle	[unqualified]**	R	Backing store for BillServiceFee	BillServiceFee
BILL_SERVICE_RATE_TYPE_CODE	Oracle	[unqualified]**	R	Backing store for BillServiceRateType	BillServiceRateType
BILL_STATUS_CODE	Oracle	[unqualified]**	R	Backing store for BillStatus	BillStatus
CANCELLATION	Oracle	[unqualified]**	R	Backing store for Cancellation	Cancellation
CASE_NOTE	Oracle	LEGAL	C/R/D	Backing store for LegalNote	LegalNote
CBP_AUDIT	Oracle	[unqualified]**	R	Backing store for CbpAudit, reached via non-identifier navigation from CbpAuditedService/CbpBill	CbpAudit
CBP_AUDITED_SERVICE	Oracle	[unqualified]**	R	Backing store for CbpAuditedService	CbpAuditedService
CBP_AUTHORIZATION	Oracle	[unqualified]**	C/R/D	Backing store for CbpAuthorization	CbpAuthorization
CBP_AUTHORIZATION_SURGERY	Oracle	[unqualified]**	C/R/D	Backing store for CbpAuthorizationSurgery	CbpAuthorizationSurgery
CBP_AUTHORIZATION_TYPE_CODE	Oracle	[unqualified]**	R	Backing store for CbpAuthorizationTypeCode	CbpAuthorizationTypeCode
CBP_BILL	Oracle	[unqualified]**	C/R	Backing store for CbpBill	CbpBill
CBP_BILL_ENTRY_SOURCE_CODE	Oracle	[unqualified]**	R	Backing store for CbpBillEntrySourceCode	CbpBillEntrySourceCode
CBP_BILL_SERVICE	Oracle	[unqualified]**	R	Backing store for CbpBillService	CbpBillService
CBP_BILL_STATUS_CODE	Oracle	[unqualified]**	R	Backing store for CbpBillStatusCode	CbpBillStatusCode
CBP_BILL_TYPE_CODE	Oracle	[unqualified]**	R	Backing store for CbpBillTypeCode	CbpBillTypeCode
CBP_DIAGNOSIS	Oracle	[unqualified]**	C/R/U	Backing store for CbpDiagnosis	CbpDiagnosis
CBP_DIAGNOSIS_TYPE_CODE	Oracle	[unqualified]**	R	Backing store for CbpDiagnosisTypeCode	CbpDiagnosisTypeCode
CBP_NOTE	Oracle	[unqualified]**	R	Backing store for CbpNote	CbpNote
CBP_NOTE_CATEGORY_CODE	Oracle	[unqualified]**	R	Backing store for CbpNoteCategoryCode	CbpNoteCategoryCode
CBP_NOTE_TYPE_CODE	Oracle	[unqualified]**	R	Backing store for CbpNoteTypeCode, reached via non-identifier navigation from CbpNote	CbpNoteTypeCode
CBP_PRESCRIBING_PROVIDER_CODE	Oracle	[unqualified]**	R	Backing store for CbpPrescribingProviderCode	CbpPrescribingProviderCode
CBP_PRIMARY_PROCEDURE_CODE	Oracle	[unqualified]**	R	Backing store for CbpPrimaryProcedureCode	CbpPrimaryProcedureCode
CBP_PROCEDURE_CODE	Oracle	[unqualified]**	C/R/U	Backing store for CbpProcedureCode	CbpProcedureCode
CBP_SERVICE_CODE	Oracle	[unqualified]**	C/R/U	Backing store for CbpServiceCode, CbpServiceCodeStateless	CbpServiceCode, CbpServiceCodeStateless
CBP_SERVICE_DESCRIPTION	Oracle	[unqualified]**	C/U	Backing store for CbpServiceDescriptionStateless	CbpServiceDescriptionStateless
CBP_SERVICE_PM_GROUP_CODE	Oracle	[unqualified]**	R	Backing store for CbpServicePmGroupCode	CbpServicePmGroupCode
CERTIFICATE_DETAIL	Oracle	[unqualified]**	C/R/D	Backing store for Certificate	Certificate
CERTIFICATE_OTHER_COV_CODE	Oracle	[unqualified]**	R	Backing store for StandardOtherCoverageText	StandardOtherCoverageText
CERTIFICATE_PREFERENCE	Oracle	[unqualified]**	C/R	Backing store for CertificatePreference	CertificatePreference
CLAIM_ACTIVITY	Oracle	[unqualified]**	C/R/D	Backing store for ClaimNote	ClaimNote
CLAIM_ACTIVITY_CATEGORY_CODE	Oracle	[unqualified]**	R	Backing store for ClaimNoteCategory	ClaimNoteCategory
CLAIM_ACTIVITY_TYPE_CODE	Oracle	[unqualified]**	R	Backing store for ClaimNoteType	ClaimNoteType
CLAIM_TASK_GROUP_CODE	Oracle	[unqualified]**	R	Backing store for TaskGroup	TaskGroup
CL_CLAIM_AUTH_PURPOSE_CODE	Oracle	[unqualified]**	R	Backing store for AuthorityPaymentApprovalTypeCode	AuthorityPaymentApprovalTypeCode
CL_CLAIM_BUS_FUNCTION_CODE	Oracle	[unqualified]**	R	Backing store for AuthorityPaymentTypeCode	AuthorityPaymentTypeCode
CL_CLAIM_BUS_PROCESS_CODE	Oracle	[unqualified]**	R	Backing store for AuthorityBusinessProcessCode	AuthorityBusinessProcessCode
CL_CLAIM_EMP_BUS_FUNC_LIMIT	Oracle	[unqualified]**	C/R/D	Backing store for EmployeeAuthorityLimit	EmployeeAuthorityLimit
CL_CLAIM_EMP_BUS_FUNC_LIM_HIST	Oracle	[unqualified]**	C/R	Backing store for EmployeeAuthorityPaymentLimitHistory	EmployeeAuthorityPaymentLimitHistory
CL_HOSTILE_WORKER_CODE	Oracle	[unqualified]**	R	Backing store for HostileWorkerCode	HostileWorkerCode
CL_INJURY_CLAIM	Oracle	[unqualified]**	R	Backing store for InjuryClaim	InjuryClaim
CL_PAYMENT_SPCL_HANDLING_CODE	Oracle	[unqualified]**	R	Backing store for SpecialHandlingCode	SpecialHandlingCode
CL_PHARMACY_DAW_CODE	Oracle	[unqualified]**	R	Backing store for PharmacyDispenseAsWrittenCode	PharmacyDispenseAsWrittenCode
CL_PHARMACY_ELIGIBILITY_REPORT	Oracle	[unqualified]**	R/U	Backing store for PharmacyEligibilityReport	PharmacyEligibilityReport
CL_PHARMACY_ELIG_STATUS_CODE	Oracle	[unqualified]**	R	Backing store for PharmacyEligibilityStatusCode	PharmacyEligibilityStatusCode
CL_SECURITY_OVERRIDE	Oracle	[unqualified]**	C/R/D	Backing store for SecurityOverride	SecurityOverride
COMPANY	Oracle	[unqualified]**	R	Referenced via native SQL join in InvestigationRepositoryExtensions.GetSubjectName (no NHibernate ClassMap; accessed only through hand-written CreateSqlQuery text)	FraudInvestigationService
CONTEXT_CODE	Oracle	[unqualified]**	R	Backing store for ContextCode	ContextCode
COUNTY	Oracle	[unqualified]**	R	Backing store for County	County
CREDIT_REP_USER	Oracle	[unqualified]**	R	Backing store for CreditRepUser	CreditRepUser
CSGSEV_CLM_SGMNTN_ACTIONS_SENT	Oracle	[unqualified]**	R	Backing store for ClaimSeverityModelActivity	ClaimSeverityModelActivity
DCBS_OREGON_BUSINESS	Oracle	WCIS_DBA (explicit qualifier in Table())	C	Backing store for OregonBusiness	OregonBusiness
DEPT_REVENUE_SOIL_ADJUSTMENT	Oracle	[unqualified]**	R	Backing store for DeptRevenueSoilAdjustment	DeptRevenueSoilAdjustment
DEPT_REVENUE_SOIL_BALANCE	Oracle	[unqualified]**	C	Backing store for DeptRevenueSoilBalance	DeptRevenueSoilBalance
DOCUMENT_DISTRIBUTION_LOG	Oracle	[unqualified]**	C/R/D	Backing store for DocumentDistributionLog, DocumentDistributionLogRequest, DocumentDistributionLogStatusOnly	DocumentDistributionLog, DocumentDistributionLogRequest, DocumentDistributionLogStatusOnly
DOCUMENT_IMAGING_ERROR	Oracle	CLM_DBA	C/R/D	Backing store for DocumentImagingError	DocumentImagingError
DOCUMENT_OPTION_CODE	Oracle	[unqualified]**	R	Backing store for DocumentOptionCode	DocumentOptionCode
DOCUMENT_OP_CODE	Oracle	[unqualified]**	R	Backing store for DocumentOutputProfileCode	DocumentOutputProfileCode
DOCUMENT_REQUEST_LOG	Oracle	[unqualified]**	C/R/D	Backing store for DocumentRequestLog	DocumentRequestLog
DOCUMENT_TEMPLATE	Oracle	[unqualified]**	C/R/D	Backing store for DocumentTemplate	DocumentTemplate
DOCUMENT_TEMPLATE_OP	Oracle	[unqualified]**	C/R/D	Backing store for DocumentTemplateOutputProfile	DocumentTemplateOutputProfile
DOCUMENT_TEMPLATE_OPTION	Oracle	[unqualified]**	C/R/D	Backing store for DocumentTemplateOption	DocumentTemplateOption
DOC_REQUEST_LOG_STATUS_CODE	Oracle	[unqualified]**	R	Backing store for DocRequestLogStatusCode	DocRequestLogStatusCode
DocumentImageTypeCode	Oracle	[unqualified]**	R	Backing store for DocumentImageTypeCode, accessed via IUnitOfWork.GetRepository<T>(); the backing table name itself could not be confirmed by static analysis or Legends — the C# entity name is used in its place per the translation skill's "never invent a table name" rule	DocumentImageTypeCode
DocumentRequestParameter	Oracle	[unqualified]**	C/R	Backing store for DocumentRequestParameter, accessed via IUnitOfWork.GetRepository<T>(); no ClassMap exists in this repository or the external mapping package queried via Legends, so the backing table name is unconfirmed and the C# entity name is used in its place	DocumentRequestParameter
DocumentTemplateParameter	Oracle	[unqualified]**	R	Backing store for DocumentTemplateParameter, accessed via IUnitOfWork.GetRepository<T>(); no ClassMap exists in this repository or the external mapping package queried via Legends, so the backing table name is unconfirmed and the C# entity name is used in its place	DocumentTemplateParameter
EBILL_INVOICE	Oracle	[unqualified]**	C/D	Backing store for EbillInvoice	EbillInvoice
EBILL_INVOICE_BILL	Oracle	[unqualified]**	D	Backing store for EbillInvoiceBill	EbillInvoiceBill
EBILL_INVOICE_ERROR	Oracle	[unqualified]**	D	Backing store for EbillInvoiceError	EbillInvoiceError
EDI_AUDITED_SERVICE_OVERRIDE	Oracle	[unqualified]**	C/R/D	Backing store for AuditedServiceOverride	AuditedServiceOverride
EDI_BILL_OVERRIDE	Oracle	[unqualified]**	C/R/D	Backing store for BillOverride	BillOverride
EDI_FILE	Oracle	OPS$JIMMIL	C/R/D	Backing store for EdiFile	EdiFile
EMPLOYERS_LIABILITY_FACTORS	Oracle	[unqualified]**	R	Backing store for EmployerLiabilityFactors	EmployerLiabilityFactors
EMPLOYERS_LIABILITY_LIMITS	Oracle	[unqualified]**	R	Backing store for EmployerLiabilityLimit	EmployerLiabilityLimit
ERROR_ENVIRONMENT	Oracle	[unqualified]**	R	Backing store for ErrorEnvironment	ErrorEnvironment
ERROR_GROUP_CODE	Oracle	[unqualified]**	R	Backing store for ErrorGroupCode	ErrorGroupCode
ERROR_GROUP_ENVIRONMENT	Oracle	[unqualified]**	R	Backing store for ErrorGroupEnvironment	ErrorGroupEnvironment
EXT_USER_DOC_NOTIFY	Oracle	[unqualified]**	C/R/D	Backing store for DocumentNotification	DocumentNotification
FILE_REQUEST	Oracle	[unqualified]**	R	Backing store for FileRequest	FileRequest
GROUP_ASSOCIATION	Oracle	[unqualified]**	R	Backing store for GroupAssociation	GroupAssociation
HEARING_LOCATION	Oracle	[unqualified]**	R	Backing store for HearingLocation	HearingLocation
IMAGE	Oracle	[unqualified]**	R	Backing store for Image, accessed via IUnitOfWork.GetRepository<T>()	Image
IMAGE_AGENCY	Oracle	[unqualified]**	C/R	Backing store for ImageAgency	ImageAgency
IMAGE_CATEGORY_CODE	Oracle	[unqualified]**	R	Backing store for ImageCategoryCode, accessed via IUnitOfWork.GetRepository<T>()	ImageCategoryCode
IMAGE_DOCUMENT_TYPE_CODE	Oracle	[unqualified]**	R	Backing store for ImageDocumentTypeCode, accessed via IUnitOfWork.GetRepository<T>()	ImageDocumentTypeCode
INTEREST_CALC_OPTION_CODE	Oracle	[unqualified]**	R	Backing store for InterestCalcCode	InterestCalcCode
INTEREST_RATE_VALUE	Oracle	[unqualified]**	R	Backing store for InterestRateValue	InterestRateValue
INVESTIGATION	Oracle	[unqualified]**	R	Backing store for Investigation	Investigation
JUDGEMENT_YEARS_VALUE	Oracle	[unqualified]**	R	Backing store for JudgmentYearsValue	JudgmentYearsValue
JUDGMENT_CODE	Oracle	[unqualified]**	R	Backing store for JudgmentCode	JudgmentCode
LC_POLICY_SERVICE_PLAN	Oracle	[unqualified]**	C/R/U	Backing store for RctPolicyServicePlan	RctPolicyServicePlan
LC_SERVICE_PLAN_CODE	Oracle	[unqualified]**	R	Backing store for RctServicePlanCode	RctServicePlanCode
LC_TRAN_CATEGORY_CODE	Oracle	[unqualified]**	R	Backing store for TransactionCategoryCode	TransactionCategoryCode
LEGAL_BILL	Oracle	[unqualified]**	C/R/D	Backing store for LegalBill	LegalBill
LEGAL_BILL_SERVICE	Oracle	[unqualified]**	R	Backing store for LegalBillService	LegalBillService
LEGAL_CASE	Oracle	[unqualified]**	R	Backing store for LegalCase	LegalCase
LEGAL_COLLECTION	Oracle	[unqualified]**	C/R	Backing store for Case	Case
LEGAL_COLLECTION_ACTIVITY	Oracle	[unqualified]**	R/D	Backing store for Activity	Activity
LEGAL_COLLECTION_BATCH_CONTROL	Oracle	[unqualified]**	R	Backing store for BatchControl	BatchControl
LEGAL_COLLECTION_CASH_RECEIPTS	Oracle	[unqualified]**	R	Backing store for CashReceipts	CashReceipts
LEGAL_COLLECTION_CODE	Oracle	[unqualified]**	R	Backing store for CollectionCode	CollectionCode
LEGAL_COLLECTION_DEBTOR	Oracle	[unqualified]**	C/R/D	Backing store for Debtor	Debtor
LEGAL_COLLECTION_NOTE	Oracle	[unqualified]**	C/R/D	Backing store for Note	Note
LEGAL_COLLECTION_PAYMENT_REF	Oracle	[unqualified]**	R	Backing store for PaymentRef	PaymentRef
LEGAL_COLLECTION_STATUS_CODE	Oracle	[unqualified]**	R	Backing store for StatusCode	StatusCode
LEGAL_COLLECTION_TRANSACTION	Oracle	[unqualified]**	C/R/D	Backing store for Transaction	Transaction
LEGAL_COLLECTION_TRAN_CODE	Oracle	[unqualified]**	R	Backing store for TransactionCode	TransactionCode
LEGAL_COLL_ACTIVITY_CODE	Oracle	[unqualified]**	R	Backing store for ActivityCode	ActivityCode
LEGAL_PERSON	Oracle	[unqualified]**	C	Backing store for LegalPerson	LegalPerson
LOCATION	Oracle	[unqualified]**	C/R/D	Backing store for Location	Location
MEDICARE_BENEFICIARY_QUERY	Oracle	[unqualified]**	D	Backing store for MedicareBeneficiaryQuery	MedicareBeneficiaryQuery
MEDICARE_BENEFICIARY_QUERY_BAT	Oracle	[unqualified]**	D	Backing store for MedicareBeneficiaryQueryBatch	MedicareBeneficiaryQueryBatch
MEDICARE_QUERY_HISTORY	Oracle	[unqualified]**	C/U	Backing store for MedicareQueryHistory	MedicareQueryHistory
NOTE_CATEGORY_CODE	Oracle	[unqualified]**	R	Backing store for LegalNoteCategory	LegalNoteCategory
OB_DOC_TYPE	Oracle	[unqualified]**	R	Backing store for DocType, reached via non-identifier navigation from OnBaseNotificationRuleMatrix	OnBaseNotificationRuleMatrix
OB_NOTIFICATION_MATRIX	Oracle	[unqualified]**	R	Backing store for NotificationMatrix, reached via non-identifier navigation from OnBaseNotificationRuleMatrix	OnBaseNotificationRuleMatrix
OB_NOTIFY_RULE_MATRX_X	Oracle	[unqualified]**	R	Backing store for OnBaseNotificationRuleMatrix	OnBaseNotificationRuleMatrix
OFFICE_CODE	Oracle	[unqualified]**	R	Backing store for OfficeCode	OfficeCode
ONLINE_MESSAGE	Oracle	[unqualified]**	R	Backing store for OnlineMessages	OnlineMessages
ONLINE_MESSAGE_APP_CODE	Oracle	[unqualified]**	R	Backing store for ApplicationCode	ApplicationCode
ONLINE_MESSAGE_PRIORITY_CODE	Oracle	[unqualified]**	R	Backing store for OnlineMessagePriority	OnlineMessagePriority
ONLINE_USER_TYPE_CODE	Oracle	[unqualified]**	R	Backing store for OnlineUserType	OnlineUserType
OSC_POLICY_PERIOD	Oracle	[unqualified]**	R	Backing store for OtherStatesPolicyPeriod	OtherStatesPolicyPeriod
OSC_POLICY_VIEW	Oracle	[unqualified]**	R	Backing store for OtherStatesPolicy	OtherStatesPolicy
OUTPUT_DOCUMENT	Oracle	[unqualified]**	R	Backing store for OutputDocument	OutputDocument
OUTPUT_DOCUMENT_TYPE_CODE	Oracle	[unqualified]**	R	Backing store for OutputDocumentTypeCode, OutputDocumentTypeCodeStateless	OutputDocumentTypeCode, OutputDocumentTypeCodeStateless
OUTPUT_DOC_NOTIFY_TEXT_CODE	Oracle	[unqualified]**	R	Backing store for OutputDocumentNotifyTextCode	OutputDocumentNotifyTextCode
OUTPUT_LOG	Oracle	[unqualified]**	R	Backing store for OutputLog	OutputLog
PAYMENT_TRANSACTION_TYPE_CODE	Oracle	[unqualified]**	R	Backing store for PaymentTransactionTypeCode	PaymentTransactionTypeCode
PERSON	Oracle	[unqualified]**	R	Referenced via native SQL join in InvestigationRepositoryExtensions.GetSubjectName (no NHibernate ClassMap; accessed only through hand-written CreateSqlQuery text)	FraudInvestigationService
POLICY	Oracle	[unqualified]**	R	Backing store for Policy	Policy
POLICY_OUTPUT_DOCUMENT	Oracle	[unqualified]**	C/R	Backing store for PolicyOutputDocument	PolicyOutputDocument
POLICY_PERIOD_COVERAGE_BIND	Oracle	[unqualified]**	R	Backing store for PolicyPeriodCoverageBind	PolicyPeriodCoverageBind
POLICY_RELATIONSHIP	Oracle	[unqualified]**	R	Backing store for PolicyRelationship	PolicyRelationship
POLICY_TEAM_FUNCTION	Oracle	[unqualified]**	R	Backing store for PolicyTeamFunction	PolicyTeamFunction
POSITIVE_PAY_VIEW	Oracle	WCIS_DBA (explicit qualifier in Table())	R	Backing store for PositivePayView	PositivePayView
PROCESS_SERVER	Oracle	[unqualified]**	R	Backing store for ProcessServer	ProcessServer
PROVIDER_ADDRESS	Oracle	[unqualified]**	C/R/U/D	Backing store for BatchProviderAddress	BatchProviderAddress
PROVIDER_LOCATION	Oracle	[unqualified]**	R	Backing store for ProviderLocation	ProviderLocation
PURCHASEORDERCOMMENTS	Oracle	[unqualified]**	R	Backing store for PurchaseOrderComment	PurchaseOrderComment
PURCHASEORDERLINECOMMENTS	Oracle	INFR_DBA (explicit qualifier in Table())	R	Backing store for PurchaseOrderLineComment	PurchaseOrderLineComment
PURCHASEORDERSVIEW	Oracle	[unqualified]**	R	Backing store for PurchaseOrder	PurchaseOrder
RCT_POLICIES_TO_TRANSMIT	Oracle	[unqualified]**	C/R/U/D	Backing store for RctPolicyToTransmit	RctPolicyToTransmit
RCT_POLICY_SELECTED	Oracle	[unqualified]**	C/R/U	Backing store for RctPolicySelected	RctPolicySelected
RCT_STAGING_POLICY	Oracle	[unqualified]**	C/R/D	Backing store for RctPolicyStagingData	RctPolicyStagingData
RCT_STAGING_POLICY_LOCATION	Oracle	[unqualified]**	C/R/D	Backing store for RctLocationStagingData	RctLocationStagingData
REGISTERED_AGENT	Oracle	[unqualified]**	R	Backing store for RegisteredAgent	RegisteredAgent
RTW_CASE	Oracle	[unqualified]**	R	Backing store for RTWCase	RTWCase
RTW_LOAD_ASSIGNMENT	Oracle	[unqualified]**	R	Backing store for RtwLoadAssignment	RtwLoadAssignment
RUN_TYPE_CODE	Oracle	[unqualified]**	R	Backing store for RunTypeCode	RunTypeCode
SUBJECT	Oracle	[unqualified]**	R	Referenced via native SQL join in InvestigationRepositoryExtensions.GetSubjectName/GetClaimId (no NHibernate ClassMap; accessed only through hand-written CreateSqlQuery text)	FraudInvestigationService
SUBPOENA	Oracle	[unqualified]**	C/R/D	Backing store for Subpoena	Subpoena
SUBPOENA_RECIPIENT	Oracle	[unqualified]**	R	Backing store for Recipient	Recipient
SUBPOENA_SPECIAL_HANDLING_CODE	Oracle	[unqualified]**	R	Backing store for SubpoenaSpecialHandling	SubpoenaSpecialHandling
SUBPOENA_STATUS_CODE	Oracle	[unqualified]**	R	Backing store for SubpoenaStatus	SubpoenaStatus
SUBPOENA_TYPE_CODE	Oracle	[unqualified]**	R	Backing store for SubpoenaType	SubpoenaType
SYSTEM_USER	Oracle	[unqualified]**	R	Backing store for SystemUser	SystemUser
SYSTEM_USER_XREF	Oracle	[unqualified]**	R	Backing store for SystemUserRef	SystemUserRef
TASK	Oracle	[unqualified]**	C/R	Backing store for Task	Task
TASK_ACTION_CODE	Oracle	[unqualified]**	R	Backing store for TaskAction	TaskAction
TASK_CATEGORY_CODE	Oracle	[unqualified]**	R	Backing store for TaskCategory	TaskCategory
TASK_PRIORITY_CODE	Oracle	[unqualified]**	R	Backing store for TaskPriority	TaskPriority
TASK_SOURCE_CODE	Oracle	[unqualified]**	R	Backing store for TaskSource	TaskSource
TEMP_DATA_PERSON_ADDRESS	Oracle	CLM_DBA (explicit qualifier in Table())	C/R/D	Backing store for TempDataPersonAddress	TempDataPersonAddress
THRDPARTY	Oracle	[unqualified]**	R	Backing store for ThirdParty	ThirdParty
THRDPARTY_CASE	Oracle	[unqualified]**	R	Backing store for ThirdPartyCase	ThirdPartyCase
TRADING_AS	Oracle	[unqualified]**	R	Backing store for TradingAs	TradingAs
USER_PREFERENCE	Oracle	[unqualified]**	C	Backing store for Preference, accessed via IUnitOfWork.GetRepository<T>()	Preference
WCIS_EMPLOYEE	Oracle	[unqualified]**	R	Backing store for WcisEmployee, accessed via IUnitOfWork.GetRepository<T>()	WcisEmployee
WRITEOFF_APPROVAL_USER	Oracle	[unqualified]**	R	Backing store for WriteOffApprovalUser	WriteOffApprovalUser
XDEFERRED_PRINT	Oracle	[unqualified]**	R	Backing store for XDeferredPrint	XDeferredPrint
XDOCUMENT	Oracle	[unqualified]**	C	Backing store for XDocument, accessed via IUnitOfWork.GetRepository<T>()	XDocument
XPRINT_CONTROL	Oracle	[unqualified]**	C	Backing store for XPrintControl, accessed via IUnitOfWork.GetRepository<T>()	XPrintControl

ADJUSTMENT_REASON_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for AdjustmentReason, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_BILL_SERVICE
Business objects	AdjustmentReason

SQL referencing ADJUSTMENT_REASON_CODE

• SQL-072: SaveBillServices
• SQL-073: ListOfAdjustmentReasons (property)

---

ADP_EMPLOYEE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Employee, accessed via non-identifier navigation from AttorneyProfile, CreditRepUser, WriteOffApprovalUser, and EmployeeAuthorityLimit/EmployeeAuthorityPaymentLimitHistory, and directly via IUnitOfWork.GetRepository<Employee>()
Access pattern	NHibernate ORM (external EmployeeMap in SAIF.Framework.Data.NHibernate) — table name confirmed via Legends CLI; most column mappings unresolved
CRUD operations	Read
Key columns used	EMPLID, RPT_MGR_EMPLID (confirmed); remaining columns unresolved — see linked SQL documents**
Sequence	N/A
Related tables	None identified
Business objects	Employee

SQL referencing ADP_EMPLOYEE

• SQL-084: LegalAttorneyList (property)
• SQL-150: GetCreditReps
• SQL-174: IsActiveEmployeeUserId
• SQL-175: GetApproverMailId
• SQL-176: GetPendingBills, LegalSupportEmployeeList
• SQL-177: GetTerminatedAuthorities
• SQL-178: HasSecurityOverride
• SQL-179: SetAdditionalProperties, CreateOverride
• SQL-180: ValidateMailId
• SQL-181: GenerateRecipientCashRequest, SetAttorneyInfo, SetCurrentUserValues
• SQL-182: GetApproverEmailAddress, InitializeLabel
• SQL-183: GetApproverMailId
• SQL-184: GetInboxItems, InitiateEmployeeList
• SQL-186: AddEditAuthorityLimit, GetAuthorityLimits, GetExpiredAuthorities, GetTerminatedAuthorities, TryGetEmployeeAuthorityLimit
• SQL-347: GetWriteOffApprovalUsers

---

ADP_EMPLOYEE_FEED

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for AdpEmployeeFeed, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	AdpEmployeeFeed

SQL referencing ADP_EMPLOYEE_FEED

• SQL-074: ExtractUsers

---

AGENCY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Agency, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	AGENCY_SEQ
Related tables	AGENCY_CONTRACT, AGENT, EXT_USER_DOC_NOTIFY, IMAGE_AGENCY, TEAM_FUNCTION_AGENCY
Business objects	Agency

SQL referencing AGENCY

• SQL-075: AgencyQuery (property)
• SQL-076: GetAgency
• SQL-077: GenerateDirectWriterNotifications

---

AGENCY_PAPERLESS_UPDATE_VIEW

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for AgencyPaperless, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	AGENCY_SEQ
Related tables	None identified
Business objects	AgencyPaperless

SQL referencing AGENCY_PAPERLESS_UPDATE_VIEW

• SQL-078: AgencyPaperlessQuery (property)

---

AGENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Agent, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	AGENCY, LOCATION, OSC_POLICY_VIEW, POLICY
Business objects	Agent

SQL referencing AGENT

• SQL-079: ProducerQuery (property)
• SQL-080: GetAgentData
• SQL-081: AgencyBookList (property), GetAgencyIdForProducer

---

APP_ERROR

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ErrorLog, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	ErrorLog

SQL referencing APP_ERROR

• SQL-195: ApplicationNames (property), GetErrorLogEntry, GetErrorLogs

---

ATTORNEY_PROFILE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for AttorneyProfile, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	AttorneyProfile

SQL referencing ATTORNEY_PROFILE

• SQL-083: GetAttorneysWithPendingLegalBills
• SQL-084: LegalAttorneyList (property)
• SQL-085: SetAttorneyInfo

---

AUTO_IMPORT_INDEX_DEFAULTS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for AutoImportIndexDefaults, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	AutoImportIndexDefaults

SQL referencing AUTO_IMPORT_INDEX_DEFAULTS

• SQL-090: GenerateIdxFile

---

BATCH_PROCESS_LOG

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for BatchProcessLog, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Update
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	BatchProcessLog

SQL referencing BATCH_PROCESS_LOG

• SQL-002: UpdateRunDate
• SQL-092: GetSingleRecord
• SQL-349: UpdateRunDate

---

BILL_SERVICE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for BillService, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_BILL_SERVICE
Business objects	BillService

SQL referencing BILL_SERVICE_CODE

• SQL-095: SaveBillServices
• SQL-096: ListOfBillServiceCodes (property)
• SQL-097: GetSpendCategory

---

BILL_SERVICE_FEE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for BillServiceFee, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	BillServiceFee

SQL referencing BILL_SERVICE_FEE

• SQL-098: GetBillServiceFee
• SQL-099: GetImeBillServiceFees, GetMcoBillServiceFees

---

BILL_SERVICE_RATE_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for BillServiceRateType, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_BILL_SERVICE
Business objects	BillServiceRateType

SQL referencing BILL_SERVICE_RATE_TYPE_CODE

• SQL-100: SaveBillServices
• SQL-101: ListOfBillRateTypeCodes (property)

---

BILL_STATUS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for BillStatus, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_BILL
Business objects	BillStatus

SQL referencing BILL_STATUS_CODE

• SQL-102: SetNewBillStatus
• SQL-103: SaveLegalBill
• SQL-104: ListOfBillStatusCodes (property)

---

CANCELLATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Cancellation, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	Cancellation

SQL referencing CANCELLATION

• SQL-105: GetPendingCancelDateForPolicy

---

CASE_NOTE

Field	Value
Database	Oracle
Schema/Link	LEGAL
Purpose	Backing store for LegalNote, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	CASE_NOTE_SEQ
Related tables	LEGAL_CASE, NOTE_CATEGORY_CODE
Business objects	LegalNote

SQL referencing CASE_NOTE

• SQL-034: CreateNote
• SQL-035: CreateTaskNote
• SQL-228: DeleteNote, GetNoteData, GetNotes
• SQL-383: DeleteNote

---

CBP_AUDIT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpAudit, reached via non-identifier navigation from CbpAuditedService/CbpBill
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	BILL_ID
Sequence	N/A
Related tables	None identified
Business objects	CbpAudit

SQL referencing CBP_AUDIT

• SQL-111: GetBillAmounts
• SQL-117: GetBillAmounts

---

CBP_AUDITED_SERVICE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpAuditedService, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CBP_AUDITED_SERVICE_ADJUSTMENT, CBP_BILL, CBP_ORIGINAL_BILL_CODE, CL_PAYMENT_CATEGORY_CODE, EBILL_EOB_ADJUSTMENT, EBILL_EOB_REMITTANCE_ADVICE, PROVIDER_LOCATION
Business objects	CbpAuditedService

SQL referencing CBP_AUDITED_SERVICE

• SQL-111: GetBillAmounts

---

CBP_AUTHORIZATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpAuthorization, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	CBP_AUTHORIZATION_SEQ
Related tables	CBP_AUTHORIZATION_CPT, CBP_AUTHORIZATION_TYPE_CODE, CBP_SERVICE_PM_GROUP_CODE, PROVIDER_LOCATION
Business objects	CbpAuthorization

SQL referencing CBP_AUTHORIZATION

• SQL-006: CreateAuthorization
• SQL-112: DeleteAuthorization, GetAuthorizations, UpdateAuthorization
• SQL-364: DeleteAuthorization

---

CBP_AUTHORIZATION_SURGERY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpAuthorizationSurgery, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	CbpAuthorizationSurgery

SQL referencing CBP_AUTHORIZATION_SURGERY

• SQL-007: AddSurgeryDate
• SQL-113: AddSurgeryDate, DeleteSurgeryDate, GetSurgeryDates
• SQL-365: DeleteSurgeryDate

---

CBP_AUTHORIZATION_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpAuthorizationTypeCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CBP_AUTHORIZATION
Business objects	CbpAuthorizationTypeCode

SQL referencing CBP_AUTHORIZATION_TYPE_CODE

• SQL-114: CreateAuthorization, GetAuthorizationTypeCodes, UpdateAuthorization

---

CBP_BILL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpBill, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	CBP_BILL_SEQ
Related tables	CBP_AUDIT, CBP_AUDITED_SERVICE, CBP_BILL_DIAGNOSIS, CBP_BILL_ENTRY_SOURCE_CODE, CBP_BILL_PROCEDURE, CBP_BILL_SERVICE, CBP_BILL_STATUS, CBP_BILL_STATUS_CODE, CBP_BILL_TYPE_CODE, CBP_NOTE, PROVIDER_LOCATION
Business objects	CbpBill

SQL referencing CBP_BILL

• SQL-008: BuildNewBillRecord, SaveBill
• SQL-115: CheckForDuplicateBill, GetInboxBillsByResponsiblePartyId, SaveBill, UpdateBillStatus
• SQL-116: GetBillEntryBillsByCriteria, SearchByCriteria, SearchByResponsiblePartyId
• SQL-117: GetBillAmounts

---

CBP_BILL_ENTRY_SOURCE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpBillEntrySourceCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CBP_BILL
Business objects	CbpBillEntrySourceCode

SQL referencing CBP_BILL_ENTRY_SOURCE_CODE

• SQL-118: CreateNewBill

---

CBP_BILL_SERVICE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpBillService, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CBP_BILL, CBP_MSRP_INVOICE_CODE, CL_PHARMACY_DAW_CODE, PROVIDER_LOCATION
Business objects	CbpBillService

SQL referencing CBP_BILL_SERVICE

• SQL-119: SubmitBill
• SQL-120: GetChargedServicesTotal, GetServices

---

CBP_BILL_STATUS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpBillStatusCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CBP_BILL
Business objects	CbpBillStatusCode

SQL referencing CBP_BILL_STATUS_CODE

• SQL-121: CreateNewBill, GetBillStatusCodes, UpdateBillStatus
• SQL-122: GetBillStatusCodes

---

CBP_BILL_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpBillTypeCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CBP_BILL
Business objects	CbpBillTypeCode

SQL referencing CBP_BILL_TYPE_CODE

• SQL-123: CreateNewBill, GetBillTypeCodes, UpdateBillTypeAndServices
• SQL-124: GetBillTypes

---

CBP_DIAGNOSIS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpDiagnosis, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Update
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	CbpDiagnosis

SQL referencing CBP_DIAGNOSIS

• SQL-009: InsertDiagnosis
• SQL-125: GetBillDiagnosis
• SQL-126: QueryDiagnosis
• SQL-351: UpdateDiagnosis

---

CBP_DIAGNOSIS_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpDiagnosisTypeCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	CbpDiagnosisTypeCode

SQL referencing CBP_DIAGNOSIS_TYPE_CODE

• SQL-127: CreateDiagnoses, GetDiagnosisTypeCodes, UpdateDiagnoses

---

CBP_NOTE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpNote, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	CBP_NOTE_SEQ
Related tables	CBP_BILL, CBP_NOTE_TYPE_CODE
Business objects	CbpNote

SQL referencing CBP_NOTE

• SQL-128: GetBillNotes

---

CBP_NOTE_CATEGORY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpNoteCategoryCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CBP_NOTE_TYPE_CODE
Business objects	CbpNoteCategoryCode

SQL referencing CBP_NOTE_CATEGORY_CODE

• SQL-129: GetAuditNoteCategoryCodes

---

CBP_NOTE_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpNoteTypeCode, reached via non-identifier navigation from CbpNote
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	CODE, CBP_NOTE_CATEGORY_CODE
Sequence	N/A
Related tables	None identified
Business objects	CbpNoteTypeCode

SQL referencing CBP_NOTE_TYPE_CODE

• SQL-128: GetBillNotes

---

CBP_PRESCRIBING_PROVIDER_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpPrescribingProviderCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	CbpPrescribingProviderCode

SQL referencing CBP_PRESCRIBING_PROVIDER_CODE

• SQL-130: GetPrescribingPrescriberCodes

---

CBP_PRIMARY_PROCEDURE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpPrimaryProcedureCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	CbpPrimaryProcedureCode

SQL referencing CBP_PRIMARY_PROCEDURE_CODE

• SQL-131: CreateProcedures, GetPrimaryProcedureCodes, UpdateProcedures

---

CBP_PROCEDURE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpProcedureCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Update
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	CbpProcedureCode

SQL referencing CBP_PROCEDURE_CODE

• SQL-010: InsertProcedure
• SQL-132: QueryProcedure
• SQL-352: UpdateProcedure

---

CBP_SERVICE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpServiceCode, CbpServiceCodeStateless, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Update
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CBP_SERVICE_DESCRIPTION
Business objects	CbpServiceCode, CbpServiceCodeStateless

SQL referencing CBP_SERVICE_CODE

• SQL-011: InsertService
• SQL-133: ValidCptCode
• SQL-353: UpdateService

---

CBP_SERVICE_DESCRIPTION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpServiceDescriptionStateless, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Update
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CBP_SERVICE_CODE
Business objects	CbpServiceDescriptionStateless

SQL referencing CBP_SERVICE_DESCRIPTION

• SQL-012: InsertServiceDescription
• SQL-354: UpdateServiceDescription

---

CBP_SERVICE_PM_GROUP_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CbpServicePmGroupCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CBP_AUTHORIZATION
Business objects	CbpServicePmGroupCode

SQL referencing CBP_SERVICE_PM_GROUP_CODE

• SQL-134: CreateAuthorization, GetServiceTypeCodes, UpdateAuthorization

---

CERTIFICATE_DETAIL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Certificate, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	CERTIFICATE_SEQUENCE
Related tables	CERTIFICATE_HOLDER, EMPLOYERS_LIABILITY_LIMITS, OSC_POLICY_PERIOD, OSC_POLICY_VIEW, TRADING_AS
Business objects	Certificate

SQL referencing CERTIFICATE_DETAIL

• SQL-013: AddCertificate, RenewCertificate
• SQL-135: GetCertificateDataById, GetCertificates, GetCertificatesReadyForBatchDistribution, GetEditableCertificates
• SQL-136: MarkCertificateAsPrinted
• SQL-366: DeleteCertificate

---

CERTIFICATE_OTHER_COV_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for StandardOtherCoverageText, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	StandardOtherCoverageText

SQL referencing CERTIFICATE_OTHER_COV_CODE

• SQL-300: GetStandardOtherCoverageTexts

---

CERTIFICATE_PREFERENCE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CertificatePreference, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	CertificatePreference

SQL referencing CERTIFICATE_PREFERENCE

• SQL-014: AddPreference
• SQL-137: GetPreferenceByPolicyNumber, GetPreferences, HasPreference

---

CLAIM_ACTIVITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ClaimNote, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	CLAIM_ACTIVITY_SEQ
Related tables	CLAIM_ACTIVITY_CATEGORY_CODE, CLAIM_ACTIVITY_TYPE_CODE
Business objects	ClaimNote

SQL referencing CLAIM_ACTIVITY

• SQL-015: CreateNote
• SQL-016: CreateTaskNote
• SQL-017: CreateTaskNote
• SQL-138: DeleteNote, GetNoteData, GetNotes
• SQL-367: DeleteNote

---

CLAIM_ACTIVITY_CATEGORY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ClaimNoteCategory, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CLAIM_ACTIVITY, CLAIM_ACTIVITY_TYPE_CODE
Business objects	ClaimNoteCategory

SQL referencing CLAIM_ACTIVITY_CATEGORY_CODE

• SQL-139: CreateNote, GetCategories, GetCategoryDesc, SaveNote
• SQL-140: CreateTaskNote
• SQL-141: CreateTaskNote

---

CLAIM_ACTIVITY_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ClaimNoteType, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CLAIM_ACTIVITY, CLAIM_ACTIVITY_CATEGORY_CODE
Business objects	ClaimNoteType

SQL referencing CLAIM_ACTIVITY_TYPE_CODE

• SQL-142: CreateNote, GetNoteTypeDesc, GetTypes, SaveNote
• SQL-143: CreateTaskNote
• SQL-144: CreateTaskNote

---

CLAIM_TASK_GROUP_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for TaskGroup, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	TASK
Business objects	TaskGroup

SQL referencing CLAIM_TASK_GROUP_CODE

• SQL-330: GetTaskGroups
• SQL-331: CreateTask, CreateTaskStateless, GetTaskGroups, ReassignTasks, UpdateTask

---

CL_CLAIM_AUTH_PURPOSE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for AuthorityPaymentApprovalTypeCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CL_CLAIM_BUS_PROCESS_CODE
Business objects	AuthorityPaymentApprovalTypeCode

SQL referencing CL_CLAIM_AUTH_PURPOSE_CODE

• SQL-088: GetApprovalTypeList

---

CL_CLAIM_BUS_FUNCTION_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for AuthorityPaymentTypeCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CL_CLAIM_BUS_PROCESS_CODE, CL_CLAIM_EMP_BUS_FUNC_LIMIT, CL_CLAIM_EMP_BUS_FUNC_LIM_HIST
Business objects	AuthorityPaymentTypeCode

SQL referencing CL_CLAIM_BUS_FUNCTION_CODE

• SQL-089: CreateNewAuthorityLimitFromEdit, GetFunctionTypeList

---

CL_CLAIM_BUS_PROCESS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for AuthorityBusinessProcessCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CL_CLAIM_AUTH_PURPOSE_CODE, CL_CLAIM_BUS_FUNCTION_CODE, CL_CLAIM_EMP_BUS_FUNC_LIMIT, CL_CLAIM_EMP_BUS_FUNC_LIM_HIST
Business objects	AuthorityBusinessProcessCode

SQL referencing CL_CLAIM_BUS_PROCESS_CODE

• SQL-087: CreateNewAuthorityLimitFromEdit

---

CL_CLAIM_EMP_BUS_FUNC_LIMIT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for EmployeeAuthorityLimit, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	CL_CLM_EMP_BUS_FUN_LIM_SEQ
Related tables	CL_CLAIM_BUS_FUNCTION_CODE, CL_CLAIM_BUS_PROCESS_CODE
Business objects	EmployeeAuthorityLimit

SQL referencing CL_CLAIM_EMP_BUS_FUNC_LIMIT

• SQL-030: AddAuthorityLimit
• SQL-185: UserAuthorityLevel
• SQL-186: AddEditAuthorityLimit, GetAuthorityLimits, GetExpiredAuthorities, GetTerminatedAuthorities, TryGetEmployeeAuthorityLimit
• SQL-187: InitiateEmployeeList
• SQL-381: DeleteAuthority

---

CL_CLAIM_EMP_BUS_FUNC_LIM_HIST

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for EmployeeAuthorityPaymentLimitHistory, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	CL_CLM_EMPBUSFUNLIMHIST_SEQ
Related tables	CL_CLAIM_BUS_FUNCTION_CODE, CL_CLAIM_BUS_PROCESS_CODE
Business objects	EmployeeAuthorityPaymentLimitHistory

SQL referencing CL_CLAIM_EMP_BUS_FUNC_LIM_HIST

• SQL-031: AddLimitToHistory
• SQL-188: GetClaimAuthorityLimitHistory

---

CL_HOSTILE_WORKER_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for HostileWorkerCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CL_SECURITY_OVERRIDE
Business objects	HostileWorkerCode

SQL referencing CL_HOSTILE_WORKER_CODE

• SQL-203: CreateOverride

---

CL_INJURY_CLAIM

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for InjuryClaim, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	CLAIM_ID_SEQ
Related tables	ATTENDING_PHYSICIAN, BODY_SIDE_CODE, CLAIM_STATUS_CODE, CL_BODY_PART_CODE, CL_CLAIM_DISABILITY_ACTIVITY, CL_CLAIM_PERSON, CL_CLAIM_TYPE_CODE, CL_DCS_FULL_PART_CODE, CL_FEDERAL_INJURY_LOCATION_CD, CL_FORM_CODE, CL_INJURED_ON_PREMISES_CODE, CL_INJURY_EVENT_CODE, CL_INJURY_NATURE_CODE, CL_INJURY_SOURCE_CODE, CL_JURISDICTION_CODE, CL_MCO_STATUS_REASON_CODE, CL_MEDICAL_CONDITION, CL_OWCP_ADDRESS, CL_REQUEST_TYPE_CODE, COVERAGE_CODE, MCO_GSA_LOCATION, OCCUPATIONAL_DISEASE_CODE, VOCATIONAL_RESP_CODE
Business objects	InjuryClaim

SQL referencing CL_INJURY_CLAIM

• SQL-208: GetClaimWorkerName
• SQL-209: CreateTask, GetClaimId
• SQL-210: GetClaimData, IsValidClaim
• SQL-211: CreateTask, CreateTaskStateless, GetAdditionalInfoTask, GetClaimId, IsValidClaim, UpdateTask

---

CL_PAYMENT_SPCL_HANDLING_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for SpecialHandlingCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_BILL
Business objects	SpecialHandlingCode

SQL referencing CL_PAYMENT_SPCL_HANDLING_CODE

• SQL-298: SaveLegalBill
• SQL-299: SpecialHandlingCodeList (property)

---

CL_PHARMACY_DAW_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for PharmacyDispenseAsWrittenCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CBP_BILL_SERVICE
Business objects	PharmacyDispenseAsWrittenCode

SQL referencing CL_PHARMACY_DAW_CODE

• SQL-255: CreateService, UpdateService

---

CL_PHARMACY_ELIGIBILITY_REPORT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for PharmacyEligibilityReport, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read, Update
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CL_PHARMACY_ELIG_STATUS_CODE
Business objects	PharmacyEligibilityReport

SQL referencing CL_PHARMACY_ELIGIBILITY_REPORT

• SQL-256: GetEligibleClaims, GetFirstFillClaims
• SQL-356: UpdatePharmElig

---

CL_PHARMACY_ELIG_STATUS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for PharmacyEligibilityStatusCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CL_PHARMACY_ELIGIBILITY_REPORT
Business objects	PharmacyEligibilityStatusCode

SQL referencing CL_PHARMACY_ELIG_STATUS_CODE

• SQL-257: ProcessFirstFillReports, UpdatePharmElig

---

CL_SECURITY_OVERRIDE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for SecurityOverride, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	CL_OVERRIDE_SECURITY_SEQ
Related tables	CL_HOSTILE_WORKER_CODE
Business objects	SecurityOverride

SQL referencing CL_SECURITY_OVERRIDE

• SQL-048: CreateOverride
• SQL-297: DeleteOverride, GetSecurityOverrideById, GetSecurityOverrides, UpdateOverride
• SQL-391: DeleteOverride

---

COMPANY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Referenced via native SQL join in InvestigationRepositoryExtensions.GetSubjectName (no NHibernate ClassMap; accessed only through hand-written CreateSqlQuery text)
Access pattern	Inline SQL (NHibernate CreateSqlQuery) — literal SQL text, not ORM-mediated
CRUD operations	Read
Key columns used	COMPANY_SEQ_NUM, COMPANY_NAME
Sequence	N/A
Related tables	None identified
Business objects	FraudInvestigationService

SQL referencing COMPANY

• SQL-214: GetClaimId, GetSubjectNameAsync

---

CONTEXT_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ContextCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	DOCUMENT_TEMPLATE
Business objects	ContextCode

SQL referencing CONTEXT_CODE

• SQL-147: GetContextTypes

---

COUNTY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for County, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LOCATION
Business objects	County

SQL referencing COUNTY

• SQL-148: GetCountyCodes
• SQL-149: GetCountyNames

---

CREDIT_REP_USER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CreditRepUser, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_COLLECTION
Business objects	CreditRepUser

SQL referencing CREDIT_REP_USER

• SQL-150: GetCreditReps

---

CSGSEV_CLM_SGMNTN_ACTIONS_SENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ClaimSeverityModelActivity, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	ClaimSeverityModelActivity

SQL referencing CSGSEV_CLM_SGMNTN_ACTIONS_SENT

• SQL-145: ClaimSeverityModelActivityQuery (property)

---

DCBS_OREGON_BUSINESS

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA (explicit qualifier in Table())
Purpose	Backing store for OregonBusiness, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	WCIS_DBA.DCBS_OREGON_BUSINESS_SEQ_NUM
Related tables	None identified
Business objects	OregonBusiness

SQL referencing DCBS_OREGON_BUSINESS

• SQL-040: CreateOregonBusinessRow

---

DEPT_REVENUE_SOIL_ADJUSTMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DeptRevenueSoilAdjustment, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	DeptRevenueSoilAdjustment

SQL referencing DEPT_REVENUE_SOIL_ADJUSTMENT

• SQL-152: CreateSoilFile, GenerateSoilAdjustments

---

DEPT_REVENUE_SOIL_BALANCE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DeptRevenueSoilBalance, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	DeptRevenueSoilBalance

SQL referencing DEPT_REVENUE_SOIL_BALANCE

• SQL-019: InsertBalanceRecords

---

DOCUMENT_DISTRIBUTION_LOG

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocumentDistributionLog, DocumentDistributionLogRequest, DocumentDistributionLogStatusOnly, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	DOCUMENT_DISTRIBUTION_LOG_SEQ, DOCUMENT_DIST_LOG_SEQ
Related tables	DOCUMENT_REQUEST_LOG
Business objects	DocumentDistributionLog, DocumentDistributionLogRequest, DocumentDistributionLogStatusOnly

SQL referencing DOCUMENT_DISTRIBUTION_LOG

• SQL-020: CreateDocumentDistributionRecord, GetNextDistributionRecordKey
• SQL-154: DeleteRequestDistributionById, GetDocumentDistributionLogById, GetPendingRequests, UpdateDocumentDistributionLogXmlField, UpdateDocumentDistributionRecord
• SQL-155: DeleteRequestDistributions
• SQL-156: GetDocumentDistributionLogsForRequest, GetPendingDocuments, GetProcessingDocuments, MarkDocumentRequestsInProcess, UpdateDocumentRequestAndDistribution
• SQL-157: UpdateDocumentDistributionLogCompleted, UpdateDocumentDistributionLogStatus, UpdateDocumentDistributionLogStatusForRequest
• SQL-369: DeleteRequestDistributionById
• SQL-370: DeleteRequestDistributions

---

DOCUMENT_IMAGING_ERROR

Field	Value
Database	Oracle
Schema/Link	CLM_DBA
Purpose	Backing store for DocumentImagingError, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	DocumentImagingError

SQL referencing DOCUMENT_IMAGING_ERROR

• SQL-021: InsertErrorImage
• SQL-159: ExportErrorEnrollmentDocuments, InsertErrorImage
• SQL-371: ExportErrorEnrollmentDocuments

---

DOCUMENT_OPTION_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocumentOptionCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	DOCUMENT_TEMPLATE_OPTION
Business objects	DocumentOptionCode

SQL referencing DOCUMENT_OPTION_CODE

• SQL-161: GetDocumentOptionCodes

---

DOCUMENT_OP_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocumentOutputProfileCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	DOCUMENT_TEMPLATE_OP
Business objects	DocumentOutputProfileCode

SQL referencing DOCUMENT_OP_CODE

• SQL-162: GetDocumentOutputProfileCodes

---

DOCUMENT_REQUEST_LOG

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocumentRequestLog, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	DOCUMENT_REQUEST_LOG_SEQ
Related tables	DOCUMENT_DISTRIBUTION_LOG, DOCUMENT_TEMPLATE
Business objects	DocumentRequestLog

SQL referencing DOCUMENT_REQUEST_LOG

• SQL-023: SubmitDocumentRequest
• SQL-163: RequestLogQuery (property)
• SQL-164: DeleteTemplateRequests, GetRecentRequests
• SQL-373: DeleteTemplateRequests

---

DOCUMENT_TEMPLATE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocumentTemplate, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	DOCUMENT_TEMPLATE_SEQ
Related tables	CONTEXT_CODE, DOCUMENT_REQUEST_LOG, DOCUMENT_TEMPLATE_OP, DOCUMENT_TEMPLATE_OPTION, RUN_TYPE_CODE
Business objects	DocumentTemplate

SQL referencing DOCUMENT_TEMPLATE

• SQL-025: CreateTemplate
• SQL-166: TemplateQuery (property)
• SQL-167: TemplateQuery (property), TemplateQueryFiltered (property)
• SQL-374: DeleteTemplate

---

DOCUMENT_TEMPLATE_OP

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocumentTemplateOutputProfile, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	DOCUMENT_TEMPLATE_OP_SEQ
Related tables	DOCUMENT_OP_CODE, DOCUMENT_TEMPLATE
Business objects	DocumentTemplateOutputProfile

SQL referencing DOCUMENT_TEMPLATE_OP

• SQL-027: AddTemplateOutputProfiles
• SQL-170: GetRequestLogXElement, IsWordDocument
• SQL-171: GetAllTemplateOutputProfiles, GetDocumentSqlLines, GetOuputProfilesForOneTemplate
• SQL-376: DeleteTemplateOutputProfiles

---

DOCUMENT_TEMPLATE_OPTION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocumentTemplateOption, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	DOCUMENT_OPTION_SEQ
Related tables	DOCUMENT_OPTION_CODE, DOCUMENT_TEMPLATE
Business objects	DocumentTemplateOption

SQL referencing DOCUMENT_TEMPLATE_OPTION

• SQL-026: AddTemplateOptions
• SQL-168: GetRequestLogXElement
• SQL-169: GetAllTemplateOptions, GetDocumentSqlLines, GetOptionsForOneTemplate
• SQL-375: DeleteTemplateOptions

---

DOC_REQUEST_LOG_STATUS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocRequestLogStatusCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	DocRequestLogStatusCode

SQL referencing DOC_REQUEST_LOG_STATUS_CODE

• SQL-153: UpdateRequestStatus

---

DocumentImageTypeCode

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocumentImageTypeCode, accessed via IUnitOfWork.GetRepository<T>(); the backing table name itself could not be confirmed by static analysis or Legends — the C# entity name is used in its place per the translation skill's "never invent a table name" rule
Access pattern	NHibernate ORM (GetRepository<T>()) — external mapping, table name unconfirmed**
CRUD operations	Read
Key columns used	Not enumerable — table and column names both unresolved; see linked SQL document for C# property names**
Sequence	N/A
Related tables	None identified
Business objects	DocumentImageTypeCode

SQL referencing DocumentImageTypeCode

• SQL-158: GetRequestLogXElement

---

DocumentRequestParameter

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocumentRequestParameter, accessed via IUnitOfWork.GetRepository<T>(); no ClassMap exists in this repository or the external mapping package queried via Legends, so the backing table name is unconfirmed and the C# entity name is used in its place
Access pattern	NHibernate ORM (GetRepository<T>()) — external mapping, table name unconfirmed**
CRUD operations	Create, Read
Key columns used	Not enumerable — table and column names both unresolved; see linked SQL documents for C# property names**
Sequence	N/A
Related tables	None identified
Business objects	DocumentRequestParameter

SQL referencing DocumentRequestParameter

• SQL-024: StoreOriginalDocumentRequestParameters
• SQL-165: GetDocumentRequestParameters, NeedVocCoordinators, SaveChangedDocumentRequestParameters, StoreOriginalDocumentRequestParameters

---

DocumentTemplateParameter

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocumentTemplateParameter, accessed via IUnitOfWork.GetRepository<T>(); no ClassMap exists in this repository or the external mapping package queried via Legends, so the backing table name is unconfirmed and the C# entity name is used in its place
Access pattern	NHibernate ORM (GetRepository<T>()) — external mapping, table name unconfirmed**
CRUD operations	Read
Key columns used	Not enumerable — table and column names both unresolved; see linked SQL document for C# property names**
Sequence	N/A
Related tables	None identified
Business objects	DocumentTemplateParameter

SQL referencing DocumentTemplateParameter

• SQL-172: GetDocumentTemplateParameters

---

EBILL_INVOICE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for EbillInvoice, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	EBILL_INVOICE_SEQ
Related tables	EBILL_CLEARINGHOUSE, EBILL_INVOICE_BILL, EBILL_INVOICE_ERROR
Business objects	EbillInvoice

SQL referencing EBILL_INVOICE

• SQL-028: ProcessInvoiceFile
• SQL-377: ProcessInvoiceFile

---

EBILL_INVOICE_BILL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for EbillInvoiceBill, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	EBILL_INVOICE_BILL_SEQ
Related tables	EBILL, EBILL_INVOICE
Business objects	EbillInvoiceBill

SQL referencing EBILL_INVOICE_BILL

• SQL-378: ProcessInvoiceFile

---

EBILL_INVOICE_ERROR

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for EbillInvoiceError, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	EBILL_INVOICE_ERROR_SEQ
Related tables	EBILL, EBILL_INVOICE
Business objects	EbillInvoiceError

SQL referencing EBILL_INVOICE_ERROR

• SQL-379: ProcessInvoiceFile

---

EDI_AUDITED_SERVICE_OVERRIDE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for AuditedServiceOverride, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	AuditedServiceOverride

SQL referencing EDI_AUDITED_SERVICE_OVERRIDE

• SQL-001: Add
• SQL-086: Get, GetOverrideById
• SQL-361: Delete

---

EDI_BILL_OVERRIDE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for BillOverride, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	BillOverride

SQL referencing EDI_BILL_OVERRIDE

• SQL-004: Add
• SQL-094: Get, GetOverrideById
• SQL-363: Delete

---

EDI_FILE

Field	Value
Database	Oracle
Schema/Link	OPS$JIMMIL
Purpose	Backing store for EdiFile, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	EDI_FILE_SEQ
Related tables	EDI_SEGMENT
Business objects	EdiFile

SQL referencing EDI_FILE

• SQL-029: LoadFile
• SQL-173: DeleteFile
• SQL-380: DeleteFile

---

EMPLOYERS_LIABILITY_FACTORS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for EmployerLiabilityFactors, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	EmployerLiabilityFactors

SQL referencing EMPLOYERS_LIABILITY_FACTORS

• SQL-189: GetStandardLimits

---

EMPLOYERS_LIABILITY_LIMITS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for EmployerLiabilityLimit, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CERTIFICATE_DETAIL
Business objects	EmployerLiabilityLimit

SQL referencing EMPLOYERS_LIABILITY_LIMITS

• SQL-190: GetSpecificLimit
• SQL-191: GetStandardLimits

---

ERROR_ENVIRONMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ErrorEnvironment, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	ERROR_GROUP_ENVIRONMENT
Business objects	ErrorEnvironment

SQL referencing ERROR_ENVIRONMENT

• SQL-192: Environments (property)

---

ERROR_GROUP_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ErrorGroupCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	ERROR_GROUP_ENVIRONMENT
Business objects	ErrorGroupCode

SQL referencing ERROR_GROUP_CODE

• SQL-193: EnvironmentGroups (property)

---

ERROR_GROUP_ENVIRONMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ErrorGroupEnvironment, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	ERROR_ENVIRONMENT, ERROR_GROUP_CODE
Business objects	ErrorGroupEnvironment

SQL referencing ERROR_GROUP_ENVIRONMENT

• SQL-194: EnvironmentsByGroup (property), GetEnvironmentsForGroup

---

EXT_USER_DOC_NOTIFY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocumentNotification, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	EXT_USER_DOC_NOTIFY_SEQ
Related tables	AGENCY
Business objects	DocumentNotification

SQL referencing EXT_USER_DOC_NOTIFY

• SQL-022: CreateEmailNotification
• SQL-160: DocumentNotificationQuery (property)
• SQL-372: DeleteEmailNotification

---

FILE_REQUEST

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for FileRequest, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	PAPER_FILE
Business objects	FileRequest

SQL referencing FILE_REQUEST

• SQL-197: LoadTaskMailIDList

---

GROUP_ASSOCIATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for GroupAssociation, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	GROUP_ASSOCIATION, GROUP_TYPE_CODE
Business objects	GroupAssociation

SQL referencing GROUP_ASSOCIATION

• SQL-198: GroupQuery

---

HEARING_LOCATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for HearingLocation, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	HEARING_LOCATION_SEQ
Related tables	HEARING_LOCATION_CODE, SUBPOENA
Business objects	HearingLocation

SQL referencing HEARING_LOCATION

• SQL-199: SetAttorneyInfo
• SQL-200: InitializeLabel
• SQL-201: SetSubpoenaData
• SQL-202: ListOfHearingLocations (property)

---

IMAGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Image, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (external ImageMap in SAIF.Framework.Data.NHibernate) — table name (image) confirmed via Legends CLI; column mappings unresolved
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	Image

SQL referencing IMAGE

• SQL-204: GetDataImage
• SQL-205: ImageAgencyQuery (property)

---

IMAGE_AGENCY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ImageAgency, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	IMAGE_AGENCY_SEQ
Related tables	AGENCY
Business objects	ImageAgency

SQL referencing IMAGE_AGENCY

• SQL-032: AddImage
• SQL-205: ImageAgencyQuery (property)

---

IMAGE_CATEGORY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ImageCategoryCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (external ImageCategoryCodeMap in SAIF.Framework.Data.NHibernate) — table name and composite-key columns confirmed via Legends CLI; remaining columns unresolved
CRUD operations	Read
Key columns used	image_file_code, code (composite key, confirmed); remaining columns unresolved**
Sequence	N/A
Related tables	None identified
Business objects	ImageCategoryCode

SQL referencing IMAGE_CATEGORY_CODE

• SQL-206: GetCategories

---

IMAGE_DOCUMENT_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ImageDocumentTypeCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (external ImageDocumentTypeCodeMap in SAIF.Framework.Data.NHibernate) — table name and key column confirmed via Legends CLI; remaining columns unresolved
CRUD operations	Read
Key columns used	code (confirmed); remaining columns and FK columns unresolved**
Sequence	N/A
Related tables	None identified
Business objects	ImageDocumentTypeCode

SQL referencing IMAGE_DOCUMENT_TYPE_CODE

• SQL-207: GetDocumentType

---

INTEREST_CALC_OPTION_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for InterestCalcCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_COLLECTION
Business objects	InterestCalcCode

SQL referencing INTEREST_CALC_OPTION_CODE

• SQL-212: GetInterestCalcCodes

---

INTEREST_RATE_VALUE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for InterestRateValue, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_COLLECTION
Business objects	InterestRateValue

SQL referencing INTEREST_RATE_VALUE

• SQL-213: GetInterestRates

---

INVESTIGATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Investigation, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	INVESTIGATION_SEQ
Related tables	None identified
Business objects	Investigation

SQL referencing INVESTIGATION

• SQL-214: GetClaimId, GetSubjectNameAsync

---

JUDGEMENT_YEARS_VALUE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for JudgmentYearsValue, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_COLLECTION
Business objects	JudgmentYearsValue

SQL referencing JUDGEMENT_YEARS_VALUE

• SQL-216: GetJudgmentYears

---

JUDGMENT_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for JudgmentCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_COLLECTION
Business objects	JudgmentCode

SQL referencing JUDGMENT_CODE

• SQL-215: GetJudgmentCodes

---

LC_POLICY_SERVICE_PLAN

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for RctPolicyServicePlan, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Update
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	RctPolicyServicePlan

SQL referencing LC_POLICY_SERVICE_PLAN

• SQL-045: InsertServicePlan
• SQL-286: ProcessOneServicePlan
• SQL-358: ExpireServicePlan

---

LC_SERVICE_PLAN_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for RctServicePlanCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	RctServicePlanCode

SQL referencing LC_SERVICE_PLAN_CODE

• SQL-290: ProcessAllServicePlans

---

LC_TRAN_CATEGORY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for TransactionCategoryCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_COLLECTION_TRAN_CODE
Business objects	TransactionCategoryCode

SQL referencing LC_TRAN_CATEGORY_CODE

• SQL-344: GetTransactionCategoryCodes

---

LEGAL_BILL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for LegalBill, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	LEGAL_BILL_SEQ
Related tables	BILL_STATUS_CODE, CL_PAYMENT_SPCL_HANDLING_CODE, LEGAL_BILL_SERVICE, LEGAL_BILL_STATUS_HISTORY, LEGAL_CASE, PROVIDER_LOCATION
Business objects	LegalBill

SQL referencing LEGAL_BILL

• SQL-033: SaveLegalBill
• SQL-217: CreateGlTransferActivity, GenerateCheckTransactionAsync, GenerateCheckTransactionsAsync, GenerateTransactionsForAdjustedBillAsync, GenerateZeroPaymentLetters, GetAttorneysWithPendingLegalBills, ReturnBillPayment, UpdateBillStatus
• SQL-218: DeleteBill, ResetParentBill, SaveLegalBill
• SQL-219: GetInboxItems, GetLegalBill, GetPendingBills
• SQL-382: DeleteBill

---

LEGAL_BILL_SERVICE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for LegalBillService, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	LEGAL_BILL_SERVICE_SEQ
Related tables	ADJUSTMENT_REASON_CODE, BILL_SERVICE_CODE, BILL_SERVICE_RATE_TYPE_CODE, LEGAL_BILL
Business objects	LegalBillService

SQL referencing LEGAL_BILL_SERVICE

• SQL-220: GenerateCheckTransactionsAsync
• SQL-221: CheckForDuplicateService
• SQL-222: PrepareAdjustedBillForSave, SaveBillServices

---

LEGAL_CASE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for LegalCase, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	LEGAL_CASE_SEQ
Related tables	APPEAL, CASE_NOTE, CASE_STATUS_CODE, LEGAL_BILL, PROVIDER_LOCATION, SCHEDULE, SUBPOENA
Business objects	LegalCase

SQL referencing LEGAL_CASE

• SQL-223: SaveLegalBill
• SQL-224: CreateNote, FormatCaseHeader
• SQL-225: GetOpposingCounselInfo, LegalCaseExistsAndHasImageAlertsFlag
• SQL-226: CreateTaskNote
• SQL-227: SaveSubpoena

---

LEGAL_COLLECTION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Case, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	LEGAL_COLLECTION_SEQ
Related tables	CREDIT_REP_USER, INTEREST_CALC_OPTION_CODE, INTEREST_RATE_VALUE, JUDGEMENT_YEARS_VALUE, JUDGMENT_CODE, LEGAL_COLLECTION_ACTIVITY, LEGAL_COLLECTION_CODE, LEGAL_COLLECTION_DEBTOR, LEGAL_COLLECTION_PAYMENT_REF, LEGAL_COLLECTION_STATUS_CODE, LEGAL_COLLECTION_TRANSACTION
Business objects	Case

SQL referencing LEGAL_COLLECTION

• SQL-005: SaveRequest
• SQL-106: AddTransaction, GetCaseInterest
• SQL-107: AddTransaction, GenerateReport
• SQL-108: GetCaseDataById, GetCaseSummaryById, GetRequestById, SaveRequest
• SQL-109: BalanceAtMinimumTasks, JudgmentExpiringTasks, PolicyPaymentTasks, ThirdPartyPaymentTasks

---

LEGAL_COLLECTION_ACTIVITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Activity, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	LEGAL_COLL_ACTIVITY_SEQ
Related tables	LEGAL_COLLECTION, LEGAL_COLL_ACTIVITY_CODE
Business objects	Activity

SQL referencing LEGAL_COLLECTION_ACTIVITY

• SQL-070: GetActivities, GetActivityData
• SQL-360: DeleteActivity

---

LEGAL_COLLECTION_BATCH_CONTROL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for BatchControl, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	LC_BATCH_CONTROL_SEQ
Related tables	None identified
Business objects	BatchControl

SQL referencing LEGAL_COLLECTION_BATCH_CONTROL

• SQL-091: ApplyCashReceipts, ProcessBatch

---

LEGAL_COLLECTION_CASH_RECEIPTS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CashReceipts, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	LC_CASH_RECEIPTS_SEQ
Related tables	None identified
Business objects	CashReceipts

SQL referencing LEGAL_COLLECTION_CASH_RECEIPTS

• SQL-110: GenerateReport, ProcessBatch

---

LEGAL_COLLECTION_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for CollectionCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_COLLECTION
Business objects	CollectionCode

SQL referencing LEGAL_COLLECTION_CODE

• SQL-146: GetCollectionCodes

---

LEGAL_COLLECTION_DEBTOR

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Debtor, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	LEGAL_COLL_DEBTOR_SEQ
Related tables	LEGAL_COLLECTION
Business objects	Debtor

SQL referencing LEGAL_COLLECTION_DEBTOR

• SQL-018: CreateDebtor
• SQL-151: GetDebtorData, GetDebtorDataList, GetDebtors, GetTransactions
• SQL-368: DeleteDebtor

---

LEGAL_COLLECTION_NOTE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Note, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	LEGAL_COLLECTION_NOTE_SEQ
Related tables	None identified
Business objects	Note

SQL referencing LEGAL_COLLECTION_NOTE

• SQL-039: CreateNote
• SQL-233: GetNotes, GetdataNote
• SQL-387: DeleteNote

---

LEGAL_COLLECTION_PAYMENT_REF

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for PaymentRef, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_COLLECTION, LEGAL_COLLECTION_TRANSACTION
Business objects	PaymentRef

SQL referencing LEGAL_COLLECTION_PAYMENT_REF

• SQL-246: GetTransactions

---

LEGAL_COLLECTION_STATUS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for StatusCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_COLLECTION
Business objects	StatusCode

SQL referencing LEGAL_COLLECTION_STATUS_CODE

• SQL-303: GetStatusCodes

---

LEGAL_COLLECTION_TRANSACTION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Transaction, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	LEGAL_COLL_TRAN_SEQ
Related tables	LEGAL_COLLECTION, LEGAL_COLLECTION_PAYMENT_REF, LEGAL_COLLECTION_TRAN_CODE, WRITEOFF_APPROVAL_USER
Business objects	Transaction

SQL referencing LEGAL_COLLECTION_TRANSACTION

• SQL-057: AddTransaction
• SQL-058: AddTransaction
• SQL-059: InsertTransaction
• SQL-343: GetTransaction, GetTransactionData, GetTransactions
• SQL-395: DeleteTransaction

---

LEGAL_COLLECTION_TRAN_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for TransactionCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LC_TRAN_CATEGORY_CODE, LEGAL_COLLECTION_TRANSACTION
Business objects	TransactionCode

SQL referencing LEGAL_COLLECTION_TRAN_CODE

• SQL-345: GetTransactionCodes, InsertTransaction

---

LEGAL_COLL_ACTIVITY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ActivityCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_COLLECTION_ACTIVITY
Business objects	ActivityCode

SQL referencing LEGAL_COLL_ACTIVITY_CODE

• SQL-071: GetActivityCodes

---

LEGAL_PERSON

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for LegalPerson, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	LEGAL_PERSON_SEQ
Related tables	SUBPOENA_RECIPIENT
Business objects	LegalPerson

SQL referencing LEGAL_PERSON

• SQL-036: CreateNewLegalPerson

---

LOCATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Location, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	LOCATION_SEQ
Related tables	AGENT, COUNTY, SUBPOENA_RECIPIENT
Business objects	Location

SQL referencing LOCATION

• SQL-037: CreateDebtor, SaveDebtor
• SQL-231: GetDebtorLocation, GetPolicyLocations, GetPolicyMailingLocation
• SQL-232: SetWitnessRecipients
• SQL-384: DeleteDebtor

---

MEDICARE_BENEFICIARY_QUERY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for MedicareBeneficiaryQuery, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	MEDICARE_QUERY_SEQ
Related tables	None identified
Business objects	MedicareBeneficiaryQuery

SQL referencing MEDICARE_BENEFICIARY_QUERY

• SQL-385: ProcessDeleteMedicareBeneficiarysForBatch

---

MEDICARE_BENEFICIARY_QUERY_BAT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for MedicareBeneficiaryQueryBatch, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	MedicareBeneficiaryQueryBatch

SQL referencing MEDICARE_BENEFICIARY_QUERY_BAT

• SQL-386: ProcessDeleteMedicareBeneficiarysForBatch

---

MEDICARE_QUERY_HISTORY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for MedicareQueryHistory, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Update
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	MEDICARE_QUERY_HISTORY_SEQ
Related tables	None identified
Business objects	MedicareQueryHistory

SQL referencing MEDICARE_QUERY_HISTORY

• SQL-038: InsertMedicareQueryHistory
• SQL-355: UpdateHistoryRecord

---

NOTE_CATEGORY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for LegalNoteCategory, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CASE_NOTE, TASK
Business objects	LegalNoteCategory

SQL referencing NOTE_CATEGORY_CODE

• SQL-229: CreateNote, GetCategories, GetCategoryDesc, UpdateNote
• SQL-230: CreateTaskNote, FillTaskData, GetNoteCategories, UpdateTask

---

OB_DOC_TYPE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for DocType, reached via non-identifier navigation from OnBaseNotificationRuleMatrix
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	ob_doc_type_seq_num, ob_doc_type
Sequence	N/A
Related tables	None identified
Business objects	OnBaseNotificationRuleMatrix

SQL referencing OB_DOC_TYPE

• SQL-235: GetNotificationMatrixRules

---

OB_NOTIFICATION_MATRIX

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for NotificationMatrix, reached via non-identifier navigation from OnBaseNotificationRuleMatrix
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	OB_NOTIFICATION_MATRIX_SEQ_NUM, OB_DOC_TYPE_SEQ_NUM
Sequence	N/A
Related tables	None identified
Business objects	OnBaseNotificationRuleMatrix

SQL referencing OB_NOTIFICATION_MATRIX

• SQL-235: GetNotificationMatrixRules

---

OB_NOTIFY_RULE_MATRX_X

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for OnBaseNotificationRuleMatrix, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	OB_NOTIFICATION_MATRIX, OB_NOTIFICATION_RULE
Business objects	OnBaseNotificationRuleMatrix

SQL referencing OB_NOTIFY_RULE_MATRX_X

• SQL-235: GetNotificationMatrixRules

---

OFFICE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for OfficeCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	POLICY
Business objects	OfficeCode

SQL referencing OFFICE_CODE

• SQL-234: FillPolicy

---

ONLINE_MESSAGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for OnlineMessages, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	ONLINE_MESSAGE_SEQ
Related tables	ONLINE_MESSAGE_PERMISSION, ONLINE_MESSAGE_PRIORITY_CODE
Business objects	OnlineMessages

SQL referencing ONLINE_MESSAGE

• SQL-237: GetAllActiveMessages

---

ONLINE_MESSAGE_APP_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ApplicationCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	ApplicationCode

SQL referencing ONLINE_MESSAGE_APP_CODE

• SQL-082: ValidateApplicationCode

---

ONLINE_MESSAGE_PRIORITY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for OnlineMessagePriority, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	ONLINE_MESSAGE
Business objects	OnlineMessagePriority

SQL referencing ONLINE_MESSAGE_PRIORITY_CODE

• SQL-236: GetMessagePriorities

---

ONLINE_USER_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for OnlineUserType, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	OnlineUserType

SQL referencing ONLINE_USER_TYPE_CODE

• SQL-238: GetMessageUserType, ValidateUserType

---

OSC_POLICY_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for OtherStatesPolicyPeriod, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CERTIFICATE_DETAIL, OSC_POLICY_VIEW
Business objects	OtherStatesPolicyPeriod

SQL referencing OSC_POLICY_PERIOD

• SQL-240: HasOscPeriodForPolicyPeriod

---

OSC_POLICY_VIEW

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for OtherStatesPolicy, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	AGENT, CERTIFICATE_DETAIL, OSC_POLICY_PERIOD, POLICY, POLICY_STATUS_CODE
Business objects	OtherStatesPolicy

SQL referencing OSC_POLICY_VIEW

• SQL-239: GetOscPolicyById

---

OUTPUT_DOCUMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for OutputDocument, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	OUTPUT_DOCUMENT_SEQ
Related tables	OUTPUT_DOCUMENT_TYPE_CODE
Business objects	OutputDocument

SQL referencing OUTPUT_DOCUMENT

• SQL-241: FillOutputDocumentProperty, ReleaseDocuments

---

OUTPUT_DOCUMENT_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for OutputDocumentTypeCode, OutputDocumentTypeCodeStateless, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	**, OUTPUT_DOCUMENT, OUTPUT_DOCUMENT_CATEGORY_CODE, OUTPUT_DOC_NOTIFY_TEXT_CODE
Business objects	OutputDocumentTypeCode, OutputDocumentTypeCodeStateless

SQL referencing OUTPUT_DOCUMENT_TYPE_CODE

• SQL-243: FillOutputDocumentProperty
• SQL-244: ReleaseDocuments

---

OUTPUT_DOC_NOTIFY_TEXT_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for OutputDocumentNotifyTextCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	OUTPUT_DOCUMENT_TYPE_CODE
Business objects	OutputDocumentNotifyTextCode

SQL referencing OUTPUT_DOC_NOTIFY_TEXT_CODE

• SQL-242: FillOutputDocumentProperty

---

OUTPUT_LOG

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for OutputLog, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	OutputLog

SQL referencing OUTPUT_LOG

• SQL-245: ReplaceImageIdsInOutputLog

---

PAYMENT_TRANSACTION_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for PaymentTransactionTypeCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	PaymentTransactionTypeCode

SQL referencing PAYMENT_TRANSACTION_TYPE_CODE

• SQL-247: DeterminePaymentIssueDate
• SQL-248: GetNextIssueDate
• SQL-249: ValidateNextIssueDate
• SQL-250: GetIssueDate

---

PERSON

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Referenced via native SQL join in InvestigationRepositoryExtensions.GetSubjectName (no NHibernate ClassMap; accessed only through hand-written CreateSqlQuery text)
Access pattern	Inline SQL (NHibernate CreateSqlQuery) — literal SQL text, not ORM-mediated
CRUD operations	Read
Key columns used	PERSON_SEQ_NUM, NAME
Sequence	N/A
Related tables	None identified
Business objects	FraudInvestigationService

SQL referencing PERSON

• SQL-214: GetClaimId, GetSubjectNameAsync

---

POLICY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Policy, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	AGENT, BUSINESS_AFFILIATE, CUSTOMER_SERVICE_TEAM_CODE, ENTITY_CODE, MARKET_TYPE_CODE, OFFICE_CODE, OSC_POLICY_VIEW, POLICY, POLICY_OUTPUT_DOCUMENT, POLICY_PERIOD, POLICY_RELATIONSHIP_CODE, POLICY_STATUS_CODE, POLICY_TEAM_FUNCTION, RTW_CASE, SUB_POLICY, TASK, TRADING_AS
Business objects	Policy

SQL referencing POLICY

• SQL-258: GetPolicyData
• SQL-259: CreateTask, GeneratePolicyDebtor, GetMarketType, ValidateContext
• SQL-260: PolicyQuery (property)
• SQL-261: FillTaskData, UpdateTask
• SQL-262: GetExperienceRatingPolicies, GetRelationshipPolicies
• SQL-263: FillPolicy
• SQL-264: GetPolicyName, IsPolicyStateEntity
• SQL-265: AgencyBookList (property), IsValidForAgent, ProducerBookList (property), SaifCorpSecurePolicies
• SQL-266: ProcessAllServicePlans
• SQL-267: CreateTask, CreateTaskStateless, UpdateTask

---

POLICY_OUTPUT_DOCUMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for PolicyOutputDocument, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	DOCUMENT_STATUS_CODE, POLICY
Business objects	PolicyOutputDocument

SQL referencing POLICY_OUTPUT_DOCUMENT

• SQL-041: AddPolicyOutputDocument
• SQL-268: GenerateAllExternalAgencyNotifications, ReleaseDocuments

---

POLICY_PERIOD_COVERAGE_BIND

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for PolicyPeriodCoverageBind, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	PolicyPeriodCoverageBind

SQL referencing POLICY_PERIOD_COVERAGE_BIND

• SQL-269: GetPolicyPeriodCoverageBind

---

POLICY_RELATIONSHIP

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for PolicyRelationship, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	PolicyRelationship

SQL referencing POLICY_RELATIONSHIP

• SQL-270: GetManualAffiliationPolicies

---

POLICY_TEAM_FUNCTION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for PolicyTeamFunction, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	POLICY
Business objects	PolicyTeamFunction

SQL referencing POLICY_TEAM_FUNCTION

• SQL-271: GetSaifContactData
• SQL-272: CreateNotificationTask

---

POSITIVE_PAY_VIEW

Field	Value
Database	Oracle
Schema/Link	WCIS_DBA (explicit qualifier in Table())
Purpose	Backing store for PositivePayView, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	PositivePayView

SQL referencing POSITIVE_PAY_VIEW

• SQL-273: PositivePayViewQuery (property)

---

PROCESS_SERVER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ProcessServer, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	PROVIDER_LOCATION
Business objects	ProcessServer

SQL referencing PROCESS_SERVER

• SQL-274: ListOfProcessServers (property)

---

PROVIDER_ADDRESS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for BatchProviderAddress, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Update, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	PROVIDER_ADDRESS_SEQ
Related tables	PROVIDER_LOCATION
Business objects	BatchProviderAddress

SQL referencing PROVIDER_ADDRESS

• SQL-003: InsertNewProviderAddress
• SQL-093: GetLastInsertId, StatelessProcessProviderAddressesForUpdates
• SQL-350: StatelessProcessProviderAddressesForUpdates
• SQL-362: StatelessProcessProviderAddressesForUpdates

---

PROVIDER_LOCATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ProviderLocation, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	PROVIDER_LOCATION_SEQ
Related tables	CBP_AUDITED_SERVICE, CBP_AUTHORIZATION, CBP_BILL, CBP_BILL_SERVICE, LEGAL_BILL, LEGAL_CASE, PROCESS_SERVER, PROVIDER, PROVIDER_ADDRESS, PROVIDER_IDENTITY, PROVIDER_SERVICE, PROVIDER_TYPE_CODE, REGISTERED_AGENT, SUBPOENA, SUBPOENA_RECIPIENT
Business objects	ProviderLocation

SQL referencing PROVIDER_LOCATION

• SQL-275: CreateAuthorization, UpdateAuthorization
• SQL-276: SaveLegalBill
• SQL-277: CreateService, UpdateService
• SQL-278: SaveRecipients, SetSubpoenaData
• SQL-279: ListOfProcessServers (property), ListOfRegisteredAgents (property)

---

PURCHASEORDERCOMMENTS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for PurchaseOrderComment, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	PurchaseOrderComment

SQL referencing PURCHASEORDERCOMMENTS

• SQL-281: RetrievePurchaseOrderComments

---

PURCHASEORDERLINECOMMENTS

Field	Value
Database	Oracle
Schema/Link	INFR_DBA (explicit qualifier in Table())
Purpose	Backing store for PurchaseOrderLineComment, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	PurchaseOrderLineComment

SQL referencing PURCHASEORDERLINECOMMENTS

• SQL-282: RetrievePurchaseOrderLineComments

---

PURCHASEORDERSVIEW

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for PurchaseOrder, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	PURCHASEORDERLINESVIEW
Business objects	PurchaseOrder

SQL referencing PURCHASEORDERSVIEW

• SQL-280: RetrievePurchaseOrders

---

RCT_POLICIES_TO_TRANSMIT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for RctPolicyToTransmit, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Update, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	RctPolicyToTransmit

SQL referencing RCT_POLICIES_TO_TRANSMIT

• SQL-047: InsertRctPolicyToTransmit
• SQL-289: GetPoliciesToTransmit
• SQL-359: UpdateRctPolicyToTransmit
• SQL-390: RemoveRctPolicyToTransmit

---

RCT_POLICY_SELECTED

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for RctPolicySelected, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Update
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	RctPolicySelected

SQL referencing RCT_POLICY_SELECTED

• SQL-044: InsertRctPolicySelected
• SQL-285: GetRctPolicySelected, ModifyRctPolicySelected
• SQL-357: ModifyRctPolicySelected

---

RCT_STAGING_POLICY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for RctPolicyStagingData, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	RCT_STAGING_POLICY_SEQ
Related tables	RCT_STAGING_POLICY_LOCATION
Business objects	RctPolicyStagingData

SQL referencing RCT_STAGING_POLICY

• SQL-046: LoadRctPolicyStagingData
• SQL-287: GetPolicyStagingPolicies, RemoveAllRctPolicyStagingData
• SQL-288: GetPolicyStagingPolicies
• SQL-389: RemoveAllRctPolicyStagingData

---

RCT_STAGING_POLICY_LOCATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for RctLocationStagingData, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	RCT_STAGING_LOCATION_SEQ
Related tables	RCT_STAGING_POLICY
Business objects	RctLocationStagingData

SQL referencing RCT_STAGING_POLICY_LOCATION

• SQL-043: LoadRctPolicyStagingData
• SQL-283: RemoveAllRctPolicyStagingData
• SQL-284: GetPolicyStagingPolicies
• SQL-388: RemoveAllRctPolicyStagingData

---

REGISTERED_AGENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for RegisteredAgent, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	PROVIDER, PROVIDER_LOCATION
Business objects	RegisteredAgent

SQL referencing REGISTERED_AGENT

• SQL-293: ListOfRegisteredAgents (property)

---

RTW_CASE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for RTWCase, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	POLICY, RTW_LOAD_CODE
Business objects	RTWCase

SQL referencing RTW_CASE

• SQL-294: CanAccessRTWClaim

---

RTW_LOAD_ASSIGNMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for RtwLoadAssignment, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	RTW_LOAD_CODE
Business objects	RtwLoadAssignment

SQL referencing RTW_LOAD_ASSIGNMENT

• SQL-295: GetRTWLoadCode

---

RUN_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for RunTypeCode, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	DOCUMENT_TEMPLATE
Business objects	RunTypeCode

SQL referencing RUN_TYPE_CODE

• SQL-296: GetRunTypes

---

SUBJECT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Referenced via native SQL join in InvestigationRepositoryExtensions.GetSubjectName/GetClaimId (no NHibernate ClassMap; accessed only through hand-written CreateSqlQuery text)
Access pattern	Inline SQL (NHibernate CreateSqlQuery) — literal SQL text, not ORM-mediated
CRUD operations	Read
Key columns used	SUBJECT_SEQ_NUM, PERSON_SEQ_NUM, COMPANY_SEQ_NUM, WORKER_ID
Sequence	N/A
Related tables	None identified
Business objects	FraudInvestigationService

SQL referencing SUBJECT

• SQL-214: GetClaimId, GetSubjectNameAsync

---

SUBPOENA

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Subpoena, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	SUBPOENA_SEQ
Related tables	HEARING_LOCATION, LEGAL_CASE, PROVIDER_LOCATION, SUBPOENA_RECIPIENT, SUBPOENA_SPECIAL_HANDLING_CODE, SUBPOENA_STATUS_CODE, SUBPOENA_TYPE_CODE
Business objects	Subpoena

SQL referencing SUBPOENA

• SQL-049: SaveSubpoena
• SQL-304: GenerateOpposingCounselDocuments, UpdateSubpoenaStatus
• SQL-305: AddSubpoenaDocumentToList, GenerateCashDisbursement, GetPreviewSubpoena, GetProcessServerEmailSubpoena, PrintSubpoena
• SQL-306: GenerateBatchLabels, GetSubpoena
• SQL-307: GenerateCheckTransactionsAsync, GetSubpoenas, UpdateSubpoenaStatus
• SQL-308: DeleteSubpoena, SaveSubpoena
• SQL-309: GetInboxItems, GetSubpoena
• SQL-310: GetApprovedSubpoenas
• SQL-311: GenerateZeroPayDocuments
• SQL-392: DeleteSubpoena

---

SUBPOENA_RECIPIENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Recipient, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	SUBPOENA_RECIPIENT_SEQ
Related tables	LEGAL_PERSON, LOCATION, PROVIDER_LOCATION, SUBPOENA
Business objects	Recipient

SQL referencing SUBPOENA_RECIPIENT

• SQL-291: ReturnSubpoenaPaymentAsync
• SQL-292: SaveRecipients

---

SUBPOENA_SPECIAL_HANDLING_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for SubpoenaSpecialHandling, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	SUBPOENA
Business objects	SubpoenaSpecialHandling

SQL referencing SUBPOENA_SPECIAL_HANDLING_CODE

• SQL-312: ListOfMailingOptions (property)

---

SUBPOENA_STATUS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for SubpoenaStatus, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	SUBPOENA
Business objects	SubpoenaStatus

SQL referencing SUBPOENA_STATUS_CODE

• SQL-313: UpdateSubpoenaStatus
• SQL-314: SetNewSubpoenaStatus
• SQL-315: ListOfSubpoenaStatus (property)

---

SUBPOENA_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for SubpoenaType, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	SUBPOENA
Business objects	SubpoenaType

SQL referencing SUBPOENA_TYPE_CODE

• SQL-316: ListOfSubpoenaTypes (property)

---

SYSTEM_USER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for SystemUser, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	SYSTEM_USER_TYPE_CODE
Business objects	SystemUser

SQL referencing SYSTEM_USER

• SQL-317: ExtractUsers

---

SYSTEM_USER_XREF

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for SystemUserRef, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	SYSTEM_USER_XREF_SEQ
Related tables	None identified
Business objects	SystemUserRef

SQL referencing SYSTEM_USER_XREF

• SQL-318: ExtractUsers, UpdateUserAccess

---

TASK

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Task, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	TASK_SEQ
Related tables	CLAIM_TASK_GROUP_CODE, NOTE_CATEGORY_CODE, POLICY, TASK_ACTION_CODE, TASK_CATEGORY_CODE, TASK_PRIORITY_CODE, TASK_SOURCE_CODE
Business objects	Task

SQL referencing TASK

• SQL-050: CreateTask
• SQL-051: AddExpiredJudgmentTask, AddExpiredLocationTask, AddPaymentTask
• SQL-052: CreateTask, CreateTaskStateless
• SQL-053: CreateMarketingTask, CreateUnderwritingTask
• SQL-054: CreateTask, CreateTaskStateless
• SQL-319: GetClaimBillQueueRemainingCount
• SQL-320: GetTaskData, GetTasks
• SQL-321: RemoveExitingTasks
• SQL-322: TaskQuery (property)
• SQL-323: TaskQuery (property)

---

TASK_ACTION_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for TaskAction, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	TASK, TASK_CATEGORY_CODE
Business objects	TaskAction

SQL referencing TASK_ACTION_CODE

• SQL-324: CreateTask
• SQL-325: SetCommonPropteryValues

---

TASK_CATEGORY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for TaskCategory, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	TASK, TASK_ACTION_CODE, TASK_PRIORITY_CODE, TASK_SOURCE_CODE
Business objects	TaskCategory

SQL referencing TASK_CATEGORY_CODE

• SQL-326: CreateTask
• SQL-327: SetCommonPropteryValues
• SQL-328: DetermineCategory, GetManualEntryCategories, ReassignTasks
• SQL-329: CreateTask, CreateTaskStateless, ReassignTasks

---

TASK_PRIORITY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for TaskPriority, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	TASK, TASK_CATEGORY_CODE
Business objects	TaskPriority

SQL referencing TASK_PRIORITY_CODE

• SQL-332: CreateTask
• SQL-333: SetCommonPropteryValues
• SQL-334: FillTaskData, ReassignTasks
• SQL-335: CreateTask, CreateTaskStateless, GetAdditionalInfoTask, ReassignTasks

---

TASK_SOURCE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for TaskSource, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	TASK, TASK_CATEGORY_CODE
Business objects	TaskSource

SQL referencing TASK_SOURCE_CODE

• SQL-336: CreateTask
• SQL-337: SetCommonPropteryValues

---

TEMP_DATA_PERSON_ADDRESS

Field	Value
Database	Oracle
Schema/Link	CLM_DBA (explicit qualifier in Table())
Purpose	Backing store for TempDataPersonAddress, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Create, Read, Delete
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	None identified
Business objects	TempDataPersonAddress

SQL referencing TEMP_DATA_PERSON_ADDRESS

• SQL-055: InsertTempRecords
• SQL-056: InsertTempRecords
• SQL-338: DeleteTempRecords
• SQL-339: DeleteTempRecords
• SQL-393: DeleteTempRecords
• SQL-394: DeleteTempRecords

---

THRDPARTY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ThirdParty, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	THRDPARTY_SEQ
Related tables	THRDPARTY_CASE, THRDPARTY_FIRM
Business objects	ThirdParty

SQL referencing THRDPARTY

• SQL-340: GenerateThirdPartyDebtor

---

THRDPARTY_CASE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for ThirdPartyCase, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	THRDPARTY_CASE_SEQ
Related tables	CAUSE_OF_ACTION_CODE, THRDPARTY, THRDPARTY_ADJUSTER_CODE, THRDPARTY_COMPANION_CLAIM, THRDPARTY_FIRM, THRDPARTY_STATUS_CODE, THRDPARTY_STATUS_HIST, THRDPARTY_TYPE_CODE
Business objects	ThirdPartyCase

SQL referencing THRDPARTY_CASE

• SQL-341: GenerateThirdPartyDebtor

---

TRADING_AS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for TradingAs, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	CERTIFICATE_DETAIL, POLICY
Business objects	TradingAs

SQL referencing TRADING_AS

• SQL-342: GetTradingAsById

---

USER_PREFERENCE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for Preference, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (external PreferencesMap in SAIF.Framework.Data.NHibernate) — table name confirmed via Legends CLI; some column pairings unresolved
CRUD operations	Create
Key columns used	USER_PREFERENCE_SEQ_NUM, USER_ID, APP_NAME, PAGE_NAME, PREFERENCE_TEXT, UPDATE_DATE, UPDATE_USER
Sequence	N/A
Related tables	None identified
Business objects	Preference

SQL referencing USER_PREFERENCE

• SQL-042: SavePreferences

---

WCIS_EMPLOYEE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for WcisEmployee, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (external WcisEmployeeMap in SAIF.Framework.Data.NHibernate) — table name confirmed via Legends CLI; column mappings unresolved
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL document for C# property names**
Sequence	N/A
Related tables	None identified
Business objects	WcisEmployee

SQL referencing WCIS_EMPLOYEE

• SQL-346: ExtractUsers

---

WRITEOFF_APPROVAL_USER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for WriteOffApprovalUser, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	N/A
Related tables	LEGAL_COLLECTION_TRANSACTION
Business objects	WriteOffApprovalUser

SQL referencing WRITEOFF_APPROVAL_USER

• SQL-347: GetWriteOffApprovalUsers

---

XDEFERRED_PRINT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for XDeferredPrint, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (GetRepository<T>()) — no direct SQL or stored procedures
CRUD operations	Read
Key columns used	Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail**
Sequence	XDEFERRED_SEQ
Related tables	None identified
Business objects	XDeferredPrint

SQL referencing XDEFERRED_PRINT

• SQL-348: GetOneXDeferredPrint

---

XDOCUMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for XDocument, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (external XDocumentMap in SAIF.Framework.Data.NHibernate) — table name and native sequence confirmed via Legends CLI; some column pairings unresolved
CRUD operations	Create
Key columns used	XDOCUMENT_SEQ_NUM, XPRINT_CONTROL_SEQ_NUM, XBIN_TYPE_CODE, DOCUMENT_TYPE_CODE, DUPLEX_CODE, FILE_NAME, EMAIL_ADDRESS, FAX_NUM, IDX_CONTENTS_TEXT, PRINT_GROUP_TEXT, START_VALUE, COPIES_COUNT, SORT0_VALUE-SORT9_VALUE
Sequence	N/A
Related tables	None identified
Business objects	XDocument

SQL referencing XDOCUMENT

• SQL-060: CreateXDocument
• SQL-061: GetCertificateBatchReportByCertHolder, GetCertificateBatchReportByPolicy, GetSummaryReportForPolicy
• SQL-062: UpdateSubpoenaStatus
• SQL-063: GenerateCashDisbursements
• SQL-064: CreateXDocument

---

XPRINT_CONTROL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Backing store for XPrintControl, accessed via IUnitOfWork.GetRepository<T>()
Access pattern	NHibernate ORM (external XPrintControlMap in SAIF.Framework.Data.NHibernate) — table name and identifier column confirmed via Legends CLI; some column pairings unresolved
CRUD operations	Create
Key columns used	XPRINT_CONTROL_SEQ_NUM; remaining columns per linked SQL documents**
Sequence	N/A
Related tables	None identified
Business objects	XPrintControl

SQL referencing XPRINT_CONTROL

• SQL-065: GenerateZeroPaymentLetters
• SQL-066: GetCertificateBatchReportXml, GetCertificateSummaryReport
• SQL-067: GenerateOpposingCounselDocuments
• SQL-068: GenerateWitnessCashDisbursementRequest, GenerateWitnessDocuments
• SQL-069: CreateXPrintControl

---

Unmapped entities

The following 17 generic-repository type arguments were passed to IUnitOfWork.GetRepository<T>() / GetSystemRepository<T>() but could not be resolved to a specific ClassMap/backing table from static analysis; they are marked ** throughout this documentation set.

Type argument	Resolved entity	Entity class	CRUD	Call sites
DocumentImageTypeCode	SAIF.Data.Model.Documents.DocumentImageTypeCode	Data/SAIF.Data/Model/Documents/DocumentImageTypeCode.cs	R	Services/SAIF.Services/Documents/DocumentRequestService.cs
DataModel.DocumentRequestParameter	SAIF.Data.Model.Documents.DocumentRequestParameter	Data/SAIF.Data/Model/Documents/DocumentRequestParameter.cs	C/R	Services/SAIF.Services/Documents/DocumentParameterService.cs
DataModel.DocumentTemplateParameter	SAIF.Data.Model.Documents.DocumentTemplateParameter	Data/SAIF.Data/Model/Documents/DocumentTemplateParameter.cs	R	Services/SAIF.Services/Documents/DocumentParameterService.cs
Data.Model.Employees.Employee, Employee, EmployeeData.Employee	SAIF.Data.Model.Employees.Employee*	not found**	R	Services/SAIF.Services/Claims/Authority/ClaimAuthorityService.cs; Services/SAIF.Services/Claims/Bills/Validators/SendPendRequestValidator.cs; Services/SAIF.Services/Claims/Information/ClaimInformationService.cs; Services/SAIF.Services/Claims/SecurityOverride/SecurityOverrideService.cs; Services/SAIF.Services/Imaging/AutoImportHelperService.cs; Services/SAIF.Services/Legal/Bills/BillPaymentService.cs; Services/SAIF.Services/Legal/Bills/BillService.cs; Services/SAIF.Services/Legal/Subpoenas/SubpoenaDocumentService.cs; Services/SAIF.Services/Legal/Subpoenas/SubpoenaLabelService.cs; Services/SAIF.Services/Legal/Subpoenas/SubpoenaPaymentService.cs; Services/SAIF.Services/Legal/Subpoenas/SubpoenaService.cs
ExternalUserType	SAIF.Data.Model.Users.ExternalUserType	not found**	R	Services/SAIF.Services/Agencies/AgencyService.cs
Data.Model.Imaging.Image	SAIF.Data.Model.Imaging.Image	not found**	R	Services/SAIF.Services/Agencies/Imaging/ImageService.cs
imagingDataModel.ImageCategoryCode	SAIF.Data.Model.Imaging.ImageCategoryCode	not found**	R	Services/SAIF.Services/Agencies/Imaging/ImageService.cs
imagingDataModel.ImageDocumentTypeCode	SAIF.Data.Model.Imaging.ImageDocumentTypeCode	not found**	R	Services/SAIF.Services/Agencies/Imaging/ImageService.cs
SAIF.Data.Model.PDF.PDFApplicationErrorCode	SAIF.Data.Model.PDF.PDFApplicationErrorCode	not found**	R	Services/SAIF.Services/Utilities/Pdf/PdfTrackingService.cs
SAIF.Data.Model.PDF.PDFStatusCode	SAIF.Data.Model.PDF.PDFStatusCode	not found**	R	Services/SAIF.Services/Utilities/Pdf/PdfTrackingService.cs
SAIF.Data.Model.PDF.PDFTracking	SAIF.Data.Model.PDF.PDFTracking	not found**	R	Services/SAIF.Services/Utilities/Pdf/PdfTrackingService.cs
SAIF.Data.Model.PDF.PDFTrackingCode	SAIF.Data.Model.PDF.PDFTrackingCode	not found**	R	Services/SAIF.Services/Utilities/Pdf/PdfTrackingService.cs
Preference	SAIF.Data.Model.Preferences.Preference*	not found**	C	Services/SAIF.Services/Claims/Notes/NotePreferenceConversionService.cs
ContactDataModel.StateCode, Data.Model.Contacts.StateCode	SAIF.Data.Model.Contacts.StateCode	not found**	R	Services/SAIF.Services/Collections/CollectionsService.cs; Services/SAIF.Services/Policies/Certificates/Information/CertificateInformationService.cs
WcisEmployee	SAIF.Data.Model.Employees.WcisEmployee*	not found**	R	Services/SAIF.Services/SystemUsers/UserExtractService.cs
PrintData.XDocument	SAIF.Data.Model.Printing.XDocument	not found**	C	Services/SAIF.Services/Legal/Bills/BillPaymentService.cs; Services/SAIF.Services/Legal/Subpoenas/OpposingCounselService.cs; Services/SAIF.Services/Legal/Subpoenas/WitnessSubpoenaProcess.cs; Services/SAIF.Services/Legal/Subpoenas/ZeroPaySubpoenaProcess.cs; Services/SAIF.Services/Policies/Certificates/DocumentService.cs
PrintData.XPrintControl	SAIF.Data.Model.Printing.XPrintControl	not found**	C	Services/SAIF.Services/Legal/Bills/BillPaymentService.cs; Services/SAIF.Services/Legal/Subpoenas/OpposingCounselService.cs; Services/SAIF.Services/Legal/Subpoenas/WitnessSubpoenaProcess.cs; Services/SAIF.Services/Legal/Subpoenas/ZeroPaySubpoenaProcess.cs; Services/SAIF.Services/Policies/Certificates/DocumentService.cs

Table relationship diagram

The following diagram shows a representative subset of the 205 table relationships discovered across this library's NHibernate mappings (foreign-key associations verified via ClassMap References/HasMany declarations). The full relationship list is enumerated per-table above; showing all 205 edges in one diagram is not legible, so this diagram illustrates the most-connected tables.

erDiagram
    CBP_BILL ||--o{ CBP_AUDITED_SERVICE : "one-to-many"
    CBP_BILL ||--o{ CBP_BILL_SERVICE : "one-to-many"
    LEGAL_CASE ||--o{ LEGAL_BILL : "one-to-many"
    LEGAL_CASE ||--o{ SUBPOENA : "one-to-many"
    OSC_POLICY_VIEW ||--o{ CERTIFICATE_DETAIL : "one-to-many"
    POLICY ||--o{ OSC_POLICY_VIEW : "one-to-many"
    POLICY ||--o{ POLICY : "one-to-many"
    POLICY ||--o{ TASK : "one-to-many"
    PROVIDER_LOCATION ||--o{ CBP_AUDITED_SERVICE : "one-to-many"
    PROVIDER_LOCATION ||--o{ CBP_BILL : "one-to-many"
    PROVIDER_LOCATION ||--o{ CBP_BILL_SERVICE : "one-to-many"
    PROVIDER_LOCATION ||--o{ LEGAL_BILL : "one-to-many"
    PROVIDER_LOCATION ||--o{ LEGAL_CASE : "one-to-many"
    PROVIDER_LOCATION ||--o{ SUBPOENA : "one-to-many"
    PROVIDER_LOCATION ||--o{ SUBPOENA_RECIPIENT : "one-to-many"
    SUBPOENA ||--o{ SUBPOENA_RECIPIENT : "one-to-many"
    THRDPARTY_FIRM ||--o{ THRDPARTY_CASE : "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/
• Services/SAIF.Services/