Skip to content

SAIF.Business.Claim.Authority database tables

This page catalogs the Oracle tables used by SAIF.Business.Claim.Authority.

Table catalog

Table Database Schema/Link CRUD Purpose Primary business object
CL_CLAIM_AUTH_PURPOSE_CODE Oracle [unqualified]** R Supports Criteria data access. Criteria
CL_CLAIM_AUTH_TYPE_CODE Oracle [unqualified]** R Supports Criteria data access. Criteria
CL_CLAIM_BUS_FUNCTION_CODE Oracle [unqualified]** R Supports Criteria data access. Criteria
CL_CLAIM_BUS_PROCESS_CODE Oracle [unqualified]** R Supports Criteria data access. Criteria
CL_CLAIM_EMP_AUTH_TYPE Oracle [unqualified]** C/D/R/U Supports Criteria data access. Criteria
CL_CLAIM_EMP_BUS_FUNC_LIMIT Oracle [unqualified]** C/D/R/U Supports Criteria data access. Criteria
CL_CLAIM_EMP_CAT_CHANGE_LIMIT Oracle [unqualified]** C/D/R/U Supports Criteria data access. Criteria
CL_CLM_EMP_BUS_FUN_LIM_SEQ Oracle [unqualified]** R Supports Criteria data access. Criteria
CL_CLM_EMP_CAT_CHG_LIM_SEQ Oracle [unqualified]** R Supports Criteria data access. Criteria

CL_CLAIM_AUTH_PURPOSE_CODE

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supports Criteria data access in SAIF.Business.Claim.Authority.
Access pattern direct SQL
CRUD operations R
Key columns used B, C, CLAIM_BUS_PROCESS_CODE, CL_CLAIM_AUTH_PURPOSE_CODE, CODE, CODE_DESCR, D, F, N, O
Sequence N/A
Related tables CL_CLAIM_AUTH_PURPOSE_CODE
Business objects Criteria

SQL referencing this table

CL_CLAIM_AUTH_TYPE_CODE

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supports Criteria data access in SAIF.Business.Claim.Authority.
Access pattern direct SQL
CRUD operations R
Key columns used C, CL_CLAIM_AUTH_TYPE_CODE, CODE, CODE_DESCR, D, F, N, O, S, U
Sequence N/A
Related tables CL_CLAIM_AUTH_TYPE_CODE
Business objects Criteria

SQL referencing this table

CL_CLAIM_BUS_FUNCTION_CODE

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supports Criteria data access in SAIF.Business.Claim.Authority.
Access pattern direct SQL
CRUD operations R
Key columns used B, C, CLAIM_BUS_PROCESS_CODE, CL_CLAIM_BUS_FUNCTION_CODE, CODE, CODE_DESCR, CODE_LONG_DESCR, D, F, L
Sequence N/A
Related tables CL_CLAIM_BUS_FUNCTION_CODE
Business objects Criteria

SQL referencing this table

CL_CLAIM_BUS_PROCESS_CODE

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supports Criteria data access in SAIF.Business.Claim.Authority.
Access pattern direct SQL
CRUD operations R
Key columns used C, CL_CLAIM_BUS_PROCESS_CODE, CODE, CODE_DESCR, CODE_LONG_DESCR, D, F, L, N, O
Sequence N/A
Related tables CL_CLAIM_BUS_PROCESS_CODE
Business objects Criteria

SQL referencing this table

CL_CLAIM_EMP_AUTH_TYPE

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supports Criteria data access in SAIF.Business.Claim.Authority.
Access pattern direct SQL
CRUD operations C/D/R/U
Key columns used A, AND, B, C, CLAIM_AUTH_TYPE_CODE, CLAIM_BUS_PROCESS_CODE, CL_CLAIM_EMP_AUTH_TYPE, D, E, EMPLOYEE_EMPLID
Sequence N/A
Related tables CL_CLAIM_EMP_AUTH_TYPE
Business objects Criteria

SQL referencing this table

CL_CLAIM_EMP_BUS_FUNC_LIMIT

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supports Criteria data access in SAIF.Business.Claim.Authority.
Access pattern direct SQL
CRUD operations C/D/R/U
Key columns used A, AND, AS, AUTHORIZED_BY_EMPLID, B, C, CLAIM_AUTH_PURPOSE_CODE, CLAIM_BUS_FUNCTION_CODE, CLAIM_BUS_PROCESS_CODE, CL_CLAIM_EMP_BUS_FUNC_LIMIT
Sequence N/A
Related tables CL_CLAIM_EMP_BUS_FUNC_LIMIT
Business objects Criteria

SQL referencing this table

CL_CLAIM_EMP_CAT_CHANGE_LIMIT

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supports Criteria data access in SAIF.Business.Claim.Authority.
Access pattern direct SQL
CRUD operations C/D/R/U
Key columns used A, AS, AUTHORIZED_BY_EMPLID, B, C, CLAIM_AUTH_PURPOSE_CODE, CLAIM_COST_CATEGORY_CODE, CL_CLAIM_EMP_CAT_CHANGE_LIMIT, CL_CLM_EMP_CAT_CHG_LIM_SEQ_NUM, D
Sequence N/A
Related tables CL_CLAIM_EMP_CAT_CHANGE_LIMIT
Business objects Criteria

SQL referencing this table

CL_CLM_EMP_BUS_FUN_LIM_SEQ

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supports Criteria data access in SAIF.Business.Claim.Authority.
Access pattern direct SQL
CRUD operations R
Key columns used N/A
Sequence CL_CLM_EMP_BUS_FUN_LIM_SEQ
Related tables N/A
Business objects Criteria

CL_CLM_EMP_CAT_CHG_LIM_SEQ

Field Value
Database Oracle
Schema/Link [unqualified]**
Purpose Supports Criteria data access in SAIF.Business.Claim.Authority.
Access pattern direct SQL
CRUD operations R
Key columns used N/A
Sequence CL_CLM_EMP_CAT_CHG_LIM_SEQ
Related tables N/A
Business objects Criteria

Table relationship diagram

The following diagram shows the relationships identified in this library's SQL.

erDiagram

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.Claim.Authority\clsClaimEmpBusFuncLimit.vb
  • Business\SAIF.Business.Claim.Authority\clsClaimEmpCatChangeLimit.vb
  • Business\SAIF.Business.Claim.Authority\clsClaimEmpAuthType.vb
  • Business\SAIF.Business.Claim.Authority\clsClaimAuthPurposeCode.vb
  • Business\SAIF.Business.Claim.Authority\clsClaimAuthPurposeCodeCollection.vb
  • Business\SAIF.Business.Claim.Authority\clsClaimAuthTypeCode.vb
  • Business\SAIF.Business.Claim.Authority\clsClaimAuthTypeCodeCollection.vb
  • Business\SAIF.Business.Claim.Authority\clsClaimBusFunctionCode.vb
  • Business\SAIF.Business.Claim.Authority\clsClaimBusFunctionCodeCollection.vb
  • Business\SAIF.Business.Claim.Authority\clsClaimBusProcessCode.vb
  • Business\SAIF.Business.Claim.Authority\clsClaimBusProcessCodeCollection.vb
  • Business\SAIF.Business.Claim.Authority\clsClaimEmpBusFuncLimitCollection.vb
  • Business\SAIF.Business.Claim.Authority\clsClaimEmpCatChangeLimitCollection.vb
  • Business\SAIF.Business.Claim.Authority\SAIF.BOF.Business.Claim.Authority.vbproj