Module List >
Module HRM tables
APR_APR70530
You are currently viewing the COMPANY
database.
Change
|
COMPANY..APR_APR70530 Table Definition
(COMPANY..APR Department Ben Accrual TEMP)
Field Definitions:
What is the 'source' column?
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| CHEKNMBR |
char(21)
''
|
|
|
|
|
| DEPRTMNT |
char(7)
''
|
Department...(more) Join Now
|
TATX1030.DEPRTMNT
|
|
join ... more text available
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| BENADJDATE |
datetime
'1/1/1900'
|
|
|
|
|
| VACTMACC |
numeric(19,5)
0
|
|
|
|
|
| SKTMACCR |
numeric(19,5)
0
|
|
|
|
|
| APR_VacationTimeTaken |
numeric(19,5)
0
|
|
|
|
|
| APR_SickTimeTaken |
numeric(19,5)
0
|
|
|
|
|
| APR_VacTimeAccrueYTD |
numeric(19,5)
0
|
|
|
|
|
| APR_VacationTimeTakenYTD |
numeric(19,5)
0
|
|
|
|
|
| APR_SickTimeAccruedYTD |
numeric(19,5)
0
|
|
|
|
|
| APR_SickTimeTakenYTD |
numeric(19,5)
0
|
|
|
|
|
| VACAVLBL |
int
0
|
|
|
|
|
| SIKTIMAV |
int
0
|
|
|
|
|
| ID_Vacation_Hours_Pendin |
numeric(19,5)
0
|
|
|
|
|
| ID_Sick_Hours_Pending |
numeric(19,5)
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|