SQL-100: Delete Provider Relationship

Deletes provider relationship data from Oracle.

Classification

Field	Value
SQL ID	SQL-100
Operation type	Delete
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsProviderRelationship
Criteria property	DeleteSQL
Lifecycle method	BeforeDelete

Parameters

Parameter	Direction	Type	Max length	Description
:OrigProviderLocationSeqNum	Input	Decimal	N/A	Value from OrigProviderLocationSeqNum
:OrigParentProviderLocSeqNum	Input	Decimal	N/A	Value from OrigParentProviderLocSeqNum
:OrigEffDate	Input	Date	N/A	Value from OrigEffDate

Tables

Table	Access	Columns used
PROVIDER_RELATIONSHIP	DELETE	See business-object criteria for key columns.

Sample SQL

Delete  PROVIDER_RELATIONSHIP Where PROVIDER_RELATIONSHIP.PROVIDER_LOCATION_SEQ_NUM = :OrigProviderLocationSeqNum    and PROVIDER_RELATIONSHIP.PARENT_PROVIDER_LOC_SEQ_NUM = :OrigParentProviderLocSeqNum    and PROVIDER_RELATIONSHIP.EFF_DATE = :OrigEffDate

Operations and processes

• Maintain provider relationship

Business rules

• BR-013: Relationship participants must exist and be distinct
• BR-014: Relationship dates must be valid and non-overlapping

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.Provider\clsProviderRelationship.vb