HR2APP12 - HR_Applicant | Prospr - Dynamics GP Table Reference

HR2APP12 - HR_Applicant

Query Builder

Select * from HR2APP12

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
APPLICANTNUMBER_I	Applicant Number	Currency	10	View
SSN_I	ISSN	String	16	View
LLASTNAME_I	LLast Name	String	22	View
FFIRSTNAME_I	FFirst Name	String	16	View
MIDLNAME	Middle Name	String	16	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE_I	IZip Code	String	12	View
COUNTRY	Country	String	62	View
HOMEPHONE	Home Phone	String	22	View
WORKPHONE	Work Phone	String	22	View
EXT_I	Ext	String	6	View
ISEQUENCENUMBER_I	ISequence Number	Integer	2	View
APPLYDATE_I	Apply Date	Date	4	View
REQUISITIONNUMBER_I	Requisition Number	Long Integer	4	View
COMPANYCODE_I	Company Code	String	8	View
DIVISIONCODE_I	Division Code	String	8	View
DEPARTMENTCODE_I	Department Code	String	8	View
POSITIONCODE_I	Position Code	String	8	View
LOCATNID	Location ID	String	16	View
STATUS0_I	Status0	Integer	2	View
REJECTREASON_I	Reject Reason	Integer	2	View
DSCRIPTN	Description	String	32	View
RELOCATION_I	Relocation	Integer	2	View
REPLYLETTERSENT_I	Reply Letter Sent	Boolean	2	View
COLORCODE_I	Color Code	Integer	2	View
COLORSTRING_I	Color String	String	8	View
REFSOURCEDDL_I	Ref Source DDL	Integer	2	View
REFERENCESOURCE_I	Reference Source	String	32	View
GENDERGB_I	Gender GB	Integer	2	View
EEOETHNICORIGIN_I	EEO Ethnic Origin	Integer	2	View
EEOAGE_I	EEO Age	Integer	2	View
HANDICAPPED	Handicapped	Boolean	2	View
VETERAN	Veteran	Boolean	2	View
DISABLEDVETERAN	Disabled Veteran	Boolean	2	View
VIETNAMVETERAN	Vietnam Veteran	Boolean	2	View
NOTESINDEX_I	Notes Index	Currency	10	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
OTHERVET	Other Veterans	Boolean	2	View
AFSMVET	Armed Forces Service Medal Veteran	Boolean	2	View
RECSEPVET	Recently-Separated Veteran	Boolean	2	View

HR2APP12 - HR_Applicant

Query Builder

Customer Service

Information

My Account

Contact Us