NMBRS API Data Model
EmployeeContractsV2: itgen_nmbrs_employee_employeecontractsv2 |
https://online-sql-editor.com/nmbrs/nl/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Nmbrs.Employees.EmployeeContractsV2%0D%0Alimit++1000
Name: EmployeeContractsV2
Catalog: Nmbrs
Schema: Employees
Label: itgen_nmbrs_employee_employeecontractsv2
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Service URL (XML-specific): EmployeeService.asmx
Topic (XML-specific): Contract_GetAll_v2
Base XPath (XML-specific): /soap:Envelope/soap:Body/nes:Contract_GetAll_v2Response
XPath (XML-specific): /nes:Contract_GetAll_v2Result/nes:Contract_v2
Server-side Filters (XML-specific): EmployeeId
Default Namespace Prefix (XML-specific): nes
Parameters
Name |
Data Type |
Required |
Default Value |
Documentation |
|---|---|---|---|---|
EmployeeId |
int32 |
☑ |
|
|
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
CONTRACTID |
int32 |
Contract ID |
☐ |
|
CONTRACTTYPE |
int32 |
Contract Type |
☐ |
|
EMPLOYEEID |
int32 |
Employee ID |
☐ |
|
EMPLOYEMENTTYPE |
int32 |
Employment Type |
☐ |
|
EMPLOYMENTSEQUENCETAXID |
int32 |
Employment Sequence Tax ID |
☐ |
|
ENDDATE |
datetime |
End Date |
☐ |
|
INDEFINITE |
boolean |
Indefinite |
☐ |
|
STARTDATE |
datetime |
Start Date |
☐ |
|
TRIALPERIOD |
datetime |
Trial Period |
☐ |
|
14-05-2020 17:1320.1.36-BETA+2798
