Please enable JavaScript to view this site.

Navigation: Schema: Views > Views

VariableHourComponents: NMBRS Variable Hour Components

Variable hour components over the last seven years. Historical variant of EmployeeCurrentHourComponentsVariable.

Catalog: Nmbrs

Schema: Views

Label: Variable Hour Components

This is a read-only view. The NMBRS API may not support changing the data or the Invantive SQL driver for NMBRS does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the NMBRS API.

View Columns

The columns of the view VariableHourComponents are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

COMPANY_CODE

int64

Company ID

 

EMP_COMPANY_CODE

int64

Company ID

 

EMP_DISPLAYNAME

string

Display Name

 

EMP_ID

int32

Employee ID

 

EMP_NUMBER

int32

Employee Number

 

EMPLOYEEID

int32

Employee ID

 

HOURCODE

int32

Hour Code

 

HOURS

decimal

Hours

 

ID

int32

ID

 

PRD_PERIOD_TYPE

string

Period Type

 

PRD_period

int32

Period

 

PRD_year

int32

Year

 

 

27-12-2021 10:56 Version 20.2.169-PROD+3633