Module List > Module HR tables BEA11031
You are currently viewing the COMPANY database.
Change

COMPANY..BEA11031 Table Definition

(COMPANY..Archive_BEN2_FMLA_Master)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPID_I char(15)
''
Employee I...(more) Join Now TATX1030.EMPID_I
INDEX1 smallint
0
Index Key ...(more) Join Now POP40100.INDEX1
CALENDARSTART_I datetime
'1/1/1900'

ABSENCESTARTDATE_I datetime
'1/1/1900'

ABSENCEENDDATE_I datetime
'1/1/1900'

BNFBEGDT datetime
'1/1/1900'
Benefit Be...(more) Join Now UPR00600.BNFBEGDT
BNFENDDT datetime
'1/1/1900'
Benefit En...(more) Join Now UPR00600.BNFENDDT
ESTRETURNDATE_I datetime
'1/1/1900'

PHYPROVNOTIFIED_I datetime
'1/1/1900'

LEAVEAPPROVAL_I tinyint
0

BENEFITEXPIRE_I datetime
'1/1/1900'
*Benefit E...(more) Join Now UPR00100.BENEFITEXPIRE_I
IBENEFITFREQUENCY_I smallint
0

IBENEFITAMOUNT_I numeric(19,5)
0.00

IBENEFITYEARMAX_I numeric(19,5)
0.00

CHECK1_I tinyint
0

HOURSWORKEDPERDAY_I numeric(19,5)
0.00

TYPEOFDAY_I smallint
0

CHECK2_I tinyint
0

IDATE_I datetime
'1/1/1900'

OLDCALENDARSTARTFMLA datetime
'1/1/1900'

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
COMMENTS_I text


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