|
|
||||||
|
|
||||||
Workflow Screenshot
Properties
| Property | Value |
| Name | FactStudentGraduationLoad |
| 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 | aca00cfc-2069-4dab-9347-5c14fb69076d |
| Interactive Mode | False |
| Is Default Locale ID | False |
| Isolation Level | Serializable |
| Locale ID | 1033 |
| Logging Mode | UseParentSetting |
| 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 | 314 |
| Version Comments | |
| Version Guid | f15884e6-e730-4db5-8897-8c006f7da236 |
| Version Major | 1 |
| Version Minor | 0 |
Executables
| Name | Type | Description |
Data Flow Task |
Data Flow Task |
|
Data Flow Task |
Data Flow Task |
|
Task |
Execute SQL Task |
|
Task |
Execute SQL Task |
Connection Managers
| Name | Description |
Log Providers
| Name | Description |
User Defined Variables
| Name | Value | Expression | Description |
EnterpriseDW |
|||
-- Get all graduation records.
SELECT
grad.STDNT_ID AS StudentId
,grad.PGM_ID AS ProgramCode
,grad.EFF_TERM AS EffectiveTerm
,grad.SEQ_NUM AS SequenceNumber
,grad.ACT_GRAD_TRM AS GraduationTerm
,COUNT(*) AS NumTermsToGraduate
,ISNULL(grad.PGM_GPA,0) AS ProgramGpa
FROM dbo.ST_STDNT_OBJ_AWD_A grad
LEFT OUTER JOIN
(
/* Get list of terms that the student has local classes in Academic History */
SELECT STUDENT_ID
,LTRIM(RTRIM(SUBSTRING(CLASS_KEY,12,6))) AS TRM_YR
FROM ST_ACDMC_HIST_A
WHERE SUBSTRING(CLASS_KEY,1,1) = 'C' OR SUBSTRING(CLASS_KEY,1,1) = 'N' -- Local classes
GROUP BY STUDENT_ID, LTRIM(RTRIM(SUBSTRING(CLASS_KEY,12,6)))
) AH
ON (
AH.STUDENT_ID = grad.STDNT_ID
AND AH.TRM_YR <= grad.ACT_GRAD_TRM
)
WHERE grad.ACT_GRAD_TRM IS NOT NULL
AND grad.ACT_GRAD_TRM <> ''
GROUP BY grad.STDNT_ID
,grad.PGM_ID
,grad.EFF_TERM
,grad.SEQ_NUM
,grad.ACT_GRAD_TRM
,ISNULL(grad.PGM_GPA,0)
|
"
-- Get all graduation records.
SELECT
grad.STDNT_ID AS StudentId
,grad.PGM_ID AS ProgramCode
,grad.EFF_TERM AS EffectiveTerm
,grad.SEQ_NUM AS SequenceNumber
,grad.ACT_GRAD_TRM AS GraduationTerm
,COUNT(*) AS NumTermsToGraduate
,ISNULL(grad.PGM_GPA,0) AS ProgramGpa
FROM dbo.ST_STDNT_OBJ_AWD_A grad
LEFT OUTER JOIN
(
/* Get list of terms that the student has local classes in Academic History */
SELECT STUDENT_ID
,LTRIM(RTRIM(SUBSTRING(CLASS_KEY,12,6))) AS TRM_YR
FROM ST_ACDMC_HIST_A
WHERE SUBSTRING(CLASS_KEY,1,1) = 'C' OR SUBSTRING(CLASS_KEY,1,1) = 'N' -- Local classes
GROUP BY STUDENT_ID, LTRIM(RTRIM(SUBSTRING(CLASS_KEY,12,6)))
) AH
ON (
AH.STUDENT_ID = grad.STDNT_ID
AND AH.TRM_YR <= grad.ACT_GRAD_TRM
)
WHERE grad.ACT_GRAD_TRM IS NOT NULL
AND grad.ACT_GRAD_TRM <> ''
GROUP BY grad.STDNT_ID
,grad.PGM_ID
,grad.EFF_TERM
,grad.SEQ_NUM
,grad.ACT_GRAD_TRM
,ISNULL(grad.PGM_GPA,0)
" |
||
Jan 1 1900 12:00AM |
|||
Mar 4 2016 10:33AM |
System Variables
| Name | Value | Expression | Description |
| Powered by BI Documenter |
