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

COMPANY..AHROR012 Table Definition

(COMPANY..Archive_HR_I9)

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
MAIDENNAME_I char(21)
''

I9ALIENUNTILCB_I tinyint
0

I9CITIZENCB_I tinyint
0

I9LPRESIDENT_I tinyint
0

ISTARTDATE_I datetime
'1/1/1900'

DOCUMENT#A1_I char(31)
''

DOCUMENT#A2_I char(31)
''

DOCUMENT#B_I char(31)
''

DOCUMENT#C_I char(31)
''

DOCUMENTTITLEA_I char(31)
''

DOCUMENTTITLEB_I char(31)
''

DOCUMENTTITLEC_I char(31)
''

EXPIRATIONA1_I datetime
'1/1/1900'

EXPIRATIONA2_I datetime
'1/1/1900'

EXPIRATIONB_I datetime
'1/1/1900'

EXPIRATIONC_I datetime
'1/1/1900'

ISSUEAUTHORITYA_I char(31)
''

ISSUEAUTHORITYB_I char(31)
''

ISSUEAUTHORITYC_I char(31)
''

ALIENADMINNUMBER_I char(21)
''

ALIENNUMBER_I char(21)
''

ALIENUNTILDATE_I datetime
'1/1/1900'

DATEFILED_I datetime
'1/1/1900'

PREPARERSNAME_I char(61)
''

PREPARERADDRESS_I char(255)
''

DATEIN_I datetime
'1/1/1900'

EMPLOYERNAME_I char(31)
''

TITLE1_I char(21)
''

TITLE2_I char(21)
''

BUSNAMEADDR_I char(81)
''

NEWNAME_I char(51)
''

REHIREDATE_I datetime
'1/1/1900'

O3CDATEEXPIRE_I datetime
'1/1/1900'

O3CDOCU#_I char(21)
''

O3CDOCUTITLE_I char(21)
''

DATESIGNED_I datetime
'1/1/1900'

DATEOFLASTCHANGE_I datetime
'1/1/1900'

EXITDATE datetime
'1/1/1900'

REENTRYDATE datetime
'1/1/1900'

i9_Non_Citizen_CB tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
CCodeDesc char
''

FOREIGNPASSNUMBER char
''

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