Module List > Module TM tables SchedSum
You are currently viewing the COMPANY database.
Change

COMPANY..SchedSum Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char
''
Employee I...(more) Join Now PA11801.EMPLOYID
join ... more text available
LASTNAME char
''
Last Name:...(more) Join Now WC010300.LASTNAME
FRSTNAME char
''

DEPRTMNT char
''
Department...(more) Join Now WC010931.DEPRTMNT
join ... more text available
POSITIONCODE_I char
''

PAYCODE char
''

TB_Schedule_Code char
''

TB_Schedule_DateStart datetime
'1/1/1900'

TB_Schedule_CodeMonday_1 char
''

TB_Schedule_TimeMonday_1 numeric
0.00

TB_Actual_TimeMonday_1st numeric
0.00

TB_Schedule_CodeTuesday1 char
''

TB_Schedule_TimeTues1 numeric
0.00

TB_Actual_TimeTuesday_1s numeric
0.00

TB_Schedule_CodeWednes1 char
''

TB_Schedule_TimeWed1 numeric
0.00

TB_Actual_TimeWed1 numeric
0.00

TB_Schedule_CodeThurs1 char
''

TB_Schedule_TimeThur1 numeric
0.00

TB_Actual_TimeThursday_1 numeric
0.00

TB_Schedule_CodeFriday_1 char
''

TB_Schedule_TimeFriday1 numeric
0.00

TB_Actual_TimeFriday_1st numeric
0.00

TB_Schedule_CodeSat1 char
''

TB_Schedule_TimeSat1 numeric
0.00

TB_Actual_TimeSaturday_1 numeric
0.00

TB_Schedule_CodeSunday_1 char
''

TB_Schedule_TimeSund1 numeric
0.00

TB_Actual_TimeSunday_1st numeric
0.00

TB_Schedule_CodeMonday_2 char
''

TB_Schedule_TimeMonday_2 numeric
0.00

TB_Actual_TimeMonday_2nd numeric
0.00

TB_Schedule_CodeTuesday2 char
''

TB_Schedule_TimeTues2 numeric
0.00

TB_Actual_TimeTuesday_2n numeric
0.00

TB_Schedule_CodeWednes2 char
''

TB_Schedule_TimeWed2 numeric
0.00

TB_Actual_TimeWed2 numeric
0.00

TB_Schedule_CodeThurs2 char
''

TB_Schedule_TimeThurs2 numeric
0.00

TB_Actual_TimeThurs2 numeric
0.00

TB_Schedule_CodeFriday_2 char
''

TB_Schedule_TimeFriday2 numeric
0.00

TB_Actual_TimeFriday_2nd numeric
0.00

TB_Schedule_CodeSat2 char
''

TB_Schedule_TimeSat2 numeric
0.00

TB_Actual_TimeSaturday_2 numeric
0.00

TB_Schedule_CodeSunday_2 char
''

TB_Schedule_TimeSun2 numeric
0.00

TB_Actual_TimeSunday_2nd numeric
0.00

TB_Schedule_TimeTotal numeric
0.00

TB_Actual_TimeTotal numeric
0.00

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