dbo.DPRProjectionConfigStep
Steps of a synchronization project. The table is handled by the SynchronizationEditor. Do not make any changes here.
TableType TUsage USERDATARows 59SizeMB 0.144
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRProjectionConfigStep | varchar(38) | no | Synchronization step | PKUID |
UID_LeftDPRSystemConnection | varchar(38) | no | Left system connection | FKUID |
UID_RightDPRSystemConnection | varchar(38) | no | Right system connection | FKUID |
UID_LeftDPRProjectionQuota | varchar(38) | yes | Left quota | FKUID |
UID_RightDPRProjectionQuota | varchar(38) | yes | Right quota | FKUID |
XObjectKey | varchar(138) | no | Object key | |
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 | |
Description | nvarchar(2048) | yes | Description | |
DisplayName | nvarchar(512) | yes | Display name | |
ExceptionHandling | nvarchar(64) | yes | Exception handling | |
Name | nvarchar(512) | no | Name | |
NameFormat | nvarchar(64) | yes | Name format | |
ProjectionDirection | nvarchar(64) | yes | Projection direction | |
RuleBlackList | nvarchar(-1) | yes | Rule exclude list | |
RuleWhiteList | nvarchar(-1) | yes | Rule include list | |
SerializationBag | nvarchar(-1) | yes | Serialization bag | |
UID_QBMClrType | varchar(38) | no | CLR type | FKUID |
UseRevision | nvarchar(64) | yes | Use revision mode | |
UID_DPRProjectionConfig | varchar(38) | no | Projection configuration | FKUID |
UID_DPRSystemObjectMatchSets | varchar(38) | no | System object matching sets | FKUID |
UID_DPRSystemMap | varchar(38) | no | System map | FKUID |
IsDeactivated | bit(1) | yes | Disabled | |
Sequence | int(4) | yes | Sequence | |
IsImport | bit(1) | yes | Data import | |
IsPostProcessingStep | bit(1) | yes | Is post processing step | |
PerformanceMemoryFactor | float(8) | yes | Performance multiplier | |
LoadPartitionedThreshold | int(4) | yes | Load partitioned threshold | |
CommitPropertiesMode | nvarchar(32) | yes | Commit property changes | |
CommitPropertiesLeft | nvarchar(-1) | yes | Commit changes to %Globals.QIM_ProductNameShort% schema properties | |
CommitPropertiesRight | nvarchar(-1) | yes | Commit changes to target system schema properties | |
DoNotRespectOutstanding | bit(1) | yes | No handling of outstanding objects |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2449 | DPRProjectionConfigStep.UID_QBMClrType | QBMClrType.UID_QBMClrType |
| DPR_RFRL2493 | DPRJournalFailure.UID_DPRProjectionConfigStep | DPRProjectionConfigStep.UID_DPRProjectionConfigStep |
Triggers
DPR_TDDPRProjectionConfigStep SQL_TRIGGER
GEN_T1CA0C8442B8F03A860242E9BE SQL_TRIGGER
GEN_T2C0E22894CCB9523215FF2E10 SQL_TRIGGER
GEN_T3D65BC2FB5F6C2EB66C1056C1 SQL_TRIGGER
GEN_T45E6DD0AFC7832E22074D9D6F SQL_TRIGGER
GEN_T58BD28491CE6C73B41DAD4F75 SQL_TRIGGER
GEN_T6A014B4228BC5844BC6BC7BD3 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.DPR_FTProjectionRootRunning | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_FGIProjectionRootRunning | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13371B79AFC07E3D85A0E6931 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ABAE3443DC53DD3EC1BBAC13 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3C525F2AB326629B21A033B17 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_VWorkflowHandlesProperty | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_VWorkflowReadsProperty | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPRJournalObjectResultView | SQL expression dependency | OBJECT_OR_COLUMN |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2449: DPRProjectionConfigStep.UID_QBMClrType -> QBMClrType.UID_QBMClrType |
| DPRJournalFailure | foreign key references table | DPR_RFRL2493: DPRJournalFailure.UID_DPRProjectionConfigStep -> DPRProjectionConfigStep.UID_DPRProjectionConfigStep |
| dbo.DPR_FTProjectionRootRunning | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.DPR_FGIProjectionRootRunning | source text reference | SQL_SCALAR_FUNCTION |