dbo.HelperHardwareOrg
Auxiliary table for identifying primary assignments of devices to roles and organization. Required for inheritance calculation. Depends on the settings of the configuration parameters under “QER\Structures\Inherite\Hardware”.
TableType TUsage MATERIALRows 0SizeMB 0
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Hardware | varchar(38) | no | Device | PKFKUID |
UID_Org | varchar(38) | no | Business Role | PKFKUID |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1436 | HelperHardwareOrg.UID_Hardware | Hardware.UID_Hardware |
| QER_RFRL1717 | HelperHardwareOrg.UID_Org | BaseTree.UID_Org |
Triggers
QER_TDHelperHardwareOrg SQL_TRIGGER
QER_TIHelperHardwareOrg 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.ADS_ZADSMachineInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZLDPMachineInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZHelperHardwareOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMB_ZHelperHardwareOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TIBaseTreeHasADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUBaseTreeHasADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TIBaseTreeHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TUBaseTreeHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| Hardware | referenced by foreign key from table | QER_RFRL1436: HelperHardwareOrg.UID_Hardware -> Hardware.UID_Hardware |
| BaseTree | referenced by foreign key from table | QER_RFRL1717: HelperHardwareOrg.UID_Org -> BaseTree.UID_Org |
| dbo.ADS_ZADSMachineInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZLDPMachineInLDAPGroup | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZHelperHardwareOrg | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.RMB_ZHelperHardwareOrg | source text reference | has TRY/CATCH error handling |
| dbo.ADS_TIBaseTreeHasADSGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUBaseTreeHasADSGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TIBaseTreeHasLDAPGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TUBaseTreeHasLDAPGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |