Pre-Time Card
Use this service to import Pre-Time Card Transaction information.
WSDL: PreTimeCard.jws
Method: PreTimeCard
Underlying File Maintenance
Prior to importing Pre-Time Card Transaction information, the following file maintenance screens must be completed:
Assumptions and Dependencies
General Guidelines
The transaction data being submitted using this web service are stored within the Payroll Approve Pre-Time Import screen by Employee or by Quantity and requires the data to be manually approved within Spectrum using the Approval buttons on the screen.
The Pre-time card Web Service submits one record at a time and creates 'R'egular Check types for the next available sequence number. If a 'R'egular Check types exist then it adds the details to the first existing sequence number.
The Pre-time card Web Service does not support the Salary redistribution logic used in standard Pre-time card entry.
To maintain Spectrum's flexibility, the Data Exchange logic will validate the web service authorization, required fields, numeric, date and generic validations only.
The Payroll and General Ledger Modules must be set up.
The flexibility within the Pre-Time Card web service creates new employee and quantity records. The SDX manual defines the specific guidelines for each type of record.
Validation will be performed on the Company_Code, Work_Date and Pay_Type.
Cost center information will only be allowed if the Company is set to a Yes status.
This Web Service is not impacted by the Workflow process in Spectrum.
Employee Record Guidelines
Any Pay_Type other than Q(uantity) will be sent to the Pre-Time Card Import Errors screen located within the Pre-Time Card Import logic.
The Department_Code defined controls what information appears in the record.
If excess data is sent within the record, the Department_Code will control what data remains in the record for review.
Non-direct departments should not have any Job, Equipment or Work Order details defined.
All standard Spectrum Pay Types and Add-on / Deduction codes are supported and validated to the Company_Code. See the Pay Types options defined in layout.
Quantity Record Guidelines
The Quantity pay type 'Q' is used to designate that a quantity record is to be created and submitted to the Pre-time Card Quantity Import Errors screen within the Pre-Time Card Import logic.
Field Descriptions
Use the table below for reference when using this service.
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 |
Company where the records will be created. |
Valid Company in Spectrum. Defaults from the Authorization ID if not populated. |
|
C |
Batch_Code |
Batch Code |
YES |
Text |
8 |
New or existing batch code |
|
D |
Employee_Code |
Employee |
Text |
11 |
Must exist in company per the Company_Code entry. Not required for quantity records. |
||
E |
Department_Code |
Department |
Text |
6 |
Not required for quantity records. ** See Assumptions and Dependencies. |
||
F |
Pay_Type |
Pay type |
YES |
Text |
10 |
(R)egular; (O)vertime; (D)ouble time; (H)oliday; (V)acation; (S)ick; (M)iscellaneous; (SA)-Special amount; (ER)-Equipment-Regular; (EO)-Equipment-Overtime; (ED)-Equipment-Double time; (EU)-Equipment usage; (RP)-Retro-pay; (JX)-Job only adjustment hours; (1,2 or 3)-Description set in Payroll Installation screen; (Q)uantity entries only; (I)ncentive pay or (U)npaid time and Add-on or Deduction codes. |
Validates to the defined Company_Code field name. All pay types supported including Incentive pay types when specified on the Payroll Installation screen (for example, IR, IO, ID when "I" is specified), Add-on and Deduction codes. |
G |
Hours_Employee |
Employee Hours |
Numeric |
8 |
Enter decimals but no $ signs or commas. Can be positive or negative; Not required for quantity records. |
||
H |
Job_Number |
Job |
Text |
10 |
Required for Quantity records. |
||
I |
Phase_Code |
Phase |
Text |
20 |
No dashes. Required for Quantity records. |
||
J |
Cost_Type |
Cost type |
Text |
3 |
Required for Quantity records. |
||
K |
Work_Date |
Date |
YES |
Text |
8 |
Enter as: MM/DD/CCYY (that is, 01/05/2010). |
Within P/R processing date range |
L |
Message |
Message |
Text |
30 |
Cannot contain Super select characters. |
||
M |
Pay_Rate_Code |
Rate level |
Text |
1 |
1 thru 9 only |
||
N |
Wage_Code |
Wage code |
Text |
10 |
|||
O |
Union_Code |
Union code OR Pay group |
Text |
10 |
|||
P |
Worker_Comp_Code |
Work Comp |
Text |
6 |
|||
Q |
State |
Work state |
Text |
10 |
|||
R |
Work_County |
Work county |
Text |
10 |
|||
S |
Work_Locality |
Work local |
Text |
10 |
|||
T |
Equipment_Code |
Equipment |
Text |
10 |
|||
U |
Equipment_Hours |
Equipment Hours |
Numeric |
8 |
Enter decimals but no $ signs or commas. Can be positive or negative |
||
V |
Additional_JTD_Quantity |
Add'l JTD Qty |
Numeric |
14 |
Enter decimals but no $ signs or commas. Can be positive or negative |
||
W |
Inter_Company_Code |
Inter-Company code |
Text |
3 |
For Employee records- the data will be shown for this company code. For Quantity records the data will need to be reviewed and the company code changed on the error screen. |
Define the valid Company code here if the Job, Work Order or Equipment is from a different company. |
|
X |
Pay_Rate |
Pay Rate |
Numeric |
12 |
Enter decimals but no $ signs or commas. Can be positive or negative |
||
Y |
Cost_Category_Code |
Cost Category |
Text |
4 |
|||
Z |
Crew_Number |
Crew |
Text |
10 |
|||
AA |
WO_Number |
Work Order |
Text |
10 |
|||
AB |
WO_Equipment |
WO Site Equipment |
Text |
8 |
|||
AC |
WO_Component |
WO Component |
Text |
2 |
|||
AD |
SC_Contract |
WO Contract |
Text |
10 |
|||
AE |
PM_Work_Order |
Equipment Work Order |
Text |
10 |
|||
AF |
Cost_Center |
Cost Center |
Text |
10 |
Cost Center Maintenance; G/L Account Cost Center; Job Cost Center; Phase Cost Center; Equipment Cost Center; Equipment Type Cost Center and Work Order Cost Center |