invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeContractPeriodsCurrent: Nmbrs Employee Current Contract Periods

read only

  • Catalog: Nmbrs
  • Schema: Views
  • Label: Employee Current Contract Periods

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 48

The result can be cached on the client.

Table Columns

The columns of the table EmployeeContractPeriodsCurrent are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
ECD_CONTRACTID int32 Contract ID
ECD_CREATIONDATE datetime Creation Date
ECD_EMPLOYEEID int32 Employee ID
ECD_EMPLOYEMENTTYPE int32 Employment Type
ECD_EMPLOYMENTSEQUENCETAXID int32 Employment Sequence Tax ID
ECD_ENDDATE datetime End Date
ECD_HOURSPERWEEK decimal itgen_nmbrs_hoursperweek
ECD_INDEFINITE char Indefinite
ECD_PHASECLASSIFICATION int32 Phase Classification
ECD_STARTDATE datetime Start Date
ECD_TRIALPERIOD datetime Trial Period
ECD_WRITTENCONTRACT char itgen_nmbrs_writtencontract
EMP_COMPANY_CODE int64 Company ID
EMP_DISPLAYNAME varchar2 Display Name
EMP_ID int32 Employee ID
EMP_NUMBER int32 Employee Number

Sample Queries

--
-- A view joining employees with a table function on contract to get a list of employee contracts from Nmbrs.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/nmbrs-data-model/webhelp/nmbrs-connector-views-employeecontractperiodscurrent.html
--
-- Related forum post: https://forums.invantive.eu/t/what-are-table-functions-and-table-function-parameters/1868
--
select *
from   Nmbrs.Views.EmployeeContractPeriodsCurrent@nms
limit  100

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: