SQL-120 to SQL-150: Code table read operations

All 31 statements in this group live in mdlCodeTables.vb and are simple SELECT code/description projections with ORDER BY sorting loaded into CTB.CodeTable / ExtendedCodeMap caches. They share a single structural pattern shown below; per-entry sections list the specific class and target table/line.

Classification (applies to all entries in this group)

Field	Value
Operation type	Read
Execution method	Inline SQL (SQL-132 is Stored procedure)
Database	Oracle
Schema	[unqualified]**
Command type	Text (StoredProcedure for SQL-132)
Business object	mdlCodeTables cache classes
Criteria property	N/A (Application layer)
Lifecycle method	N/A

Sample SQL (common pattern)

SELECT CODE          AS Code,
       DESCRIPTION   AS Description,
       EFF_DATE      AS EffDate,
       EXP_DATE      AS ExpDate
FROM   <code_table>
ORDER  BY DESCRIPTION

All 31 code-table statements follow this shape against their respective *_CODE table (or ADP_EMPLOYEE / PROVIDER_LOCATION / LEGAL_PERSON for the staff and firm pick-lists). Results are cached in CTB.CodeTable / ExtendedCodeMap.*

Entries

SQL-120 clsALJList

Field	Value
SQL ID	SQL-120
Class	clsALJList
Type	Inline
Target	ADP_EMPLOYEE / attorney filter
Line	68

Tables

Table	Access	Columns used
ADP_EMPLOYEE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-121 clsActiveAttorneyList

Field	Value
SQL ID	SQL-121
Class	clsActiveAttorneyList
Type	Inline
Target	ADP_EMPLOYEE + ATTORNEY_PROFILE
Line	102

Tables

Table	Access	Columns used
ADP_EMPLOYEE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE
ATTORNEY_PROFILE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-122 clsAttorneyScheduleTypeCodes

Field	Value
SQL ID	SQL-122
Class	clsAttorneyScheduleTypeCodes
Type	Inline
Target	ATTORNEY_SCHEDULE_TYPE_CODE
Line	134

Tables

Table	Access	Columns used
ATTORNEY_SCHEDULE_TYPE_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-123 clsAttorneyTypeCodes

Field	Value
SQL ID	SQL-123
Class	clsAttorneyTypeCodes
Type	Inline
Target	ATTORNEY_TYPE_CODE
Line	158

Tables

Table	Access	Columns used
ATTORNEY_TYPE_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-124 clsBodyPartCodes

Field	Value
SQL ID	SQL-124
Class	clsBodyPartCodes
Type	Inline
Target	LEGAL_BODY_PART_CODE
Line	195

Tables

Table	Access	Columns used
LEGAL_BODY_PART_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-125 clsCancelledByCodes

Field	Value
SQL ID	SQL-125
Class	clsCancelledByCodes
Type	Inline
Target	CANCELLED_BY_CODE
Line	220

Tables

Table	Access	Columns used
CANCELLED_BY_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-126 clsCaseStatusCodes

Field	Value
SQL ID	SQL-126
Class	clsCaseStatusCodes
Type	Inline
Target	CASE_STATUS_CODE
Line	243

Tables

Table	Access	Columns used
CASE_STATUS_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-127 clsDurationCodes

Field	Value
SQL ID	SQL-127
Class	clsDurationCodes
Type	Inline
Target	DURATION_CODE
Line	296

Tables

Table	Access	Columns used
DURATION_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-128 clsFileLocationCodes

Field	Value
SQL ID	SQL-128
Class	clsFileLocationCodes
Type	Inline
Target	LEGAL_FILE_LOCATION_CODE
Line	321

Tables

Table	Access	Columns used
LEGAL_FILE_LOCATION_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-129 clsHearingLocationCodes

Field	Value
SQL ID	SQL-129
Class	clsHearingLocationCodes
Type	Inline
Target	HEARING_LOCATION_CODE
Line	345

Tables

Table	Access	Columns used
HEARING_LOCATION_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-130 clsHearingLocationList

Field	Value
SQL ID	SQL-130
Class	clsHearingLocationList
Type	Inline
Target	HEARING_LOCATION
Line	367

Tables

Table	Access	Columns used
HEARING_LOCATION	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-131 clsLegalStaffList

Field	Value
SQL ID	SQL-131
Class	clsLegalStaffList
Type	Inline
Target	ADP_EMPLOYEE
Line	402

Tables

Table	Access	Columns used
ADP_EMPLOYEE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-132 clsLegalStaffList (proc path)

Field	Value
SQL ID	SQL-132
Class	clsLegalStaffList (proc path)
Type	StoredProc
Target	pk80001_legalnet.SelectLegalEmployees
Line	416

Tables

Table	Access	Columns used

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-133 clsMessageAttorneyList

Field	Value
SQL ID	SQL-133
Class	clsMessageAttorneyList
Type	Inline
Target	ADP_EMPLOYEE + ATTORNEY_PROFILE
Line	444

Tables

