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