Payroll Master – HR Alias (UPR00100)

azurecurveProductsHuman Resources (414)PayrollPayroll Master - HR Alias (UPR00100)

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

Product: Human Resources (414)
Series: Payroll

Display Name: Payroll Master - HR Alias
Physical Name: UPR00100
Technical Name: HRUPR_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
2EMPLCLAS SearchEmployee ClassSTR15_Employee_ClassString1615
3INACTIVE SearchInactiveCB_InactiveBoolean20
4LASTNAME SearchLast NameSTR20String2220
5FRSTNAME SearchFirst NameSTR15String1615
6MIDLNAME SearchMiddle NameSTR15String1615
7ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
8SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString1615
9BRTHDATE SearchBirth DateDTDate48
10GENDER SearchGenderDDL_GenderInteger20
11ETHNORGN SearchEthnic OriginDDL_Ethnic OriginInteger20
12Calc_Min_Wage_Bal SearchCalc Min Wage BalCB_CalcMinWageBalBoolean20
13DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString86
14DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
15JOBTITLE SearchJob TitleSTR6_Payroll_CodeString86
16SUPERVISORCODE_I SearchSupervisor CodeSTR6_UString86
17LOCATNID SearchLocation IDSTR15_Location_IDString1615
18WCACFPAY SearchWhich Cash Account For PayGBInteger20
19ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Payroll Master - HR Alias'].ACTINDX AS 'Payroll Master - HR Alias-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       UPR00100 AS ['Payroll Master - HR Alias']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Payroll Master - HR Alias'].ACTINDX = ['Account Index Master'].ACTINDX
20WKHRPRYR SearchWork Hours Per YearINT4_U0Integer24
21STRTDATE SearchStart DateDTDate48
22DEMPINAC SearchDate Employee InactivatedDTDate48
23RSNEMPIN SearchReason Employee InactivatedSTR30String3230
24MINETPAY SearchMinimum Net PayDLR11_$U2Currency1014
25SUTASTAT SearchSuta StateSTR2_State_CodeString42
26WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString86
27ATACRVAC SearchAuto Accrue VacationCB_Accrue_Vacation:Boolean20
28VACCRAMT SearchVacation Accrual AmountLI6_U2Long Integer46
29VACCRMTH SearchVacation Accrual MethodGBInteger20
30VACAPRYR SearchVacation Hours Per YearLI6_U2Long Integer46
31VACAVLBL SearchVacation AvailableLI6_S2Long Integer46
32WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroCB_WarnVacationFallsBelowZeroBoolean20
33ATACRSTM SearchAuto Accrue Sick TimeCB_Accrue_Sick_Time:Boolean20
34STMACMTH SearchSick Time Accrual MethodGBInteger20
35SKTMACAM SearchSick Time Accrual AmountLI6_U2Long Integer46
36SIKTIMAV SearchSick Time AvailableLI6_S2Long Integer46
37SKTMHPYR SearchSick Time Hours Per YearLI6_U2Long Integer46
38WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroCB_WarnSickTimeFallsBelowZeroBoolean20
39USERDEF1 SearchUser Defined 1STR20String2220
40USERDEF2 SearchUser Defined 2STR20String2220
41EMPLOYMENTTYPE SearchType of EmploymentDDL_Employment_TypeInteger20
42MARITALSTATUS SearchMaritalStatusDDL_MaritalStatusInteger20
43BENADJDATE SearchBen Adj DateDTDate48
44LASTDAYWORKED_I SearchLast Day WorkedDTDate48
45BIRTHDAY SearchBirth DayINTInteger20
46BIRTHMONTH SearchBirth MonthINTInteger20
47SPOUSE SearchSpouseSTR15String1615
48SPOUSESSN SearchSpouse SSNSTR15_Social_Security_NumberString1615
49NICKNAME SearchNickNameSTR20String2220
50ALTERNATENAME SearchAlternate NameSTR20String2220
51HRSTATUS SearchHR StatusDDL_HRStatusInteger20
52DATEOFLASTREVIEW_I SearchDate Of Last ReviewDTDate48
53DATEOFNEXTREVIEW_I SearchDate Of Next ReviewDTDate48
54BENEFITEXPIRE_I SearchBenefit ExpireDTDate48
55HANDICAPPED SearchHandicappedCB_HandicapBoolean20
56VETERAN SearchVeteranCB_MilitaryBoolean20
57VIETNAMVETERAN SearchVietnam VeteranCB_VietnamBoolean20
58DISABLEDVETERAN SearchDisabled VeteranCB_DisableVetBoolean20
59UNIONEMPLOYEE SearchUnion EmployeeCB_Union_EmpBoolean20
60SMOKER_I SearchSmokerCB_SmokerBoolean20
61CITIZEN SearchCitizenCB_CitizenBoolean20
62VERIFIED SearchVerifiedCB_VerifedBoolean20
63I9RENEW SearchI9renewDTDate48
64Primary_Pay_Record SearchPrimary Pay RecordSTR6_Payroll_CodeString86
65CHANGEBY_I SearchChange BySTR15_User_IDString1615
66CHANGEDATE_I SearchChange DateDTDate48
67NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Payroll Master - HR Alias'].NOTEINDX AS 'Payroll Master - HR Alias-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       UPR00100 AS ['Payroll Master - HR Alias']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Master - HR Alias'].NOTEINDX = ['Record Notes Master'].NOTEINDX
68NOTEINDX2 SearchNote Index2DLR14Currency1014
69UNIONCD SearchUnion CodeSTR6String86
70RATECLSS SearchRate ClassSTR15String1615
71FEDCLSSCD SearchFederal Classification CodeSTR10_LBAUString1210
72OTHERVET SearchOther VeteransCB_OtherVetBoolean20
73Military_Discharge_Date SearchMilitary Discharge DateDTDate48
74EMPLSUFF SearchEmployee SuffixSTR4_Employee_SuffixString64
75STATUSCD SearchStatus CodeSTR15_LBUString1615
76Workflow_Approval_Status SearchWorkflow Approval StatusDDL_WorkflowApprovalStatusInteger20
77Workflow_Priority SearchWorkflow PriorityDDL_WorkflowPriorityInteger20
78Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
79AFSMVET SearchArmed Forces Service Medal VeteranCB_Armed_ForcesBoolean20
80RECSEPVET SearchRecently-Separated VeteranCB_Recently_Sep_VetBoolean20
81USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payroll Master - HR Alias'].USERID AS 'Payroll Master - HR Alias-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       UPR00100 AS ['Payroll Master - HR Alias']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payroll Master - HR Alias'].USERID = ['Users Master'].USERID
82DEX_ROW_TS Searchdatetimedatetime33
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
83DEX_ROW_ID Searchintint1010

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.

azurecurveProductsHuman Resources (414)PayrollPayroll Master - HR Alias (UPR00100)

Leave a Reply

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