vCommunityAddressesArchive


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ModifiedType varchar 10 √ null
ModifiedDate datetime 16,3 √ null
ModifiedBy varchar 50 √ null
ID int 4 √ null
IDType varchar 1 √ null
AddressID int 4 √ null
SpouseID int 4 √ null
SpouseFlag bit 1 √ 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
OccupMobilePhone varchar 15 √ null
OccupAddressComma varchar 200 √ null
OccupAddressFull 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
SilentMobilePhoneFlag bit 1 √ null
SilentOccupMobilePhoneFlag bit 1 √ null
DirectoryIncludeFlag bit 1 √ null
DirectoryProvideFlag bit 1 √ null
UserFlag1 bit 1 √ null
UserFlag2 bit 1 √ null
UserFlag3 bit 1 √ null
UserFlag4 bit 1 √ null
UserFlag5 bit 1 √ null
MailNamePrimaryOverrideFlag bit 1 √ null
MailNameJointOverrideFlag bit 1 √ null
MailSalutationPrimaryOverrideFlag bit 1 √ null
MailSalutationJointOverrideFlag bit 1 √ null
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 √ null
HighestNonNationalQualificationCode varchar 15 √ null
OccupDescIncludeInMailAddressFlag bit 1 √ null
WorkWithChildrenCheckStatus varchar 15 √ null
WorkWithChildrenCheckRegistrationNumber varchar 30 √ null
WorkWithChildrenCheckExpiryDate datetime 16,3 √ null
ExternalSystemRegistrationNumber varchar 30 √ null
DefaultMobilePhoneCode varchar 1 √ null
WebSite varchar 100 √ null
DietaryRequirementCode varchar 15 √ null
OccupAddressComment varchar 250 √ null
MaidenName varchar 30 √ null
OverideLegalSurname varchar 30 √ null
CommunityGUID varchar 32 √ null
RefugeeFlag bit 1 √ null
Biography varchar 2147483647 √ null
WorkWithChildrenCheckVerifiedDate datetime 16,3 √ null
PhoneAlt varchar 15 √ null
Fax varchar 15 √ null
HomeAddressSameFlag bit 1 √ null
ValidAddressFlag bit 1 √ null
SilentPhoneFlag bit 1 √ null
MailFlag bit 1 √ null
MagazineFlag bit 1 √ null
SolicitationFlag bit 1 √ null
RaffleFlag bit 1 √ null
ReasonFlagChange varchar 50 √ null
ReasonFlagChangeDate datetime 16,3 √ null
AddressComma varchar 200 √ null
AddressFull varchar 200 √ null
HomeAddressComma varchar 200 √ null
HomeAddressFull varchar 200 √ null
Phone varchar 15 √ null
AddressRegion varchar 10 √ null
AddressRegionOverrideFlag tinyint 1 √ null
AddressComment varchar 250 √ null
AddressDPID varchar 8 √ null
AddressSortPlanNumber varchar 3 √ null
HomeAddressDPID varchar 8 √ null
HomeAddressSortPlanNumber varchar 3 √ null
AddressPAFVersion varchar 10 √ null
HomeAddressPAFVersion varchar 10 √ null
AddressDPIDBarcode varchar 60 √ null
HomeAddressDPIDBarcode varchar 60 √ null
SilentHomeAddressFlag bit 1 √ null
MailFlagChangeReason varchar 255 √ null
MagazineFlagChangeReason varchar 255 √ null
SolicitationFlagChangeReason varchar 255 √ null
RaffleFlagChangeReason varchar 255 √ null
AddressUserFlag1 bit 1 √ null
AddressUserFlag2 bit 1 √ null
AddressUserFlag3 bit 1 √ null
AddressUserFlag4 bit 1 √ null
AddressUserFlag5 bit 1 √ null
HomeAddressLatitude decimal 11,6 √ null
HomeAddressLongitude decimal 11,6 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views