SQL-010: Insert group association row¶

SQL-010 insert group association row in support of clsGroupAssociation.

Classification¶

Field	Value
SQL ID	SQL-010
Operation type	Insert
Execution method	Inline SQL via BOF data portal
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsGroupAssociation`
Criteria property	`InsertSQL`
Lifecycle method	`BeforeInsert` / `AfterInsert`

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	INSERT	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¶

Insert into GROUP_ASSOCIATION
  (
    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,
    PMS_GROUP_NUMBER,
    CREATE_DATE,
    CREATE_USER,
    UPDATE_DATE,
    UPDATE_USER,
    PMS_GROUP_SUB_CODE,
    GROUP_ENROLL_FORM,
    RATE_CHANGE_ENDORSE_CODE,
    CODE_ACRONYM,
    FIXED_PLAN_DATE_FLAG,
    PRINT_AT_PLAN_FLAG,
    AUTO_RENEWAL_FLAG,
    GROUP_REPRESENTATIVE,
    MANDATORY_FINANCIAL_SYSTEM,
    MANDATORY_RENEWAL_TRACK,
    PENDING_ENDORSE_CODE,
    CANCEL_ENDORSE_CODE,
    PARENT_GROUP
  )
Values
  (
    :Code,
    :Name,
    :Address1,
    :Address2,
    :City,
    :State,
    :Zip,
    :Zip4,
    :USPSBarcode,
    :County,
    :Phone,
    :Fax,
    :AssociationEffectiveDate,
    :AssociationExpirationDate,
    :GroupTypeCode,
    :GroupPlanCode,
    :AddEndorseCode,
    :GroupRenewalDate,
    :PMSGroupNumber,
    :CreateDate,
    :CreateUser,
    :UpdateDate,
    :UpdateUser,
    :PMSGroupSubCode,
    :GroupEnrollForm,
    :RateChangeEndorseCode,
    :CodeAcronym,
    :FixedPlanDateFlag,
    :PrintATPlanFlag,
    :AutoRenewalFlag,
    :GroupRepresentative,
    :MandatoryFinancialSystem,
    :MandatoryRenewalTrack,
    :PendingEndorseCode,
    :CancelEndorseCode,
    :ParentGroup
  )

Operations and processes¶

Persist group associations (insert / update / delete)

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