SAIF.Business database tables¶

This page catalogs Oracle tables, views, and grouped lookup tables accessed by SAIF.Business.

Table catalog¶

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
ADP_EMPLOYEE	Oracle	[unqualified]**	R	Used by clsEmployeeData, clsEmployeeDataCollection.	`clsEmployeeData`, `clsEmployeeDataCollection`
ADP_EMPLOYEE_PHONE_VIEW	Oracle	[unqualified]**	R	Used by clsEmployeeData.	`clsEmployeeData`
ADP_VIRTUAL_EMPLOYEE_VIEW	Oracle	[unqualified]**	R	Used by ClaimServices.	`ClaimServices`
ALL_STATES	Oracle	[unqualified]**	R	Used by clsAddress, ObjectServices.	`clsAddress`, `ObjectServices`
APPLICATION_HELP_DETAIL	Oracle	[unqualified]**	R	Used by clsHelpText, clsHelpTextCollection.	`clsHelpText`, `clsHelpTextCollection`
APPLICATION_HELP_MASTER	Oracle	[unqualified]**	R	Used by clsHelpTextCollection.	`clsHelpTextCollection`
COUNTRY	Oracle	[unqualified]**	R	Used by clsAddress, clsAddressStructure.	`clsAddress`, `clsAddressStructure`
EMPLOYEE_LEAVE	Oracle	[unqualified]**	C/R/U/D	Used by clsEmployeeLeave, clsEmployeeLeaveCollection.	`clsEmployeeLeave`, `clsEmployeeLeaveCollection`
EXT_USER / EXT_USER_TYPE	Oracle	[unqualified]**	R	Used by ExternalUserServices.	`ExternalUserServices`
IMAGE / IMGSYS	Oracle	[unqualified]**	R	Used by ImageInfo.	`ImageInfo`
LANGUAGE_TRANSLATION	Oracle	[unqualified]**	R	Used by clsLanguageTranslation, clsLanguageTranslationCollection.	`clsLanguageTranslation`, `clsLanguageTranslationCollection`
LOCATION	Oracle	[unqualified]**	R	Used by clsSAIFOutputAddress.	`clsSAIFOutputAddress`
MCO_PLAN / MCO_GSA_LOCATION	Oracle	[unqualified]**	R	Used by MCOInfo.	`MCOInfo`
POLICY / POLICY_PERIOD_ALL / POLICY_PERIOD_MASTER / US_POLICY_UNIT	Oracle	[unqualified]**	R	Used by PolicyServices, UnitStatServices.	`PolicyServices`, `UnitStatServices`
RECORDING	Oracle	[unqualified]**	R	Used by ImageServices.	`ImageServices`
PDF_CONVERSION_ERROR	Oracle	[unqualified]**	C	Used by ImageServices.	`ImageServices`
ZIP_CODE / ZIP_MCO_COUNTY	Oracle	[unqualified]**	R	Used by clsAddress, clsAddressStructure.	`clsAddress`, `clsAddressStructure`
CL_INJURY_CLAIM / CL_CLAIM_RESPONSIBILITY	Oracle	[unqualified]**	R	Used by ClaimServices.	`ClaimServices`
CL_FINANCIAL_TRANS / CL_FINANCIAL_TRANS_DTL	Oracle	[unqualified]**	R	Used by ClaimServices.	`ClaimServices`
CL_INCURRED_COST_HISTORY / CL_INCURRED_CATEGORY_COST	Oracle	[unqualified]**	R	Used by ClaimServices.	`ClaimServices`
CL_SECURITY_OVERRIDE	Oracle	[unqualified]**	R	Used by ClaimServices.	`ClaimServices`
LEGAL_CASE / LEGAL_COLLECTION / INVESTIGATION / CL_CLAIM_SUPPORT_ORDER_CONN	Oracle	[unqualified]**	R	Used by ClaimServices.	`ClaimServices`
CL_PHARMACY_ELIGIBILITY_REPORT	Oracle	[unqualified]**	U	Used by ClaimServices.	`ClaimServices`
PAYMENT_TRANSACTION_TYPE_CODE	Oracle	[unqualified]**	U	Used by ClaimServices.	`ClaimServices`
BANK_ACCOUNT	Oracle	[unqualified]**	R	Used by ClaimServices, EFTServices.	`ClaimServices`, `EFTServices`
PAYMENT_AUTHORIZATION	Oracle	[unqualified]**	R	Used by ClaimServices, EFTServices.	`ClaimServices`, `EFTServices`
DEBIT_CARD_ENROLLMENT_REQUEST	Oracle	[unqualified]**	R	Used by EFTServices.	`EFTServices`
CL_CLAIM_EMP_BUS_FUNC_LIMIT	Oracle	[unqualified]**	R	Used by ClaimServices.	`ClaimServices`
NON_EMPR_ACCT	Oracle	[unqualified]**	R	Used by PolicyServices.	`PolicyServices`
VIRTUAL_EMPLOYEE	Oracle	[unqualified]**	R	Used by clsEmployeeData.	`clsEmployeeData`
LEAVE_TYPE_CODE	Oracle	[unqualified]**	R	Used by clsEmployeeLeaveCollection.	`clsEmployeeLeaveCollection`
DUAL	Oracle	`SYS`*	R	Used by clsHelpText, ClaimServices.	`clsHelpText`, `ClaimServices`
WCIS_EMPLOYEE	Oracle	[unqualified]**	R	Used by clsEmployeeData.	`clsEmployeeData`
Code/lookup tables (`EMAIL_CODE`, `ADDRESS_CODE`, `PHONE_CODE`, `COMPANY_CODE`, `RELATIONSHIP_CODE`, `ETHNIC_GROUP_CODE`, `CL_LANGUAGE_PREFERENCE_CODE`, `CL_BENEFIT_TYPE_CODE`, `CL_JURISDICTION_CODE`, `COUNTRY_CODE`, `CL_RELATIONSHIP_TO_WORKER_CODE`, `CLAIM_PERSON_CODE`, `CL_PAYMENT_CATEGORY_CODE`, `CL_REIMB_PROGRAM_CODE`, `CLAIM_DECISION_CODE`, `CL_REQUEST_TYPE_CODE`, `OWN_MOTION_REASON_CODE`, `EAIP_EXPENSE_TYPE_CODE`, `RTW_LOAD_CODE`, `CL_WAGE_PERIOD_PAY_UNIT_CODE`, `CL_SETTLEMENT_FULL_PART_CODE`, `CL_FINANCIAL_TRANS_TYPE_CODE`, `CL_CLAIM_COST_CATEGORY_CODE`, `CL_CLAIM_TYPE_CODE`, `CL_CLAIM_TYPE_GCODE`, `CLAIM_STATUS_CODE`, `CL_CLAIM_STATUS_GCODE`)	Oracle	[unqualified]**	R	Used by mdlCodeMaps, GlobalizationServices.	`mdlCodeMaps`, `GlobalizationServices`

