AHR2EM02 - Archive_HR_Employee_History | Prospr

AHR2EM02 - Archive_HR_Employee_History

Select * from AHR2EM02

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPID_I	Emp ID	String	16	View
EFFECTIVEDATE_I	Effective Date0	Date	4	View
COMPANY_I	Company	String	66	View
DIVISION_I	Division	String	32	View
DEPARTMENTNAME_I	Department Name	String	32	View
POSITION_I	Position	String	32	View
EMPLOYMENTTYPE	Type of Employment 1. Full Time Regular 2. Full Time Temp 3. Part Time Regular 4. Part Time Temp 5. Intern In SBM, this field is not available. 6. Other	Integer	2	View
HRSTATUS	HR Status 1. Active 2. Family Leave 3. Leave of Absence 4. Maternity 5. Retired 6. Separated 7. Suspended 8. Terminated 9. Other In SBM, this field is not available.	Integer	2	View
SEPARATIONREASON_I	Separation Reason	Integer	2	View
SHFTCODE	Shift Code	String	8	View
RSNEMPIN	Reason Employee Inactivated	String	32	View
SUPERVISOR	Supervisor	String	32	View
LOCATION_I	Location	String	32	View
CHANGEREASON_I	Change Reason	String	32	View
NOTESINDEX_I	Notes Index	Currency	10	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
SEQNUMBR	Sequence Number	Long Integer	4	View