| Name |
CheckModsCustCat |
| Value |
 Expression: "DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "' /* Date and Time to validate against RowUpdatedOn in Source Tables */
DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "'SELECT
CAST(CASE
WHEN COUNT(*) > 0 Then 'Y'
ELSE 'N'
END AS char(1)) AS Result FROM UTL_CODE_TABLE UtlCode
WHERE (UtlCode.ISN_UTL_CODE_TABLE) IN
(
/* Select changed records from GL Trans File */
SELECT ISN_UTL_CODE_TABLE
FROM UTL_CODE_TABLE
WHERE (
UTL_CODE_TABLE.RowUpdatedOn >= @IncrementalBeginDtTm
AND UTL_CODE_TABLE.RowUpdatedOn <= @IncrementalEndDtTm
AND UTL_CODE_TABLE.TABLE_NAME = 'DWCUSTTYPE' )
)
"
DECLARE @IncrementalBeginDtTm datetime = 'Jan 1 1900 12:00AM' /* Date and Time to validate against RowUpdatedOn in Source Tables */
DECLARE @IncrementalEndDtTm datetime = 'Mar 4 2016 10:33AM'SELECT
CAST(CASE
WHEN COUNT(*) > 0 Then 'Y'
ELSE 'N'
END AS char(1)) AS Result FROM UTL_CODE_TABLE UtlCode
WHERE (UtlCode.ISN_UTL_CODE_TABLE) IN
(
/* Select changed records from GL Trans File */
SELECT ISN_UTL_CODE_TABLE
FROM UTL_CODE_TABLE
WHERE (
UTL_CODE_TABLE.RowUpdatedOn >= @IncrementalBeginDtTm
AND UTL_CODE_TABLE.RowUpdatedOn <= @IncrementalEndDtTm
AND UTL_CODE_TABLE.TABLE_NAME = 'DWCUSTTYPE' )
)
|
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::CheckModsCustCat |
| Evaluate As Expression |
True |
| Expression |
"DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "' /* Date and Time to validate against RowUpdatedOn in Source Tables */
DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "'SELECT
CAST(CASE
WHEN COUNT(*) > 0 Then 'Y'
ELSE 'N'
END AS char(1)) AS Result FROM UTL_CODE_TABLE UtlCode
WHERE (UtlCode.ISN_UTL_CODE_TABLE) IN
(
/* Select changed records from GL Trans File */
SELECT ISN_UTL_CODE_TABLE
FROM UTL_CODE_TABLE
WHERE (
UTL_CODE_TABLE.RowUpdatedOn >= @IncrementalBeginDtTm
AND UTL_CODE_TABLE.RowUpdatedOn <= @IncrementalEndDtTm
AND UTL_CODE_TABLE.TABLE_NAME = 'DWCUSTTYPE' )
)
"
|
| ID |
f8bc16b4-e1e9-43f7-b339-e75ee950d20b |
| Raise Changed Event |
False |
Properties
