ROBAWS API Data Model

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Print Topic
Send Mail Feedback
Share This Topic
Save Permalink URL

Navigation: Schema: Employees > Tables

EmployeeCertificates: Employee Certificates

Contents Previous Home Next More

https://cloud.invantive.com/robaws/Sql

Catalog: Robaws

Schema: Employees

Label: Employee Certificates

Select: true

Insert: false

Update: false

Delete: false

Select Service URL (OData-specific): /api/v1/employees

Insert Service URL (OData-specific): /api/v1/employees

Update Service URL (OData-specific): /api/v1/employees

Delete Service URL (OData-specific): /api/v1/employees

Field Selection Method (OData-specific): NotRequired

Base Path (OData-specific): content[*].certificates[*]

Select Operation (Swagger-specific): get /api/v1/employees

Table Function Parameters

The following parameters can be used to control the behaviour of the table function EmployeeCertificates. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name	Data Type	Required	Documentation
fromDate	datetime	☐	fromDate
name	string	☐	name
offset	int64	☐
paged	boolean	☐
pageNumber	int32	☐
searchText	string	☐	searchText
size	int32	☐	Number of records per page.
sort.sorted	boolean	☐
sort.unsorted	boolean	☐
toDate	datetime	☐	toDate
unpaged	boolean	☐
updatedFrom	datetime	☐	updatedFrom

Table Columns

