0% found this document useful (0 votes)

23 views25 pages

Final SQL Query With Date and Null Check

The document contains SQL case statements that determine final revenue, charges, and indebtedness values based on various date extractions and conditions. It checks for non-null values and compares dates from different sources (CODS, NODS, MDI) to derive the final totals and their sources. The logic ensures that the most recent and relevant data is selected for reporting purposes.

Uploaded by

Aymeric M.

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as TXT, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

23 views25 pages

Final SQL Query With Date and Null Check

Uploaded by

Aymeric M.

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as TXT, PDF, TXT or read online on Scribd

You are on page 1/ 25

,CASE

WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_TOTAL_REVENUES_MONTHLY" IS NOT NULL
THEN TO_NUMBER("CODS_TOTAL_REVENUES_MONTHLY")

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_TOTAL_REVENUES_MONTHLY" IS NOT NULL
THEN TO_NUMBER("NODS_TOTAL_REVENUES_MONTHLY")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_TOTAL_REVENUES_MONTHLY" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_TOTAL_REVENUES_MONTHLY")

ELSE NULL
END AS "FINAL_TOTAL_REVENUES_MONTHLY"

,CASE
WHEN "NODS_TOTAL_REVENUES_MONTHLY" IS NULL AND
"CODS_TOTAL_REVENUES_MONTHLY" IS NULL AND "MDI_FINAL_TOTAL_REVENUES_MONTHLY" IS
NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_TOTAL_REVENUES_MONTHLY" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_TOTAL_REVENUES_MONTHLY" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_TOTAL_REVENUES_MONTHLY" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_TOTAL_REVENUES_MONTHLY"

,CASE
WHEN "NODS_TOTAL_REVENUES_MONTHLY" IS NULL AND
"CODS_TOTAL_REVENUES_MONTHLY" IS NULL AND "MDI_FINAL_TOTAL_REVENUES_MONTHLY" IS
NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_TOTAL_REVENUES_MONTHLY"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_TOTAL_CHARGES_MONTHLY" IS NOT NULL
THEN TO_NUMBER("NODS_TOTAL_CHARGES_MONTHLY")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_TOTAL_CHARGES_MONTHLY" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_TOTAL_CHARGES_MONTHLY")

ELSE NULL
END AS "FINAL_TOTAL_CHARGES_MONTHLY"

,CASE
WHEN "NODS_TOTAL_CHARGES_MONTHLY" IS NULL AND "CODS_TOTAL_CHARGES_MONTHLY"
IS NULL AND "MDI_FINAL_TOTAL_CHARGES_MONTHLY" IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_TOTAL_CHARGES_MONTHLY" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_TOTAL_CHARGES_MONTHLY" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_TOTAL_CHARGES_MONTHLY" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_TOTAL_CHARGES_MONTHLY"

,CASE
WHEN "NODS_TOTAL_CHARGES_MONTHLY" IS NULL AND "CODS_TOTAL_CHARGES_MONTHLY"
IS NULL AND "MDI_FINAL_TOTAL_CHARGES_MONTHLY" IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_TOTAL_CHARGES_MONTHLY"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_TOTAL_INDEBTEDNESS_MONTHLY" IS NOT NULL
THEN TO_NUMBER("NODS_TOTAL_INDEBTEDNESS_MONTHLY")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_TOTAL_INDEBTEDNESS_MONTHLY" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_TOTAL_INDEBTEDNESS_MONTHLY")

ELSE NULL
END AS "FINAL_TOTAL_INDEBTEDNESS_MONTHLY"

,CASE
WHEN "NODS_TOTAL_INDEBTEDNESS_MONTHLY" IS NULL AND
"CODS_TOTAL_INDEBTEDNESS_MONTHLY" IS NULL AND
"MDI_FINAL_TOTAL_INDEBTEDNESS_MONTHLY" IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_TOTAL_INDEBTEDNESS_MONTHLY" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_TOTAL_INDEBTEDNESS_MONTHLY" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_TOTAL_INDEBTEDNESS_MONTHLY" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_TOTAL_INDEBTEDNESS_MONTHLY"

