Page History

...

1. Upgrade and restart the system.
2. Run the migrateAgreementWorkEffortAppl service from WebTools.
3. Check to make sure all data was transferred from OldAgreementWorkEffortAppl to AgreementWorkEffortApplic.
4. Drop the AgreementWorkEffortAppl table.

R929503: rename square_footage to facility_size, change its type to fixed-point, add a facility_size_uom_id colum

ALTER TABLE facility ALTER square_footage TYPE DEC(18,6);
ALTER TABLE facility RENAME COLUMN square_footage TO facility_size;
ALTER TABLE facility ADD COLUMN facility_size_uom_id VARCHAR(20);