ADP_EMPLOYEE¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `clsEmployeeData`, `clsEmployeeDataCollection`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`clsEmployeeData`, `clsEmployeeDataCollection`

Operations referencing this table¶

Business rules referencing this table¶

BR-SB-011: Employee collection retrieval appends literal filter predicates
PROC-RULE-033: Claim authorization exists only when the employee has a matching business-process/function-limit row with a sufficient maximum amount.

SQL referencing this table¶

ADP_EMPLOYEE_PHONE_VIEW¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `clsEmployeeData`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`clsEmployeeData`

Operations referencing this table¶

Employee profile retrieval

SQL referencing this table¶

SQL-025

ADP_VIRTUAL_EMPLOYEE_VIEW¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `ClaimServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`ClaimServices`

Operations referencing this table¶

Claim authorization and visibility checks

SQL referencing this table¶

SQL-014

ALL_STATES¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `clsAddress`, `ObjectServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`clsAddress`, `ObjectServices`

Operations referencing this table¶

Address validation and external-user reporting

SQL referencing this table¶

SQL-022

APPLICATION_HELP_DETAIL¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `clsHelpText`, `clsHelpTextCollection`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	`REFERENCE_KEY_VALUE_NEXTVAL`
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`clsHelpText`, `clsHelpTextCollection`

Operations referencing this table¶

Help text retrieval

SQL referencing this table¶

APPLICATION_HELP_MASTER¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `clsHelpTextCollection`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	`REFERENCE_KEY_VALUE_NEXTVAL`
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`clsHelpTextCollection`

Operations referencing this table¶

Help text retrieval

SQL referencing this table¶

SQL-030

COUNTRY¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `clsAddress`, `clsAddressStructure`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`clsAddress`, `clsAddressStructure`

Operations referencing this table¶

Business rules referencing this table¶

SQL referencing this table¶

SQL-022