,CASE
WHEN "NODS_TOTAL_INDEBTEDNESS_MONTHLY" IS NULL AND
"CODS_TOTAL_INDEBTEDNESS_MONTHLY" IS NULL AND
"MDI_FINAL_TOTAL_INDEBTEDNESS_MONTHLY" IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_TOTAL_INDEBTEDNESS_MONTHLY"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_EXISTING_DEBT_ON_PROPERTY" IS NOT NULL
THEN TO_NUMBER("NODS_EXISTING_DEBT_ON_PROPERTY")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_EXISTING_DEBT_ON_PROPERTY" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_EXISTING_DEBT_ON_PROPERTY")

ELSE NULL
END AS "FINAL_EXISTING_DEBT_ON_PROPERTY"

,CASE
WHEN "NODS_EXISTING_DEBT_ON_PROPERTY" IS NULL AND
"CODS_EXISTING_DEBT_ON_PROPERTY" IS NULL AND "MDI_FINAL_EXISTING_DEBT_ON_PROPERTY"
IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_EXISTING_DEBT_ON_PROPERTY" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_EXISTING_DEBT_ON_PROPERTY" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_EXISTING_DEBT_ON_PROPERTY" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_EXISTING_DEBT_ON_PROPERTY"

,CASE
WHEN "NODS_EXISTING_DEBT_ON_PROPERTY" IS NULL AND
"CODS_EXISTING_DEBT_ON_PROPERTY" IS NULL AND "MDI_FINAL_EXISTING_DEBT_ON_PROPERTY"
IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_EXISTING_DEBT_ON_PROPERTY"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_REQUESTED_FACILITY_LIMIT" IS NOT NULL
THEN TO_NUMBER("NODS_REQUESTED_FACILITY_LIMIT")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_REQUESTED_FACILITY_LIMIT" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_REQUESTED_FACILITY_LIMIT")

ELSE NULL
END AS "FINAL_REQUESTED_FACILITY_LIMIT"

,CASE
WHEN "NODS_REQUESTED_FACILITY_LIMIT" IS NULL AND
"CODS_REQUESTED_FACILITY_LIMIT" IS NULL AND "MDI_FINAL_REQUESTED_FACILITY_LIMIT" IS
NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_REQUESTED_FACILITY_LIMIT" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_REQUESTED_FACILITY_LIMIT" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_REQUESTED_FACILITY_LIMIT" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_REQUESTED_FACILITY_LIMIT"

,CASE
WHEN "NODS_REQUESTED_FACILITY_LIMIT" IS NULL AND
"CODS_REQUESTED_FACILITY_LIMIT" IS NULL AND "MDI_FINAL_REQUESTED_FACILITY_LIMIT" IS
NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_REQUESTED_FACILITY_LIMIT"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_EXPOSURE_AT_DEFAULT" IS NOT NULL
THEN TO_NUMBER("NODS_EXPOSURE_AT_DEFAULT")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_EXPOSURE_AT_DEFAULT" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_EXPOSURE_AT_DEFAULT")

ELSE NULL
END AS "FINAL_EXPOSURE_AT_DEFAULT"

,CASE
WHEN "NODS_EXPOSURE_AT_DEFAULT" IS NULL AND "CODS_EXPOSURE_AT_DEFAULT" IS
NULL AND "MDI_FINAL_EXPOSURE_AT_DEFAULT" IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_EXPOSURE_AT_DEFAULT" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_EXPOSURE_AT_DEFAULT" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_EXPOSURE_AT_DEFAULT" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_EXPOSURE_AT_DEFAULT"

,CASE
WHEN "NODS_EXPOSURE_AT_DEFAULT" IS NULL AND "CODS_EXPOSURE_AT_DEFAULT" IS
NULL AND "MDI_FINAL_EXPOSURE_AT_DEFAULT" IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_EXPOSURE_AT_DEFAULT"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_COLLATERAL_COVER_VALUE" IS NOT NULL
THEN TO_NUMBER("NODS_COLLATERAL_COVER_VALUE")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_COLLATERAL_COVER_VALUE" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_COLLATERAL_COVER_VALUE")

