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 |
|
|
||
| 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 | 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 |
|
|
||
| CurrentWWCRequiredFlag | bit | 1 | null |
|
|
|||
| 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 | null |
|
|
Table contained 0 rows