Data Architecture Updates
Please execute the following tasks to update our SQL server.
-
@dbsmith Create new HEAD files that mirror the data in the AS400. (AS_HEADTB, AS_HEADBR, AS_HEADT) -
@SweatyHandshake please document these three files, describing each one in detail. -
@dbsmith please add divisions file to server. @SweatyHandshake , please document. -
Load PM07DTA (or check if its already in ASSESSABLEPERMITS?). If PM07DTA = ASSESSABLEPERMITS, rename to AS_PM07DTA. @SweatyHandshake you know what to do. -
@SweatyHandshake please update the SQL inventory and move to data architecture. -
@ccao_rross needs to create architecture standards in the DS Handbook. -
@dbsmith please upload the schedule of table updates for the SQL server to the repository.
When all this is complete:
-
@SweatyHandshake please alter the MODELDATA and ASSMNTDATA view so that HEAD is replaced as the definition of the universe. -
Add the SQl code that creates these tables to the repo.
Edited by Sweaty Handshake