cust_CCIW_v_person_attribute

/*
Attribute type values
0=Int
1=String
2=DateTime
3=Lookup
4=YesNo
5=Decimal
6=Currency
7=Url
8=Guid
9=Document
*/

CREATE VIEW [dbo].[cust_CCIW_v_person_attribute]
AS
SELECT CASE a.attribute_type
        WHEN 1
            THEN varchar_value
        WHEN 2
            THEN CONVERT(VARCHAR(10), datetime_value, 101)
        WHEN 3
            THEN (
                    SELECT l.lookup_value
                    FROM core_lookup l
                    WHERE l.lookup_id = pa.int_value
                    )
        WHEN 4
            THEN CASE int_value
                    WHEN 1
                        THEN 'Yes'
                    ELSE 'No'
                    END
        WHEN 5
            THEN CAST(decimal_value AS VARCHAR)
        WHEN 6
            THEN CAST(decimal_value AS VARCHAR)
        WHEN 7
            THEN varchar_value
        WHEN 8
            THEN varchar_value
        END AS attribute_value
    ,a.attribute_id
    ,a.attribute_group_id
    ,a.attribute_name
    ,a.attribute_type
    ,pa.person_id
    ,pa.int_value
    ,pa.varchar_value
    ,pa.datetime_value
    ,pa.decimal_value
    ,pa.date_created
    ,pa.date_modified
    ,pa.created_by
    ,pa.modified_by
    ,pa.organization_id
FROM dbo.core_attribute AS a
INNER JOIN dbo.core_person_attribute AS pa ON a.attribute_id = pa.attribute_id
    AND a.organization_id = pa.organization_id