DIM_PROCESS_STAGE
Intermediate storage for the process dimension
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| PROCESSSYSTEMID | uniqueidentifier | yes | [dbo].[ACKNOWLEDGEMENTPROCESS].[ID], [dbo].[CORRESPONDENCEPROCESS].[ID] or [dbo].[PLEDGEREMINDERPROCESS].[ID] | |
| PROCESSNAME | nvarchar(100) | yes | [dbo].[ACKNOWLEDGEMENTPROCESS].[NAME], [dbo].[CORRESPONDENCEPROCESS].[NAME] or [dbo].[PLEDGEREMINDERPROCESS].[NAME] | |
| PROCESSDESCRIPTION | nvarchar(255) | yes | [dbo].[ACKNOWLEDGEMENTPROCESS].[DESCRIPTION], [dbo].[CORRESPONDENCEPROCESS].[DESCRIPTION] or [dbo].[PLEDGEREMINDERPROCESS].[DESCRIPTION] | |
| PROCESSTYPECODE | tinyint | yes | 1 = Acknowledgements, 2 = Correspondence, 3 = Pledge Reminders | |
| PROCESSTYPE | nvarchar(50) | yes | Type of process: Acknowledgements, Correspondence or Pledge Reminders | |
| ISINCLUDED | bit | yes | Flag indicating when data should be included in results | |
| ETLCONTROLID | int | yes | ID generated through the ETL process. | |
| SOURCEDIMID | int | yes | Source system used. |