HRORI012 - HR_I9 | Prospr - Dynamics GP Table Reference

HRORI012 - HR_I9

Query Builder

Select * from HRORI012

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPID_I	Emp ID	String	16	View
MAIDENNAME_I	Maiden Name	String	22	View
I9ALIENUNTILCB_I	i9 Alien until CB	Boolean	2	View
I9CITIZENCB_I	i9 Citizen CB	Boolean	2	View
I9LPRESIDENT_I	i9 LPResident	Boolean	2	View
ISTARTDATE_I	IStart Date	Date	4	View
DOCUMENT#A1_I	Document # A1	String	32	View
DOCUMENT#A2_I	Document #A2	String	32	View
DOCUMENT#B_I	Document #B	String	32	View
DOCUMENT#C_I	Document #C	String	32	View
DOCUMENTTITLEA_I	Document Title A	String	32	View
DOCUMENTTITLEB_I	Document Title B	String	32	View
DOCUMENTTITLEC_I	Document Title C	String	32	View
EXPIRATIONA1_I	Expiration A1	Date	4	View
EXPIRATIONA2_I	Expiration A2	Date	4	View
EXPIRATIONB_I	Expiration B	Date	4	View
EXPIRATIONC_I	Expiration C	Date	4	View
ISSUEAUTHORITYA_I	Issue Authority A	String	32	View
ISSUEAUTHORITYB_I	Issue Authority B	String	32	View
ISSUEAUTHORITYC_I	Issue Authority C	String	32	View
ALIENADMINNUMBER_I	AlienAdmin Number	String	22	View
ALIENNUMBER_I	AlienNumber	String	22	View
ALIENUNTILDATE_I	Alien Until Date	Date	4	View
DATEFILED_I	Date Filed	Date	4	View
PREPARERSNAME_I	Preparers Name	String	62	View
PREPARERADDRESS_I	Preparer Address	String	256	View
DATEIN_I	Date In	Date	4	View
EMPLOYERNAME_I	Employer Name	String	32	View
TITLE1_I	Title1	String	22	View
TITLE2_I	Title2	String	22	View
BUSNAMEADDR_I	Bus Name & Addr	String	82	View
NEWNAME_I	New Name	String	52	View
REHIREDATE_I	Rehire Date	Date	4	View
O3CDATEEXPIRE_I	3c Date Expire	Date	4	View
O3CDOCU#_I	3c Docu#	String	22	View
O3CDOCUTITLE_I	3c DocuTitle	String	22	View
DATESIGNED_I	Date Signed	Date	4	View
DATEOFLASTCHANGE_I	Date OF Last Change	Date	4	View
EXITDATE	Date Of Exit	Date	4	View
REENTRYDATE	Date of Reentry	Date	4	View
i9_Non_Citizen_CB	i9 Non Citizen CB	Boolean	2	View

HRORI012 - HR_I9

Query Builder

Customer Service

Information

My Account

Contact Us