dbo.ESetCollection
System role collection
TableType TUsage MATERIALRows 0SizeMB 0
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ESet | varchar(38) | no | System role | PKFKUID |
UID_ESetChild | varchar(38) | no | Child system role | PKFKUID |
XTouched | nchar(2) | yes | Processing status |
Relations
| FK | From | To |
|---|---|---|
| RMS_RFRL1669 | ESetCollection.UID_ESetChild | ESet.UID_ESet |
Triggers
GEN_T1EB0419D1612584B0FF3971C8 SQL_TRIGGER
GEN_T29A449D0F747EA84411EDB5A2 SQL_TRIGGER
RMS_TDESetCollection SQL_TRIGGER
RMS_TIESetCollection 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.RMS_ZESetCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_ZESetHasEntitlement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_ZOrgHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_ZPersonHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_ZWorkDeskHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3202EECD5BF7ECB1080318E2C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TDESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TIESetHasEntitlement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TUESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TUESetHasEntitlement | SQL expression dependency | OBJECT_OR_COLUMN |
| ESet | referenced by foreign key from table | RMS_RFRL1669: ESetCollection.UID_ESetChild -> ESet.UID_ESet |
| dbo.RMS_ZESetCollection | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_ZESetHasEntitlement | source text reference | has TRY/CATCH error handling |
| dbo.RMS_ZOrgHasESet | source text reference | has TRY/CATCH error handling |
| dbo.RMS_ZPersonHasESet | source text reference | has TRY/CATCH error handling |
| dbo.RMS_ZWorkDeskHasESet | source text reference | has TRY/CATCH error handling |
| dbo.RMS_TDESet | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TIESetHasEntitlement | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TUESet | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TUESetHasEntitlement | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |