SAIF.Business.Provider SQL catalog¶
This page indexes SQL statements identified in the provider library database-analysis findings.
Create operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-016 | Inserts a new m c o plan record into Oracle. | Inline | MCO_PLAN | clsMCOPlan |
| SQL-017 | Inserts a new note record into Oracle. | Inline | CBP_NOTE | clsNote |
| SQL-018 | Inserts a new provider record into Oracle. | Inline | PROVIDER | clsProvider |
| SQL-019 | Inserts a new provider address record into Oracle. | Inline | PROVIDER_ADDRESS | clsProviderAddress |
| SQL-020 | Inserts a new provider address code record into Oracle. | Inline | PROVIDER_ADDRESS_CODE | clsProviderAddressCode |
| SQL-021 | Inserts a new provider contact record into Oracle. | Inline | PROVIDER_CONTACT | clsProviderContact |
| SQL-022 | Inserts a new provider contact code record into Oracle. | Inline | PROVIDER_CONTACT_CODE | clsProviderContactCode |
| SQL-023 | Inserts a new provider dcbs cost charge record into Oracle. | Inline | PROVIDER_DCBS_COST_CHARGE | clsProviderDcbsCostCharge |
| SQL-024 | Inserts a new provider identity record into Oracle. | Inline | PROVIDER_IDENTITY | clsProviderIdentity |
| SQL-025 | Inserts a new provider identity code record into Oracle. | Inline | PROVIDER_IDENTITY_CODE | clsProviderIdentityCode |
| SQL-026 | Inserts a new provider ineligibility period record into Oracle. | Inline | PROVIDER_INELIG_PERIOD | clsProviderIneligibilityPeriod |
| SQL-027 | Inserts a new provider ineligibility reason code record into Oracle. | Inline | PROVIDER_INELIG_REASON_CD | clsProviderIneligibilityReasonCode |
| SQL-028 | Inserts a new provider location record into Oracle. | Inline | PROVIDER_LOCATION | clsProviderLocation |
| SQL-029 | Inserts a new provider m c o membership record into Oracle. | Inline | MCO_PROVIDER | clsProviderMCOMembership |
| SQL-030 | Inserts a new provider relationship record into Oracle. | Inline | PROVIDER_RELATIONSHIP | clsProviderRelationship |
| SQL-031 | Inserts a new provider relationship code record into Oracle. | Inline | PROVIDER_RELATIONSHIP_CODE | clsProviderRelationshipCode |
| SQL-032 | Inserts a new provider service record into Oracle. | Inline | PROVIDER_SERVICE | clsProviderService |
| SQL-033 | Inserts a new provider service code record into Oracle. | Inline | PROVIDER_SERVICE_CODE | clsProviderServiceCode |
| SQL-034 | Inserts a new provider service contract record into Oracle. | Inline | PROVIDER_SERVICE_CONTRACT | clsProviderServiceContract |
| SQL-035 | Inserts a new provider service type record into Oracle. | Inline | PROVIDER_SERVICE_TYPE | clsProviderServiceType |
| SQL-036 | Inserts a new provider tax i d record into Oracle. | Inline | PROVIDER_TAX_ID | clsProviderTaxID |
| SQL-037 | Inserts a new provider type code record into Oracle. | Inline | PROVIDER_TYPE_CODE | clsProviderTypeCode |
Read operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-038 | Retrieves c b p service data from Oracle. | Inline | CBP_SERVICE_CODE, CBP_SERVICE_DESCRIPTION | clsCBPService |
| SQL-039 | Retrieves c b p service type data from Oracle. | Inline | CBP_SERVICE_TYPE_CODE | clsCBPServiceType |
| SQL-040 | Retrieves m c o plan data from Oracle. | Inline | MCO_PLAN | clsMCOPlan |
| SQL-041 | Retrieves note data from Oracle. | Inline | CBP_NOTE, CBP_NOTE_TYPE_CODE | clsNote |
| SQL-042 | Retrieves provider data from Oracle. | Inline | PROVIDER | clsProvider |
| SQL-043 | Retrieves provider address data from Oracle. | Inline | PROVIDER_ADDRESS | clsProviderAddress |
| SQL-044 | Retrieves provider address code data from Oracle. | Inline | PROVIDER_ADDRESS_CODE | clsProviderAddressCode |
| SQL-045 | Retrieves provider contact data from Oracle. | Inline | PROVIDER_CONTACT | clsProviderContact |
| SQL-046 | Retrieves provider contact code data from Oracle. | Inline | PROVIDER_CONTACT_CODE | clsProviderContactCode |
| SQL-047 | Retrieves provider dcbs cost charge data from Oracle. | Inline | PROVIDER_DCBS_COST_CHARGE | clsProviderDcbsCostCharge |
| SQL-048 | Retrieves provider identity data from Oracle. | Inline | PROVIDER_IDENTITY | clsProviderIdentity |
| SQL-049 | Retrieves provider identity code data from Oracle. | Inline | PROVIDER_IDENTITY_CODE | clsProviderIdentityCode |
| SQL-050 | Retrieves provider ineligibility period data from Oracle. | Inline | PROVIDER_INELIG_PERIOD | clsProviderIneligibilityPeriod |
| SQL-051 | Retrieves provider ineligibility period collection data from Oracle. | Inline | PROVIDER_INELIG_PERIOD | clsProviderIneligibilityPeriodCollection |
| SQL-052 | Retrieves provider ineligibility reason code data from Oracle. | Inline | PROVIDER_INELIG_REASON_CD | clsProviderIneligibilityReasonCode |
| SQL-053 | Retrieves provider location data from Oracle. | Inline | PROVIDER_LOCATION | clsProviderLocation |
| SQL-054 | Retrieves provider m c o membership data from Oracle. | Inline | MCO_PROVIDER | clsProviderMCOMembership |
| SQL-055 | Retrieves provider relationship data from Oracle. | Inline | PROVIDER_RELATIONSHIP, PROVIDER_LOCATION | clsProviderRelationship |
| SQL-056 | Retrieves provider relationship code data from Oracle. | Inline | PROVIDER_RELATIONSHIP_CODE | clsProviderRelationshipCode |
| SQL-057 | Retrieves provider service data from Oracle. | Inline | PROVIDER_SERVICE | clsProviderService |
| SQL-058 | Retrieves provider service code data from Oracle. | Inline | PROVIDER_SERVICE_CODE | clsProviderServiceCode |
| SQL-059 | Retrieves provider service type data from Oracle. | Inline | PROVIDER_SERVICE_TYPE | clsProviderServiceType |
| SQL-060 | Retrieves provider tax i d data from Oracle. | Inline | PROVIDER_TAX_ID | clsProviderTaxID |
| SQL-061 | Retrieves provider type data from Oracle. | Inline | PROVIDER_TYPE_CODE | clsProviderType |
| SQL-062 | Retrieves provider type code data from Oracle. | Inline | PROVIDER_TYPE_CODE | clsProviderTypeCode |
| SQL-063 | Retrieves provider type collection data from Oracle. | Inline | PROVIDER_TYPE_CODE | clsProviderTypeCollection |
Update operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-064 | Updates an existing m c o plan record in Oracle. | Inline | MCO_PLAN | clsMCOPlan |
| SQL-065 | Updates an existing note record in Oracle. | Inline | CBP_NOTE | clsNote |
| SQL-066 | Updates an existing provider record in Oracle. | Inline | PROVIDER | clsProvider |
| SQL-067 | Updates an existing provider address record in Oracle. | Inline | PROVIDER_ADDRESS | clsProviderAddress |
| SQL-068 | Updates an existing provider address code record in Oracle. | Inline | PROVIDER_ADDRESS_CODE | clsProviderAddressCode |
| SQL-069 | Updates an existing provider contact record in Oracle. | Inline | PROVIDER_CONTACT | clsProviderContact |
| SQL-070 | Updates an existing provider contact code record in Oracle. | Inline | PROVIDER_CONTACT_CODE | clsProviderContactCode |
| SQL-071 | Updates an existing provider dcbs cost charge record in Oracle. | Inline | PROVIDER_DCBS_COST_CHARGE | clsProviderDcbsCostCharge |
| SQL-072 | Updates an existing provider identity record in Oracle. | Inline | PROVIDER_IDENTITY | clsProviderIdentity |
| SQL-073 | Updates an existing provider identity code record in Oracle. | Inline | PROVIDER_IDENTITY_CODE | clsProviderIdentityCode |
| SQL-074 | Updates an existing provider ineligibility period record in Oracle. | Inline | PROVIDER_INELIG_PERIOD | clsProviderIneligibilityPeriod |
| SQL-075 | Updates an existing provider ineligibility reason code record in Oracle. | Inline | PROVIDER_INELIG_REASON_CD | clsProviderIneligibilityReasonCode |
| SQL-076 | Updates an existing provider location record in Oracle. | Inline | PROVIDER_LOCATION | clsProviderLocation |
| SQL-077 | Updates an existing provider m c o membership record in Oracle. | Inline | MCO_PROVIDER | clsProviderMCOMembership |
| SQL-078 | Updates an existing provider relationship record in Oracle. | Inline | PROVIDER_RELATIONSHIP | clsProviderRelationship |
| SQL-079 | Updates an existing provider relationship code record in Oracle. | Inline | PROVIDER_RELATIONSHIP_CODE | clsProviderRelationshipCode |
| SQL-080 | Updates an existing provider service record in Oracle. | Inline | PROVIDER_SERVICE | clsProviderService |
| SQL-081 | Updates an existing provider service code record in Oracle. | Inline | PROVIDER_SERVICE_CODE | clsProviderServiceCode |
| SQL-082 | Updates an existing provider service contract record in Oracle. | Inline | PROVIDER_SERVICE_CONTRACT | clsProviderServiceContract |
| SQL-083 | Updates an existing provider service type record in Oracle. | Inline | PROVIDER_SERVICE_TYPE | clsProviderServiceType |
| SQL-084 | Updates an existing provider tax i d record in Oracle. | Inline | PROVIDER_TAX_ID | clsProviderTaxID |
| SQL-085 | Updates an existing provider type code record in Oracle. | Inline | PROVIDER_TYPE_CODE | clsProviderTypeCode |
Delete operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-086 | Deletes m c o plan data from Oracle. | Inline | MCO_PLAN | clsMCOPlan |
| SQL-087 | Deletes note data from Oracle. | Inline | CBP_NOTE | clsNote |
| SQL-088 | Deletes provider data from Oracle. | Inline | PROVIDER | clsProvider |
| SQL-089 | Deletes provider address data from Oracle. | Inline | PROVIDER_ADDRESS | clsProviderAddress |
| SQL-090 | Deletes provider address code data from Oracle. | Inline | PROVIDER_ADDRESS_CODE | clsProviderAddressCode |
| SQL-091 | Deletes provider contact data from Oracle. | Inline | PROVIDER_CONTACT | clsProviderContact |
| SQL-092 | Deletes provider contact code data from Oracle. | Inline | PROVIDER_CONTACT_CODE | clsProviderContactCode |
| SQL-093 | Deletes provider dcbs cost charge data from Oracle. | Inline | PROVIDER_DCBS_COST_CHARGE | clsProviderDcbsCostCharge |
| SQL-094 | Deletes provider identity data from Oracle. | Inline | PROVIDER_IDENTITY | clsProviderIdentity |
| SQL-095 | Deletes provider identity code data from Oracle. | Inline | PROVIDER_IDENTITY_CODE | clsProviderIdentityCode |
| SQL-096 | Deletes provider ineligibility period data from Oracle. | Inline | PROVIDER_INELIG_PERIOD | clsProviderIneligibilityPeriod |
| SQL-097 | Deletes provider ineligibility reason code data from Oracle. | Inline | PROVIDER_INELIG_REASON_CD | clsProviderIneligibilityReasonCode |
| SQL-098 | Deletes provider location data from Oracle. | Inline | PROVIDER_LOCATION | clsProviderLocation |
| SQL-099 | Deletes provider m c o membership data from Oracle. | Inline | MCO_PROVIDER | clsProviderMCOMembership |
| SQL-100 | Deletes provider relationship data from Oracle. | Inline | PROVIDER_RELATIONSHIP | clsProviderRelationship |
| SQL-101 | Deletes provider relationship code data from Oracle. | Inline | PROVIDER_RELATIONSHIP_CODE | clsProviderRelationshipCode |
| SQL-102 | Deletes provider service data from Oracle. | Inline | PROVIDER_SERVICE | clsProviderService |
| SQL-103 | Deletes provider service code data from Oracle. | Inline | PROVIDER_SERVICE_CODE | clsProviderServiceCode |
| SQL-104 | Deletes provider service contract data from Oracle. | Inline | PROVIDER_SERVICE_CONTRACT | clsProviderServiceContract |
| SQL-105 | Deletes provider service type data from Oracle. | Inline | PROVIDER_SERVICE_TYPE | clsProviderServiceType |
| SQL-106 | Deletes provider tax i d data from Oracle. | Inline | PROVIDER_TAX_ID | clsProviderTaxID |
| SQL-107 | Deletes provider type code data from Oracle. | Inline | PROVIDER_TYPE_CODE | clsProviderTypeCode |
Sequence operations¶
| SQL ID | Description | Sequence | Tables | Business object |
|---|---|---|---|---|
| SQL-001 | Returns the next identifier value used when creating m c o plan. | MCO_PLAN_ID_NEXTVAL |
N/A | clsMCOPlan |
| SQL-002 | Returns the next identifier value used when creating note. | CBP_NOTE_SEQ.NEXTVAL |
N/A | clsNote |
| SQL-003 | Returns the next identifier value used when creating provider. | PROVIDER_SEQ_NUM_NEXTVAL |
N/A | clsProvider |
| SQL-004 | Returns the next identifier value used when creating provider address. | PROVIDER_ADDRESS_SEQ_NUM_NEXTVAL |
N/A | clsProviderAddress |
| SQL-005 | Returns the next identifier value used when creating provider address code. | CODE_NEXTVAL |
N/A | clsProviderAddressCode |
| SQL-006 | Returns the next identifier value used when creating provider contact. | PROVIDER_CONTACT_SEQ_NUM_NEXTVAL |
N/A | clsProviderContact |
| SQL-007 | Returns the next identifier value used when creating provider contact code. | CODE_NEXTVAL |
N/A | clsProviderContactCode |
| SQL-008 | Returns the next identifier value used when creating provider identity code. | CODE_NEXTVAL |
N/A | clsProviderIdentityCode |
| SQL-009 | Returns the next identifier value used when creating provider ineligibility reason code. | CODE_NEXTVAL |
N/A | clsProviderIneligibilityReasonCode |
| SQL-010 | Returns the next identifier value used when creating provider location. | PROVIDER_LOCATION_SEQ_NUM_NEXTVAL |
N/A | clsProviderLocation |
| SQL-011 | Returns the next identifier value used when creating provider relationship code. | CODE_NEXTVAL |
N/A | clsProviderRelationshipCode |
| SQL-012 | Returns the next identifier value used when creating provider service. | PROVIDER_LOCATION_SEQ_NUM_NEXTVAL |
N/A | clsProviderService |
| SQL-013 | Returns the next identifier value used when creating provider service code. | CODE_NEXTVAL |
N/A | clsProviderServiceCode |
| SQL-014 | Returns the next identifier value used when creating provider service type. | PROVIDER_TYPE_CODE_NEXTVAL |
N/A | clsProviderServiceType |
| SQL-015 | Returns the next identifier value used when creating provider type code. | CODE_NEXTVAL |
N/A | clsProviderTypeCode |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Database tables
- API reference
- Configuration
Sources¶
Business\SAIF.Business.Provider\clsMCOPlan.vbBusiness\SAIF.Business.Provider\clsNote.vbBusiness\SAIF.Business.Provider\clsProvider.vbBusiness\SAIF.Business.Provider\clsProviderAddress.vbBusiness\SAIF.Business.Provider\clsProviderAddressCode.vbBusiness\SAIF.Business.Provider\clsProviderContact.vbBusiness\SAIF.Business.Provider\clsProviderContactCode.vbBusiness\SAIF.Business.Provider\clsProviderIdentityCode.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityReasonCode.vbBusiness\SAIF.Business.Provider\clsProviderLocation.vbBusiness\SAIF.Business.Provider\clsProviderRelationshipCode.vbBusiness\SAIF.Business.Provider\clsProviderService.vbBusiness\SAIF.Business.Provider\clsProviderServiceCode.vbBusiness\SAIF.Business.Provider\clsProviderServiceType.vbBusiness\SAIF.Business.Provider\clsProviderTypeCode.vbBusiness\SAIF.Business.Provider\clsMCOPlan.vbBusiness\SAIF.Business.Provider\clsNote.vbBusiness\SAIF.Business.Provider\clsProvider.vbBusiness\SAIF.Business.Provider\clsProviderAddress.vbBusiness\SAIF.Business.Provider\clsProviderAddressCode.vbBusiness\SAIF.Business.Provider\clsProviderContact.vbBusiness\SAIF.Business.Provider\clsProviderContactCode.vbBusiness\SAIF.Business.Provider\clsProviderDcbsCostCharge.vbBusiness\SAIF.Business.Provider\clsProviderIdentity.vbBusiness\SAIF.Business.Provider\clsProviderIdentityCode.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityPeriod.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityReasonCode.vbBusiness\SAIF.Business.Provider\clsProviderLocation.vbBusiness\SAIF.Business.Provider\clsProviderMCOMembership.vbBusiness\SAIF.Business.Provider\clsProviderRelationship.vbBusiness\SAIF.Business.Provider\clsProviderRelationshipCode.vbBusiness\SAIF.Business.Provider\clsProviderService.vbBusiness\SAIF.Business.Provider\clsProviderServiceCode.vbBusiness\SAIF.Business.Provider\clsProviderServiceContract.vbBusiness\SAIF.Business.Provider\clsProviderServiceType.vbBusiness\SAIF.Business.Provider\clsProviderTaxID.vbBusiness\SAIF.Business.Provider\clsProviderTypeCode.vbBusiness\SAIF.Business.Provider\clsCBPService.vbBusiness\SAIF.Business.Provider\clsCBPServiceType.vbBusiness\SAIF.Business.Provider\clsMCOPlan.vbBusiness\SAIF.Business.Provider\clsNote.vbBusiness\SAIF.Business.Provider\clsProvider.vbBusiness\SAIF.Business.Provider\clsProviderAddress.vbBusiness\SAIF.Business.Provider\clsProviderAddressCode.vbBusiness\SAIF.Business.Provider\clsProviderContact.vbBusiness\SAIF.Business.Provider\clsProviderContactCode.vbBusiness\SAIF.Business.Provider\clsProviderDcbsCostCharge.vbBusiness\SAIF.Business.Provider\clsProviderIdentity.vbBusiness\SAIF.Business.Provider\clsProviderIdentityCode.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityPeriod.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityPeriodCollection.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityReasonCode.vbBusiness\SAIF.Business.Provider\clsProviderLocation.vbBusiness\SAIF.Business.Provider\clsProviderMCOMembership.vbBusiness\SAIF.Business.Provider\clsProviderRelationship.vbBusiness\SAIF.Business.Provider\clsProviderRelationshipCode.vbBusiness\SAIF.Business.Provider\clsProviderService.vbBusiness\SAIF.Business.Provider\clsProviderServiceCode.vbBusiness\SAIF.Business.Provider\clsProviderServiceType.vbBusiness\SAIF.Business.Provider\clsProviderTaxID.vbBusiness\SAIF.Business.Provider\clsProviderType.vbBusiness\SAIF.Business.Provider\clsProviderTypeCode.vbBusiness\SAIF.Business.Provider\clsProviderTypeCollection.vbBusiness\SAIF.Business.Provider\clsMCOPlan.vbBusiness\SAIF.Business.Provider\clsNote.vbBusiness\SAIF.Business.Provider\clsProvider.vbBusiness\SAIF.Business.Provider\clsProviderAddress.vbBusiness\SAIF.Business.Provider\clsProviderAddressCode.vbBusiness\SAIF.Business.Provider\clsProviderContact.vbBusiness\SAIF.Business.Provider\clsProviderContactCode.vbBusiness\SAIF.Business.Provider\clsProviderDcbsCostCharge.vbBusiness\SAIF.Business.Provider\clsProviderIdentity.vbBusiness\SAIF.Business.Provider\clsProviderIdentityCode.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityPeriod.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityReasonCode.vbBusiness\SAIF.Business.Provider\clsProviderLocation.vbBusiness\SAIF.Business.Provider\clsProviderMCOMembership.vbBusiness\SAIF.Business.Provider\clsProviderRelationship.vbBusiness\SAIF.Business.Provider\clsProviderRelationshipCode.vbBusiness\SAIF.Business.Provider\clsProviderService.vbBusiness\SAIF.Business.Provider\clsProviderServiceCode.vbBusiness\SAIF.Business.Provider\clsProviderServiceContract.vbBusiness\SAIF.Business.Provider\clsProviderServiceType.vbBusiness\SAIF.Business.Provider\clsProviderTaxID.vbBusiness\SAIF.Business.Provider\clsProviderTypeCode.vbBusiness\SAIF.Business.Provider\clsMCOPlan.vbBusiness\SAIF.Business.Provider\clsNote.vbBusiness\SAIF.Business.Provider\clsProvider.vbBusiness\SAIF.Business.Provider\clsProviderAddress.vbBusiness\SAIF.Business.Provider\clsProviderAddressCode.vbBusiness\SAIF.Business.Provider\clsProviderContact.vbBusiness\SAIF.Business.Provider\clsProviderContactCode.vbBusiness\SAIF.Business.Provider\clsProviderDcbsCostCharge.vbBusiness\SAIF.Business.Provider\clsProviderIdentity.vbBusiness\SAIF.Business.Provider\clsProviderIdentityCode.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityPeriod.vbBusiness\SAIF.Business.Provider\clsProviderIneligibilityReasonCode.vbBusiness\SAIF.Business.Provider\clsProviderLocation.vbBusiness\SAIF.Business.Provider\clsProviderMCOMembership.vbBusiness\SAIF.Business.Provider\clsProviderRelationship.vbBusiness\SAIF.Business.Provider\clsProviderRelationshipCode.vbBusiness\SAIF.Business.Provider\clsProviderService.vbBusiness\SAIF.Business.Provider\clsProviderServiceCode.vbBusiness\SAIF.Business.Provider\clsProviderServiceContract.vbBusiness\SAIF.Business.Provider\clsProviderServiceType.vbBusiness\SAIF.Business.Provider\clsProviderTaxID.vbBusiness\SAIF.Business.Provider\clsProviderTypeCode.vb