ELSE NULL
END AS "FINAL_COLLATERAL_COVER_VALUE"

,CASE
WHEN "NODS_COLLATERAL_COVER_VALUE" IS NULL AND
"CODS_COLLATERAL_COVER_VALUE" IS NULL AND "MDI_FINAL_COLLATERAL_COVER_VALUE" IS
NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_COLLATERAL_COVER_VALUE" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_COLLATERAL_COVER_VALUE" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_COLLATERAL_COVER_VALUE" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_COLLATERAL_COVER_VALUE"

,CASE
WHEN "NODS_COLLATERAL_COVER_VALUE" IS NULL AND
"CODS_COLLATERAL_COVER_VALUE" IS NULL AND "MDI_FINAL_COLLATERAL_COVER_VALUE" IS
NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_COLLATERAL_COVER_VALUE"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_IRG_PROBABILITY_OF_DEFAULT" IS NOT NULL
THEN TO_NUMBER("NODS_IRG_PROBABILITY_OF_DEFAULT")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_IRG_PROBABILITY_OF_DEFAULT" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_IRG_PROBABILITY_OF_DEFAULT")

ELSE NULL
END AS "FINAL_IRG_PROBABILITY_OF_DEFAULT"

,CASE
WHEN "NODS_IRG_PROBABILITY_OF_DEFAULT" IS NULL AND
"CODS_IRG_PROBABILITY_OF_DEFAULT" IS NULL AND
"MDI_FINAL_IRG_PROBABILITY_OF_DEFAULT" IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_IRG_PROBABILITY_OF_DEFAULT" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_IRG_PROBABILITY_OF_DEFAULT" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_IRG_PROBABILITY_OF_DEFAULT" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_IRG_PROBABILITY_OF_DEFAULT"
,CASE
WHEN "NODS_IRG_PROBABILITY_OF_DEFAULT" IS NULL AND
"CODS_IRG_PROBABILITY_OF_DEFAULT" IS NULL AND
"MDI_FINAL_IRG_PROBABILITY_OF_DEFAULT" IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_IRG_PROBABILITY_OF_DEFAULT"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_EPC_RATING_CURRENT" IS NOT NULL
THEN TO_NUMBER("NODS_EPC_RATING_CURRENT")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_EPC_RATING_CURRENT" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_EPC_RATING_CURRENT")

ELSE NULL
END AS "FINAL_EPC_RATING_CURRENT"

,CASE
WHEN "NODS_EPC_RATING_CURRENT" IS NULL AND "CODS_EPC_RATING_CURRENT" IS
NULL AND "MDI_FINAL_EPC_RATING_CURRENT" IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_EPC_RATING_CURRENT" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_EPC_RATING_CURRENT" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_EPC_RATING_CURRENT" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_EPC_RATING_CURRENT"

,CASE
WHEN "NODS_EPC_RATING_CURRENT" IS NULL AND "CODS_EPC_RATING_CURRENT" IS
NULL AND "MDI_FINAL_EPC_RATING_CURRENT" IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_EPC_RATING_CURRENT"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_EXCEPTION_TO_POLICY" IS NOT NULL
THEN TO_NUMBER("NODS_EXCEPTION_TO_POLICY")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_EXCEPTION_TO_POLICY" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_EXCEPTION_TO_POLICY")

ELSE NULL
END AS "FINAL_EXCEPTION_TO_POLICY"

,CASE
WHEN "NODS_EXCEPTION_TO_POLICY" IS NULL AND "CODS_EXCEPTION_TO_POLICY" IS
NULL AND "MDI_FINAL_EXCEPTION_TO_POLICY" IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_EXCEPTION_TO_POLICY" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_EXCEPTION_TO_POLICY" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_EXCEPTION_TO_POLICY" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_EXCEPTION_TO_POLICY"

