Skip to main content
Skip table of contents

wsiSMSTechnician

Table: SV00115

Element NameData TypeLengthRequiredDefaultDescription

@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 CodeDescription

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.