EMPLOYEE: AccountView Employees
read only per partition
- Catalogo:
AccountView - Label: Employees
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella EMPLOYEE. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | 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 |
Nome | |||
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 |
Nome della via | |||
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 |
Nome Utente | |||
WF_ |
char |
All general ledger accounts allowed | |||
WF_ |
int64 |
Maximum approval amount | |||
WHS_ |
varchar2 |
Default warehouse code | |||
WWW_ |
varchar2 |
Website |