dbo.QERRiskIndex
Risk index functions
TableType TUsage CONFIGURATIONRows 160SizeMB 0.336
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QERRiskIndex | varchar(38) | no | Risk index function | PKUID |
Weight | float(8) | yes | Weighting / Change value | |
QueryString | nvarchar(-1) | yes | Query | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
TypeOfCalculation | nvarchar(6) | yes | Calculation type | limited |
IsInActive | bit(1) | yes | Disabled | |
DisplayValue | nvarchar(512) | yes | Name | |
Description | nvarchar(-1) | yes | Description | |
UID_DialogColumn | varchar(38) | yes | Table column (target) | FKUID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| No FK rows in snapshot. | ||
Triggers
GEN_T1B33CE4ECEB6FFE4A1A1E896B SQL_TRIGGER
GEN_T20BDD984EE7620E6861F4135B SQL_TRIGGER
GEN_T3B98D4D82F6B7664F125C5331 SQL_TRIGGER
GEN_T5268C92936DFA252DAA8D57E7 SQL_TRIGGER
QER_TDQERRiskIndex SQL_TRIGGER
QER_TIQERRiskIndex SQL_TRIGGER
QER_TUQERRiskIndex 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.QER_PQERRiskIndexDefine | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PSQRiskIndexGetUpdate | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.GEN_T30FD7D35FC495D5D5685F4017 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5268C92936DFA252DAA8D57E7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PQERRiskIndexDefine | source text reference | has TRY/CATCH error handling |
| dbo.QER_PSQRiskIndexGetUpdate | source text reference | SQL_STORED_PROCEDURE |