Get Project Log Jobs

Use this service to import Project Log Jobs information.

WSDL: GetPJJob.jws

Method: GetPJJob

Enhanced Authentication

Assumptions and Dependencies

  • The Authorization ID controls the security and defaults the pCompany_Code field if left blank in the parameter fields.

  • All parameter fields have SuperSelect logic except the pSort_By

Parameter Fields

Use the table below for reference when using this service.
Element Name Description Req Type Max Field Information
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
pCompany_Code Company Code YES Text 3 Valid Company in Spectrum. Defaults from the Authorization ID if not populated.
pJob_Number Job Number Text 10
pStatus_Code if left blank then active and inactive only Text 1 (A)ctive, (I)nactive or (C )omplete
pCost_Center if blank then all for company and operator or enter one only Text 50 Project Log Discipline
pSort_By Sort By Options Text 1 Blank = Company Code or D= Log Class

Return Fields

Use the table below for reference when using this service.
Element Name Description Type Max Field Information
Company_Code Company Code Text 3 Valid Spectrum Company
Job_Number Job Number Text 10
Job_Description Job Name Text 25
Status_Code Status Text 1 (A)ctive, (I)nactive or (C )omplete
Category Project Log Category Text 30
PJ_Reference_Num Last Project Log Reference Number per Category Text 10 Display the Reference Number from the Project Log table per Category
Cost_Center Job Cost Center Text 10
Error_Code Error Code Text 1 Used for Error information if needed
Error_Description Error Description Text 250 Used for Error information if needed
Error_Column Error Column Text 100 Used for Error information if needed