SQL-030: Update group association row (truncated)
SQL-030 update group association row (truncated) in support of clsGroupAssociation. The statement text is truncated at a bare Where and is not executable as written.
Classification
Field
Value
SQL ID SQL-030
Operation type Update
Execution method Inline SQL via BOF data portal
Database Oracle
Schema [unqualified]**
Command type Text
Business object clsGroupAssociation
Criteria property UpdateSQL
Lifecycle method BeforeUpdate / AfterUpdate
Parameters
Parameter
Direction
Type
Max length
Description
N/A
In
String
not specified
Group association code — primary key (BR-001 : must be non-empty).
N/A
In
String
not specified
Group name / code description.
N/A
In
String
not specified
Mailing address line 1.
N/A
In
String
not specified
Mailing address line 2.
N/A
In
String
not specified
Mailing city.
N/A
In
String
not specified
Mailing state.
N/A
In
String
not specified
5-digit ZIP.
N/A
In
String
not specified
ZIP+4 extension.
N/A
In
String
not specified
USPS delivery barcode.
N/A
In
String
not specified
Mailing county.
N/A
In
String
not specified
Group phone number.
N/A
In
String
not specified
Group fax number.
N/A
In
Date
not specified
Group effective date.
N/A
In
Date
not specified
Group expiration date; null means never expired (BR-002 ).
N/A
In
String
not specified
Stored group type code driving BR-003 classification.
N/A
In
String
not specified
Plan code used by the sales-plan filter (BR-004 ).
N/A
In
String
not specified
Endorsement code used when adding a member.
N/A
In
Date
not specified
Common renewal date for the group.
N/A
In
String
not specified
Policy Management System group number.
N/A
In
Date
not specified
Audit — row creation timestamp.
N/A
In
String
not specified
Audit — creating user.
N/A
In
Date
not specified
Audit — last update timestamp (BR-021 ).
N/A
In
String
30 (BR-021 )
Audit — last updating user.
N/A
In
String
not specified
PMS group sub-code.
N/A
In
String
not specified
Enrollment form identifier.
N/A
In
String
not specified
Endorsement code used on rate change.
N/A
In
String
not specified
Short acronym for the group.
N/A
In
String
not specified
Y/N — group uses a fixed plan date.
N/A
In
String
not specified
Y/N — print at plan.
N/A
In
String
not specified
Y/N — auto-renew members.
N/A
In
String
not specified
Named group representative.
N/A
In
String
not specified
Y/N — financial system participation is mandatory.
N/A
In
String
not specified
Y/N — renewal tracking is mandatory.
N/A
In
String
not specified
Endorsement code for pending membership.
N/A
In
String
not specified
Endorsement code for cancelled membership.
N/A
In
String
not specified
Parent group code for hierarchy (BR-003 PARNT).
Tables
Table
Access
Columns used
GROUP_ASSOCIATION UPDATE
CODE, CODE_DESCR, ADDRESS1, ADDRESS2, CITY, STATE, ZIP, ZIP4, USPS_BARCODE, COUNTY, PHONE, FAX, ASSOCIATION_EFF_DATE, ASSOCIATION_EXP_DATE, GROUP_TYPE_CODE, GROUP_PLAN_CODE, ADD_ENDORSE_CODE, GROUP_RENEWAL_DATE
Sample SQL
Update GROUP_ASSOCIATION
Set
CODE = : Code ,
CODE_DESCR = : Name ,
ADDRESS1 = : Address1 ,
ADDRESS2 = : Address2 ,
CITY = : City ,
STATE = : State ,
ZIP = : Zip ,
ZIP4 = : Zip4 ,
USPS_BARCODE = : USPSBarcode ,
COUNTY = : County ,
PHONE = : Phone ,
FAX = : Fax ,
ASSOCIATION_EFF_DATE = : AssociationEffectiveDate ,
ASSOCIATION_EXP_DATE = : AssociationExpirationDate ,
GROUP_TYPE_CODE = : GroupTypeCode ,
GROUP_PLAN_CODE = : GroupPlanCode ,
ADD_ENDORSE_CODE = : AddEndorseCode ,
GROUP_RENEWAL_DATE = : GroupRenewalDate ,
PMS_GROUP_NUMBER = : PMSGroupNumber ,
CREATE_DATE = : CreateDate ,
CREATE_USER = : CreateUser ,
UPDATE_DATE = : UpdateDate ,
UPDATE_USER = : UpdateUser ,
PMS_GROUP_SUB_CODE = : PMSGroupSubCode ,
GROUP_ENROLL_FORM = : GroupEnrollForm ,
RATE_CHANGE_ENDORSE_CODE = : RateChangeEndorseCode ,
CODE_ACRONYM = : CodeAcronym ,
FIXED_PLAN_DATE_FLAG = : FixedPlanDateFlag ,
PRINT_AT_PLAN_FLAG = : PrintATPlanFlag ,
AUTO_RENEWAL_FLAG = : AutoRenewalFlag ,
GROUP_REPRESENTATIVE = : GroupRepresentative ,
MANDATORY_FINANCIAL_SYSTEM = : MandatoryFinancialSystem ,
MANDATORY_RENEWAL_TRACK = : MandatoryRenewalTrack ,
PENDING_ENDORSE_CODE = : PendingEndorseCode ,
CANCEL_ENDORSE_CODE = : CancelEndorseCode ,
PARENT_GROUP = : ParentGroup
Where
-- statement ends here; no predicate follows (anomaly A-2)
Operations and processes
Note: Statements marked with * were inferred from code structure, naming conventions, or
contextual evidence where direct confirmation was not available in source artifacts. Statements
marked with ** could not be confirmed; treat as unknown until verified.
Sources
Business\SAIF.Business.Policy.Group\clsGroupAssociation.vb