Parsing Policy Instruments (baseline set)

I decided to take another shot a writing a parser in Sparx EA that could covert the XML version of the TBS policy instruments in to Archimate elements for traceability within Sparx EA.

After many days of effort spread out many, many weeks, I managed to get something that I think will be useful to others.   The parsing of the XML only took about an hour, what took much longer is writing the logic to interpret the contents of the XML in a way to ensure that the resulting elements each received a unique traceability ID, and fixing issues within the XML.

Currently only the English versions of the instruments have been parsed, I hope to release the french versions in the next few weeks, and if I can have the two versions cross linked.

Some of the nodes in the XML had assigned IDs that were unique, but many more had “inferred” IDs based on their location in the XML hierarchy.   There was also the issue of heading tags e.g. <title>…</title> in some XML files instead of parent child nodes to indicate hierarchy requiring that I track heading numbering to determine hierarchy.   Luckily these difficulties seem to be legacy issues, the new releases have more easily parsed XML and seem to assign IDs to all nodes.

The majority of the statements in the instruments have been captured as Archimate Requirements elements, with the exception of terms/definitions which I captured as Archimate Meaning Elements.

I will be working on “modelling” instruments as I use them for a project I’m working on.   My focus will be security, IM, and IT related instruments.   I will be creating the business object, business role, business actor, and business process elements that realize the requirements in each directive.

I also plan to make my parsing script available to other Sparx EA users as part of my release of my EARecordset library (which the parsing script uses).   For now the parsed policy instruments can be found on my download page as Sparx EA XMI files, CSV files and Archimate Exchange Files.

