wsiSMSTechnician
Table: SV00115
Element Name | Data Type | Length | Required | Default | Description |
---|---|---|---|---|---|
@I_vAllowableOvertimeHours | smallint |
| |||
@I_vEmployeeID | char | 15 | |||
@I_vEmployeeVehicle | char | 15 | |||
@I_vEPACertification | char | 51 | |||
@I_vOnlyValidate | tinyint |
| |||
@I_vPagerNumber | char | 21 | |||
@I_vPrimarySkillLevel | char | 15 | |||
@I_vRDCAccessNumber | char | 21 | |||
@I_vReturnErrorText | tinyint |
| |||
@I_vSVInactive | tinyint |
| |||
@I_vSVLanguageID | smallint |
| |||
@I_vSVPagerPIN | char | 41 | |||
@I_vSVPagerVendorID | char | 11 | |||
@I_vTechnician | char | 11 | |||
@I_vTechnicianID | char | 15 | |||
@I_vTechnicianLongName | char | 31 | |||
@I_vTechnicianTeam | char | 15 | |||
@I_vTimeZone | char | 3 | |||
@I_vTimeZoneTag | char | 5 | |||
@I_vUpdateIfExists | tinyint |
| |||
@I_vUserID | char | 15 | |||
@I_vUSRDEFND1 | char | 50 | |||
@I_vUSRDEFND2 | char | 50 | |||
@I_vUSRDEFND3 | char | 50 | |||
@I_vUSRDEFND4 | varchar | 8000 | |||
@I_vUSRDEFND5 | varchar | 8000 | |||
@I_vVendorID | char | 15 | |||
@I_vVendorSwitch | tinyint |
| |||
@I_vWennsoftAffiliate | char | 15 | |||
@I_vWennsoftBranch | char | 15 | |||
@I_vWennsoftRegion | char | 15 | |||
@I_vWennSoftTablesOnly | tinyint |
| |||
@I_vWSReservedCB1 | tinyint |
| |||
@I_vWSReservedCB10 | tinyint |
| |||
@I_vWSReservedCB2 | tinyint |
| |||
@I_vWSReservedCB3 | tinyint |
| |||
@I_vWSReservedCB4 | tinyint |
| |||
@I_vWSReservedCB5 | tinyint |
| |||
@I_vWSReservedCB6 | tinyint |
| |||
@I_vWSReservedCB7 | tinyint |
| |||
@I_vWSReservedCB8 | tinyint |
| |||
@I_vWSReservedCB9 | tinyint |
| |||
@I_vWSReservedSTR1 | char | 11 | |||
@I_vWSReservedSTR2 | char | 11 | |||
@O_iErrorState | int |
| |||
@oErrString | varchar | 255 |
Error Codes
Error Code | Description |
---|---|
52132 | Employee ID does not exist. |
52177 | Affiliate, region and branch are not valid. |
52204 | Time Zone Tag is invalid. |
52228 | Technician Team does not exist. |
52261 | Vendor ID does not exist |
52297 | The UpdateIfExists parameter is invalid: 0=Do Not Update 1=Update if exists. |
52346 | Technician field is empty. |
52347 | Pager Number field contains an invalid value (length > 14). |
52348 | Skill Level does not exist. In the SV00572, Skill Level and SV Language ID are the primary key and both need to be valid. |
52349 | MobileTech User Checkbox (WSReservedCB1) is invalid. Enter 0 or 1. |
52350 | Allow Double Checkbox (WSReservedCB2) is invalid. Enter 0 or 1. |
52351 | WSReservedCB3 is invalid. Enter 0 or 1. |
52352 | WSReservedCB4 is invalid. Enter 0 or 1. |
52353 | WSReservedCB5 is invalid. Enter 0 or 1. |
52354 | WSReservedCB6 is invalid. Enter 0 or 1. |
52355 | WSReservedCB7 is invalid. Enter 0 or 1. |
52356 | WSReservedCB8 is invalid. Enter 0 or 1. |
52357 | WSReservedCB9 is invalid. Enter 0 or 1. |
52358 | WSReservedCB10 is invalid. Enter 0 or 1. |
52359 | SVInactive Checkbox is invalid. 0 = Active 1=Inactive. |
52360 | SV Pager Vendor ID does not exist in SV_Pager_Vendor_MSTR (SVPGVNDR). |
52361 | Error updating record in the SV00115 table. |
52362 | Error inserting record in the SV00115 table. |
52382 | A Vendor ID and Employee ID cannot be assigned to the same record. |