CommunityArchive


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 null
IDType varchar 1 √ null
AddressID int 4 √ null
SpouseID int 4 √ null
SpouseFlag bit 1 √ null
CommunityCreatedDate datetime 16,3 √ null
CommunityCreatedBy varchar 50 √ null
CommunityModifiedDate datetime 16,3 √ null
CommunityModifiedBy varchar 50 √ null
Surname varchar 30 √ null
SurnamePrevious varchar 30 √ null
Title varchar 30 √ null
Initials varchar 15 √ null
Suffix varchar 20 √ null
Preferred varchar 20 √ null
Given1 varchar 20 √ null
Given2 varchar 50 √ null
OccupCode varchar 15 √ null
OccupDesc varchar 50 √ null
OccupCompany varchar 50 √ null
OccupIndustryCode varchar 8 √ null
OccupPositionCode varchar 8 √ null
OccupPhone varchar 15 √ null
OccupFax varchar 15 √ null
OccupEmail varchar 100 √ null
MailFormat varchar 1 √ null
SalutFormat varchar 1 √ null
BirthDate datetime 16,3 √ null
DeceasedDate datetime 16,3 √ null
DeceasedFlag bit 1 √ null
Gender varchar 15 √ null
MobilePhone varchar 15 √ null
Email varchar 100 √ null
ReligionCode varchar 5 √ null
CountryOfBirthCode varchar 5 √ null
HomeLanguageCode varchar 5 √ null
Education varchar 255 √ null
Qualifications varchar 255 √ null
HighestSecondaryYearLevel tinyint 1 √ null
LastYearOfStudy int 4 √ null
MaritalStatus varchar 1 √ null
MailNamePrimary varchar 100 √ null
MailNameJoint varchar 100 √ null
MailSalutationPrimary varchar 100 √ null
MailSalutationJoint varchar 100 √ null
OccupAddress1 varchar 40 √ null
OccupAddress2 varchar 40 √ null
OccupAddress3 varchar 40 √ null
OccupSuburb varchar 40 √ null
OccupState varchar 5 √ null
OccupCountryCode varchar 5 √ null
OccupPostCode varchar 5 √ null
OccupMobilePhone varchar 15 √ null
OccupAddressFull varchar 200 √ null
OccupAddressComma varchar 200 √ null
ParishCode varchar 5 √ null
NationalityCode varchar 5 √ null
InitialsOverrideFlag bit 1 √ null
OccupCompanyAttn varchar 40 √ null
DefaultEmailCode varchar 1 √ null
Nationality2Code varchar 5 √ null
OccupDescIncludeInAddressFlag bit 1 √ null
OccupAddressDPID varchar 8 √ null
OccupAddressSortPlanNumber varchar 3 √ null
ParkingSpace varchar 15 √ null
OccupAddressPAFVersion varchar 10 √ null
OccupAddressDPIDBarcode varchar 60 √ null
NetworkLogin varchar 100 √ null
Barcode varchar 20 √ null
OccupMobilePhoneActual varchar 15 √ null
SilentMobilePhoneFlag bit 1 √ null
MobilePhoneActual varchar 15 √ null
SilentOccupMobilePhoneFlag bit 1 √ null
DirectoryIncludeFlag bit 1 √ null
DirectoryProvideFlag bit 1 √ null
UserFlag1 bit 1 ((0))
UserFlag2 bit 1 ((0))
UserFlag3 bit 1 ((0))
UserFlag4 bit 1 ((0))
UserFlag5 bit 1 ((0))
MailNamePrimaryOverrideFlag bit 1 ((0))
MailNameJointOverrideFlag bit 1 ((0))
MailSalutationPrimaryOverrideFlag bit 1 ((0))
MailSalutationJointOverrideFlag bit 1 ((0))
NameInternal varchar 100 √ null
NameInternalOverrideFlag bit 1 √ null
NameExternal varchar 100 √ null
NameExternalOverrideFlag bit 1 √ null
PreferredFormal varchar 20 √ null
LegalFullName varchar 150 √ null
LegalFullNameOverrideFlag bit 1 √ null
EthnicGroup1Code varchar 15 √ null
EthnicGroup2Code varchar 15 √ null
EthnicGroup3Code varchar 15 √ null
IndigenousGroup1Code varchar 15 √ null
IndigenousGroup2Code varchar 15 √ null
IndigenousGroup3Code varchar 15 √ null
IndigenousLanguageLevelCode varchar 15 √ null
CountryCitizenshipCode varchar 5 √ null
EarlyChildhoodParticipationCode varchar 15 √ null
SchoolAttainmentCode varchar 15 √ null
NeighbourIslandLanguageCode varchar 5 √ null
NeighbourIslandLanguageLevelCode varchar 15 √ null
SystemProcessNumber int 4 √ null
DietaryRequirements varchar 2147483647 √ null
PhysicalRequirements varchar 2147483647 √ null
HighestQualificationLevel varchar 15 √ null
PublishToAssociatedFlag bit 1 ((0))
HighestNonNationalQualificationCode varchar 15 ('')
OccupDescIncludeInMailAddressFlag bit 1 √ null
WorkWithChildrenCheckStatus varchar 15 ('')
WorkWithChildrenCheckRegistrationNumber varchar 30 ('')
WorkWithChildrenCheckExpiryDate datetime 16,3 √ null
ExternalSystemRegistrationNumber varchar 30 ('')
DefaultMobilePhoneCode varchar 1 √ null
WebSite varchar 100 ('')
DietaryRequirementCode varchar 15 √ null
OccupAddressComment varchar 250 ('')
MaidenName varchar 30 ('')
OverideLegalSurname varchar 30 ('')
CommunityGUID varchar 32 ('')
RefugeeFlag bit 1 ((0))
Biography varchar 2147483647 √ null
WorkWithChildrenCheckVerifiedDate datetime 16,3 √ null
CurrentWWCRequiredFlag bit 1 ((0))
Comment varchar 2147483647 √ null
FacebookUrl varchar 100 √ null
FacetimeAddress varchar 100 √ null
IdamGuid uniqueidentifier 16 √ null
IdamLogin varchar 50 √ null
LinkedInUrl varchar 100 √ null
SkypeAddress varchar 100 √ null
TwitterUrl varchar 100 √ null
TransactionGUID uniqueidentifier 16 √ null
TransactionMode char 1 √ null
CommunityArchiveSeq int identity 4 √ null
ExternalValidationFlag bit 1 ((0))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_CommunityArchiveSeq Primary key Asc CommunityArchiveSeq
AK_CommunityArchive_IDDate Performance Asc/Asc ID + CommunityModifiedDate
AK_TransactionGUID Performance Asc TransactionGUID