DB-CLL-065-104 — Standard reference-data CRUD across 8 TableMaint objects¶

Classification¶

Field	Value
SQL ID	DB-CLL-065-104
Operation type	R,I,U,D
Execution method	Text
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Inline text SQL
Business object	clsAttorneyConflict, clsAttorneyWorkerAssignment (+ clsAttorneyPolicyAssignment, clsAttorneySchedule), clsLegalPersonType, clsOtherFirm, clsOutOFTownRotationAssgn, clsHearingLocation
Criteria property	CreateSQL/RetrieveSQL/InsertSQL/UpdateSQL/DeleteSQL
Lifecycle method	AfterCreate/AfterRetrieve/BeforeInsert/BeforeUpdate/BeforeDelete

Parameters¶

No bound parameters were identified for this statement.

Tables¶

Table	Access	Columns/Notes
ATTORNEY_CONFLICT	CRUD	full column set
ATTORNEY_POLICY_ASSIGNMENT	CRUD	full column set
ATTORNEY_SCHEDULE	CRUD	full column set
ATTORNEY_WORKER_ASSIGNMENT	CRUD	full column set
LEGAL_PERSON_TYPE	CRUD	full column set
OTHER_FIRM	CRUD	full column set
OUT_OF_TOWN_ROTATION_ASSGN	CRUD	full column set
HEARING_LOCATION	CRUD	full column set

Sample SQL¶

-- Representative pattern: clsAttorneyConflict RetrieveSQL (one of 8 TableMaint reference
-- objects in this consolidated group), reconstructed verbatim from
-- SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb:
Select
  ATTORNEY_CONFLICT.ATTORNEY_CONFLICT_SEQ_NUM as AttorneyConflictSeqNum,
  ATTORNEY_CONFLICT.ATTORNEY_EMPLID as AttorneyEmplid,
  ATTORNEY_CONFLICT.EFF_DATE as EffDate,
  ATTORNEY_CONFLICT.EXP_DATE as ExpDate,
  to_char(ATTORNEY_CONFLICT.CONFLICT_LEGAL_PERSON_SEQ_NUM) as ConflictLegalPersonSeqNum,
  to_char(ATTORNEY_CONFLICT.ATTY_PROVIDER_LOCATION_SEQ_NUM) as ProviderLocationID,
  ATTORNEY_CONFLICT.ADJUSTER_EMPLID as AdjusterEmplid,
  ATTORNEY_CONFLICT.POLICY_NUM as PolicyNum
From
  ATTORNEY_CONFLICT
Where
  ATTORNEY_CONFLICT.ATTORNEY_CONFLICT_SEQ_NUM = :AttorneyConflictSeqNum

-- plus matching Insert/Update/Delete statements and a Create-sequence Select per object.
-- Each of the other 7 TableMaint objects listed above repeats this same CRUD shape against
-- its own table (see database-tables.md for the per-table column detail); the exact column
-- lists for those other 7 objects were **not individually reconstructed here — consolidated
-- to avoid ~40 near-duplicate single-purpose pages, per the DB analysis's own consolidation
-- approach. Treat the non-clsAttorneyConflict statements as unverified until inspected
-- directly against their respective .vb source files.

Operations and processes¶

Business rules¶

Sources¶

SAIF.Business.Claim.Legal\TableMaint\ (clsAttorneyConflict.vb, clsAttorneyWorkerAssignment.vb, clsLegalPersonType.vb, clsOtherFirm.vb, clsOutOFTownRotationAssgn.vb, clsHearingLocation.vb)