,CASE
WHEN "NODS_EXCEPTION_TO_POLICY" IS NULL AND "CODS_EXCEPTION_TO_POLICY" IS
NULL AND "MDI_FINAL_EXCEPTION_TO_POLICY" IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_EXCEPTION_TO_POLICY"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_TOTAL_DEPENDENT_ADULT" IS NOT NULL
THEN TO_NUMBER("NODS_TOTAL_DEPENDENT_ADULT")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_TOTAL_DEPENDENT_ADULT" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_TOTAL_DEPENDENT_ADULT")

ELSE NULL
END AS "FINAL_TOTAL_DEPENDENT_ADULT"

,CASE
WHEN "NODS_TOTAL_DEPENDENT_ADULT" IS NULL AND "CODS_TOTAL_DEPENDENT_ADULT"
IS NULL AND "MDI_FINAL_TOTAL_DEPENDENT_ADULT" IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_TOTAL_DEPENDENT_ADULT" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_TOTAL_DEPENDENT_ADULT" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_TOTAL_DEPENDENT_ADULT" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_TOTAL_DEPENDENT_ADULT"

,CASE
WHEN "NODS_TOTAL_DEPENDENT_ADULT" IS NULL AND "CODS_TOTAL_DEPENDENT_ADULT"
IS NULL AND "MDI_FINAL_TOTAL_DEPENDENT_ADULT" IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_TOTAL_DEPENDENT_ADULT"

,CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_TOTAL_CHILD_NBR" IS NOT NULL
THEN TO_NUMBER("CODS_TOTAL_CHILD_NBR")
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_TOTAL_CHILD_NBR" IS NOT NULL
THEN TO_NUMBER("NODS_TOTAL_CHILD_NBR")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_TOTAL_CHILD_NBR" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_TOTAL_CHILD_NBR")

ELSE NULL
END AS "FINAL_TOTAL_CHILD_NBR"

,CASE
WHEN "NODS_TOTAL_CHILD_NBR" IS NULL AND "CODS_TOTAL_CHILD_NBR" IS NULL AND
"MDI_FINAL_TOTAL_CHILD_NBR" IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_TOTAL_CHILD_NBR" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_TOTAL_CHILD_NBR" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_TOTAL_CHILD_NBR" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_TOTAL_CHILD_NBR"

,CASE
WHEN "NODS_TOTAL_CHILD_NBR" IS NULL AND "CODS_TOTAL_CHILD_NBR" IS NULL AND
"MDI_FINAL_TOTAL_CHILD_NBR" IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_TOTAL_CHILD_NBR"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_MINIMUM_DISPOSABLE_INCOME" IS NOT NULL
THEN TO_NUMBER("NODS_MINIMUM_DISPOSABLE_INCOME")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_MINIMUM_DISPOSABLE_INCOME" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_MINIMUM_DISPOSABLE_INCOME")

ELSE NULL
END AS "FINAL_MINIMUM_DISPOSABLE_INCOME"

,CASE
WHEN "NODS_MINIMUM_DISPOSABLE_INCOME" IS NULL AND
"CODS_MINIMUM_DISPOSABLE_INCOME" IS NULL AND "MDI_FINAL_MINIMUM_DISPOSABLE_INCOME"
IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_MINIMUM_DISPOSABLE_INCOME" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_MINIMUM_DISPOSABLE_INCOME" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_MINIMUM_DISPOSABLE_INCOME" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_MINIMUM_DISPOSABLE_INCOME"

,CASE
WHEN "NODS_MINIMUM_DISPOSABLE_INCOME" IS NULL AND
"CODS_MINIMUM_DISPOSABLE_INCOME" IS NULL AND "MDI_FINAL_MINIMUM_DISPOSABLE_INCOME"
IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_MINIMUM_DISPOSABLE_INCOME"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_MDI_COVER_RATIO" IS NOT NULL
THEN TO_NUMBER("NODS_MDI_COVER_RATIO")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_MDI_COVER_RATIO" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_MDI_COVER_RATIO")

ELSE NULL
END AS "FINAL_MDI_COVER_RATIO"

