SQL-006: Insert user access group¶

Inserts a new access-group membership row into EXT_USER_ACCESS_GROUP, associating a user type with an access group code.

Classification¶

Field	Value
SQL ID	SQL-006
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsUserAccessGroup`
Criteria property	`InsertSQL`
Lifecycle method	`BeforeInsert`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:UserAccessGroupID`	Input	Decimal	N/A	`EXT_USER_ACCESS_GROUP_SEQ_NUM` — primary key.
`:UserTypeID`	Input	Decimal	N/A	Owning `EXT_USER_TYPE_SEQ_NUM`.
`:AccessGroupCode`	Input	String	5	Access group code from `EXT_USER_ACCESS_GROUP_CODE`.
`:ExpirationDate`	Input	DateTime	N/A	Optional expiration date for the membership.
`:IsDefaultAccess`	Input	String	1	Default access flag.
`:CreateUser`	Input	String	30	Username creating the record.
`:CreateDate`	Input	DateTime	N/A	Record creation timestamp.
`:UpdateUser`	Input	String	30	Username of last update.
`:UpdateDate`	Input	DateTime	N/A	Last update timestamp.
`:UpdateNum`	Input	Decimal	N/A	Optimistic-concurrency counter.

Tables¶

Table	Access	Columns used
EXT_USER_ACCESS_GROUP	INSERT	`EXT_USER_ACCESS_GROUP_SEQ_NUM`, `EXT_USER_TYPE_SEQ_NUM`, `EXT_USER_ACCESS_GROUP_CODE`, `EXPIRATION_DATE`, `DEFAULT_ACCESS_FLAG`, `CREATE_USER`, `CREATE_DATE`, `UPDATE_USER`, `UPDATE_DATE`, `UPDATE_NUM`

Sample SQL¶

INSERT INTO EXT_USER_ACCESS_GROUP g (
    EXT_USER_ACCESS_GROUP_SEQ_NUM, EXT_USER_TYPE_SEQ_NUM,
    EXT_USER_ACCESS_GROUP_CODE, EXPIRATION_DATE, DEFAULT_ACCESS_FLAG,
    CREATE_USER, CREATE_DATE, UPDATE_USER, UPDATE_DATE, UPDATE_NUM
)
VALUES (
    :UserAccessGroupID, :UserTypeID, :AccessGroupCode, :ExpirationDate,
    :IsDefaultAccess, :CreateUser, :CreateDate, :UpdateUser, :UpdateDate, :UpdateNum
)

Operations and processes¶

User access group management

Business rules¶

BR-EU-05: Optimistic concurrency via UPDATE_NUM

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.External.Users\clsUserAccessGroup.vb