SQL-076: Update Provider Location
Updates an existing provider location record in Oracle.
Classification
| Field |
Value |
| SQL ID |
SQL-076 |
| Operation type |
Update |
| Execution method |
Inline |
| Database |
Oracle |
| Schema |
[unqualified]** |
| Command type |
Text |
| Business object |
clsProviderLocation |
| Criteria property |
UpdateSQL |
| Lifecycle method |
BeforeUpdate |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
| :ProviderSeqNum |
Input |
Unspecified |
N/A |
Value from ProviderSeqNum |
| :ProviderTypeCode |
Input |
Unspecified |
5 |
Value from ProviderTypeCode |
| :BusinessFlag |
Input |
Unspecified |
1 |
Value from BusinessFlag |
| :CriticalAccessHospitalFlag |
Input |
Unspecified |
1 |
Value from CriticalAccessHospitalFlag |
| :ApprovedFlag |
Input |
Unspecified |
1 |
Value from ApprovedFlag |
| :PrimaryLocationFlag |
Input |
Unspecified |
1 |
Value from PrimaryLocationFlag |
| :PossibleFraudFlag |
Input |
Unspecified |
1 |
Value from PossibleFraudFlag |
| :IneligibilityFlag |
Input |
Unspecified |
1 |
Value from IneligibilityFlag |
| :RecentActivityFlag |
Input |
Unspecified |
1 |
Value from RecentActivityFlag |
| :BusinessName |
Input |
clsSmartString |
50 |
Value from m_BusinessName |
| :BusinessNameUpperCase |
Input |
clsSmartString |
50 |
Value from m_BusinessNameUpperCase |
| :LastName |
Input |
clsSmartString |
50 |
Value from m_LastName |
| :LastNameUpperCase |
Input |
clsSmartString |
50 |
Value from m_LastNameUpperCase |
| :FirstName |
Input |
clsSmartString |
20 |
Value from m_FirstName |
| :MiddleName |
Input |
clsSmartString |
20 |
Value from m_MiddleName |
| :ApprovedUser |
Input |
clsSmartString |
30 |
Value from m_ApprovedUser |
| :PhoneAreaCode |
Input |
Unspecified |
3 |
Value from m_PhoneNumber.AreaCode |
| :PhoneNum |
Input |
Unspecified |
7 |
Value from PhoneData |
| :PhoneNumExt |
Input |
clsSmartString |
10 |
Value from m_PhoneExtension |
| :TollFreePhoneNum |
Input |
Unspecified |
23 |
Value from TollFreePhoneNumber |
| :FaxNum |
Input |
Unspecified |
23 |
Value from FaxNumber |
| :TollFreeFaxNum |
Input |
Unspecified |
23 |
Value from TollFreeFaxNumber |
| :WebSiteAddress |
Input |
clsSmartString |
250 |
Value from m_WebSiteAddress |
| :PayeeName |
Input |
clsSmartString |
50 |
Value from m_PayeeName |
| :ProviderLocationSeqNum |
Input |
Unspecified |
N/A |
Value from ProviderLocationSeqNum |
| :UpdateUser |
Input |
Unspecified |
30 |
Value from UpdateUser |
| :UpdateNum |
Input |
Unspecified |
N/A |
Value from UpdateNum |
| :UpdateDate |
Input |
Unspecified |
N/A |
Value from UpdateDate |
| :EmailAddress |
Input |
clsSmartString |
250 |
Value from m_EmailAddress |
Tables
| Table |
Access |
Columns used |
| PROVIDER_LOCATION |
UPDATE |
See business-object criteria for key columns. |
Sample SQL
Update PROVIDER_LOCATION Set PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationSeqNum, PROVIDER_SEQ_NUM = :ProviderSeqNum, PROVIDER_TYPE_CODE = :ProviderTypeCode, BUSINESS_FLAG = :BusinessFlag, CRITICAL_ACCESS_HOSPITAL_FLAG = :CriticalAccessHospitalFlag, BUSINESS_NAME = :BusinessName, BUSINESS_NAME_UPPER_CASE = :BusinessNameUpperCase, LAST_NAME = :LastName, LAST_NAME_UPPER_CASE = :LastNameUpperCase, FIRST_NAME = :FirstName, MIDDLE_NAME = :MiddleName, APPROVED_FLAG = :ApprovedFlag, APPROVED_USER = :ApprovedUser, PRIMARY_LOCATION_FLAG = :PrimaryLocationFlag, POSSIBLE_FRAUD_FLAG = :PossibleFraudFlag, PHONE_AREA_CODE = :PhoneAreaCode, PHONE_NUM = :PhoneNum, PHONE_NUM_EXT = :PhoneNumExt, FAX_NUM = :FaxNum, TOLL_FREE_PHONE_NUM = :TollFreePhoneNum, TOLL_FREE_FAX_NUM = :TollFreeFaxNum, INELIGIBILITY_FLAG = :IneligibilityFlag, UPDATE_USER = :UpdateUser, UPDATE_NUM = UPDATE_NUM + 1, UPDATE_DATE = :UpdateDate, RECENT_ACTIVITY_FLAG = :RecentActivityFlag, WEB_SITE_ADDRESS = :WebSiteAddress, PAYEE_NAME = :PayeeName ,EMAIL_ADDR = :EmailAddress Where PROVIDER_LOCATION.PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationSeqNum AND UPDATE_NUM = :UpdateNum
Operations and processes
Business rules
Note: Statements marked with ** could not be confirmed; treat as unknown until verified.
Sources
Business\SAIF.Business.Provider\clsProviderLocation.vb