EMPLOYEE_LEAVE¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `clsEmployeeLeave`, `clsEmployeeLeaveCollection`.
Access pattern	direct SQL / stored procedure
CRUD operations	C/R/U/D
Key columns used	See the linked SQL documents for exact column usage.
Sequence	`EMPLOYEE_LEAVE_SEQ`*
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`clsEmployeeLeave`, `clsEmployeeLeaveCollection`

Operations referencing this table¶

Employee leave persistence

Business rules referencing this table¶

SQL referencing this table¶

EXT_USER / EXT_USER_TYPE¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `ExternalUserServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`ExternalUserServices`

IMAGE / IMGSYS¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `ImageInfo`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`ImageInfo`

Operations referencing this table¶

Imaging lookup and alert support

SQL referencing this table¶

SQL-037

LANGUAGE_TRANSLATION¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `clsLanguageTranslation`, `clsLanguageTranslationCollection`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`clsLanguageTranslation`, `clsLanguageTranslationCollection`

Operations referencing this table¶

Language translation retrieval

SQL referencing this table¶

LOCATION¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `clsSAIFOutputAddress`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`clsSAIFOutputAddress`

Operations referencing this table¶

Business rules referencing this table¶

SQL referencing this table¶

SQL-033

MCO_PLAN / MCO_GSA_LOCATION¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `MCOInfo`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`MCOInfo`

Operations referencing this table¶

Lookup and reference-data hydration

SQL referencing this table¶

SQL-039

POLICY / POLICY_PERIOD_ALL / POLICY_PERIOD_MASTER / US_POLICY_UNIT¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `PolicyServices`, `UnitStatServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`PolicyServices`, `UnitStatServices`

Operations referencing this table¶

Policy and unit-stat support

Business rules referencing this table¶

SQL referencing this table¶

RECORDING¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `ImageServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`ImageServices`

Operations referencing this table¶

Imaging lookup and alert support

Business rules referencing this table¶

PDF_CONVERSION_ERROR¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `ImageServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	C
Key columns used	See the linked SQL documents for exact column usage.
Sequence	`PDF_CONVERSION_ERROR_SEQ`
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`ImageServices`

Operations referencing this table¶

Imaging lookup and alert support

SQL referencing this table¶

SQL-003

ZIP_CODE / ZIP_MCO_COUNTY¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `clsAddress`, `clsAddressStructure`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`clsAddress`, `clsAddressStructure`

Operations referencing this table¶

Address validation and external-user reporting

SQL referencing this table¶

SQL-022

CL_INJURY_CLAIM / CL_CLAIM_RESPONSIBILITY¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `ClaimServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`ClaimServices`

Operations referencing this table¶

Claim authorization and visibility checks

Business rules referencing this table¶

SQL referencing this table¶

CL_FINANCIAL_TRANS / CL_FINANCIAL_TRANS_DTL¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `ClaimServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`ClaimServices`

Operations referencing this table¶

Claim authorization and visibility checks

Business rules referencing this table¶

BR-SB-010: Benefit-payment history checks map business context to payment-category filters

SQL referencing this table¶

CL_INCURRED_COST_HISTORY / CL_INCURRED_CATEGORY_COST¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `ClaimServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`ClaimServices`

SQL referencing this table¶

SQL-016

CL_SECURITY_OVERRIDE¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `ClaimServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`ClaimServices`

Operations referencing this table¶

Claim authorization and visibility checks

SQL referencing this table¶

SQL-014

LEGAL_CASE / LEGAL_COLLECTION / INVESTIGATION / CL_CLAIM_SUPPORT_ORDER_CONN¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `ClaimServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`ClaimServices`

Operations referencing this table¶

Imaging lookup and alert support

Business rules referencing this table¶

PROC-RULE-004: Claim image alerting is enabled only when at least one flagged legal case exists for the claim.

SQL referencing this table¶

CL_PHARMACY_ELIGIBILITY_REPORT¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `ClaimServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	U
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`ClaimServices`

SQL referencing this table¶

SQL-044

