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 |
|
|
|||
| 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 |
|
|
|||
| Comment | varchar | 2147483647 | √ | null |
|
|
||
| Biography | varchar | 2147483647 | √ | 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 |
|
|
|||
| OccupAddressPAFVersion | varchar | 10 | null |
|
|
|||
| OccupAddressDPIDBarcode | varchar | 60 | null |
|
|
|||
| ParkingSpace | varchar | 15 | null |
|
|
|||
| NetworkLogin | varchar | 100 | null |
|
|
|||
| Barcode | varchar | 20 | null |
|
|
|||
| SilentMobilePhoneFlag | bit | 1 | null |
|
|
|||
| MobilePhoneActual | varchar | 15 | null |
|
|
|||
| SilentOccupMobilePhoneFlag | bit | 1 | null |
|
|
|||
| OccupMobilePhoneActual | varchar | 15 | null |
|
|
|||
| DirectoryIncludeFlag | bit | 1 | null |
|
|
|||
| DirectoryProvideFlag | 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 |
|
|
|||
| 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 |
|
|
|||
| 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 |
|
|
|||
| 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 |
|
|
|||
| MaidenName | varchar | 30 | null |
|
|
|||
| OverideLegalSurname | varchar | 30 | null |
|
|
|||
| OccupAddressComment | varchar | 250 | null |
|
|
|||
| CommunityGUID | varchar | 32 | null |
|
|
|||
| WorkWithChildrenCheckVerifiedDate | datetime | 16,3 | √ | null |
|
|
||
| RefugeeFlag | bit | 1 | null |
|
|
|||
| FacetimeAddress | varchar | 100 | null |
|
|
|||
| SkypeAddress | varchar | 100 | null |
|
|
|||
| FacebookUrl | varchar | 100 | null |
|
|
|||
| TwitterUrl | varchar | 100 | null |
|
|
|||
| LinkedInUrl | varchar | 100 | null |
|
|
|||
| IdamGuid | uniqueidentifier | 16 | √ | null |
|
|
||
| IdamLogin | varchar | 50 | null |
|
|
|||
| CurrentWWCRequiredFlag | bit | 1 | null |
|
|
|||
| ExternalValidationFlag | bit | 1 | null |
|
|
|||
| DefaultEmail | varchar | 201 | null |
|
|
|||
| DefaultEmailOccupIfBoth | varchar | 100 | null |
|
|
|||
| DefaultEmailPersonalIfBoth | varchar | 100 | null |
|
|
|||
| DefaultMobilePhone | varchar | 15 | null |
|
|
|||
| DefaultMobilePhoneActual | varchar | 15 | null |
|
|
|||
| MailNamePrimaryPreferred | varchar | 123 | null |
|
|
|||
| ConfirmationsDisplayName | varchar | 75 | null |
|
|
|||
| GenderSynergyMeaning | varchar | 30 | √ | null |
|
|
Table contained 0 rows