EMPLOYEE: AccountView Employees
read only per partition
- Catálogo:
AccountView - Label: Employees
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla EMPLOYEE. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
AD_ |
varchar2 |
Full name | |||
ADDRESS1 |
varchar2 |
Address | |||
BLK_ |
char |
Show blocked hours | |||
CITY |
varchar2 |
City | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
CNT_ |
varchar2 |
ISO country code | |||
COMMENT1 |
varchar2 |
Note | |||
CON_ |
decimal |
Contract hours Sunday | |||
CON_ |
decimal |
Contract hours Monday | |||
CON_ |
decimal |
Contract hours Tuesday | |||
CON_ |
decimal |
Contract hours Wednesday | |||
CON_ |
decimal |
Contract hours Thursday | |||
CON_ |
decimal |
Contract hours Friday | |||
CON_ |
decimal |
Contract hours Saturday | |||
CON_ |
char |
Do not check contract time | |||
CON_ |
decimal |
Contract time | |||
COST_ |
varchar2 |
Cost centre code | |||
COUNTRY |
varchar2 |
Country | |||
DATE_ |
datetime |
Date of birth | |||
DATE_ |
datetime |
Start of employment date | |||
DATE_ |
datetime |
End of employment date | |||
DEAR |
varchar2 |
Salutation | |||
DFLT_ |
varchar2 |
Default hour type amounts | |||
DFLT_ |
varchar2 |
Default hour type quantities | |||
DFLT_ |
varchar2 |
Default hour type hours | |||
DPT_ |
varchar2 |
Department | |||
EMP_ |
varchar2 |
Employee group | |||
EMP_ |
decimal |
Employee revenue | |||
EMP_NR |
varchar2 |
Employee code | |||
EMP_ |
decimal |
Calculated internal hourly rate | |||
EMP_ |
decimal |
Total profit per year | |||
EMP_ |
decimal |
Calculated external hourly rate | |||
EMP_ |
decimal |
Gender | |||
EXT_ |
varchar2 |
External description | |||
FAX_ |
varchar2 |
Business fax | |||
FAX_ |
varchar2 |
Private fax | |||
FST_ |
varchar2 |
Initials | |||
FST_ |
varchar2 |
Primer Nombre | |||
GRP_ |
varchar2 |
Report group code | |||
HR_ |
decimal |
Non-productive hours | |||
HR_ |
decimal |
Productive hours | |||
IMG_ |
varchar2 |
Image | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
IS_ |
char |
IFA employee | |||
LVE_ |
decimal |
Leave budget | |||
LVE_ |
decimal |
Leave balance | |||
MAIL_ |
varchar2 |
Business email | |||
MAIL_ |
varchar2 |
Private email | |||
OWN_ |
varchar2 |
Hours display | |||
OWN_ |
varchar2 |
Claim proposal display | |||
OWN_OI |
varchar2 |
Invoice display | |||
OWN_ |
varchar2 |
Project display | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PCT_ |
decimal |
Overhead surcharge percentage | |||
PCT_ |
decimal |
Billing target | |||
PCT_ |
decimal |
Profit surcharge percentage | |||
PO_BOX |
varchar2 |
Postal address | |||
PO_ |
varchar2 |
Postal address city | |||
PO_ |
varchar2 |
Postal address postcode | |||
POSITION |
varchar2 |
Job title | |||
POST_ |
varchar2 |
Postcode | |||
REC_ |
char |
Blocked | |||
SAL_ |
decimal |
Annual salary | |||
ST_ |
varchar2 |
Address addition | |||
ST_NR |
varchar2 |
House number | |||
ST_ |
varchar2 |
Address region | |||
ST_ |
varchar2 |
Nombre de la Calle | |||
TEL_ |
varchar2 |
Business telephone | |||
TEL_ |
varchar2 |
Mobile telephone | |||
TEL_ |
varchar2 |
Private telephone | |||
TIM_ |
decimal |
Standard number of hours per year | |||
TIME_ |
decimal |
Employee hours entry | |||
USR_ID |
varchar2 |
Código de Entrada | |||
WF_ |
char |
All general ledger accounts allowed | |||
WF_ |
int64 |
Maximum approval amount | |||
WHS_ |
varchar2 |
Default warehouse code | |||
WWW_ |
varchar2 |
Website |