PAYMENT_TRANSACTION_TYPE_CODE¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `ClaimServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	U
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`ClaimServices`

SQL referencing this table¶

SQL-045

WCIS_EMPLOYEE¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `clsEmployeeData`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`clsEmployeeData`

Operations referencing this table¶

Employee profile retrieval

SQL referencing this table¶

SQL-024

Code/lookup tables (`EMAIL_CODE`, `ADDRESS_CODE`, `PHONE_CODE`, `COMPANY_CODE`, `RELATIONSHIP_CODE`, `ETHNIC_GROUP_CODE`, `CL_LANGUAGE_PREFERENCE_CODE`, `CL_BENEFIT_TYPE_CODE`, `CL_JURISDICTION_CODE`, `COUNTRY_CODE`, `CL_RELATIONSHIP_TO_WORKER_CODE`, `CLAIM_PERSON_CODE`, `CL_PAYMENT_CATEGORY_CODE`, `CL_REIMB_PROGRAM_CODE`, `CLAIM_DECISION_CODE`, `CL_REQUEST_TYPE_CODE`, `OWN_MOTION_REASON_CODE`, `EAIP_EXPENSE_TYPE_CODE`, `RTW_LOAD_CODE`, `CL_WAGE_PERIOD_PAY_UNIT_CODE`, `CL_SETTLEMENT_FULL_PART_CODE`, `CL_FINANCIAL_TRANS_TYPE_CODE`, `CL_CLAIM_COST_CATEGORY_CODE`, `CL_CLAIM_TYPE_CODE`, `CL_CLAIM_TYPE_GCODE`, `CLAIM_STATUS_CODE`, `CL_CLAIM_STATUS_GCODE`)¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by `mdlCodeMaps`, `GlobalizationServices`.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	See the linked SQL documents for exact column usage.
Sequence	N/A
Related tables	See the relationship diagram and linked SQL documents.
Business objects	`mdlCodeMaps`, `GlobalizationServices`

BANK_ACCOUNT¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports EFT authorization status checks by providing bank-account status and prenote fields.
Access pattern	stored procedure
CRUD operations	R
Key columns used	`BANK_ACCOUNT_SEQ_NUM`, `BANK_ACCOUNT_STATUS_CODE`, `PRENOTE_REQUIRED_FLAG`, `PRENOTE_SUCCESS_DATE`
Sequence	N/A
Related tables	`PAYMENT_AUTHORIZATION`
Business objects	`ClaimServices`, `EFTServices`

SQL referencing this table¶

CL_CLAIM_EMP_BUS_FUNC_LIMIT¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores claim authorization limits used to decide whether an employee can release or approve a payment or reserve.
Access pattern	stored procedure
CRUD operations	R
Key columns used	`EMPLOYEE_EMPLID`, `CLAIM_BUS_PROCESS_CODE`, `CLAIM_AUTH_PURPOSE_CODE`, `CLAIM_BUS_FUNCTION_CODE`, `MAX_AMOUNT`
Sequence	N/A
Related tables	`ADP_EMPLOYEE`
Business objects	`ClaimServices`

SQL referencing this table¶

SQL-018

DEBIT_CARD_ENROLLMENT_REQUEST¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Tracks debit-card enrollment rows counted by EFT card-enrollment helpers.
Access pattern	stored procedure
CRUD operations	R
Key columns used	`CARDHOLDER_ID_NUM`, `CARD_TERM_DATE`
Sequence	N/A
Related tables	N/A
Business objects	`EFTServices`

SQL referencing this table¶

SQL-035

DUAL¶

Field	Value
Database	Oracle
Schema/Link	`SYS`*
Purpose	Oracle pseudo-table used when the library needs a single-row scalar or cursor-backed projection instead of a persisted business table.
Access pattern	direct SQL / stored procedure
CRUD operations	R
Key columns used	Pseudo-columns only; no persisted business columns are read.
Sequence	`REFERENCE_KEY_VALUE_NEXTVAL`
Related tables	N/A
Business objects	`clsHelpText`, `ClaimServices`

SQL referencing this table¶

LEAVE_TYPE_CODE¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supplies descriptive leave-type text for employee-leave result sets.
Access pattern	stored procedure
CRUD operations	R
Key columns used	`CODE`, `CODE_DESCR`
Sequence	N/A
Related tables	`EMPLOYEE_LEAVE`
Business objects	`clsEmployeeLeaveCollection`

SQL referencing this table¶

SQL-028

NON_EMPR_ACCT¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores low-number non-employer accounts used by policy validation logic.
Access pattern	direct SQL
CRUD operations	R
Key columns used	`ACCT_NUM`
Sequence	N/A
Related tables	`POLICY`
Business objects	`PolicyServices`

SQL referencing this table¶

SQL-042

PAYMENT_AUTHORIZATION¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores EFT payment authorization rows returned or counted by `pk82350_eft`.
Access pattern	stored procedure
CRUD operations	R
Key columns used	`CUSTOMER_SECOND_ID`, `CUSTOMER_ID`, `CUSTOMER_TYPE_CODE`, `AUTHORIZATION_TYPE_CODE`, `AUTH_DATE`, `REVOKE_DATE`, `BANK_ACCOUNT_SEQ_NUM`, `PAYMENT_AUTHORIZATION_SEQ_NUM`
Sequence	N/A
Related tables	`BANK_ACCOUNT`
Business objects	`ClaimServices`, `EFTServices`

SQL referencing this table¶

VIRTUAL_EMPLOYEE¶

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provides the virtual-employee projection used by the employee retrieval variant that joins supervisor data from `ADP_EMPLOYEE`.
Access pattern	direct SQL
CRUD operations	R
Key columns used	`CITY`, `DEPTID`, `DESCR`, `EMAIL_ADDRESS`, `EMPLID`, `EMPL_STATUS`, `FIRST_NAME`, `LAST_NAME`, `LOCATION`, `MIDDLE_NAME`, `PHONE`, `PHONE_EXTENSION`, `PREFERRED_NAME`, `RPT_MGR_EMPLID`
Sequence	N/A
Related tables	`ADP_EMPLOYEE`
Business objects	`clsEmployeeData`

SQL referencing this table¶

SQL-023

Table relationship diagram¶

The following diagram shows discoverable relationships across the tables and views used by this library.

erDiagram
    CL_CLAIM_RESPONSIBILITY ||--o{ CL_INJURY_CLAIM : "CL_INJURY_CLAIM.CLAIM_RESP_CODE = CL_CLAIM_RESPONSIBILITY.CLAIM_RESP_CODE"
    CL_FINANCIAL_TRANS ||--o{ CL_FINANCIAL_TRANS_DTL : "CL_FINANCIAL_TRANS.CLAIM_FINANCIAL_TRANS_SEQ_NUM = CL_FINANCIAL_TRANS_DTL.CLAIM_FINANCIAL_TRANS_SEQ_NUM"
    CL_INCURRED_COST_HISTORY ||--o{ CL_INCURRED_CATEGORY_COST : "CL_INCURRED_COST_HISTORY.CL_INCURRED_COST_HIST_SEQ_NUM = CL_INCURRED_CATEGORY_COST.CL_INCURRED_COST_HIST_SEQ_NUM"
    ADP_EMPLOYEE ||--o{ ADP_EMPLOYEE : "SPV.EMPLID = ADP.RPT_MGR_EMPLID"
    EXT_USER ||--o{ EXT_USER_TYPE : "EXT_USER_TYPE.EXT_USER_SEQ_NUM = EXT_USER.EXT_USER_SEQ_NUM"
    IMAGE ||--o{ IMGSYS : "IMAGE.TOWID = IMGSYS.TOWID"
    APPLICATION_HELP_MASTER ||--o{ APPLICATION_HELP_DETAIL : "APPLICATION_HELP_MASTER.REFERENCE_KEY_VALUE = APPLICATION_HELP_DETAIL.REFERENCE_KEY_VALUE"
    MCO_PLAN ||--o{ MCO_GSA_LOCATION : "MCO_PLAN.MCO_PLAN_ID = MCO_GSA_LOCATION.MCO_PLAN_ID"
    POLICY ||--o{ POLICY_PERIOD_MASTER : "POLICY.POLICY_NUM = POLICY_PERIOD_MASTER.POLICY_NUM"
    POLICY ||--o{ US_POLICY_UNIT : "US_POLICY_UNIT.POLICY_NUM = POLICY.POLICY_NUM"

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¶

Business\SAIF.Business\ClaimServices.vb
Business\SAIF.Business\clsEmployeeData.vb
Business\SAIF.Business\clsEmployeeDataCollection.vb
Business\SAIF.Business\clsEmployeeLeave.vb
Business\SAIF.Business\clsHelpText.vb
Business\SAIF.Business\clsHelpTextCollection.vb
Business\SAIF.Business\clsLanguageTranslation.vb
Business\SAIF.Business\clsLanguageTranslationCollection.vb
Business\SAIF.Business\clsSAIFOutputAddress.vb
Business\SAIF.Business\ImageInfo.vb
Business\SAIF.Business\ImageServices.vb
Business\SAIF.Business\PolicyServices.vb
Business\SAIF.Business\UnitStatServices.vb
Business\SAIF.Business\MCOInfo.vb
Business\SAIF.Business\mdlCodeMaps.vb
Business\SAIF.Business\ObjectServices.vb
Business\SAIF.Business\EFTServices.vb
Business\SAIF.Business\ContactInfo\clsAddress.vb
Business\SAIF.Business\ContactInfo\clsAddressStructure.vb
Business\SAIF.Business\Services\ExternalUserServices.vb