Amendment One.docx

SAP

State of South Carolina

AMENDMENT ONE

(Only items highlighted or Q&A are subject to additional questions)

Solicitation:

Date Issued:

Procurement Officer:

Phone:

E-Mail Address:

Mailing Address:

5400020491 12/18/2020

JO MARIE BROWN, CPPO, CPPB

803-896-0670 jmbrown@mmo.sc.gov SFAA, Div. of Procurement Services, MMO PO Box 101103 Columbia SC 29211

DESCRIPTION: Outcomes and Accountability Data System

USING GOVERNMENTAL UNIT: SC Department of Education First Steps

SUBMIT YOUR OFFER ON-LINE AT THE FOLLOWING URL: http://www.procurement.sc.gov

SUBMIT OFFER BY (Opening Date/Time): 1/05/2021 at 11:00 am (See "Deadline For Submission Of Offer" provision)

QUESTIONS MUST BE RECEIVED BY: 12/22/2020 at 3:00 pm (See "Questions From Offerors" provision)

NUMBER OF COPIES TO BE SUBMITTED: One (1) Electronic Technical Proposal, One (1) Electronic Business Proposal, One (1) Electronic Redacted Copy of Technical Proposal marked "Redacted", One (1) Electronic Redacted Copy of Business Proposal marked "Redacted", (See “Submitting Redacted Offers” provision Section IV, “Submitting Confidential Information” Section II.A., & “Electronic Copies-Required Media and Format” provision Section II. B.)

Initial here if NO redacted copy is necessary___________

CONFERENCE TYPE: Non-Mandatory Pre-Proposal DATE & TIME: 12/10/2020 at 1:00 pm

(As appropriate, see "Conferences - Pre-Bid/Proposal" & "Site Visit" provisions) LOCATION: Virtual Conference Meeting link: https://scsfaa.webex.com/scsfaa/j.php?MTID=m561ebc572927effdba198a7349210b8f Meeting number:132 549 8668 Password: p7BM5E5FJT4

You must submit a signed copy of this form with Your Offer. By signing, You agree to be bound by the terms of the Solicitation. You agree to hold Your Offer open for a minimum of sixty (60) calendar days after the Opening Date. (See "Signing Your Offer" provision.)

NAME OF OFFEROR

(full legal name of business submitting the offer) Any award issued will be issued to, and the contract will be formed with, the entity identified as the Offeror. The entity named as the offeror must be a single and distinct legal entity. Do not use the name of a branch office or a division of a larger entity if the branch or division is not a separate legal entity, i.e., a separate corporation, partnership, sole proprietorship, etc.

AUTHORIZED SIGNATURE

(Person must be authorized to submit binding offer to contract on behalf of Offeror.)

DATE SIGNED

TITLE

(business title of person signing above)

STATE VENDOR NO.

(Register to Obtain S.C. Vendor No. at www.procurement.sc.gov)

PRINTED NAME

(printed name of person signing above)

STATE OF INCORPORATION

(If you are a corporation, identify the state of incorporation.)

OFFEROR'S TYPE OF ENTITY: (Check one) (See "Signing Your Offer" provision.)

___ Sole Proprietorship ___ Partnership ___ Other_____________________________

___ Corporate entity (not tax-exempt) ___ Corporation (tax-exempt) ___ Government entity (federal, state, or local)

PAGE TWO

