Module List >
Module HRM tables
PTO00100
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PTO00100 Table Definition
(COMPANY..PTO Payroll Master)
Field Definitions:
What is the 'source' column?
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
UPR00100.EMPLOYID
|
|
join ... more text available
|
| ID_Accrual_Code |
char(11)
''
|
|
|
|
|
| ID_Accrual_Code_2 |
char(11)
''
|
|
|
|
|
| ID_Accrual_Code_3 |
char(11)
''
|
|
|
|
|
| ID_Accrual_Code_4 |
char(11)
''
|
|
|
|
|
| ID_LTD_Vac_Hours_Worked |
numeric(19,5)
0
|
|
|
|
|
| ID_LTD_Sick_Hours_Worked |
numeric(19,5)
0
|
|
|
|
|
| ID_Vacation_Time_Accrued |
numeric(19,5)
0
|
|
|
|
|
| ID_Sick_Time_Accrued |
numeric(19,5)
0
|
|
|
|
|
| ID_End_Date |
datetime
'1/1/1900'
|
|
|
|
|
| ID_End_Sick_Date |
datetime
'1/1/1900'
|
|
|
|
|
| ID_Vacation_Hours_Pendin |
numeric(19,5)
0
|
|
|
|
|
| ID_Sick_Hours_Pending |
numeric(19,5)
0
|
|
|
|
|
| ID_Max_Carry_Over_Hours |
numeric(19,5)
0
|
|
|
|
|
| ID_Max_Sick_Carry_Over_H |
numeric(19,5)
0
|
|
|
|
|
| ID_Max_Annual_Hours |
numeric(19,5)
0
|
|
|
|
|
| ID_Annualized_Expiration |
tinyint
0
|
|
|
|
|
| ID_Use_Anniversary_Years |
tinyint
0
|
|
|
|
|
| ID_Annualized_Sick_Expir |
tinyint
0
|
|
|
|
|
| ID_Use_Sick_Anniv_Years |
tinyint
0
|
|
|
|
|
| ID_Max_Vac_Type |
smallint
0
|
|
|
|
|
| ID_Max_Sick_Type |
smallint
0
|
|
|
|
|
| ID_Max_Sick_Hours |
numeric(19,5)
0
|
|
|
|
|
| ID_Max_Code |
char(9)
''
|
|
|
|
|
| ID_Max_Code_2 |
char(9)
''
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| PTO_Code |
char(15)
''
|
|
|
|
|
| INACTIVE |
tinyint
0
|
Inactive: ...(more) Join Now
|
UPR00100.INACTIVE
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|