Data Map - Spectrum

Data Map - Spectrum

Data is mapped between JobSiteForecast and Spectrum as show below.

Get Data

The following GET routines retrieve data from Spectrum and integrate it into the JobSiteForecast database.

Get Jobs

Company_Code,
Job_Number,
Job_Description,
Division,
Address_1,
Address_2,
City,
State,
Zip_Code,
Project_Manager,
Superintendent,
Estimator,
Certified_Flag,
Customer_Code,
Status_Code,
Work_State_Tax_Code,
Contract_Number,
Cost_Center,
Net_Cash_Flow,
Revised_Contract,
Projected_Cost
Cost_to_Date,
Billed_To_Date,

Get Phases

Company_Code Job_Number Phase_Code Cost_Type Description Status_Code Unit_of_Measure JTD_Quantity JTD_Hours JTD_Cost Projected_Quantity Projected_Hours Projected_Dollars Estimated_Quantity Estimated_Hours Current_Estimated_Dollars Cost_Center Error_Code Error_Description Error_Column Work_State_Tax_Code

Get Employees

Company_Code
Employee_Code
Employee_Name
Supervisor_Code
Employment_Status
Department_Code
Union_Code
Wage_Class
Worker_Comp_Code
First_Name
Middle_Name
Last_Name
Occupation
Trade
Title
Employee_Mobile_Phone
Employee_Extension

Get Job Cash Flow

Company_Code
Job_Number
Net_Cash_Flow
Cost_to_Date
Billed_to_Date

Get Unposted Time Cards

Company_Code
Job_Number
Phase_Code
Cost_Type
sum (Hours)

Get Unposted Quantities

Company_Code
Job_Number
Phase_Code
Cost_Type
sum (Additional_JTD_Qty)

Get Add On Cash Codes

Company_Code
Vol_Deduct_Code
Vol_Deduct_Description
Deduct_Type
Calc_Method
Direct_Cost_Flag

Where Deduct_Type = 'A' and Add_On_Cash_Flag = 'Y'

Get Company Codes

Company_Code
Company_Name

Get Cost Centers

Company_Code
Cost_Center_Code
Cost_Center_Description
Status

Get Departments

Company_Code
Department_code
Description
Direct_Cost_Flag

Get Cost Types

Company_Code
Cost_Type
Description

Post Data

The following routine post data into Spectrum using the Spectrum APIs.

Post Projected Cost

Company_Code
Job_Number
Phase_Code
Cost_Type
Transaction_Date
Projected_Cost
Projected_Hours
Projected_Quantity
Note
Operator_Code

Post Time Cards

Company_Code
Batch_Code
Employee_Code
Department_Code
Pay_Type
Hours
Job_Number
Phase_Code
Cost_Type
Work_Date
Message
Additional_JTD_Qty

Post Projected Quantity

Company_Code
Job_Number
Phase_Code
Cost_Type
Additional_Qty
Transaction_Date

    • Related Articles

    • Export Data

      General This process will export data from the database and provide it in another format for upload into your accounting system. The steps to export are: Select the week ending date that you wish to export. You can select one of the last 4 weeks. ...

    • Import Data

      Single Job Import This screens provides a method for importing job details when you need a new job immediately imported and cannot wait for the overnight process to update the job list. To add a new job: Enter the job number in the field Click SEARCH ...

    • Job Cost Analysis

      This screens provides detailed cost analysis on the job. Grid The listing in the grid provides all the hours projections and cost projections for each phase code. This grid has many columns so it is best to configure your screen to provide the view ...

    • Release Notes - March 2024

      A number of enhancements are now available. Job Cost Analysis Screen When syncing data, Spectrum will ignore any changes to phase codes set to "C" Complete Status. Spectrum does not allow any changes to a phase code cost or hours once the status is ...

    • Release Notes - April 2023

      This release has a number of changes inside the functioning of the system. Automatic Overnight Updates The system will now update overnight automatically. This means there is no need to import the payroll weekly. The IMPORT button is now grayed out ...