LVE: AccountView Leave requests
read only per partition
- Catálogo:
AccountView - Label: Leave requests
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla LVE. 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 |
|---|---|---|---|---|---|
APP_ |
varchar2 |
Reviewer employee code | |||
APP_ |
varchar2 |
Reviewer note | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
datetime |
Assessment | |||
CNG_ |
varchar2 |
Employee last modified | |||
EMP_NR |
varchar2 |
Employee code | |||
FIRST_ |
datetime |
First day of leave | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
LAST_ |
datetime |
Last day of leave | |||
LVE_ |
varchar2 |
Short description | |||
LVE_ |
varchar2 |
Leave number | |||
LVE_ |
int32 |
Status | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
TOT_ |
decimal |
From budget (days) | |||
USR_ |
varchar2 |
Reason for leave |