dbo.AttestationCase
Attestation cases
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_AttestationCase | varchar(38) | no | Attestation case | PKUID |
UID_QERJustification | varchar(38) | yes | Standard reason | FKUID |
UID_AttestationPolicy | varchar(38) | no | Attestation policy | FKUID |
UID_PersonHead | varchar(38) | yes | Approver | FKUID |
ObjectKeyBase | varchar(138) | yes | Attestation object | |
DisplayName | nvarchar(510) | yes | Display name | |
ReportContent | nvarchar(-1) | yes | Report | |
IsClosed | bit(1) | yes | Closed | |
IsGranted | bit(1) | yes | Approved | |
DisplayPersonHead | nvarchar(510) | yes | Approver | |
ReasonHead | nvarchar(-1) | yes | Reason for decision | |
DateHead | datetime(8) | yes | Approval date | |
DecisionLevel | int(4) | yes | Approval level | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XUserInserted | nvarchar(128) | yes | Created by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
ReportType | nvarchar(32) | yes | Output format | |
ToSolveTill | datetime(8) | yes | Due date | |
StructureDisplay1 | nvarchar(2048) | yes | Grouping column 1 | |
StructureDisplay2 | nvarchar(2048) | yes | Grouping column 2 | |
StructureDisplay3 | nvarchar(2048) | yes | Grouping column 3 | |
PropertyInfo1 | nvarchar(2048) | yes | Property 1 | |
PropertyInfo2 | nvarchar(2048) | yes | Property 2 | |
PropertyInfo3 | nvarchar(2048) | yes | Property 3 | |
PropertyInfo4 | nvarchar(2048) | yes | Property 4 | |
IsReserved | bit(1) | yes | Reserved | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
RiskIndex | float(8) | yes | Risk index | |
ObjectKey1 | varchar(138) | yes | Related object 1 | |
ObjectKey2 | varchar(138) | yes | Related object 2 | |
ObjectKey3 | varchar(138) | yes | Related object 3 | |
IsNotApprovedBefore | bit(1) | yes | Not approved before | |
UID_AttestationRun | varchar(38) | no | Attestation run | FKUID |
UID_QERWorkingMethod | varchar(38) | yes | Running instance of approval workflow | FKUID |
PeerGroupFactor | float(8) | yes | Peer group factor | |
IsCrossFunctional | bit(1) | yes | Functional foreign | |
IsUnderConstruction | bit(1) | yes | In progress | |
Recommendation | int(4) | yes | Recommendation | limited |
RecommendationDetail | nvarchar(-1) | yes | Details of recommendation |
Relations
| FK | From | To |
|---|---|---|
| ATT_RFRL1494 | AttestationCase.UID_PersonHead | Person.UID_Person |
| ATT_RFRL1496 | AttestationHistory.UID_AttestationCase | AttestationCase.UID_AttestationCase |
| ATT_RFRL1497 | AttestationCase.UID_AttestationPolicy | AttestationPolicy.UID_AttestationPolicy |
| ATT_RFRL1501 | AttestationCase.UID_AttestationRun | AttestationRun.UID_AttestationRun |
| ATT_RFRL2005 | AttestationHelper.UID_AttestationCase | AttestationCase.UID_AttestationCase |
| ATT_RFRL2551 | AttestationCaseHasMControl.UID_AttestationCase | AttestationCase.UID_AttestationCase |
| ATT_RFRL2555 | AttestationCase.UID_QERJustification | QERJustification.UID_QERJustification |
| ATT_RFRL300 | AttestationCase.UID_QERWorkingMethod | QERWorkingMethod.UID_QERWorkingMethod |
Triggers
ATT_TDAttestationCase SQL_TRIGGER
ATT_TIAttestationCase SQL_TRIGGER
ATT_TUAttestationCase SQL_TRIGGER
GEN_T2C5A7B57D8AD06769420F2A6A SQL_TRIGGER
GEN_T33FC1835C9D183DF3DC73AD3B 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.ATT_FTAttCasesForBaseObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_FTAttCasesForBaseObject | SQL expression dependency | dbo · UID_AttestationCase · OBJECT_OR_COLUMN |
| dbo.ATT_FTAttCasesForBaseObject | SQL expression dependency | dbo · ObjectKeyBase · OBJECT_OR_COLUMN |
| dbo.ATT_FTAttCasesForBaseObject | SQL expression dependency | dbo · ObjectKey1 · OBJECT_OR_COLUMN |
| dbo.ATT_FTAttCasesForBaseObject | SQL expression dependency | dbo · ObjectKey2 · OBJECT_OR_COLUMN |
| dbo.ATT_FTAttCasesForBaseObject | SQL expression dependency | dbo · ObjectKey3 · OBJECT_OR_COLUMN |
| dbo.ATT_FTATTDecisionPossible | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_FTATTDecisionPossible | SQL expression dependency | dbo · UID_AttestationCase · OBJECT_OR_COLUMN |
| dbo.ATT_FTATTDecisionPossible | SQL expression dependency | dbo · IsUnderConstruction · OBJECT_OR_COLUMN |
| dbo.ATT_FTAttestationRulerAD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_FTAttestationRulerAL | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_FTAttestationRulerAP | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_FTObjectKeysForAttCaseDec | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT0044E9DC660D8FECCA25B039 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT2C474E889CA9C8FCEA4EC191 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT2C7A1B8F5142CADC43C12E36 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT2D1FA228B84AFBBC14771E3E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT3354606E3BF1E02E5A5A0D6D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT338A25E7F823BCDE7C6FE46D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT40E617EA4EDFD9F440AB5C68 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT4C7BC4445A0341819B629866 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT5722C3D575F878FB30B0EE5B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT5A6F9D07A29423F9B201F14A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT608B5DA1F6AD03A10CD2C831 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT71486EB9289E8C428D0BC8BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT845EC51B5AF2EB6FB365CF0A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT85A7A15236CA027EB51A0677 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT8E628D60FC464C8B7A3E7163 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT927E5D5D3F0555DEEE967B36 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTB7B5BDD7AB99634CC7E45559 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTBD06BC392C446FFD04D09C27 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTC016772C36040219536E1C4A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTC089FEB4D7097AB81097AD23 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTC97C4E282A021430296681B0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTC981DF5F2F0406E0D7320D5B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE10BCE32554C404BF46E35BC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE35AC06685CE359B1AF5EA91 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE61C28094906F2921112552C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE88D7AC2E5BCB2C66CBA5FF1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEFFAA41A2AB92F8FB75E91BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTF3A3F8BCA98F86D47979C4BF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTF44D88E18725B741C6F53649 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTFA19C28A35DB0558466A0353 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTFF06E267A3719F2448E723DE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMB_FTAttestationRulerAO | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_FGIReasonTypeForAttCase | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_P47650F5671BCBA8B679125E_ | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_P600B8EB3A312074D1A10A4A_ | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_PAfterMigrationTasks | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_PAttestationCaseCreate_i | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_PAttestationHelperFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_RAttestationAbort | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_RAttestationCheckValid | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_RAttestationHelperFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_RAttestationMakeDecisionCD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_RAttestationMakeDecisionEX | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_RAttestationMakeDecisionWC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_RAttestationReminder | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_RAttestationReset | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationCheckValid | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationMakeDecisionCD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationMakeDecisionEX | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationMakeDecisionWC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationReminder | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationReset | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttestationRunDeleteOld | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAttHelperFill_Recalc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P1BF268D1A2D85F748D1C8D3DC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P1D67E3E269674A9ABEB90BA37 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P3D1014B8F2EC2E7D43FE7A93B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P3E0A52C4815EF3D7D5E6F6954 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P4057136D381E001C6D193807D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P4A3DAB9B7D76F4026E32FF0AF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P511ED250CC29BC4790569AD05 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P52191672D9A949F56CEF49189 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P79C56D662E8621728F4523495 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P80179191B9F74E79661E38B69 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P81873663C07A2B77D5AFA3EBA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P868803F97F7D407AF1FDCB2CB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P8BBE7521D9BA354471DFB91B1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P8E0BA4E922554B2BBDE398B01 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P96DE6C8F5BE12F18D75820E01 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P9B87544E1325D45A63B7E4C95 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PB1830A69EEF88FC94BC348C4B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PB2F935A721940C6E32DB7B15C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PB940AF6AF37DA86891585D609 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PB997831590DAEE270ABD98498 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PD6497BB2C618C7A8F2D853CBF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PD7F5C14E45AA0CB9A2F4BD7AD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PD994860C104395BD514FD90DD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PDB723629AD0B408FABAA3CD5E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PE480ACF02FD9C9941892572A7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PE728BC6CE1F9D630117C55DCF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PEB7B38B3919D8817864BF479A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PF1F9147D1FE627AD8AD522454 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PF213242606AF08FBBEC556492 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PF837A42D1078A12AD322DF2DB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PFFF6475ED5AB3E00FA2D77305 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ARS_FTAttestationRulerPA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_FTAttCasesForManager | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_FTAttNextDecisionMaker | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT08A14AE8F9D981AD09F553B0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT0C630EFF36AD9E49E0FFF2FE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT0F7FE5A5A25A6DE9C309A9D7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT0F901AD6507907BB01E4A981 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT206288222D1F87EA0484AA8A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT2A6B61A1A68C55C23D506F43 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT43995B4CF20EE84DFB6E7371 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT4EA9514908EF8B11861005B5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT6584585E7E66B87B5B962382 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT6719C6F395ED676A7D718650 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT6B98DA23F38CBB384A685EC8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT842C03601E482D5270A228C9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT87DD7CCCB1A93594B7DE8E69 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT90047D6917308974E35F601B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT9C4D6102BCF4ED8AC1D655D7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTA3AD537967B99F82C7D2C1DC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTA4721EFEFFE03144F484EE09 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTA591CB967B6EB7D1ABA2C46D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTA73ADF7F79169968E59D3549 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTA79399517D2D1260EA6DA690 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTAE7F54B43880F6D4AB069DA1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTD77937B9B2F8F10E78FB7DD3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTDB92B44B6D3F9012EB5B6BC0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE429BF64AFEA12BCCFC1AC2C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_FTAttCasesForManager | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TDBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TDQERUniversalSubstitute | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TIQERUniversalSubstitute | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUAttestationCase | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUAttestationPolicy | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUPWODecisionMethod | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUPWODecisionSubmethod | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUQERUniversalSubstitute | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_TUATTComplianceRule | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1555D0903AA51FFEA947C0D73 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C3D78466F05DE84C333B3E26 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FFF140BA494B3D88D2C4663E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T21F6500A327433F3515292487 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2948D4DD82032AEE0AA8EBBDB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C2630021CB14906358C7D203 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.POL_TIATTPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.POL_TUATTPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.POL_TUATTQERPolicy | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DO | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · UID_AttestationCase · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · UID_AttestationPolicy · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · UID_PersonHead · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · DisplayName · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · IsClosed · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · DecisionLevel · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_DOS | SQL expression dependency | dbo · IsReserved · OBJECT_OR_COLUMN |
| dbo.ATT_VAttDecisionPerson_I | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_VElementAndRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_VElementAndRoot | SQL expression dependency | dbo · UID_AttestationCase · OBJECT_OR_COLUMN |
| dbo.ATT_VElementAndRoot | SQL expression dependency | dbo · UID_AttestationPolicy · OBJECT_OR_COLUMN |
| dbo.ATT_VElementAndRoot | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.ATTVCasesOpenByPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_V118F829496034F2DE2F3C7217 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA0027FC97D740B782E506DE7D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA05BB553BE91FAEE8713379CA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA0656856FAF3EE754CE71C04A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA111423CC66E5842CBB1C687D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA185773EB322C9FC7F9EEE642 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA1D2C7FA260E5E16154DD6176 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA1DA7D80B997259AF7D5121A8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA25D7F6BF7D5FDBED9317006F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA2762FFD20AA3ACC4FE56E7F8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA293803C3DBC1BD856CDD922F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA32BDA1DCB812DCADC999EA4B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA37708886E5E94799AAB62D42 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA39182F18C1CD001E7EA6166F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA3F0D9DEB25E1AE1067533D6A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA41551C6BAF738FFF56E41796 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA5CA004B104300E79A7343554 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA615759A0C32981E4BF7FF69A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA661CC924758A1D4472C45800 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA6E29F464D57F9113C35C7118 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA79D54C7FA1E39C832BA03761 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA7D7B6157DE10EB7E6F126D8C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA87237D1300BE930184981BB6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA8AAA27F90FF51BC6C7479DB5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAA3B2403FF92C3210786A92EE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAA95991A793B7D963A4C47BF1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAAA6C3E5DBA851C32D14B04FD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAAFCC37D990A55B085258744B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAB28FDE4BEE5ABD025A1DE5DA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAC4223317172A4B6986977079 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VACE2FD44B696E81F98FAC09AF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VADF8FCDCF9E250A22ABAE212F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAE6E47918C9A698F06ADC90B3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAEE0B8BE6268490874574812F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAEE9545DF38BAC08B777B9B45 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAFC7E0BD7B6E73B489F302AAF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAFF59783452135DA9FCE14B07 | SQL expression dependency | OBJECT_OR_COLUMN |
| Person | referenced by foreign key from table | ATT_RFRL1494: AttestationCase.UID_PersonHead -> Person.UID_Person |
| AttestationHistory | foreign key references table | ATT_RFRL1496: AttestationHistory.UID_AttestationCase -> AttestationCase.UID_AttestationCase |
| AttestationPolicy | referenced by foreign key from table | ATT_RFRL1497: AttestationCase.UID_AttestationPolicy -> AttestationPolicy.UID_AttestationPolicy |
| AttestationRun | referenced by foreign key from table | ATT_RFRL1501: AttestationCase.UID_AttestationRun -> AttestationRun.UID_AttestationRun |
| AttestationHelper | foreign key references table | ATT_RFRL2005: AttestationHelper.UID_AttestationCase -> AttestationCase.UID_AttestationCase |
| AttestationCaseHasMControl | foreign key references table | ATT_RFRL2551: AttestationCaseHasMControl.UID_AttestationCase -> AttestationCase.UID_AttestationCase |
| QERJustification | referenced by foreign key from table | ATT_RFRL2555: AttestationCase.UID_QERJustification -> QERJustification.UID_QERJustification |
| QERWorkingMethod | referenced by foreign key from table | ATT_RFRL300: AttestationCase.UID_QERWorkingMethod -> QERWorkingMethod.UID_QERWorkingMethod |
| dbo.ATT_FTAttCasesForBaseObject | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.ATT_FTATTDecisionPossible | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.ATT_FTAttestationRulerAD | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.ATT_FTAttestationRulerAL | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.ATT_FTAttestationRulerAP | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.ATT_FTObjectKeysForAttCaseDec | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.RMB_FTAttestationRulerAO | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.ATT_FGIReasonTypeForAttCase | source text reference | SQL_SCALAR_FUNCTION |
| dbo.ATT_P47650F5671BCBA8B679125E_ | source text reference | has TRY/CATCH error handling |
| dbo.ATT_P600B8EB3A312074D1A10A4A_ | source text reference | has TRY/CATCH error handling |
| dbo.ATT_PAfterMigrationTasks | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, has TRY/CATCH error handling |
| dbo.ATT_PAttestationCaseCreate_i | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_PAttestationCaseDeleteOld | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_PAttestationHelperFill | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_RAttestationAbort | source text reference | has TRY/CATCH error handling |
| dbo.ATT_RAttestationCheckValid | source text reference | has TRY/CATCH error handling |
| dbo.ATT_RAttestationHelperFill | source text reference | has TRY/CATCH error handling |
| dbo.ATT_RAttestationMakeDecisionCD | source text reference | has TRY/CATCH error handling |
| dbo.ATT_RAttestationMakeDecisionEX | source text reference | has TRY/CATCH error handling |
| dbo.ATT_RAttestationMakeDecisionWC | source text reference | has TRY/CATCH error handling |
| dbo.ATT_RAttestationReminder | source text reference | has TRY/CATCH error handling |
| dbo.ATT_RAttestationReset | source text reference | has TRY/CATCH error handling |
| dbo.ATT_ZAttestationCheck | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationCheckValid | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationMakeDecisionCD | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationMakeDecisionEX | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationMakeDecisionWC | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationReminder | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationReset | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_ZAttestationRunDeleteOld | source text reference | has TRY/CATCH error handling |
| dbo.ATT_ZAttHelperFill_Recalc | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_PPersonDelete_GDPR | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZQERWorkingMethodCleanUp | source text reference | has TRY/CATCH error handling |
| dbo.ARS_FTAttestationRulerPA | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.ATT_FTAttCasesForManager | source text reference | uses session context values |
| dbo.ATT_FTAttNextDecisionMaker | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.TSB_FTAttCasesForManager | source text reference | uses session context values |
| dbo.ATT_TDBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TDQERUniversalSubstitute | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TIQERUniversalSubstitute | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUAttestationCase | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUAttestationPolicy | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUPerson | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUPWODecisionMethod | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUPWODecisionSubmethod | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUQERUniversalSubstitute | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.CPL_TUATTComplianceRule | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.POL_TIATTPersonInBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.POL_TUATTPersonInBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.POL_TUATTQERPolicy | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-att-compositionapi-server-plugin-att-compositionapi-api-att-case-workflow.cs | decompiled C# reference | classes ATT_Case_Workflow, _003C_003Ec__DisplayClass0_0; methods MoveNext, SetStateMachine, _003CBuild_003Eb__0, _003CBuild_003Eb__2, _003CBuild_003Eb__3, _003CBuild_003Eb__4; references AttestationCase, AttestationPolicy, Delegation, ESet, Person; markers reads entity values, saves entities, references DB/Dialog objects, IT Shop related markers |
| cs-att-customizer-att-customizer-attestationcase.cs | decompiled C# reference | classes AttestationCase, MP, DecisionHistoryArgs, _003C_003Ec__DisplayClass4_0; methods _003C_Initialize_IsNotApprovedBefore_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync, _Initialize_IsNotApprovedBefore, Handle_DecisionHistory; references AttestationCase, AttestationHelper, AttestationHistory, AttestationObject, AttestationPolicy, Delegation; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-att-customizer-att-customizer-attestationpolicy.cs | decompiled C# reference | classes AttestationPolicy, ReportEngine, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass18_0; methods _003CCreateAttestation_003Eb__0, _003CPrepareAttestations_003Eb__0, _003CCompleteCasesUnderConstruction_003Eb__0, _003CCompleteCasesUnderConstruction_003Eb__2, _003C_GetGrantedCases_003Eb__0, _003C_CreateAttestations_003Eb__0; references AttestationCase, AttestationHelper, AttestationObject, AttestationObjectHasPWODM, AttestationPolicy, AttestationPolicyGroup; markers reads entity values, writes entity values, references DB/Dialog objects, Job/process related markers |
| cs-att-customizer-att-customizer-attestationrun.cs | decompiled C# reference | classes AttestationRun, _003C_003Ec__DisplayClass2_0; methods _003CCancel_OnSaving_003Eb__0, MoveNext, SetStateMachine, Cancel, Cancel_OnSaving; references AttestationCase, AttestationRun, Method_Attestation; markers reads entity values, references DB/Dialog objects |
| cs-att-forms-att-forms-formattestationmakedecision.cs | decompiled C# reference | classes FormAttestationMakeDecision; methods OnInit, InitializeComponent, OnFormLoad, OnFormSizeChanged, OnFormUnload, Task_ShowHistory; references AttestationCase, AttestationHelper, AttestationHistory, AttestationObject, AttestationPolicy, Delegation; markers reads entity values, references DB/Dialog objects |
| cs-att-forms-att-forms-formattestationqueryanswer.cs | decompiled C# reference | classes FormAttestationQueryAnswer; methods OnInit, InitializeComponent, OnFormLoad, MainActivator_OnActivating, ButtonAnswer_Click; references AttestationCase, AttestationHelper, Person, PWODecisionRule; markers references DB/Dialog objects |