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

COMPANY..BEA40100 Table Definition

(COMPANY..Archive_HR_Benefit_COBRA_MSTR)

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
IC_Instance_Number_I smallint
0

EFFECTIVEDATE_I datetime
'1/1/1900'

LLASTNAME_I char(21)
''

FFIRSTNAME_I char(15)
''

MI_I char(1)
''

ADDRESS1 char(61)
''
Address 1:...(more) Join Now RM00101.ADDRESS1
ADDRESS2 char(61)
''
Address 2:...(more) Join Now RM00101.ADDRESS2
CITY char(35)
''
City: City...(more) Join Now RM00101.CITY
STATE char(29)
''
State: Up...(more) Join Now RM00101.STATE
ZIPCODE_I char(11)
''

HOMEPHONE char(21)
''

DATEOFBIRTH_I datetime
'1/1/1900'

RELATIONSHIP smallint
0
1-spouse, ...(more) Join Now UPR00111.RELATIONSHIP
DEPSSN_I char(15)
''

SSN_I char(15)
''

BENEFITEXPIRE_I datetime
'1/1/1900'
*Benefit E...(more) Join Now UPR00100.BENEFITEXPIRE_I
BNFBEGDT datetime
'1/1/1900'
Benefit Be...(more) Join Now UPR00600.BNFBEGDT
COBRAQE_I smallint
0

COMMENTSTR20 char(21)
''

DSCRIPTN char(31)
''
Descriptio...(more) Join Now CM20300.DSCRIPTN
IC_Initial_Balance_I numeric(19,5)
0.00

COSTCOBRA_I numeric(19,5)
0.00

IC_Months_INT_I smallint
0

IC_Cobra_Month_DDL_I smallint
0

IC_Cobra_Dependent_DDL_I smallint
0

IC_Cobra_Employee_DDL_I smallint
0

IBENEFITFREQUENCY_I smallint
0

IC_First_Payment_Date_I datetime
'1/1/1900'

IC_Last_Payment_Date_I datetime
'1/1/1900'

IC_Auto_Post_CB_I tinyint
0

IC_Next_Auto_Post_Date_I datetime
'1/1/1900'

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