| School and district operation > Maintaining information availability > About data mapping

About data mapping

Chancery SMS is a mature software product that Pearson has enhanced over many years of continuous development. Moreover, there are many Chancery SMS systems in operation storing large amounts of data. Enhancements to Chancery SMS are constrained by older aspects of its database architecture. Recent versions of Chancery SMS bypass these constraints by using a new database schema or tables. These developments make it necessary, however, to consolidate the data in the old schema, that is, in common tables.

To be more specific, certain data stored in a Chancery SMS schools, such as student class schedules, attendance, and grading, is stored in a new set of database tables. For this data to be available to reports and for uploading to a parent portal [>>], it must be transferred to the common set of tables [Figure 92].

Figure 92: System data mapping

For details as to which tables are mapped, refer to the Chancery SMS Data Dictionary [>>].

Pearson
Always Learning
www.pearsonschoolsystems.com 
Tel: 866-434-6276
Email: psstechsupp@pearson.com