dbo.ComplianceSubRulePerson
Identities to monitor
TableType TUsage MATERIALRows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Person | varchar(38) | no | Identity | PKFKUID |
UID_ComplianceRule | varchar(38) | no | Rule | PKFKUID |
XTouched | nchar(2) | yes | Processing status |
Relations
| FK | From | To |
|---|---|---|
| CPL_RFRL1411 | ComplianceSubRulePerson.UID_ComplianceRule | ComplianceRule.UID_ComplianceRule |
| CPL_RFRL1412 | ComplianceSubRulePerson.UID_Person | Person.UID_Person |
Triggers
No triggers in snapshot.
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_FTComplianceSubRulePerson | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.CPL_FTComplianceSubRulePerson | SQL expression dependency | dbo · UID_Person · OBJECT_OR_COLUMN |
| dbo.CPL_FTComplianceSubRulePerson | SQL expression dependency | dbo · UID_ComplianceRule · OBJECT_OR_COLUMN |
| dbo.CPL_FTComplianceSubRulePersonR | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.CPL_PSubRuleFillPerson_i | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_FTCCSPWOCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA23A3658D1BD06E8FA265F5D1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA3AA22E3EBAF4301F7FEBBC27 | SQL expression dependency | OBJECT_OR_COLUMN |
| ComplianceRule | referenced by foreign key from table | CPL_RFRL1411: ComplianceSubRulePerson.UID_ComplianceRule -> ComplianceRule.UID_ComplianceRule |
| Person | referenced by foreign key from table | CPL_RFRL1412: ComplianceSubRulePerson.UID_Person -> Person.UID_Person |
| dbo.CPL_FTComplianceSubRulePerson | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.CPL_FTComplianceSubRulePersonR | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.CPL_PComplianceCheckMakeProc_h | source text reference | has TRY/CATCH error handling |
| dbo.CPL_PSubRuleFillPerson_i | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.CPL_FTCCSPWOCheck | source text reference | SQL_TABLE_VALUED_FUNCTION |