Greetings;

I need to be able to submit a SQL query to generate a list of Constituent Attributes from Raisers Edge.  My first thought was to use the “AttributeTypes” table; however, I cannot seem to figure out how to query it to _only_ give me Constituent attributes, not all attributes.

Basically, I am trying to get a SQL query to duplicate the same results you would get if you where to go into Configuration – Attributes – Constituent and then export the attribute grid.

Thank you.

The field RECORDTYPE determines which kind of records it can attach to.  I don't think there is a translation table.

Drew 

I wasn't able to find a translation table within SQL, but I believe these are the values:

CONSTITUENT = 1
GIFT = 2
ACTION = 3
EDUCATION = 4
SPECIAL_EVENT = 5
PARTICIPANT = 6
CAMPAIGN = 7
APPEAL = 8
FUND = 10
PACKAGE = 11
CONSTIT_ADDRESS = 12
JOB = 13
MEMBERSHIP = 14
INDIVIDUAL_RELATIONSHIP = 15
ORGANIZATION_RELATIONSHIP = 16
FINANCIAL = 17
PROPOSAL = 18

Mitch

Thank you VERY much.  This will do quite nicely.