-------------------
-- app_address : --
-------------------

SELECT Existing_Party_Id as Lead_Id, Address_Type, Number_And_Street, Barangay, NULL AS LandMark, NULL AS Comments,
City, State, Region, Country, Country_Code, Zip_Code, NULL AS Nom_Index, NULL AS Date_Since_Residing,
Is_Preferred_Address, Is_Active, Created_Date, Created_By, 'Y' as Is_Latest_Rec FROM app_address;

---------------------------
-- app_consent_details : --
---------------------------

SELECT Existing_Party_Id as Lead_Id, Consent_Type, NULL AS Consent_Capture_Source, Consent_Channel, NULL AS Status, 
NULL AS Comments, Consent_Details, Created_Date, Created_By, 'Y' as Is_Latest_Rec FROM app_consent_details;

-------------------
-- app_contact : --
-------------------

SELECT Existing_Party_Id as Lead_Id, Contact_Type, Contact_Value, NULL AS Contact_Period, 
Is_Preferred, Is_Active, Created_Date, Created_By, 'Y' as Is_Latest_Rec FROM app_contact;

-----------------------
-- app_kyc_details : --
-----------------------

SELECT Existing_Party_Id as Lead_Id, Document_Id, Document_Type, NULL AS Issuing_Authority, NULL AS Valid_Until, National_Id,
Is_Active, CreatedDate AS Created_Date, CreatedBy AS Created_By, 'Y' as Is_Latest_Rec FROM app_kyc_details;

----------------------
-- app_occupation : --
----------------------

SELECT Existing_Party_Id as Lead_Id, Nature_Of_Occupation, Nature_Of_Occupation_Code, Organization, Industry_Type, 
Industry_Type_Code, Occupation_Type, Occupation_Type_Code, Occupation_Status, Occupation_Status_Code, NULL AS Date_Of_Commencement,
Monthly_Income, Annual_Income, Fund_Source_Name, Fund_Source_Code, Source_Of_Wealth, Proof_Of_SOW, Party_Linked_Companies,
Party_Banks, NULL AS Proof_Of_Address, NULL AS Proof_Of_Income, Salary_Period, Salary_Dates, NULL AS Proof_Of_Billing,
Profession, Is_Active, Created_Date, Created_By, 'Y' as Is_Latest_Rec FROM app_occupation;

----------------
-- app_lead : --
----------------

SELECT Application_Id, NULL AS CW_Transaction_Id, Existing_Party_Id as Lead_Id, First_Name, Last_Name, Middle_Name, 
DOB, Gender, Salutation, Suffix, Civil_Status, Place_Of_Birth, Nationality, No_Of_Dependents, Arn_No, Idm_Arn_No, 
Party_Status, NULL AS Is_DOSRI, NULL AS Is_RPT, NULL AS Is_FATCA, Party_Type, NULL AS Preferred_Address_Id,
NULL AS fatca_W9_IdType, NULL AS fatca_W9_IdNumber, NULL AS App_Product_Type, NULL AS App_Party_Type,
NULL AS Source, NULL AS Channel, NULL AS Channel_Type, NULL AS Product_Type, NULL AS sssGsis, NULL AS tinId,
NULL AS Is_Record_Edited, Is_Active, Created_Date, Created_By, Updated_Date, Updated_By, 
'Y' as Is_Latest_Rec, NULL AS External_application_id FROM app_party AS app_lead;

-----------------------
-- app_lead_status : --
-----------------------

SELECT Existing_Party_Id as Lead_Id, Status_Type, Status_Flag, Created_Date, Created_By, NULL AS CBS_party_id,
'Y' as Is_Latest_Rec FROM app_party_status AS app_lead_status;

------------------------
-- app_relationship : --
------------------------

SELECT Existing_Party_Id as Lead_Id, Relationship_Type, Name, Nationality, DOB, NULL AS Address, 
Share_Percentage, Is_Nominee, NULL AS Nominee_Index, Created_Date, Created_By, 
'Y' as Is_Latest_Rec FROM app_relationship;