Project Log
Use this service to import Project Log information.
Method: ProjectLog
Underlying File Maintenance
Prior to importing Project Log information, the following file maintenance screens must be completed:Assumptions and Dependencies
If Company_Code and Category field names are blank then use the Authorization ID default value. Both fields are required in order to process the web service.
The TransactionId and Reference_Num field name can be defined or not.
If they are both blank then a new entry is created using the auto sequencing logic.
If the TransactionId is defined and valid then it will update the pre-existing record.
Any field that are left blank they will not be updated in Spectrum.
The service does not delete values that exist in Spectrum; it only changes data defined in the layout.
If the Reference_Num is defined along with the Company_Code, Job_Number, and Category and the unique combination of those fields are valid then it will update the pre-existing record.
Any field that are left blank they will not be updated in Spectrum.
The service does not delete values that exist in Spectrum; it only changes data defined in the layout.
If the Reference_Num is defined along with the Company_Code, Job_Number, and Category and the unique combination of those fields does not exist then a new entry is created using the defined Reference_Num.
If the defined 'Category' in the record has a default value defined and the information is not valid then the default value will be used.
If there is no default value defined then the field will be left blank.
No error will be returned to the user.
The following fields are validated against the defined Spectrum Project Management Tables.
Classification
Phase
Building
Area
Once the Record is entered into Spectrum the user will receive a Response message defining the following:
TransactionId for their records that is stored in their system and is used as a selection criteria if known.
If duplicate records exist to be updated, then they will all be updated as they are processed.
External_Link and External_Id field logic
These fields are used to define if a third party web connection is being used.
External_Link = states if a web address is defined in the field. This is a yes or no field.
External_Id = stores the complete web address such as http://www.msn.com
The defined Web URL (External_Id) controls how the information is opened in Spectrum. If it is defined then it uses the Spectrum Web link logic.
If the External_Id is defined then External_Link will be Y(es).
External_Id and External_Link fields DO NOT display on the Project Log detail tab screen.
Project Logs tied to an External_Id URL will be opened using the defined URL and can't be viewed within Spectrum.
Issued_Date and Resp_Req_Date field logic
If the Job has a defined Default Project Log for the Days to Respond then this field will be calculated when the new entry is made.
The Resp_Req_Date is only calculated if the default exists for the Job and Category.
If the Issue_Date is blank, it uses the system date and will calculate the Resp_Req_Date as well if the Job has defaults defined.
The Resp_Req_Date is not calculated if the Entry is being changed.
This Web Service will work with the defined Workflow process in Spectrum.
Field Descriptions
Use the table below for reference when using this service. The Authorization_ID and GUID elements are not shown on the Spectrum Excel Office Add-in templates for data entry points.Excel |
Element Name | Description | Req | Type | Max | Format | Validation |
---|---|---|---|---|---|---|---|
Authorization_ID | Authorization ID to access the server | YES | Text | 20 | Data Exchange Installation Screen | ||
GUID | Unique reference number created by programming | Text | 36 | ** See GUID definition | |||
B |
Company_Code | Company Code | Text | 3 | Can default from Authorization Id | Valid Company in Spectrum. Defaults from the Authorization ID if not populated. | |
C |
Job_Number | Job code | YES | Text | 10 | Valid Job in Spectrum | |
D |
TransactionId | Project Log ID | Text | 36 | TransactionId is created within Spectrum when the project log is added. If defined then the record will be updated. | Validates to the Project Log entry. | |
E |
Category | Category | Text | 30 | Validates to the Project Management Category Maintenance | ||
F |
Reference_Num | Number | Text | 10 | Reference_Num is created within Spectrum when the project log is added. ** If defined and the Company_Code, Job_Number and Category is unique the record will be updated otherwise creates a new entry. | Validates to the Project Log entry. | |
G |
Topic | Topic | Text | 250 | |||
H |
Issued_Date | Issued date | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) If left blank it will use the current date. | ||
I |
Resp_Req_Date | Respond by | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
J |
Answered_Date | Answered | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
K |
Cost_Impact | Cost impact? | Text | 1 | (Y)es or (N)o or blank field | ||
L |
Schedule_Impact | Schedule impact? | Text | 1 | (Y)es or (N)o or blank field | ||
M |
Status | Closed? | Text | 1 | (O)pen or (C )losed | ||
N |
Activity | Activity flag? | Text | 1 | (A)cton needed, (I)nformation or (T)racking | ||
O |
Priority | Priority flag? | Text | 1 | (H)igh, (M)edium or (L)ow | ||
P |
Classification | Discipline | Text | 50 | Validates to the Project Management Classification Maintenance | ||
Q |
Spec_Section | Spec Section | Text | 30 | |||
R |
Phase | Phase | Text | 20 | No dashes | Validates to the Job Phase | |
S |
Building | Building | Text | 10 | Validates to the Project Management Building / Area Maintenance | ||
T |
Area | Area | Text | 10 | Validates to the Project Management Building / Area Maintenance | ||
U |
Responsibility | Responsibility | Text | 250 | |||
V |
Reference | Reference | Text | 250 | |||
W |
Sent_via | Sent via | Text | 50 | |||
X |
Direction | Direction | Text | 1 | (I)nbound or (O)utbound or blank | ||
Y |
Email_Date | E-mail date | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
Z |
Weather | Weather | Text | 250 | |||
AA |
AM_Temperature | AM Temperature | Text | 6 | |||
AB |
PM_Temperature | PM Temperature | Text | 6 | |||
AC |
Precipitation_Amount | Precipitation Amount | Numeric | 6 | Positive number only. Enter as : xx.xxx | ||
AD |
Wind | Wind | Text | 15 | |||
AE |
External_Ref1 | External ID | Text | 30 | |||
AF |
External_Ref2 | Owner number | Text | 30 | |||
AG |
External_Link | Access to External Program? | Text | 1 | (Y)es or (N)o or blank field | **See Assumptions and Dependencies. | |
AH |
External_Id | External Program's Web URL | Text | 250 | Used to open details using the web link logic in Spectrum. | **See Assumptions and Dependencies. If defined then the External_Link = Y | |
AI |
Authored_By | Authored by | Text | 250 | |||
AJ |
Cost_Impact_Amount | Cost impact amount | Numeric | 14 | Allows negatives. Decimals OK | ||
AK |
Sent_To_Submitter | Sent to submitter | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AL |
Required_From_Submitter | Required from submitter | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AM |
Received_From_Submitter | Received from submitter | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AN |
Sent_To_Approver | Sent to approver | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AO |
Required_From_Approver | Required from approver | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AP |
Received_From_Approver | Received from approver | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AQ |
Returned_To_Submitter | Returned to submitter | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AR |
Scheduled_Delivery | Scheduled delivery | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AS |
Actual_Delivery | Actual delivery | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AT |
Inspection | Inspection | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AU |
Re_Inspection | Reinspection | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AV |
Scheduled_Complete | Scheduled complete | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AW |
Signed_Off | Signed off | Date | 10 | Enter as: MM/DD/CCYY (for example, 01/05/2010) | ||
AX |
Schedule_Impact_Days | Schedule Impact days | Numeric | 4 | Allows negatives. Decimals OK | ||
AY |
Log_Status | Log Status | Text | 30 | |||
AZ |
Subsection | Subsection | Text | 10 |