Module List > Module PAM tables PAM50900
You are currently viewing the COMPANY database.
Change

COMPANY..PAM50900 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
AWARDID char
''

Award_Description char
''

Annual_Leave_CB tinyint
0

Sick_Leave_CB tinyint
0

Rounding_Applies_CB tinyint
0

SHRM smallint
0

SHRP smallint
0

OHRM smallint
0

OHRP smallint
0

Weekly_Basis_Days smallint
0

Weekly_Normal_End_Time datetime
'1/1/1900'

Weekly_Normal_Start_Time datetime
'1/1/1900'

Weekly_Daily_Min numeric
0.00

Weekly_Overtime_First numeric
0.00

WOFirst_Rate numeric
0.00

Weekly_Overtime_Hours numeric
0.00

WO_Next_Rate numeric
0.00

Daily_Overtime_Above numeric
0.00

DO_First_Rate numeric
0.00

Daily_Overtime_Hours numeric
0.00

DO_Next_Rate numeric
0.00

DO_Outside_Rate numeric
0.00

Saturday_End_Time datetime
'1/1/1900'

Saturday_Start_Time datetime
'1/1/1900'

Saturday_Daily_Min numeric
0.00

Saturday_Normal_Rate numeric
0.00

Saturday_Outside_Rate numeric
0.00

Saturday_Overtime_Hours1 numeric
0.00

Saturday_Overtime_Hours2 numeric
0.00

Saturday_Overtime_Rate_1 numeric
0.00

Saturday_Overtime_Rate_2 numeric
0.00

Sunday_End_Time datetime
'1/1/1900'

Sunday_Start_Time datetime
'1/1/1900'

Sunday_Daily_Min numeric
0.00

Sunday_Normal_Rate numeric
0.00

Sunday_Outside_Rate numeric
0.00

Sunday_Overtime_Hours_1 numeric
0.00

Sunday_Overtime_Hours_2 numeric
0.00

Sunday_Overtime_Rate_1 numeric
0.00

Sunday_Overtime_Rate_2 numeric
0.00

Holiday_Normal_Rate numeric
0.00

Holidays_Daily_Min numeric
0.00

Holidays_End_Time datetime
'1/1/1900'

Holidays_OT_Hours_1 numeric
0.00

Holidays_OT_Hours_2 numeric
0.00

Holidays_OTRate_1 numeric
0.00

Holidays_OT_Rate_2 numeric
0.00

Holidays_Outside_Rate numeric
0.00

Holidays_Start_Time datetime
'1/1/1900'

Afternoon_Start_Time datetime
'1/1/1900'

Afternoon_End_Time datetime
'1/1/1900'

Afternoon_multiple numeric
0.00

Night_Start_Time datetime
'1/1/1900'

Night_End_Time datetime
'1/1/1900'

Night_multiple numeric
0.00

Morning_Start_Time datetime
'1/1/1900'

Morning_End_Time datetime
'1/1/1900'

Morning_multiple numeric
0.00

Productivity_allowance numeric
0.00

Dirt_Allowance numeric
0.00

Heat_Allowance numeric
0.00

Meal_Time datetime
'1/1/1900'

Meal_Amount_1 numeric
0.00

Meal_Amount_2 numeric
0.00

Meal_Hours_1 numeric
0.00

Meal_Hours_2 numeric
0.00

Meal_time_allowance numeric
0.00

WD_OTD_OPC char
''

WD_OTD_PC1 char
''

WD_OTD_PC2 char
''

WD_OTW_PC1 char
''

WD_OTW_PC2 char
''

SAA_PC char
''

SAN_PC char
''

SAT_N_PC char
''

SAT_OTD_OPC char
''

SAT_OTD_PC1 char
''

SAT_OTD_PC2 char
''

SAM_PC char
''

SUN_N_PC char
''

SUN_OTD_OPC char
''

SUN_OTD_PC1 char
''

SUN_OTD_PC2 char
''

PH_N_PC char
''

PH_OTD_OPC char
''

PH_OTD_PC1 char
''

PH_OTD_PC2 char
''

MA_PC1 char
''

MA_PC2 char
''

MA_PCS char
''

PA_PC char
''

DA_PC char
''

HA_PC char
''

SatSun_Applies tinyint
0

Public_Hols_Apply tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3