Other Contact Types

[tkoenitzer]

How do I access the Other's contact type's specific contact type via the database.

Other(Notary)
Other(Tax Collector)


Thanks,
Tim

[brandon.ritchie]

The pfm.Contact table has a field "OtherType" which has this value for other contact types (ContactType=16).

SELECT OtherType, [Name] FROM pfm.Contact WHERE ContactType = 16

[Lisa Ennis]

It is in the pfm.Contact table, the field is OtherType. It is the last field in the Select statement below.

Code: Select all

SELECT 
    C.RootId#,
    C.Id#,
    C.LastId#,
    C.Code,
    C.ContactType,
    C.Name,
    C.NameShort,
    C.OtherType
FROM 
    pfm.[Contact] AS C

Hope this helps!