SQL-078: Update Provider Relationship

Updates an existing provider relationship record in Oracle.

Classification

Field	Value
SQL ID	SQL-078
Operation type	Update
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsProviderRelationship
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate

Parameters

Parameter	Direction	Type	Max length	Description
:ProviderLocationSeqNum	Input	Decimal	N/A	Value from ProviderLocationSeqNum
:ParentProviderLocSeqNum	Input	Decimal	N/A	Value from ParentProviderLocSeqNum
:ProviderRelationshipCode	Input	String	5	Value from ProviderRelationshipCode
:EffDate	Input	Date	N/A	Value from EffDate
:ExpDate	Input	clsSmartDate	N/A	Value from m_ExpDate
:UpdateUser	Input	String	30	Value from UpdateUser
:UpdateNum	Input	Decimal	N/A	Value from UpdateNum
:UpdateDate	Input	Date	N/A	Value from UpdateDate
: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	UPDATE	See business-object criteria for key columns.

Sample SQL

Update  PROVIDER_RELATIONSHIP Set  PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationSeqNum,  PARENT_PROVIDER_LOC_SEQ_NUM = :ParentProviderLocSeqNum,  PROVIDER_RELATIONSHIP_CODE = :ProviderRelationshipCode,  EFF_DATE = :EffDate,  EXP_DATE = :ExpDate,  UPDATE_USER = :UpdateUser,  UPDATE_NUM = UPDATE_NUM + 1,  UPDATE_DATE = :UpdateDate Where PROVIDER_RELATIONSHIP.PROVIDER_LOCATION_SEQ_NUM = :OrigProviderLocationSeqNum    and PROVIDER_RELATIONSHIP.PARENT_PROVIDER_LOC_SEQ_NUM = :OrigParentProviderLocSeqNum    and PROVIDER_RELATIONSHIP.EFF_DATE = :OrigEffDate    and UPDATE_NUM = :UpdateNum

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