SELECT
    [COUNTER_PARTY_ID] AS 'counter_party_id'
    ,HC.[SNAPSHOT_DATE] AS 'snapshot_date'
    ,HC.[ENTITY] AS 'entity'
    ,HC.[ORIGIN_CONTRACTID] AS 'origin_contractid'
    ,HC.[ORIGIN_COUNTER_PARTYDID] AS 'origin_counter_partydid'
    ,HC.[ORIGIN_SYSTEMID] AS 'origin_systemid'
    ,[PRODUCT_TYPE] AS 'product_type'
    ,[PRODUCT_SUBTYPE] AS 'product_subtype'
    ,[BUSINESS_UNIT] AS 'business_unit'
    ,[SEGMENT] AS 'segment'
    ,HC.[CURRENCY] AS 'currency'
    ,[MATURITY_DATE] AS 'maturity_date'
    ,[OBSERVATION_DATE] AS 'observation_date'
    ,[OUTSTANDING_AMT] AS 'outstanding_amt'
    ,[COLLECTIBILITY] AS 'collectibility'
    ,[DYS_PAST_DUE] AS 'dys_past_due'
    ,[DISCOUNT_RATE]/100 AS 'discount_rate'
    ,[DP_IND] AS 'dp_ind'
    ,[CDD_IND] AS 'cdd_ind'
    ,[IS_REPO] AS 'is_repo'
    ,CASE WHEN [IS_REPO] = 1 THEN 'true' ELSE 'false' END AS 'is_defaulted'
    ,HC.[FLAG_JF] AS 'flag_jf'
    ,HC.[BANK_JF] AS 'bank_jf'
    ,HR.[RECOVERY_AMT] AS 'recovery_amt'
    ,HR.[RECOVERY_DATE] AS 'recovery_date'
FROM [PSAK71_STG].[dbo].[PSAK_HISTORICAL_CONTRACT] HC
LEFT JOIN [PSAK71_STG].[dbo].[PSAK_HISTORICAL_RECOVERIES] HR
ON HC.[ORIGIN_CONTRACTID] = HR.[ORIGIN_CONTRACTID] AND HC.[SNAPSHOT_DATE] = HR.[SNAPSHOT_DATE]
WHERE 1=1
    AND HC.[SNAPSHOT_DATE] = @ReportingDate