| Value |
 Expression: "DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "' /* Date and Time to validate against RowUpdatedOn in Source Tables */
DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "'
SELECT
CASHIER_SESSION_KEY + RIGHT('00000' + CAST(RECEIPT_SEQ as varchar(5)),5) as StudentReceiptAK
,STUDENT_ID AS StudentIdAK
,CAST(CASE
WHEN ISDATE(StReceipt.ADD_DATE) = 1 THEN StReceipt.ADD_DATE
ELSE '1900-01-01'
END AS DATETIME)
AS DateAK
,CAST(RECEIPT_AMOUNT AS NUMERIC(11,2)) AS ReceiptTotal
,CAST(ISNULL(RECEIPT_AMOUNT,0) AS NUMERIC(11,2)) + CAST(ISNULL(RECEIPT_OTHER_1,0) AS NUMERIC(11,2)) AS ReceiptTotalPlusCoverage
,CAST(RECEIPT_OTHER_2 AS NUMERIC(11,2)) AS ReceiptFeesPaid
,CAST(TOTAL_RECV_PAID AS NUMERIC(11,2)) AS ReceiptReceivablesPaid
,CAST(TOTAL_OBLG_PAID AS NUMERIC(11,2)) AS ReceiptObligationsPaid
FROM AR_RECEIPT_A StReceipt
WHERE (
StReceipt.RowUpdatedOn >= @IncrementalBeginDtTm
A
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
CASHIER_SESSION_KEY + RIGHT('00000' + CAST(RECEIPT_SEQ as varchar(5)),5) as StudentReceiptAK
,STUDENT_ID AS StudentIdAK
,CAST(CASE
WHEN ISDATE(StReceipt.ADD_DATE) = 1 THEN StReceipt.ADD_DATE
ELSE '1900-01-01'
END AS DATETIME)
AS DateAK
,CAST(RECEIPT_AMOUNT AS NUMERIC(11,2)) AS ReceiptTotal
,CAST(ISNULL(RECEIPT_AMOUNT,0) AS NUMERIC(11,2)) + CAST(ISNULL(RECEIPT_OTHER_1,0) AS NUMERIC(11,2)) AS ReceiptTotalPlusCoverage
,CAST(RECEIPT_OTHER_2 AS NUMERIC(11,2)) AS ReceiptFeesPaid
,CAST(TOTAL_RECV_PAID AS NUMERIC(11,2)) AS ReceiptReceivablesPaid
,CAST(TOTAL_OBLG_PAID AS NUMERIC(11,2)) AS ReceiptObligationsPaid
FROM AR_RECEIPT_A StReceipt
WHERE (
StReceipt.RowUpdatedOn >= @IncrementalBeginDtTm
AND StReceipt.RowUpdatedOn <= @IncrementalEndDtTm
AND StReceipt.STUDENT_ID IS NOT NULL AND StReceipt.RECEIPT_STATUS = 'CO'
)
UNION ALL
SELECT
CASHIER_SESSION_KEY + RIGHT('00000' + CAST(RECEIPT_SEQ as varchar(5)),5) as StudentReceiptAK
,CUSTOMER_ID AS StudentIdAK
,CAST(CASE
WHEN ISDATE(CustReceipt.ADD_DATE) = 1 THEN CustReceipt.ADD_DATE
ELSE '1900-01-01'
END AS DATETIME)
AS DateAK
,CAST(RECEIPT_AMOUNT AS NUMERIC(11,2)) AS ReceiptTotal
,CAST(ISNULL(RECEIPT_AMOUNT,0) AS NUMERIC(11,2)) + CAST(ISNULL(RECEIPT_OTHER_1,0) AS NUMERIC(11,2)) AS ReceiptTotalPlusCoverage
,CAST(RECEIPT_OTHER_2 AS NUMERIC(11,2)) AS ReceiptFeesPaid
,CAST(TOTAL_RECV_PAID AS NUMERIC(11,2)) AS ReceiptReceivablesPaid
,CAST(TOTAL_OBLG_PAID AS NUMERIC(11,2)) AS ReceiptObligationsPaid
FROM AR_RECEIPT_A CustReceipt
INNER JOIN ST_STDNT_A Stdnt
ON
(
CustReceipt.CUSTOMER_ID = Stdnt.STUDENT_ID
and
Stdnt.STUDENT_ID IS NOT NULL
)
WHERE (
CustReceipt.RowUpdatedOn >= @IncrementalBeginDtTm
AND CustReceipt.RowUpdatedOn <= @IncrementalEndDtTm
AND CustReceipt.STUDENT_ID IS NULL AND CustReceipt.CUSTOMER_ID IS NOT NULL AND CustReceipt.RECEIPT_STATUS = 'CO'
)
|
| Expression |
"DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "' /* Date and Time to validate against RowUpdatedOn in Source Tables */
DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "'
SELECT
CASHIER_SESSION_KEY + RIGHT('00000' + CAST(RECEIPT_SEQ as varchar(5)),5) as StudentReceiptAK
,STUDENT_ID AS StudentIdAK
,CAST(CASE
WHEN ISDATE(StReceipt.ADD_DATE) = 1 THEN StReceipt.ADD_DATE
ELSE '1900-01-01'
END AS DATETIME)
AS DateAK
,CAST(RECEIPT_AMOUNT AS NUMERIC(11,2)) AS ReceiptTotal
,CAST(ISNULL(RECEIPT_AMOUNT,0) AS NUMERIC(11,2)) + CAST(ISNULL(RECEIPT_OTHER_1,0) AS NUMERIC(11,2)) AS ReceiptTotalPlusCoverage
,CAST(RECEIPT_OTHER_2 AS NUMERIC(11,2)) AS ReceiptFeesPaid
,CAST(TOTAL_RECV_PAID AS NUMERIC(11,2)) AS ReceiptReceivablesPaid
,CAST(TOTAL_OBLG_PAID AS NUMERIC(11,2)) AS ReceiptObligationsPaid
FROM AR_RECEIPT_A StReceipt
WHERE (
StReceipt.RowUpdatedOn >= @IncrementalBeginDtTm
A |
Properties
