UPR00100 - Payroll Master | Prospr - Dynamics GP Table Reference

UPR00100 - Payroll Master

Query Builder

Select * from UPR00100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
EMPLCLAS	Employee Class	String	16	View
INACTIVE	Inactive	Boolean	2	View
LASTNAME	Last Name	String	22	View
FRSTNAME	First Name	String	16	View
MIDLNAME	Middle Name	String	16	View
ADRSCODE	Address Code	String	16	View
SOCSCNUM	Social Security Number	String	16	View
BRTHDATE	Birth Date	Date	4	View
GENDER	Gender 1 is male 2 is female 3 is N/A.	Integer	2	View
ETHNORGN	Ethnic Origin 1. White 2. American Indian or Alaskan Native 3. Black or African American 4. Asian 5. Hispanic or Latino 6. Two or more races 7. N/A 8. Native Hawaiian or Pacific Islander	Integer	2	View
Calc_Min_Wage_Bal	Calc Min Wage Bal	Boolean	2	View
DIVISIONCODE_I	Division Code	String	8	View
DEPRTMNT	Department	String	8	View
JOBTITLE	Job Title	String	8	View
SUPERVISORCODE_I	Supervisor Code	String	8	View
LOCATNID	Location ID	String	16	View
WCACFPAY	Which Cash Account For Pay	Integer	2	View
ACTINDX	Account Index	Long Integer	4	View
WKHRPRYR	Work Hours Per Year	Integer	2	View
STRTDATE	Start Date	Date	4	View
DEMPINAC	Date Employee Inactivated	Date	4	View
RSNEMPIN	Reason Employee Inactivated	String	32	View
MINETPAY	Minimum Net Pay	Currency	10	View
SUTASTAT	Suta State	String	4	View
WRKRCOMP	Workers Comp	String	8	View
ATACRVAC	Auto Accrue Vacation	Boolean	2	View
VACCRAMT	Vacation Accrual Amount	Long Integer	4	View
VACCRMTH	Vacation Accrual Method	Integer	2	View
VACAPRYR	Vacation Hours Per Year	Long Integer	4	View
VACAVLBL	Vacation Available	Long Integer	4	View
WRNVCNFLSBLWZR	Warn Vacation Falls Below Zero	Boolean	2	View
ATACRSTM	Auto Accrue Sick Time	Boolean	2	View
STMACMTH	Sick Time Accrual Method 0 is by Hours Worked 1 is by Amount.	Integer	2	View
SKTMACAM	Sick Time Accrual Amount	Long Integer	4	View
SIKTIMAV	Sick Time Available	Long Integer	4	View
SKTMHPYR	Sick Time Hours Per Year	Long Integer	4	View
WRNSTFLSBLWZR	Warn Sick Time Falls Below Zero	Boolean	2	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	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
MARITALSTATUS	MaritalStatus 1. Married 2. Single 3. N/A	Integer	2	View
BENADJDATE	Ben Adj Date	Date	4	View
LASTDAYWORKED_I	Last Day Worked	Date	4	View
BIRTHDAY	Birth Day	Integer	2	View
BIRTHMONTH	Birth Month	Integer	2	View
SPOUSE	Spouse	String	16	View
SPOUSESSN	Spouse SSN	String	16	View
NICKNAME	NickName	String	22	View
ALTERNATENAME	Alternate Name	String	22	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
DATEOFLASTREVIEW_I	Date Of Last Review	Date	4	View
DATEOFNEXTREVIEW_I	Date Of Next Review	Date	4	View
BENEFITEXPIRE_I	Benefit Expire	Date	4	View
HANDICAPPED	Handicapped	Boolean	2	View
VETERAN	Veteran	Boolean	2	View
VIETNAMVETERAN	Vietnam Veteran	Boolean	2	View
DISABLEDVETERAN	Disabled Veteran	Boolean	2	View
UNIONEMPLOYEE	Union Employee	Boolean	2	View
SMOKER_I	Smoker	Boolean	2	View
CITIZEN	Citizen	Boolean	2	View
VERIFIED	Verified	Boolean	2	View
I9RENEW	I9renew	Date	4	View
Primary_Pay_Record	Primary Pay Record	String	8	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
NOTEINDX	Note Index	Currency	10	View
NOTEINDX2	Note Index2	Currency	10	View
UNIONCD	Union Code	String	8	View
RATECLSS	Rate Class	String	16	View
FEDCLSSCD	Federal Classification Code	String	12	View
OTHERVET	Other Veterans	Boolean	2	View
Military_Discharge_Date	Military Discharge Date	Date	4	View
EMPLSUFF	Employee Suffix	String	6	View
STATUSCD	Status Code	String	16	View
Workflow_Approval_Status	Workflow Approval Status 1 – Not Submitted 2 – Submitted 3 – No Approval Needed 4 – Pending Approval 5 – Pending Changes 6 – Approved 7 – Rejected 8 – Workflow Ended 9 – Workflow Not Activated 10 – Workflow Deactivated	Integer	2	View
Workflow_Priority	Workflow Priority	Integer	2	View
AFSMVET	Armed Forces Service Medal Veteran	Boolean	2	View
RECSEPVET	Recently-Separated Veteran	Boolean	2	View

UPR00100 - Payroll Master

Query Builder

Customer Service

Information

My Account

Contact Us