SQL/refreshLocal.sql at master · ngc2419/SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70


--INSERT INTO [dbo].[delinquency_snapshot]
           ([LOAN NUMBER]
           ,[OLD LOAN NUMBER]
           ,[INVESTOR ID]
           ,[ARM INDICATOR]
           ,[LO TYPE]
           ,[ORIGINAL LO TYPE]
           ,[FIRST PRINCIPAL BALANCE]
           ,[FIRST P AND I AMOUNT]
           ,[SUSPENSE BALANCE]
           ,[LOAN LOSS MIT STATUS CODE]
           ,[MAN CODE]
           ,[MSP DLQ STATUS]
           ,[MTH STATUS NAME]
           ,[NEXT PAYMENT DUE DATE]
           ,[CS BORR ORIG CREDIT QLTY CODE]
           ,[CS BORR CREDIT QUALITY CODE]
           ,[CS BORR CREDIT QUALITY DATE]
           ,[STREAMLINE]
           ,[SOURCE CHANNEL]
           ,[NOTE DATE]
           ,[MONTH FROM ORIGINATION]
           ,[IS COMPARE]
           ,[IS EOM]
           ,[SIXTY]
           ,[NINETY]
           ,[BDE LOAD]
           ,[MSP LOAD]
           ,[LOAN DATE]
           ,[IS_COMPARE_YEAR]
           ,[proper_status]
           ,[owner_name]
           ,[iv_cat_cd])
select  [LOAN NUMBER]
           ,[OLD LOAN NUMBER]
           ,[INVESTOR ID]
           ,[ARM INDICATOR]
           ,[LO TYPE]
           ,[ORIGINAL LO TYPE]
           ,[FIRST PRINCIPAL BALANCE]
           ,[FIRST P AND I AMOUNT]
           ,[SUSPENSE BALANCE]
           ,[LOAN LOSS MIT STATUS CODE]
           ,[MAN CODE]
           ,[MSP DLQ STATUS]
           ,[MTH STATUS NAME]
           ,[NEXT PAYMENT DUE DATE]
           ,[CS BORR ORIG CREDIT QLTY CODE]
           ,[CS BORR CREDIT QUALITY CODE]
           ,[CS BORR CREDIT QUALITY DATE]
           ,[STREAMLINE]
           ,[SOURCE CHANNEL]
           ,[NOTE DATE]
           ,[MONTH FROM ORIGINATION]
           ,[IS COMPARE]
           ,[IS EOM]
           ,[SIXTY]
           ,[NINETY]
           ,[BDE LOAD]
           ,[MSP LOAD]
           ,[LOAN DATE]
           ,[IS_COMPARE_YEAR]
           ,[proper_status]
           ,[owner_name]
           ,[iv_cat_cd]
	   FROM  [10.0.15.10].bdesime.dbo.delinquency_snapshot
WHERE [Loan Date] IN ('11/30/2016','12/31/2016','1/31/2017')