Email addresses will be recorded on another table. Linda Canada-Concerned with restriction of information in the future, Do not want to place too many constraints. Not all students graduate Include pager numbers, cellular numbers Student transfers to a different campus. Relationship Feature will be used. Asked team to look into reducing the number of address that must be entered, without reducing functionality of addresses.
Synchronization is critical for institutional reporting.
Develop batch program that drops and rebuilds the PS table from the Bureau's tables. No updating allowed to the Building and Facility PS Tables. Run batch program once for initial load of the PS Building and Facility tables, thereafter run batch program periodically for PS Building table only. A standard SQR report will be required to maintain facility data integrity between the PS and Bureau tables. Some classes may need to move to a different classroom, some classes may be cancelled, professors' instructional needs change.