,CASE
WHEN "NODS_MDI_COVER_RATIO" IS NULL AND "CODS_MDI_COVER_RATIO" IS NULL AND
"MDI_FINAL_MDI_COVER_RATIO" IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_MDI_COVER_RATIO" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_MDI_COVER_RATIO" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_MDI_COVER_RATIO" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_MDI_COVER_RATIO"

,CASE
WHEN "NODS_MDI_COVER_RATIO" IS NULL AND "CODS_MDI_COVER_RATIO" IS NULL AND
"MDI_FINAL_MDI_COVER_RATIO" IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_MDI_COVER_RATIO"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_DEBT_TO_INCOME" IS NOT NULL
THEN TO_NUMBER("NODS_DEBT_TO_INCOME")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_DEBT_TO_INCOME" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_DEBT_TO_INCOME")

ELSE NULL
END AS "FINAL_DEBT_TO_INCOME"

,CASE
WHEN "NODS_DEBT_TO_INCOME" IS NULL AND "CODS_DEBT_TO_INCOME" IS NULL AND
"MDI_FINAL_DEBT_TO_INCOME" IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_DEBT_TO_INCOME" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_DEBT_TO_INCOME" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_DEBT_TO_INCOME" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_DEBT_TO_INCOME"

,CASE
WHEN "NODS_DEBT_TO_INCOME" IS NULL AND "CODS_DEBT_TO_INCOME" IS NULL AND
"MDI_FINAL_DEBT_TO_INCOME" IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_DEBT_TO_INCOME"

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >= TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-
01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_ETV_CURRENT" IS NOT NULL
THEN TO_NUMBER("NODS_ETV_CURRENT")

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_ETV_CURRENT" IS NOT NULL
THEN TO_NUMBER("MDI_FINAL_ETV_CURRENT")

ELSE NULL
END AS "FINAL_ETV_CURRENT"

,CASE
WHEN "NODS_ETV_CURRENT" IS NULL AND "CODS_ETV_CURRENT" IS NULL AND
"MDI_FINAL_ETV_CURRENT" IS NULL THEN NULL
ELSE
CASE
WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "CODS_ETV_CURRENT" IS NOT NULL
THEN 'CODS'
WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01
00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
AND "NODS_ETV_CURRENT" IS NOT NULL
THEN 'NODS'
WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS
VARCHAR2(19)), '0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS') >=
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01 00:00:00'),
'YYYY-MM-DD HH24:MI:SS')
AND "MDI_FINAL_ETV_CURRENT" IS NOT NULL
THEN 'MDI'
ELSE NULL
END
END AS "FINAL_SOURCE_ETV_CURRENT"

,CASE
WHEN "NODS_ETV_CURRENT" IS NULL AND "CODS_ETV_CURRENT" IS NULL AND
"MDI_FINAL_ETV_CURRENT" IS NULL THEN NULL
ELSE
GREATEST(
TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-
01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS'),
TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)),
'0001-01-01 00:00:00'), 'YYYY-MM-DD HH24:MI:SS')
)
END AS "FINAL_DATE_EXTRACTION_ETV_CURRENT"

