dbo.PersonHasObject
Identities: company resource assignments
TableType TUsage MATERIALRows 2691SizeMB 2.032
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_PersonHasObject | varchar(38) | no | Assignment | PKUID |
ObjectKey | varchar(138) | no | Assignment | |
UID_Person | varchar(38) | no | Identity | FKUID |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
InheritInfo | int(4) | yes | Origin | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL2554 | PersonHasObject.UID_Person | Person.UID_Person |
Triggers
CPL_TDPersonHasObject SQL_TRIGGER
CPL_TIPersonHasObject SQL_TRIGGER
GEN_T24F8BC3831E58ED3CEB557D83 SQL_TRIGGER
GEN_T3B02BECBF1EA2DDCE7D1E83F1 SQL_TRIGGER
QER_TDPersonHasObject SQL_TRIGGER
QER_TIPersonHasObject 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.CPL_FTCCSPersonCheckWithOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_FTCCSPersonHasObjectWPWO | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA255A0285DD402BFAB93B25 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA611AC9FE209B209D6BA5B6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA6B0C73DBB737AB994BFB9E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA7753660E27005EE52B37B7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAD7000AD9C38ECA30590962 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAD7441E90FFE1AE74985684 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO441C2F873660C363A87E18 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO6FE29BD24EE8070A0F58FF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO9226A461259BE698109D7C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOACC993FDAF5792E1B59AE0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOB7D443E409F1129BFD9922 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD48DD3E8DD9E49B431EC66 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD74410BBDA5C1BE51102F6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY06423E1553D20332D88F9A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY19AE465A1AEDCAF37D47AC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY8C8C8E4B72714983D306FB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY9D970CBAA569CA4712CE1A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYA5065182EC53F911A8AB59 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYB5B79D3FB317B463216F71 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYEB1C7B5195AE3821552788 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopPersonHasObjFill_b | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PPersonHasObjectPostProc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasObjectExtAtt | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TDObjectHasExtendedAtt | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIObjectHasExtendedAtt | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_VCCSPersonCheck | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_VCCSPersonCheckDetail | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA0766FF57DCBE22C2C416B399 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA1FA3277F874351244D8452DD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA3ADA5606B1CF0AE5C2D3E1A9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA7FAF5FF7F13165FBB987A22C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA86EADBDEBC39FECD4271A6AA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA92A4A25A42E56828F0F4258A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAB55ED05D5A72AF5AFD98195B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAB7D6D093CD99BCBB45621C50 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAD59A3C45A72F29FE85CEC434 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VADE4AF4B967D1575C5A1F386F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VADF0FE2C85DDDCD2BBFEBB966 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAE7BD443F54A53B6F0C66FAF0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAFFFB439EB331F52E1288CDB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VPersonHasElemWReason | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VPersonInOrgAndPHO | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QERVPersonHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVGroupMemberSource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVUNSGroupOwner | SQL expression dependency | OBJECT_OR_COLUMN |
| Person | referenced by foreign key from table | QER_RFRL2554: PersonHasObject.UID_Person -> Person.UID_Person |
| dbo.CPL_FTCCSPersonCheckWithOrg | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.CPL_FTCCSPersonHasObjectWPWO | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.ADS_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_PITShopPersonHasObjFill_b | source text reference | has TRY/CATCH error handling |
| dbo.QER_PPersonHasObjectPostProc | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZPersonHasObjectExtAtt | source text reference | has TRY/CATCH error handling |
| dbo.RMS_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.RPS_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_TDObjectHasExtendedAtt | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIObjectHasExtendedAtt | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-cpl-compositionapi-cpl-compositionapi-itshop-cartcompliancecheck.cs | decompiled C# reference | classes CartComplianceCheck, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass12_0, _003C_003Ec__DisplayClass17_0; methods MoveNext, SetStateMachine, _003CGetViolationsAsync_003Eb__1, _003CGetViolationsAsync_003Eb__2, _003CSetExceptionApproverFlagsAsync_003Eb__1, _003CCheckOrgAssignmentComplianceAsync_003Eb__3; references AERole, ComplianceRule, ComplianceSubRule, Department, ESet, HelperPWOPersonHasObject; markers reads entity values, references DB/Dialog objects, IT Shop related markers |