The columns of the table EmployeeCertificates are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required
address_city	string	City	☐
address_country	string	Country	☐
address_latLng_defined	boolean		☐
address_latLng_lat	double		☐
address_latLng_lng	double		☐
address_street	string	Street	☐
address_streetBase	string		☐
address_streetExtra	string		☐
address_streetNumber	string		☐
address_zipcode	string	ZIP Code	☐
bankaccountNr	string	Bank Account Number	☐
birthDate	datetime	Birth Date	☐
civilStatus	string		☐
competenceLevel	string	Competence Level	☐
costPerHour	double	Cost per Hour	☐
defaultMobility_id	int64		☐
defaultMobility_name	string		☐
defaultMobility_version	int64		☐
defaultOperation_accountancyCode_code	string		☐
defaultOperation_accountancyCode_externalId	string		☐
defaultOperation_accountancyCode_id	int64		☐
defaultOperation_accountancyCode_name	string		☐
defaultOperation_accountancyCode_version	int64		☐
defaultOperation_accountancyCodePurchase_code	string		☐
defaultOperation_accountancyCodePurchase_externalId	string		☐
defaultOperation_accountancyCodePurchase_id	int64		☐
defaultOperation_accountancyCodePurchase_name	string		☐
defaultOperation_accountancyCodePurchase_version	int64		☐
defaultOperation_activity	string		☐
defaultOperation_agreementType	string		☐
defaultOperation_articleGroup_contextPath	string		☐
defaultOperation_articleGroup_id	int64		☐
defaultOperation_articleGroup_name	string		☐
defaultOperation_articleGroup_photo_availableForWappy	boolean		☐
defaultOperation_articleGroup_photo_directory	boolean		☐
defaultOperation_articleGroup_photo_documentDate	datetime		☐
defaultOperation_articleGroup_photo_expirationDate	datetime		☐
defaultOperation_articleGroup_photo_filename	string		☐
defaultOperation_articleGroup_photo_fileSize	int64		☐
defaultOperation_articleGroup_photo_id	int64		☐
defaultOperation_articleGroup_photo_mimeType	string		☐
defaultOperation_articleGroup_photo_objectRef_objectId	int64		☐
defaultOperation_articleGroup_photo_objectRef_objectType	string		☐
defaultOperation_articleGroup_photo_parentId	int64		☐
defaultOperation_articleGroup_photo_path	string		☐
defaultOperation_articleGroup_photo_uuid	string		☐
defaultOperation_articleGroup_photo_version	int64		☐
defaultOperation_articleGroup_photo_wappy	boolean		☐
defaultOperation_articleGroup_version	int64		☐
defaultOperation_articleNumber	string		☐
defaultOperation_articleType	string		☐
defaultOperation_barcode	string		☐
defaultOperation_brand	string		☐
defaultOperation_calc	boolean		☐
defaultOperation_calcDescription	string		☐
defaultOperation_calculationType	string		☐
defaultOperation_chapter	string		☐
defaultOperation_costPrice	double		☐
defaultOperation_costPriceStrategy	string		☐
defaultOperation_currencySymbol	string		☐
defaultOperation_description	string		☐
defaultOperation_deviantSalesName	string		☐
defaultOperation_headerLevel	string		☐
defaultOperation_id	int64		☐
defaultOperation_indirectCostFactor	double		☐
defaultOperation_internalPhoto	boolean		☐
defaultOperation_lineType	string		☐
defaultOperation_margin	double		☐
defaultOperation_materialInstallation	boolean		☐
defaultOperation_minimumSaleAmount	double		☐
defaultOperation_minimumStockAmount	double		☐
defaultOperation_name	string		☐
defaultOperation_newPage	boolean		☐
defaultOperation_photo_availableForWappy	boolean		☐
defaultOperation_photo_directory	boolean		☐
defaultOperation_photo_documentDate	datetime		☐
defaultOperation_photo_expirationDate	datetime		☐
defaultOperation_photo_filename	string		☐
defaultOperation_photo_fileSize	int64		☐
defaultOperation_photo_id	int64		☐
defaultOperation_photo_mimeType	string		☐
defaultOperation_photo_objectRef_objectId	int64		☐
defaultOperation_photo_objectRef_objectType	string		☐
defaultOperation_photo_parentId	int64		☐
defaultOperation_photo_path	string		☐
defaultOperation_photo_uuid	string		☐
defaultOperation_photo_version	int64		☐
defaultOperation_photo_wappy	boolean		☐
defaultOperation_saleName	string		☐
defaultOperation_salePrice	double		☐
defaultOperation_salePriceStrategy	string		☐
defaultOperation_stockAmount	double		☐
defaultOperation_stockChanges	string		☐
defaultOperation_stockLocation	string		☐
defaultOperation_supplierNames	string		☐
defaultOperation_timeOperation	boolean		☐
defaultOperation_unitType	string		☐
defaultOperation_vatTarif	string		☐
defaultOperation_version	int64		☐
dependentChildren	int32		☐
detachment	boolean		☐
dimona	string		☐
dimonaExpireDate	datetime		☐
distance	double	Distance	☐
documentRsz	int64		☐
documentRszPayment	int64		☐
documentRszValidTill	datetime		☐
driverLicense	string	Driver License	☐
email	string	Email	☐
emergencyTel	string	In Case of Emergency Phone	☐
employeeGone	datetime	Employee Gone Date	☐
employeeRole_id	int64		☐
employeeRole_name	string		☐
employeeRole_version	int64		☐
employeeSince	datetime	Employee since	☐
employeeStatute	string		☐
expireDateRszPayment	datetime		☐
fullname	string	Full Name	☐
function	string	Function	☐
gender	string	Gender	☐
grossSalary	double	Gross Salary	☐
gsm	string	Mobile	☐
gsmOrTel	string	Mobile or Phone	☐
id	int64	ID	☐
independentCertificate	boolean	Independent Certificate	☐
independentConnection	boolean	Independent Connection	☐
insz	string		☐
limosaExpireDate	datetime		☐
limosaNr	string		☐
name	string	Name	☐
nameAndState	string	Name and State	☐
nationality	string	Nationality	☐
objectDescription	string		☐
passportExpireDate	datetime	Passport Expiry Date	☐
passportNr	string	Passport Number	☐
paymentRsz	boolean		☐
planningGroup	string	Planning Group	☐
startDate	datetime	Start Date	☐
status	string	Status	☐
subType	string	Sub Type	☐
supplier_accountancyCodePurchase_code	string		☐
supplier_accountancyCodePurchase_externalId	string		☐
supplier_accountancyCodePurchase_id	int64		☐
supplier_accountancyCodePurchase_name	string		☐
supplier_accountancyCodePurchase_version	int64		☐
supplier_accountNr	string		☐
supplier_addressString	string		☐
supplier_bank	string		☐
supplier_btwNumber	string		☐
supplier_currencySymbol	string		☐
supplier_email	string		☐
supplier_externalId	string		☐
supplier_fax	string		☐
supplier_gsm	string		☐
supplier_id	int64		☐
supplier_invoiceAddress_city	string		☐
supplier_invoiceAddress_country	string		☐
supplier_invoiceAddress_latLng_defined	boolean		☐
supplier_invoiceAddress_latLng_lat	double		☐
supplier_invoiceAddress_latLng_lng	double		☐
supplier_invoiceAddress_street	string		☐
supplier_invoiceAddress_streetBase	string		☐
supplier_invoiceAddress_streetExtra	string		☐
supplier_invoiceAddress_streetNumber	string		☐
supplier_invoiceAddress_zipcode	string		☐
supplier_invoiceRemarks	string		☐
supplier_language	string		☐
supplier_legalForm_hasVat	boolean		☐
supplier_legalForm_id	int64		☐
supplier_legalForm_name	string		☐
supplier_legalForm_pdfName	string		☐
supplier_legalForm_version	int64		☐
supplier_legalName	string		☐
supplier_logicId	string		☐
supplier_name	string		☐
supplier_planningEmail	string		☐
supplier_status	string		☐
supplier_supplyOrderRemarks	string		☐
supplier_tel	string		☐
supplier_vat_ublSchemeId	string		☐
supplier_vat_vatCode	string		☐
supplier_vat_vatCountry	string		☐
supplier_vat_vatValid	boolean		☐
supplier_vatNr	string		☐
supplier_vatTarif	string		☐
supplier_version	int64		☐
supplier_website	string		☐
supplierName	string	Supplier Name	☐
surname	string	Last Name	☐
tel	string	Phone	☐
type	string	Type	☐
version	int64	Version	☐

17-11-2020 16:0920.1.279-BETA+2990

Please enable JavaScript to view this site.

ROBAWS API Data Model

EmployeeCertificates: Employee Certificates

Table Function Parameters

Table Columns