Understood..here are my load statements for the 3 tables in question...
CHARGEOFFS:
LOAD
CASEID,
CHARGEOFFAMOUNT,
CHARGEOFFDATE,
CHARGEOFFGL,
CHARGEOFFSETRU,
INCIDENTCOUNTERID,
LOCATIONID,
STARTDATE,
CATEGORYID,
Month(CHARGEOFFDATE) as ChargeOffMonth,
Date(CHARGEOFFDATE,'MMM-YYYY') as ChargeOffMonthDate,
Date (monthstart (CHARGEOFFDATE) , 'MMM_YYYY') as ChargeOffMonthYear;
SQL SELECT
CASEID,
CHARGEOFFAMOUNT,
CHARGEOFFDATE,
CHARGEOFFGL,
CHARGEOFFSETRU,
INCIDENTCOUNTERID,
LOCATIONID,
STARTDATE,
CATEGORYID
FROM ICMSCITRIX.dbo.TBLINCIDENT
WHERE CHARGEOFFDATE >= '1/1/2012'
AND CHARGEOFFDATE <= '12/31/2012'
AND CHARGEOFFGL IN (860360, 980360, 990360, 970360, 860500);
RECOVERY:
LOAD CASEID,
DATEOFRECOVERY,
ITEMIZEDRECOVERYGL,
ITEMIZEDRECOVERYLOSSLOCATION,
TOTALRECOVERY,
Month(DATEOFRECOVERY) as RecoveryMonth,
Date (monthstart (DATEOFRECOVERY) , 'MMM_YYYY') as RecoveryMonthYear;
SQL SELECT CASEID,
DATEOFRECOVERY,
ITEMIZEDRECOVERYGL,
ITEMIZEDRECOVERYLOSSLOCATION,
TOTALRECOVERY
FROM ICMSCITRIX.dbo.TBLITEMIZEDRECOVERY
WHERE DATEOFRECOVERY >= '1/1/2012'
AND DATEOFRECOVERY <= '06/28/2012'
AND ITEMIZEDRECOVERYGL IN (860360, 980360, 990360, 970360, 860500);
PAYMENTS:
LOAD
CASEID,
INVESTIGATORID,
PAYMENTAMOUNT,
PAYMENTDATE,
Month(PAYMENTDATE) as PaymentMonth,
Date(PAYMENTDATE,'MMM-YYYY') as PaymentMonthDate,
Date (monthstart (PAYMENTDATE) , 'MMM_YYYY') as PaymentMonthYear;
SQL SELECT
CASEID,
INVESTIGATORID,
PAYMENTAMOUNT,
PAYMENTDATE
FROM ICMSCITRIX.dbo.TBLRECOVERYPAYMENT
WHERE PAYMENTDATE >= '1/1/2012'
AND PAYMENTDATE <= '12/31/2012';
)
