UPR_EmployeeList_View (UPR50000)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR50000

Display Name: UPR_EmployeeList_View
Physical Name: UPR50000
Technical Name: UPR_EmployeeList_View

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
2	LASTNAME	Last Name	String	STR20	20
3	FRSTNAME	First Name	String	STR15	15
4	DEPRTMNT	Department	String	STR6_Payroll_Code	6
5	INACTIVE	Inactive	Boolean	CB_Inactive	0
6	EMPLCLAS	Employee Class	String	STR15_Employee_Class	15
7	SUPERVISORCODE_I	Supervisor Code	String	STR6_U	6
8	ADDRESS1	Address 1	String	STR60	60
9	CITY	City	String	STR35	35
10	STATE	State	String	STR30_State	29
11	ZIPCODE	Zip Code	String	STR10	10
12	PHONE1	Phone 1	String	Phone_Number	14
13	DIVISIONCODE_I	Division Code	String	STR6_Payroll_Code	6
14	Workflow_Approval_Status	Workflow Approval Status	Integer	DDL_WorkflowApprovalStatus	0
15	Workflow_Priority	Workflow Priority	Integer	DDL_WorkflowPriority	0
16	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['UPR_EmployeeList_View'].USERID AS 'UPR_EmployeeList_View-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM UPR50000 AS ['UPR_EmployeeList_View'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['UPR_EmployeeList_View'].USERID = ['Users Master'].USERID