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

COMPANY..BreakRul Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TB_Break_ID char
''

INACTIVE tinyint
0

EMPLOYID char
''
Employee I...(more) Join Now PA11801.EMPLOYID
join ... more text available
TB_Employee_Report_To char
''

DIVISIONCODE_I char
''

LOCATNID char
''
Location I...(more) Join Now PA01101.LOCATNID
join ... more text available
SUPERVISORCODE_I char
''

POSITIONCODE_I char
''

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

join ... more text available
USERDEF1 char
''
UserDefine...(more) Join Now PM00200.USERDEF1
USERDEF2 char
''
UserDefine...(more) Join Now PM00200.USERDEF2
SHFTCODE char
''
Shift Code...(more) Join Now HR2EMP02.SHFTCODE
TB_Days_of_Week1 smallint
0

TB_Break_Starting_Time datetime
'1/1/1900'

TB_Break_Ending_Time datetime
'1/1/1900'

TB_Break_Hours numeric
0.00

TB_Paid_Break tinyint
0

AA_Job_# char
''

AA_Job_Phase_ID char
''

AA_Job_Step_ID char
''

PayCode char
''

SEQNUMBR int
0
Sequence N...(more) Join Now HR2EMP02.SEQNUMBR
Routing_Seq_Number smallint
0

Routing_Step_ID char
''

Cost_Code_Alias char
''

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