Table	Access	Columns used
ADP_EMPLOYEE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE
ATTORNEY_PROFILE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-134 clsNatureCodes

Field	Value
SQL ID	SQL-134
Class	clsNatureCodes
Type	Inline
Target	NATURE_CODE
Line	482

Tables

Table	Access	Columns used
NATURE_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-135 clsNoteCategoryCodes

Field	Value
SQL ID	SQL-135
Class	clsNoteCategoryCodes
Type	Inline
Target	NOTE_CATEGORY_CODE
Line	506

Tables

Table	Access	Columns used
NOTE_CATEGORY_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-136 clsOutcomeGroundsCodes

Field	Value
SQL ID	SQL-136
Class	clsOutcomeGroundsCodes
Type	Inline
Target	OUTCOME_GROUNDS_CODE
Line	530

Tables

Table	Access	Columns used
OUTCOME_GROUNDS_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-137 clsOutcomeIssueCodes

Field	Value
SQL ID	SQL-137
Class	clsOutcomeIssueCodes
Type	Inline
Target	OUTCOME_ISSUE_CODE
Line	567

Tables

Table	Access	Columns used
OUTCOME_ISSUE_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-138 clsOutsideCouselFirmList

Field	Value
SQL ID	SQL-138
Class	clsOutsideCouselFirmList
Type	Inline
Target	PROVIDER_LOCATION
Line	591

Tables

Table	Access	Columns used
PROVIDER_LOCATION	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-139 clsOutsideCouselList

Field	Value
SQL ID	SQL-139
Class	clsOutsideCouselList
Type	Inline
Target	LEGAL_PERSON
Line	613

Tables

Table	Access	Columns used
LEGAL_PERSON	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-140 clsOrderTypeCodes

Field	Value
SQL ID	SQL-140
Class	clsOrderTypeCodes
Type	Inline
Target	ORDER_TYPE_CODE
Line	654

Tables

Table	Access	Columns used
ORDER_TYPE_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-141 clsOtherFirmTypeCodes

Field	Value
SQL ID	SQL-141
Class	clsOtherFirmTypeCodes
Type	Inline
Target	OTHER_FIRM_TYPE_CODE
Line	679

Tables

Table	Access	Columns used
OTHER_FIRM_TYPE_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-142 clsPetitionerRespondentCodes

Field	Value
SQL ID	SQL-142
Class	clsPetitionerRespondentCodes
Type	Inline
Target	PETITIONER_RESPONDENT_CODE
Line	703

Tables

Table	Access	Columns used
PETITIONER_RESPONDENT_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-143 clsRequestedByCodes

Field	Value
SQL ID	SQL-143
Class	clsRequestedByCodes
Type	Inline
Target	REQUESTED_BY_CODE
Line	727

Tables

Table	Access	Columns used
REQUESTED_BY_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-144 clsRequestIssueCodes

Field	Value
SQL ID	SQL-144
Class	clsRequestIssueCodes
Type	Inline
Target	REQUEST_ISSUE_CODE
Line	751

Tables

Table	Access	Columns used
REQUEST_ISSUE_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-145 clsRequestTypeCodes

Field	Value
SQL ID	SQL-145
Class	clsRequestTypeCodes
Type	Inline
Target	REQUEST_TYPE_CODE
Line	896

Tables

Table	Access	Columns used
REQUEST_TYPE_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-146 clsReviewLevelCodes

Field	Value
SQL ID	SQL-146
Class	clsReviewLevelCodes
Type	Inline
Target	REVIEW_LEVEL_CODE
Line	933

Tables

Table	Access	Columns used
REVIEW_LEVEL_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-147 clsSAIFStaffList

Field	Value
SQL ID	SQL-147
Class	clsSAIFStaffList
Type	Inline
Target	ADP_EMPLOYEE
Line	958

Tables

Table	Access	Columns used
ADP_EMPLOYEE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-148 clsScheduleStatusCodes

Field	Value
SQL ID	SQL-148
Class	clsScheduleStatusCodes
Type	Inline
Target	SCHEDULE_STATUS_CODE
Line	999

Tables

Table	Access	Columns used
SCHEDULE_STATUS_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-149 clsScheduleTypeCodes

Field	Value
SQL ID	SQL-149
Class	clsScheduleTypeCodes
Type	Inline
Target	SCHEDULE_TYPE_CODE
Line	1040

Tables

Table	Access	Columns used
SCHEDULE_TYPE_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

SQL-150 clsScheduleALJList clsServiceCodes

Field	Value
SQL ID	SQL-150
Class	clsScheduleALJList / clsServiceCodes
Type	Inline
Target	ADP_EMPLOYEE (1104) / SERVICE_CODE (1133)
Line	1104, 1133

Tables

Table	Access	Columns used
ADP_EMPLOYEE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE
SERVICE_CODE	SELECT	CODE, DESCRIPTION, EFF_DATE, EXP_DATE

Sources

• SAIF.Business.Claim.Legal\mdlCodeTables.vb

---

Related documentation

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

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.