SAIF.Services SQL catalog

This page indexes all 395 SQL/ORM statements identified in SAIF.Services, grouped by CRUD type. This library is overwhelmingly NHibernate ORM-mediated — the sole exception is SQL-214, which documents hand-written native SQL (Session.CreateSqlQuery) executed from InvestigationRepositoryExtensions; its Sample SQL section shows the literal SQL text captured from source, not an ORM-inferred expression. Every other entry below represents a GetRepository<T>() / query-provider call site, and each linked document's Sample SQL section shows the actual ORM expression executed, per the established documentation precedent for ORM-only libraries.

Create operations

SQL ID	Description	Type	Tables	Business object
SQL-001	Create AuditedServiceOverride via Add	ORM	EDI_AUDITED_SERVICE_OVERRIDE	AuditedServiceOverride
SQL-002	Create BatchProcessLog via UpdateRunDate	ORM	batch_process_log	BatchProcessLog
SQL-003	Create BatchProviderAddress via InsertNewProviderAddress	ORM	PROVIDER_ADDRESS	BatchProviderAddress
SQL-004	Create BillOverride via Add	ORM	EDI_BILL_OVERRIDE	BillOverride
SQL-005	Create Case via SaveRequest	ORM	LEGAL_COLLECTION	Case
SQL-006	Create CbpAuthorization via CreateAuthorization	ORM	CBP_AUTHORIZATION	CbpAuthorization
SQL-007	Create CbpAuthorizationSurgery via AddSurgeryDate	ORM	CBP_AUTHORIZATION_SURGERY	CbpAuthorizationSurgery
SQL-008	Create CbpBill records	ORM	CBP_BILL	CbpBill
SQL-009	Create CbpDiagnosis via InsertDiagnosis	ORM	CBP_DIAGNOSIS	CbpDiagnosis
SQL-010	Create CbpProcedureCode via InsertProcedure	ORM	CBP_PROCEDURE_CODE	CbpProcedureCode
SQL-011	Create CbpServiceCodeStateless via InsertService	ORM	CBP_SERVICE_CODE	CbpServiceCodeStateless
SQL-012	Create CbpServiceDescriptionStateless via InsertServiceDescription	ORM	CBP_SERVICE_DESCRIPTION	CbpServiceDescriptionStateless
SQL-013	Create Certificate records	ORM	CERTIFICATE_DETAIL	Certificate
SQL-014	Create CertificatePreference via AddPreference	ORM	CERTIFICATE_PREFERENCE	CertificatePreference
SQL-015	Create ClaimNote via CreateNote	ORM	CLAIM_ACTIVITY	ClaimNote
SQL-016	Create ClaimNote via CreateTaskNote	ORM	CLAIM_ACTIVITY	ClaimNote
SQL-017	Create ClaimNote via CreateTaskNote	ORM	CLAIM_ACTIVITY	ClaimNote
SQL-018	Create Debtor via CreateDebtor	ORM	LEGAL_COLLECTION_DEBTOR	Debtor
SQL-019	Create DeptRevenueSoilBalance via InsertBalanceRecords	ORM	DEPT_REVENUE_SOIL_BALANCE	DeptRevenueSoilBalance
SQL-020	Create DocumentDistributionLog records	ORM	DOCUMENT_DISTRIBUTION_LOG	DocumentDistributionLog
SQL-021	Create DocumentImagingError via InsertErrorImage	ORM	CLM_DBA.document_imaging_error	DocumentImagingError
SQL-022	Create DocumentNotification via CreateEmailNotification	ORM	EXT_USER_DOC_NOTIFY	DocumentNotification
SQL-023	Create DocumentRequestLog via SubmitDocumentRequest	ORM	DOCUMENT_REQUEST_LOG	DocumentRequestLog
SQL-024	Create DocumentRequestParameter via StoreOriginalDocumentRequestParameters	ORM	DocumentRequestParameter**	DocumentRequestParameter
SQL-025	Create DocumentTemplate via CreateTemplate	ORM	DOCUMENT_TEMPLATE	DocumentTemplate
SQL-026	Create DocumentTemplateOption via AddTemplateOptions	ORM	DOCUMENT_TEMPLATE_OPTION	DocumentTemplateOption
SQL-027	Create DocumentTemplateOutputProfile via AddTemplateOutputProfiles	ORM	DOCUMENT_TEMPLATE_OP	DocumentTemplateOutputProfile
SQL-028	Create EbillInvoice via ProcessInvoiceFile	ORM	EBILL_INVOICE	EbillInvoice
SQL-029	Create EdiFile via LoadFile	ORM	OPS$JIMMIL.EDI_FILE	EdiFile
SQL-030	Create EmployeeAuthorityLimit via AddAuthorityLimit	ORM	CL_CLAIM_EMP_BUS_FUNC_LIMIT	EmployeeAuthorityLimit
SQL-031	Create EmployeeAuthorityPaymentLimitHistory via AddLimitToHistory	ORM	CL_CLAIM_EMP_BUS_FUNC_LIM_HIST	EmployeeAuthorityPaymentLimitHistory
SQL-032	Create ImageAgency via AddImage	ORM	Image_Agency	ImageAgency
SQL-033	Create LegalBill via SaveLegalBill	ORM	LEGAL_BILL	LegalBill
SQL-034	Create LegalNote via CreateNote	ORM	LEGAL.CASE_NOTE	LegalNote
SQL-035	Create LegalNote via CreateTaskNote	ORM	LEGAL.CASE_NOTE	LegalNote
SQL-036	Create LegalPerson via CreateNewLegalPerson	ORM	LEGAL_PERSON	LegalPerson
SQL-037	Create Location records	ORM	LOCATION	Location
SQL-038	Create MedicareQueryHistory via InsertMedicareQueryHistory	ORM	MEDICARE_QUERY_HISTORY	MedicareQueryHistory
SQL-039	Create Note via CreateNote	ORM	LEGAL_COLLECTION_NOTE	Note
SQL-040	Create OregonBusiness via CreateOregonBusinessRow	ORM	WCIS_DBA.DCBS_OREGON_BUSINESS	OregonBusiness
SQL-041	Create PolicyOutputDocument via AddPolicyOutputDocument	ORM	policy_output_document	PolicyOutputDocument
SQL-042	Create Preference via SavePreferences	ORM	USER_PREFERENCE**	Preference
SQL-043	Create RctLocationStagingData via LoadRctPolicyStagingData	ORM	RCT_STAGING_POLICY_LOCATION	RctLocationStagingData
SQL-044	Create RctPolicySelected via InsertRctPolicySelected	ORM	RCT_POLICY_SELECTED	RctPolicySelected
SQL-045	Create RctPolicyServicePlan via InsertServicePlan	ORM	LC_POLICY_SERVICE_PLAN	RctPolicyServicePlan
SQL-046	Create RctPolicyStagingData via LoadRctPolicyStagingData	ORM	RCT_STAGING_POLICY	RctPolicyStagingData
SQL-047	Create RctPolicyToTransmit via InsertRctPolicyToTransmit	ORM	RCT_POLICIES_TO_TRANSMIT	RctPolicyToTransmit
SQL-048	Create SecurityOverride via CreateOverride	ORM	CL_SECURITY_OVERRIDE	SecurityOverride
SQL-049	Create Subpoena via SaveSubpoena	ORM	SUBPOENA	Subpoena
SQL-050	Create Task via CreateTask	ORM	TASK	Task
SQL-051	Create Task records	ORM	TASK	Task
SQL-052	Create Task records	ORM	TASK	Task
SQL-053	Create Task records	ORM	TASK	Task
SQL-054	Create Task records	ORM	TASK	Task
SQL-055	Create TempDataPersonAddress via InsertTempRecords	ORM	CLM_DBA.TEMP_DATA_PERSON_ADDRESS	TempDataPersonAddress
SQL-056	Create TempDataPersonAddress via InsertTempRecords	ORM	CLM_DBA.TEMP_DATA_PERSON_ADDRESS	TempDataPersonAddress
SQL-057	Create Transaction via AddTransaction	ORM	LEGAL_COLLECTION_TRANSACTION	Transaction
SQL-058	Create Transaction via AddTransaction	ORM	LEGAL_COLLECTION_TRANSACTION	Transaction
SQL-059	Create Transaction via InsertTransaction	ORM	LEGAL_COLLECTION_TRANSACTION	Transaction
SQL-060	Create XDocument via CreateXDocument	ORM	XDOCUMENT**	XDocument
SQL-061	Create XDocument records	ORM	XDOCUMENT**	XDocument
SQL-062	Create XDocument via UpdateSubpoenaStatus	ORM	XDOCUMENT**	XDocument
SQL-063	Create XDocument via GenerateCashDisbursements	ORM	XDOCUMENT**	XDocument
SQL-064	Create XDocument via CreateXDocument	ORM	XDOCUMENT**	XDocument
SQL-065	Create XPrintControl via GenerateZeroPaymentLetters	ORM	XPRINT_CONTROL**	XPrintControl
SQL-066	Create XPrintControl records	ORM	XPRINT_CONTROL**	XPrintControl
SQL-067	Create XPrintControl via GenerateOpposingCounselDocuments	ORM	XPRINT_CONTROL**	XPrintControl
SQL-068	Create XPrintControl records	ORM	XPRINT_CONTROL**	XPrintControl
SQL-069	Create XPrintControl via CreateXPrintControl	ORM	XPRINT_CONTROL**	XPrintControl

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-070	Retrieve Activity records	ORM	LEGAL_COLLECTION_ACTIVITY**	Activity
SQL-071	Retrieve ActivityCode via GetActivityCodes	ORM	LEGAL_COLL_ACTIVITY_CODE	ActivityCode
SQL-072	Retrieve AdjustmentReason via SaveBillServices	ORM	ADJUSTMENT_REASON_CODE	AdjustmentReason
SQL-073	Retrieve AdjustmentReason via ListOfAdjustmentReasons (property)	ORM	ADJUSTMENT_REASON_CODE	AdjustmentReason
SQL-074	Retrieve AdpEmployeeFeed via ExtractUsers	ORM	ADP_EMPLOYEE_FEED	AdpEmployeeFeed
SQL-075	Retrieve Agency via AgencyQuery (property)	ORM	Agency	Agency
SQL-076	Retrieve Agency via GetAgency	ORM	Agency	Agency
SQL-077	Retrieve Agency via GenerateDirectWriterNotifications	ORM	Agency	Agency
SQL-078	Retrieve AgencyPaperless via AgencyPaperlessQuery (property)	ORM	AGENCY_PAPERLESS_UPDATE_VIEW	AgencyPaperless
SQL-079	Retrieve Agent via ProducerQuery (property)	ORM	Agent	Agent
SQL-080	Retrieve Agent via GetAgentData	ORM	AGENT	Agent
SQL-081	Retrieve Agent records	ORM	AGENT	Agent
SQL-082	Retrieve ApplicationCode via ValidateApplicationCode	ORM	ONLINE_MESSAGE_APP_CODE	ApplicationCode
SQL-083	Retrieve AttorneyProfile via GetAttorneysWithPendingLegalBills	ORM	ATTORNEY_PROFILE	AttorneyProfile
SQL-084	Retrieve AttorneyProfile via LegalAttorneyList (property)	ORM	ATTORNEY_PROFILE, ADP_EMPLOYEE**	AttorneyProfile
SQL-085	Retrieve AttorneyProfile via SetAttorneyInfo	ORM	ATTORNEY_PROFILE	AttorneyProfile
SQL-086	Retrieve AuditedServiceOverride records	ORM	EDI_AUDITED_SERVICE_OVERRIDE	AuditedServiceOverride
SQL-087	Retrieve AuthorityBusinessProcessCode via CreateNewAuthorityLimitFromEdit	ORM	CL_CLAIM_BUS_PROCESS_CODE	AuthorityBusinessProcessCode
SQL-088	Retrieve AuthorityPaymentApprovalTypeCode via GetApprovalTypeList	ORM	CL_CLAIM_AUTH_PURPOSE_CODE	AuthorityPaymentApprovalTypeCode
SQL-089	Retrieve AuthorityPaymentTypeCode records	ORM	CL_CLAIM_BUS_FUNCTION_CODE	AuthorityPaymentTypeCode
SQL-090	Retrieve AutoImportIndexDefaults via GenerateIdxFile	ORM	AUTO_IMPORT_INDEX_DEFAULTS	AutoImportIndexDefaults
SQL-091	Retrieve BatchControl records	ORM	LEGAL_COLLECTION_BATCH_CONTROL	BatchControl
SQL-092	Retrieve BatchProcessLog via GetSingleRecord	ORM	BATCH_PROCESS_LOG	BatchProcessLog
SQL-093	Retrieve BatchProviderAddress records	ORM	PROVIDER_ADDRESS	BatchProviderAddress
SQL-094	Retrieve BillOverride records	ORM	EDI_BILL_OVERRIDE	BillOverride
SQL-095	Retrieve BillService via SaveBillServices	ORM	BILL_SERVICE_CODE	BillService
SQL-096	Retrieve BillService via ListOfBillServiceCodes (property)	ORM	BILL_SERVICE_CODE	BillService
SQL-097	Retrieve BillService via GetSpendCategory	ORM	BILL_SERVICE_CODE	BillService
SQL-098	Retrieve BillServiceFee via GetBillServiceFee	ORM	BILL_SERVICE_FEE	BillServiceFee
SQL-099	Retrieve BillServiceFee records	ORM	BILL_SERVICE_FEE	BillServiceFee
SQL-100	Retrieve BillServiceRateType via SaveBillServices	ORM	BILL_SERVICE_RATE_TYPE_CODE	BillServiceRateType
SQL-101	Retrieve BillServiceRateType via ListOfBillRateTypeCodes (property)	ORM	BILL_SERVICE_RATE_TYPE_CODE	BillServiceRateType
SQL-102	Retrieve BillStatus via SetNewBillStatus	ORM	BILL_STATUS_CODE	BillStatus
SQL-103	Retrieve BillStatus via SaveLegalBill	ORM	BILL_STATUS_CODE	BillStatus
SQL-104	Retrieve BillStatus via ListOfBillStatusCodes (property)	ORM	BILL_STATUS_CODE	BillStatus
SQL-105	Retrieve Cancellation via GetPendingCancelDateForPolicy	ORM	CANCELLATION	Cancellation
SQL-106	Retrieve Case records	ORM	LEGAL_COLLECTION	Case
SQL-107	Retrieve Case records	ORM	LEGAL_COLLECTION	Case
SQL-108	Retrieve Case records	ORM	LEGAL_COLLECTION	Case
SQL-109	Retrieve Case records	ORM	LEGAL_COLLECTION	Case
SQL-110	Retrieve CashReceipts records	ORM	LEGAL_COLLECTION_CASH_RECEIPTS	CashReceipts
SQL-111	Retrieve CbpAuditedService via GetBillAmounts	ORM	CBP_BILL, CBP_AUDITED_SERVICE, CBP_AUDIT	CbpAuditedService
SQL-112	Retrieve CbpAuthorization records	ORM	CBP_AUTHORIZATION	CbpAuthorization
SQL-113	Retrieve CbpAuthorizationSurgery records	ORM	CBP_AUTHORIZATION_SURGERY	CbpAuthorizationSurgery
SQL-114	Retrieve CbpAuthorizationTypeCode records	ORM	CBP_AUTHORIZATION_TYPE_CODE	CbpAuthorizationTypeCode
SQL-115	Retrieve CbpBill records	ORM	CBP_BILL	CbpBill
SQL-116	Retrieve CbpBill records	ORM	CBP_BILL	CbpBill
SQL-117	Retrieve CbpBill via GetBillAmounts	ORM	CBP_BILL, CBP_AUDITED_SERVICE, CBP_AUDIT	CbpBill
SQL-118	Retrieve CbpBillEntrySourceCode via CreateNewBill	ORM	CBP_BILL_ENTRY_SOURCE_CODE	CbpBillEntrySourceCode
SQL-119	Retrieve CbpBillService via SubmitBill	ORM	CBP_BILL_SERVICE	CbpBillService
SQL-120	Retrieve CbpBillService records	ORM	CBP_BILL_SERVICE	CbpBillService
SQL-121	Retrieve CbpBillStatusCode records	ORM	CBP_BILL_STATUS_CODE	CbpBillStatusCode
SQL-122	Retrieve CbpBillStatusCode via GetBillStatusCodes	ORM	CBP_BILL_STATUS_CODE	CbpBillStatusCode
SQL-123	Retrieve CbpBillTypeCode records	ORM	CBP_BILL_TYPE_CODE	CbpBillTypeCode
SQL-124	Retrieve CbpBillTypeCode via GetBillTypes	ORM	CBP_BILL_TYPE_CODE	CbpBillTypeCode
SQL-125	Retrieve CbpDiagnosis via GetBillDiagnosis	ORM	CBP_DIAGNOSIS	CbpDiagnosis
SQL-126	Retrieve CbpDiagnosis via QueryDiagnosis	ORM	CBP_DIAGNOSIS	CbpDiagnosis
SQL-127	Retrieve CbpDiagnosisTypeCode records	ORM	CBP_DIAGNOSIS_TYPE_CODE	CbpDiagnosisTypeCode
SQL-128	Retrieve CbpNote via GetBillNotes	ORM	CBP_NOTE, CBP_NOTE_TYPE_CODE, CBP_NOTE_CATEGORY_CODE	CbpNote
SQL-129	Retrieve CbpNoteCategoryCode via GetAuditNoteCategoryCodes	ORM	CBP_NOTE_CATEGORY_CODE	CbpNoteCategoryCode
SQL-130	Retrieve CbpPrescribingProviderCode via GetPrescribingPrescriberCodes	ORM	CBP_PRESCRIBING_PROVIDER_CODE	CbpPrescribingProviderCode
SQL-131	Retrieve CbpPrimaryProcedureCode records	ORM	CBP_PRIMARY_PROCEDURE_CODE	CbpPrimaryProcedureCode
SQL-132	Retrieve CbpProcedureCode via QueryProcedure	ORM	CBP_PROCEDURE_CODE	CbpProcedureCode
SQL-133	Retrieve CbpServiceCode via ValidCptCode	ORM	CBP_SERVICE_CODE	CbpServiceCode
SQL-134	Retrieve CbpServicePmGroupCode records	ORM	CBP_SERVICE_PM_GROUP_CODE	CbpServicePmGroupCode
SQL-135	Retrieve Certificate records	ORM	CERTIFICATE_DETAIL	Certificate
SQL-136	Retrieve Certificate via MarkCertificateAsPrinted	ORM	CERTIFICATE_DETAIL	Certificate
SQL-137	Retrieve CertificatePreference records	ORM	CERTIFICATE_PREFERENCE	CertificatePreference
SQL-138	Retrieve ClaimNote records	ORM	CLAIM_ACTIVITY	ClaimNote
SQL-139	Retrieve ClaimNoteCategory records	ORM	CLAIM_ACTIVITY_CATEGORY_CODE	ClaimNoteCategory
SQL-140	Retrieve ClaimNoteCategory via CreateTaskNote	ORM	CLAIM_ACTIVITY_CATEGORY_CODE	ClaimNoteCategory
SQL-141	Retrieve ClaimNoteCategory via CreateTaskNote	ORM	CLAIM_ACTIVITY_CATEGORY_CODE	ClaimNoteCategory
SQL-142	Retrieve ClaimNoteType records	ORM	CLAIM_ACTIVITY_TYPE_CODE	ClaimNoteType
SQL-143	Retrieve ClaimNoteType via CreateTaskNote	ORM	CLAIM_ACTIVITY_TYPE_CODE	ClaimNoteType
SQL-144	Retrieve ClaimNoteType via CreateTaskNote	ORM	CLAIM_ACTIVITY_TYPE_CODE	ClaimNoteType
SQL-145	Retrieve ClaimSeverityModelActivity via ClaimSeverityModelActivityQuery (property)	ORM	CSGSEV_CLM_SGMNTN_ACTIONS_SENT	ClaimSeverityModelActivity
SQL-146	Retrieve CollectionCode via GetCollectionCodes	ORM	LEGAL_COLLECTION_CODE	CollectionCode
SQL-147	Retrieve ContextCode via GetContextTypes	ORM	CONTEXT_CODE	ContextCode
SQL-148	Retrieve County via GetCountyCodes	ORM	COUNTY	County
SQL-149	Retrieve County via GetCountyNames	ORM	COUNTY	County
SQL-150	Retrieve CreditRepUser via GetCreditReps	ORM	CREDIT_REP_USER, ADP_EMPLOYEE**	CreditRepUser
SQL-151	Retrieve Debtor records	ORM	LEGAL_COLLECTION_DEBTOR	Debtor
SQL-152	Retrieve DeptRevenueSoilAdjustment records	ORM	DEPT_REVENUE_SOIL_ADJUSTMENT	DeptRevenueSoilAdjustment
SQL-153	Retrieve DocRequestLogStatusCode via UpdateRequestStatus	ORM	DOC_REQUEST_LOG_STATUS_CODE	DocRequestLogStatusCode
SQL-154	Retrieve DocumentDistributionLog records	ORM	DOCUMENT_DISTRIBUTION_LOG	DocumentDistributionLog
SQL-155	Retrieve DocumentDistributionLog via DeleteRequestDistributions	ORM	DOCUMENT_DISTRIBUTION_LOG	DocumentDistributionLog
SQL-156	Retrieve DocumentDistributionLogRequest records	ORM	DOCUMENT_DISTRIBUTION_LOG, DOCUMENT_REQUEST_LOG	DocumentDistributionLogRequest
SQL-157	Retrieve DocumentDistributionLogStatusOnly records	ORM	DOCUMENT_DISTRIBUTION_LOG	DocumentDistributionLogStatusOnly
SQL-158	Retrieve DocumentImageTypeCode via GetRequestLogXElement	ORM	DocumentImageTypeCode**	DocumentImageTypeCode
SQL-159	Retrieve DocumentImagingError records	ORM	DOCUMENT_IMAGING_ERROR	DocumentImagingError
SQL-160	Retrieve DocumentNotification via DocumentNotificationQuery (property)	ORM	EXT_USER_DOC_NOTIFY	DocumentNotification
SQL-161	Retrieve DocumentOptionCode via GetDocumentOptionCodes	ORM	DOCUMENT_OPTION_CODE	DocumentOptionCode
SQL-162	Retrieve DocumentOutputProfileCode via GetDocumentOutputProfileCodes	ORM	DOCUMENT_OP_CODE	DocumentOutputProfileCode
SQL-163	Retrieve DocumentRequestLog via RequestLogQuery (property)	ORM	DOCUMENT_REQUEST_LOG, DOCUMENT_TEMPLATE	DocumentRequestLog
SQL-164	Retrieve DocumentRequestLog records	ORM	DOCUMENT_REQUEST_LOG	DocumentRequestLog
SQL-165	Retrieve DocumentRequestParameter records	ORM	DocumentRequestParameter**	DocumentRequestParameter
SQL-166	Retrieve DocumentTemplate via TemplateQuery (property)	ORM	DOCUMENT_TEMPLATE	DocumentTemplate
SQL-167	Retrieve DocumentTemplate records	ORM	DOCUMENT_TEMPLATE	DocumentTemplate
SQL-168	Retrieve DocumentTemplateOption via GetRequestLogXElement	ORM	DOCUMENT_TEMPLATE_OPTION	DocumentTemplateOption
SQL-169	Retrieve DocumentTemplateOption records	ORM	DOCUMENT_TEMPLATE_OPTION	DocumentTemplateOption
SQL-170	Retrieve DocumentTemplateOutputProfile records	ORM	DOCUMENT_TEMPLATE_OP	DocumentTemplateOutputProfile
SQL-171	Retrieve DocumentTemplateOutputProfile records	ORM	DOCUMENT_TEMPLATE_OP	DocumentTemplateOutputProfile
SQL-172	Retrieve DocumentTemplateParameter via GetDocumentTemplateParameters	ORM	DocumentTemplateParameter**	DocumentTemplateParameter
SQL-173	Retrieve EdiFile via DeleteFile	ORM	EDI_FILE	EdiFile
SQL-174	Retrieve Employee via IsActiveEmployeeUserId	ORM	ADP_EMPLOYEE**	Employee
SQL-175	Retrieve Employee via GetApproverMailId	ORM	ADP_EMPLOYEE**	Employee
SQL-176	Retrieve Employee records	ORM	ADP_EMPLOYEE**	Employee
SQL-177	Retrieve Employee via GetTerminatedAuthorities	ORM	ADP_EMPLOYEE**, CL_CLAIM_EMP_BUS_FUNC_LIMIT, CL_CLAIM_BUS_PROCESS_CODE, CL_CLAIM_BUS_FUNCTION_CODE	Employee
SQL-178	Retrieve Employee via HasSecurityOverride	ORM	ADP_EMPLOYEE**	Employee
SQL-179	Retrieve Employee records	ORM	ADP_EMPLOYEE**	Employee
SQL-180	Retrieve Employee via ValidateMailId	ORM	ADP_EMPLOYEE**	Employee
SQL-181	Retrieve Employee records	ORM	ADP_EMPLOYEE**	Employee
SQL-182	Retrieve Employee records	ORM	ADP_EMPLOYEE**	Employee
SQL-183	Retrieve Employee via GetApproverMailId	ORM	ADP_EMPLOYEE**	Employee
SQL-184	Retrieve Employee records	ORM	ADP_EMPLOYEE**	Employee
SQL-185	Retrieve EmployeeAuthorityLimit via UserAuthorityLevel	ORM	CL_CLAIM_EMP_BUS_FUNC_LIMIT	EmployeeAuthorityLimit
SQL-186	Retrieve EmployeeAuthorityLimit records	ORM	CL_CLAIM_EMP_BUS_FUNC_LIMIT, CL_CLAIM_BUS_PROCESS_CODE, CL_CLAIM_BUS_FUNCTION_CODE, ADP_EMPLOYEE**	EmployeeAuthorityLimit
SQL-187	Retrieve EmployeeAuthorityLimit via InitiateEmployeeList	ORM	CL_CLAIM_EMP_BUS_FUNC_LIMIT	EmployeeAuthorityLimit
SQL-188	Retrieve EmployeeAuthorityPaymentLimitHistory via GetClaimAuthorityLimitHistory	ORM	CL_CLAIM_EMP_BUS_FUNC_LIM_HIST, CL_CLAIM_BUS_FUNCTION_CODE	EmployeeAuthorityPaymentLimitHistory
SQL-189	Retrieve EmployerLiabilityFactors via GetStandardLimits	ORM	EMPLOYERS_LIABILITY_FACTORS	EmployerLiabilityFactors
SQL-190	Retrieve EmployerLiabilityLimit via GetSpecificLimit	ORM	EMPLOYERS_LIABILITY_LIMITS	EmployerLiabilityLimit
SQL-191	Retrieve EmployerLiabilityLimit via GetStandardLimits	ORM	EMPLOYERS_LIABILITY_LIMITS	EmployerLiabilityLimit
SQL-192	Retrieve ErrorEnvironment via Environments (property)	ORM	ERROR_ENVIRONMENT	ErrorEnvironment
SQL-193	Retrieve ErrorGroupCode via EnvironmentGroups (property)	ORM	ERROR_GROUP_CODE	ErrorGroupCode
SQL-194	Retrieve ErrorGroupEnvironment records	ORM	ERROR_GROUP_ENVIRONMENT, ERROR_ENVIRONMENT, ERROR_GROUP_CODE	ErrorGroupEnvironment
SQL-195	Retrieve ErrorLog records	ORM	APP_ERROR	ErrorLog
SQL-196	Retrieve ExternalUserType via ExternalUserTypeQuery (property)	ORM	ext_user_type, EXT_USER	ExternalUserType
SQL-197	Retrieve FileRequest via LoadTaskMailIDList	ORM	FILE_REQUEST, PAPER_FILE	FileRequest
SQL-198	Retrieve GroupAssociation via GroupQuery	ORM	GROUP_ASSOCIATION	GroupAssociation
SQL-199	Retrieve HearingLocation via SetAttorneyInfo	ORM	HEARING_LOCATION	HearingLocation
SQL-200	Retrieve HearingLocation via InitializeLabel	ORM	HEARING_LOCATION	HearingLocation
SQL-201	Retrieve HearingLocation via SetSubpoenaData	ORM	HEARING_LOCATION	HearingLocation
SQL-202	Retrieve HearingLocation via ListOfHearingLocations (property)	ORM	HEARING_LOCATION	HearingLocation
SQL-203	Retrieve HostileWorkerCode via CreateOverride	ORM	CL_HOSTILE_WORKER_CODE	HostileWorkerCode
SQL-204	Retrieve Image via GetDataImage	ORM	image**	Image
SQL-205	Retrieve ImageAgency via ImageAgencyQuery (property)	ORM	IMAGE_AGENCY, image**	ImageAgency
SQL-206	Retrieve ImageCategoryCode via GetCategories	ORM	image_category_code**	ImageCategoryCode
SQL-207	Retrieve ImageDocumentTypeCode via GetDocumentType	ORM	image_document_type_code**	ImageDocumentTypeCode
SQL-208	Retrieve InjuryClaim via GetClaimWorkerName	ORM	CL_INJURY_CLAIM	InjuryClaim
SQL-209	Retrieve InjuryClaim records	ORM	CL_INJURY_CLAIM	InjuryClaim
SQL-210	Retrieve InjuryClaim records	ORM	CL_INJURY_CLAIM	InjuryClaim
SQL-211	Retrieve InjuryClaim records	ORM	CL_INJURY_CLAIM	InjuryClaim
SQL-212	Retrieve InterestCalcCode via GetInterestCalcCodes	ORM	INTEREST_CALC_OPTION_CODE	InterestCalcCode
SQL-213	Retrieve InterestRateValue via GetInterestRates	ORM	INTEREST_RATE_VALUE	InterestRateValue
SQL-214	Retrieve Investigation records	Inline SQL	INVESTIGATION, SUBJECT, PERSON, COMPANY, PROVIDER_LOCATION, POLICY	Investigation
SQL-215	Retrieve JudgmentCode via GetJudgmentCodes	ORM	JUDGMENT_CODE	JudgmentCode
SQL-216	Retrieve JudgmentYearsValue via GetJudgmentYears	ORM	JUDGEMENT_YEARS_VALUE	JudgmentYearsValue
SQL-217	Retrieve LegalBill records	ORM	LEGAL_BILL, LEGAL_BILL_SERVICE	LegalBill
SQL-218	Retrieve LegalBill records	ORM	LEGAL_BILL	LegalBill
SQL-219	Retrieve LegalBill records	ORM	LEGAL_BILL, BILL_STATUS_CODE	LegalBill
SQL-220	Retrieve LegalBillService via GenerateCheckTransactionsAsync	ORM	LEGAL_BILL_SERVICE	LegalBillService
SQL-221	Retrieve LegalBillService via CheckForDuplicateService	ORM	LEGAL_BILL_SERVICE, LEGAL_BILL	LegalBillService
SQL-222	Retrieve LegalBillService records	ORM	LEGAL_BILL_SERVICE	LegalBillService
SQL-223	Retrieve LegalCase via SaveLegalBill	ORM	LEGAL_CASE	LegalCase
SQL-224	Retrieve LegalCase records	ORM	LEGAL_CASE	LegalCase
SQL-225	Retrieve LegalCase records	ORM	LEGAL_CASE	LegalCase
SQL-226	Retrieve LegalCase via CreateTaskNote	ORM	LEGAL_CASE	LegalCase
SQL-227	Retrieve LegalCase via SaveSubpoena	ORM	LEGAL_CASE	LegalCase
SQL-228	Retrieve LegalNote records	ORM	LEGAL.CASE_NOTE	LegalNote
SQL-229	Retrieve LegalNoteCategory records	ORM	NOTE_CATEGORY_CODE	LegalNoteCategory
SQL-230	Retrieve LegalNoteCategory records	ORM	NOTE_CATEGORY_CODE	LegalNoteCategory
SQL-231	Retrieve Location records	ORM	LOCATION	Location
SQL-232	Retrieve Location via SetWitnessRecipients	ORM	LOCATION	Location
SQL-233	Retrieve Note records	ORM	LEGAL_COLLECTION_NOTE	Note
SQL-234	Retrieve OfficeCode via FillPolicy	ORM	OFFICE_CODE	OfficeCode
SQL-235	Retrieve OnBaseNotificationRuleMatrix via GetNotificationMatrixRules	ORM	OB_NOTIFY_RULE_MATRX_X, OB_NOTIFICATION_MATRIX, ob_doc_type	OnBaseNotificationRuleMatrix
SQL-236	Retrieve OnlineMessagePriority via GetMessagePriorities	ORM	ONLINE_MESSAGE_PRIORITY_CODE	OnlineMessagePriority
SQL-237	Retrieve OnlineMessages via GetAllActiveMessages	ORM	ONLINE_MESSAGE	OnlineMessages
SQL-238	Retrieve OnlineUserType records	ORM	ONLINE_USER_TYPE_CODE	OnlineUserType
SQL-239	Retrieve OtherStatesPolicy via GetOscPolicyById	ORM	OSC_POLICY_VIEW	OtherStatesPolicy
SQL-240	Retrieve OtherStatesPolicyPeriod via HasOscPeriodForPolicyPeriod	ORM	OSC_POLICY_PERIOD, OSC_POLICY_VIEW	OtherStatesPolicyPeriod
SQL-241	Retrieve OutputDocument records	ORM	OUTPUT_DOCUMENT	OutputDocument
SQL-242	Retrieve OutputDocumentNotifyTextCode via FillOutputDocumentProperty	ORM	OUTPUT_DOC_NOTIFY_TEXT_CODE	OutputDocumentNotifyTextCode
SQL-243	Retrieve OutputDocumentTypeCode via FillOutputDocumentProperty	ORM	OUTPUT_DOCUMENT_TYPE_CODE	OutputDocumentTypeCode
SQL-244	Retrieve OutputDocumentTypeCodeStateless via ReleaseDocuments	ORM	OUTPUT_DOCUMENT_TYPE_CODE	OutputDocumentTypeCodeStateless
SQL-245	Retrieve OutputLog via ReplaceImageIdsInOutputLog	ORM	OUTPUT_LOG	OutputLog
SQL-246	Retrieve PaymentRef via GetTransactions	ORM	LEGAL_COLLECTION_PAYMENT_REF	PaymentRef
SQL-247	Retrieve PaymentTransactionTypeCode via DeterminePaymentIssueDate	ORM	PAYMENT_TRANSACTION_TYPE_CODE	PaymentTransactionTypeCode
SQL-248	Retrieve PaymentTransactionTypeCode via GetNextIssueDate	ORM	PAYMENT_TRANSACTION_TYPE_CODE	PaymentTransactionTypeCode
SQL-249	Retrieve PaymentTransactionTypeCode via ValidateNextIssueDate	ORM	PAYMENT_TRANSACTION_TYPE_CODE	PaymentTransactionTypeCode
SQL-250	Retrieve PaymentTransactionTypeCode via GetIssueDate	ORM	PAYMENT_TRANSACTION_TYPE_CODE	PaymentTransactionTypeCode
SQL-251	Retrieve PDFApplicationErrorCode via GetApplicationType	ORM	pdf_app_error_code**	PDFApplicationErrorCode
SQL-252	Retrieve PDFStatusCode via GetStatusType	ORM	pdf_cache_status_code**	PDFStatusCode
SQL-253	Retrieve PDFTracking records	ORM	pdf_tracking, pdf_app_error_code	PDFTracking
SQL-254	Retrieve PDFTrackingCode via GetProcessingType	ORM	pdf_tracking_code**	PDFTrackingCode
SQL-255	Retrieve PharmacyDispenseAsWrittenCode records	ORM	CL_PHARMACY_DAW_CODE	PharmacyDispenseAsWrittenCode
SQL-256	Retrieve PharmacyEligibilityReport records	ORM	CL_PHARMACY_ELIGIBILITY_REPORT	PharmacyEligibilityReport
SQL-257	Retrieve PharmacyEligibilityStatusCode records	ORM	CL_PHARMACY_ELIG_STATUS_CODE	PharmacyEligibilityStatusCode
SQL-258	Retrieve Policy via GetPolicyData	ORM	POLICY	Policy
SQL-259	Retrieve Policy records	ORM	POLICY	Policy
SQL-260	Retrieve Policy via PolicyQuery (property)	ORM	POLICY	Policy
SQL-261	Retrieve Policy records	ORM	POLICY	Policy
SQL-262	Retrieve Policy records	ORM	POLICY	Policy
SQL-263	Retrieve Policy via FillPolicy	ORM	POLICY	Policy
SQL-264	Retrieve Policy records	ORM	POLICY	Policy
SQL-265	Retrieve Policy records	ORM	POLICY	Policy
SQL-266	Retrieve Policy via ProcessAllServicePlans	ORM	POLICY	Policy
SQL-267	Retrieve Policy records	ORM	POLICY	Policy
SQL-268	Retrieve PolicyOutputDocument records	ORM	POLICY_OUTPUT_DOCUMENT, OUTPUT_DOCUMENT, OUTPUT_DOCUMENT_TYPE_CODE	PolicyOutputDocument
SQL-269	Retrieve PolicyPeriodCoverageBind via GetPolicyPeriodCoverageBind	ORM	POLICY_PERIOD_COVERAGE_BIND	PolicyPeriodCoverageBind
SQL-270	Retrieve PolicyRelationship via GetManualAffiliationPolicies	ORM	POLICY_RELATIONSHIP, POLICY	PolicyRelationship
SQL-271	Retrieve PolicyTeamFunction via GetSaifContactData	ORM	POLICY_TEAM_FUNCTION	PolicyTeamFunction
SQL-272	Retrieve PolicyTeamFunction via CreateNotificationTask	ORM	POLICY_TEAM_FUNCTION	PolicyTeamFunction
SQL-273	Retrieve PositivePayView via PositivePayViewQuery (property)	ORM	POSITIVE_PAY_VIEW	PositivePayView
SQL-274	Retrieve ProcessServer via ListOfProcessServers (property)	ORM	PROCESS_SERVER	ProcessServer
SQL-275	Retrieve ProviderLocation records	ORM	PROVIDER_LOCATION	ProviderLocation
SQL-276	Retrieve ProviderLocation via SaveLegalBill	ORM	PROVIDER_LOCATION	ProviderLocation
SQL-277	Retrieve ProviderLocation records	ORM	PROVIDER_LOCATION	ProviderLocation
SQL-278	Retrieve ProviderLocation records	ORM	PROVIDER_LOCATION	ProviderLocation
SQL-279	Retrieve ProviderLocation records	ORM	PROVIDER_LOCATION	ProviderLocation
SQL-280	Retrieve PurchaseOrder via RetrievePurchaseOrders	ORM	PURCHASEORDERSVIEW	PurchaseOrder
SQL-281	Retrieve PurchaseOrderComment via RetrievePurchaseOrderComments	ORM	PURCHASEORDERCOMMENTS	PurchaseOrderComment
SQL-282	Retrieve PurchaseOrderLineComment via RetrievePurchaseOrderLineComments	ORM	PURCHASEORDERLINECOMMENTS	PurchaseOrderLineComment
SQL-283	Retrieve RctLocationStagingData via RemoveAllRctPolicyStagingData	ORM	RCT_STAGING_POLICY_LOCATION	RctLocationStagingData
SQL-284	Retrieve RctLocationStagingData via GetPolicyStagingPolicies	ORM	RCT_STAGING_POLICY_LOCATION	RctLocationStagingData
SQL-285	Retrieve RctPolicySelected records	ORM	RCT_POLICY_SELECTED	RctPolicySelected
SQL-286	Retrieve RctPolicyServicePlan via ProcessOneServicePlan	ORM	LC_POLICY_SERVICE_PLAN	RctPolicyServicePlan
SQL-287	Retrieve RctPolicyStagingData records	ORM	RCT_STAGING_POLICY, RCT_STAGING_POLICY_LOCATION	RctPolicyStagingData
SQL-288	Retrieve RctPolicyStagingData via GetPolicyStagingPolicies	ORM	RCT_STAGING_POLICY	RctPolicyStagingData
SQL-289	Retrieve RctPolicyToTransmit via GetPoliciesToTransmit	ORM	RCT_POLICIES_TO_TRANSMIT	RctPolicyToTransmit
SQL-290	Retrieve RctServicePlanCode via ProcessAllServicePlans	ORM	LC_SERVICE_PLAN_CODE	RctServicePlanCode
SQL-291	Retrieve Recipient via ReturnSubpoenaPaymentAsync	ORM	SUBPOENA_RECIPIENT	Recipient
SQL-292	Retrieve Recipient via SaveRecipients	ORM	SUBPOENA_RECIPIENT	Recipient
SQL-293	Retrieve RegisteredAgent via ListOfRegisteredAgents (property)	ORM	REGISTERED_AGENT	RegisteredAgent
SQL-294	Retrieve RTWCase via CanAccessRTWClaim	ORM	RTW_CASE	RTWCase
SQL-295	Retrieve RtwLoadAssignment via GetRTWLoadCode	ORM	RTW_LOAD_ASSIGNMENT	RtwLoadAssignment
SQL-296	Retrieve RunTypeCode via GetRunTypes	ORM	RUN_TYPE_CODE	RunTypeCode
SQL-297	Retrieve SecurityOverride records	ORM	CL_SECURITY_OVERRIDE	SecurityOverride
SQL-298	Retrieve SpecialHandlingCode via SaveLegalBill	ORM	CL_PAYMENT_SPCL_HANDLING_CODE	SpecialHandlingCode
SQL-299	Retrieve SpecialHandlingCode via SpecialHandlingCodeList (property)	ORM	CL_PAYMENT_SPCL_HANDLING_CODE	SpecialHandlingCode
SQL-300	Retrieve StandardOtherCoverageText via GetStandardOtherCoverageTexts	ORM	CERTIFICATE_OTHER_COV_CODE	StandardOtherCoverageText
SQL-301	Retrieve StateCode via GetStateCodes	ORM	ALL_STATES**	StateCode
SQL-302	Retrieve StateCode via GetStateCodes	ORM	ALL_STATES**	StateCode
SQL-303	Retrieve StatusCode via GetStatusCodes	ORM	LEGAL_COLLECTION_STATUS_CODE	StatusCode
SQL-304	Retrieve Subpoena records	ORM	SUBPOENA	Subpoena
SQL-305	Retrieve Subpoena records	ORM	SUBPOENA	Subpoena
SQL-306	Retrieve Subpoena records	ORM	SUBPOENA, SUBPOENA_SPECIAL_HANDLING_CODE	Subpoena
SQL-307	Retrieve Subpoena records	ORM	SUBPOENA	Subpoena
SQL-308	Retrieve Subpoena records	ORM	SUBPOENA	Subpoena
SQL-309	Retrieve Subpoena records	ORM	SUBPOENA	Subpoena
SQL-310	Retrieve Subpoena via GetApprovedSubpoenas	ORM	SUBPOENA	Subpoena
SQL-311	Retrieve Subpoena via GenerateZeroPayDocuments	ORM	SUBPOENA	Subpoena
SQL-312	Retrieve SubpoenaSpecialHandling via ListOfMailingOptions (property)	ORM	SUBPOENA_SPECIAL_HANDLING_CODE	SubpoenaSpecialHandling
SQL-313	Retrieve SubpoenaStatus via UpdateSubpoenaStatus	ORM	SUBPOENA_STATUS_CODE	SubpoenaStatus
SQL-314	Retrieve SubpoenaStatus via SetNewSubpoenaStatus	ORM	SUBPOENA_STATUS_CODE	SubpoenaStatus
SQL-315	Retrieve SubpoenaStatus via ListOfSubpoenaStatus (property)	ORM	SUBPOENA_STATUS_CODE	SubpoenaStatus
SQL-316	Retrieve SubpoenaType via ListOfSubpoenaTypes (property)	ORM	SUBPOENA_TYPE_CODE	SubpoenaType
SQL-317	Retrieve SystemUser via ExtractUsers	ORM	SYSTEM_USER	SystemUser
SQL-318	Retrieve SystemUserRef records	ORM	SYSTEM_USER_XREF	SystemUserRef
SQL-319	Retrieve Task via GetClaimBillQueueRemainingCount	ORM	TASK	Task
SQL-320	Retrieve Task records	ORM	TASK	Task
SQL-321	Retrieve Task via RemoveExitingTasks	ORM	TASK	Task
SQL-322	Retrieve Task via TaskQuery (property)	ORM	TASK	Task
SQL-323	Retrieve Task via TaskQuery (property)	ORM	TASK	Task
SQL-324	Retrieve TaskAction via CreateTask	ORM	TASK_ACTION_CODE	TaskAction
SQL-325	Retrieve TaskAction via SetCommonPropteryValues	ORM	TASK_ACTION_CODE	TaskAction
SQL-326	Retrieve TaskCategory via CreateTask	ORM	TASK_CATEGORY_CODE	TaskCategory
SQL-327	Retrieve TaskCategory via SetCommonPropteryValues	ORM	TASK_CATEGORY_CODE	TaskCategory
SQL-328	Retrieve TaskCategory records	ORM	TASK_CATEGORY_CODE	TaskCategory
SQL-329	Retrieve TaskCategory records	ORM	TASK_CATEGORY_CODE	TaskCategory
SQL-330	Retrieve TaskGroup via GetTaskGroups	ORM	CLAIM_TASK_GROUP_CODE	TaskGroup
SQL-331	Retrieve TaskGroup records	ORM	CLAIM_TASK_GROUP_CODE	TaskGroup
SQL-332	Retrieve TaskPriority via CreateTask	ORM	TASK_PRIORITY_CODE	TaskPriority
SQL-333	Retrieve TaskPriority via SetCommonPropteryValues	ORM	TASK_PRIORITY_CODE	TaskPriority
SQL-334	Retrieve TaskPriority records	ORM	TASK_PRIORITY_CODE	TaskPriority
SQL-335	Retrieve TaskPriority records	ORM	TASK_PRIORITY_CODE	TaskPriority
SQL-336	Retrieve TaskSource via CreateTask	ORM	TASK_SOURCE_CODE	TaskSource
SQL-337	Retrieve TaskSource via SetCommonPropteryValues	ORM	TASK_SOURCE_CODE	TaskSource
SQL-338	Retrieve TempDataPersonAddress via DeleteTempRecords	ORM	TEMP_DATA_PERSON_ADDRESS	TempDataPersonAddress
SQL-339	Retrieve TempDataPersonAddress via DeleteTempRecords	ORM	TEMP_DATA_PERSON_ADDRESS	TempDataPersonAddress
SQL-340	Retrieve ThirdParty via GenerateThirdPartyDebtor	ORM	THRDPARTY	ThirdParty
SQL-341	Retrieve ThirdPartyCase via GenerateThirdPartyDebtor	ORM	THRDPARTY_CASE	ThirdPartyCase
SQL-342	Retrieve TradingAs via GetTradingAsById	ORM	TRADING_AS	TradingAs
SQL-343	Retrieve Transaction records	ORM	LEGAL_COLLECTION_TRANSACTION	Transaction
SQL-344	Retrieve TransactionCategoryCode via GetTransactionCategoryCodes	ORM	LC_TRAN_CATEGORY_CODE	TransactionCategoryCode
SQL-345	Retrieve TransactionCode records	ORM	LEGAL_COLLECTION_TRAN_CODE	TransactionCode
SQL-346	Retrieve WcisEmployee via ExtractUsers	ORM	WCIS_EMPLOYEE**	WcisEmployee
SQL-347	Retrieve WriteOffApprovalUser via GetWriteOffApprovalUsers	ORM	WRITEOFF_APPROVAL_USER, ADP_EMPLOYEE**	WriteOffApprovalUser
SQL-348	Retrieve XDeferredPrint via GetOneXDeferredPrint	ORM	XDEFERRED_PRINT	XDeferredPrint

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-349	Update BatchProcessLog via UpdateRunDate	ORM	batch_process_log	BatchProcessLog
SQL-350	Update BatchProviderAddress via StatelessProcessProviderAddressesForUpdates	ORM	PROVIDER_ADDRESS	BatchProviderAddress
SQL-351	Update CbpDiagnosis via UpdateDiagnosis	ORM	CBP_DIAGNOSIS	CbpDiagnosis
SQL-352	Update CbpProcedureCode via UpdateProcedure	ORM	CBP_PROCEDURE_CODE	CbpProcedureCode
SQL-353	Update CbpServiceCodeStateless via UpdateService	ORM	CBP_SERVICE_CODE	CbpServiceCodeStateless
SQL-354	Update CbpServiceDescriptionStateless via UpdateServiceDescription	ORM	CBP_SERVICE_DESCRIPTION	CbpServiceDescriptionStateless
SQL-355	Update MedicareQueryHistory via UpdateHistoryRecord	ORM	MEDICARE_QUERY_HISTORY	MedicareQueryHistory
SQL-356	Update PharmacyEligibilityReport via UpdatePharmElig	ORM	CL_PHARMACY_ELIGIBILITY_REPORT	PharmacyEligibilityReport
SQL-357	Update RctPolicySelected via ModifyRctPolicySelected	ORM	RCT_POLICY_SELECTED	RctPolicySelected
SQL-358	Update RctPolicyServicePlan via ExpireServicePlan	ORM	LC_POLICY_SERVICE_PLAN	RctPolicyServicePlan
SQL-359	Update RctPolicyToTransmit via UpdateRctPolicyToTransmit	ORM	RCT_POLICIES_TO_TRANSMIT	RctPolicyToTransmit

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-360	Delete Activity via DeleteActivity	ORM	LEGAL_COLLECTION_ACTIVITY	Activity
SQL-361	Delete AuditedServiceOverride via Delete	ORM	EDI_AUDITED_SERVICE_OVERRIDE	AuditedServiceOverride
SQL-362	Delete BatchProviderAddress via StatelessProcessProviderAddressesForUpdates	ORM	PROVIDER_ADDRESS	BatchProviderAddress
SQL-363	Delete BillOverride via Delete	ORM	EDI_BILL_OVERRIDE	BillOverride
SQL-364	Delete CbpAuthorization via DeleteAuthorization	ORM	CBP_AUTHORIZATION	CbpAuthorization
SQL-365	Delete CbpAuthorizationSurgery via DeleteSurgeryDate	ORM	CBP_AUTHORIZATION_SURGERY	CbpAuthorizationSurgery
SQL-366	Delete Certificate via DeleteCertificate	ORM	CERTIFICATE_DETAIL	Certificate
SQL-367	Delete ClaimNote via DeleteNote	ORM	CLAIM_ACTIVITY	ClaimNote
SQL-368	Delete Debtor via DeleteDebtor	ORM	LEGAL_COLLECTION_DEBTOR	Debtor
SQL-369	Delete DocumentDistributionLog via DeleteRequestDistributionById	ORM	DOCUMENT_DISTRIBUTION_LOG	DocumentDistributionLog
SQL-370	Delete DocumentDistributionLog via DeleteRequestDistributions	ORM	DOCUMENT_DISTRIBUTION_LOG	DocumentDistributionLog
SQL-371	Delete DocumentImagingError via ExportErrorEnrollmentDocuments	ORM	DOCUMENT_IMAGING_ERROR	DocumentImagingError
SQL-372	Delete DocumentNotification via DeleteEmailNotification	ORM	EXT_USER_DOC_NOTIFY	DocumentNotification
SQL-373	Delete DocumentRequestLog via DeleteTemplateRequests	ORM	DOCUMENT_REQUEST_LOG	DocumentRequestLog
SQL-374	Delete DocumentTemplate via DeleteTemplate	ORM	DOCUMENT_TEMPLATE	DocumentTemplate
SQL-375	Delete DocumentTemplateOption via DeleteTemplateOptions	ORM	DOCUMENT_TEMPLATE_OPTION	DocumentTemplateOption
SQL-376	Delete DocumentTemplateOutputProfile via DeleteTemplateOutputProfiles	ORM	DOCUMENT_TEMPLATE_OP	DocumentTemplateOutputProfile
SQL-377	Delete EbillInvoice via ProcessInvoiceFile	ORM	EBILL_INVOICE	EbillInvoice
SQL-378	Delete EbillInvoiceBill via ProcessInvoiceFile	ORM	EBILL_INVOICE_BILL	EbillInvoiceBill
SQL-379	Delete EbillInvoiceError via ProcessInvoiceFile	ORM	EBILL_INVOICE_ERROR	EbillInvoiceError
SQL-380	Delete EdiFile via DeleteFile	ORM	EDI_FILE	EdiFile
SQL-381	Delete EmployeeAuthorityLimit via DeleteAuthority	ORM	CL_CLAIM_EMP_BUS_FUNC_LIMIT	EmployeeAuthorityLimit
SQL-382	Delete LegalBill via DeleteBill	ORM	LEGAL_BILL	LegalBill
SQL-383	Delete LegalNote via DeleteNote	ORM	CASE_NOTE	LegalNote
SQL-384	Delete Location via DeleteDebtor	ORM	LOCATION	Location
SQL-385	Delete MedicareBeneficiaryQuery via ProcessDeleteMedicareBeneficiarysForBatch	ORM	MEDICARE_BENEFICIARY_QUERY	MedicareBeneficiaryQuery
SQL-386	Delete MedicareBeneficiaryQueryBatch via ProcessDeleteMedicareBeneficiarysForBatch	ORM	MEDICARE_BENEFICIARY_QUERY_BAT	MedicareBeneficiaryQueryBatch
SQL-387	Delete Note via DeleteNote	ORM	LEGAL_COLLECTION_NOTE	Note
SQL-388	Delete RctLocationStagingData via RemoveAllRctPolicyStagingData	ORM	RCT_STAGING_POLICY_LOCATION	RctLocationStagingData
SQL-389	Delete RctPolicyStagingData via RemoveAllRctPolicyStagingData	ORM	RCT_STAGING_POLICY	RctPolicyStagingData
SQL-390	Delete RctPolicyToTransmit via RemoveRctPolicyToTransmit	ORM	RCT_POLICIES_TO_TRANSMIT	RctPolicyToTransmit
SQL-391	Delete SecurityOverride via DeleteOverride	ORM	CL_SECURITY_OVERRIDE	SecurityOverride
SQL-392	Delete Subpoena via DeleteSubpoena	ORM	SUBPOENA	Subpoena
SQL-393	Delete TempDataPersonAddress via DeleteTempRecords	ORM	TEMP_DATA_PERSON_ADDRESS	TempDataPersonAddress
SQL-394	Delete TempDataPersonAddress via DeleteTempRecords	ORM	TEMP_DATA_PERSON_ADDRESS	TempDataPersonAddress
SQL-395	Delete Transaction via DeleteTransaction	ORM	LEGAL_COLLECTION_TRANSACTION	Transaction

Related documentation

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

Sources

• Services/SAIF.Services/