ESS Profile Personal (UPR30601)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: ESS Profile Personal
Physical Name: UPR30601
Technical Name: uprESSProfilePersonal

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
2FRSTNAME SearchFirst NameSTR15String15
3MIDLNAME SearchMiddle NameSTR15String15
4LASTNAME SearchLast NameSTR20String20
5EMPLSUFF SearchEmployee SuffixSTR4_Employee_SuffixString4
6NICKNAME SearchNickNameSTR20String20
7SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString15
8STRTDATE SearchStart DateDTDate8
9BRTHDATE SearchBirth DateDTDate8
10GENDER SearchGenderDDL_GenderInteger0
11ETHNORGN SearchEthnic OriginDDL_Ethnic OriginInteger0
12MARITALSTATUS SearchMaritalStatusDDL_MaritalStatusInteger0
13SPOUSE SearchSpouseSTR15String15
14PHONE1 SearchPhone 1Phone_NumberString14
15PHONE2 SearchPhone 2Phone_NumberString14
16PHONE3 SearchPhone 3Phone_Number3String14
17FAX SearchFaxSTR14_FAXString14
18INET1 SearchINet1STR200String200
19Messenger_Address SearchMessenger AddressSTR200String200
20ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
21ADDRESS1 SearchAddress 1STR60String60
22ADDRESS2 SearchAddress 2STR60String60
23ADDRESS3 SearchAddress 3STR60String60
24CITY SearchCitySTR35String35
25STATE SearchStateSTR30_StateString29
26ZIPCODE SearchZip CodeSTR10String10
27COUNTY SearchCountySTR60String60
28COUNTRY SearchCountrySTR60String60
29EmailToAddress SearchEmail To AddressTX32000Text32000
30DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *