SQL-001 to SQL-014: Sequence acquisition statements¶

All 14 statements in this group are IBusinessCriteria.CreateSQL implementations of the form SELECT <seq>.NEXTVAL FROM DUAL, executed as a scalar query by the BOF data portal immediately before the matching INSERT. A further 23 sequence names are obtained through the BOF helper GetNextSeqNum("<name>") rather than through explicit CreateSQL text; because the helper issues the equivalent statement inside the framework, its literal text is not present in this repository and is not assigned a SQL ID.*

SQL-001 clsAppeal.Criteria.CreateSQL¶

clsAppeal.Criteria.CreateSQL — Sequence operation against APPEAL_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-001
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAppeal`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT APPEAL_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsAppeal.vb

SQL-002 clsAttorneyConflict.Criteria.CreateSQL¶

clsAttorneyConflict.Criteria.CreateSQL — Sequence operation against ATTORNEY_CONFLICT_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-002
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyConflict`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT ATTORNEY_CONFLICT_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb

SQL-003 clsAttorneyPolicyAssignment.Criteria.CreateSQL¶

clsAttorneyPolicyAssignment.Criteria.CreateSQL — Sequence operation against ATTY_POLICY_ASSGN_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-003
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyPolicyAssignment`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT ATTY_POLICY_ASSGN_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb

SQL-004 clsAttorneySchedule.Criteria.CreateSQL¶

clsAttorneySchedule.Criteria.CreateSQL — Sequence operation against ATTORNEY_SCHEDULE_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-004
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneySchedule`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT ATTORNEY_SCHEDULE_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb

SQL-005 clsAttorneyWorkerAssignment.Criteria.CreateSQL¶

clsAttorneyWorkerAssignment.Criteria.CreateSQL — Sequence operation against ATTORNEY_WORKER_ASSGN_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-005
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyWorkerAssignment`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT ATTORNEY_WORKER_ASSGN_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb

SQL-006 clsCreateFile (print control)¶

clsCreateFile (print control) — Sequence operation against xprint_control_seq.

Classification¶

Field	Value
SQL ID	SQL-006
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsCreateFile (print control)`
Criteria property	`N/A`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT xprint_control_seq.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\Print\clsCreateFile.vb:277

SQL-007 clsHearingLocation.Criteria.CreateSQL¶

clsHearingLocation.Criteria.CreateSQL — Sequence operation against HEARING_LOCATION_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-007
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsHearingLocation`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT HEARING_LOCATION_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb

SQL-008 clsLegalCase.Criteria.CreateSQL¶

clsLegalCase.Criteria.CreateSQL — Sequence operation against LEGAL_CASE_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-008
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalCase`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT LEGAL_CASE_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb

SQL-009 clsLegalPerson.Criteria.CreateSQL¶

clsLegalPerson.Criteria.CreateSQL — Sequence operation against LEGAL_PERSON_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-009
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPerson`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT LEGAL_PERSON_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb

SQL-010 clsLegalPersonType.Criteria.CreateSQL¶

clsLegalPersonType.Criteria.CreateSQL — Sequence operation against LEGAL_PERSON_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-010
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPersonType`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT LEGAL_PERSON_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb

SQL-011 clsLegalSchedule.Criteria.CreateSQL¶

clsLegalSchedule.Criteria.CreateSQL — Sequence operation against SCHEDULE_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-011
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalSchedule`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT SCHEDULE_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb

SQL-012 clsOtherFirm.Criteria.CreateSQL¶

clsOtherFirm.Criteria.CreateSQL — Sequence operation against OTHER_FIRM_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-012
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOtherFirm`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT OTHER_FIRM_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb

SQL-013 clsOutcomeStaff.Criteria.CreateSQL¶

clsOutcomeStaff.Criteria.CreateSQL — Sequence operation against OUTCOME_STAFF_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-013
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutcomeStaff`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT OUTCOME_STAFF_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb

SQL-014 clsOutOFTownRotationAssgn.Criteria.CreateSQL¶

clsOutOFTownRotationAssgn.Criteria.CreateSQL — Sequence operation against OUT_OF_TOWN_ROTATION_SEQ_NUM.

Classification¶

Field	Value
SQL ID	SQL-014
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutOFTownRotationAssgn`
Criteria property	`CreateSQL`
Lifecycle method	See enclosing `Before`/`After` hook in the source class

Tables¶

Table	Access	Columns used
DUAL	SELECT (NEXTVAL)	See Sample SQL below

Sample SQL¶

-- Sequence acquisition
SELECT OUT_OF_TOWN_ROTATION_SEQ_NUM.NEXTVAL
FROM   DUAL

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

See per-SQL-ID Sources subsections above for exact .vb file/line citations.

SQL-001 to SQL-014: Sequence acquisition statements¶

SQL-001 clsAppeal.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-002 clsAttorneyConflict.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-003 clsAttorneyPolicyAssignment.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-004 clsAttorneySchedule.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-005 clsAttorneyWorkerAssignment.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-006 clsCreateFile (print control)¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-007 clsHearingLocation.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-008 clsLegalCase.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-009 clsLegalPerson.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-010 clsLegalPersonType.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-011 clsLegalSchedule.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-012 clsOtherFirm.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-013 clsOutcomeStaff.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

SQL-014 clsOutOFTownRotationAssgn.Criteria.CreateSQL¶

Classification¶

Tables¶

Sample SQL¶

Sources¶

Related documentation¶

Sources¶