(Return Page Two with Your Offer) HOME OFFICE ADDRESS (Address for offeror's home office / principal place of business)

NOTICE ADDRESS (Address to which all procurement and contract related notices should be sent.) (See "Notice" clause)

_________________________________________________ Area Code - Number - Extension Facsimile

_________________________________________________ E-mail Address

PAYMENT ADDRESS (Address to which payments will be sent.) (See "Payment" clause)

____Payment Address same as Home Office Address ____Payment Address same as Notice Address (check only one) ORDER ADDRESS (Address to which purchase orders will be sent) (See "Purchase Orders and "Contract Documents" clauses)

____Order Address same as Home Office Address ____Order Address same as Notice Address (check only one)

ACKNOWLEDGMENT OF AMENDMENTS

Offerors acknowledges receipt of amendments by indicating amendment number and its date of issue. (See "Amendments to Solicitation" Provision)

DISCOUNT FOR PROMPT PAYMENT

(See "Discount for Prompt Payment" clause)

PREFERENCES - A NOTICE TO VENDORS (SEP. 2009): Preferences do not apply to Request for Proposals per SC Consolidated Procurement Code Section 11-35-1524, e (5)

PREFERENCES - ADDRESS AND PHONE OF IN-STATE OFFICE: Preferences do not apply to Request for Proposals per SC Consolidated Procurement Code Section 11-35-1524, e (5)

____In-State Office Address same as Home Office Address ____In-State Office Address same as Notice Address (check only one)

PAGE TWO (SEP 2009)

End of PAGE TWO

AMENDMENTS TO SOLICITATION (JAN 2004):

(a) The Solicitation may be amended at any time prior to opening. All actual and prospective Offerors should monitor the following web site for the issuance of Amendments: www.procurement.sc.gov(b) Offerors shall acknowledge receipt of any amendment to this solicitation (1) by signing and returning the amendment, (2) by identifying the amendment number and date in the space provided for this purpose on Page Two,

(3) by letter, or (4) by submitting a bid that indicates in some way that the bidder received the amendment. (c) If this solicitation is amended, then all terms and conditions which are not modified remain unchanged.[02-2A005-1]

1. Can you please share the number of children and families to be served annually for SC RFP 5400020491?

At any point in time, there may be over 60,000 active clients. Annually, there are approximately 6,500 children who apply to First Steps 4K, and about 4,500 of them attend a center. Annually, the Local Partnerships serve over 50,000 children, parents, and child care providers through a variety of programs. Enrollment for all programs is done on a rolling basis, and some programs have waiting lists.

2. Has a budget been determined for the annual license, maintenance, and support of a solution? If so, what is the approximate budget estimate?

As stated in the RFP, please provide the cost of annual license, maintenance, and support of the solution for the first five years as part of the response.

3. Are there any other objectives (other than those stated in the overview document) that are driving this initiative?

All objectives are stated in the RFP.

4. Is this project part of a larger internal initiative and/or transformation project ( i.e. cost reduction, panel convergence, program management, etc.)?

No.

5. What strategic/financial impact of this project for your department and the organization as a whole?

The Outcomes and Accountability Data System will help us better serve our clients and to better understand the impact of our programs.

6. Is there an option to do nothing?

The agency needs to replace the system to meet its reporting and statutory requirements.

7. What is the expected date for selection of a solution?

As stated in the RFP, award will be posted on February 4, 2021.

8. What is the expected "Go Live" date for the selected solution?

This should be provided as part of the project timeline, as outlined in the RFP.

9. Are there any repercussions for missing the above selection and go-live dates?

Please see 07-7B102-1 Default in the solicitation for further information. South Carolina Department of Education would review on a per case basis to determine if the Default clause applied.

10. For which years is this project budgeted?

As stated in the RFP, initial contract will be for one year with up to four years of renewal.

11. Who (or which group) is the executive sponsor for this initiative?

South Carolina First Steps is the executive sponsor.

12. What roles and departments are represented among the steering or selection committee for this project?

Members of the Finance and Administration and Strategic Impact teams are on the evaluation panel.

13. What third party consultant(s) are being engaged in the selection and/or are anticipated to be engaged in the selection or implementation of the selected solution?

No third party consultants are being engaged or are anticipated to be engaged in the selection process.

14. What are the biggest challenges for the business related to the current solution and process?

Currently, the First Steps Data Collection (FSDC) System, only the developers can export data, build reports or forms, or make user accounts. For ChildPlus, the biggest challenges are related to data export and report and form building.

15. What are the biggest challenges for the end users within the current solution and process?

Currently, the biggest challenges for end users relate to a lack of efficiency and flexibility.

16. What are the top 3 critical capabilities or features required of the selected solution?

Top three critical features are: child-centric, vendor-hosted, and on-demand.

17. Which of the business (functional) requirements outlined are required for use within the first year of solution deployment?

All requirements are required for use within the first year.

18. Which of the business (functional) requirements outlined are required for use by and within the second year of solution deployment?

All requirements are required for use within the first year.

19. Which of the business (functional) requirements outlined are required for use by and within the third year of solution deployment?

All requirements are required for use within the first year.

20. Which of the business (functional) requirements outlined would be categorized as "nice to have" versus "required"?

All “nice to have” requirements are labelled as “optional features” in the RFP; all other requirements are required.

21. Please describe the expected phases and timeline expectations for deploying the selected solution?

As stated in the RFP, a project timeline must be provided that includes the following deliverables:

· System architecture

· Pilot system

· Data conversion, migration, and quality assurance testing

· Trainings

· Technical documentation

· Full system deployment

22. What are the top success factors for the project?

Top success factors include meeting all requirements and the project timeline/management.

23. How will the top project success factors be measured?

Actual progress compared to the proposed progress detailed in the project timeline. All deliverables outlined in the RFP are met to the agency’s expectations.

24. What roles will be represented within your project team?

Project team will include representatives from programmatic areas, IT, and Senior Management.

25. Is FedRAMP, AWS GovCloud or similar certification/services required for the solution?

All requirements are outlined in the RFP.

26. Which key reports, metrics, and dashboards are provided or supported by the current solution that you would like to maintain?

Overall, key reports include aggregate, unduplicated number of clients served by program/ demographics/ location/ between two points in time and summary data of program milestones/ model fidelity benchmarks.

27. Please identify the systems that will be integrated with XXvendorXX and, for each integration please describe the integration method, if you know.

Right now, no integrations are in place, but the new system should have the ability to integrate.

28. Data Migration is one of the most important factors when estimating implementation timelines, work effort and costs in an implementation. This scoping guide is intended to collect information required to provide accurate estimates for both implementation timeline and related migration costs. Within a migration, it is the migration of historical data and related detail that increases both the level of effort and related costs. XvendorX has found that most successful data migrating clients consider what data is required for current operations and reporting when XvendorX “Goes Live” and what historical data can be maintained in an existing database or is not necessary to migrate or retain.

Noted.

29. Will you be providing resources to extract and clean all data to be migrated?

As stated in the RFP, this is the responsibility of the vendor.

30. If not, would you like XvendorX to recommend a consulting resource to assist with those efforts?

As above, this is the responsibility of the vendor.

31. Would you please provide sample data screens for the systems being converted?

Data dictionaries will be made available.

32. please identify the number of matter repositories from where data will be migrated and please identify each repository by name. If you anticipate migrating matter from more than one repository please respond with information for each repository.

As stated in the RFP, there are two current databases from which data will be migrated: (1) ChildPlus (First Steps 4K); (2) First Steps Data Collection System (First Steps Local Partnerships).

33. Number of Repositories from where records will be migrated

As stated in the RFP, there are two current databases from which data will be migrated: (1) ChildPlus (First Steps 4K); (2) First Steps Data Collection System (First Steps Local Partnerships).

34. Approximate number of records you anticipate migrating from each repository

As stated in the RFP, there are two current databases from which data will be migrated: (1) ChildPlus (First Steps 4K), which has approximately 30,000 records; (2) First Steps Data Collection System (First Steps Local Partnerships), which has approximately 500,000 records.

35. Approximate number of Open and Active Records

As stated in the RFP, at any point in time, there may be over 60,000 active clients. Annually, there are approximately 6,500 children who apply to First Steps 4K, and about 4,500 of them attend a center. Annually, the LPs serve over 50,000 children, parents, and child care providers through a variety of programs. Enrollment for all programs is done on a rolling basis, and some programs have waiting lists.

36. Approximate number of Closed Records

There are approximately 470,000 closed records.

37. How many years of record data do you anticipate migrating?

The FSDC has over twenty years of data, and ChildPlus has approximately five years of data. We anticipate that all of ChildPlus will be migrated, and for the FSDC, the vendor and First Steps will work together to determine the appropriate years of data to migrate.

38. Approximate number and description of Record Types and File Types

The vendor and First Steps will work together to determine the record and file types to be migrated.

39. Estimated number of unique record fields to be migrated

The vendor and First Steps will work together to determine the number of unique record fields to be migrated.

40. Approximate size of all documents to be migrated

The vendor and First Steps will work together to determine the size of all documents to be migrated.

41. Is the expectation that the system be fully implemented with all requirements in the RFP by 2/15/22, with the 4 optional extension years for maintenance and minor enhancements only?

The expectation is that the system will be fully implemented by 2/15/23 (24 months from award date), with the 3 optional extension years for maintenance and minor enhancements.

42. Please describe the extent to which the system will need to accommodate the following: • Online forms / templates; • External data connectivity; • Analysis of data joined from multiple sources; and • Internally-integrated (internal to the system) business logic or processes.

The requirements for each of these are detailed in the RFP.SAP

SAP

SAP

IX. ATTACHMENTS TO SOLICITATION

Double-Click to open documents

1. CP Data Dictionary

2. FSDC Dictionary Draft

Page Page image1.emf

CP DATA DICTIONARY.xlsx

CP DATA DICTIONARY

TABLE_NAME COLUMN_NAME DATA TYPE DEFAULT VALUE CHARACTER MAXIMUM LENGTH NUMERIC PRECISION

AddOn Active bit ((0)) NULL NULL

AddOn AddOnGalleryID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOn AddOnID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOn ClientVersionOnCreateDate varchar ('') 20 NULL

AddOn ClusterID bigint NULL NULL 19

AddOn CreatedByUserID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOn CreatedDate datetime NULL NULL NULL

AddOn CreatedFromGalleryDateTime datetime NULL NULL NULL

AddOn Definition varchar ('') -1 NULL

AddOn EnableEntryExpress bit ('0') NULL NULL

AddOn LastEditedByUserID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOn LastEditedDate datetime NULL NULL NULL

AddOn Name varchar ('') 50 NULL

AddOn NextSqlColumnNameInt int ((0)) NULL 10

AddOn RelatesTo int ((0)) NULL 10

AddOn ServiceArea int ((0)) NULL 10

AddOn SqlTableName varchar ('') 30 NULL

AddOn TIMESTAMP timestamp NULL NULL NULL

AddOnAgency AddOnID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnAgency AgencyID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnAgency ClusterID bigint NULL NULL 19

AddOnAgency TIMESTAMP timestamp NULL NULL NULL

AddOnFamilyServiceEventType AddOnID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnFamilyServiceEventType FamilyServiceEventTypeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnFamilyServiceEventType TIMESTAMP timestamp NULL NULL NULL

AddOnHealthEventType AddOnID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnHealthEventType HealthEventTypeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnHealthEventType TIMESTAMP timestamp NULL NULL NULL

AddOnHistory Active bit ((0)) NULL NULL

AddOnHistory AddOnGalleryID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnHistory AddOnHistoryID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnHistory AddOnID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnHistory ClientVersionOnCreateDate varchar ('') 20 NULL

AddOnHistory ClusterID bigint NULL NULL 19

AddOnHistory CreatedByUserID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnHistory CreatedDate datetime NULL NULL NULL

AddOnHistory CreatedFromGalleryDateTime datetime NULL NULL NULL

AddOnHistory Definition varchar ('') -1 NULL

AddOnHistory LastEditedByUserID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnHistory LastEditedDate datetime NULL NULL NULL

AddOnHistory Name varchar ('') 50 NULL

AddOnHistory NextSqlColumnNameInt int ((0)) NULL 10

AddOnHistory RelatesTo int ((0)) NULL 10

AddOnHistory ServiceArea int ((0)) NULL 10

AddOnHistory SqlTableName varchar ('') 30 NULL

AddOnNextRecordID AddOnID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnNextRecordID ClusterID bigint NULL NULL 19

AddOnNextRecordID NextRecordID int ((0)) NULL 10

AddOnReports AddOnID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnReports ClusterID int NULL NULL 10

AddOnReports Definition varchar ('') -1 NULL

AddOnReports IncludeInStandardReportCategory smallint ((0)) NULL 5

AddOnReports Name varchar ('') 300 NULL

AddOnReports Number varchar ('') 30 NULL

AddOnReports ReportDesignType tinyint ((0)) NULL 3

AddOnReports ReportID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnReports TIMESTAMP timestamp NULL NULL NULL

AddOnUserGroup AddOnID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AddOnUserGroup ClusterID bigint NULL NULL 19

AddOnUserGroup SecurityLevel tinyint ((0)) NULL 3

AddOnUserGroup TIMESTAMP timestamp NULL NULL NULL

AddOnUserGroup UserGroupID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Address Address1 varchar ('') 32 NULL

Address Address2 varchar ('') 32 NULL

Address AddressID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Address AddressType int ((0)) NULL 10

Address City varchar ('') 20 NULL

Address ClusterID int NULL NULL 10

Address Comment varchar ('') -1 NULL

Address County varchar ('') 3 NULL

Address EndDate datetime NULL NULL NULL

Address FamilyID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Address StartDate datetime NULL NULL NULL

Address State varchar ('') 2 NULL

Address Zip varchar ('') 10 NULL

Agency Active bit 0 NULL NULL

Agency AgencyID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Agency AgencyName varchar ('') 35 NULL

Agency CCNETIntegrated bit 0 NULL NULL

Agency CopyLocationsOnAccept bit ((1)) NULL NULL

Agency CopyLocationsOnEnroll bit ((1)) NULL NULL

Agency DrdpExportAgencyName varchar ('') 125 NULL

Agency Email varchar ('') 60 NULL

Agency Extension varchar ('') 10 NULL

Agency Fax varchar ('') 14 NULL

Agency LacoeAgencyTypeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Agency Logo varbinary (NULL) -1 NULL

Agency MailingAddress1 varchar ('') 30 NULL

Agency MailingAddress2 varchar ('') 30 NULL

Agency MailingCity varchar ('') 15 NULL

Agency MailingState varchar ('') 2 NULL

Agency MailingZip varchar ('') 10 NULL

Agency MailSameAsPhysical bit 0 NULL NULL

Agency Notes varchar ('') -1 NULL

Agency Phone varchar ('') 14 NULL

Agency PhysicalAddress1 varchar ('') 30 NULL

Agency PhysicalAddress2 varchar ('') 30 NULL

Agency PhysicalCity varchar ('') 15 NULL

Agency PhysicalState varchar ('') 2 NULL

Agency PhysicalZip varchar ('') 10 NULL

Agency RestrictEnrollmentByServiceArea bit ((0)) NULL NULL

Agency RestrictEnrollmentByZipCode bit ((0)) NULL NULL

Agency TaxID varchar ('') 20 NULL

Agency TIMESTAMP timestamp NULL NULL NULL

Agency Website varchar ('') 75 NULL

AgencyFunding Active bit 0 NULL NULL

AgencyFunding AgencyFundingID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AgencyFunding AgencyID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AgencyFunding Amount numeric 0 NULL 12

AgencyFunding BeginDate datetime NULL NULL NULL

AgencyFunding DelegateNumber varchar ('') 3 NULL

AgencyFunding DirectorPersonID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AgencyFunding EndDate datetime NULL NULL NULL

AgencyFunding FundedEnrollment int 0 NULL 10

AgencyFunding FundingID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AgencyFunding ProgramID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AgencyFunding TIMESTAMP timestamp NULL NULL NULL

AgencyZipCodesServed AgencyID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AgencyZipCodesServed TIMESTAMP timestamp NULL NULL NULL

AgencyZipCodesServed ZipCode varchar ('') 5 NULL

AgencyZipCodesServed ZipCodeID uniqueidentifier (newid()) NULL NULL

AgeRangeSets Age1 tinyint 0 NULL 3

AgeRangeSets Age2 tinyint 0 NULL 3

AgeRangeSets Age3 tinyint 0 NULL 3

AgeRangeSets Age4 tinyint 0 NULL 3

AgeRangeSets Age5 tinyint 0 NULL 3

AgeRangeSets AgeRangeSetsID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AgeRangeSets AgeUnit char ('') 1 NULL

AgeRangeSets Name varchar ('') 50 NULL

Attachment AttachedByUserID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Attachment AttachedDate datetime NULL NULL NULL

Attachment Attachment varbinary NULL -1 NULL

Attachment AttachmentDatabaseName nvarchar (NULL) 128 NULL

Attachment AttachmentID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Attachment AttachmentNotes varchar ('') -1 NULL

Attachment AttachmentTypeCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Attachment ClusterID int NULL NULL 10

Attachment Description varchar ('') 40 NULL

Attachment FileName varchar ('') -1 NULL

Attachment FileSize bigint ((0)) NULL 19

Attachment ModuleID int ((0)) NULL 10

AttachmentAttendanceHeader AttachmentID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentAttendanceHeader AttendanceHeaderID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentAttendanceHeader ClusterID int NULL NULL 10

AttachmentCLASSObservation AttachmentID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentCLASSObservation ClusterID int NULL NULL 10

AttachmentCLASSObservation ObservationID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentCLASSObservationInfant AttachmentID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentCLASSObservationInfant ClusterID int NULL NULL 10

AttachmentCLASSObservationInfant ObservationID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentCLASSObservationToddler AttachmentID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentCLASSObservationToddler ObservationID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentCommunityResource AttachmentID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentCommunityResource ClusterID int NULL NULL 10

AttachmentCommunityResource CommunityResourceID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentFamily AttachmentID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentFamily ClusterID int NULL NULL 10

AttachmentFamily FamilyID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentMonitoringReview AttachmentID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentMonitoringReview ClusterID int NULL NULL 10

AttachmentMonitoringReview MonitoringReviewID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentPerson AttachmentID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentPerson ClusterID int NULL NULL 10

AttachmentPerson PersonID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentThumbnails AttachmentID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentThumbnails ClusterID int NULL NULL 10

AttachmentThumbnails Thumbnail varbinary NULL -1 NULL

AttachmentTrainingEvent AttachmentID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttachmentTrainingEvent ClusterID int NULL NULL 10

AttachmentTrainingEvent TrainingEventID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Attendance AbsenceReasonCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Attendance AMSnackTime datetime NULL NULL NULL

Attendance ArrivalTime varchar ('') 8 NULL

Attendance AteAMSnack bit 0 NULL NULL

Attendance AteBreakfast bit 0 NULL NULL

Attendance AteLunch bit 0 NULL NULL

Attendance AtePMSnack bit 0 NULL NULL

Attendance AteSupper bit 0 NULL NULL

Attendance AttendanceCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Attendance AttendanceDate datetime NULL NULL NULL

Attendance AttendanceHeaderID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Attendance AttendanceID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Attendance AttendanceNotes varchar ('') -1 NULL

Attendance BreakfastTime datetime NULL NULL NULL

Attendance CACFPReimbursementLevelCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Attendance ClusterID int NULL NULL 10

Attendance DayOfWeek int -1 NULL 10

Attendance DepartureTime varchar ('') 8 NULL

Attendance LocationID uniqueidentifier (NULL) NULL NULL

Attendance LocationStatusID_deprecated uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Attendance LunchTime datetime NULL NULL NULL

Attendance PMSnackTime datetime NULL NULL NULL

Attendance ScanInTime datetime NULL NULL NULL

Attendance ScanOutTime datetime NULL NULL NULL

Attendance SupperTime datetime NULL NULL NULL

Attendance WeekStartingDate datetime NULL NULL NULL

AttendanceFollowUp AttendanceFollowUpID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttendanceFollowUp ClusterID int NULL NULL 10

AttendanceFollowUp CompletedDate datetime NULL NULL NULL

AttendanceFollowUp DueDate datetime NULL NULL NULL

AttendanceFollowUp FollowUpTypeCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttendanceFollowUp Notes varchar ('') -1 NULL

AttendanceFollowUp ProgramParticipationID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttendanceFollowUp ResponsibleStaffID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttendanceHeader AttendanceDate datetime NULL NULL NULL

AttendanceHeader AttendanceHeaderID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttendanceHeader CACFPNonParticipantAMSnack smallint 0 NULL 5

AttendanceHeader CACFPNonParticipantBreakfast smallint 0 NULL 5

AttendanceHeader CACFPNonParticipantLunch smallint 0 NULL 5

AttendanceHeader CACFPNonParticipantPMSnack smallint 0 NULL 5

AttendanceHeader CACFPNonParticipantSupper smallint 0 NULL 5

AttendanceHeader ClassroomID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttendanceHeader ClusterID int NULL NULL 10

AttendanceHeader CreatedBy uniqueidentifier (NULL) NULL NULL

AttendanceHeader CreatedDate datetime NULL NULL NULL

AttendanceHeader DayOfWeek int ((1)) NULL 10

AttendanceHeader NonCACFPNonParticipantAMSnack smallint 0 NULL 5

AttendanceHeader NonCACFPNonParticipantBreakfast smallint 0 NULL 5

AttendanceHeader NonCACFPNonParticipantLunch smallint 0 NULL 5

AttendanceHeader NonCACFPNonParticipantPMSnack smallint 0 NULL 5

AttendanceHeader NonCACFPNonParticipantSupper smallint 0 NULL 5

AttendanceHeader Notes varchar ('') -1 NULL

AttendanceHeader OpenStatusCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttendanceHeader UpdatedBy uniqueidentifier (NULL) NULL NULL

AttendanceHeader UpdatedDate datetime NULL NULL NULL

AttendanceHeader WeekStartingDate datetime NULL NULL NULL

AttendancePreferences AttendanceCodeADAStatus tinyint NULL NULL 3

AttendancePreferences AttendanceCodeID uniqueidentifier NULL NULL NULL

AttendancePreferences ClusterID int NULL NULL 10

AttendanceSignature AttendanceID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AttendanceSignature CheckInSignature image NULL 2147483647 NULL

AttendanceSignature CheckOutSignature image NULL 2147483647 NULL

AttendanceSignature ClusterID int NULL NULL 10

AuditLog AuditLogID int NULL NULL 10

AuditLog RecordLookupID int ((0)) NULL 10

AuditLog TableID tinyint ((0)) NULL 3

AuditLog TransactionID int ((0)) NULL 10

AuditLog UpdateType tinyint ((0)) NULL 3

AuditLogConfig EnableLogging bit ((0)) NULL NULL

AuditLogConfig ModuleID int ((0)) NULL 10

AuditLogConfig TIMESTAMP timestamp NULL NULL NULL

AuditLogDeletedEntities Description varchar ('') 100 NULL

AuditLogDeletedEntities ParentLookupID int ((0)) NULL 10

AuditLogDeletedEntities RecordLookupID int ((0)) NULL 10

AuditLogDeletedEntities TableID tinyint ((0)) NULL 3

AuditLogField AllowLogging bit ((1)) NULL NULL

AuditLogField Description varchar ('') 100 NULL

AuditLogField FieldID smallint NULL NULL 5

AuditLogField FieldName varchar ('') 100 NULL

AuditLogField ModuleID int ((0)) NULL 10

AuditLogField PrimaryKeyColumn1 varchar ('') 60 NULL

AuditLogField PrimaryKeyColumn2 varchar ('') 60 NULL

AuditLogField TableName varchar ('') 100 NULL

AuditLogFieldEdit AuditLogID int ((0)) NULL 10

AuditLogFieldEdit ClusterID int NULL NULL 10

AuditLogFieldEdit FieldID smallint ((0)) NULL 5

AuditLogFieldEdit NewValue varchar ('') -1 NULL

AuditLogFieldEdit OldValue varchar ('') -1 NULL

AuditLogGuidLookup ExtraID1 uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

AuditLogGuidLookup LookupID int NULL NULL 10

AuditLogGuidLookup NonGuidExtraID1 tinyint (NULL) NULL 3

AuditLogGuidLookup NonGuidRecordID tinyint (NULL) NULL 3

AuditLogGuidLookup RecordID uniqueidentifier NULL NULL NULL

AuditLogTransaction ModuleID int ((0)) NULL 10

AuditLogTransaction PlatformType tinyint ((0)) NULL 3

AuditLogTransaction TransactionDate datetime NULL NULL NULL

AuditLogTransaction TransactionID int NULL NULL 10

AuditLogTransaction UserLookupID int ((0)) NULL 10

AuditLogTransactionEntities ClusterID int NULL NULL 10

AuditLogTransactionEntities EntityLookupID int ((0)) NULL 10

AuditLogTransactionEntities TransactionID int ((0)) NULL 10

Birth APGARScore1Minute tinyint 0 NULL 3

Birth APGARScore5Minutes tinyint 0 NULL 3

Birth BabyProblems tinyint 0 NULL 3

Birth BabyProblemsNotes varchar ('') 60 NULL

Birth BirthCertificate varchar ('') 20 NULL

Birth BirthCity varchar ('') 20 NULL

Birth BirthFacility varchar ('') 32 NULL

Birth BirthHistoryNotes varchar ('') -1 NULL

Birth BirthState varchar ('') 2 NULL

Birth ClusterID int NULL NULL 10

Birth DeliveryCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Birth DeliveryComplications varchar ('') 60 NULL

Birth FacilityTypeCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Birth Gestation varchar ('') 2 NULL

Birth GestationUnknown bit 0 NULL NULL

Birth HeadSize varchar ('') 10 NULL

Birth Length varchar ('') 10 NULL

Birth LengthofStay varchar ('') 10 NULL

Birth MotherProblems tinyint 0 NULL 3

Birth MotherProblemsNotes varchar ('') 60 NULL

Birth ObservableDefects varchar ('') 60 NULL

Birth Ounces tinyint 0 NULL 3

Birth PersonID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Birth Pounds tinyint 0 NULL 3

BirthCondition BirthConditionID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

BirthCondition ClusterID int NULL NULL 10

BirthCondition MedicalProblemsCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

BirthCondition PersonID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

BusRider Address1 varchar ('') 32 NULL

BusRider Address2 varchar ('') 32 NULL

BusRider BeginDate datetime NULL NULL NULL

BusRider BusRiderID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

BusRider BusRouteID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

BusRider City varchar ('') 20 NULL

BusRider ClusterID int NULL NULL 10

BusRider EndDate datetime NULL NULL NULL

BusRider HomeAddress bit 0 NULL NULL

BusRider Notes varchar ('') -1 NULL

BusRider PersonID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

BusRider RidesFriday bit 0 NULL NULL

BusRider RidesMonday bit 0 NULL NULL

BusRider RidesSaturday bit 0 NULL NULL

BusRider RidesSunday bit 0 NULL NULL

BusRider RidesThursday bit 0 NULL NULL

BusRider RidesTuesday bit 0 NULL NULL

BusRider RidesWednesday bit 0 NULL NULL

BusRider State varchar ('') 2 NULL

BusRider StopNumber int 0 NULL 10

BusRider Zip varchar ('') 10 NULL

BusRoute AgencyID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

BusRoute AgencyProvided bit 0 NULL NULL

BusRoute ArriveTime varchar ('') 8 NULL

BusRoute BusNumber varchar ('') 15 NULL

BusRoute BusRouteID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

BusRoute ClusterID int NULL NULL 10

BusRoute DepartTime varchar ('') 8 NULL

BusRoute Destination varchar ('') 30 NULL

BusRoute DriverPersonID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

BusRoute OldRouteID varchar ('') 2 NULL

BusRoute Origin varchar ('') 30 NULL

BusRoute RouteLabel varchar ('') 30 NULL

BusRoute RouteTypeCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

BusRoute RunsFriday bit 0 NULL NULL

BusRoute RunsMonday bit 0 NULL NULL

BusRoute RunsSaturday bit 0 NULL NULL

BusRoute RunsSunday bit 0 NULL NULL

BusRoute RunsThursday bit 0 NULL NULL

BusRoute RunsTuesday bit 0 NULL NULL

BusRoute RunsWednesday bit 0 NULL NULL

BusRoute SiteID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Cache ClusterID int NULL NULL 10

Cache DeletedAt datetime NULL NULL NULL

Cache TableName varchar ('') 64 NULL

Calendar Active bit ((0)) NULL NULL

Calendar AgencyID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Calendar CalendarID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Calendar ClusterID int NULL NULL 10

Calendar Name varchar ('') 100 NULL

Calendar OwnerID uniqueidentifier (NULL) NULL NULL

CalendarEvent AllDayEvent bit ((0)) NULL NULL

CalendarEvent CalendarEventID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CalendarEvent CalendarID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CalendarEvent ClusterID int NULL NULL 10

CalendarEvent CreatedByID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CalendarEvent CreationDate datetime NULL NULL NULL

CalendarEvent Description varchar ('') 200 NULL

CalendarEvent EndDate datetime NULL NULL NULL

CalendarEvent Notes varchar ('') -1 NULL

CalendarEvent ReminderInfo varchar ('') 300 NULL

CalendarEvent ServiceArea tinyint ((0)) NULL 3

CalendarEvent StartDate datetime NULL NULL NULL

CalendarUser CalendarID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CalendarUser ClusterID int NULL NULL 10

CalendarUser SecurityLevel tinyint ((4)) NULL 3

CalendarUser UserID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CFCategory CategoryName varchar ('') 50 NULL

CFCategory CFCategoryID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CFCategory QueryText varchar ('') -1 NULL

CFCategory TIMESTAMP timestamp NULL NULL NULL

CFCategoryFilterType CFCategoryID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CFCategoryFilterType ClusterID int NULL NULL 10

CFCategoryFilterType JoinArea varchar ('') 64 NULL

CFCategoryFilterType JoinField varchar ('') 64 NULL

CFCategoryFilterType JoinTable varchar ('') 64 NULL

CFCategoryFilterType SortOrder int 0 NULL 10

CFCategoryFilterType TIMESTAMP timestamp NULL NULL NULL

CFCategoryTable CFCategoryID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CFCategoryTable CFTableID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CFExpression CFExpressionID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CFExpression CFFieldID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CFExpression CFTableID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CFExpression CodeDisplayValue varchar ('') 100 NULL

CFExpression CustomFilterID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CFExpression LeftParen int 0 NULL 10

CFExpression ManualEntry bit 0 NULL NULL

CFExpression ManualEntryName varchar ('') 64 NULL

CFExpression ManualEntrySQL varchar ('') 6000 NULL

CFExpression Operator int 0 NULL 10

CFExpression RightParen int 0 NULL 10

CFExpression SortOrder int 0 NULL 10

CFExpression UnionType varchar ('') 3 NULL

CFExpression Value varchar ('') 256 NULL

CFField AllowInCustomFilter bit -1 NULL NULL

CFField CFFieldID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CFField CFTableID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CFField DataType varchar ('varchar') 20 NULL

CFField DataTypeLength varchar ('20') 6 NULL

CFField Expression varchar ('') 7750 NULL

CFField FieldDescription varchar ('') 100 NULL

CFField FieldName varchar ('') 64 NULL

CFField TableName varchar ('') 32 NULL

CFField TIMESTAMP timestamp NULL NULL NULL

CFTable CFTableID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CFTable Name varchar ('') 64 NULL

CFTable TIMESTAMP timestamp NULL NULL NULL

CLASSObservation BM numeric ((0.0)) NULL 3

CLASSObservation CD numeric ((0.0)) NULL 3

CLASSObservation ClusterID int NULL NULL 10

CLASSObservation ILF numeric ((0.0)) NULL 3

CLASSObservation LM numeric ((0.0)) NULL 3

CLASSObservation NC numeric ((0.0)) NULL 3

CLASSObservation Notes varchar ('') -1 NULL

CLASSObservation ObservationDate datetime NULL NULL NULL

CLASSObservation ObservationID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservation ObserverID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservation PC numeric ((0.0)) NULL 3

CLASSObservation PD numeric ((0.0)) NULL 3

CLASSObservation ProgramTermClassroomID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservation QF numeric ((0.0)) NULL 3

CLASSObservation RSP numeric ((0.0)) NULL 3

CLASSObservation TeacherID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservation TS numeric ((0.0)) NULL 3

CLASSObservationInfant ELS numeric ((0.0)) NULL 3

CLASSObservationInfant FE numeric ((0.0)) NULL 3

CLASSObservationInfant Notes varchar ('') -1 NULL

CLASSObservationInfant ObservationDate datetime NULL NULL NULL

CLASSObservationInfant ObservationID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservationInfant ObserverID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservationInfant ProgramTermClassroomID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservationInfant RC numeric ((0.0)) NULL 3

CLASSObservationInfant TeacherID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservationInfant TS numeric ((0.0)) NULL 3

CLASSObservationPeriod Active bit ((1)) NULL NULL

CLASSObservationPeriod BeginDate datetime NULL NULL NULL

CLASSObservationPeriod ClusterID int NULL NULL 10

CLASSObservationPeriod EndDate datetime NULL NULL NULL

CLASSObservationPeriod Name varchar ('') 50 NULL

CLASSObservationPeriod ObservationPeriodID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservationToddler BG numeric ((0.0)) NULL 3

CLASSObservationToddler FLD numeric ((0.0)) NULL 3

CLASSObservationToddler LM numeric ((0.0)) NULL 3

CLASSObservationToddler NC numeric ((0.0)) NULL 3

CLASSObservationToddler Notes varchar ('') -1 NULL

CLASSObservationToddler ObservationDate datetime NULL NULL NULL

CLASSObservationToddler ObservationID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservationToddler ObserverID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservationToddler PC numeric ((0.0)) NULL 3

CLASSObservationToddler ProgramTermClassroomID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservationToddler QF numeric ((0.0)) NULL 3

CLASSObservationToddler RCP numeric ((0.0)) NULL 3

CLASSObservationToddler TeacherID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSObservationToddler TS numeric ((0.0)) NULL 3

Classroom Active bit ((1)) NULL NULL

Classroom Aide2PersonID_deprecated uniqueidentifier NULL NULL NULL

Classroom Aide3PersonID_deprecated uniqueidentifier NULL NULL NULL

Classroom Aide4PersonID_deprecated uniqueidentifier NULL NULL NULL

Classroom AidePersonID_deprecated uniqueidentifier NULL NULL NULL

Classroom BeginTime_deprecated varchar NULL 8 NULL

Classroom ClassCapacity tinyint 0 NULL 3

Classroom ClassName varchar ('') 25 NULL

Classroom ClassroomID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Classroom ClassroomLabel varchar ('') 1 NULL

Classroom ClusterID int NULL NULL 10

Classroom EndTime_deprecated varchar NULL 8 NULL

Classroom MaxAgeMonths_deprecated tinyint NULL NULL 3

Classroom MaxAgeYears_deprecated tinyint NULL NULL 3

Classroom MinAgeMonths_deprecated tinyint NULL NULL 3

Classroom MinAgeYears_deprecated tinyint NULL NULL 3

Classroom SiteID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Classroom SystemDefined bit 0 NULL NULL

Classroom Teacher2PersonID_deprecated uniqueidentifier NULL NULL NULL

Classroom TeacherPersonID_deprecated uniqueidentifier NULL NULL NULL

Classroom TIMESTAMP timestamp NULL NULL NULL

Classroom TotalTime_deprecated varchar NULL 5 NULL

Classroom TSGoldClassID int ((0)) NULL 10

Classroom TSGoldIntegrated bit ((0)) NULL NULL

CLASSThreshold Active bit ((1)) NULL NULL

CLASSThreshold BM numeric ((0.0)) NULL 3

CLASSThreshold CD numeric ((0.0)) NULL 3

CLASSThreshold ClassroomOrganization numeric ((0.0)) NULL 3

CLASSThreshold ClusterID int NULL NULL 10

CLASSThreshold EmotionalSupport numeric ((0.0)) NULL 3

CLASSThreshold ILF numeric ((0.0)) NULL 3

CLASSThreshold InstructionalSupport numeric ((0.0)) NULL 3

CLASSThreshold LM numeric ((0.0)) NULL 3

CLASSThreshold Name varchar ('') 50 NULL

CLASSThreshold NC numeric ((0.0)) NULL 3

CLASSThreshold PC numeric ((0.0)) NULL 3

CLASSThreshold PD numeric ((0.0)) NULL 3

CLASSThreshold QF numeric ((0.0)) NULL 3

CLASSThreshold RSP numeric ((0.0)) NULL 3

CLASSThreshold SystemDefined tinyint ((0)) NULL 3

CLASSThreshold ThresholdID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSThreshold TS numeric ((0.0)) NULL 3

CLASSThresholdInfant Active bit ((1)) NULL NULL

CLASSThresholdInfant ClusterID int NULL NULL 10

CLASSThresholdInfant ELS numeric ((0.0)) NULL 3

CLASSThresholdInfant FE numeric ((0.0)) NULL 3

CLASSThresholdInfant Name varchar ('') 50 NULL

CLASSThresholdInfant RC numeric ((0.0)) NULL 3

CLASSThresholdInfant ResponsiveCaregiving numeric ((0.0)) NULL 3

CLASSThresholdInfant SystemDefined tinyint ((0)) NULL 3

CLASSThresholdInfant ThresholdID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSThresholdInfant TS numeric ((0.0)) NULL 3

CLASSThresholdToddler Active bit ((1)) NULL NULL

CLASSThresholdToddler BG numeric ((0.0)) NULL 3

CLASSThresholdToddler ClusterID int NULL NULL 10

CLASSThresholdToddler EmotionalSupport numeric ((0.0)) NULL 3

CLASSThresholdToddler EngagedSupport numeric ((0.0)) NULL 3

CLASSThresholdToddler FLD numeric ((0.0)) NULL 3

CLASSThresholdToddler LM numeric ((0.0)) NULL 3

CLASSThresholdToddler Name varchar ('') 50 NULL

CLASSThresholdToddler NC numeric ((0.0)) NULL 3

CLASSThresholdToddler PC numeric ((0.0)) NULL 3

CLASSThresholdToddler QF numeric ((0.0)) NULL 3

CLASSThresholdToddler RCP numeric ((0.0)) NULL 3

CLASSThresholdToddler SystemDefined tinyint ((0)) NULL 3

CLASSThresholdToddler ThresholdID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CLASSThresholdToddler TS numeric ((0.0)) NULL 3

Code Actid varchar ('') 10 NULL

Code Active bit 0 NULL NULL

Code Code varchar ('') 3 NULL

Code CodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Code CodeType varchar ('') 11 NULL

Code Description varchar ('') 125 NULL

Code SpanishDescription nvarchar ('') 125 NULL

Code SystemDefined bit 0 NULL NULL

Code TIMESTAMP timestamp NULL NULL NULL

CodeType CodeType varchar ('') 11 NULL

CodeType Description varchar ('') 100 NULL

CodeType SupportsSpanish bit ((0)) NULL NULL

CodeType UserMaintainable bit 0 NULL NULL

CommunityResource Active bit 0 NULL NULL

CommunityResource AgencyID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CommunityResource Apply varchar ('') -1 NULL

CommunityResource ClusterID int NULL NULL 10

CommunityResource CommunityResourceID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CommunityResource Contact varchar ('') 50 NULL

CommunityResource County varchar ('') 3 NULL

CommunityResource Directions varchar ('') -1 NULL

CommunityResource Email varchar ('') 50 NULL

CommunityResource Fax varchar ('') 14 NULL

CommunityResource MailAddress1 varchar ('') 32 NULL

CommunityResource MailAddress2 varchar ('') 32 NULL

CommunityResource MailCity varchar ('') 20 NULL

CommunityResource MailSameAsPhysical bit 0 NULL NULL

CommunityResource MailState varchar ('') 2 NULL

CommunityResource MailZip varchar ('') 10 NULL

CommunityResource Notes varchar ('') -1 NULL

CommunityResource Phone1 varchar ('') 14 NULL

CommunityResource Phone2 varchar ('') 14 NULL

CommunityResource PhysicalAddress1 varchar ('') 32 NULL

CommunityResource PhysicalAddress2 varchar ('') 32 NULL

CommunityResource PhysicalCity varchar ('') 20 NULL

CommunityResource PhysicalState varchar ('') 2 NULL

CommunityResource PhysicalZip varchar ('') 10 NULL

CommunityResource ResourceName varchar ('') 32 NULL

CommunityResource ServiceArea varchar ('') -1 NULL

CommunityResource ServicesRendered varchar ('') -1 NULL

CommunityResource ShortName varchar ('') 8 NULL

CommunityResource SiteID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CommunityResource Specialty varchar ('') 30 NULL

CommunityResource TIMESTAMP timestamp NULL NULL NULL

CommunityResource TypeDentist bit 0 NULL NULL

CommunityResource TypeDoctor bit 0 NULL NULL

CommunityResource TypeHealthCenter bit 0 NULL NULL

CommunityResource TypeLea bit ((0)) NULL NULL

CommunityResource TypeMentalHealthCenter bit 0 NULL NULL

CommunityResource TypePartCAgency bit ((0)) NULL NULL

CommunityResource TypeSocialService bit 0 NULL NULL

CommunityResource Website varchar ('') 100 NULL

Contact Address1 varchar ('') 32 NULL

Contact Address2 varchar ('') 32 NULL

Contact City varchar ('') 20 NULL

Contact ClusterID int NULL NULL 10

Contact ContactID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Contact Name varchar ('') 32 NULL

Contact Phone1 varchar ('') 14 NULL

Contact Phone1Ext varchar ('') 10 NULL

Contact Phone1TypeCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Contact Phone2 varchar ('') 14 NULL

Contact Phone2Ext varchar ('') 10 NULL

Contact Phone2TypeCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Contact Phone3 varchar ('') 14 NULL

Contact Phone3Ext varchar ('') 10 NULL

Contact Phone3TypeCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Contact Phone4 varchar ('') 14 NULL

Contact Phone4Ext varchar ('') 10 NULL

Contact Phone4TypeCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

Contact State varchar ('') 2 NULL

Contact Zip varchar ('') 10 NULL

ContactPicture ClusterID int NULL NULL 10

ContactPicture ContactID uniqueidentifier NULL NULL NULL

ContactPicture Picture image NULL 2147483647 NULL

CustomFilter CFCategoryID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CustomFilter CustomFilterDisplayText varchar ('') -1 NULL

CustomFilter CustomFilterID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CustomFilter CustomFilterName varchar ('') 50 NULL

CustomFilter GroupCodeID uniqueidentifier ('00000000-0000-0000-0000-000000000000') NULL NULL

CustomFilter InvalidatedDueToUpdate bit ('0') NULL NULL

CustomFilter TIMESTAMP timestamp NULL NULL NULL

DashboardCacheClassroomData AcceptedCount int NULL NULL 10

DashboardCacheClassroomData AttendanceAbsentCountLastMonth int NULL NULL 10

DashboardCacheClassroomData AttendanceAbsentCountMTD int NULL NULL 10

DashboardCacheClassroomData AttendanceAbsentCountYTD int NULL NULL 10

DashboardCacheClassroomData AttendanceNeitherCountLastMonth int NULL NULL 10

DashboardCacheClassroomData AttendanceNeitherCountMTD int NULL NULL 10

DashboardCacheClassroomData AttendanceNeitherCountYTD int NULL…