| Name |
GetMergedStudents |
| Value |
 Expression: "
/* SELECT Students who have been Merged for Delete Processing */
SELECT prev.PREV_STDNT_ID AS OLD_ID
,stdnt.STUDENT_ID AS NEW_ID
FROM [dbo].[ST_STDNT_A_PREV_STDNT_ID_USED] prev
/* Get Student Information */
LEFT OUTER JOIN [dbo].[ST_STDNT_A] stdnt
ON (
stdnt.ISN_ST_STDNT_A = prev.ISN_ST_STDNT_A
)
/* Get Old Student Information */
LEFT OUTER JOIN [dbo].[ST_STDNT_A] oldstdnt
ON (
prev.PREV_STDNT_ID = oldstdnt.STUDENT_ID
)
/* Where the student-id was changed within the begin and end date range
and the OLD student does not still exist on ST_STDNT_A */
WHERE (
cast(prev.[CHG_ID_DATE] as date) >= cast('" + @[User::IncrementalBeginDtTm] + "' as date)
AND
cast(prev.[CHG_ID_DATE] as date) <= cast('" + @[User::IncrementalEndDtTm] + "' as date)
)
AND
(
oldstdnt.STUDENT_ID IS NULL
)
"
/* SELECT Students who have been Merged for Delete Processing */
SELECT prev.PREV_STDNT_ID AS OLD_ID
,stdnt.STUDENT_ID AS NEW_ID
FROM [dbo].[ST_STDNT_A_PREV_STDNT_ID_USED] prev
/* Get Student Information */
LEFT OUTER JOIN [dbo].[ST_STDNT_A] stdnt
ON (
stdnt.ISN_ST_STDNT_A = prev.ISN_ST_STDNT_A
)
/* Get Old Student Information */
LEFT OUTER JOIN [dbo].[ST_STDNT_A] oldstdnt
ON (
prev.PREV_STDNT_ID = oldstdnt.STUDENT_ID
)
/* Where the student-id was changed within the begin and end date range
and the OLD student does not still exist on ST_STDNT_A */
WHERE (
cast(prev.[CHG_ID_DATE] as date) >= cast('Jan 1 1900 12:00AM' as date)
AND
cast(prev.[CHG_ID_DATE] as date) <= cast('Mar 4 2016 10:33AM' as date)
)
AND
(
oldstdnt.STUDENT_ID IS NULL
)
|
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::GetMergedStudents |
| Evaluate As Expression |
True |
| Expression |
"
/* SELECT Students who have been Merged for Delete Processing */
SELECT prev.PREV_STDNT_ID AS OLD_ID
,stdnt.STUDENT_ID AS NEW_ID
FROM [dbo].[ST_STDNT_A_PREV_STDNT_ID_USED] prev
/* Get Student Information */
LEFT OUTER JOIN [dbo].[ST_STDNT_A] stdnt
ON (
stdnt.ISN_ST_STDNT_A = prev.ISN_ST_STDNT_A
)
/* Get Old Student Information */
LEFT OUTER JOIN [dbo].[ST_STDNT_A] oldstdnt
ON (
prev.PREV_STDNT_ID = oldstdnt.STUDENT_ID
)
/* Where the student-id was changed within the begin and end date range
and the OLD student does not still exist on ST_STDNT_A */
WHERE (
cast(prev.[CHG_ID_DATE] as date) >= cast('" + @[User::IncrementalBeginDtTm] + "' as date)
AND
cast(prev.[CHG_ID_DATE] as date) <= cast('" + @[User::IncrementalEndDtTm] + "' as date)
)
AND
(
oldstdnt.STUDENT_ID IS NULL
)
"
|
| ID |
c8e69f9e-d482-4b0e-b2c7-6fe1c69b2366 |
| Raise Changed Event |
False |
Properties
