invantive documentation
Invantive Support ForumsLog In / Sign Up

EMPLOYEE: AccountView Employees

read only per partition

  • Catalog: AccountView
  • Label: Employees

Can only retrieve data.

Table Columns

The columns of the table EMPLOYEE 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
AD_NAME varchar2(40) Full name
ADDRESS1 varchar2(80) Address
BLK_HOURS char Show blocked hours
CITY varchar2(35) City
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
CNT_CODE varchar2(2) ISO country code
COMMENT1 varchar2(4) Note
CON_T_01 decimal Contract hours Sunday
CON_T_02 decimal Contract hours Monday
CON_T_03 decimal Contract hours Tuesday
CON_T_04 decimal Contract hours Wednesday
CON_T_05 decimal Contract hours Thursday
CON_T_06 decimal Contract hours Friday
CON_T_07 decimal Contract hours Saturday
CON_T_NCHK char Do not check contract time
CON_TIME decimal Contract time
COST_CODE varchar2(10) Cost centre code
COUNTRY varchar2(30) Country
DATE_BIRTH datetime Date of birth
DATE_IN datetime Start of employment date
DATE_OUT datetime End of employment date
DEAR varchar2(40) Salutation
DFLT_COST varchar2(10) Default hour type amounts
DFLT_DIST varchar2(10) Default hour type quantities
DFLT_TIME varchar2(10) Default hour type hours
DPT_CODE varchar2(10) Department
EMP_GRP varchar2(10) Employee group
EMP_INV decimal Employee revenue
EMP_NR varchar2(10) Employee code
EMP_PCHS decimal Calculated internal hourly rate
EMP_PROF decimal Total profit per year
EMP_SELL decimal Calculated external hourly rate
EMP_SEX decimal Gender
EXT_DESC varchar2(40) External description
FAX_BUS varchar2(20) Business fax
FAX_PRIV varchar2(20) Private fax
FST_INIT varchar2(10) Initials
FST_NAME varchar2(20) First Name
GRP_CODE varchar2(10) Report group code
HR_IMPPROD decimal Non-productive hours
HR_PROD decimal Productive hours
IMG_FILE varchar2(4) Image
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
IS_WF_EMP char IFA employee
LVE_BUD decimal Leave budget
LVE_DAYS decimal Leave balance
MAIL_BUS varchar2(50) Business email
MAIL_PRIV varchar2(50) Private email
OWN_HOURS varchar2(1) Hours display
OWN_INV varchar2(1) Claim proposal display
OWN_OI varchar2(1) Invoice display
OWN_PROJ varchar2(1) Project display
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PCT_ALLOC decimal Overhead surcharge percentage
PCT_INV decimal Billing target
PCT_PROFIT decimal Profit surcharge percentage
PO_BOX varchar2(80) Postal address
PO_CITY varchar2(35) Postal address city
PO_CODE varchar2(10) Postal address postcode
POSITION varchar2(40) Job title
POST_CODE varchar2(10) Postcode
REC_BLK char Blocked
SAL_YEAR decimal Annual salary
ST_EXTRA varchar2(10) Address addition
ST_NR varchar2(10) House number
ST_REGION varchar2(40) Address region
ST_STREET varchar2(60) Street Name
TEL_BUS varchar2(20) Business telephone
TEL_MOB varchar2(20) Mobile telephone
TEL_PRIV varchar2(20) Private telephone
TIM_NORM decimal Standard number of hours per year
TIME_SHEET decimal Employee hours entry
USR_ID varchar2(20) User name
WF_ALLACCT char All general ledger accounts allowed
WF_AUTHAMT int64 Maximum approval amount
WHS_CODE varchar2(5) Default warehouse code
WWW_URL varchar2(80) Website