Final SQL Query With Explicit Null Check
No ratings yet
Final SQL Query With Explicit Null Check
23 pages
Queryy
No ratings yet
Queryy
2 pages
Final SQL Query With Regexp Check
No ratings yet
Final SQL Query With Regexp Check
27 pages
Final SQL Query With Final Updates
No ratings yet
Final SQL Query With Final Updates
25 pages
Loan Data Extraction Analysis
No ratings yet
Loan Data Extraction Analysis
4 pages
Final SQL Query With Null Date Handling
No ratings yet
Final SQL Query With Null Date Handling
23 pages
Funcao Que Gera o Razao Contabil
No ratings yet
Funcao Que Gera o Razao Contabil
17 pages
Voucher Line Data Processing Query
No ratings yet
Voucher Line Data Processing Query
6 pages
Financial Project Analysis Report
No ratings yet
Financial Project Analysis Report
2 pages
Notes
No ratings yet
Notes
3 pages
SQL For Competency
100% (2)
SQL For Competency
3 pages
Employee Absence Report Query
No ratings yet
Employee Absence Report Query
5 pages
Common Local Tax XFRM Script
No ratings yet
Common Local Tax XFRM Script
5 pages
Exemplo de View
No ratings yet
Exemplo de View
8 pages
ABAP To SQL 1
No ratings yet
ABAP To SQL 1
17 pages
Get Expense Center
No ratings yet
Get Expense Center
1 page
Procedure Query
No ratings yet
Procedure Query
22 pages
Opm Recon
No ratings yet
Opm Recon
30 pages
SQL Queries for Inventory Transactions
No ratings yet
SQL Queries for Inventory Transactions
22 pages
Fail
No ratings yet
Fail
4 pages
Antiguedad de Saldos Query
No ratings yet
Antiguedad de Saldos Query
2 pages
Script
No ratings yet
Script
5 pages
SQL Monitor
No ratings yet
SQL Monitor
11 pages
Query Change
No ratings yet
Query Change
15 pages
Financial Data Query for Analysts
No ratings yet
Financial Data Query for Analysts
9 pages
Customer Daily Status
No ratings yet
Customer Daily Status
6 pages
New 7
No ratings yet
New 7
2 pages
Loan Disbursement & Outstanding Reports
No ratings yet
Loan Disbursement & Outstanding Reports
37 pages
SQL Explain Plan for Invoice Data
No ratings yet
SQL Explain Plan for Invoice Data
15 pages
How Things Work - ISD Development Approach
No ratings yet
How Things Work - ISD Development Approach
7 pages
Users SQL Diag
No ratings yet
Users SQL Diag
4 pages
Zycus Supplier Extract28082024
No ratings yet
Zycus Supplier Extract28082024
4,676 pages
Query Merchandiser
No ratings yet
Query Merchandiser
2 pages
Oracle Superannuation Data Queries
No ratings yet
Oracle Superannuation Data Queries
3 pages
SQL Query
No ratings yet
SQL Query
5 pages
Dbo - Edi Member Elig Ext Hn1 Incr - Storedprocedure
No ratings yet
Dbo - Edi Member Elig Ext Hn1 Incr - Storedprocedure
16 pages
Query Auditorías
No ratings yet
Query Auditorías
11 pages
Goods Revieve Note
No ratings yet
Goods Revieve Note
4 pages
Vendor Spend Report Script Non Po
No ratings yet
Vendor Spend Report Script Non Po
2 pages
Query Oracle 2
No ratings yet
Query Oracle 2
2 pages
Query To Get End Dated Oracle EBS Buyer in System
No ratings yet
Query To Get End Dated Oracle EBS Buyer in System
1 page
Comprehensive Date Management Script
No ratings yet
Comprehensive Date Management Script
7 pages
1
No ratings yet
1
24 pages
ISD Data Synchronization Strategies
No ratings yet
ISD Data Synchronization Strategies
6 pages
AME Tables
No ratings yet
AME Tables
4 pages
Script SQL Server
No ratings yet
Script SQL Server
4 pages
SP ORDER CALC ALL Ag 20231012
No ratings yet
SP ORDER CALC ALL Ag 20231012
16 pages
ASN Appointment
No ratings yet
ASN Appointment
67 pages
SQL Query for Sales Data Analysis
No ratings yet
SQL Query for Sales Data Analysis
2 pages
SQL Financial Data Extraction
No ratings yet
SQL Financial Data Extraction
8 pages
Employee Data Query
No ratings yet
Employee Data Query
2 pages
00 02
No ratings yet
00 02
6 pages
DB Karşılaştırmalı Tarih Fonksiyonları
No ratings yet
DB Karşılaştırmalı Tarih Fonksiyonları
3 pages
Query To Create A Spreadsheet For Loading Into Budget
No ratings yet
Query To Create A Spreadsheet For Loading Into Budget
2 pages
Vendor Spend Report Combined Script
No ratings yet
Vendor Spend Report Combined Script
3 pages
Grade Rate Query for Oracle Fusion
No ratings yet
Grade Rate Query for Oracle Fusion
1 page
GRN Orgi
No ratings yet
GRN Orgi
58 pages
Evandro
No ratings yet
Evandro
3 pages
Thesis Help for Struggling Students
100% (3)
Thesis Help for Struggling Students
7 pages
Biogas & Fertilizer Unit for Farms
No ratings yet
Biogas & Fertilizer Unit for Farms
26 pages
Making Work Visible - Audio Book
No ratings yet
Making Work Visible - Audio Book
56 pages
Eating Disorders in Primary Care
No ratings yet
Eating Disorders in Primary Care
13 pages
Course 1. Psychometrics 2024, 2
No ratings yet
Course 1. Psychometrics 2024, 2
215 pages
Service-Now Implementations Exam Questions
80% (15)
Service-Now Implementations Exam Questions
22 pages
The Legend of Auntie Po
No ratings yet
The Legend of Auntie Po
36 pages
Notes For Japan History
No ratings yet
Notes For Japan History
4 pages
100 Medieval Careers
No ratings yet
100 Medieval Careers
3 pages
8-Channel Relay Controller Guide
100% (1)
8-Channel Relay Controller Guide
4 pages
Signalr Realtime Application Development Einar Ingebrigtsen Instant Download
No ratings yet
Signalr Realtime Application Development Einar Ingebrigtsen Instant Download
50 pages
30 Days of Phrasal Verbs Learning
No ratings yet
30 Days of Phrasal Verbs Learning
71 pages
Buhlmann Catalogue Alloyed Flanges
No ratings yet
Buhlmann Catalogue Alloyed Flanges
39 pages
Update Gemcom Block Model Steps
No ratings yet
Update Gemcom Block Model Steps
63 pages
Data Review Meeting Template - 2018 Final-1
No ratings yet
Data Review Meeting Template - 2018 Final-1
19 pages
DL Throughput Troubleshooting - Lte
No ratings yet
DL Throughput Troubleshooting - Lte
6 pages
S.H.M Conservation Energy
No ratings yet
S.H.M Conservation Energy
2 pages
LRT3 Telecom System Tender Guide
100% (1)
LRT3 Telecom System Tender Guide
2 pages
Customer Relationship Management in
No ratings yet
Customer Relationship Management in
2,889 pages
QAFT 6 Paper 1
No ratings yet
QAFT 6 Paper 1
9 pages
KOREA VISA REQUIREMENTS - Individual
No ratings yet
KOREA VISA REQUIREMENTS - Individual
6 pages
Indian Coal Allocation Scam
No ratings yet
Indian Coal Allocation Scam
8 pages
The Key Difference Between Accounting Vs Engineering Is That Accounting Is The Process of Recording
100% (1)
The Key Difference Between Accounting Vs Engineering Is That Accounting Is The Process of Recording
7 pages
Knockout Fitness 15day BG
No ratings yet
Knockout Fitness 15day BG
49 pages
ELE 412 - EEE 412 Old
No ratings yet
ELE 412 - EEE 412 Old
113 pages
Quiz - 6625 - Cambridge Starters Test 5 - Reading Writing
No ratings yet
Quiz - 6625 - Cambridge Starters Test 5 - Reading Writing
6 pages
Python RegEx Tutorial: Basics & Examples
No ratings yet
Python RegEx Tutorial: Basics & Examples
8 pages
6.3 MTR Specs
No ratings yet
6.3 MTR Specs
2 pages
Trigonometry Problems and Solutions
No ratings yet
Trigonometry Problems and Solutions
71 pages

Final SQL Query With Date and Null Check

Uploaded by

Final SQL Query With Date and Null Check

Uploaded by

,CASE

WHEN TO_DATE(NVL(CAST("CODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

WHEN TO_DATE(NVL(CAST("NODS_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-01-01

WHEN TO_DATE(NVL(CAST("MDI_FINAL_DATE_EXTRACTION" AS VARCHAR2(19)), '0001-

You might also like