dbo.RPSReport
Subscribable reports
TableType TUsage USERDATARows 44SizeMB 0.12
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_RPSReport | varchar(38) | no | Predefined report | PKUID |
Ident_RPSReport | nvarchar(256) | no | Name | |
UID_DialogReport | varchar(38) | no | Report | FKUID |
Description | nvarchar(-1) | yes | Description | |
UID_AccProduct | varchar(38) | yes | Service item | FKUID |
IsForITShop | bit(1) | yes | IT Shop | |
IsITShopOnly | bit(1) | yes | Only use in IT Shop | |
IsInActive | bit(1) | yes | Disabled | |
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 | |
RiskIndex | float(8) | yes | Risk index | |
PreProcessorCondition | nvarchar(2048) | yes | Preprocessor condition | |
IsDeactivatedByPreProcessor | bit(1) | yes | Deactivated by preprocessor | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
ExportFormat | varchar(256) | yes | Format (e-mail attachment) | |
IsListReport | bit(1) | yes | Simple list report | |
ReportDefinition | nvarchar(-1) | yes | Report definition | |
UID_PersonOwner | varchar(38) | yes | Owner | FKUID |
Relations
| FK | From | To |
|---|---|---|
| RPS_RFRL1000 | RPSReport.UID_PersonOwner | Person.UID_Person |
| RPS_RFRL4167 | RPSReport.UID_DialogReport | DialogReport.UID_DialogReport |
| RPS_RFRL4170 | RPSReport.UID_AccProduct | AccProduct.UID_AccProduct |
Triggers
GEN_T29DEE62EF858B51B04394AA0D SQL_TRIGGER
GEN_T3EF2A24EC8C84ED380F7012C0 SQL_TRIGGER
GEN_T5CD5B9F09DE529E15A5C19984 SQL_TRIGGER
RPS_TATTURPSReport SQL_TRIGGER
RPS_TIRPSReport SQL_TRIGGER
RPS_TURPSReport 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.GEN_FT0044E9DC660D8FECCA25B039 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA5EA3EF0E9FC80233ADD9EE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA68DE2FD4D90FC662383EB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA78C3BCC907CEF155050D0B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAAC15AF9D41DD5F69733C77 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAB7DBF0F7F222EB264AEFE2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAC3ADCB5E377B40F83363AD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAD6FE70DA25EEF93CA9D2B9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEADB0B0EC871449B1B49BEF1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAFBEAF4BE6580A2C3226736 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEFFAA41A2AB92F8FB75E91BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO10971C9480677C7F862216 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO1D1CA7D5FD62681C041DEC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO6224CD38BD1B4497851790 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO8E13F4963076C7F5D04DB8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO8EDF537F72D2FFD396F085 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO9D4FD2292EFC748015E780 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO9E905677168B2599FECD5F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOA3730A0231D3DD7638F7BC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD74410BBDA5C1BE51102F6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOF3591ACC43EAD381AF1626 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY01FB8D175B472AFAC4FBBD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY06423E1553D20332D88F9A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY334AF4B7AAF5D1C1085331 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY5082C636ECA32E1D797C16 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY5A3D5445A31314E3C80820 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY680B289738F51B38B41A7B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY896E146F4F840E422CCBA3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY94A1455D19630D9B5E3446 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYA98DB5E80EFE54297AA0A8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYD9F80E09EE41CB3418962A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P47FE782293862D2C716B80BCC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P8BBE7521D9BA354471DFB91B1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PE728BC6CE1F9D630117C55DCF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZAllForOneRPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZOrgHasRPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZPersonHasRPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZPrePropRPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT4EA9514908EF8B11861005B5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE429BF64AFEA12BCCFC1AC2C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T160DCD9E8D814DB7512FAABD4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T18982FEA1E48BBC7BBED1F2AE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1ACCF3B9FB3C044F4C41A708C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C3D78466F05DE84C333B3E26 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1EA7BE24A3331D721708CF413 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T215AE2BC45821F9ABAC4A311C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2439B5DE1D79CA228D58E37FF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T25894CE85FB7F76D27F9EBFB0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C2630021CB14906358C7D203 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2CF44B1B0CFB801EB44A91ECE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T51E48C470396EA5ADB872F98B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T57F8608F242285E77AC895FFB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5CD5B9F09DE529E15A5C19984 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_TIBaseTreeHasRPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_TIPersonHasRPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_TURPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMVSystemOverview | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERAccProductUsage | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVBaseTreeHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonAndAERoles | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| Person | referenced by foreign key from table | RPS_RFRL1000: RPSReport.UID_PersonOwner -> Person.UID_Person |
| DialogReport | referenced by foreign key from table | RPS_RFRL4167: RPSReport.UID_DialogReport -> DialogReport.UID_DialogReport |
| AccProduct | referenced by foreign key from table | RPS_RFRL4170: RPSReport.UID_AccProduct -> AccProduct.UID_AccProduct |
| dbo.RPS_ZAllForOneRPSReport | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.RPS_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.RPS_ZOrgHasRPSReport | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.RPS_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.RPS_ZPersonHasRPSReport | source text reference | has TRY/CATCH error handling |
| dbo.RPS_ZPrePropRPSReport | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.RPS_TIBaseTreeHasRPSReport | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RPS_TIPersonHasRPSReport | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RPS_TURPSReport | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-rps-customizer-rps-customizer-personhasrpsreport.cs | decompiled C# reference | classes PersonHasRPSReport; methods MoveNext, SetStateMachine, CreateITShopOrder; references Person, PersonHasRPSReport, RPSReport; markers references DB/Dialog objects, IT Shop related markers |
| cs-rps-customizer-rps-customizer-rpsreport.cs | decompiled C# reference | classes RPSReport; methods MoveNext, SetStateMachine, _CreateParameterSet, OnSavedAsync; references DialogParameter, DialogParameterSet, DialogReport, RPSReport; markers reads entity values, references DB/Dialog objects |
| cs-rps-customizer-rps-customizer-rpssubscription.cs | decompiled C# reference | classes RPSSubscription; methods MoveNext, SetStateMachine, _CreateParameterSet; references DialogParameter, DialogParameterSet, RPSReport, RPSSubscription; markers reads entity values, references DB/Dialog objects |
| cs-rps-forms-rps-forms-formrpsreportmasterdata.cs | decompiled C# reference | classes FormRPSReportMasterData; methods OnInit, OnDesignChanged, InitializeComponent, OnFormLoad, OnFormSizeChanged, Task_Preview; references AccProduct, DialogParameter, DialogParameterSet, DialogReport, Person, RPSReport; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers |