dbo.ComplianceSubRule
Partial rules
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ComplianceSubRule | varchar(38) | no | Patial rule | PKUID |
UID_ComplianceRule | varchar(38) | yes | Rule | FKUID |
WhereClause | nvarchar(-1) | yes | Condition | |
WhereClauseAddOn | nvarchar(-1) | yes | Additional condition | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
Description | nvarchar(-1) | yes | Description | |
SortOrder | nvarchar(64) | yes | Sort order | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
CountMatchesMin | int(4) | yes | Min. number of entitlements |
Relations
| FK | From | To |
|---|---|---|
| CPL_RFRL1407 | ComplianceSubRule.UID_ComplianceRule | ComplianceRule.UID_ComplianceRule |
Triggers
CPL_TIComplianceSubRule SQL_TRIGGER
CPL_TUComplianceSubRule SQL_TRIGGER
GEN_T2C5CA1987F076178C38A7144B SQL_TRIGGER
GEN_T3F101F29DC3B791AC6D3D46F8 SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.CPL_FTCCSESetCheckWithPWO | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_FTCCSESetCheckWithPWODet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_FTCCSOrgCheckWithPWO | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_FTCCSOrgCheckWithPWODetail | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_FTCCSPersonCheckWithOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_FTCCSPWOCheckDetail | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_PAfterMigrationTasks | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_RSubRuleFillObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_ZScheduleStartFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_ZSubRuleFillObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_FTCCSPWOCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_TUComplianceRule | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C5614EECB227BA2F334F1104 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2307813B7ED5569A712D931EF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_VCCSESetCheck | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.CPL_VCCSESetCheck | SQL expression dependency | dbo · UID_ComplianceSubRule · OBJECT_OR_COLUMN |
| dbo.CPL_VCCSESetCheck | SQL expression dependency | dbo · UID_ComplianceRule · OBJECT_OR_COLUMN |
| dbo.CPL_VCCSESetCheck | SQL expression dependency | dbo · CountMatchesMin · OBJECT_OR_COLUMN |
| dbo.CPL_VCCSESetCheckDetail | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_VCCSOrgCheck | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.CPL_VCCSOrgCheck | SQL expression dependency | dbo · UID_ComplianceSubRule · OBJECT_OR_COLUMN |
| dbo.CPL_VCCSOrgCheck | SQL expression dependency | dbo · UID_ComplianceRule · OBJECT_OR_COLUMN |
| dbo.CPL_VCCSOrgCheck | SQL expression dependency | dbo · CountMatchesMin · OBJECT_OR_COLUMN |
| dbo.CPL_VCCSOrgCheckDetail | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_VCCSPersonCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_VCCSPersonCheckDetail | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_V134C775CB07CEBA13F185FA22 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VADA5FD7268D5BF0A7634339A8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VADE4AF4B967D1575C5A1F386F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAE834E1ABD9D5B019DA047B27 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAF16F4C1C19441DC655EEF88A | SQL expression dependency | OBJECT_OR_COLUMN |
| ComplianceRule | referenced by foreign key from table | CPL_RFRL1407: ComplianceSubRule.UID_ComplianceRule -> ComplianceRule.UID_ComplianceRule |
| dbo.CPL_FTCCSESetCheckWithPWO | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.CPL_FTCCSESetCheckWithPWODet | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.CPL_FTCCSOrgCheckWithPWO | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.CPL_FTCCSOrgCheckWithPWODetail | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.CPL_FTCCSPersonCheckWithOrg | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.CPL_FTCCSPWOCheckDetail | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.CPL_PAfterMigrationTasks | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.CPL_RSubRuleFillObject | source text reference | has TRY/CATCH error handling |
| dbo.CPL_ZScheduleStartFill | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.CPL_ZSubRuleFillObject | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.CPL_FTCCSPWOCheck | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.CPL_TUComplianceRule | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-cpl-compositionapi-cpl-compositionapi-itshop-cartcompliancecheck.cs | decompiled C# reference | classes CartComplianceCheck, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass12_0, _003C_003Ec__DisplayClass17_0; methods MoveNext, SetStateMachine, _003CGetViolationsAsync_003Eb__1, _003CGetViolationsAsync_003Eb__2, _003CSetExceptionApproverFlagsAsync_003Eb__1, _003CCheckOrgAssignmentComplianceAsync_003Eb__3; references AERole, ComplianceRule, ComplianceSubRule, Department, ESet, HelperPWOPersonHasObject; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-cpl-customizer-cpl-customizer-compliancerule.cs | decompiled C# reference | classes ComplianceRule; methods MoveNext, SetStateMachine, OnSavingAsync, OnWorkingCopySaving, OnRelationObjectSaving, OnWorkingCopySaved; references AERole, ComplianceArea, ComplianceRule, ComplianceRuleHasMControl, ComplianceRuleInArea, ComplianceSubRule; markers reads entity values, references DB/Dialog objects |