SQL-085: Update Provider Type Code

Updates an existing provider type code record in Oracle.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:CodeDescr	Input	String	65	Value from CodeDescr
:DiagnosisRequiredFlag	Input	String	1	Value from DiagnosisRequiredFlag
:MandatoryMcoFlag	Input	String	1	Value from MandatoryMcoFlag
:MedicalAuditFlag	Input	String	1	Value from MedicalAuditFlag
:ServiceProvRestrictFlag	Input	String	1	Value from ServiceProvRestrictFlag
:SelfRegistrationFlag	Input	String	1	Value from SelfRegistrationFlag
:ClaimProfileFlag	Input	String	1	Value from ClaimProfileFlag
:DcbsProviderTypeCode	Input	clsSmartString	2	Value from m_DcbsProviderTypeCode
:Code	Input	String	5	Value from Code
:UpdateUser	Input	String	30	Value from UpdateUser
:UpdateNum	Input	Decimal	N/A	Value from UpdateNum
:UpdateDate	Input	Date	N/A	Value from UpdateDate
:Code	Input	String	5	Value from MyCriteria.Code

Tables

Table	Access	Columns used
PROVIDER_TYPE_CODE	UPDATE	See business-object criteria for key columns.

Sample SQL

Update PROVIDER_TYPE_CODE Set CODE = :Code, CODE_DESCR = :CodeDescr, UPDATE_USER = :UpdateUser, UPDATE_NUM = UPDATE_NUM + 1, UPDATE_DATE = :UpdateDate, DIAGNOSIS_REQUIRED_FLAG = :DiagnosisRequiredFlag, MANDATORY_MCO_FLAG = :MandatoryMcoFlag, MEDICAL_AUDIT_FLAG = :MedicalAuditFlag, SERVICE_PROV_RESTRICT_FLAG = :ServiceProvRestrictFlag, DCBS_PROVIDER_TYPE_CODE = :DcbsProviderTypeCode, SELF_REGISTRATION_FLAG = :SelfRegistrationFlag, CLAIM_PROFILE_FLAG = :ClaimProfileFlag Where PROVIDER_TYPE_CODE.CODE = :Code AND UPDATE_NUM = :UpdateNum

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

Sources

• Business\SAIF.Business.Provider\clsProviderTypeCode.vb