project BLF > class BSODViolationRule1 > business logic query ViolationsByRole
Parameters
query condition
each SODViolation1 where
SODViolation1.Role_ID = iiRoleID
first SODCategory1 (inner-join) where
SODCategory1.SODCategory_ID = SODViolation1.SODCategory1_ID AND
first SODCategory2 (inner-join) where
SODCategory2.SODCategory_ID = SODViolation1.SODCategory2_ID AND
first SODExclusion (inner-join) where
SODExclusion.SODCategory1_ID = SODViolation1.SODCategory1_ID AND
SODExclusion.SODCategory2_ID = SODViolation1.SODCategory2_ID AND
query resultset tqViolationsByRole
| field name | data type | db field | description |
|---|
| tiSODCategory_ID | integer | SODCategory1.SODCategory_ID | record ID |
| tiSODCategory_ID1 | integer | SODCategory2.SODCategory_ID | record ID |
| tcSODCategoryCode1 | character | SODCategory1.SODCategoryCode | SOD category code |
| tcSODCategoryCode2 | character | SODCategory2.SODCategoryCode | SOD category code |
| tcSODCategoryDescription1 | character | SODCategory1.SODCategoryDescription | SOD category description |
| tcSODCategoryDescription2 | character | SODCategory2.SODCategoryDescription | SOD category description |
| tcSODExclusionLevel | character | SODExclusion.SODExclusionLevel | Exclusion Level |
Internal usage
BLF