Stores constituent batch information.
Foreign Key Fields
| Foreign Key |
Field Type |
Null |
Notes |
Description |
|
BATCHID
|
uniqueidentifier
|
false
|
|
FK to BATCH
|
|
TITLECODEID
|
uniqueidentifier
|
true
|
|
FK to TITLECODE
|
|
SUFFIXCODEID
|
uniqueidentifier
|
true
|
|
FK to SUFFIXCODE
|
|
INDUSTRYCODEID
|
uniqueidentifier
|
true
|
|
FK to INDUSTRYCODE
|
|
PARENTCORPID
|
uniqueidentifier
|
true
|
|
FK to CONSTITUENT
|
|
ADDRESS_ADDRESSTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to ADDRESSTYPECODE
|
|
ADDRESS_COUNTRYID
|
uniqueidentifier
|
true
|
|
FK to COUNTRY
|
|
ADDRESS_STATEID
|
uniqueidentifier
|
true
|
|
FK to STATE
|
|
EMAILADDRESS_EMAILADDRESSTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to EMAILADDRESSTYPECODE
|
|
ADDEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
CHANGEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
PRIMARYADDRESSEE_NAMEFORMATTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to NAMEFORMATTYPECODE
|
|
PRIMARYADDRESSEE_NAMEFORMATFUNCTIONID
|
uniqueidentifier
|
true
|
|
FK to NAMEFORMATFUNCTION
|
|
PRIMARYSALUTATION_NAMEFORMATTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to NAMEFORMATTYPECODE
|
|
PRIMARYSALUTATION_NAMEFORMATFUNCTIONID
|
uniqueidentifier
|
true
|
|
FK to NAMEFORMATFUNCTION
|
|
EDUCATIONALHISTORY_EDUCATIONALINSTITUTIONID
|
uniqueidentifier
|
true
|
|
FK to EDUCATIONALINSTITUTION
|
|
EDUCATIONALHISTORY_EDUCATIONALHISTORYTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to EDUCATIONALHISTORYTYPECODE
|
|
EDUCATIONALHISTORY_EDUCATIONALHISTORYSTATUSCODEID
|
uniqueidentifier
|
true
|
|
FK to EDUCATIONALHISTORYSTATUSCODE
|
|
EDUCATIONALHISTORY_EDUCATIONALDEGREECODEID
|
uniqueidentifier
|
true
|
|
FK to EDUCATIONALDEGREECODE
|
|
SPOUSEID
|
uniqueidentifier
|
true
|
|
FK to CONSTITUENT
|
|
SPOUSE_RELATIONSHIPTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to RELATIONSHIPTYPECODE
|
|
SPOUSE_RECIPROCALTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to RELATIONSHIPTYPECODE
|
|
SPOUSE_TITLECODEID
|
uniqueidentifier
|
true
|
|
FK to TITLECODE
|
|
SPOUSE_SUFFIXCODEID
|
uniqueidentifier
|
true
|
|
FK to SUFFIXCODE
|
|
SPOUSE_EMAILADDRESS_EMAILADDRESSTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to EMAILADDRESSTYPECODE
|
|
PRIMARYBUSINESSID
|
uniqueidentifier
|
true
|
|
FK to CONSTITUENT
|
|
PRIMARYBUSINESS_RELATIONSHIPTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to RELATIONSHIPTYPECODE
|
|
PRIMARYBUSINESS_RECIPROCALTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to RELATIONSHIPTYPECODE
|
|
PRIMARYBUSINESS_PHONE_PHONETYPECODEID
|
uniqueidentifier
|
true
|
|
FK to PHONETYPECODE
|
|
PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESSTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to EMAILADDRESSTYPECODE
|
|
PRIMARYBUSINESS_ADDRESS_ADDRESSTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to ADDRESSTYPECODE
|
|
PRIMARYBUSINESS_ADDRESS_COUNTRYID
|
uniqueidentifier
|
true
|
|
FK to COUNTRY
|
|
PRIMARYBUSINESS_ADDRESS_STATEID
|
uniqueidentifier
|
true
|
|
FK to STATE
|
|
PRIMARYBUSINESS_INDUSTRYCODEID
|
uniqueidentifier
|
true
|
|
FK to INDUSTRYCODE
|
|
PRIMARYBUSINESS_PARENTCORPID
|
uniqueidentifier
|
true
|
|
FK to CONSTITUENT
|
|
CONSTIT_SECURITY_ATTRIBUTEID
|
uniqueidentifier
|
true
|
|
The ID of the constituent security attribute that is assigned.
|
|
GROUPTYPEID
|
uniqueidentifier
|
true
|
|
FK to GROUPTYPE
|
|
ADDRESS_COUNTYCODEID
|
uniqueidentifier
|
true
|
|
FK to COUNTYCODE
|
|
ADDRESS_CONGRESSIONALDISTRICTCODEID
|
uniqueidentifier
|
true
|
|
FK to CONGRESSIONALDISTRICTCODE
|
|
ADDRESS_STATEHOUSEDISTRICTCODEID
|
uniqueidentifier
|
true
|
|
FK to STATEHOUSEDISTRICTCODE
|
|
ADDRESS_STATESENATEDISTRICTCODEID
|
uniqueidentifier
|
true
|
|
FK to STATESENATEDISTRICTCODE
|
|
ADDRESS_LOCALPRECINCTCODEID
|
uniqueidentifier
|
true
|
|
FK to LOCALPRECINCTCODE
|
|
ADDRESS_INFOSOURCECODEID
|
uniqueidentifier
|
true
|
|
FK to INFOSOURCECODE
|
|
ADDRESS_REGIONCODEID
|
uniqueidentifier
|
true
|
|
FK to REGIONCODE
|
|
PRIMARYBUSINESS_ADDRESS_DONOTMAILREASONCODEID
|
uniqueidentifier
|
true
|
|
FK to DONOTMAILREASONCODE
|
|
ADDRESS_DONOTMAILREASONCODEID
|
uniqueidentifier
|
true
|
|
FK to DONOTMAILREASONCODE
|
|
EDUCATIONALHISTORY_ACADEMICCATALOGPROGRAMID
|
uniqueidentifier
|
true
|
|
FK to ACADEMICCATALOGPROGRAM
|
|
EDUCATIONALHISTORY_EDUCATIONALPROGRAMCODEID
|
uniqueidentifier
|
true
|
|
FK to EDUCATIONALPROGRAMCODE
|
|
EDUCATIONALHISTORY_ACADEMICCATALOGDEGREEID
|
uniqueidentifier
|
true
|
|
FK to ACADEMICCATALOGDEGREE
|
|
EDUCATIONALHISTORY_EDUCATIONALAWARDCODEID
|
uniqueidentifier
|
true
|
|
FK to EDUCATIONALAWARDCODE
|
|
EDUCATIONALHISTORY_EDUCATIONALSOURCECODEID
|
uniqueidentifier
|
true
|
|
FK to EDUCATIONALSOURCECODE
|
|
EDUCATIONALHISTORY_LEVELCODEID
|
uniqueidentifier
|
true
|
|
FK to EDUCATIONALHISTORYLEVELCODE
|
|
EDUCATIONALHISTORY_REASONCODEID
|
uniqueidentifier
|
true
|
|
FK to EDUCATIONALHISTORYREASONCODE
|
|
CONSTITUENT_SITEID
|
uniqueidentifier
|
true
|
|
The ID of the constituent site that is assigned.
|
|
PRIMARYBUSINESS_JOBCATEGORYCODEID
|
uniqueidentifier
|
true
|
|
Stores the category of the job for the primary business relationship
|
|
PRIMARYBUSINESS_CAREERLEVELCODEID
|
uniqueidentifier
|
true
|
|
Stores the career level of the job for the primary business relationship
|
|
PRIMARYBUSINESS_ADDRESS_INFOSOURCECODEID
|
uniqueidentifier
|
true
|
|
FK to INFOSOURCECODE
|
|
TITLE2CODEID
|
uniqueidentifier
|
true
|
|
FK to TITLECODE
|
|
SUFFIX2CODEID
|
uniqueidentifier
|
true
|
|
FK to SUFFIXCODE
|
|
SPOUSE_TITLE2CODEID
|
uniqueidentifier
|
true
|
|
FK to TITLECODE
|
|
SPOUSE_SUFFIX2CODEID
|
uniqueidentifier
|
true
|
|
FK to SUFFIXCODE
|
|
PRIMARYBUSINESS_JOBSCHEDULECODEID
|
uniqueidentifier
|
true
|
|
Stores the schedule of the job for this relationship
|
|
ETHNICITYCODEID
|
uniqueidentifier
|
true
|
|
FK to ETHNICITYCODE
|
|
RELIGIONCODEID
|
uniqueidentifier
|
true
|
|
FK to RELIGIONCODE
|
|
TARGETCODEID
|
uniqueidentifier
|
true
|
|
FK to TARGETCODE
|
|
INCOMECODEID
|
uniqueidentifier
|
true
|
|
FK to INCOMECODE
|
|
PRIMARYBUSINESS_PHONE_COUNTRYID
|
uniqueidentifier
|
true
|
|
FK to COUNTRY
|
|
PRIMARYBUSINESS_PRIMARYRECOGNITIONTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to REVENUERECOGNITIONTYPECODE
|
|
PRIMARYBUSINESS_RECIPROCALRECOGNITIONTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to REVENUERECOGNITIONTYPECODE
|
|
SPOUSE_PRIMARYRECOGNITIONTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to REVENUERECOGNITIONTYPECODE
|
|
SPOUSE_RECIPROCALRECOGNITIONTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to REVENUERECOGNITIONTYPECODE
|
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
KEYNAME
|
nvarchar(100)
|
false
|
|
|
|
FIRSTNAME
|
nvarchar(50)
|
false
|
|
|
|
MIDDLENAME
|
nvarchar(50)
|
false
|
|
|
|
MAIDENNAME
|
nvarchar(100)
|
false
|
|
|
|
NICKNAME
|
nvarchar(50)
|
false
|
|
|
|
BIRTHDATE
|
UDT_FUZZYDATE
|
false
|
|
|
|
GENDERCODE
|
tinyint
|
false
|
|
0=Unknown, 1=Male, 2=Female
|
|
WEBADDRESS
|
UDT_WEBADDRESS
|
false
|
|
|
|
ISORGANIZATION
|
bit
|
false
|
|
|
|
NUMEMPLOYEES
|
int
|
false
|
|
|
|
NUMSUBSIDIARIES
|
int
|
false
|
|
|
|
ADDRESS_ADDRESSBLOCK
|
nvarchar(150)
|
false
|
|
|
|
ADDRESS_CITY
|
nvarchar(50)
|
false
|
|
|
|
ADDRESS_POSTCODE
|
nvarchar(12)
|
false
|
|
|
|
ADDRESS_DONOTMAIL
|
bit
|
false
|
|
|
|
EMAILADDRESS_EMAILADDRESS
|
UDT_EMAILADDRESS
|
false
|
|
|
|
SEQUENCE
|
int
|
false
|
|
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
CUSTOMIDENTIFIER
|
nvarchar(100)
|
false
|
|
User-definable custom identifier.
|
|
SEQUENCEID
|
int
|
false
|
|
Identity column used to increment the default lookupid.
|
|
CUSTOMID
|
nvarchar(100)
|
false
|
|
|
|
ADDRESS_CART
|
nvarchar(10)
|
false
|
|
|
|
ADDRESS_DPC
|
nvarchar(8)
|
false
|
|
|
|
ADDRESS_LOT
|
nvarchar(5)
|
false
|
|
|
|
ADDRESS_STARTDATE
|
UDT_MONTHDAY
|
false
|
|
|
|
ADDRESS_ENDDATE
|
UDT_MONTHDAY
|
false
|
|
|
|
ISDECEASED
|
bit
|
false
|
|
|
|
DECEASEDDATE
|
UDT_FUZZYDATE
|
false
|
|
|
|
EDUCATIONALHISTORY_ISPRIMARYRECORD
|
bit
|
false
|
|
|
|
EDUCATIONALHISTORY_CONSTITUENCYSTATUSCODE
|
tinyint
|
false
|
|
0=Unknown, 1=Currently Attending, 2=Incomplete, 3=Graduated
|
|
EDUCATIONALHISTORY_CLASSOF
|
UDT_YEAR
|
false
|
|
|
|
EDUCATIONALHISTORY_GPA
|
decimal(3, 2)
|
false
|
|
|
|
EDUCATIONALHISTORY_STARTDATE
|
UDT_FUZZYDATE
|
false
|
|
|
|
EDUCATIONALHISTORY_ENDDATE
|
UDT_FUZZYDATE
|
false
|
|
|
|
EDUCATIONALHISTORY_KNOWNNAME
|
nvarchar(50)
|
false
|
|
|
|
EDUCATIONALHISTORY_FRATERNITY
|
nvarchar(50)
|
false
|
|
|
|
SPOUSE_KEYNAME
|
nvarchar(100)
|
false
|
|
|
|
SPOUSE_FIRSTNAME
|
nvarchar(50)
|
false
|
|
|
|
SPOUSE_MIDDLENAME
|
nvarchar(50)
|
false
|
|
|
|
SPOUSE_MAIDENNAME
|
nvarchar(100)
|
false
|
|
|
|
SPOUSE_NICKNAME
|
nvarchar(50)
|
false
|
|
|
|
SPOUSE_GENDERCODE
|
tinyint
|
false
|
|
0=Unknown, 1=Male, 2=Female
|
|
SPOUSE_BIRTHDATE
|
UDT_FUZZYDATE
|
false
|
|
|
|
SPOUSE_EMAILADDRESS_EMAILADDRESS
|
UDT_EMAILADDRESS
|
false
|
|
|
|
PRIMARYBUSINESS_KEYNAME
|
nvarchar(100)
|
false
|
|
|
|
PRIMARYBUSINESS_PHONE_NUMBER
|
nvarchar(100)
|
false
|
|
|
|
PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESS
|
UDT_EMAILADDRESS
|
false
|
|
|
|
PRIMARYBUSINESS_ADDRESS_ADDRESSBLOCK
|
nvarchar(150)
|
false
|
|
|
|
PRIMARYBUSINESS_ADDRESS_CITY
|
nvarchar(50)
|
false
|
|
|
|
PRIMARYBUSINESS_ADDRESS_POSTCODE
|
nvarchar(12)
|
false
|
|
|
|
PRIMARYBUSINESS_ADDRESS_CART
|
nvarchar(10)
|
false
|
|
|
|
PRIMARYBUSINESS_ADDRESS_DPC
|
nvarchar(8)
|
false
|
|
|
|
PRIMARYBUSINESS_ADDRESS_LOT
|
nvarchar(5)
|
false
|
|
|
|
PRIMARYBUSINESS_ADDRESS_DONOTMAIL
|
bit
|
false
|
|
|
|
PRIMARYBUSINESS_NUMEMPLOYEES
|
int
|
false
|
|
|
|
PRIMARYBUSINESS_NUMSUBSIDIARIES
|
int
|
false
|
|
|
|
PRIMARYBUSINESS_WEBADDRESS
|
UDT_WEBADDRESS
|
false
|
|
|
|
SPOUSE_COPY_ADDRESS
|
bit
|
false
|
|
|
|
SPOUSE_COPY_PHONENUMBER
|
bit
|
false
|
|
|
|
SPOUSE_COPY_EMAILADDRESS
|
bit
|
false
|
|
|
|
ISGROUP
|
bit
|
false
|
|
|
|
GROUPTYPECODE
|
tinyint
|
false
|
|
0=Household, 1=Custom
|
|
GROUPSTARTDATE
|
datetime
|
true
|
|
|
|
GROUPDESCRIPTION
|
nvarchar(300)
|
false
|
|
|
|
ADDRESS_OMITFROMVALIDATION
|
bit
|
false
|
|
|
|
ADDRESS_LASTVALIDATIONATTEMPTDATE
|
datetime
|
true
|
|
|
|
ADDRESS_VALIDATIONMESSAGE
|
nvarchar(200)
|
false
|
|
|
|
ADDRESS_CERTIFICATIONDATA
|
int
|
false
|
|
|
|
EDUCATIONALHISTORY_PREFERREDCLASSYEAR
|
UDT_YEAR
|
false
|
|
|
|
EDUCATIONALHISTORY_EDUCATIONALSOURCEDATE
|
UDT_FUZZYDATE
|
false
|
|
|
|
EDUCATIONALHISTORY_COMMENT
|
nvarchar(500)
|
false
|
|
|
|
EDUCATIONALHISTORY_DATEGRADUATED
|
UDT_FUZZYDATE
|
false
|
|
|
|
EDUCATIONALHISTORY_DATELEFT
|
UDT_FUZZYDATE
|
false
|
|
|
|
ISPRIMARYORGANIZATION
|
bit
|
false
|
|
|
|
PRIMARYBUSINESS_ISPRIMARYORGANIZATION
|
bit
|
false
|
|
|
|
GENDER
|
nvarchar(7) (Computed)
|
true
|
|
Provides a translation for the 'GENDERCODE' field.
|
|
EDUCATIONALHISTORY_CONSTITUENCYSTATUS
|
nvarchar(19) (Computed)
|
true
|
|
Provides a translation for the 'EDUCATIONALHISTORY_CONSTITUENCYSTATUSCODE' field.
|
|
SPOUSE_GENDER
|
nvarchar(7) (Computed)
|
true
|
|
Provides a translation for the 'SPOUSE_GENDERCODE' field.
|
|
GROUPTYPE
|
nvarchar(9) (Computed)
|
true
|
|
Provides a translation for the 'GROUPTYPECODE' field.
|
|
ADDRESS_HISTORICALSTARTDATE
|
date
|
true
|
|
Indicates the date that the constituent started using this address.
|
|
PRIMARYMEMBER_COPYCONTACTINFO
|
bit
|
false
|
|
|
|
LOOKUPID
|
nvarchar(100) (Computed)
|
true
|
|
Unique identifer that supports user defined values as well as system generated values.
|
|
PRIMARYBUSINESS_JOBTITLE
|
nvarchar(100)
|
false
|
|
Store the job title value for a the primary business relationship
|
|
PRIMARYBUSINESS_JOBDIVISION
|
nvarchar(100)
|
false
|
|
Stores the division of the job for this relationship
|
|
PRIMARYBUSINESS_JOBDEPARTMENT
|
nvarchar(100)
|
false
|
|
Stores the department of the job for this relationship
|
|
BIRTHPLACE
|
nvarchar(50)
|
false
|
|
|
|
PRIMARYBUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS
|
bit
|
false
|
|
|
|
PRIMARYBUSINESS_PRIMARYSOFTCREDITMATCHFACTOR
|
decimal(5, 2)
|
false
|
|
|
|
PRIMARYBUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS
|
bit
|
false
|
|
|
|
PRIMARYBUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR
|
decimal(5, 2)
|
false
|
|
|
|
EMAILADDRESS_STARTDATE
|
date
|
true
|
|
|
|
SPOUSE_EMAILADDRESS_STARTDATE
|
date
|
true
|
|
|
|
PRIMARYBUSINESS_EMAILADDRESS_STARTDATE
|
date
|
true
|
|
|
|
SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS
|
bit
|
false
|
|
|
|
SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR
|
decimal(5, 2)
|
false
|
|
|
|
SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS
|
bit
|
false
|
|
|
|
SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR
|
decimal(5, 2)
|
false
|
|
|
|
PRIMARYBUSINESS_STARTDATE
|
date
|
true
|
|
|
|
SPOUSE_STARTDATE
|
date
|
true
|
|
|
