| Value |
 Expression: "DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "' /* Date and Time to validate against RowUpdatedOn in Source Tables */
DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "'
SELECT
CAST(Coa.FISCAL_YEAR + Coa.GL_ACCT_NO as varchar(29)) as YearGlAccountNumberAK
,CAST(
CASE
WHEN SUBSTRING(Coa.GL_ACCT_NO,22,4) = ' ' THEN SUBSTRING(Coa.GL_ACCT_NO,1,8) + '-' +
SUBSTRING(Coa.GL_ACCT_NO,9,6) + '-' + SUBSTRING(Coa.GL_ACCT_NO,15,2) + '-' +
SUBSTRING(Coa.GL_ACCT_NO,17,5)
WHEN SUBSTRING(Coa.GL_ACCT_NO,22,4) <> ' ' THEN SUBSTRING(Coa.GL_ACCT_NO,1,8) + '-' +
SUBSTRING(Coa.GL_ACCT_NO,9,6) + '-' + SUBSTRING(Coa.GL_ACCT_NO,15,2) + '-' +
SUBSTRING(Coa.GL_ACCT_NO,17,5) + '-' + SUBSTRING(Coa.GL_ACCT_NO,22,4)
END AS VARCHAR) as GlAccountNumber
,Coa.FISCAL_YEAR as FiscalYear
,ISNULL(Coa.ACTIVE_IND, 'N/A') as Ac
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(Coa.FISCAL_YEAR + Coa.GL_ACCT_NO as varchar(29)) as YearGlAccountNumberAK
,CAST(
CASE
WHEN SUBSTRING(Coa.GL_ACCT_NO,22,4) = ' ' THEN SUBSTRING(Coa.GL_ACCT_NO,1,8) + '-' +
SUBSTRING(Coa.GL_ACCT_NO,9,6) + '-' + SUBSTRING(Coa.GL_ACCT_NO,15,2) + '-' +
SUBSTRING(Coa.GL_ACCT_NO,17,5)
WHEN SUBSTRING(Coa.GL_ACCT_NO,22,4) <> ' ' THEN SUBSTRING(Coa.GL_ACCT_NO,1,8) + '-' +
SUBSTRING(Coa.GL_ACCT_NO,9,6) + '-' + SUBSTRING(Coa.GL_ACCT_NO,15,2) + '-' +
SUBSTRING(Coa.GL_ACCT_NO,17,5) + '-' + SUBSTRING(Coa.GL_ACCT_NO,22,4)
END AS VARCHAR) as GlAccountNumber
,Coa.FISCAL_YEAR as FiscalYear
,ISNULL(Coa.ACTIVE_IND, 'N/A') as AccountStatusCode
,CASE
WHEN Coa.ACTIVE_IND = 'A' THEN 'Active'
WHEN Coa.ACTIVE_IND = 'I' THEN 'In-Active'
WHEN Coa.ACTIVE_IND = 'S' THEN 'Summary'
ELSE 'N/A'
END AS AccountStatus
,CAST(ISNULL(Coa.START_DATE, '1900-01-01') as datetime) AS StartDate
,CAST(ISNULL(Coa.END_DATE, '2098-06-30') as datetime) AS EndDate
,CASE
WHEN Coa.COA_BUDGETED_ACCT_IND = 'Y' THEN 'Yes'
ELSE 'No'
END AS IsAccountBudgeted
,ISNULL(Coa.COA_BUDGET_POOL_NO, 'N/A') as BudgetPoolNo
FROM COA_ORG_UNIT_FILE Coa
WHERE (CAST(Coa.FISCAL_YEAR + Coa.GL_ACCT_NO as varchar(29))) IN
(
/* Select changed records from Student File */
SELECT CAST(FISCAL_YEAR + GL_ACCT_NO as varchar(29))
FROM COA_ORG_UNIT_FILE
WHERE (
COA_ORG_UNIT_FILE.RowUpdatedOn >= @IncrementalBeginDtTm
AND COA_ORG_UNIT_FILE.RowUpdatedOn <= @IncrementalEndDtTm
AND COA_IND = 'Y'
)
)
|
| Expression |
"DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "' /* Date and Time to validate against RowUpdatedOn in Source Tables */
DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "'
SELECT
CAST(Coa.FISCAL_YEAR + Coa.GL_ACCT_NO as varchar(29)) as YearGlAccountNumberAK
,CAST(
CASE
WHEN SUBSTRING(Coa.GL_ACCT_NO,22,4) = ' ' THEN SUBSTRING(Coa.GL_ACCT_NO,1,8) + '-' +
SUBSTRING(Coa.GL_ACCT_NO,9,6) + '-' + SUBSTRING(Coa.GL_ACCT_NO,15,2) + '-' +
SUBSTRING(Coa.GL_ACCT_NO,17,5)
WHEN SUBSTRING(Coa.GL_ACCT_NO,22,4) <> ' ' THEN SUBSTRING(Coa.GL_ACCT_NO,1,8) + '-' +
SUBSTRING(Coa.GL_ACCT_NO,9,6) + '-' + SUBSTRING(Coa.GL_ACCT_NO,15,2) + '-' +
SUBSTRING(Coa.GL_ACCT_NO,17,5) + '-' + SUBSTRING(Coa.GL_ACCT_NO,22,4)
END AS VARCHAR) as GlAccountNumber
,Coa.FISCAL_YEAR as FiscalYear
,ISNULL(Coa.ACTIVE_IND, 'N/A') as Ac |
Properties