The files contain the following 262 policy instruments:

  1. Accessibility Standard for Real Property
  2. Acquisition Cards Program – Transfer of operational responsibility for the Government of Canada
  3. Appraisals and Estimates Standard for Real Property
  4. Carry-Forward of Capital Funds – TB Circular 1987-53
  5. Co-development Guidelines
  6. Common Services Policy
  7. Contracting Policy
  8. Controlled Goods Directive
  9. Data Standard on Classification of Procurement Items
  10. Defence Scientific Service Group – Pay Plan
  11. Directive on Accounting Standards GC 1010 Financial Statement Concepts (Materiality)
  12. Directive on Accounting Standards GC 1100 Financial Statement Objectives
  13. Directive on Accounting Standards GC 1150 Generally Accepted Accounting Principles
  14. Directive on Accounting Standards GC 1200 Financial Statement Presentation
  15. Directive on Accounting Standards GC 1300 Government Reporting Entity
  16. Directive on Accounting Standards GC 2400 Subsequent Events
  17. Directive on Accounting Standards GC 2700 Segment Disclosures
  18. Directive on Accounting Standards GC 3050 Loans Receivable
  19. Directive on Accounting Standards GC 3150 Tangible Capital Assets
  20. Directive on Accounting Standards GC 3250-3255 Retirement and Post-Employment Benefits
  21. Directive on Accounting Standards GC 3300-3310 Contingent Liabilities and Loan Guarantees
  22. Directive on Accounting Standards GC 3320 Contingent Assets
  23. Directive on Accounting Standards GC 3390 Contractual Obligations
  24. Directive on Accounting Standards GC 3410 Government Transfers
  25. Directive on Accounting Standards GC 4100 Specified Purpose Accounts
  26. Directive on Accounting Standards GC 4200 Inventories
  27. Directive on Accounting Standards GC 4300 Non-Monetary Transactions
  28. Directive on Accounting Standards GC 4400 Departmental Quarterly Financial Report
  29. Directive on Accounting Standards GC 4500 Departmental Financial Statements
  30. Directive on Accounting Standards GC 5000 Recording Financial Transactions in the Accounts of Canada
  31. Directive on Accounting Standards GC 5100 Payables at Year-End
  32. Directive on Accounting Standards Introduction – Government of Canada Accounting Handbook
  33. Directive on Accounting Standards
  34. Directive on Automated Decision-Making
  35. Directive on Career Transition for Executives
  36. Directive on Charging and Special Financial Authorities
  37. Directive on Classification Grievances
  38. Directive on Classification Oversight
  39. Directive on Classification
  40. Directive on Delegation of Spending and Financial Authorities
  41. Directive on Departmental Security Management
  42. Directive on Disposal of Surplus Materiel
  43. Directive on Executive (EX) Group Organization and Classification
  44. Directive on Executive Compensation
  45. Directive on Fleet Management Executive Vehicles
  46. Directive on Fleet Management Light Duty Vehicles
  47. Directive on Government Contracts, Including Real Property Leases, in the Nunavut Settlement Area
  48. Directive on Identity Management
  49. Directive on Information Management Roles and Responsibilities
  50. Directive on Interchange Canada
  51. Directive on Internal Audit
  52. Directive on Leave and Special Working Arrangements
  53. Directive on Management of Information Technology
  54. Directive on Official Languages for Communications and Services
  55. Directive on Official Languages for People Management
  56. Directive on Open Government
  57. Directive on Payments
  58. Directive on Performance Management
  59. Directive on Personal Information Requests and Correction of Personal Information
  60. Directive on Privacy Impact Assessment
  61. Directive on Privacy Practices
  62. Directive on Public Money and Receivables
  63. Directive on Recordkeeping
  64. Directive on Results
  65. Directive on Security Management
  66. Directive on Service and Digital Appendix A Mandatory Procedures for Enterprise
  67. Architecture Assessment
  68. Directive on Service and Digital Appendix B Mandatory Procedures on Application Programming Interfaces
  69. Directive on Service and Digital Appendix C Examples of Acceptable Network and Device Use (non-exhaustive list)
  70. Directive on Service and Digital Appendix D Examples of Unacceptable Network and Device Use (non-exhaustive list of examples)
  71. Directive on Service and Digital Appendix E Mandatory Procedures for Privacy and Monitoring of Network and Device Use Information Notices
  72. Directive on Service and Digital
  73. Directive on Social Insurance Number
  74. Directive on Terms and Conditions of Employment for Certain ExcludedUnrepresented Employees
  75. Directive on Terms and Conditions of Employment
  76. Directive on the Administration of Required Training
  77. Directive on the Business Number
  78. Directive on the Harassment Complaint Process
  79. Directive on the Implementation of the Official Languages (Communications with and Services to the Public) Regulations
  80. Directive on the Management of Communications
  81. Directive on the Management of Projects and Programmes
  82. Directive on the Performance Management Program (PMP) for Executives
  83. Directive on the Sale or Transfer of Surplus Real Property
  84. Directive on Transfer Payments
  85. Directive on Travel, Hospitality, Conference and Event Expenditures
  86. Directive on Union Dues
  87. Directives and Standards – General – Occupational Health and Safety
  88. Employment Equity Policy
  89. Financial Information Strategy Accounting Manual
  90. Fire Protection Standard
  91. Flying Accidents Compensation
  92. Foundation Framework for Treasury Board Policies
  93. Framework for the Management of Compliance
  94. Framework for the Management of Risk
  95. Future Asset Restoration Liability A Supplement to the Financial Information Strategy (FIS) Manual
  96. Governance and Expenditure Management Policy Area
  97. Guide to a Project Brief
  98. Guide to Administering Low-Value Amounts
  99. Guide to Claims
  100. Guide to Cost Estimating
  101. Guide to Delegating and Applying Spending and Financial Authorities
  102. Guide to Fleet Management, Chapter 2 Executive Vehicles
  103. Guide to Interest and Administrative Charges
  104. Guide to Investment Planning – Assets and Acquired Services
  105. Guide to Management of Materiel
  106. Guide to Requesting Capacity-Based Real Property Transaction Approval Limits
  107. Guide to the Management of Movable Heritage Assets
  108. Guide to the Review of Management of Government Information Holdings
  109. Guideline for Employees of the Government of Canada Information Management (IM) Basics
  110. Guideline for the Policy on Internal Control
  111. Guideline on Accountable Advances
  112. Guideline on Chief Financial Officer Attestation for Cabinet Submissions
  113. Guideline on Collection of Receivables
  114. Guideline on Common Financial Management Business Process 11 – Manage Planning And Budgeting
  115. Guideline on Common Financial Management Business Process 31 – Manage Procure to Payment
  116. Guideline on Common Financial Management Business Process 32 – Manage Travel
  117. Guideline on Common Financial Management Business Process 33 – Manage Other Payments
  118. Guideline on Common Financial Management Business Process 41 – Manage Other Capital Assets
  119. Guideline on Cost Estimation for Capital Asset Acquisitions
  120. Guideline on Defining Authentication Requirements
  121. Guideline on Departmental Chart of Accounts Line Object Codes
  122. Guideline on Developing a Departmental Security Plan
  123. Guideline on Financial Management of Pay Administration
  124. Guideline on Identity Assurance
  125. Guideline on Performance Measurement Strategy under the Policy on Transfer Payments
  126. Guideline on Recipient Audits Under the Policy on Transfer Payments and the Directive on Transfer Payments
  127. Guideline on Security for Debts
  128. Guideline on Self-Insurance
  129. Guideline on Service Agreements An Overview
  130. Guideline on Service Agreements Essential Elements
  131. Guideline on Service Management
  132. Guideline on Service Standards
  133. Guideline on the Application of Goods and Services TaxHarmonized Sales Tax
  134. Guideline on the Attribution of Internal Services
  135. Guideline on the Management of Public Key Infrastructure in the Government of Canada
  136. Guideline on the Payment, Recording and Rebate of the Quebec Sales Tax
  137. Guideline to Implementing Budget 2011 Direction on Public-Private Partnerships
  138. Guidelines for Discipline
  139. Guidelines for Essential Services Designations
  140. Guidelines for Labour-Management Consultation Committees
  141. Guidelines for Privacy Breaches
  142. Guidelines for the Processing of Garnishments
  143. Guidelines for Two-Tier Bargaining
  144. Guidelines for Use of Employer Facilities
  145. Guidelines on Contractual Arrangements
  146. Guidelines on Costing
  147. Guidelines on Fleet Management, Chapter 1 Light-Duty Vehicles
  148. Guidelines on Managerial or Confidential Exclusions
  149. Guidelines on Streamlining – Statutory Reports to Parliament
  150. Guidelines on the Proactive Disclosure of Contracts
  151. Guidelines on the Reporting of Grants and Contributions Awards
  152. Information Management – Guidelines
  153. Injury-on-Duty Leave
  154. Interdepartmental Transfers – Capital Assets A Supplement to the Financial Information Strategy (FIS) Manual
  155. Interim Directive on the Administration of the Access to Information Act
  156. Internal Support Services under Section 292 of the Financial Administration Act
  157. Internet Protocol Version 6 (IPv6) Network Equipment Procurement Guideline
  158. IT Security Guidelines, ITSG-33 control catalogue
  159. Long-Term Disability Insurance – Chapter 3-4
  160. Motor Vehicle Operations Directive – Chapter 2-11
  161. Notice on Policy on Management of Real Property – November 12, 2013
  162. Notice on Policy on Management of Real Property – November 16, 2009
  163. Notice on Policy on Management of Real Property – November 17, 2011
  164. Notice on Policy on the Management of Projects – November 12, 2013
  165. Occupational Health Evaluation Standard
  166. Operational Security Standard – Business Continuity Planning (BCP) Program
  167. Operational Security Standard – Readiness Levels for Federal Government Facilities
  168. Operational Security Standard Management of Information Technology Security (MITS)
  169. Operational Security Standard on Physical Security
  170. Operational Standard for the Security of Information Act
  171. Performance Pay Administration Policy for Certain Non-Management Category Senior Excluded Levels
  172. Performance pay for represented employees in the Administrative and Foreign Service Category
  173. Pesticides Directive – Chapter 2-15
  174. Policy Framework for Information and Technology
  175. Policy Framework for People Management
  176. Policy Framework for the Management of Assets and Acquired Services
  177. Policy Framework for the Management of Compensation
  178. Policy on Acceptable Network and Device Use
  179. Policy on Access to Information
  180. Policy on Classification
  181. Policy on Communications and Federal Identity
  182. Policy on Conflict of Interest and Post-Employment
  183. Policy on Decision Making in Limiting Contractor Liability in Crown Procurement Contracts
  184. Policy on Educational Assistance for Children of Employees – Chapter 7-3
  185. Policy on Employee Assistance Program
  186. Policy on Financial Management
  187. Policy on Government Security
  188. Policy on Green Procurement
  189. Policy on Harassment Prevention and Resolution
  190. Policy on Information Management
  191. Policy on Interchange Canada
  192. Policy on Internal Audit
  193. Policy on Investment Planning – Assets and Acquired Services
  194. Policy on Learning, Training, and Development
  195. Policy on Legal Assistance and Indemnification
  196. Policy on Management of Information Technology
  197. Policy on Management of Materiel
  198. Policy on Management of Real Property
  199. Policy on Occupational Safety and Health
  200. Policy on Official Languages
  201. Policy on Privacy Protection
  202. Policy on Results
  203. Policy on Service and Digital
  204. Policy on Service
  205. Policy on Terms and Conditions of Employment
  206. Policy on the Duty to Accommodate Persons with Disabilities in the Federal Public Service
  207. Policy on the Management of Executives
  208. Policy on the Management of Projects
  209. Policy on the Planning and Management of Investments
  210. Policy on Transfer Payments
  211. Procedures for Liaison with Private Contractors
  212. Procedures for Publishing
  213. Procurement Review Policy
  214. Public Service Income Benefit Plan for Survivors of Employees Slain on Duty
  215. Reducing Paper Burden on Small Business – A Progress Report for 1995 by the President of the Treasury Board
  216. Remediation Liabilities Related to Contaminated Sites A Supplement to the Financial Information Strategy (FIS) Manual
  217. Reporting Standard on Real Property
  218. Salary administration policy – Mediation Conciliation Officer Sub-group
  219. Security and Contracting Management Standard
  220. Security Organization and Administration Standard
  221. Self-Funded Leave Policy
  222. Service outside Canada
  223. Staff engaged locally outside Canada
  224. Standard for Electronic Documents and Records Management Solutions (EDRMS)
  225. Standard for fire safety planning and fire emergency organization – Chapter 3-1
  226. Standard for Organizational Project Management Capacity
  227. Standard for Project Complexity and Risk
  228. Standard on Customer Record
  229. Standard on Email Management
  230. Standard on Enterprise Resource Planning Systems
  231. Standard on Geospatial Data
  232. Standard on Identity and Credential Assurance
  233. Standard on Metadata
  234. Standard on Optimizing Websites and Applications for Mobile Devices
  235. Standard on Privacy and Web Analytics
  236. Standard on Quarterly Financial Reports for Crown Corporations
  237. Standard on Security Screening
  238. Standard on Vendor Record
  239. Standard on Web Accessibility
  240. Standard on Web Interoperability
  241. Standard on Web Usability
  242. Standards on Knowledge for Required Training
  243. Student Employment Policy
  244. TBITS 03 Coded Character Set for Information Interchange – Implementation Criteria
  245. TBITS 05 Canadian Government Keyboard Standard for Information Technology Equipment – Implementation Criteria
  246. TBITS 0611 Naming and Addressing for Government Handling Applications – Implementation Criteria
  247. TBITS 069 Canadian Open Systems Application Criteria (COSAC), Telecommunications wiring system in Government-Owned and leased buildings – Implementation Criteria
  248. TBITS 12 Codes for the Representation of Currencies and Funds – Implementation Criteria
  249. TBITS 23 Information Technology Vocabulary – Implementation Criteria
  250. TBITS 25 Materiel Coding – Implementation Criteria
  251. TBITS 26 Software Product Evaluation, Quality Characteristics and Guidelines for their Use – Implementation Criteria
  252. TBITS 30 Business Number – Implementation Criteria
  253. TBITS 36 All-Numeric Representation of Dates and Times -Implementation Criteria
  254. TBITS 38 Advanced card technologies – Physical parameters and appearance of the Government of Canada employee technology card – Implementation Criteria
  255. Telework Policy
  256. Term Employment Policy
  257. Termination of Employment of Public Service Employees Due to Alternative Delivery Situations
  258. Terms and Conditions of Employment for Students
  259. Values and Ethics Code for the Public Sector
  260. Workers’ Compensation
  261. Workplace Day Care Centres
  262. Workplace Fitness Program Policy

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.