| Name |
Copy_ArchivedPriorEnrollment |
| Value |
 Expression: "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::PriorYearTermResults] + "'
AND [REF_NUM] IS NOT NULL
AND dbo.udf_StringToDate([LOG_DATE]) <=
'" + @[User::PriorYearDateResults] + "'
"
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]) <=
''
|
| Value Type |
String |
| Description |
This variable contains the Select Statement to copy Prior Year Enrollment from the Archived Student Class log file in Staging to DWOperations |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::Copy_ArchivedPriorEnrollment |
| Evaluate As Expression |
True |
| Expression |
"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::PriorYearTermResults] + "'
AND [REF_NUM] IS NOT NULL
AND dbo.udf_StringToDate([LOG_DATE]) <=
'" + @[User::PriorYearDateResults] + "'
"
|
| ID |
29e5fbd5-26c2-4380-af05-6797a7b6cf29 |
| Raise Changed Event |
False |
Properties
