NMBRS API Data Model
EmployeeAbsences: Employee Absences |
https://online-sql-editor.com/nmbrs/nl/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Nmbrs.Employees.EmployeeAbsences%0D%0Alimit++1000
Name: EmployeeAbsences
Catalog: Nmbrs
Schema: Employees
Label: Employee Absences
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Service URL (XML-specific): EmployeeService.asmx
Topic (XML-specific): Absence_GetList
Base XPath (XML-specific): /soap:Envelope/soap:Body/nes:Absence_GetListResponse
XPath (XML-specific): /nes:Absence_GetListResult/nes:Absence
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 |
|---|---|---|---|---|
COMMENT |
string |
Comment |
☐ |
|
DOSSIER |
string |
File |
☐ |
|
DOSSIERNR |
int32 |
File Number |
☐ |
|
EMPLOYEEID |
int32 |
Employee ID |
☐ |
|
END |
datetime |
End |
☐ |
|
PERCENTAGE |
int32 |
Percentage |
☐ |
|
REGISTRATIONENDDATE |
datetime |
Registration End Date |
☐ |
|
REGISTRATIONSTARTDATE |
datetime |
Registration Start Date |
☐ |
|
START |
datetime |
Start |
☐ |
|
14-05-2020 17:1320.1.36-BETA+2798
