|
|
||||||
|
|
||||||
Workflow Screenshot
Properties
| Property | Value |
| Name | FactActiveEnrollmentSnapshotLoad |
| Description | This package will extract the Enrollment Information for all the Active Terms. One row per student per term per class will be created if the Student was enrolled on the day for which the package is executed. All the data in this Fact table will be removed during each execution and will be re-created for the current day. |
| Checkpoint File Name | |
| Checkpoint Usage | Never |
| Check Signature On Load | True |
| Creation Date | Tuesday, May 08, 2012 4:11 PM |
| Creator Computer Name | SCOWAN |
| Creator Name | SCOWAN\hetgroup |
| Debug Mode | False |
| Delay Validation | False |
| Disable | False |
| Disable Event Handlers | False |
| Enable Configurations | True |
| Encrypt Checkpoints | False |
| Fail Package On Failure | False |
| Fail Parent On Failure | False |
| Forced Execution Value | 0 |
| Force Execution Value | None |
| Description | False |
| ID | 2904468b-e9ef-4362-901a-1bbaecb28d29 |
| Interactive Mode | False |
| Is Default Locale ID | False |
| Isolation Level | Serializable |
| Locale ID | 1033 |
| Logging Mode | Enabled |
| Max Concurrent Executables | -1 |
| Maximum Error Count | 1 |
| Offline Mode | False |
| Package Type | DTSDesigner100 |
| Protection Level | DontSaveSensitive |
| Save Checkpoints | False |
| Suppress Configuration Warnings | False |
| Suspend Required | False |
| Transaction Option | Supported |
| Update Objects | False |
| Version Build | 214 |
| Version Comments | |
| Version Guid | f9dce5ee-04d9-49f2-be72-39c93927f9cf |
| Version Major | 1 |
| Version Minor | 0 |
Executables
| Name | Type | Description |
Data Flow Task |
Data Flow Task |
|
For Each Loop |
Foreach Loop Container |
|
Task |
Execute SQL Task |
|
Task |
Execute SQL Task |
|
Task |
Execute SQL Task |
Connection Managers
| Name | Description |
Log Providers
| Name | Description |
User Defined Variables
| Name | Value | Expression | Description |
SELECT
st_clslog.STDNT_ID
,st_clslog.EFF_TRM
,st_clslog.REF_NUM
,st_clslog.LOG_DATE
,ISNULL(st_clslog.LOG_TIME,0) AS LOG_TIME
,st_clslog.NOT_PAID_FLG
,st_clslog.TRNSCTN_TY
FROM [dbo].[ST_STDNT_CLS_LOG_ARCH_A] st_clslog
WHERE EFF_TRM = ''
AND [REF_NUM] IS NOT NULL
AND dbo.udf_StringToDate([LOG_DATE]) <=
'2016-03-04'
|
"SELECT
st_clslog.STDNT_ID
,st_clslog.EFF_TRM
,st_clslog.REF_NUM
,st_clslog.LOG_DATE
,ISNULL(st_clslog.LOG_TIME,0) AS LOG_TIME
,st_clslog.NOT_PAID_FLG
,st_clslog.TRNSCTN_TY
FROM [dbo].[ST_STDNT_CLS_LOG_ARCH_A] st_clslog
WHERE EFF_TRM = '" + @[User::TermResults] + "'
AND [REF_NUM] IS NOT NULL
AND dbo.udf_StringToDate([LOG_DATE]) <=
'" + @[User::CurrentDayDate] + "'
" |
This variable contains the Select Statement to copy Prior Year Enrollment from Archived Stdnt Class Log in Staging to DWOperations |
|
SELECT
st_clslog.STDNT_ID
,st_clslog.EFF_TRM
,st_clslog.REF_NUM
,st_clslog.LOG_DATE
,ISNULL(st_clslog.LOG_TIME,0) AS LOG_TIME
,st_clslog.NOT_PAID_FLG
,st_clslog.TRNSCTN_TY
FROM [dbo].[ST_STDNT_CLS_LOG] st_clslog
WHERE EFF_TRM = ''
AND [REF_NUM] IS NOT NULL
AND dbo.udf_StringToDate([LOG_DATE]) <=
'2016-03-04'
|
"SELECT
st_clslog.STDNT_ID
,st_clslog.EFF_TRM
,st_clslog.REF_NUM
,st_clslog.LOG_DATE
,ISNULL(st_clslog.LOG_TIME,0) AS LOG_TIME
,st_clslog.NOT_PAID_FLG
,st_clslog.TRNSCTN_TY
FROM [dbo].[ST_STDNT_CLS_LOG] st_clslog
WHERE EFF_TRM = '" + @[User::TermResults] + "'
AND [REF_NUM] IS NOT NULL
AND dbo.udf_StringToDate([LOG_DATE]) <=
'" + @[User::CurrentDayDate] + "'
" |
This variable contains the Select Statement to copy Prior Year Enrollment from Staging to DWOperations |
|
2016-03-04 |
This is a configuration setting in SSIS_Configurations that is set to the date that the package is being executed on. |
||
System.Object |
This contains the Active Terms returned from a SQL select statement. |
||
EXEC dbo.usp_FactEnrollmentSS_Select '2016-03-04' , '' |
"EXEC dbo.usp_FactEnrollmentSS_Select '" + @[User::CurrentDayDate] + "' , '" + @[User::TermResults] + "'" |
This is the SQL statement to execute a Stored Procedure to retrieve data from the Student Class Log file in the source system. |
|
This variable is used in a For Each Loop container to extract data for each active term. |
System Variables
| Name | Value | Expression | Description |
| Powered by BI Documenter |
