SQL-005 Association type code lookup

Retrieve association type code definitions.

Classification

Field	Value
SQL ID	SQL-005
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsAssociationTypeCodeCollection
Criteria property	RetrieveSQL (delegates to clsAssociationTypeCode.Criteria.Retrieve_SQL)
Lifecycle method	BeforeRetrieve / AfterRetrieve

Tables

Table	Access	Columns used
ASSOCIATION_TYPE_CODE	SELECT	CODE, CODE_DESCR, ASSOCIATION_TYPE_CATEGORY_CODE, SOURCE_PROCEDURE_NAME, SECURITY_GROUP_NAME, SORT_ORDER, POLICY_HEADER_DEFAULT_FLAG

Sample SQL

SELECT
  ASSOCIATION_TYPE_CODE.CODE AS Code,
  ASSOCIATION_TYPE_CODE.CODE_DESCR AS Description,
  ASSOCIATION_TYPE_CODE.ASSOCIATION_TYPE_CATEGORY_CODE AS AssociationTypeCategoryCode,
  ASSOCIATION_TYPE_CODE.SOURCE_PROCEDURE_NAME AS SourceProcedureName,
  ASSOCIATION_TYPE_CODE.SECURITY_GROUP_NAME AS SecurityGroupName,
  ASSOCIATION_TYPE_CODE.SORT_ORDER AS SortOrder,
  ASSOCIATION_TYPE_CODE.POLICY_HEADER_DEFAULT_FLAG AS PolicyHeaderDefaultFlag
FROM ASSOCIATION_TYPE_CODE

Operations and processes

• Retrieve policy associations

Business rules

• BR-VP-020: Association type is secured when security group set
• BR-VP-021: Association category prefix classification
• BR-VP-027: Create/Insert/Update/Delete SQL are invalid

Sources

• SAIF.Business.View.Policy/Associations/clsAssociationTypeCodeCollection.vb
• SAIF.Business.View.Policy/Associations/clsAssociationTypeCode.vb