/
Sage Timberline Variation Comparison Integration - Reference

Sage Timberline Variation Comparison Integration - Reference

Owned by Matthew Garrett
Last updated: Aug 27, 2021
2 min read

Return to Sage Timberline Variation Comparison Integration
Article Index

Integrated Fields

In this type of integration, no data is altered in Framework ECM or Sage Timberline. As a result there are no integrated fields in Sage Timberline Variation Comparison.

Database Models

The following database model(s) displays the manner in which data is integrated between the third party application and Framework Integration.

Integration Process

The following information is a low level account of the integration process including criteria, decisions, and outcomes. This information is technical in nature and is provided "as-is" for a detailed analysis of the integration process for system administrators.

  1. Get eligible framework jobs from v_sched_tlGold1 where

    1. Client.s_name_ref is not null

    2. Client.s_name is not null

    3. Job.s_link_accts <> ‘N/A’

    4. Job.l_job_status_gl_id = -7(Active) or -10(On Hold) or l_job_status_gl_id = -946 (Pending Cancellation) or -8(Cancelled) and if d_cont_cancelled >= (today - 14 days).

    5. Job.l_wfl_stgMajor_id <> -5 (Maintenance) 
      OR
      Job.l_wfl_stgMinor_id = -18(Maint DLP) and d_settle_act >= (today - 140) up to 20 weeks or Job.l_wfl_stgMinor_id = -19(Maint Service) and d_dlp_expiry_act >= (today - 28) up to 4 weeks.

    6. and apply Criteria Method criteria where CriteriaMethod is

    7. 1 – Single Region Division • job.l_context_id = ‘CriteriaMethodID’

    8. 2 – Single Job • job.s_job_num = ‘CriteriaMethodID’

    9. 3 – Single Team • job.l_team_id = ‘CriteriaMethodID’

    10. 4 – All Jobs • job.l_job_id <> 0

    11. 5 – Accounts Entity • job.l_accounts_e_id = ‘CriteriaMethodID’

  2. For each job, get all doc records linked to the job where

    1. Doc.l_doc_type_gl_id = -228(Variation Order Document)

    2. Doc.l_doc_stat_gl_id = -222(Final) • Doc.d_signed_act is not null

  3. Get matching CNC document group from timberline table Active_cnc_record_17 where If job.s_link_boq is empty then

    1. Active_cnc_record_17.OOC = job.s_job_num(formatted for timberline) Else

    2. Active_cnc_record_17.OOC = job.s_link_boq

  4. Get Matching CNC documents from timberline table Active_cnc_record_19 where

    1. Active_cnc_record_19.OIC = Active_cnc_record_17.OOC

    2. Active_cnc_record_19.OICO = Active_cnc_record_17.OOCO

  5. Finally compare the framework totals with the Timberline totals