Script table
The
DEPM_MOD_SCRIPT table represents a SQL statement that is used to
execute any transformational statement on the staging database.| Name | Definition |
|---|---|
| Name | nvarchar(50) NOT NULL; PK |
| Description | nvarchar(150) NULL |
| ModelName | nvarchar(50) NOT NULL; PK |
| Definition (can contain Custom Settings) | ntext NULL |
| LastSuccessfulExecution | timestamp NULL |
The name of a script is unique for the model.
LastSuccessfulExecution indicates the time (UTC) when the script was last
run with a successful result.
The table has these references:
| Source columns | Target table | Target columns |
|---|---|---|
| ModelName | _model | Name |