Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
pvDocumentClassificationsUser View InsertFlag bit 1 √ null
pvCommunityCorrespondence View ModuleKey int 4 √ null
pvStudentContacts View ModifiedBy varchar 50 null
vDocumentsWithoutDocumentField View SelectFlag bit 1 √ null
Photos Table ID int 4 null
pvNotificationCorrespondenceRecipients View Subject varchar 255 null
pvCommunity View Title varchar 30 null
pvCommunityCorrespondence View CreatedByID int 4 √ null
CommunityCorrespondenceRecipients Table Content varchar 2147483647 ('')
NotificationCorrespondenceRecipients Table PhoneNumber varchar 15 ('')
vDocumentsWithoutDocumentField View Module varchar 30 √ null
CommunityCorrespondenceRecipients Table ID int 4 null
pvFileSemesters View AuthorStoppedFlag bit 1 null
pvCommunityCorrespondence View SenderID int 4 √ null
SystemEmail Table ErrorMessage varchar 4000 ('')
pvFileSemesters View SeasonType varchar 15 null
DebtorStatementsDocuments Table DebtorStatementBalancesRecipientsSeq int 4 √ null
NotificationCorrespondenceRecipients Table Email varchar 100 ('')
vStudentReportsArchiveLatest View StudentReportsArchiveSeq int 4 null
pvCommunity View OccupAddressFull varchar 200 null
pvCommunity View SilentMobilePhoneFlag bit 1 null
CommunityCorrespondence Table Module varchar 15 ('')
CommunityCorrespondenceRecipients Table Subject varchar 255 ('')
pvCommunity View CurrentWWCRequiredFlag bit 1 null
pvCommunityCorrespondence View ContentPrev varchar 255 √ null
vStudentReportsArchiveLatest View DocumentDocument varbinary 2147483647 √ null
SynDatabaseLocal Table VersionInstalledByWorkstation varchar 50 ('')
pvDocumentClassificationsUser View ID int 4 null
vDocuments View DocumentType varchar 15 null
SystemEmail Table ParamAppendQueryErrorFlag bit 1 ((0))
OnlineTemporaryAttachments Table OnlineTemporaryAttachmentsSeq int identity 4 √ null
pvDocumentClassificationsUser View DeleteFlag bit 1 √ null
OnlineImportAttachments Table OnlineImportApplicationsSeq int 4 null
pvluDocumentClassification View SynergyMeaning varchar 30 null
pvCommunity View Initials varchar 15 null
NotificationCorrespondenceRecipients Table SentFlag bit 1 ((0))
SystemEmailAttachment Table SysmailFilesize int 4 √ null
pvNotificationCorrespondenceRecipients View VerificationRequiredFlag bit 1 null
vLoginName View HostName nvarchar 256 √ null
pvDocumentReferences View CommunityID int 4 √ null
StudentReportsArchiveLink Table ID int 4 null
pvNotificationCorrespondenceRecipients View ContentSubstituted varchar 2147483647 null
pvCommunityCorrespondence View Module varchar 30 √ null
vDocumentsWithoutDocumentField View Description varchar 255 null
pvStudentNames View EntryDate datetime 16 √ null
SystemEmail Table SysmailExcludeQueryOutputFlag bit 1 √ null
tDocuments Table SourceCode varchar 15 ('')
pvFileSemesters View FileSemester smallint 2 null
pvNotificationCorrespondenceRecipients View BCC varchar 1000 null
pvDocumentClassificationsUser View Description varchar 100 null
CommunityCorrespondenceRecipients Table SentFlag bit 1 ((0))
pvFutureStudentNames View FuturePreferredDetailed varchar 69 √ null
pvFileSemesters View CommPortalCurrentFlag bit 1 null
pvNotificationCorrespondenceRecipients View SentFlag bit 1 null
pvFutureStudentNames View FutureNameExternal varchar 100 √ null
tDocumentReferencesArchive Table RelatedSeq int 4 √ null
pvDocumentReferences View tDocumentsSeq int 4 √ null
pvStudentNames View ActiveTodayFlag bit 1 √ null
StudentReportsArchive Table Document varbinary 2147483647 √ null
vStudentReportsArchiveLatest View UnderlayCreatedDate datetime 16 √ null
pvCommunity View OccupCountryCode varchar 5 null
vDocumentsWithoutDocumentField View DeleteFlag bit 1 √ null
pvStudentContacts View NormalMailFlag bit 1 null
CommunityCorrespondence Table ClassificationCode varchar 15 ('')
pvCommunity View NetworkLogin varchar 100 null
pvluDocumentClassification View DescriptionStyle varchar 20 null
wkCommunityCorrespondenceAttachments Table Attachment varbinary 2147483647 √ null
pvCommunity View DeceasedFlag bit 1 null
pvCommunity View NameInternalOverrideFlag bit 1 null
DebtorStatementsDocuments Table InvoicePageCount smallint 2 √ null
pvCommunity View ParkingSpace varchar 15 null
NotificationCorrespondenceRecipients Table DBMailitemID int 4 √ null
pvFileSemesters View ActivatedFlag bit 1 null
pvluDocumentClassification View Description varchar 100 null
NotificationCorrespondenceRecipients Table Subject varchar 255 ('')
vStudentReportsArchiveLatest View DocumentCreatedByID int 4 √ null
PayrollEmployeeDocuments Table PayrollEmployeeDocumentsSeq int identity 4 √ null
CommunityCorrespondenceAttachments Table CommunityCorrespondenceSeq int 4 null
pvObjectTaskActivities View CommunicationReference varchar 255 null
pvObjectTaskActivities View Description varchar 2147483647 √ null
pvCommunity View WorkWithChildrenCheckExpiryDate datetime 16 √ null
vDocumentsWithoutDocumentField View SynDatabaseCode varchar 5 null
SystemEmailAttachment Table SystemEmailAttachmentSeq int identity 4 √ null
DebtorStatementsDocuments Table UnderlayType varchar 1 ('')
StudentReportsArchive Table SourcePath varchar 1000 ('')
pvFutureStudentNames View EnrolYear int 4 √ null
CommunityCorrespondence Table SenderID int 4 √ null
PayrollEmployeeDocuments Table FinanceDatabaseCode varchar 20 ('')
pvFutureStudentNames View Tutor varchar 15 null
pvFutureStudentNames View YearLevel smallint 2 √ null
SystemEmail Table SysmailSentDate datetime 16 √ null
SystemEmail Table ParamExcludeQueryOutputFlag bit 1 ((0))
SystemEmailAttachment Table SysmailAttachment varbinary 2147483647 √ null
vStudentReportsArchiveLatest View UnderlaySourcePath varchar 1000 √ null
tDocumentReferencesArchive Table RelatedSeqModuleCode varchar 30 √ null
vDocumentsWithoutDocumentField View DocumentCreatedDate datetime 16 null
pvObjectTaskActivities View ObjectTaskActivitiesSeq int identity 4 null
vDocuments View SourceCode varchar 15 null
tDocumentsArchive Table DocumentCreatedDate datetime 16 ('')
pvCommunity View OverideLegalSurname varchar 30 null
DebtorStatementsDocuments Table StatementPageCount smallint 2 √ null
SystemEmail Table SysmailSendRequestUser nvarchar 256 √ null
vStudentReportsArchiveLatest View UnderlayDocument varbinary 2147483647 √ null
pvCommunity View CountryCitizenshipCode varchar 5 null
tDocumentReferencesArchive Table CommunityID int 4 √ ((0))
NotificationCorrespondenceRecipientsReply Table Content varchar 2147483647 ('')
NotificationCorrespondenceRecipientsReply Table NotificationCorrespondenceRecipientsReplySeq int identity 4 √ null
pvCommunity View DefaultMobilePhoneActual varchar 15 null
SystemEmail Table SysmailFileAttachments nvarchar 1073741823 √ null
CommunityCorrespondence Table CC varchar 2147483647 ('')
SystemEmail Table SysmailExecuteQueryDatabase nvarchar 256 √ null
pvCommunityCorrespondence View CreatedDate datetime 16 √ null
wkCommunityCorrespondenceSentDBMail Table SessionID datetime 16 null
vDocuments View CommunityID int 4 √ null
pvStudentContacts View LinkedID int 4 null
SystemEmail Table CreatedByID int 4 √ null
tDocumentReferences Table RelatedSeqModuleCode varchar 30 √ null
pvCommunity View Nationality2Code varchar 5 null
pvDocumentReferences View Module varchar 30 √ null
Photos Table Photo varbinary 2147483647 √ null
pvStudentNames View House varchar 5 null
SystemEmail Table SysmailSubject nvarchar 510 √ null
pvCommunity View NationalityCode varchar 5 null
pvluDocumentClassification View ModifiedDate datetime 16 √ null
vDocumentsWithoutDocumentField View ClassificationCode varchar 15 null
pvCommunityCorrespondence View PhoneNumber varchar 100 null
StudentReportsArchive Table SourceRef varchar 100 ('')
vDocumentsWithoutDocumentField View SourceRef varchar 100 null
tDocumentsArchive Table tDocumentsArchiveSeq int 4 null
pvCommunity View SchoolAttainmentCode varchar 15 null
StudentReportsArchive Table SourceCode varchar 50 ('')
pvCommunity View OccupAddress3 varchar 40 null
SynDatabaseLocal Table VersionInstalledDate datetime 16 √ null
pvCommunity View PublishToAssociatedFlag bit 1 null
pvDocumentClassificationsUser View SelectFlag bit 1 √ null
pvStudentContacts View SpouseSIF3RefID uniqueidentifier 16 √ null
pvFileSemesters View CommPortalResultsPublishAfterDate datetime 16 √ null
wkCommunityCorrespondenceSentDBMail Table RecipientEmail varchar 255 √ null
pvCommunity View DefaultEmailCode varchar 1 null
pvCommunity View Gender varchar 15 null
pvCommunity View NeighbourIslandLanguageLevelCode varchar 15 null
vLoginName View LoginName varchar 50 √ null
SystemEmail Table SysmailRecipients varchar 2147483647 √ null
pvCommunity View OccupPhone varchar 15 null
tDocuments Table Description varchar 255 ('')
pvFileSemesters View ActualSemester smallint 2 null
pvNotificationCorrespondence View sqlcNotificationSent bit 1 √ null
vDocuments View ClassificationDescription varchar 100 null
pvNotificationCorrespondenceRecipients View DeletedFlag bit 1 null
pvCommunity View OccupCompany varchar 50 null
tDocuments Table SourceRef varchar 100 ('')
SystemEmailAttachment Table SysmailFilename varchar 260 √ null
pvStudentNames View StudentNameExternal varchar 100 √ null
SystemEmail Table SysmailBody nvarchar 1073741823 √ null
StudentReportsArchiveLink Table Description varchar 255 ('')
pvluDocumentClassification View CommPortalVisibleForSpouseFlag bit 1 null
pvNotificationCorrespondenceRecipients View NotificationRulesSeq int 4 null
pvNotificationCorrespondence View sqlcNotificationStatusText varchar 2000 √ null
pvCommunity View DefaultMobilePhone varchar 15 null
SystemEmail Table SysmailSentAccountID int 4 √ null
pvluDocumentClassification View CommPortalVisibleForStudentReportsFlag bit 1 null
pvCommunity View ExternalSystemRegistrationNumber varchar 30 null
pvObjectTaskActivities View CreatedByID int 4 null
vDocumentsWithoutDocumentField View tDocumentsSeq int 4 null
pvNotificationCorrespondenceRecipients View AbsenceEventsSeq int 4 √ null
NotificationCorrespondence Table PeriodNumber tinyint 1 √ null
tDocumentReferences Table SynDatabaseCode varchar 5 √ null
tDocumentsArchive Table Description varchar 255 ('')
pvFileSemesters View StartDate datetime 16 √ null
tDocumentsArchive Table SourceCode varchar 15 ('')
pvCommunity View SkypeAddress varchar 100 null
pvCommunity View ParishCode varchar 5 null
tDocumentReferencesArchive Table tDocumentsSeq int 4 √ null
SystemEmail Table ParamQueryResultWidth int 4 √ null
SystemEmail Table ParamQueryResultSeparator char 1 (' ')
tDocumentsArchive Table DocumentModifiedByID int 4 null
pvDocumentClassificationsUser View LoginName varchar 50 null
vStudentReportsArchiveLatest View DocumentDocumentType varchar 15 null
tDocuments Table ClassificationCode varchar 15 ('')
vDocumentsWithoutDocumentField View DocumentType varchar 15 null
pvCommunity View LegalFullNameOverrideFlag bit 1 null
pvCommunity View MaidenName varchar 30 null
pvluDocumentClassification View Code varchar 15 null
vStudentReportsArchiveLatest View UnderlayCreatedByID int 4 √ null
pvFileSemesters View ReportsPrintedFlag bit 1 null
vDocumentsWithoutDocumentField View DocumentThumbnail varbinary 8000 √ null
SystemEmail Table ProcessedDate datetime 16 √ null
tDocuments Table DocumentCreatedByID int 4 √ null
pvCommunity View MailNamePrimaryOverrideFlag bit 1 null
vDocuments View Document varbinary 2147483647 √ null
vDocuments View tDocumentsSeq int 4 null
pvCommunity View OccupAddress2 varchar 40 null
tDocumentReferences Table tDocumentsSeq int 4 √ null
pvStudentNames View StudentNameInternal varchar 100 √ null
pvCommunityCorrespondence View CommunityCorrespondenceSeq int 4 null
tDocuments Table DocumentCreatedDate datetime 16 ('')
CommunityCorrespondenceRecipients Table Email varchar 100 ('')
wkCommunityCorrespondenceSentDBMail Table SenderID int 4 √ null
pvCommunity View OccupPositionCode varchar 8 null
pvCommunity View CommunityCreatedBy varchar 50 √ null
pvObjectTaskActivities View EmailBCC varchar 255 null
pvStudentContacts View ReportsFlag bit 1 null
pvCommunityCorrespondence View Content varchar 2147483647 √ null
pvCommunity View Barcode varchar 20 null
OnlineImportAttachments Table OnlineImportAttachmentsSeq int identity 4 √ null
CommunityCorrespondence Table DB_MailItem_ID int 4 √ null
vDocumentsWithoutDocumentField View MastertDocumentsSeq int 4 √ null
pvCommunity View BirthDate datetime 16 √ null
pvObjectTaskActivities View StartDate datetime 16 √ null
tDocumentsArchive Table SourceDate datetime 16 ('')
SystemEmail Table ParamSubject nvarchar 510 √ null
pvCommunity View ExternalValidationFlag bit 1 null
SystemEmail Table SysmailCopyRecipients varchar 2147483647 √ null
SystemEmail Table SysmailSensitivity varchar 12 √ null
pvCommunity View OccupAddressSortPlanNumber varchar 3 null
pvDocumentClassificationsUser View UpdateFlag bit 1 √ null
pvObjectTaskActivities View CommunicationMethodCode varchar 15 null
pvCommunity View UserFlag2 bit 1 null
pvCommunity View CommunityGUID varchar 32 null
pvDocumentClassificationsUser View SecurityMeaning varchar 15 null
vStudentReportsArchiveLatest View StudentReportsArchiveLinkSeq int 4 null
NotificationCorrespondence Table Subject varchar 255 ('')
pvCommunity View ConfirmationsDisplayName varchar 75 null
ObjectTaskActivityAttachments Table Attachment varbinary 2147483647 √ null
pvCommunity View LegalFullName varchar 150 null
ObjectTaskActivityAttachments Table SourceFileName varchar 150 ('')
wkCommunityCorrespondenceAttachments Table AttachmentFileName varchar 100 ('')
NotificationCorrespondence Table CreatedByID int 4 √ null
StudentReportsArchiveLink Table FileYear int 4 √ null
vDocuments View UpdateFlag bit 1 √ null
pvCommunity View OccupDescIncludeInAddressFlag bit 1 null
pvStudentNames View StudentNameForwardDetailed varchar 172 √ null
pvCommunity View DietaryRequirements varchar 2147483647 √ null
pvStudentNames View Form varchar 15 null
OnlineImportAttachments Table Description varchar 255 √ ('')
pvCommunityCorrespondence View SentFlag bit 1 √ null
NotificationCorrespondence Table SenderEmail varchar 100 ('')
pvCommunity View HighestNonNationalQualificationCode varchar 15 null
vDocuments View DocumentModifiedDate datetime 16 null
DocumentReferences Table DocumentReferencesSeq int 4 √ null
pvCommunity View MailFormat varchar 1 null
pvCommunity View IndigenousGroup3Code varchar 15 null
pvCommunity View OccupFax varchar 15 null
pvCommunity View DefaultMobilePhoneCode varchar 1 null
vDocuments View DocumentThumbnail varbinary 8000 √ null
vDocumentsWithoutDocumentField View DocumentModifiedDate datetime 16 null
StudentReportsArchiveLink Table StudentReportsArchiveSeq int 4 null
NotificationCorrespondence Table CreatedDateTime datetime 16 (getdate())
SystemEmail Table ParamImportance varchar 6 √ null
pvNotificationCorrespondenceRecipients View CreatedDateTime datetime 16 null
SystemEmail Table SysmailQueryResultWidth int 4 √ null
Photos Table SourceDesc varchar 20 √ null
pvCommunity View SilentOccupMobilePhoneFlag bit 1 null
tDocumentsArchive Table DocumentType varchar 15 ('')
SystemEmail Table SysmailQueryResultHeaderFlag bit 1 √ null
pvCommunity View MailNameJointOverrideFlag bit 1 null
OnlineImportAttachments Table FieldName varchar 20 ('')
pvNotificationCorrespondenceRecipients View CC varchar 1000 null
pvCommunity View WebSite varchar 100 null
vDocumentsWithoutDocumentField View InsertFlag bit 1 √ null
SystemEmail Table SysmailQuery nvarchar 1073741823 √ null
tDocuments Table Document varbinary 2147483647 √ null
pvCommunity View CommunityModifiedBy varchar 50 √ null
CommunityCorrespondence Table MAPIProfile varchar 100 ('')
SystemEmail Table ParamQueryAttachmentFilename nvarchar 520 √ null
pvCommunity View WorkWithChildrenCheckVerifiedDate datetime 16 √ null
pvCommunity View HighestSecondaryYearLevel tinyint 1 null
CommunityCorrespondenceAttachments Table CommunityCorrespondenceAttachmentsSeq int identity 4 √ null
pvStudentNames View StudentLegalFullName varchar 150 √ null
pvStudentContacts View PrimaryOnlyFlag bit 1 null
pvCommunity View SalutFormat varchar 1 null
DebtorStatementsDocuments Table DebtorStatementsDocumentsSeqUnderlay int 4 √ null
vDocumentsWithoutDocumentField View SourcePath varchar 1000 √ null
SynDatabaseLocal Table VersionNumber decimal 16 √ ((0))
NotificationCorrespondenceRecipientsReply Table SystemProcessNumber int 4 √ null
pvNotificationCorrespondenceRecipients View Format varchar 15 null
pvCommunity View OccupAddressPAFVersion varchar 10 null
vStudentReportsArchiveLatest View FileSemester smallint 2 √ null
pvCommunity View IndigenousGroup2Code varchar 15 null
pvCommunity View DietaryRequirementCode varchar 15 null
pvCommunity View Preferred varchar 20 null
pvCommunity View OccupAddressDPIDBarcode varchar 60 null
pvCommunity View UserFlag4 bit 1 null
SystemEmail Table ParamProfileName nvarchar 256 ('')
pvCommunity View OccupMobilePhone varchar 15 null
pvrefCommunityCorrespondenceTypes View Description varchar 30 null
DebtorStatementsDocumentsPreviewLog Table StatementNumber int 4 ((0))
pvStudentNames View StudentGiven1 varchar 20 √ null
NotificationCorrespondence Table CC varchar 1000 ('')
pvCommunity View OccupState varchar 5 √ null
pvluDocumentClassification View CommPortalVisibleForSelfFlag bit 1 null
SystemEmail Table ParamBlindCopyRecipients varchar 2147483647 √ null
NotificationCorrespondence Table NotificationRulesSeq int 4 null
SystemEmailAttachment Table SysmailAttachmentID int 4 √ null
wkCommunityCorrespondenceAttachments Table ConfigUserID int 4 √ null
vDocuments View Module varchar 30 √ null
tDocumentReferences Table CommunityID int 4 √ ((0))
pvNotificationCorrespondenceRecipients View ProcessedDateTime datetime 16 √ null
pvCommunity View Email varchar 100 null
pvluDocumentClassification View SetCentrallyFlag bit 1 √ null
pvCommunity View CountryOfBirthCode varchar 5 null
NotificationCorrespondence Table SubjectClassesSeq int 4 √ null
pvCommunity View OccupCompanyAttn varchar 40 null
Photos Table PhotoType varchar 5 (' ')
DebtorStatementsDocuments Table InvoiceImage varbinary 2147483647 √ null
pvFileSemesters View AnnualAssessmentsFlag bit 1 null
SystemEmail Table ParamFromAddress varchar 2147483647 √ null
pvObjectTaskActivities View FollowUpDate datetime 16 √ null
Photos Table ModifiedDate datetime 16 √ null
SystemEmail Table SenderEmail varchar 100 √ null
SystemEmail Table SysmailLastModUser nvarchar 256 √ null
pvCommunity View IndigenousLanguageLevelCode varchar 15 null
DebtorStatementsDocumentsPreviewLog Table PreviewDate datetime 16 (getdate())
tDocuments Table DocumentModifiedByID int 4 √ null
pvFutureStudentNames View FuturePreferred varchar 20 √ null
pvNotificationCorrespondence View sqlcNotificationReply varchar 2147483647 √ null
pvNotificationCorrespondence View AbsenceEventsSeq int 4 √ null
pvCommunity View CommunityModifiedDate datetime 16 √ null
vStudentReportsArchiveLatest View UnderLaySeq int 4 √ null
CommunityCorrespondenceAttachments Table Attachment varbinary 2147483647 √ null
NotificationCorrespondenceRecipients Table ID int 4 null
NotificationCorrespondence Table Type varchar 15 ('')
SystemEmailRecipient Table ID int 4 √ null
pvFutureStudentNames View House varchar 5 null
pvCommunity View Qualifications varchar 255 null
pvStudentNames View LeavingDate datetime 16 √ null
DocumentReferences Table ID int 4 null
PayrollEmployeeDocuments Table CreatedDate datetime 16 (getdate())
tDocumentsArchive Table DocumentCreatedByID int 4 null
SystemEmail Table SysmailSendRequestDate datetime 16 √ null
StudentReportsArchiveLink Table FileSemester smallint 2 √ null
pvCommunityCorrespondence View Type varchar 15 null
pvNotificationCorrespondenceRecipients View Type varchar 15 null
pvDocumentClassificationsUser View ActiveFlag bit 1 null
pvCommunity View Biography varchar 2147483647 √ null
pvCommunity View EarlyChildhoodParticipationCode varchar 15 null
SystemEmail Table ParamBody nvarchar 1073741823 √ null
pvNotificationCorrespondenceRecipients View SubjectSubstituted varchar 255 null
pvCommunity View ReligionCode varchar 5 null
NotificationCorrespondenceRecipients Table Content varchar 2147483647 ('')
vStudentReportsArchiveLatest View DocumentCreatedDate datetime 16 √ null
pvCommunity View SpouseFlag bit 1 null
NotificationCorrespondence Table VerificationRequiredFlag bit 1 ((0))
SystemEmailAttachment Table SystemEmailSeq int 4 null
pvStudentNames View StudentCampus varchar 3 null
tDocuments Table DocumentType varchar 15 ('')
pvFileSemesters View SystemCurrentFlag bit 1 null
pvDocumentReferences View SynDatabaseCode varchar 5 null
pvNotificationCorrespondenceRecipients View NotificationCorrespondenceRecipientsSeq int 4 null
pvFutureStudentNames View FutureGiven1 varchar 20 √ null
pvFutureStudentNames View FutureSurname varchar 30 √ null
NotificationCorrespondenceRecipientsReply Table ReceivedDateTime datetime 16 null
wkCommunityCorrespondenceSentDBMail Table MailItemID int 4 √ null
Photos Table ModifiedBy varchar 50 √ null
pvCommunity View NeighbourIslandLanguageCode varchar 5 null
Photos Table MediumRes varbinary 2147483647 √ null
vDocuments View SourcePath varchar 1000 √ null
pvCommunity View LinkedInUrl varchar 100 null
pvFutureStudentNames View FuturePreferredFormal varchar 20 √ null
pvCommunity View NameExternalOverrideFlag bit 1 null
pvStudentContacts View LivesWithFlag bit 1 null
pvCommunity View IDType varchar 1 null
NotificationCorrespondenceRecipientsReply Table NotificationCorrespondenceRecipientsSeq int 4 null
OnlineTemporaryAttachments Table DocumentData varbinary 2147483647 √ null
vDocuments View SourceRef varchar 100 null
pvCommunity View OccupAddressDPID varchar 8 null
pvCommunity View OccupPostCode varchar 5 null
tDocuments Table DocumentModifiedDate datetime 16 ('')
SystemEmail Table ParamCopyRecipients varchar 2147483647 √ null
pvCommunity View LastYearOfStudy int 4 null
vDocuments View SynDatabaseCode varchar 5 null
tDocumentsArchive Table Document varbinary 2147483647 √ null
NotificationCorrespondence Table Content varchar 2147483647 ('')
pvStudentNames View LeavingDatePassedFlag bit 1 √ null
SystemEmail Table SysmailAttachQueryResultAsFileFlag bit 1 √ null
pvCommunity View EthnicGroup2Code varchar 15 null
wkCommunityCorrespondenceAttachments Table CommunityCorrespondenceSeq int 4 null
pvStudentNames View YearLevelSort smallint 2 null
CommunityCorrespondence Table BCC varchar 2147483647 √ ('')
SystemEmailRecipient Table BlindCopyFlag bit 1 ((0))
pvFileSemesters View EndDate datetime 16 √ null
NotificationCorrespondence Table Recipients varchar 1000 ('')
SystemEmail Table SystemEmailSeq int identity 4 √ null
tDocuments Table DocumentStoredFlag bit 1 √ null
pvrefCommunityCorrespondenceTypes View Code varchar 15 null
pvCommunity View DefaultEmailPersonalIfBoth varchar 100 null
pvCommunity View MobilePhone varchar 15 null
pvluDocumentClassification View CommPortalVisibleForStudentParentFlag bit 1 null
pvCommunity View IdamGuid uniqueidentifier 16 √ null
tDocumentsArchive Table SourcePath varchar 1000 √ null
pvCommunity View Surname varchar 30 null
StudentReportsArchive Table CreatedByID int 4 √ null
SystemEmail Table ParamQueryNoTruncateFlag bit 1 ((0))
pvCommunity View OccupAddressComment varchar 250 null
vDocuments View ID int 4 √ null
NotificationCorrespondence Table MAPIProfile varchar 100 ('')
pvCommunity View HomeLanguageCode varchar 5 null
pvStudentNames View StudentNameNoYearLevel varchar 100 √ null
pvCommunity View FacebookUrl varchar 100 null
pvCommunity View DefaultEmail varchar 201 null
pvFutureStudentNames View EnrolDate datetime 16 √ null
pvStudentNames View Boarder varchar 3 null
pvCommunity View CommunityCreatedDate datetime 16 √ null
StudentReportsArchiveLink Table StudentReportsArchiveLinkSeq int identity 4 √ null
pvFileSemesters View SynergyMeaning varchar 20 null
pvStudentContacts View ModifiedDate datetime 16 √ null
vDocumentsWithoutDocumentField View DocumentCreatedByID int 4 √ null
pvStudentNames View StudentPreferredFormal varchar 20 √ null
pvCommunity View DefaultEmailOccupIfBoth varchar 100 null
SystemEmail Table ParamQuery nvarchar 1073741823 √ null
ObjectTaskActivityAttachments Table ObjectTaskActivityAttachmentsSeq int identity 4 √ null
SystemEmail Table ParamRecipients varchar 2147483647 √ null
pvCommunity View DeceasedDate datetime 16 √ null
NotificationCorrespondence Table ProcessedDateTime datetime 16 √ null
pvCommunityCorrespondence View ID int 4 √ null
SystemEmail Table CreatedDate datetime 16 √ null
pvDocumentClassificationsUser View DocumentClassificationCode varchar 15 null
pvStudentContacts View SIF3RefID uniqueidentifier 16 √ null
tDocuments Table SourcePath varchar 1000 √ null
StudentReportsArchive Table UnderLaySeq int 4 √ null
SystemEmail Table SysmailSentStatus varchar 8 √ null
vStudentReportsArchiveLatest View DocumentSourcePath varchar 1000 null
vStudentReportsArchiveLatest View ID int 4 null
SynDatabaseLocal Table ScriptName varchar 20 ('')
pvCommunity View PreferredFormal varchar 20 null
pvCommunity View MailSalutationPrimary varchar 100 null
pvCommunity View OccupSuburb varchar 40 null
tDocuments Table SourceDate datetime 16 ('')
pvCommunity View MailSalutationJointOverrideFlag bit 1 null
vDocuments View DeleteFlag bit 1 √ null
pvCommunity View SurnamePrevious varchar 30 null
CommunityCorrespondence Table Subject varchar 255 ('')
pvObjectTaskActivities View EmailSubject varchar 255 null
pvluDocumentClassification View SecurityMeaning varchar 15 null
StudentReportsArchive Table CreatedDate datetime 16 √ (getdate())
pvFutureStudentNames View FutureName varchar 101 √ null
tDocuments Table DocumentThumbnail varbinary 8000 √ null
pvStudentNames View Gender varchar 15 √ null
pvStudentNames View EntryDateLowIfBlank datetime 16 null
tDocumentsArchive Table DocumentModifiedDate datetime 16 ('')
CommunityCorrespondence Table CreatedDate datetime 16 √ null
pvObjectTaskActivities View FollowUpID int 4 √ null
pvCommunity View TwitterUrl varchar 100 null
pvCommunity View NameExternal varchar 100 null
pvCommunity View MaritalStatus varchar 1 null
pvStudentContacts View LinkedIDSeq tinyint 1 null
StudentReportsArchiveLink Table FileType varchar 5 ('')
SystemEmail Table SysmailAppendQueryErrorFlag bit 1 √ null
pvCommunity View OccupDesc varchar 50 null
pvStudentContacts View StudentContactsSeq int identity 4 null
CommunityCorrespondence Table ModuleKey int 4 √ null
CommunityCorrespondence Table SenderEmail varchar 100 ('')
SystemEmail Table SysmailQueryResultSeparator char 1 √ null
NotificationCorrespondenceRecipients Table NotificationCorrespondenceRecipientsSeq int identity 4 √ null
DebtorStatementsDocuments Table DebtorStatementsDocumentsSeqUnderlayHeader int 4 √ null
pvCommunity View AddressID int 4 null
SystemEmailRecipient Table Email varchar 100 √ null
wkCommunityCorrespondenceSentDBMail Table Seq int identity 4 √ null
SystemEmail Table ParamAttachQueryResultAsFileFlag bit 1 ((0))
pvObjectTaskActivities View AllocatedToID int 4 √ null
SystemEmail Table SysmailLastModDate datetime 16 √ null
vDocuments View SourceTable varchar 3 null
pvNotificationCorrespondenceRecipients View SubjectClassesSeq int 4 √ null
pvluDocumentClassification View ModifiedUser varchar 100 null
NotificationCorrespondenceRecipients Table CreatedDateTime datetime 16 √ (getdate())
CommunityCorrespondence Table Content varchar 2147483647 √ null
SystemEmail Table SysmailAttachmentEncoding varchar 20 √ null
vLoginName View CurrentDate datetime 16 null
pvFutureStudentNames View FutureNameInternal varchar 100 √ null
tDocumentsArchive Table MastertDocumentsSeq int 4 √ null
vDocumentsWithoutDocumentField View ClassificationDescription varchar 100 null
SystemEmailRecipient Table CopyFlag bit 1 ((0))
DebtorStatementsDocumentsPreviewLog Table DebtorID int 4 ((0))
pvCommunityCorrespondence View Email varchar 1000 √ null
pvCommunity View MailNameJoint varchar 100 null
pvCommunity View OccupDescIncludeInMailAddressFlag bit 1 null
NotificationCorrespondence Table BCC varchar 1000 ('')
vDocuments View SelectFlag bit 1 √ null
tDocumentReferences Table tDocumentReferencesSeq int identity 4 √ null
pvCommunity View UserFlag1 bit 1 null
DebtorStatementsDocumentsPreviewLog Table DebtorStudentID int 4 ((0))
OnlineTemporaryAttachments Table OnlineImportSubmissionsSeq int 4 √ null
pvStudentNames View StudentBirthDate datetime 16 √ null
vDocuments View DocumentModifiedByID int 4 √ null
pvStudentNames View LeavingHighlightFlag bit 1 √ null
pvFileSemesters View FileYear smallint 2 null
NotificationCorrespondence Table NotificationCorrespondenceSeq int identity 4 √ null
pvNotificationCorrespondenceRecipients View PhoneNumber varchar 15 null
pvCommunityCorrespondence View AttachmentCount int 4 √ null
pvDocumentReferences View ID int 4 √ null
pvStudentNames View StudentName varchar 221 √ null
tDocumentReferences Table SortOrder int 4 ((0))
wkCommunityCorrespondenceSentDBMail Table SenderEmail varchar 255 √ null
CommunityCorrespondence Table Type varchar 15 ('')
pvFutureStudentNames View Form varchar 15 null
pvFutureStudentNames View Status varchar 3 null
pvObjectTaskActivities View FollowUpFlag bit 1 null
pvCommunityCorrespondence View SourceDate datetime 16 null
DebtorStatementsDocuments Table DatabaseCode varchar 5 ('')
CommunityCorrespondenceRecipients Table PhoneNumber varchar 100 ('')
pvCommunity View Given2 varchar 50 null
OnlineImportAttachments Table CreatedDate datetime 16 √ null
DebtorStatementsDocuments Table DebtorStatementsDocumentsSeqUnderlayFooter int 4 √ null
pvObjectTaskActivities View EmailCC varchar 255 null
pvFileSemesters View SeasonActiveFlag bit 1 null
vDocumentsWithoutDocumentField View SourceDate datetime 16 null
pvCommunity View NameInternal varchar 100 null
pvNotificationCorrespondence View ProcessedDateTime datetime 16 √ null
SystemEmail Table ParamBodyFormat varchar 20 √ null
SystemEmail Table ParamExecuteQueryDatabase nvarchar 256 √ null
NotificationCorrespondenceRecipients Table DeletedFlag bit 1 ((0))
pvFutureStudentNames View FutureNameNoYearLevel varchar 52 √ null
SystemEmail Table ParamReplyTo varchar 2147483647 √ null
NotificationCorrespondenceRecipientsReply Table FromNumber varchar 15 ('')
vDocumentsWithoutDocumentField View DocumentModifiedByID int 4 √ null
OnlineImportAttachments Table FieldData varbinary 2147483647 √ null
pvCommunity View OccupAddressComma varchar 200 null
vStudentReportsArchiveLatest View FileYear int 4 √ null
pvFutureStudentNames View FutureLegalFullName varchar 150 √ null
vDocuments View MastertDocumentsSeq int 4 √ null
tDocumentsArchive Table SourceRef varchar 100 ('')
pvCommunity View OccupMobilePhoneActual varchar 15 null
NotificationCorrespondence Table ClassificationCode varchar 15 ('')
SystemEmailAttachment Table SysmailLastModUser nvarchar 256 √ null
pvCommunity View DirectoryIncludeFlag bit 1 null
pvFutureStudentNames View ID int 4 null
tDocumentsArchive Table ClassificationCode varchar 15 ('')
vDocumentsWithoutDocumentField View UpdateFlag bit 1 √ null
pvCommunity View WorkWithChildrenCheckRegistrationNumber varchar 30 null
vLoginName View SystemUser nvarchar 256 √ null
vDocumentsWithoutDocumentField View CommunityID int 4 √ null
SystemEmail Table SysmailMailitemID int 4 √ null
SystemEmail Table ParamSensitivity varchar 12 √ null
NotificationCorrespondenceRecipientsReply Table ReceiptID int 4 √ null
vLoginName View CrystalLogin varchar 50 √ null
tDocuments Table MastertDocumentsSeq int 4 √ null
CommunityCorrespondenceAttachments Table sysmail_attachment_id int 4 √ null
pvCommunity View PhysicalRequirements varchar 2147483647 √ null
pvNotificationCorrespondence View NotificationCorrespondenceSeq int 4 null
pvStudentNames View StudentSurname varchar 30 √ null
pvStudentNames View LeavingDateHighIfBlank datetime 16 null
pvFutureStudentNames View FutureNameForwardDetailed varchar 100 √ null
SystemEmailRecipient Table SystemEmailSeq int 4 null
pvCommunity View FacetimeAddress varchar 100 null
pvCommunity View OccupAddress1 varchar 40 null
Photos Table Thumbnail varbinary 2147483647 √ null
StudentReportsArchive Table SystemProcessNumber int 4 √ null
CommunityCorrespondenceRecipients Table CommunityCorrespondenceSeq int 4 null
DocumentReferencesArchive Table ID int 4 null
pvCommunity View MailNamePrimary varchar 100 null
NotificationCorrespondence Table AbsenceEventsSeq int 4 √ null
tDocumentReferences Table RelatedSeq int 4 √ null
pvNotificationCorrespondenceRecipients View ID int 4 null
vDocuments View ClassificationCode varchar 15 null
pvCommunity View GenderSynergyMeaning varchar 30 √ null
SystemEmail Table ParamFileAttachments nvarchar 1073741823 √ null
CommunityCorrespondence Table Recipients varchar 2147483647 √ ('')
pvStudentNames View FileYear smallint 2 null
pvFileSemesters View Description varchar 100 null
pvCommunity View MailNamePrimaryPreferred varchar 123 null
vDocumentsWithoutDocumentField View SourceTable varchar 3 null
vStudentReportsArchiveLatest View UnderlayDocumentType varchar 15 √ null
pvDocumentReferences View SourceTable varchar 3 null
vDocumentsWithoutDocumentField View SourceCode varchar 15 null
pvCommunityCorrespondence View Subject varchar 255 null
wkCommunityCorrespondenceSentDBMail Table RecipientID int 4 √ null
SystemEmail Table SysmailBlindCopyRecipients varchar 2147483647 √ null
CommunityCorrespondenceAttachments Table AttachmentFileName varchar 100 ('')
pvObjectTaskActivities View EmailSender varchar 255 null
pvStudentNames View YearLevel smallint 2 √ null
DebtorStatementsDocuments Table StatementNumber int 4 ((0))
CommunityCorrespondence Table Date datetime 16 √ null
pvCommunity View ID int 4 null
pvCommunity View OccupCode varchar 15 √ null
pvCommunity View DirectoryProvideFlag bit 1 null
pvCommunity View Suffix varchar 20 null
CommunityCorrespondenceRecipients Table CommunityCorrespondenceRecipientsSeq int identity 4 √ null
pvCommunity View UserFlag5 bit 1 null
vDocuments View DocumentCreatedDate datetime 16 null
vDocumentsWithoutDocumentField View ID int 4 √ null
pvStudentNames View LeftFlag bit 1 √ null
SystemEmail Table SysmailImportance varchar 6 √ null
ObjectTaskActivityAttachments Table ObjectTaskActivitiesSeq int 4 null
tDocumentReferencesArchive Table SynDatabaseCode varchar 5 √ null
NotificationCorrespondenceRecipients Table NotificationCorrespondenceSeq int 4 null
StudentReportsArchive Table StudentReportsArchiveSeq int identity 4 √ null
tDocumentReferencesArchive Table tDocumentReferencesArchiveSeq int 4 null
OnlineTemporaryAttachments Table Description varchar 255 √ ('')
SystemEmail Table ParamQueryResultNoPaddingFlag bit 1 ((0))
SynDatabaseLocal Table BuildNumber varchar 30 ('')
tDocuments Table tDocumentsSeq int identity 4 √ null
pvCommunity View IndigenousGroup1Code varchar 15 null
pvCommunity View MobilePhoneActual varchar 15 null
CommunityCorrespondenceAttachments Table CreatedDateTime datetime 16 √ (getdate())
pvFutureStudentNames View Campus varchar 3 null
pvNotificationCorrespondence View Type varchar 15 null
pvCommunity View EthnicGroup1Code varchar 15 null
SynDatabaseLocal Table Type varchar 10 ('')
pvFileSemesters View FileSemestersSeq int identity 4 null
pvCommunity View UserFlag3 bit 1 null
vDocuments View DocumentCreatedByID int 4 √ null
pvCommunity View SpouseID int 4 null
SystemEmailAttachment Table SysmailLastModDate datetime 16 √ null
pvCommunity View MailSalutationJoint varchar 100 null
pvFileSemesters View SIF3RefID uniqueidentifier 16 null
OnlineImportAttachments Table OriginalFileName varchar 100 ('')
pvCommunity View HighestQualificationLevel varchar 15 null
pvCommunity View Education varchar 255 null
NotificationCorrespondence Table SenderID int 4 null
pvDocumentClassificationsUser View SynergyMeaning varchar 30 null
pvCommunity View Comment varchar 2147483647 √ null
NotificationCorrespondence Table Format varchar 15 ('TEXT')
wkCommunityCorrespondenceAttachments Table Seq int identity 4 √ null
DebtorStatementsDocuments Table StatementImage varbinary 2147483647 √ null
pvStudentContacts View ID int 4 null
DebtorStatementsDocumentsPreviewLog Table DebtorStatementsDocumentsPreviewLogSeq int identity 4 √ null
SystemEmailRecipient Table SystemEmailRecipientSeq int identity 4 √ null
SystemEmail Table SysmailBodyFormat varchar 20 √ null
pvCommunityCorrespondence View SenderEmail varchar 100 null
pvCommunity View InitialsOverrideFlag bit 1 null
pvDocumentClassificationsUser View AnyFlag bit 1 √ null
CommunityCorrespondence Table CommunityCorrespondenceSeq int identity 4 √ null
pvNotificationCorrespondenceRecipients View NotificationCorrespondenceSeq int 4 null
pvCommunity View RefugeeFlag bit 1 null
pvStudentNames View Tutor varchar 15 null
pvObjectTaskActivities View StopDate datetime 16 √ null
pvStudentContacts View ContactType varchar 3 null
pvFutureStudentNames View StatusSynergyMeaning varchar 30 √ null
SystemEmailRecipient Table RecipientFlag bit 1 ((0))
tDocumentsArchive Table DocumentThumbnail varbinary 8000 √ null
pvluDocumentClassification View CommPortalVisibleForStudentLivesWithFlag bit 1 null
SynDatabaseLocal Table DatabaseName varchar 50 ('')
pvCommunityCorrespondence View ClassificationCode varchar 15 null
pvNotificationCorrespondenceRecipients View Email varchar 100 null
vDocuments View InsertFlag bit 1 √ null
vDocuments View Description varchar 255 null
pvStudentNames View StatusSynergyMeaning varchar 30 √ null
pvCommunityCorrespondence View ClassificationDescription varchar 100 null
pvCommunity View Given1 varchar 20 null
pvNotificationCorrespondenceRecipients View Content varchar 2147483647 null
tDocumentReferencesArchive Table SortOrder int 4 null
pvStudentNames View StudentPreferred varchar 20 √ null
OnlineTemporaryAttachments Table OriginalFileName varchar 100 ('')
pvCommunity View OccupEmail varchar 100 null
CommunityCorrespondence Table CreatedByID int 4 √ null
pvluDocumentClassification View ActiveFlag bit 1 null
tDocumentsArchive Table DocumentStoredFlag bit 1 √ null
NotificationCorrespondenceRecipientsReply Table ProcessedDateTime datetime 16 √ null
pvCommunity View OccupIndustryCode varchar 8 null
DocumentReferencesArchive Table DocumentReferencesArchiveSeq int 4 √ null
vDocuments View SourceDate datetime 16 null
pvCommunity View WorkWithChildrenCheckStatus varchar 15 null
pvStudentNames View id int 4 null
pvCommunity View IdamLogin varchar 50 null
pvObjectTaskActivities View ObjectTasksSeq int 4 null
pvStudentNames View LOAFlag bit 1 √ null
pvCommunity View EthnicGroup3Code varchar 15 null
vDocumentsWithoutDocumentField View DocumentStoredFlag bit 1 √ null
SystemEmail Table SysmailProfileID int 4 √ null
DebtorStatementsDocumentsPreviewLog Table ViewedByID int 4 √ null
pvCommunityCorrespondence View Date datetime 16 √ null
pvStudentNames View StudentPreferredDetailed varchar 141 √ null
pvStudentNames View BoardingHouse varchar 15 null
vStudentReportsArchiveLatest View FileType varchar 5 null
OnlineTemporaryAttachments Table CreatedDate datetime 16 √ null
SystemEmail Table ParamQueryResultHeaderFlag bit 1 ((1))
pvStudentContacts View ParentFlag bit 1 null
NotificationCorrespondenceRecipientsReply Table CreatedDateTime datetime 16 √ (getdate())
DebtorStatementsDocuments Table DebtorStatementsDocumentsSeq int identity 4 √ null
pvCommunity View MailSalutationPrimaryOverrideFlag bit 1 null
pvNotificationCorrespondenceRecipients View DBMailitemID int 4 √ null
PayrollEmployeeDocuments Table Image varbinary 2147483647 √ null
pvStudentNames View Status varchar 3 null
NotificationCorrespondence Table SystemProcessNumber int 4 √ null
pvNotificationCorrespondenceRecipients View SystemProcessNumber int 4 √ null
StudentReportsArchive Table DocumentType varchar 15 ('')
vStudentReportsArchiveLatest View Description varchar 255 null