(Show Contents)
Database Schema Revision History
This topic contains the list of changes to the database schema file
since ARCHIBUS 11 Revision 1. This
information is provided for the benefit of users with customized schemas
so they can see if they need to migrate any changes from the released
schema to their own schema. Sites
using the standard ARCHIBUS schema do not need this information.
Even for sites with custom schema, you may not need this information,
as new versions of ARCHIBUS are backward-compatible with previous schema
formats. You only need to review this information if you need some new
database object on which a new desired feature depends. For instance,
you only need to include the BOMA 96 enumeration changes if you need the
BOMA 96 calculations.
Since database schema versions can run with different releases of the
ARCHIBUS program, databases are tagged with an "ARCHIBUS Database
Version" number. You
can see your ARCHIBUS Database version by checking the ARCHIBUS Schema Preferences
table (scmpref.avw).
Version 20.1: Database 136
Click on the following link to access a TXT file listing the database revision history
Database Revision History
Version 19.3 Multi-Lingual (Database Version 135)
Schema Preferences:
- Update Db Version Date to: 2011.03.24
- Update Db Version number to: 135
Schema changes:
Green Bldgs:
- Changed the afm_flds entries for project_name field in tables (gb_cert_docs, gb_cert_log, gb_cert_proj, gb_cert_scores) to modify the string_format to UPPER. (3030865)
- Changed the afm_flds entries for gb_fp_setup "*_version" and "subregion_code" FK fields to modify the string_format to UPPER, to match the definition of the referenced fields. (3030864)
WFR changes:
*** NONE ***
PNav changes:
System:
- Add a new System Administration view "Edit Messages" into the messages table. (3028118)
- CAD Manager process is missing icon in Smart Client Process. (3030807)
Proj. Mgmt.:
- Project Mgmt / Execute process - add at bottom of PNav an "Update Project Status / Close Project" view: ab-proj-project-update-status.axvw (3030895)
Data changes:
System:
- Add drawing revision data for Drawing File Mgmt. (3030684)
Green Bldgs:
- There is data inconsistency between tables gb_fp_emiss_data and gb_fp_sectors for sector_name column which at a certain point has the values: "Manufacturing industries/Construction" and "Manufacturing Industries/Construction". This is a problematic only with Oracle because is key-sensitive. (3030714)
Version 19.3 (Database Version 134)
Schema Preferences:
- Update Db Version Date to: 2011.03.08
- Update Db Version number to: 134
Schema changes:
System:
- Change the size of afm_notifications_log.email_message to 8000. This prevents UPW from crashing with MSSQL because the current 10,000 exceeds the max VARCHAR size for SqlServer.(3029999)
- Set A/FM Type for afm_dwgs.dwg_file field to “Calculated”.
- Update afm_flds for the enumeration list for afm_transfer_set.status: (3030442)
- Remove the extra line return in "No Extract File".
- Add: "UPDATED;Updated;"
- Add tables:
- afm_metric_definitions
- afm_metric_trend_values
BldgOps:
- probtype table: Copy ac.hierarchy_ids field definition in afm_flds to the probtype table.
Cap Bud:
- UPDATE afm_flds SET ml_heading = 'Date Available - End' WHERE table_name = 'funding' AND field_name = 'date_avail_end';
Green Bldgs:
- Change the enum list for bl.use1 to include values required by Energy Star: (3030313)
- UNKNOWN;UNKNOWN;BANK/FINANCIAL INSTITUTION;BANK/FINANCIAL INSTITUTION;COURTHOUSE;COURTHOUSE;DATA CENTER;DATA CENTER;HOUSE OF WORSHIP;HOUSE OF WORSHIP;HOSPICE;HOSPICE;HOSPITAL;HOSPITAL;HOTEL;HOTEL;K-12 SCHOOL;K-12 SCHOOL;MANUFACTURING;MANUFACTURING;MEDICAL OFFICE;MEDICAL OFFICE;MIXED USE;MIXED USE;MULTIFAMILY HOUSING;MULTIFAMILY HOUSING;OFFICE;OFFICE;OTHER;OTHER;RESIDENCE HALL/DORMITORY;RESIDENCE HALL/DORMITORY;RETAIL;RETAIL;SALES OFFICE;SALES OFFICE;SENIOR CARE FACILITY;SENIOR CARE FACILITY;SPORT/RECREATION;SPORT/RECREATION;STORAGE;STORAGE;SUPERMARKET/GROCERY STORE;SUPERMARKET/GROCERY STORE;WAREHOUSE;WAREHOUSE;WAREHOUSE (REFRIGERATED);WAREHOUSE (REFRIGERATED);WASTEWATER TREATMENT PLANT;WASTEWATER TREATMENT PLANT
- Add field called scenario_type to scenario table: Data Type=Char, Size=16, ML Heading="Scenario Type", Comments="v19.3-Green Building". (3030182)
- Add field called is_dflt to bill_unit table: Data Type=Smallint, Heading="Default?", Comments="v19.3-Green Building", Default Value=0, Enumeration List="0;No;1;Yes" (3030160)
- Change size of bl.use1 from 16 to 32 (3030311)
- bill_type table:
- Change bill_type.bill_type_id string format from Upper to AnyChar. (3029955)
Needed to accommodate multi/mixed units support and international standard abbreviations for units, for which lower and mixed case strings are required (e.g., kg, mg, MT, kW) - Change All NULL for or bill_type.cost_cat_id from rom No to Yes (3030158)
This is needed to accommodate multi/mixed units support. Without this change, a dummy record would need to be created in cost_cat table for GB to use in its bill_type entries. If the user deletes that dummy cost_cat record, ALL of GB's bill_type and bill_unit entries would be deleted via cascade delete, causing GB to stop functioning. - Add field activity_id. Copy from: afm_notifications_log. Allow Null = Yes, Validate Data? = No, Comments="v19.3-Green Building" (3030157)
This is needed to accommodate multi/mixed units support.It will be used by multi-unit enabled applications, such as Green Building, to filter bill_type entries to only their own entries. It will also be used by Energy Management to display only its own entries, which are those where activity_id is NULL. We’ve specified that multi-units applications will, in their Define Units task, show all units with activity_id equal to the ID of the activity OR AbAll. Some unit types are generic, like “VOLUME” or “DISTANCE”, that can be shared. Adding a dummy activity_id of AbAll to the activity table didn’t seem like a good option.
- bill_unit table:
- Change conversion_factor - change from (Size=12, Decimals=6) to (Size=28, Decimals=12). (3030579)
- Change bill_unit_id string format from Upper to AnyChar. (3029955)
- Add all gb_* tables for Green Bldgs activity.
Localization:
- Expand the sizes of the following lang_strings fields in order to handle the larger afm_activities.summary* field sizes that were expanded for v19.2: (3030083)
- string_english from: 512 to: 800
- string_trans from: 768 to: 1200
- reference_info from: 512 to: 800
- To get the new fields from the last update into afm_flds_lang run:
- INSERT INTO afm_flds_lang (table_name, field_name)
- SELECT table_name, field_name FROM afm_flds
- WHERE NOT EXISTS (SELECT 1 FROM afm_flds_lang afm_flds_lang_inner
- WHERE afm_flds_lang_inner.table_name = afm_flds.table_name
- AND afm_flds_lang_inner.field_name = afm_flds.field_name )
WFR changes:
System:
- Add WFR to remove unlicensed activity assignments to users
- Activity: AbSystemAdministration
- Rule name: removeUnlicensedActivities
- Event handler class: com.archibus.eventhandler.security.RemoveUnlicensedActivities
- Event handler method: removeUnlicensedActivities
- Active: Yes
- Security group: leave empty
- Rule Type: Scheduled
- XML Schedule Properties: <xml_schedule_properties><schedule startTime="01-01-2010 12:00:00" endTime="" runOnStartup="true"><simple repeatCount="-1" repeatInterval="315360000"/></schedule></xml_schedule_properties>
BldgOps:
- Canonical Db lost the "updateServiceRequestStatusFromWorkRequest" after the 2010-12-22 update. This WFR was added to the production databases. Add it to the canonical hq.db: Import: WFR-updateServiceRequestStatusFromWorkRequest.xml
Green Bldgs.:
- Add all WFRs for Green Bldgs activity.
PNav changes:
System:
- The localization process creates duplicate records in MSSQL and Oracle if Pkey fields have leading spaces. Remove the leading spaces from records in the following tables and fields that have leading spaces:
- afm_hotlist.view_title
- afm_subtasks.subtask
- afm_tasks.task
- Add PNav entries for Drawing File Management (3030027)
- Create a new “CAD Manager” process in the System Administration activity beneath “ARCHIBUS Administrator” but before Add-in Manager”. Add this process on both Web Central and the Smart Client Process Navigators. Help link is: \Subsystems\webc\Content\cad_manager\cad_manager_over.htm
- Add the following views:
- Set Asset Text Visibility (ab-cad-set-atxt-visibility.axvw)
- Label
- View Drawing Changes by Drawing ( ab-dwg-changes-by-dwg.axvw)
- View Drawing Changes by Building Location (ab-dwg-changes-by-bl.axvw)
- View Drawing Changes by User (ab-dwg-changes-by-user.axvw)
- Add: Technologies > Localization > Localization > Localization Analysis (ab-localization-analysis.axvw) (3028511,3030276)
- Change view for: AbSystemAdministration / ARCHIBUS Administrator (SC) / Assign Processes to Roles TO: \sys-admin-views\security\ab-sys-afm-roleprocs-by-role-gd.axvw (3030344)
Space Mgmt:
- Space Management / Space Inventory / Room Inventory / Highlight Vert Pen by Type --- Typo: the command line should be "afm_hvertxtype" (3029964)
- Add Ptasks for simple views for exporting space data.
- Add/Update Building Performance and Room Inventory process tasks for SC CAD extensions.
Green Bldgs:
- Add all PNav entries for Green Bldgs activity.
Data changes:
System:
- Add the following to the afm_activities.summary field for the Green Buildings activity: (3030178)
- Sustainability officers and green building managers strive to increase green building performance and certification levels and to reduce carbon footprint. However, assessing progress and quantifying results requires complex calculations and a breadth of data spanning multiple years. This activity calculates net greenhouse gas equivalent impact, shows carbon footprint change over time for each building or an entire portfolio, tracks progress through sustainability certification projects, and manages data and documents required for requalification. It also shows anticipated payback on sustainability investments and correlates environmental data to facility use and operations thus providing the timely and reliable data required for making and defending strategic sustainability decisions.
- The following changes convert user "AFM" to an activity licensee user and add user "AI" as a domain license user:
- Copy user "AFM" to a new user "AI" (3030557)
- Rename the “AIDEMOACP” (role “ACTIVITY LICENSEE” role) user to “AFM” (still “ACTIVITY LICENSEE” role) (3030557)
- Copy the AFM user (role “ACTIVITY LICENSEE”) to user AIDEMOACP. (We need no other change as all other processes and groups come from the role.)
- Add em_id = "AI" to the em table similar to em_id = "AFM".
- Update afm_userprocs to assign user 'AI' to all processes:
- INSERT INTO afm_userprocs ( activity_id, process_id, user_name )
SELECT afm_processes.activity_id, afm_processes.process_id, 'AI*'
FROM afm_processes, afm_activities
WHERE afm_activities.activity_id = afm_processes.activity_id
AND afm_activities.is_active = 1 AND afm_processes.is_active = 1
AND NOT EXISTS (SELECT 1 FROM afm_userprocs WHERE user_name = 'AI'
AND afm_userprocs.activity_id = afm_processes.activity_id
AND afm_userprocs.process_id = afm_processes.process_id );
Proj. Mgmt.:
- Update project tasks to show dependencies.
Green Bldgs.:
- Change bl.use1 for HQ and JFKB from "MIXED USE" to "OFFICE"
- The reason is that Energy Star export has a different spreadsheet template for each building use, and therefore a separate spreadsheet is required for each use.We have only tested the template for “OFFICE” so far and having several bldgs with ‘OFFICE’ will demonstrate export of multiple buildings to one spreadsheet
- Add all sample data for Green Bldgs.
BldgOps:
- Establish hierarchical sample data for problem types
REPM:
- Some data is missing from the ls_resp table in Oracle since clause_type_id = ‘amenity’ but in the primary table is stored as ‘Amenity’. To resolve:
- UPDATE ls_resp SET clause_type_id='Amenity' WHERE resp_id in ('AM40', 'AM41', 'AM42', 'AM43');
Space:
- rm table - Delete room: Hq-17-000 (3024461)
Version 19.2 (Database Version 133)
Schema Preferences:
- Update Db Version Date to: 2011.01.21
- Update Db Version number to: 133
Schema changes:
System:
- Support afm_notifications_log table and fields for email notification logging (this table was added in v19.1 but not supported in that release).
- Remove "Edit Group" values from afm_flds table for table afm_notifications_log (3029732)
- Add afm_dwgs and afm_dwgvers tables and fields for Drawing File Mgmt. Note that the Drawing File Mgmt features are not supported in v19.2.
- To support Radio Frequency ID functionality:
- - Add rf_reader and rf_activity tables and fields
- - Add current location fields to eq, ta, and em tables including: curr_site_id, curr_bl_id, curr_fl_id, curr_rm_id
- Add hpattern_acad field to the dv table (3029883).
- afm_activities.summary and afm_products.summary - change size from 512 to 800. Change sizes of all summary_* fields to 1200.
- Set afm_type to "Calculated" for all enumeration list fields that do not have a default value:
- First update lang_lang.lang_to_fld_mapping to have a default value of '03'
- Then:
UPDATE afm_flds SET afm_type = 2070 WHERE enum_list IS NOT NULL AND dflt_val IS NULL AND afm_type <> 2070 AND table_name <> 'afm_wf_steps';
Real Estate & Property Management:
- Add cost fields to bl table that match those in the property table. (3028864)
- cost_operating_total
- cost_utility_total
- cost_tax_total
- cost_other_total
- income_total
- date_costs_start
- date_costs_end
- date_costs_last_calcd
- Add table: bl_amenity
Building Operations:
- Run System / Schema / Define / Update Service Desk and On Demand Work SQL Views using latest helpdesk_views.sql updated in 12/2010 to modify the hwr_month SQL view to support new fields such as supervisor. (3028984)
- Change probtype.prob_type to be of A/FM Type “Hierarchical-Concat”. (Note that this change is not sufficient for making prob_type hierarchical; in the next release a trace_id field will be added to the prob_type table.)
- Correct Validating table settings for the following fields:
- helpdesk_sla_response activity_type
- helpdesk_sla_steps activity_id
- helpdesk_sla_steps activity_type
- helpdesk_sla_steps ordering_seq
- add field "pmp_id" to the activity_log tables to facilitate SLA matching for Preventive Maintenance work requests. (3029391)
- activity_log
- hactivity_log
Reservations:
- rmpct.day_part -- change enum list to: "0;Full Day;1;Morning;2;Afternoon;" (3029345)
Capital Budgets:
- funding table - add new field date_avail_end. (3027862)
Workflow Rules (WFR) Additions and Changes:
New WFRs added:
- AbCommonResources / GraphicsService - deletes enterprise graphics files. (3029657)
- LeaseAdministrationService. The duplicateLease method provides for copying lease templates: (3028657)
- ProjectGanttService. The cascadeTaskDependencies method cascades dates for linked project tasks. (3027995)
New WFRs added for Building Operations applications:
- AbBldgOpsOnDemandWork
- invokeSLAForWorkRequests -- integrates non-Run Anywhere Work Request processes with the Run Anywhere applications
- updateWrDateAssigned -- integrates non-Run Anywhere Work Request processes with the Run Anywhere applications
- updateWorkTeamFromSupervisor
- AbBldgOpsHelpDesk
- updateServiceRequestStatusFromWorkRequest -- integrates non-Run Anywhere Work Request processes with the Run Anywhere applications
- AbBldgOpsBackgroundData
- calculateWorkResourceValues -- provides parts inventory calculations
Energy Management:
- Change repeatInterval for the Energy Mgmt scheduled WFRs from "86400000" (every 24000 hours) to "86400" (every 24 hours).
Process Navigator (PNav) changes:
System:
- Add task: System Administration/Add In Manager/Add-in Application License Generator
- Add task: "View Notifications Log" in Utilities section under the ARCHIBUS Administrator process
- Updated elevator stories (summaries) for many of the domains (products) and activities.
- Remove unused Domain and Activities:
DELETE FROM afm_products WHERE product_id = 'AbCapitalBudgets';
DELETE FROM afm_activities
WHERE NOT EXISTS (SELECT 1 FROM afm_processes WHERE afm_processes.activity_id = afm_activities.activity_id)
AND NOT EXISTS (SELECT 1 FROM afm_wf_rules WHERE afm_wf_rules.activity_id = afm_activities.activity_id);
- Add Document Management views to Web PNav under the System Administration/ARCHIBUS Administrator role. (3028794)
Real Estate & Property Management:
- PNav updated to add additional views and reports, to correct some view links, and to add some help links.
Moves:
- PNav updated to correct file names particularly in regards to file name changes to match convention. (3026577); (3028765); (3028030)
Space Planning & Inventory:
- Correct duplicate dashboard names. (3028740)
- Add PNav entries to support Highlighting Groups and Rooms in the AutoCAD Extension.
Building Operations:
- PNav updated to add additional views and reports, to correct some view links, and to add some help links.
Asset Management:
Capital Budgeting:
- Remove: Capital Budgeting > Prioritize & Estimate > Create Facility Condition Index Scenarios as this functionality is now incorporated in the Analyze Facility Condition Index Scenarios view. (3029741)
Solutions:
- Add the following new solution templates (Technologies) tasks:
Software Engineering / Software Engineer Views:
- Miniconsole Views / Miniconsole with columns that can be shown, hidden, or sorted
- Tree Views / Tree View with Multiple Selection Checkboxes
User Interface Add-Ins / Parts for Forms:
- Advanced Form Techniques / Console with Multiple-value Restrictions
User Interface Add-Ins / Parts for Reports:
- Report with Complex Parsed Restriction
Business Process Owner Views / Paginated Reports:
- Report with Print-out Restriction
- Report with Passed Restrictions and Parameters
Data changes:
System:
- Drawing File Mgmt -- Add a user Z-CADHQ with a VPA Building Code List value of “HQ”. Use this user to test the VPA restriction on the Drawing List.
- Change user "CHARLES" to have a role at a higher level (3029667)
- Add a new activity parameter (afm_activity_params) record (3029026):
- AbSystemAdministration-highlightRGBColorEncoding, “Use Web Central-style RGB Encoding?”, 0/1
Email notifications logging - add a new record in the afm_activity_params table to store the Notification Logging Level the system administrator requires:
| Field name |
Field value |
| activity_id |
'AbSystemAdministration' |
| param_id |
'NotificationLoggingLevel' |
| param_value |
'off'|'subject'|'message' Default value is 'message' |
| description |
'Indicate the level of e-mail notification logging required. Valid values are:
• "off": to disable logging;
• "subject": to log only the subject;
• "message": to log the complete message text.'
|
| transfer_status |
'NO CHANGE' |
Localization:
- afm_flds_lang updated to include records for the new v19.2 fields
Building Operations:
- Create a “default SLA” for the Hoteling service request type (3029808)
- Significant sample data added.
Project Management:
- Update project and activity_log sample data to include site and bl id values so that appropriate data is displayed when VPA is in use (3029743)
Space:
- Vertical and service areas hpattern values updated in rmtype table.
- Add values to 9 records in db table for dv.hpattern_acad field.
Real Estate & Property Management:
- Add "Amendment to Lease Agreement 001.docx" to the one record in the ls_amendment table. That record has a value in its doc field, however, no corresponding document records currently exist in the afm_docs or afm_docvers tables. (3028241)
- Update sample data for the following tables:
- ot
- property
- bl
- ls
- prop_amenity
- bl_amenity
- ls_resp
- cost_tran_recur
- cost_tran_sched
- cost_tran
Version 19.1 (Certified International Release) Database Version 132
Schema Preferences
- Update Db Version Date to: 2010.08.16
- Update Db Version number to: 132
Schema Changes:
- Make translatable fields wider to accept translations . resource_std.resource_name_% change from 32 to 64 (3028043)
- afm_roles table - change the AbCoreLevel4Activity display value to "Activity ACP"; set the Default Value for License Level to be "AbCoreLevel4Activity". (3028016)
- afm_flds_trans table - change the Default value to "AUTOINCREMENT" (it was Null).
- wo table - Remove the Edit Group value of "CALCULATED" from wo.date_closed and wo.time_closed. (3208048)
- afm_wf_steps table - Change the size of the following fields from 32 to 48 (3028043)
- step_01
- step_02
- step_03
- step_ch
- step_de
- step_es
- step_fr
- step_it
- step_jp
- step_ko
- step_nl
- step_no
- step_zh
- afm_notifications_log table - Add this Notifications Log table (this is only needed for v19.2 but is being added now so work can proceed.). afm_notifications_log - holds notification history.
| Field name |
Type and Size |
Description |
| auto_number |
Integer (10) |
Auto-numbered PKey |
| email_from |
varchar(50) |
The e-mail address of the sender. |
| email_to |
varchar(5000) |
The e-mail addresses of the recipients, comma-delimited. |
| email_subject |
varchar(200) |
|
| email_message |
varchar(10000) |
|
| email_host |
Varchar(256) |
|
| server_date_sent |
date |
|
| server_time_sent |
time |
|
| status |
char(16) |
Enumerated value that shows the send status. Valid values are: "sent"; "error"; |
| status_message |
varchar(1000) |
The status message (typically, this is an error message). |
| activity_id |
char(32) |
The activity from which the message was sent. |
- geo_region table - Add "Geographic Business Regions" table with fields:
| Field name |
Type and Size |
Description |
| geo_region_id |
Char 8 |
Example values: AMER; EMEA; APAC |
| geo_region_name |
Char 64 |
Example values: AMER (Americas); EMEA (Europe, Middle East, Africa); APAC (Asia Pacific, Japan) |
| description |
Varchar 1000 |
|
| hpattern_acad |
Char 16 |
|
| option1 |
Char 16 |
|
| option2 |
har 16 |
|
- ctry table - add Fkey field to geo_region_id
Localization:
- To get the new fields from the last update into afm_flds_lang run:
INSERT INTO afm_flds_lang (table_name, field_name)
SELECT table_name, field_name FROM afm_flds
WHERE NOT EXISTS (SELECT 1 FROM afm_flds_lang afm_flds_lang_inner
WHERE afm_flds_lang_inner.table_name = afm_flds.table_name
AND afm_flds_lang_inner.field_name = afm_flds.field_name )
- Run Comparator50.abs to verify database and especially FKeys.
WFR changes:
PNav changes:
- Correct error on some assets when trying to use the Number command. (3028055)
DELETE FROM afm_ptasks WHERE process_id LIKE 'Group%' AND task_id = 'Number';
DELETE FROM afm_ptasks WHERE process_id LIKE 'Fur%' AND task_id = 'Number';
DELETE FROM afm_ptasks WHERE process_id LIKE 'Equip%' AND task_id = 'Number';
- Three context-sensitive Help links not working from three Smart Client Extension processes (3028233). Import items-3028233-doc1.xls.
- Add "Define Employee Standards" under "Move Management" -> "Enterprise Move Management" -> "Business Process Owner" (3028159)
Data changes:
System:
- Correct Wrong name for "Portfolio Management" in PNav’s "Summary" (3028080). The name of the Activity in the PNav is "Portfolio Management", but in the "Summary" is "Portfolio Administration" (old name).
- In the afm_users table, change the role for "TRAM" to “2 - WORKFLOW PROCESS”
Project Management:
- Add bl_id values to project table so that the following query returns values:
SELECT project.bl_id, SUM(cost_est_design_exp) + SUM(cost_est_design_cap) FROM activity_log, project
WHERE activity_log.project_id = project.project_id
AND ( project.status LIKE 'Approved%' OR project.status LIKE 'Issued%' )
GROUP BY project.bl_id
Reservations:
- - hreserve_rs table where rsres_id = 16 --- 9/26/2006 Cold food catering resource is reserved for -6 hours, which is not correct. (3028222). time_end value of 12:00am, which is not correct. Because 12:00 am is earlier than its time_start (8:00am).
Version 19.1 Database Version 131
A summary of database changes required per activity or domain when upgrading from v18.2 to v19.1 is listed in the below table.
| Activity or Domain |
Tables/Fields Changed* |
SQL Views changed |
PNav Changed |
afm_wf_rules changes
|
| System |
Yes |
No |
Yes |
Yes |
| Asset Management |
Yes |
No |
Yes |
Yes |
| Space |
No |
No |
Yes |
No |
| Service Desk |
No |
Yes |
Yes |
Yes |
| On Demand Work |
No |
Yes |
Yes |
Yes |
| Move Management |
Yes |
No |
Yes |
Yes |
| Project Management |
No |
No |
Yes |
Yes |
| Reservations |
No |
Yes |
No |
Yes |
| Emergency Prep |
No |
No |
Yes |
Yes |
| REPM |
No |
No |
Order and Titles only |
Yes |
| Condition Assessment |
No |
No |
No |
No |
| Hoteling |
Yes |
No |
Yes |
Yes |
| Energy Management |
Yes |
No |
Yes |
Yes |
| Localization |
Yes |
No |
Yes |
Yes |
Note: When reviewing this list of changes, note that some of the View 1.0 view files or ARCHIBUS Windows Client/Server view files referenced in this document are now obsolete and no longer shipped.
Schema changes
System
- Add a field: help_system (enum: System;End User) to both the afm_processes and the afm_activities tables (3023526)
- Add a new field, afm_atyp.dflt_view_sc, same as afm_atyp.dflt_view except expand the column to be 64 characters long instead of the current 8 (3025039)
- Change "A/FM" to "ARCHIBUS":
UPDATE afm_tbls SET title = REPLACE( title, 'A/FM', 'ARCHIBUS') WHERE title LIKE '%A/FM%';
UPDATE afm_flds SET ml_heading = REPLACE( ml_heading, 'A/FM', 'ARCHIBUS') WHERE ml_heading LIKE '%A/FM%';
Remove the "/FM" from ml_heading for afm_scmpref.afm_cascades_changes
- Change the string format on the afm_users.user_pwd field from Upper to AnyChar (3024785)
- Add Data Transfer Status field to all system tables (afm_*) -- run CopyDataTransferFlds.abs
- afm_processes.process_type:
- Change default value to: WEB
- Add new values to enum list and add "Client/Server to Windows C/S items:WEB;
Web PNav;WEB-DASH;Web Dashboard;SC;Smart Client;SCOVERLAY;Smart Client Overlay;WINDOWS;Client/Server;OVERLAY;Client/Server Overlay;
- afm_ptasks.task_type and afm_psubtasks.task_type: enum -- add two new values for Smart Client Grid and CAD Grid views; add "c/S" to Windows C/S items:
LABEL;Label;WEB URL;Web URL;GRID;Smart Client Grid;GRIDCAD;Smart Client CAD Grid;OVERLAY ACTION;Overlay Action;VIEW;C/S View;FIXED-FORMAT VIEW;C/S Fixed-Format View;DRAWING VIEW;C/S Drawing View;BASICSCRIPT ACTION;C/S BasicScript Action;ACTIVEX ACTION;C/S ActiveX Action;WINDOWS CONSOLE URL;C/S Windows Console URL;SHELLEXECUTE;C/S ShellExecute;WINDOWS BROWSER URL;C/S Windows Browser URL;- afm_scmpref: Add two fields (similar to fields from afm_dwgs):
- afm_dwgpub:
Add: rule_suffix -- "Suffix" -- Char(32)
Add: dwg_view -- "AutoCAD Drawing View" -- Char(32)
Change: rule_type:
- add values to enum for Ent. Graphics Publishing: NONE;None;ALL;All;SWF;SWF;EMF;EMF;SWF and EMF;SWF and EMF;JSON;JSON;BY OWNER;By Owner;LAYERED BY OWNER;Layered By Owner;QUERY TEXT;Query Text;QUERY TABLE;Query Table;ASSET;Asset;RESTRICTION;Restriction;URL;URL;DYNAMIC;Dynamic
- afm_tbls:
Add: table_type -- "Table Type" -- Char(32) -- default: PROJECT DATA -- enum: PROJECT SECURITY;Project Security;PROJECT APPLICATION DATA;Project Application Data;PROJECT DATA;Project Data;DATA DICTIONARY;Data Dictionary;APPLICATION DICTIONARY;Application Dictionary;PROCESS NAVIGATOR;Process Navigator;
Add: default_view -- "Default View" -- char(64)
DOCUMENTATION NOTE:
The Update Project Wizard doesn't create the fields:
- afm_tbls.default_view
- afm_tbls.table_type
- afm_tbls.transfer_status
- afm_flds.transfer_status
- afm_groups.transfer_status
These are new fields for afm_flds, afm_tbls and afm_groups that the Update Project Wizard doesn�t add.
The solution is to run Update Project Wizard again with (Table like=afm_flds;afm_tbls;afm_groups)
UPDATE afm_tbls SET table_type = 'PROJECT SECURITY' WHERE table_name IN ( 'afm_groups','afm_users','afm_groupsforroles','afm_roles','afm_userprocs','afm_roleprocs' );
UPDATE afm_tbls SET table_type = 'PROJECT APPLICATION DATA' WHERE table_name IN ( 'afm_hotlist', 'afm_tclevel', 'afm_wf_steps' );
UPDATE afm_tbls SET table_type = 'DATA DICTIONARY' WHERE table_name IN ( 'afm_flds', 'afm_tbls', 'afm_flds_lang' );
UPDATE afm_tbls SET table_type = 'APPLICATION DICTIONARY' WHERE table_name IN ( 'afm_wf_rules','afm_atyp','afm_dwgpub','afm_layr', 'messages', 'afm_activity_params', 'afm_scmpref' );
UPDATE afm_tbls SET table_type = 'PROCESS NAVIGATOR' WHERE table_name IN ( 'afm_products','afm_activity_cats','afm_actprods','afm_activities','afm_processes','afm_ptasks','afm_psubtasks' );
- Add table: afm_transfer_set:
autonumbered_id -- "Autonumbered ID" -- (pkey) Integer -- Default: AUTOINCREMENT
set_name -- "Data Transfer Set" -- Char (32)
table_name -- "Table Name" -- Char (32) Does not validate on afm_tables.
table_type -- "Table Type" -- Char(32)
nrecords_dest -- "Records in Destination Table" -- Integer
nrecords_source -- "Records in Source Extract" -- Integer
nrecords_inserted -- "Records Inserted" -- Integer
nrecords_updated -- "Records Updated" -- Integer
nrecords_missing -- "Records Missing" -- Integer
processing_order -- "Processing Order" -- SmallInt
status -- "Status" -- Char(16) -- Default: NONE -- Enum: NONE;None;PENDING;Pending;EXPORTED;Exported;COMPARED;
Compared;IMPORTED;Imported;NO EXTRACT FILE;No Extract File;NO PROJECT TABLE;No Project Table;NOT PROCESSED;Not Processed;
- Add table: afm_flds_trans:
autonumbered_id -- "Autonumbered ID" -- (pkey) Integer -- Default: AUTOINCREMENT
** Add ALL fields from afm_flds table. Remove validating links.
change_type -- "Field Differs In" -- Char (32) Default: NONE -- Enum List:
NONE;None;NO_DEFAULT;Default Value not in Enum;NEW;Field is new;PROJECT_ONLY;Field is only in project;ALLOW_NULL;Is Null?;AFM_TYPE;AFM Type;ATTRIBUTES;Attributes;COMMENTS;Comments;DATA_TYPE;Data Type;DECIMALS;Decimals;DEP_COLS;Dependent Columns;DFLT_VAL;Default Value;EDIT_GROUP;Edit Group;EDIT_MASK;Edit Mask;ENUM_LIST;Enum List;FIELD_GROUPING;Field Grouping;IS_ATXT;Is Asset Text;IS_TC_TRACEABLE;Is Tc_Traceable;MAX_VAL;Maximum Val;MIN_VAL;Minimum Val;ML_HEADING;Multiline Heading;NUM_FORMAT;Numeric Format;PRIMARY_KEY;Primary Key;REF_TABLE;Reference Table;REVIEW_GROUP;Review Group;SIZE;Size;SL_HEADING;Single Line Heading;STRING_FORMAT;String Format;VALIDATE;Validate Data;
data_dict_diffs -- "Data Dictionary Differences" -- VarChar[ 256 ]
sql_table_diffs -- "SQL Table Differences" -- VarChar[ 256 ]
rec_action -- "Action - Recommended" -- Char[ 32 ] -- Default: NO ACTION
Enum: NO ACTION;No Action;APPLY CHANGE;Apply Change;KEEP EXISTING;Keep Existing;DELETE FIELD;Delete Field;
chosen_action -- "Action - Chosen" -- Char[ 32 ] -- Default: NO ACTION
Enum: NO ACTION;No Action;APPLY CHANGE;Apply Change;KEEP EXISTING;Keep Existing;DELETE FIELD;Delete Field;
- afm_flds_trans -- Make the autonumbered_id field the primary key
- Add the following to the enum for afm_flds.afm_type:
;2175;Questionnaire;
- Set the AFM Type for the following fields to be "Questionnaire":
| activity_log | act_quest |
| activity_log_hactivity_log | act_quest |
| activity_logview | act_quest |
| hactivity_log | act_quest |
| hactivity_logmonth | act_quest |
| mo | mo_quest |
| project | project_quest |
- For performance add an index to em.email:
CREATE INDEX em_email ON em (email) (3025541)
- Change afm_atyp.dflt_view and afm_atyp.dflt_view_sc to allow Null values.
- Remove circular references - Set "Validate Data?" to No for the following 2 fields:
afm_atyp.pop_layer
dp.approving_mgr
- Change afm_user.user_pwd and sql_pwd size to 128 (3025455)
- afm_ptasks.task_action change from size of 64 to size of 128 to accomodate longer Overlay commands
- Licensing and Revit changes ( \\coleburn\thetis\Spec\Yalta\Yalta9\discussion\V.19.1 Licensing Changes.docx ). Add new fields:
| afm_dwgs | model_level |
| afm_dwgs | model_name |
| afm_processes | license_level |
| afm_roles | license_level |
| afm_users | bim_license |
| afm_users | is_named_user |
Security:
- LEVEL 1 users can not access certain validating fields that they need to use for executing self-service tasks:
UPDATE afm_flds SET review_group = NULL WHERE table_name <> 'afm_users' AND review_group IS NOT NULL AND ( primary_key > 0 OR ref_table IS NOT NULL);
Real Estate Portfolio Management Domain
- Add a new su.doc_image field of type document as an alternative to the su.image_file field.
Asset Management Domain
- eqstd; fnstd: add 2 document fields (doc_graphic, doc_block) to use instead of the image fields (image_file, image_of_block)
- Add a document field to the warranty table: doc_warranty (3026700)
- Add a doc_image field to the following 3 tables:
Move Management Domain
- add mo_scenario table for move scenarios.
- add mo_scenario_em table for employee move scenarios.
- add hist_em_count table for historical churn reporting.
- mo.phone_dept_contact change ml_heading to be the same as for project.phone_dept_contact
- mo_scenario table -- make the comments and the description fields to have string format "Memo" (3026045)
Service Desk/On Demand Activities
- Change the numeric format for helpdesk_step_log.pkey_value. This field stores either service request or work request ids.
Right now, the work request ids show up as comma-separated because the numeric format is set to "default".
This should change to "NoSeparator". (3024523)
- Update SQL views used by SD/OD due to added fields in the activity_log table (3025620)
Run: System /Schema /Define /Update Service Desk and On Demand Work SQL Views
Space
- change fl.area_gross_ext to have a default of "0.0" instead of "0".
Condition Assessment Activity
- Change multi-line headings:
Activity_log.cond_priority
from: Conditions Priority to Condition Priority (remove "s" at the end of Conditions")
Activity_log.cond_value
from: Conditions Value to Condition Value (remove "s" at the end of Conditions")
Reservations Activity
- Update the Reservations SQL Views: run reservationSqlViews.abs (2010-3-4 version)
Hoteling Activity
- rmpct:
Add: status -- "Status" -- SmallInt -- Default: 1 -- enum: 0;Requested;1;Approved
Add: resources -- "Resources" -- "Hoteling Resources Required" -- VarChar (5000) -- Memo
Add: visitor_id -- copy from visitors table; add validation; remove Pkey; Allow NUll
Add: day_part -- "Part of Day" -- SmallInt -- Default: 0 -- enum: 0;Full;1;Morning;2;Afternoon
Add: activity_log_id -- copy from cost_tran table
Add: parent_pct_id -- "Parent Percentage Code" -- Integer
- visitors:
Add: em_id -- copy from eq table; change ML Heading to: "Contact Employee"
Add: dv_id -- copy from eq table; change ML Heading to: "Contact Division"
Add: dp_id -- copy from eq table; change ML Heading to: "Contact Department"
Add: visitor_photo -- same as "em.em_photo"
- activity_log and hactivity_log:
Add: recurring_rule -- copy from reserve table
- rm:
Add: hotelable -- "Is Hotelable?" -- SmallInt -- Default: 0 -- enum: 0;No;1;Yes
- rmstd_emstd -- Add table:
Add: rm_std -- copy from rm table; make Pkey 1; Not Null
Add: em_std -- copy from em table; make Pkey 2; Not Null
- rmstd:
Add: doc_graphic -- copy eqstd.doc_graphic; change ML Heading
Add: doc_block -- eqstd.doc_block; change ML Heading
- dp:
Add: approving_mgr -- copy work_pkg_bids.approved_by; change ML Heading to: "Approved By"; change Fields to Validate to: approving_mgr
Energy Management Activity
- Add records to afm_tbls:
- Add vn_ac table
- Add bill* tables
- Add weather* tables
- Add energy* tables
- Add records to afm_flds -- these are all records where afm_flds.comments LIKE 'v19.1 Energy Management%'
In addition to the fields for the tables listed above added fields to bl table
- Add enum value ('Energ;Energy;') to vn.vendor_type
Localization:
- Change lang_strings.string_trans size to 768 and data type to VarChar. (3024613)
- Add field "locale" to the lang_lang table. (3027425)
ML Heading - "Default Locale to write to lang file"
CHAR - length 5
Default value - 'en_US'
- Change lang_lang.is_default_language to SmallInt with a default of 0. (It is a "0;No;1;Yes" enum but was oddly Char 512)
- To get the new fields from the new fields in afm_flds_lang run:
INSERT INTO afm_flds_lang (table_name, field_name)
SELECT table_name, field_name FROM afm_flds
WHERE NOT EXISTS (SELECT 1 FROM afm_flds_lang afm_flds_lang_inner
WHERE afm_flds_lang_inner.table_name = afm_flds.table_name
AND afm_flds_lang_inner.field_name = afm_flds.field_name )
Work Flow Rules
System:
- Add rule for data transfer by record
- Add WFR for Gantt control
- DELETE FROM afm_wf_rules WHERE rule_id = 'appUpWizServiceRule'; because we are using a different one and errors occur in the archibus.log (3026060)
- DELETE FROM afm_wf_rules WHERE rule_id = 'dataTransferInByRecord'; (AbSystemAdministration) as this should not be called from views.
- PDF Forms - add rule for pdfLiveCycle.
- Add two WFR's for Basic Rule Wizard:
Activity: AbCommonResources
Rule: BasicRules
Activity: AbSystemAdministration
Rule: BasicRuleWizService
- Add new WFRs for AbCommonResources services:
Activity: AbCommonResources
Rule: DataSourceService
Activity: AbCommonResources
Rule: JobManagerService
- Add a new WFR:
Activity: AbSystemAdministration
Rule: PasswordManagerService
- Add WFRs in for AbSolutionsLogicAddIns (formally known as AbSolutionsLogicCookbook). (3027012)
Hoteling Activity
- Add WFRs for checking Hoteling
Service Desk/On Demand Work Activities
- Consolidate OD/SD WFR's to service level rules instead of individual method rules
Portfolio Administration Activity
- Remove rule that was replaced with JavaScript:
DELETE FROM afm_wf_rules WHERE rule_id = 'checkOwnership' AND activity_id = 'AbRPLMPortfolioAdministration';
Portfolio Forecasting Activity
- Update WFR's to new service format: (3025763)
Government Property RegistryActivity
- Update WFR's to new service format:
- UPDATE afm_wf_rules SET rule_id = 'GovPropertyRegistryService' WHERE activity_id = 'AbRPLMGovPropertyRegistry' AND rule_id = 'ActivityService';
Capital Budgeting/ Project Management Activities
- Update WFR's to new service format (ProjectManagementService, MsProjectService and CapitalProjectsService) (3025759)
Emergency Preparedness Activity
- Add EP Common Handler (3026971)
Energy Management
Reservations Activity
- Consolidate Reservations WFR's
Move Management Activity
- Consolidate Move Mgmt WFR's
Asset Management Activity
Package and Deploy Wizard
- Add new afm_wf_rules record for the App Up Wiz
Process Navigator
Smart Client:
- Add Smart Client Process Navigators
System
- Update AbSolutions (3026908)
- Rename and re-order Sys Man ptasks (3027052)
- UPDATE afm_ptasks SET task_file = 'ab-sys-user-procs.axvw' WHERE task_file = 'ab-ex-user-procs.axvw' AND activity_id = 'AbSystemAdministration';
- Rename the �Risk Management� domain to "Environmental & Risk Management" Domain.
- Add: System Administration / Business Process Owner / Run Basic Rule Wizard --- ab-basic-rule-wizard.axvw
under "Run Dashboard Definition Wizard"
- Add task for: AbSystemAdministration / ARCHIBUS Administrator / Encrypt Passwords in Configuration Files
- Overlay Process Navigator task updates
- Update help links.
- Add "Report with Data Transfer of Documents" --- ab-ex-dt-activity-log-with-docs.axvw
under: Technologies / User Interface Add-Ins / Parts for Reports / Report with DOC, PDF, Excel, and Data Transfer Actions
- Change afm_pubgraphics to afm_pubgraphicst to get the command line form of this command.
- Rename the Technologies/System Integrator Views to User Interface Add Ins.
- Rename the Business Logic Integrator Views to the Business Logic Add Ins.
- Rename "extensions" to "Add In Management".
- Delete Workflow Manager process under under System Administration activity (moved items to Add In Manager ).
- Move AbSolutionsLogicCookbook activity tasks into AbSolutionsLogicAddIns.
- Delete AbSolutionsLogicCookbook activity.
- Create a Basic Rule Wizard ptasks in the AbSolutionsLogicAddIns process.
- Move ARCHIBUS Administrator tasks (password and user management) from System Administrator to ARCHIBUS Administrator.
- Rename the System Administration/System Integrator process to Add In Management.
- Move the Add In Management tasks (workflow rules, views, pnav tasks) from Business Process Owner to Add In Management.
- Remove "/FM" from some activity descriptions.
- Delete "Workflow" process and ptasks from beneath the User Interface Add Ins (as it is now under Business Logic Add Ins).
- Create new views for the System Administration Activity--Assign Processes to Roles, Create User Identities from Employees, Synchronize User and Employee Identities and for the Technologies/Parts for Forms--Adding Panel Instructions (kb 3024782)
- Create two new WFRs--assignAllActivitiesToRole, deleteAllProcessesAssignedToRole
Background views
- Update PNav to remove old background views and replace them with the new Define Locations and Define Organizations views (3024964):
Move Management Activity
- Remove old Define views and replace with Define Locations and Define Organizations
- Update Move Process Navigator with new role and tasks:
- Change Define Employees, under BPO, to point to: ab-sp-def-em.axvw
- Delete existing Churn Reports from afm_ptasks
- Add Scenarios
- Add an afm_userprocs record assigning activity_id="AbMoveManagement" process_id="Move Scenario Planner" to users AFM and Abernathy
- Move Business Process Owner process to first in list (KB 3025859)
- Add a view for defining Tagged Furn
- Remove the task "Examine Group Move Spreadsheet"
- Add Dashboards
- Remove remaining "Spreadsheet" views. (3027185)
Delete the following:
| Activity |
Process or Role |
Task |
| AbMoveManagement |
Craftsperson |
Examine Group Move Spreadsheet |
| AbMoveManagement |
Data Coordinator |
Examine Group Move Spreadsheet |
| AbMoveManagement |
Voice Coordinator |
Examine Group Move Spreadsheet |
Asset Management Activity
- Make the following changes to the Web Central Process Navigators to make them consistent with the additions for the Smart Client Process Navigators:
- Asset Portal - Background Data (Smart Client Only � do not put on Web)
- Asset Portal - Equipment Asset Control (updated process, add new URLs, don�t add grid views)
- Asset Portal - Furniture Asset Control (updated process, add new URLs, don�t add grid views)
- Asset Portal - Depreciation (new process)
- Add some telecom views
- Add Furn. Std. views
- Under Equipment, under Telecom Console, add: "View Jack and Equipment Plan" (ab-ap-eq-plans.axvw )
- Change "Telecom Assets Console" to "Equipment Assets Console" (3026259)
- Web Central, move Edit Furniture Standards from the Tagged Furniture process to the Background Data process, as that is where all other standards data is developed.
- Change both "Tagged Furniture" process titles to just "Furniture" since furniture standards inventory tasks are included.
- Software - View and Edit Software Standards - Move to Background process.
- Add rules to publish Tagged Furniture and Furniture Standards to the drawing publishing rules table.
- Add a Process task to publish furniture graphics.
Space
- Add reports in Shared Workplace Chargeback: "View Over-allocated and Under-allocated Rooms", "View Overall Utilization by Department", and "View Overall Utilization by Room".
- Import - afm_ptasks_view_overallocated_rooms.xml
- Update Space Planning & Management P-Nav to make it clearer and more organized (3024947)
- Add three tasks to the Space Inventory & Performance activity to add/edit hatch patterns. (3026975)
Emergency Preparedness
Define Systems -- need a new .axvw - ab-ep-def-systems.axvw --- Change Smart Client PNav to refer to this Web view since the -gd view is actually a Web View
Define Systems Dependencies -- need a new .axvw - ab-ep-def-system-dependencies.axvw
- Add two new views to the Web Emergency Preparedness Business Process Owner process:
Define Geographic Locations----------ab-def-geo-loc.axvw
Define Locations
Define Organizations
Define Companies ---------- ab-rplm-companies-define.axvw
Define System Types
- Smart Client Process Navigator - Add "Define System Types" - The new view should be: ab-ep-def-system-types-gd.axvw.
- Business Process Owner - Remove Define Recovery Team Call List and add to Emergency Response & Recovery Teams process (3026788)
- (3026830):
UPDATE afm_ptasks SET task_id = 'Define Employee Emergency Information' WHERE activity_id = 'AbSpaceEmergencyPreparedness' AND process_id = 'Business Process Owner' AND task_id = 'Enter Employees Emergency Contact Information';
- (3026831):
UPDATE afm_ptasks SET task_id = 'Update Advisory Bulletin' WHERE activity_id = 'AbSpaceEmergencyPreparedness' AND process_id = 'Business Unit Managers' AND task_id = 'Edit Advisory Bulletin and Instructions for Managers';
Reservations Activity
- Change legacy background data views to use newer location and organization views ((3024786)
Hoteling Activity
- Activate the Hoteling activity:
UPDATE afm_activities SET is_active = 1 WHERE activity_id = 'AbSpaceHotelling';
INSERT INTO afm_actprods (product_id, activity_id, activity_cat_id) VALUES ('AbWorkplaceServices', 'AbSpaceHotelling', 'NONE');
- Create Hoteling Process Navigator entries:
Create three new users with three new roles: HOTEL ADMIN, HOTEL ALL DPS, and HOTEL NO APPROVAL (both user name and role name)
Create three new groups: HOTELING ADMINISTRATION, HOTEL BOOKINGS ALL DEPARTMENTS, HOTEL BOOKINGS WITHOUT APPROVAL
Assign HOTEL ADMIN to HOTELING ADMINISTRATION, HOTEL ADD DPS to HOTEL BOOKINGS ALL DEPARTMENTS, and HOTEL NO APPROVAL to HOTEL BOOKINGS WITHOUT APPROVAL:
Reservations Activity
- For two records in afm_ptasks, the task_file is set to "ab-sp-def-loc.axvw", but it should be set to "ab-sp-def-loc-rm.axvw". (3024964)
- Activity AbWorkplaceReservations, process Reservation Manager
- Activity AbWorkplaceReservations, process Develop Background Data
Service Desk/On Demand/Preventative Maintenance Activities
- Add a task to allow clients to review and submit previously un-submitted service requests. (3021037)
- Put Bus. Proc. Owner process at top
UPDATE afm_processes SET display_order = 50 WHERE activity_id = 'AbBldgOpsHelpDesk' AND process_id = 'Business Process Owner';
UPDATE afm_processes SET display_order = 50 WHERE activity_id = 'AbBldgOpsOnDemandWork' AND process_id = 'Business Process Owner';
UPDATE afm_processes SET display_order = 50 WHERE activity_id = 'AbBldgOpsPM' AND process_id = 'Facilities';
UPDATE afm_processes SET display_order = 75 WHERE activity_id = 'AbBldgOpsPM' AND process_id = 'Maintenance';
UPDATE afm_processes SET display_order = 700 WHERE activity_id = 'AbBldgOpsPM' AND process_id = 'Service Desk Manager';
- Add vendors to On Demand Work under Inventory Manager (3026448)
- Consolidate the views that supervisors and craftspersons use to issue, update, and update labor hours for work requests.
- Add Define Work Teams task (3026500)
- Update afm_ptasks to include Define Geographical Locations in the Business Process Owner processes for Service Desk, On Demand Work, and Preventive Maintenance.
Along with the inclusion of the Timezone field on the City tab, this will allow users to define timezones for use in these applications.
Energy Management Activity
- Change activity_id = "AbRPLMEnergyManagement" to "AbRiskEnergyManagement"
- Add Process Navigator entries
Environmental. Sustainability:
Hoteling Activity
Real Estate Portfolio Management Domain
- New Suite view additions listed in: \\Coleburn\Thetis\Spec\Yalta\Yalta9\active\Smart Client Process Navigator Views.docx
For Suites should be under Lease Administration Suite Inventory (CAD)
Also the last eight views should be on the Web PNav under Suite Analysis
Also add to afm_userprocs for user AFM
- Portfolio Management / Background Data --- under Define Locations add Define Counties - ab-repm-counties-define.axvw
- Update task list for: AbRPLMLeaseAdministration / Lease Portfolio
Project Management Activity
- UPDATE afm_ptasks SET task_file = 'ab-proj-projects-calendar.axvw' WHERE task_file = 'ab-proj-projects-calendar-mssql.axvw';
- Add afm_ptask for �View Active Projects Timeline� ( ab-proj-active-projects-timeline.axvw ) under Capital Project Management / Project Management / Monitor / View Projects Map
Localization Activity
- Add view for: Edit Language Glossary Table (lang_glossary) (3027060)
Licensing
- Define a new ACTIVITY LICENSEE role for application-style licensing.
- Create a new AIDEMOACT for testing activity style licenses and Z-NAMED% users for testing named licensing.
Technologies Domain
- Add 3D chart views
- Add new grid and paginated report sample views to the Technologies Process Navigator (3027629)
Data changes:
System:
Preventive Maintenance Activity
- Update helpdesk_sla_response and helpdesk_sla_steps for an extra Verification step in one of the PM SLAs.
Hoteling Activity
- Add Activity Parameters.
- Add activity_type of �SERVICE DESK � HOTELING�
- Add afm_groupsforroles data for hoteling
- Add afm_userprocs data for hoteling
- Add the "SPAC%" security group to the roles: HOTEL ALL DPS and HOTEL NO APPROVAL (3025571)
Asset Management Domain
- Add records to afm_dwgpub for jk and eq assets:
rule_id = AbPubJk; table_assigned = jk; rule_type = JSON; is_active = JSON; title = Publish Jacks
rule_id = AbPubEq; table_assigned = eq; rule_type = JSON; is_active = JSON; title = Publish Equipment
Version 18.2 Database Version 130
Schema Preferences
- Update Db Version Date to: 2009.09.13
- Update Db Version number to: 130
Schema changes
System
- afmroles: changed vpa_restriction to be 5000 characters in size. (3022214)
- Set the following field's afm_type to "Calculated":
| Table Name |
Field Name |
| afm_holiday_dates |
auto_number |
| fn |
fn_id |
| fn_trial |
fn_id |
| gp |
gp_id |
| grp_trans |
grp_trans_id |
| mo |
mo_id |
| pms |
pms_id |
| reserve |
res_id |
| reserve_rm |
rmres_id |
| reserve_rs |
rsres_id |
| rmpct |
pct_id |
| serv |
serv_id |
| system_dep |
auto_number |
| vert |
vert_id |
- rm: Added data transfer field
- em: Added a document field for Employee photo.
Real Estate Portfolio Management Domain
- contact: Added a document field for contact photo.
Condition Assessment Activity
- Added assessment_id to activity_log and hactivity_log tables. Same as activity_log_id, calculated so can not manually edit. Automatically filled in.
Service Desk/On Demand Work Activities
- Ran "System/ Schema/ Define/ Update Service Desk and On Demand Work SQL Views" to recreate hactivity_logmonth SQL view (3023701)
Preventive Maintenance Activity
- Support SLA's for PM Work Requests:
- Added field helpdesk_sla_request.pmp_id
- Added new table named “pmgen” and titled “PM Work Order Generation Rules”. (Provides for defining schedules, for filtered conditions, for when PM Work Orders will be auto-generated.)
- Added field pmp.pmp_ids_to_suppress
Project Management Activity
- project table; fields date_app_mgr2 and date_app_mgr are currently Char(10); changed to be date fields (33024244)
Localization Activity
- Add Localization activity data (3023984)
8 tables affected:
afm_tbls (definitions added for: lang_lang, lang_strings, lang_files, lang_enum, lang_glossary )
afm_flds (definitions added for: lang_lang, lang_strings, lang_files, lang_enum, lang_glossary )
afm_activities
afm_actprods
afm_processes
afm_ptasks
afm_userprocs
afm_wf_rules
Localization
To get the new fields into afm_flds_lang ran:
INSERT INTO afm_flds_lang (table_name, field_name)
SELECT table_name, field_name FROM afm_flds
WHERE NOT EXISTS (SELECT 1 FROM afm_flds_lang afm_flds_lang_inner
WHERE afm_flds_lang_inner.table_name = afm_flds.table_name
AND afm_flds_lang_inner.field_name = afm_flds.field_name )
Workflow Rules
SysAdmin
- Added Data Transfer WFR
- Added Cascading Updates and Deletes WFR
Condition Assessment Activity
- Added ConditionAssessmentService WFR
Preventive Maintenance Activity
- Deleted all existing WFR's for PM and then added PMEventHandlers for v18.2
Capital Budgeting:
- Update xml_rule_props field for copyTemplateActionsToProject to handle V1.0/V2.0 views
Process Navigator
System
- Added task "Merge Primary Key" under System Admin/ Business Process Owner/
- Changed: /Technologies /System Integrator Views /Parts for Reports / "Report with PDF and Excel Export Actions" to: Report with DOC, PDF, Excel, and Data Transfer Actions
- Added sub-folder values to the afm_activities table for those records that are Active, have Web Processes, and are missing values for the sub-folder. (Needed for localization).
- Added "Report with Passed Restrictions & Parameters" to Business Process Owner Views / Paginated Reports
- Removed help links from some afm_activities
- Updated help links for afm_processes
Preventive Maintenance
- Added a process on the Process Navigator “Service Desk Manager”.
- Added a task “Manage Work Order Generation Rules” to the Maintenance Manager process.
- Added a task “Planning Board” to the Supervisor and Supervisor (Work Requests) processes within AbBldgOpsPM.
- Changed the task name “View Unissued PM Work Orders” to “View Active PM Work Orders”.
- Added a task “Overdue PM Work Requests” to the Reports process.
- Changed file for PM / Service Desk Manager / "Manage Service Level Agreements" task
- Added PM Dashboard
Condition Assessment
- Implemented the Process Navigator for Web Central
Localization Activity
- Added an afm_activities record for the Activity: “AbSolutionsLocalization”
- Assigned the AbSolutionsLocalization activity to the AbSolutionTemplates (Technologies) Domain with an afm_actprods record.
Space
- Added an additional Space Mgmt dashboard
Capital Budgeting:
- Updated Process Navigator
Changed task file for Capital Budgeting > Prioritize & Estimate (Optional) > Add or Edit Actions view
Added new task Prioritize & Estimate (Optional) > Create Facility Condition Index Scenarios
Changed task file for Prioritize & Estimate (Optional) > Analyze Facility Condition Index Scenarios
System Administrator
Data changes
Condition Assessment
- Added and updated sample data for the following tables:
- project
- afm_processes
- afm_ptasks
- afm_userprocs
- wo
- activity_log
- wr
- wrcf
- wrtr
- Add image data to 4 activity_log records
- Add to projecttype table: project_type="ASSESSMENT - ENVIRONMENTAL"; description="Environmental Assessment project"
- Copied Condition Assessment images from image fields to document fields.
Preventive Maintenance
- Sample data changes:
- pmgp_add_ahu_route.xml
- pms_update_pm_group.txt
- cf_add_jeff_to_market_team.txt
- pmp_for_suppression.xml
- pmgen_for_ahu_pm_pmgp.xml
- helpdesk_sla_request_for_pm_slas.xml
- helpdesk_sla_response_for_pm_slas.xml
- afm_ptasks_correct_sla_task_file.txt
Service Desk/On Demand Work
- Changed link in Notification of Escalation for Response (3023826):
Space
- Updated room types and room standards hatch patterns because highlight pattern legends did not display because the Hpattern Acad value was either null or white. (3023798)
- Added building images to the bl and property tables doc fields.
Project Management
- Updated dates for activity_log records assigned to projects so that the tasks are more current (3015504)
Version 18.1 Database Version 129
Schema Preferences
- Updated Db Version to 129
- Updated Db Version Date to 2009.06.29
Web - Core
Schema:
- afm_flds table: set "Is Asset Text?" to 4 for rm.area
- Add fields for default width and height for drawings in paginated reports at tabloid (11x17) or at A3 size (as opposed to the A4 size). (3022469)
- Localization - Update afm_flds_lang from afm_flds
Workflow Rules:
- Add new WFR's for v18.1 Space Mgmt, RPLM, and core (3021444)
- DELETE FROM afm_processes WHERE display_order = 0 AND process_type = 'WINDOWS'; (3021903)
- Add new AbSystemAdministration WFR: AbSystemAdministration-ConfigHandlers
- All AbSolutionsViewExamples WFRs have been removed and replaced by four new WFRs:
- AbSolutionsViewExamples-LogicExamples
- AbSolutionsViewExamples-JobExamples
- AbSolutionsViewExamples-TimelineExamples
- AbSolutionsViewExamples-WSClientExamples
- Import .../ab-products/common/AbCommonResources-workflowrules.xml ( AbCommonResources-SpaceService WFR was previously incorrect )
- Paginated reporting - import - afm-docx-paginated-report-wrokflow-rule.xml
- DELETE FROM afm_wf_rules WHERE activity_id = 'AbRPLMPortfolioAdministration' AND rule_id = 'getMapData'
- Import: paginated_reporting_wfr.xml (this adds the generatePaginatedReport rule with the ReportBuilderJob as opposed to the previously added generateDocxReport rule for ReportBuilder.)
- Import: PerUserFileExpiration_afm_wf_rules.xml (3022579)
- Four scheduled rules use incorrect repeatInterval value.
- First, restrict afm_wf_rules WHERE xml_sched_props LIKE '%repeatInterval="86400000"%'
- Delete the xml_sched_props value from the AbBldgOpsHelpDesk/ testTemplate rule.
- Then, change "86400000" to "86400" (these values should be seconds in a day; NOT milliseconds).
- Add AbCommonResources-EmailService and AbCommonResources-HighlightPatternService
- Import the new rules defined in ab-products/solutions/logic-cookbook/AbSolutionsLogicCookbook-workflowrules.xml
- Import the workflow rules from AbSolutionsWorkflow-workflowrules.xml
Process Navigator:
- UPDATE afm_ptasks SET task_file = 'ab-setup-license-file.axvw' WHERE task_file = 'setup-license-file.axvw' (3022747)
- UPDATE afm_ptasks SET task_action = 'afm_vertservtorm' WHERE task_action = 'AfmConvertVertServToRoom'; (3023147)
- DWF to SWF changes:
- Import afm_ptasks_DWF_to_SWF_AbEmergPrep.xml
- Consolidate Enhanced All Room Inventory and Basic All Room Inventory in Windows and CAD PNavs. (3023221)
- Added help links for new v18.1 Web processes.
- Update online help links. Import: misc_help_links_v181.xml
- Two "Calculated Field" reports added to AbSolutionsViewsSystemIntegrator (calculated_SQL_field_ptasks.xml)
- Five "Cross-table" views added to AbSolutionsViewsSystemIntegrator (cross_table_ptasks.xml); (cross_table_ptasks_additional.xml)
- Update GIS views (3022315)
- Change Move Management activity to Enterprise Move Management (3022528)
- Remove the "/FM" from the ARCHIBUS/FM System Administration activity title (3022528)
- Update for help links.
- Under: Technologies > Software Engineer Views > Advanced Techniques. Import:
- questionnaires_ptasks.xml
- Questionnaire Wizard (solutions/programming/questionnaire/ab-ex-prg-questionnaire-wizard.axvw)
- Virtual XML Fields: A Questionnaire Report (solutions/programming/questionnaire/ab-ex-prg-questionnaire-report.axvw)
- Virtual XML Fields: A Questionnaire Form (solutions/programming/questionnaire/ab-ex-prg-questionnaire-form.axvw)
- Generating a Questionnaire Action Response (solutions/programming/questionnaire/ab-ex-prg-questionnaire-action-response.axvw)
- Add the AbSolutionsLogicCookbook to the PNav: (3022729)
- Make inactive: Workplace Portal activity
- Make inactive: Building Ops/Building Ops activity
- Add new icons for Product level in PNav. Import: afm_products_32x32_icon_names.xml
- Correct the large icons for the Activity and Move Management processes. Import: afm_process_16x16_icon_names.xml
- Add paginated report views to the Technologies PNav. Import:
- 18-1_afm_processes_entries_Paginated_Reports.xls
- 18-1_afm_ptasks_entries_Paginated_Reports.xls
- afm_userprocs_entries_PaginatedReports.xml
Data:
- Import items-3023183-doc1.xml -- adds Drawing Publishing rules: AbPubRegcompliance, AbPubZone
- UPDATE afm_dwgs SET report_height_tabloid = 9.5 (3022912)
- Table ac - corrected sample data in hierarchy trace field
- add to afm_scmpref.preferences:
- <field table="programtype" field="program_type" />
- <field table="programtype" field="description" />
- In cases for which we are listing “Reports” as the process, don't repeat the activity name in the Report process name.
- Bad data in contact table: UPDATE contact SET contact_id = UPPER( contact_id ) (3022636)
- Add perUserFileExpiration activity param. Import: items-3022578-doc1.xml (3022578, 3022579)
- Add group publishing rule and update descriptions of enterprise graphics rules. Import: afm_pubdwg_entgraphics_rules.xml (3022586)
- Add the ESRI ArcGIS Online Activity Param: ESRIArcGisOnlineServicesKey -- Import: ESRIArcGisOnlineServicesKey.xml (3022621)
Real Estate Portfolio Management Domain
Schema:
- Add fields:To invoice_payment table (An invoice_payment record with a NULL invoice_id can be used to record overpayments):
- contact_id --- to record who the payment is from, validates on contact table
- payment_method --- Char 6 -- enum: CHECK;Check;CREDIT;Credit Card;DEBIT;Debit Card;PAYPAL;Paypal;WIRE;Wire Transfer;
- Forecasting:
- Add table: portfolio_scenario (portfolio_scenario_id and description fields)
- gp table - Add field: portfolio_scenario_id
- Create a validating Portfolio Scenario table.Make sure this always has a "Baseline" default scenario record.
- Change ml_heading of portfolio_scenario_id from: "Portfolio Scenario Code" to: "Portfolio Scenario"
- Add portfolio_scenario as validating table for gp.portfolio_scenario_id in afm_flds
- Change the fields ( area_common, area_rentable, area_usable ) in the ls table to be Numeric 10.2 instead of Numeric 9.1 (3022851)
Workflow Rules:
- Import ...\schema\ab-products\rplm\common\AbRPLMPortfolioAdministration-workflowrules.xml ( updates the AbRPLMLeaseAdministration-calculateCashFlowProjection eventhandler to use the new "simple" workflow methods. )
- Import: afm_wf_rules_AbRPLMGroupSpaceAllocation_updateGroupAllocationCosts.xml
- Import: RPLM_Portfolio_Scenarios_wfr.xml
- Import WFR: ...\schema\ab-products\rplm\common\AbRPLMChargebackInvoice-workflowrules.xml file
Process Navigator:
- Add new PNav entries for Cost Admin and Cost Chargeback and Recievables
- Change the domain "Real Property Portfolio Management" to "Real Estate Portfolio Management"
- Make inactive: Real Property and Lease Portal activity
- Add REPM dashboards. Import:
- REPM_Dashboard_afm_processes.xml
- REPM_Dashboard_afm_ptasks.xml
- REPM_Dashboard_afm_userprocs.xml
- Add To: Real Property Portfolio Management – Cost Chargeback & Invoicing – Business Process Owner:
- Add: under - Real Estate – Portfolio Management – Portfolio Management – Reports. Import
- PortfolioAdministration_Reports_Afm_processes.xml
- PortfolioAdministration_Reports_afm_ptasks.xml
- PortfolioAdministration_Reports_Afm_userprocs.xml
- Buildings by ...
- ... Country ab-rplm-pfadmin-bldgs-by-country-report.axvw
- ... City ab-rplm-pfadmin-bldgs-by-city-report.axvw
- All Buildings and their Book Values (View file name: ab-rplm-pfadmin-bldgs-book-values-report.axvw)
- Structures by:
- ... Country (View file name: ab-rplm-pfadmin-struc-by-country-report.axvw)
- ... City (View file name: ab-rplm-pfadmin-struc-by-city-report.axvw)
- Land by:
- ... Country (View file name: ab-rplm-pfadmin-land-by-country-report.axvw)
- ... City (View file name: ab-rplm-pfadmin-land-by-city-report.axvw)
- All Properties and their Book Values (View file name: ab-rplm-pfadmin-props-book-values-report.axvw)
- Portfolio Investments (View file name: ab-rplm-pfadmin-investments.axvw)
- Portfolio Sales (View file name: ab-rplm-pfadmin-sales.axvw)
- Add: Portfolio Forecasting activity
Data:
- Import sample data for Forecasting activities:
- LXBuilding.xml
- LXFloor.xml
- LXGroups.xml
- LXCosts.xml
- Update cost_tran_recur records for rent costs in HQ bldg that expire in 2008 and 2009 to expire later
- Import: prepayments_for_invoice_payment_table.xml
- ls table - Updated dates; updated and filled in area negotiated. Import: ls_date_update_and_filling_the_area_neg_rentable_field.xml
- Invoice - Closed an old invoice. Make Several new invoices. Import: RPLM_v18_1_invoice.xml
- Invoice_payment - Added some invoice payments. Added some prepayments. Import: RPLM_v18_1_invoice_payment.xml
- Cost_tran_recur - An update to the cost dates. Import: cost_tran_recur_plus_three_years.xml
- Cost_tran_sched - An update to the cost dates. Import: cost_tran_sched_plus_three_years.xml
- Cost_tran - An update to the cost dates. Some costs were marked with Cost Status as Receivable but the Date Paid was not NULL.
- Updated some of the cost statuses to Received. Added Invoice Code (since several invoices were added).
- Import: cost_tran_plus_three_years_and_updated_invoice_id.xml
Space Management Domain
Schema:
- Add fields:
- rmcat table:
- used_in_calcs: Char 20 default "all_totals"
- enum list: all_totals;All Totals;rm_totals;Room Totals Only;dp_comn_ocup_totals;Dept., Common, Ocup Totals Only
- supercat: Char 4 default "PERS"
- enum list: VERT;Vertical Penetration;SERV;Service Area;PERS;Personnel Area;OTHR;Other Area
- cost_sqft (same as in bl and fl tables)
- rm table:
- cost_sqft (same as in bl and fl tables)
- cap_em (Employee Capacity)
- rmcat.used_in_calcs -- add ";no_totals;No Totals" to the enum list.
- rmcat.supercat -- change the PERS value in the enum to: USBL;Usable Area; change the default value to "USBL"
- Also: UPDATE rmcat SET supercat = 'USBL';
- Decimal places set to 0 in the fl table in the physical database (not in afm_flds). Run Update Schema on the fl table to resolve. (3022415)
- In afm_flds table, REPLACE( ml_heading, 'Comn.', 'Common') WHERE ml_heading LIKE '%Comn.%' (3022852)
- fl table -- add "Total" to the ML Heading for the Room Area fields (3022853)
Workflow Rules:
- Import: workflow-highlight-dialog.xml
Process Navigator:
- Add new PNav entries for v18.1 Space Mgmt Web Activities
- Remap existing Web Space activity ptasks to new views. Import: afm_ptasks_webc_space_legacy_views.xml
- Change the titles of the Process Navigator tasks that generate these graphics from:
- Publish to SWF (This Drawing)
- Publish to SWF (All Drawings)
To
- Publish Enterprise Graphics (This Drawing)
- Publish Enterprise Graphics (All Drawings)
- Update Windows and CAD PNavs. Import:
- Space_Win_CAD_afm_activities.xml
- Space_Win_CAD_afm_processes2.xml
- Space_Win_CAD_afm_ptasks.xml
- Space_Win_CAD_afm_userprocs.xml
Data:
- Add an Activity Parameter: AbCommonResources includeGroupsInUnifiedSpaceCalcs value = 1
- UPDATE rmcat SET supercat = 'VERT' WHERE rm_cat = 'VERT';
- UPDATE rmcat SET supercat = 'SERV' WHERE rm_cat = 'SERV';
- Eliminate group data from HQ 17, 18, 19: DELETE FROM gp WHERE bl_id='HQ' and fl_id in ('17','18','19');
- Import new Space sample data:
- NewRoomCategories.xml
- NewRoomTypes.xml
- HQ15HQ01Floors.xml
- HQ15HQ01Drawings.xml
- HQ15HQ01Gross.xml
- HQ01Groups.xml
- HQ15HQ01Rooms.xml
- HQ17HQ18HQ19Rooms.xml (New Vertical and Service Rooms)
- XC02XC03XC04Rooms.xml (New Vertical and Service Rooms)
- HQ15Employees.xml
- Run Space Planning & Management / Space ChargebackDevelop / Space Chargeback:
- Update Area Totals
- Perform Chargeback
- Run Space Planning & Management / Personnel and Occupancy / Develop Background Data:
- Update Employee Headcounts
- UPDATE rm SET cap_em = (SELECT std_em FROM rmstd WHERE rmstd.rm_std = rm.rm_std) WHERE rm_std IS NOT NULL AND cap_em = 0;
- Update hatch patterns. Import: dp_facilities_highlight_pattern.xml
- Drawing publishing rules: AbPubGp -- is missing "gp" in Assigned table column. Add it.
Service Desk and On Demand Work activities
Schema:
- Work Team support for Work Orders (3021926, 3021301)
- Add work_team_id to wo and hwo tables (copy from table wr and hwr)
- Update the enumerated list for two columns in helpdesk_sla_response: (3021917)
- interval_to_complete and interval_to_respond. Add minutes:n;Minute;h;Hour;d;Day;w;Week;m;Month
- Update translations in afm_flds_lang: Import items-3021917-doc2.xml
- messages.description - change to be size 512
- messages.is_rich_msg_format - Add. smallint; Default 0; enumeration list - 0;No;1;Yes
- support configurable e-mail messages (3022032, 3021340)
- afm_wf_steps - add fields "attachments", "body_message_id", and "subject_message_id" - import KB3022032-afm_wf_steps-fields.xml
- afm_wf_rules - add new WFR's - import KB3022032-afm_wf_rules_data.xml
- afm_wf_steps - adds sample data - import KB3022032-afm_wf_steps_data.xml
- Ran DBUPWW.abs to add work_team_id to the SQL view wohwo
- Forwarding SD/OD steps (3020144) -
- afm_wf_steps data updated
- 3 afm_wf_rules added
- Fields with field_name like 'step_status%' - updated enum_lists.
- custom notification support (3021340) -
- import 2 new (DISPATCH_VIEW, ASSIGN_VIEW) and update 1 (REVIEW_VIEW) afm_activity_params records.
- Import new and updated messages for Service Desk and On Demand Work.
- Add 3 fields:
- helpdesk_sla_response.notify_craftsperson
- helpdesk_sla_response.notify_service_provider
- helpdesk_sla_steps.notify_responsible
- Update SQL views for SD/OD
- Step Type enum list updated to have a display value of “Edit and Approve” where the data value is “review” (update for v17.3 missed some).
Workflow Rules:
- Import ...\schema\ab-products\bldgops\common\AbBldgOps-workflowrules.xml
Process Navigator:
- new navigator tasks for SD/OD / System Integrator - Manage Notifications; and for Searching for requests
- DELETE FROM afm_ptasks WHERE activity_id = 'AbBldgOpsHelpDesk' AND process_id = 'Service Desk Manager'
AND (task_id = 'Review all Service Requests and Work Requests' OR task_id = 'Review all Escalated Service Requests');
- DELETE FROM afm_ptasks WHERE activity_id = 'AbBldgOpsOnDemandWork' AND process_id = 'Service Desk Manager'
AND (task_id = 'Review all Service Requests and Work Requests' OR task_id = 'Review all Escalated Service Requests');
Data:
- Add new step in afm_wf_steps called "Forward to Work Team" - import items-3021926-doc2.xml (3021926, 3021301)
- Add the ability to forward service requests in the Requested status with Search. Import: bldgops_forward_requested.xml
Reservations activity
Schema:
- run new reservationsSQLViews.abs
Data:
- Import messages - 2008-01-13-Reservations-Timeout-message.xml (3021386)
- Add new messages to database to support additional timezone functionality - items-3021928-doc1.xml (3021928)
- Import rm_config_data.xml
- Import rm_arrange_data.xml
Preventive Maintenance activity
Process Navigator:
- Consolidate all PM reports into one process on P-Nav: (3021910)
- DELETE FROM afm_processes WHERE activity_id = 'AbBldgOpsPM' AND process_id LIKE 'Preventive Maintenance%';
- import items-3021910-doc1.xml, items-3021910-doc2.xml, items-3021910-doc3.xml
US Federal Property Registry activity
Data:
- Update sample data:
- UPDATE grp_trans SET size_unit_of_measure = NULL WHERE size_unit_of_measure = 0;
- UPDATE grp_trans SET mission_dependency = NULL WHERE mission_dependency = 0;
- UPDATE grp_trans SET historical_status = NULL WHERE historical_status = 0;
- UPDATE grp_trans SET utilization = NULL WHERE utilization = 0;
Version 17.3 Database Version 128
Schema Preferences
- Updated Db Version to 128
-
Updated Db Version Date to 2008-01-08
Web – Core
Schema:
- Added the sql_pwd and sql_uid fields to the afm_users table (same as in afm_roles) (3020695,3018685).
- afm_flds_lang updated to include all fields from afm_flds.
Workflow Rules:
- Imported latest WFRs from: /schema/ab-products/solutions/common/AbSolutionsViewExamples-workflowrules.xml.
- Imported AbCommonResources Workflow rules to get the new job rules.
- Imported AbSystemAdministration-runFileSearch.xml.
- Removed schedule_properties from the five WFRs that service the View Definition Wizard: deleteFile; getListOfFilesToConvert; getViewContents; moveAndRenameFile; writeViewContents.
Process Navigator:
- Added view for "Assign Security Groups to Roles" (ab-edit-groupsforroles.axvw).
- Added "Find Files with Duplicate File Names" under AbSystemAdministration / System Integrator.
- Removed "Users and Their Profiles" task and views from System Administration->Business Process Owner. It duplicated "Add or Edit Users" task, and used an outdated edit form, which did not use the correct edit form for password change.
(3020726)
- Help links added and updated
.
Data:
- Changed ARCHIBUS SYSTEM ADMINISTRATOR role to NOT have sql_pwd and sql_uid values. Moved those sql_pwd and sql_uid values to another user. (3020671)
Preventive Maintenance activity
Schema:
- pmp table:
- Added “doc” field.
- Added “eq_std” field.
- Changed display value for pmp.pmp_type from "Housekeeping" to "Location" where data value is "HK". (3020450)
- pmps table:
- pms table:
- Added "site_id" field.
- Default value of field “fixed” changed to “1”. (3020450)
- wo (and hwo) tables:
- Changed display value for wo.wo_type (and hwo.wo_type) from "Housekeeping Prev. Maint." to "Location Prev. Maint." where data value is "HSPM". (3020450)
Workflow Rules:
- Added for Web C Prev. Maint. business logic (afm_wf_rules).
Process Navigator:
- Additions for Web C Prev. Maint. processes and tasks (afm_processes, afm_ptasks ).
US Federal Property Registry activity
Schema:
- Added tables:
- grp Government Real Property
- grp_agency_and_bureau Government Agencies and Bureaus
- grp_trans Data Transactions - Government Real Property
- grp_type Government Real Property Types
- grp_use Government Real Property Uses
- Added "Property Unique ID" field from gpr table to the bl, property and eq tables. grp_uid (copy grp.unique_identifier). This field is NOT validated since the typical user process is to first add the
grp_uid values to the bl, property, or eq tables and then later on perhaps add them to the grp table.
Workflow Rules:
- Added workflow rules for this activity.
Process Navigator:
- Additions for US Federal Property Registry; processes and tasks (afm_processes, afm_ptasks ).
Data:
- Imported standard gov. agencies into the grp_agency table.
- Added a new security group: Government RPLM Inventory Process Owner.
- Added a new role: Government RPLM Inventory Process Owner.
- Assigned the new group to the new role.
- Created a new user "Government RPLM Inventory Process Owner" and assigned it to the role: Government RPLM Inventory Process Owner.
Reservations activity
Schema:
-
Added Timezones table. Added FKey from city table to Timezones. Added standard timezones data to Timezones table. (3020246)
- Updated Foreign Keys for reserve_rm to re-establish the existing defined FKeys.
Workflow Rules:
- Added to afm_wf_rules table (3018035).
Data:
- Messages added to the messages table for new functionality so that reservations cancellation times will consider different time zone needs. (3018035, 3021176)
Portfolio Administration and Lease Administration activities
Schema:
- Updated su.facility_type_id to validate against the facility_type table. (3020405)
- Changed enum list for op.who_can_exercise to be all caps: LANDLORD;LANDLORD;TENANT;TENANT;BOTH;BOTH (3021144)
Also, the default value for op.who_can_exercise changed from "Both" to "BOTH".
Process Navigator:
- Added view: “Lease Expirations by Year - Chart” (ab-rplm-lsadmin-leases-expiring-per-year-chart.axvw).
Service Desk and On Demand Work activities:
Process Navigator:
- Changed the task names in afm_ptasks of the following tasks within activity_id = "AbBldgOpsOnDemandWork" and process_id = "Inventory Manager". (3020788)
- changed "View and Edit Equipment Standards" to "Define Equipment Standards"
- changed "View and Edit Equipment Inventory" to "Define Equipment"
- changed "View and Edit Parts Inventory" to "Define Parts Inventory"
- changed "Edit Inventory of Tools" to "Define Tools"
Data
- Corrected standard SLA response: UPDATE helpdesk_sla_response SET serv_window_days = '0,1,1,1,1,1,0' WHERE serv_window_days = '0,1,1,1,1,0'; (3020457)
Version 17.2 Database Version 127
Schema Preferences: The Database Version schema preference (Afm_Scmprefs) was set to 127.
Database Version date was set to 2008.10.23.
Schema Changes:
- Ran the latest reservationSqlViews.abs to update the Reservations activity SQL views (3017224)
- afm_wf_steps.display_order -- changed size in afm_flds from 10 to 5. (3017390)
- Added date_pwd_changed and num_retries to the afm_users table. (3017913)
- Change wr_step_waiting.step_type from size of 32 to size of 16 to match the other step_type field sizes.
- Add table definition for workflow_substitutes (3016298):
- Added new table: workflow_substitutes
- Modified existing table to add field: helpdesk_sla_request.default_priority
- Added review;Review;escalation;Escalation;forward;Forward to enumeration list for field step_type in tables: afm_wf_steps,helpdesk_sla_steps, helpdesk_step_log, activity_log_step_waiting, wr_step_waiting, helpdesk_roles
- Changed surey to survey in enumeration list for field step_type in tables: afm_wf_steps,helpdesk_sla_steps, helpdesk_step_log, activity_log_step_waiting, wr_step_waiting, helpdesk_roles
- RPLM changes for new Property Administration and Lease Administration activities:
- Added tables:
docs_assigned {Assigned Documents}
ot {Ownership Transactions}
facility_type {Facility Types}
ls_clause_type
ls_amendment
ls_alert_definition
- Table changes:
table:op --- fields added
table: ls_resp --- fields added
table: su add fields:
name
description
facility_type_id {validates on the facility_type table}
table: property add fields:
property_type {enum: "Land;Land;Structure;Structure" }
area_manual
address1
address2
prop_photo
table: ls add fields:
automatic_renewal {enum: Yes/No}
use_as_template {enum: Yes/No}
template_name
description {varchar 512}
pr_id {validates on property table}
table: bl add fields:
bldg_photo {document field}
value_book {same as in property table}
value_market {same as in property table}
date_book_val {same as in property table}
date_market_val {same as in property table}
- Change afm_ptasks.task_file to have a size of 128 (was 64) to accommodate longer file names and the fact that adding items to "My Favorites" appends the user name to the file.
- Change afm_processes.dashboard_view to have a size of 128 (was 64)
Set the following fields to have an ARCHIBUS Type of Calculated:
activity_log.step_status
helpdesk_sla_steps.step_status
helpdesk_step_log.step_status_result
wr.step_status
- op table:
Add field: op.date_exercising_applicable
Remove field: date_end
Change Multi-line headings:
date_option to "Date Option Window Ends"
date_start to "Date Option Window Starts"
- pms.schedule_type -- change display value for "meter" and "manual" to "Meter" and "Manual"
- Add fields for IWMS Suite:
gp table: area_manual, date_end, date_start, description, pct_floor, count_em
fl table: area_manual
-
- Cost of resources in Reservations should go out to two decimal places (3018032) Make the following fields have two decimal places (they have none now):
rm_arrange.cost_per_unit
rm_arrange.cost_per_unit_ext
resources.cost_per_unit
resources.cost_per_unit_ext
- Change afm_users.home_page to be an enumerated field in the database, to have a default value, and not allow NULL.
Change the default value for afm_users.home_page to be: ab-dashboard.axvw
UPDATE afm_users SET home_page='navigator-details.axvw' WHERE home_page = 'solutionexplorer-details.axvw'
UPDATE afm_users SET home_page='ab-dashboard.axvw' WHERE home_page = 'dashboard.axvw' ;
(3019063, 3018304)
- Change the enum for afm_users.home_page to make dashboard.axvw be ab-dashboard.axvw
- UPDATE afm_flds SET enum_list =
'ab-dashboard.axvw;Dashboard;navigator-details.axvw;Process Navigator;accessible-details.axvw;Accessible Navigator'
WHERE table_name = 'afm_users' AND field_name = 'home_page'
(3019691, 3018816, 3019781)
- Add site_id to table pms for PM
- Add eq_std to table pmp for PM
- Change the Lease Clauses table's primary key's multiline heading from Responsibility Code to Clause Code
- Update the enumeration list for action_approval_expired fields in the resources and rm_arrange tables
- Changes for problem 3019438
- Remove field "em_id" from the afm_flds for "table": wrhwr
- Re-create the SQL view "wrview" by running dbupww.abs.
- SD/OD: change data type to “smallint” for the following two fields:
helpdesk_sla_response.time_to_complete
helpdesk_sla_response.time_to_respond
- Expand mo.option2 to 35 characters to match em_id (3019423)
- Change fixed_resource_id size from 32 to 64 characters
- Change the primary key of the rm_resource_std table to be combination of fields:
bl_id , fl_id , rm_id , config_id , rm_arrange_type_id , fixed_resource_id
Since, in this case, the new Pkey includes the existing PKey as the last part and has all of the other fields that would be in the Pkey are already set to NOT allow Null
the change for this PKey should not present any problems for users existing data.(3015539)
- Changes to support changing step name from "Review" to "Edit and Approve". (3018622)
- Change afm_wf_step.step to "Edit and Approve" where afm_wf_step.step_type = "review".
- Change the display value in the enum list for the "review" data value to "Edit and Approve" for afm_wf_steps.step_type.
Workflow Rule (WFR) Changes:
- Added, changed, and deleted workflow rules records for:
AbRPLMPortfolioAdministration
AbRPLMLeaseAdministration
AbWorkplaceReservations
AbSolutionsViewExamples
AbSolutionsMyAdn
AbSolutionsWorkflow
AbSystemAdministration
AbCommonResources
- Delete all afm_wf_rules entries for AbSolutionsExtras.
- Change AbWorkplaceReservations-closeReservations from Type Message rule to a Scheduled rule.
- AbCommonResources activity in afm_activities is NOT active by default - set it to active (3019314)
- Service Desk and On Demand Work WFR Changes
- Changed input of workflow rule: AbBldgOpsHelpDesk-archiveRequest
- Added new workflow rules:
AbBldgOpsHelpDesk-checkRequestDuplicates
AbBldgOpsHelpDesk-reviewRequest
AbBldgOpsHelpDesk-forwardApproval
AbBldgOpsHelpDesk-forwardRequest
AbBldgOpsOnDemandWork-cancelWorkRequests
AbBldgOpsOnDemandWork-cancelWorkRequest
AbBldgOpsOnDemandWork-closeWorkRequests
AbBldgOpsOnDemandWork-closeWorkRequest
AbBldgOpsOnDemandWork - issueWorkRequests
Process Navigator Changes:
- Add Process Navigator entries for:
- AbRPLMPortfolioAdministration
- AbRPLMLeaseAdministration
- Update help links for Web Central.
- Add default dashboards for Reservations and Service Desk/On Demand Workd(3018856)
- Solutions Templates Process Navigator entries added and changed
- Drawing Views Process Navigator entries added and changed
- UPDATE afm_users SET home_page = 'navigator-details.axvw' WHERE user_name like 'RESERVATION%' (3018822,3018856)
- Add new tasks to the "System Administrator" process of the AbSystemAdministration activity:
- Run Dashboard Definition Wizard
- Run View Converter
- Service Desk and On Demand Work changes:
- Added processes Supervisor_WR and Craftsperson_WR for activity AbBldgOpsOnDemandWork.
- Changed task files for ptasks for processes Client, Supervisor and Craftsperson in activity AbBuildingOperations.
- Changed task file for AbBldgOpsOnDemandWork – Client – View Maintenance Service Request.
- Added ptask "Determine Ordering Sequence of Service Level Agreements" for process "Service Desk Manager" in activities AbBldgOpsHelpDesk and AbBldgOpsOnDemandWork.
- Added ptask "Define Vendors for process Business Process Owner" in activity AbBldgOpsHelpDesk.
- Removed task "Review/Archive Closed Work Orders" from the PNav in the AbBldgOpsOnDemandWork activity. (3019854)
Data Changes:
- Drawing Publishing Rules (afm_dwgpbub) added and updated. (3018192)
- Activity Parameters table - records added for AbRPLMPortfolioAdministration.
- Changed records for Service Desk and On Demand Work
- Messages table:
Added records for:
- AbRPLMPortfolioAdministration
- AbWorkplaceReservations
- AbSystemAdministration (password messages) (3018223)
- Service Desk and On Demand Work Data Changes:
added Escalation, Review, and Forward steps in afm_wf_steps
- Update bldgops_helpdesk_sla_response data (3017470)
- Add the following new activities (3018095):
- AbRPLMEsriExtensions Geospatial Extensions for ESRI
- AbRPLMEsriArcWeb Geospatial Extension for ESRI ArcWeb Services
- Add the "ED" security group as assigned to the "RESERVATION MANAGER" role.
- Field attribute value has a white space in afm_scmpref.preferences. Remove the extra white space :
<field table="afm_wf_steps" field="step " /> (3017406)
- Sample data additions for RPLM:
site
property
ls
su
contact
cost_tran_recur
ls_amendment (ls_clause_type)
ls_resp (
docs_assigned
ls_alert_definition)
- Sample data changes for RPLM:
property
bl
ls
su
ot
- Employee email: Email addresses for employees do not match their updated names.
Imported data from kb3018342.xls (3018342)
Version 17.1: Database Version 126
Schema Preferences: The Database Version schema preference (Afm_Scmprefs) was set to 126.
Database Version date was set to 2008.02.25
Schema Changes:
- Archiving fails in Svc Desk/OD Work because hactivity_log table is set to AUTOINCREMENT (3016730). To correct:
- UPDATE afm_flds SET dflt_val=NULL WHERE table_name='hactivity_log' AND field_name='activity_log_id'
- alter table hactivity_log: delete primary key
- alter table hactivity_log: modify activity_log_id integer not null default null
- alter table hactivity_log: add primary key(activity_log_id)
- The Process Dashboard requires new columns in the afm_processes table: (3016787). To correct:
- dashboard_layout char(64) : name of the layout AXVW file; used to generate default dashboard view from afm_ptasks records;
- dashboard_view char(64) : optional, name of the custom AXVW dashboard view; if specified, dashboard_layout is not used.
- Also, the afm_process.process_type enumeration needs to be updated, to allow the individual processes to be displayed either in Process Navigator or in Process Dashboards:
Current enumeration: OVERLAY;Overlay;WEB;Web;WINDOWS;Windows;
New enumeration: OVERLAY;Overlay;WEB;Web PNav;WEB-DASH;Web Dashboard;WINDOWS;Windows;
- Multi-language fields added to resource_std table and to afm_scmpref.preferences (3017007).
- Work-around for UPW issue with copying data on tables with circular references.
(The UPW fails to check the "validated_data" when it prepares to copy table data;
it only checks the "validating table" field instead. So it decides that there
is a circular reference even before the actual copy.)
- UPDATE afm_flds SET ref_table = NULL WHERE table_name = 'activity_log' AND field_name = 'wr_id''
- There are two enums (afm_conversions.is_currency and survey.report) that use similar enum lists but in different case. (3017165) This creates problems for the localization kit which does not distinguish enum lists by field but only by the enum list itself.
Altering survey.report has the least affect on users thus the fix is to update the database per the following:
- UPDATE afm_flds SET enum_list = 'YES;YES;NO;NO', dflt_val = 'YES' WHERE table_name = 'survey' AND field_name = 'report'
- ALTER TABLE survey MODIFY report CHAR(4) NOT NULL DEFAULT 'YES'
- UPDATE survey SET report = 'YES' WHERE report = 'yes'
- UPDATE survey SET report = 'NO' WHERE report = 'no'
Workflow Rule (WFR) Changes:
- Added WFR for Move Mgmt - Edit Multiple. (3016919)
Data Changes:
- Missing data in afm_wf_steps:
INSERT INTO afm_wf_steps (activity_id, status, step, display_order, step_type,)
VALUES ( 'AbBldgOpsOnDemandWork', 'Basic', 'Can', 600, 'basic') (3016740)
- Add default security groups to the abCommonResources workflow rules (3015663).
- INSERT INTO afm_flds_lang (table_name, field_name)
(SELECT table_name, field_name FROM afm_flds WHERE NOT EXISTS
(SELECT 1 FROM afm_flds_lang
WHERE afm_flds.table_name = afm_flds_lang.table_name AND afm_flds.field_name = afm_flds_lang.field_name ))
- Some translatable fields are missing from afm_scmpref.preferences (3017089, 3017240):
- Add: afm_wf_steps.step. (Also add the localization fields for afm_wf_steps.step to afm_flds.)
- afm_wf_steps.step_type and afm_wf_steps.status are Enumerated fields. Remove them from afm_scmpref.preferences.
- helpdesk_roles.step_type is an Enumerated field. Remove it from afm_scmpref.preferences.
- helpdesk_sla_response.priority_label and messages.message_text. These do have localization fields so it is appropriate
to have these in the afm_scmpref.prefereces field.
- UPDATE afm_flds SET dep_cols = NULL WHERE ref_table IS NULL.
There are a handful of fields that have values in Fields to Validate even though the Validating Table is Null.
There are no functional problems, that we know of, due to this; but it is not clean.
The above statement cleans this up. The fields with this condition are listed below and can be found by a
restriction on afm_flds WHERE dep_cols NOT NULL AND ref_table IS NULL.
| Table |
Field |
Field to Validate |
| activity_logview |
dispatcher |
dispatcher |
| activity_logview |
manager |
manager |
| activity_logview |
requestor |
requestor |
| activity_logview |
supervisor |
supervisor |
| cf |
position |
|
| cf |
skills |
|
| hwo |
date_closed |
|
| hwo |
name_authorized |
name_authorized |
| hwo |
name_of_contact |
name_of_contact |
| hwo |
name_of_planner |
name_of_planner |
| hwo |
supervisor |
supervisor |
| wo |
date_closed |
|
| wohwo |
date_closed |
|
Version 17.1 Database Version 125
- Schema Preferences: The Database Version schema preference (Afm_Scmprefs) was set to 125.
Database Version date set to 12/03/2007
- Schema Changes:
- Added new tables for new Service Desk and On Demand Work activities:
activity_log_hactivity_log
activity_log_step_waiting
activity_logview
afm_holiday_dates
afm_wf_steps
hactivity_log
hactivity_logmonth
helpdesk_roles
helpdesk_sla_request
helpdesk_sla_response
helpdesk_sla_steps
helpdesk_step_log
hwr_month
work_team
wr_step_waiting
- Modified existing tables to add Service Desk and On Demand Work fields or to modify existing fields:
activity_log
activitytype
afm_activities
cf
hwo
hwr
hwrcf
hwrtr
hwrtt
servcont
wo
wr
wrcf
wrtr
wrtt
- Added "APPROVED" to activity_log.status enumeration list (3015324)
- Added actscns table. (3011777)
- Added Latitude and Longitude fields for property and bl tables to support ESRI integrations (3014386)
- mo table: Changed mo.to_fax and mo.from_fax to 20 chars. (3015676)
- mo table: from_comp_type and to_comp_type fields -- enum lists - add “N/A;N/A;” and make “N/A” the default value
- mo.hours_actual --- set to NOT calculated
- hreserve.res_type; resview.res_type -- removed "continuous;Continuous" from the enum list
- activity_log table: doc field added (3016592)
- The following 2 New enums are added to the is_active field of the afm_dwgpubrules table: (3016027)
SWF;SWF
JSON;JSON
- fl table: Added Nominal Elevation and Nominal Height fields for the ArcObjects script for exporting 3d rooms to GIS. (3016274)
- cf.email -- changed ARCHIBUS Type from "Calculated" to "None"
- Ran the new reservationSqlViews.abs to add the new SQL view for Reservations report (3015618)
- Ran System / Schema / Define / Update Service Desk and On Demand Work SQL Views
- Some fields in tables that are SQL Views have an ARCHIBUS type of None; changed to be Calculated
:
hwr_month
wr_step_waiting tables
activity_log_hactivity_log
activity_logview
resrmview
resview
wohwo
wrhwr
wrview
- Data Changes
- Added some afm_activity_params values for Reservations Activity (3015323)
- Added some messages table values for Reservations Activity (3015369, 3015372)
- Added activity_params values for ESRI ArcWebServices integration
- Added new drawing rules for exporting architectural info to SWF and asset info to JSON format (3016027)
- Added standard and sample data to the new SLA tables added for Service Desk and On Demand Work
- Added Service Desk and On Demand Work Process Navigation and activity data to the following tables:
userprocs
groups
roles
groupsforroles
activity_params
afm_wf_steps
messages
activitytype
questionnaire
questions
helpdesk_roles
afm_holiday_dates
activitytype
- Sample Data changes:
Change some resources.room_service values to "Yes"
activity_log Some Action Titles updated so that the data does not all appear the same. (3016516)
Added latitude and longitude values to the property and bl tables
- WRF Changes
-
Changes required by the updated Capital Budgeting views
- Changes required by the updated Project Management views
- Added one new WFR for the Create FCI Scenarios view
- Changes required by the updated Move Management views and for (3016541, 3015787, and 3015757)
- Added for View Definition Wizard
- Added Service Desk and On Demand Work WFRs
- PNav changes
- Added Service Desk and On Demand Work Process Navigator Entries (activities, actprods, processes, ptasks)
- Changed title of AbBldgOps, in afm_products table, to be "Operations Management"
- Replaced the existing Web Central Building Operations Management views with the equivalent new On Demand forms, as listed in the following table. (3016496)
|
From
|
To
|
|
REQUESTOR
|
CLIENT
|
|
Create Work Request
|
Create Maintenance Service Request
|
|
Review Status of Work Requests
|
Review Maintenance Service Request
|
|
SUPERVISOR
|
SUPERVISOR
|
|
Create and Review as above
|
Create and Review as above
|
|
Approve and Issue Work Requests
|
Issue and Print Work Orders
|
|
Update Work Requests
|
Update Work Orders and Work Requests
|
|
CRAFTSPERSON
|
CRAFTSPERSON
|
|
Create and Review as above
|
Create and Review as above
|
|
Add Craftspersons to Work
|
(Removed)
|
|
Update Work Request
|
Update Work Orders and Work Requests
|
- Added the View Definition Wizard to the Process Navigator under System Administration/ System Administrator: ab-viewdef-wizard.axvw (3016505)
- Capital Budgeting: Added view: "Analyze Facility Condition Index Scenarios" (3011777)
- Changed the afm_activities.subfolder value for the activity “AbSystemAdministration” from
“\ab-system\system-administration” to “\ab-products\system-administration” (3015821)
- Added Tree Control test views to Solution Templates under AbSolutionsViewsSystemIntegrator:
Added a new process "Tree Views" and under that process added:
|
Task
|
View
|
|
Simple Tree - Departments by Division
|
ab-ex-simple-tree-dpxdv.axvw
|
|
Tree with Bridge table - Emp. by Room by Div.
|
ab-ex-bridged-tree-emxrmxdv.axvw
|
|
Tree with Console - Work Requests by Emp.
|
ab-ex-tree-with-console-wrxem.axvw
|
|
H ierarchical Tree - CSI codes
|
ab-ex-simple-hierarchy-tree-csi.axvw
|
|
Hierarchical Tree - Accounts
|
ab-ex-simple-hierarchy-tree-ac.axvw
|
|
Tree with many leaves - all rooms per every
|
Emp. ab-ex-loading-test-large-rm-em.axvw
|
|
Select Values Tree
|
ab-ex-tree-selval-wr.axvw
|
- Add a new process: "GIS Views" under Solution Templates \ System Integrator Views.
In that process added five tasks:
Geocode Properties
Geocode Buildings
Manage Property Portfolio
Manage Leases
Manage Operations
- Assigned the "GIS Views" process to the AFM and ABERNATHY users
- Solution Templates / Business Process Owner Views / Edit Views: Added Edit Form Work Requests (All Fields) - RI (3015391)
- All the “fm_web_central_online_help.htm” help links changed to “afm.htm” (3015325)
- Added two items to the ARCHIBUS Client/Server System module: "Update Service Desk and On Demand Work SQL Views"and "Run SQL Script"
Version 16.3 Database Version 124
- The
Database Version schema preference (Afm_Scmprefs) was set to 124.
- Schema
Changes
- Implemented
"Reservations" activity tables and fields:
- Tables
and fields added have the comment: "Reservations-v16.3"
- New
Tables added were:
- hreserve
Historical Reservations
- hreserve_rm
Historical Room Reservations (Enhanced)
- hreserve_rs
Historical Resource Reservations
- reserve
Reservations
- reserve_rm
Room Reservations (Enhanced)
- reserve_rs
Resource Reservations
- resource_std
Resource Standards
- resources
Resources
- rm_arrange
Room Arrangements
- rm_arrange_type
Room Arrangement Types
- rm_config
Room Configurations
- rm_resource_std
Room (Fixed) Resource Standards
- In
the existing tables, fields
were added to these tables:
- Ran
reservationSqlViews.abs to add Reservations SQL views
- Added
vn_id to
wr and hwr tables. ML heading of "Primary Vendor"
- Ran
DBUPWW.abs to add vn_id to wrhwr SQL view and to the wrhwr table in afm_flds
- Added
messages table.
- Added
afm_activity_params "Activity Parameters" table.
- Adedd
an "email" field to cf table. Same as em.email and afm_users.email.
- UPDATE
afm_users SET locale = 'DEFAULT' WHERE locale IS NULL
- Set
afm_users.locale to NOT allow NULLs
- Added
Schema Preferences fields needed for clustering (3014615):
- afm_scmpref.cluster_internal_use
- afm_scmpref.cluster_num_servers
- Changed
mo.em_id to ALLOW NULL = yes. (3013578)
- Ran
the "Add Work Wizard SQL Views" task to re-create the wr SQL
views due to new fields.
- Added
Cellular Number (cellular) to Contacts table (contact) (3014346)
- Sample
data added for Reservations activity
- Added
RES. SETUP and RES. CLEANUP to probtype table (field is 16 chars so "RESERVATION"
had to be abbreviated.)
- Added
data to afm_activity_params
- Added
reservations messages to the messages table
- Reservations:
security
- created
the following security groups:
RESERVATION APPROVER
RESERVATION ASSISTANT
RESERVATION HOST
RESERVATION MANAGER
RESERVATION SERVICE DESK
RESERVATION TRADES
- assigned
each security group to corresponding role
- created
one user for each of the roles
- Assigned
all Reservations processes to the Reservation users and to user AFM
- Added
SPAC% security group to the RESERVATIONS roles
- Made
the following rm.reservable = yes, and added rm_config and rm_arrange
data for those that did not have it:
HQ 17 109
HQ 17 127
HQ 18 109
HQ 19 107
HQ 19 110
- Linked
Reservations users to employee "AFM": UPDATE afm_users SET email='afm@tgd.com'
WHERE role_name LIKE 'RES%'
- Made
inactive some afm_dwgpub records. (3013398)
- Updated
dwgname and ehandle data for the Workflow Rule Diagrams
(3015143)
- Fixed
problem with running the RM_Asset_Qtext publishing rule in the sample
data causing error (3013438)
- Changed
bldg "DC" to "XC"
- Imported
data for XC bldg (data added to tables: fl, afm_dwgs, vert, serv, gros,
rm, em, eqstd, eq, fn, jk, su)
- Made
several changes to HQ sample data for use with the v16.3 exercises. (3014638 through 3014640, 3014642 through 3014647,
3014649, 3014650)
- Set
the following publishing rules to be active:
(3015162)
AbHltBl
AbLyrMisc
AbURLBl
- Added
and updated afm_wf_rules records for the AbSolutions* activities
- Added
and updated afm_wf_rule record for the AbCommonResources activity
- Added
new afm_wf_rules records for the Reservation activity
- Updated
some of the WFR rules for abMoveManagement*, Proj. Mgmt, Capital Budgeting,
and Workplace Portal
- Set
to NULL the Security Group value for ALL of the WFRs (remove SYSTEM MGR
from all rules)
- Process
Navigator Changes
- Added
records to the following tables for Reservations:
afm_processes
afm_roles
afm_roleprocs
afm_ptasks
- Added
"Update Reservations SQL Views" navigator task to System/ Schema/
Define to run: reservationSqlViews.abs
- For
AbSolutions, changed PNav task name for Furn. Plan (3013446)
- Change
subfolders on several solution template activities. (3015186)
- Added
PNav labels for (All Room) and (Composite) activities
(3013473)
- Changed
afm_ptasks Enter Faceplates task to use file xfp.avw instead of fp.avw (3014275)
- DWG
Editor Draw Telecom Grid command was removed from pnavs
(3013520)
- Updated
the help links in database (3013584)
- Added
to PNav
- Proj Mgmt/ Proj Mgmt / Request ---
under Add or Edit Programs: "Add or Edit Programs by Type" ---
ab-programs-edit-by-type.axvw. (3011669)
- Added
PNav entry for axvw to add/edit/delete Project Phases (projphase table).
(3012450)
- Added
two new views to PNav: (3011830)
- Compare
Project Costs to Budget Costs: ab-proj-projects-compare-to-budget.axvw
- Compare
Project Costs to Budget Costs by Year: ab-proj-projects-compare-to-budget-2d.axvw
- Changed
the file names for the following two PNav entries (3012046):
- AbCapitalBudgeting
/ Prioritize & Estimate (Optional) / Add or Edit Actions: ab-project-capbud-actions-edit.axvw
- AbCapitalBudgeting
/ Prioritize & Estimate (Optional) / Estimate Baseline Schedule and
Durations: ab-project-capbud-actions-est-base-sched-edit.axvw
- Added
afm_activity_params.avw to System/Schema/Control Navigator (3014372)
- Added
messages_trans.avw to System/Schema/Translate Navigator
- Set
Dashboard frame heights to zero. (3014565)
- Changed
ab-wf-rules-container.axvw to ab-wf-rules-by-activity.axvw for the record:
AbSystemAdministration > Workflow Process Manager > Workflow Diagrams
- Reassigned
the AbWorkplacePortal and AbWorkplaceReservations activities to the AbWorkplaceServices
domain.
- Made
the AbWorkplaceServices domain active=Yes.
- Deleted
the (now
empty) AbWorkplace Portal domain.
- In
the ARCHIBUS Domains table, changed Domains Large Icon to
be:
- AbAsset
fc_facil.gif
- AbRisk
ab-act-emergeprep.gif
- AbTelecom
ab-role-security.gif
- AbSMP
ab-act-smp.gif
- For
Processes, changed "Process or Role" and Titles for them from
“Facility Information Manager” to "Business Process Owner.”
- For
AbMoveManagement / Business Process Owner, changed Large Icon be “ab-role-fim.gif”.
- Added
record with link to setup-license-file.axvw (3014779)
- Added
to DNav: System / Schema / Control / Schema Preferences / Messages (messages.avw)
3015173
Version 16.1 Database Version 123
- Schema
Preferences
- The
Database Version schema preference (Afm_Scmprefs) was set to 123.
- Process
Navigator
- Schema
Changes:
- afm_ptasks.view_type_override
- Added. (3012446)
- afm_ptasks.security_group
- Updated Multi-Line Heading. (3009173)
- afm_ptasks.comments
- Updated string_format for to memo.
- afm_processes.summary
- Updated to reduce size from 512 to 320 to better facilitate localization. (3012372)
- Data
Changes:
- afm_products,
afm_activities, afm_processes, and afm_ptasks tables - Extensive additions
and updates of Process Navigator records.
- Domain
Navigator
- Schema
Changes:
- help_file
field in all domain navigator tables - Updated multi-line heading from
"Help File" to "Help Sub-Folder". Note: v16.1 does
not provide any functionality for this field.
(3013104)
- afm_modules
- Table title changed from "Modules" to "Domains"
- Data
Changes:
- afm_modules
- Display order changes; Title changes; assigned Activities changed. (3012121 + other changes)
- Drawing
Publishing
- Schema
Changes:
- afm_dwgpub.comments
- New field added.
- afm_dwg.pub_rule_type
- Added new enumeration value (Dynamic). (3012359)
- Data
Changes:
- Drawing
Publishing rules added. (3011950, 3011958)
- Dynamic
drawing publishing rules added.
- Added
task to Domain Navigator: System/Schema/Update/Convert GDI Patterns to
AutoCAD (3012496)
- Work
Flow Rules
- Data
changes:
- afm_wf_rules
- Rules updated to add dwg_name and ehandle values. (3012735)
- HQ
Sample Data
- Data
Changes:
- dp,
rmcat, rmtype, gpstd, hprorate, regn - Added sample AutoCad Hatch patterns
to existing records.
- VPA
restriction for Role "Z-VPA-TBL" -- Uupdated to change "optionX"
fields to "vpa_optionX" in the restriction sql.
(3008506)
Version 15.1 Database Version 122
- Database
Version Number updated to 122
- Schema
Changes
- Sybase
database rebuilt as UTF8 (3012170)
- afm_layr.title_%
- changed size from 40 to 64 to accommodate translations
- afm_users.clr_scheme
enumerations list - added: ;SLATE-LARGE;Slate - Large Font (3012286,
3012289)
- mo.mo_type
- changed default from NULL to 'Employee'
(3011776)
- activity_log.date_planned_for
- changed default from NULL to CURRENT
(3011789)
- work_pkgs.doc
- added this document field (3011779)
- System
Data Changes
- afm_users.clr_scheme
- set to SLATE for those that did not have values
- afm_scmpref.preferences
- added fields from the questions table to the list of translatable fields
- Process
Navigator
- afm_products.help_link
- replaced @dbExtension with @helpExtension (3012001,
3011941)
- afm_ptasks:
- Added
web view for Add and Enter Business Units in Move Mgmt (3011596)
- Added
Primary Trades web view in Bldg Ops and Move Mgmt. (3011584)
- Updated
Solution Template tasks to correct search paths (3012236)
- Renamed
"Product" to "Domain" in System/ Schema /Navigate
Activities tasks (3012125)
- Work
Flow Rules
- afm_wf_rules
- add two workflow rules that implement batch report generation (3011813)
- afm_wf_rules
- rules updated (3012082)
- HQ
Sample Data
- added
users to afm_users for load testing
- changed
hpattern from old format to new format for tables: ls, dp, rmstd, rmtype
(3012310, 3012331)
Version 15.1 Database Version 121
- Schema
Preferences
- The
Database Version schema preference (Afm_Scmprefs) was set to 121.
- Added
date_lang_en field to afm_scmpref for tracking canonic changes
- ARCHIBUS
Navigator Changes
- The
Document Management, Questionnaires, and Workflow Rules activities added
to the System module.
- In
System module, renamed Step Up and Connectivity activity to Connectivity.
Removed Step Up task category and its tasks from the activity.
- "Update
to V15 Status Codes" task added to the System/Schema/Define task
category.
- "Tables
licensed by Activity" and "Licensed Tables and Their Activities"
tasks added to the System/ Schema/ Navigate Activities task category.
- Process
Navigator Changes
- The
Move Management, Capital Budgeting, and Project Management activities
added. The System Administration/Workflow Process Manager activity added.
- Products
changed to Domains.
- Workplace
Services product removed and its activities reorganized into new domains,
such as the Building Operations activity moved to the Operations domain.
- Asset/Asset
Control activity added. Telecom Asset Control process changed to Equipment
Asset Control.
- The
Emergency Preparedness activity added to Space domain.
- Fields
- Projects,
Move Orders, Vendors, Activity Logs tables: Several new fields
were added to these tables.
For a complete list, load the ARCHIBUS Fields table and
set a restriction for: "Comments" "LIKE" "%Trin%".
All fields added or changed for version 15.1 have "Trinidad"
is in the Comments field.
- For the amount_tot_invoice field in the
Invoices table, change ARCHIBUS Type to None from Calculated for both the
HQ and Schema databases (Sybase only). Also, the following new fields
were added to the Invoices (invoice) table.
Field |
invoice.project_id |
invoice.work_pkg_id |
invoice.vn_id |
invoice.qty_accepted |
invoice.qty_invoiced |
invoice.qty_invoiced |
- The following new fields were added to the
Communications Log (ls_comm) table.
Field |
ls_comm.recorded_by |
ls_comm.parent_key |
ls_comm.summary |
ls_comm.project_id |
ls_comm.comm_type |
ls_comm.doc |
ls_comm.priority |
- The
following new fields were added to the Budgets table.
-
|
Field
|
|
budget.site_id
|
|
budget.program_type
|
|
budget.year_start
|
|
budget.year_end
|
- These new fields were added to various tables.
Field |
afm_dwgs.dwg_file |
afm_scmpref.date_lang_en |
Afm_flds.validated_data |
Afm_flds.attributes |
ls.doc |
activity_log.doc |
invoice.doc |
activitytype.instructions |
activitytype.description |
activitytype.autogen_wr |
activitytype.standard_cost |
activitytype.prob_type |
zone.layer_name |
trial_project.project_id |
invoice_payment.amount_expense |
afm_ptasks.iframe_width |
afm_ptasks.iframe_height |
- The following fields had their ARCHIBUS Type
changed from Graphic to Document:
Field |
activity_log.doc_file1 activity_log.doc_file2 activity_log.doc_file3
|
ls.image_doc1
ls.image_doc2
ls.image_doc3 |
ls_comm.image_doc1 |
op.image_doc1
op.image_doc2 |
- afm_users.locale
enumeration list changed to include "no_NO;Norwegian".
- afm_flds.enum_list
and afm_flds_lang.enum_list_xx size changed from 600 to 750.
- project.project_type
changed from enum to validate on projecttype table.
- Set
the bl, fl, rm, dv, and dp fields of rm_trial table to not validate.
- activity_log
table: approved_by, assessed_by, completed_by, created_by, verified_by
size is expanded to match the em table.
- Added
a Comments field to the following tables: afm_activities, afm_activity_cats,
afm_actprods, afm_acts, afm_cats, afm_class, afm_hotlist. afm_mods. afm_processes,
afm_products. afm_psubtasks. afm_ptasks, afm_subtasks, afm_tasks
- afm_flds.afm_type
has new values in enum list: "Document" and "Doc.Stg"
- Table
Changes
- These
tables were added:
-
|
Title
|
Name
|
Use
|
|
Documents
|
afm_docs
|
List of all documents in the document management system.
|
|
Documents Versions
|
afm_docvers
|
Versions of documents.
|
|
Archived Documents Versions
|
afm_docversarch
|
Archives of documents.
|
|
Questions
|
questions
|
List of questions for each questionnaire.
|
|
Questionnaires
|
questionnnaires
|
List of all questionnaires in the system.
|
|
Activity Sub-Types
|
activity_subtype
|
Contains standard action descriptions to refine the Activity Types
table.
|
|
Workflow Controller Log
|
afm_wf_log
|
Used for workflow rules.
|
|
Workflow Rules
|
afm_wf_rules
|
Used for workflow rules
|
|
ARCHIBUS Calendar Dates
|
afm_cal_dates
|
Used for calendar reporting by ARCHIBUS Web Central View Analysis.
|
|
ARCHIBUS Activity Tables
|
afm_act_tbls
|
Used for importing actions from other applications.
|
|
Document Templates
|
doc_templates
|
Holds templates that can be used with ARCHIBUS Web Central and doc management
system.
|
|
Project Types
|
projecttype
|
Capital Budgeting/Project Mgmnt activities
|
|
Project Phases
|
projphase
|
Capital Budgeting/Project Mgmnt activities
|
|
Activity Item Transactions
|
activity_log_trans
|
Capital Budgeting/Project Mgmnt activities
|
|
Status Log
|
status_log
|
Capital Budgeting/Project Mgmnt activities
|
|
Project Team
|
proj_team
|
Capital Budgeting/Project Mgmnt activities
|
|
Scenarios
|
scenario
|
Capital Budgeting/Project Mgmnt activities
|
|
Project Scenarios
|
projscns
|
Capital Budgeting/Project Mgmnt activities
|
|
Funding Sources
|
funding
|
Capital Budgeting/Project Mgmnt activities
|
|
Funding Allocations
|
projfunds
|
Capital Budgeting/Project Mgmnt activities
|
|
Program Budget Items
|
prog_budget_items
|
Capital Budgeting/Project Mgmnt activities
|
|
Program Types
|
programtype
|
Capital Budgeting/Project Mgmnt activities
|
|
Programs
|
program
|
Capital Budgeting/Project Mgmnt activities
|
|
Status Log
|
status_log
|
Capital Budgeting/Project Mgmnt activities
|
|
Communications Log Log
|
ls_comm_log
|
Capital Budgeting/Project Mgmnt activities
|
|
Communication Subscriptions
|
commsubs
|
Capital Budgeting/Project Mgmnt activities
|
|
Communication Types
|
commtype
|
Capital Budgeting/Project Mgmnt activities
|
|
Work Packages
|
work_pkgs
|
Capital Budgeting/Project Mgmnt activities
|
|
Work Package Bids and Contracts
|
work_pkg_bids
|
Capital Budgeting/Project Mgmnt activities
|
- C-LEVEL
(dashboard user) added to ARCHIBUS Roles table."Smith" added to
Users table and assigned to this role. Process-to-user assignments for
Smith.
- In
Employees table, added SMITH@tgd.com to the record for SMITH, SALLY so
the dashboard user is someone with an ARCHIBUS identity. Also, added em photo
for Smith. So that items appear on dashboard, assigned activity log items,
projects, hotlist items. Added
projects
assigned to "smith, sall"y as project manager.(must be assigned
to em).
- For
User SYSTEM, added afm_userpocs records to match user AFM.
- afm_wf_rule,
afm_wf_activity, afm_wf_activitydef,
afm_wf_incoming_messages
tables used by previous workflow component were removed.
- ARCHIBUS
Layers table now has records for RM-TRIAL1-MO, RM-TRIAL2-MO and RM-TRIAL3-MO.
- TDB
record added to Contacts table.
- Set
defaults for baseline and design dates and durations in activity_log in
both HQ and Schema databases.(Sybase only).
- The
following records were added to the activity_type table (Schema database
only; Sybase only):PROJECT - CHANGE ORDER, PROJECT - MILESTONE, PROJECT
- DOCUMENT, PROJECT - TASK
Version 14.3 Database Version 120
- Preferences.
The database version schema preference (afm_scmprefs) was set to 120.
- Navigator
Changes. The Navigator items under System/Security were updated.
- Database
Format. Sybase and Oracle databases ship with UTF-8 (Unicode Transformation
Format-8) encoding.
- Field
Changes
- The afm_users.user_pwd field has been increased
from 10 to 64.
- The afm_users.locale field was made an enumerated
field with the following values:
- Default
- ar_SA;Arabic
- zh_CN;Chinese (Simplified)
- zh_TW;Chinese (Traditional)
- nl_NL;Dutch
- en_AU;English (Australia)
- en_CA;English (Canada)
- en_GB;English (United
Kingdom)
- en_US;English (United
States)
- fr_CA;French (Canada)
- fr_FR;French (France)
- de_DE;German
- iw_IL;Hebrew
- it_IT;Italian
- ja_JP;Japanese
- ko_KR;Korean
- pt_BR;Portuguese
- es_ES;Spanish
- The data types of the
following fields changed from CHAR to VARCHAR
|
Table
|
Field
|
|
Afm_activities
|
Summary
|
|
Afm_activities
|
Summary_de
|
|
Afm_activities
|
Summary_es
|
|
Afm_activities
|
Summary_fr
|
|
Afm_activities
|
Summary_nl
|
|
Afm_activities
|
Summary_no
|
|
Afm_processes
|
Summary
|
|
Afm_processes
|
Summary_de
|
|
Afm_processes
|
Summary_es
|
|
Afm_processes
|
Summary_fr
|
|
Afm_processes
|
Summary_nl
|
|
Afm_processes
|
Summary_no
|
|
Afm_wf_rules
|
Event_filter
|
|
Afm_wf_rules
|
Msg_action
|
|
Afm_wf_rules
|
Recipient_list
|
|
Afm_wf_rules
|
Sql_action
|
- Table
Changes. The following table changes were made:
- Added XML Schema Preferences
data for translatable fields to the preferences field in the afm_scmpref
table.
- To record the date
that translated strings were last updated date_lang_** fields were added
to the afm_scmpref table for each language field.
- title_* fields added
to the afm_layr table.
- To provide for additional
language translations each of the following table and field combinations
added _01, _02, and _03 fields:
|
Table
|
Field
|
|
Afm_activities
|
Summary_01
|
|
Afm_activities
|
Title_01
|
|
Afm_activity_cats
|
Summary_01
|
|
Afm_activity_cats
|
Title_01
|
|
Afm_flds_lang
|
Enum_list_01
|
|
Afm_flds_lang
|
Ml_heading_01
|
|
Afm_layr
|
Title_01
|
|
Afm_processes
|
Summary_01
|
|
Afm_processes
|
Title_01
|
|
Afm_products
|
Summary_01
|
|
Afm_products
|
Title_01
|
|
Afm_psubtasks
|
Task_01
|
|
Afm_ptasks
|
Task_01
|
|
Afm_tbls
|
Title_01
|
- To provided for translation, each of the following
tables and fields added fields with the internationalization extensions:
(_01, _02, _03, _ch, _de, _es, _fr, _it, _jp, _ko, _nl, _no, _zh):
|
Table
|
Field
|
|
Afm_mods
|
Afm_module
|
|
Afm_class
|
Act_class
|
|
Afm_acts
|
Act
|
|
Afm_cats
|
Task_cat
|
|
Afm_tasks
|
Task
|
|
Afm_subtasks
|
Subtask
|
|
Afm_hotlist
|
Super_cat
|
|
Afm_hotlist
|
Category
|
|
Afm_hotlist
|
View_title
|
Version 14.3 Database Version 119
- Preferences.
The database
version schema preference (afm_scmprefs) was set to 119.
- Navigator
Changes. A
Process Navigator for ARCHIBUS Web Central was added.
- Drawing
Publishing Rules (afm_dwgpub). rule_type
enumerated field values were extended to include QUERY TABLE;Query Table;.
- New
Tables. These tables were added:
|
Title
|
Name
|
Use
|
|
Products
|
afm_products
|
Process Navigator
|
|
Activity Categories
|
afm_activity_cats
|
Process Navigator
|
|
Product Activities
|
afm_actprods
|
Process Navigator
|
|
Activities
|
afm_activities
|
Process Navigator
|
|
Processes and Roles
|
afm_processes
|
Process Navigator
|
|
Process Tasks
|
afm_ptasks
|
Process Navigator
|
|
Process Subtasks
|
afm_psubtasks
|
Not used by v14.3
|
|
User Process Assignments
|
afm_userprocs
|
Process Navigator
|
|
ARCHIBUS Roles
|
afm_roles
|
Security Roles
|
|
ARCHIBUS Groups for Roles
|
afm_groupsforroles
|
Security
Roles
|
|
Workflow Process
|
afm_wf_process
|
Workflow
|
|
Workflow Rules
|
afm_wf_rules
|
Workflow
|
|
Visitors
|
visitors
|
Workplace Portal Activity
|
- New
Fields. These
new fields were added.
|
Field
|
|
afm_tbls.title_ch, de, es, fr, etc.
|
|
afm_users.bl_id_list
|
|
afm_users.site_id_list
|
|
afm_users.email
|
|
afm_users.home_page
|
|
afm_users.locale
|
|
afm_users.preferences
|
|
afm_users.role_name
|
|
afm_users.vpa_option1,2,3, and 4
|
|
afm_dwgpub.layer_background
|
- Field
Size Changes. These
fields were enlarged.
|
Field
|
New Size
|
Old Size
|
|
afm_acts.security_group
|
64
|
10
|
|
afm_cats.security_group
|
64
|
10
|
|
afm_class.security_group
|
64
|
10
|
|
afm_flds.edit_group
|
64
|
10
|
|
afm_flds.review_group
|
64
|
10
|
|
afm_group.group_name
|
64
|
10
|
|
afm_hotlist.security_group
|
64
|
10
|
|
afm_mods.security_group
|
64
|
10
|
|
afm_tasks.security_group
|
64
|
10
|
|
afm_subtasks.security_group
|
64
|
10
|
|
afm_atyp.dflt_symbol
|
64
|
8
|
|
it.performed_by
|
32
|
16
|
|
rmcat.description
|
96
|
25
|
|
rmtype.description
|
96
|
26
|
- Field
Default Value Changes. These
fields had default value changes.
|
Field
|
Old Value
|
New Value
|
|
afm_scmpref. afm_db_version_num
|
101
|
1.01
|
|
afm_scmpref. afm_exe_release_num
|
107 (default)
|
1.07
|
|
.cf.issue_work_in_format
|
<blank>
|
None
|
|
tr.issue_work_in_format
|
<blank>
|
None
|
Version 14.2 Database Version 118
- Preferences.
The database
version schema preference (afm_scmprefs) was set to 118.
- Navigator
Changes. The
following changes / additions were made to the Domain Navigator:
- A new
Additional Activities module was added.
- A Condition
Assessment activity was added under the new Additional Activities module.
- A Environmental
Sustainability activity was added under the new Additional Activities
module.
- General
Table and Field Changes. The
following table and field changes were made:
- A Classifications
table and fields were added to support the new Condition Assessment activity.
- An
Organizations table was added. This table is a standard (non-concatenated)
Hierarchical table and provides a template for those users who wish to
track their organization assignments using an unlimited hierarchy rather
than the standard 3-tier hierarchy of Business Units, Divisions, and Departments.
- In
the Accounts table (ac) a hierarchy_id field was added and the ac_id field
was changed to ARCHIBUS_type Hierarchical-Concat.
- The
schem_prefs table now includes a hierarchy_delim field.
- The
equipment table (eq) now includes a csi_id field.
- The
historical work orders (hwr) table now includes an activity_log_id field.
- The
project tables project_type field now includes an assessment value in
the enumeration list.
- The
work request (wr) and historical work requests (hwr) tables now include
the activity_log_id field.
- The
Work Requests (wrview) and the All Work Requests (wrhwr) now include the
activity_log_id field.
- The
Work Requests (wrview) SQL view and the All Work Requests (wrhwr) SQL
view now include the activity_log_id field.
- The
communications log (ls_comm) table has been changed as follows:
- The
hierarchy_ids field was added.
- The
auto_number afm_type was changed to hierarchical.
- Changes
to Activity Logs table
These fields were added to the Activity Logs
table (activity_log):
|
New
Fields in Activity Logs table
|
|
assessed_by
|
|
capital_program
|
|
completed_by
|
|
cond_priority
|
|
cond_value
|
|
cost_act_cap, cost_est_cap
|
|
cost_to_replace
|
|
csi_id
|
|
date_assessed, date_verified
|
|
doc_file1,doc_file2, doc_file3
|
|
eq_id
|
|
fl_id, location
|
|
rec_action
|
|
rm_id
|
|
site_id
|
|
sust_priority
|
|
verified_by
|
The following fields were changed in the Activity
Log table (activity_log):
- The
cost_actual field multi-line header (ml_heading) was changed to Cost Actual
(Expense).
- The
cost_estimated field multi-line header was changed to Cost-Estimated (Expense).
- The
status fields enumeration list now contains the following values:
" N/A
" Trial
" Budgeted
" Planned
" Scheduled
" In Progress
" Completed
" Completed and Verified
- Changes
to the afm_Flds table
- The afm_type fields now
has the following new values:
- The
enum_list field has been increased to 600 to accommodate additional enumeration
values.
Version 14.1 Database Version 117
- Schema
Preferences. The
Database Version schema preference (Afm_Scmprefs) was set to 117.
- Schema
Table Title Changes. Several
table titles have been changed as follows in order to resolve a Data Transfer
to Excel issue. Excel
has a 31-character limit for sheet titles and several ARCHIBUS table
titles previously exceeded this limit.
Table | Old Title | New Title |
blbu | Bldg. Ops. Budgets for Buildings | Bldg.
Ops. Building |
hwrtr | Historical WR Trade Requirements | Historical WR |
mo_eq | Move Order Equipment Assignments | Move Order Equip. Assignments |
mo_ta | Move Order Tagged Furn. Assignments | Process
Navigator |
pmpsum | PM Procedure Forecast Summaries | Move Order Tagged Furn. Assig. |
ta_compinvsur | Tagged Furn. Inventory vs. Audit | Tagged Furn. Inv. vs. Audit |
ta_compinvtrial | Tagged
Furn. Inventory vs. Trial | Tagged Furn. Inventory vs. Trial (extra spaces removed) |
wrtr | Work Requests Trade Requirements | Work Request Trade Requirement |
- Drawing
Publishing. The Afm_Dwgpub table and fields for the Drawing Publishing
feature were added. Additionally
the Drawings Task Category (DrawingPublishing) and tasks were added as
follows:
- Drawing
Publishing Rules (afm_dwgpub.avw)
- Drawing
Publishing Rules Summary (afm_dwgpub_tbl.avw)
- Asset
Types and Publishing Rules (atypes.avw)
- Publish
Drawings (afm_dwgpub.abs)
- Schema.
Added Type.Afm_Flds. An
"Hpattern Acad Ext" (Extended) type added to the Afm_Atype table.
- Schema.
Field Change. The
Hpattern_Acad Field has been changed in 14 tables as follows:
o Type set to Hpattern Acad Ext
o Field width increased to 64 characters
- Schema.
Afm_Atyp Table. A
rule_id field has been added to the Afm_Atyp table.
- Schema.
New Tables. The following tables were removed:
- 'afm_activities'
- 'afm_activity_cats'
- 'afm_groupsforroles'
- 'afm_processes'
- 'afm_prodmeths'
- 'afm_products'
- 'afm_psubtasks'
- 'afm_ptasks'
- 'afm_roles'
- 'afm_userprocs'
- Schema.
Navigation
Changes. Database
Version 117 contains the following Navigation changes.
- afm_hotlist.
A new record
was added to load the HTML form example under: Space/C: Operations Management/1.
Rooms/Reassign Rooms and Employees.
Version 12.2 Database Version 116
- Schema
Preferences. The
Database Version schema preference was set to 116.
- Emergency
Preparation activity. The
tables and fields for the Space/Emergency Preparedness activity were added
to the ARCHIBUS Tables and ARCHIBUS fields tables. They are marked with "Emergency
Preparedness" in the Comments field. Similarly,
the activities and tasks for the Space/Emergency Preparedness activity
were added to the Domain Navigator tables.
- Add
Field task. There
is a new Navigator task, System/ Schema/ Define/Add Field. It is located
beneath the "Copy Field(s)" task.
- Context-Sensitive
Help from Navigator. For
all Help Topic fields in the Domain Navigator tables that use keywords,
the dbupHelpLinks.abs routine updates the Help Topic fields to now use
the topics' context strings. Also, in the ARCHIBUS Tasks table, the Help File
fields for System/Schema/Update/ Audit Logs and System/Schema/Update/Currency
and Conversion were updated to link to afm_sysman.hlp, rather than afm.hlp.
- ARCHIBUS
Hotlist table. Changed
afm_hotlist.view_title from 64 to 96 characters so that long localized
strings can fit.
- ARCHIBUS
Conversions table. afm_conversions
table definition and physical table updated.
- ARCHIBUS
Workflow Activity Instances table. There
is a new field in the afm_wf_activity_def table: "is_retired".
- Properties
table. property.detail_dwg
was updated to be 64 characters wide from 8 characters.
- Size
of Auto-Incremented Integers. Standardized
the auto-incremented integers sizes in afm_flds. All were changed to 10.
This is purely cosmetic, as all integers field sizes are defined by the
database engine.
- ARCHIBUS
Asset Types table. Removed pop_loc from the Fields to Validate
in afm_atyp, as it has no effect.
- Groups
table. gp.function
changed to gp.gp_function for Microsoft SQL Server 2000 compatibility.
Version 12.1 Database Version 115
- Schema
Preferences. The
Database
Version schema preference was set to 115.
- Work
Flow Controller. The
afm_wf% tables were added. Also, fields for the Work Flow Controller were
Added to the wr, hwr, wrcf, hwrcf, tr, and cf tables.
- Work
Wizard. Required
database changes for the Work Wizard included the following:
- Added
fields to wr and hwr , including wr.satisfaction and wr.satisfaction_notes.
- Removed
WOAUTONUMBER and WRAUTONUMBER triggers, as the triggers are not supported
by the Runtime Sybase engine. Authoring and Multi-user users can run the
Navigator action to re-create these triggers.
- In
the ARCHIBUS Groups table, the afm_groups.ww_preferences fields was added.
- The
following SQL views were added: wohwo, wrhwr, wrcfhwrcf, and wrpthwrpt.
- wr.time_requested
now has a default of CURRENT.
- System/Schema/Define/Add
Work Wizard SQL Views added to Navigator.
- SQL
view wrview updated so that now both wr and hwr records can be viewed
in the tree control.
- System/Schema
activity reorganized. On
the Domain Navigator, the System/Schema activity was reorganized. The
Connect tasks were removed from System/Schema and System/Security. Also,
the tasks in System/Schema/Control were re-organized. Help Topic fields
for these items updated to match changes.
- ARCHIBUS
Hotlist table. To
implement multi-language ARCHIBUS Web Central, changes for multi-language support
were made to the ARCHIBUS Hotlist table.
- The
afm_hotlist.inet_file values were set to lower case.
- Updated
.cfm Hotlist capitalization.
- VoloView
and Toolbar views added to hotlist via HotLsChg.abs.
- "VPID"
set to uppercase for Help links.
- Dwg
Filename fields. All detail_dwg, symbol, title_block, and "dwgnames"
fields changed from 8 to 64 characters to support long filenames. Previously,
other filename fields (including "dwgname") had been changed
to 64, but these had been missed.
- Drawing
Assets. Centered
Boundary Asset Text Generation style added. Also, most pline asset types
changed to Centered Boundary.
- Real
Property & Lease Management module. Extra title white space
in the Real Property & Lease Management module was removed from the
Navigator.
- Telecom.
Indexes were re-created.
- Online
Help. For
System module Navigator entries, the Help File field was changed from
afm11_sysman.hlp to afm_sysman.hlp.
- F&E
Audit vs. Inventory tables. Removed
validation from the ta_compinvsur and eq_compinvsur tables.
- Employee
Standards table. emstd.em_std set to UPPER.
- Triggers
and SQL views. System/Schema/Define
Indexes, triggers, and SQL
views were re-created.
Version 11.3 Database Version 114
- Fields changed from 32 to
64 characters. For
localization purposes, all act_class and act fields
were changed from 32 characters to 64. Changed afm_tbls.title
from 32 char to 64. Update Schema, Alter table. Updated appropriate foreign
keys.
- Navigator titles and multi-line
headings. Some Navigator titles and multi-line field headings cleaned
up based on localization feedback.
Version 11.2 Database Version 113
- BOMA
96. The space calculations offer a BOMA 96 option in addition to
the BOMA 90 and Enhanced BOMA calculations.
- afm_scmpref.space_area_type ("Space Area
Method") changed:
From:
ar;All Room;arp;All Room Percentage;ci;Composite;cib;Composite - BOMA;cie;Composite
- EBOMA
To:
ar;All Room;arp;All Room Percentage;ci;Composite;cib;Composite - BOMA;cie;Composite
- EBOMA;ci9;Composite - BOMA 96
This field is used by the SMP module's Allocation
view action for determining the calculation to use when recalculating
floors usable area (spalloc.abs).
- afm_scmpref.lease_proration_method
("Group Area Prorate Method") changed:
From:
B;BOMA;E;Enhanced BOMA;G;Group
To:
B;BOMA;E;Enhanced BOMA;9;BOMA 96;G;Group
This field is used by the Lease module for
determining the calculations to use when charging back common areas to
lease areas. (lsarea.abs).
- Microsoft
SQL Server Reserved Words. The
"use" and "image" fields were renamed to avoid conflicts
with reserved words
in MS SQL Server. These
are now named "use1" and "image_file".
- Use
ARCHIBUS Function for Cascade. A
new schema preference field, afm_scmpref.afm_cascades_changes, has been
added to support the application level cascading updates and deletes for
Microsoft SQL Server and Oracle.
- Real
Fields Changed to Numeric. All
fields that were type "Real" in the standard schema have been
changed to "Numeric" in order to avoid slight rounding differences
between the values displayed on the screen and the values stored in the
database. If
you use the Update Project Wizard to apply these changes to your current
database, your stored values will be rounded to the number of decimal
places specified for each field in the afm_flds table.
Version 11.1 Database Version 112
- First
V11 Schema. Database
version 112 is the benchmark schema from which all other V11 changes are
noted. If
you have a previous version of the schema, please review the AddToV10.abs
file for a list of the changes made to Version 10 schema.