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 TypeLength
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
2EMPLCLAS SearchEmployee ClassSTR15_Employee_ClassString15
3INACTIVE SearchInactiveCB_InactiveBoolean0
4LASTNAME SearchLast NameSTR20String20
5FRSTNAME SearchFirst NameSTR15String15
6MIDLNAME SearchMiddle NameSTR15String15
7ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
8SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString15
9BRTHDATE SearchBirth DateDTDate8
10GENDER SearchGenderDDL_GenderInteger0
11ETHNORGN SearchEthnic OriginDDL_Ethnic OriginInteger0
12Calc_Min_Wage_Bal SearchCalc Min Wage BalCB_CalcMinWageBalBoolean0
13DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString6
14DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString6
15JOBTITLE SearchJob TitleSTR6_Payroll_CodeString6
16SUPERVISORCODE_I SearchSupervisor CodeSTR6_UString6
17LOCATNID SearchLocation IDSTR15_Location_IDString15
18WCACFPAY SearchWhich Cash Account For PayGBInteger0
19ACTINDX SearchAccount IndexLI_14Long Integer14
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_U0Integer4
21STRTDATE SearchStart DateDTDate8
22DEMPINAC SearchDate Employee InactivatedDTDate8
23RSNEMPIN SearchReason Employee InactivatedSTR30String30
24MINETPAY SearchMinimum Net PayDLR11_$U2Currency14
25SUTASTAT SearchSuta StateSTR2_State_CodeString2
26WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString6
27ATACRVAC SearchAuto Accrue VacationCB_Accrue_Vacation:Boolean0
28VACCRAMT SearchVacation Accrual AmountLI6_U2Long Integer6
29VACCRMTH SearchVacation Accrual MethodGBInteger0
30VACAPRYR SearchVacation Hours Per YearLI6_U2Long Integer6
31VACAVLBL SearchVacation AvailableLI6_S2Long Integer6
32WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroCB_WarnVacationFallsBelowZeroBoolean0
33ATACRSTM SearchAuto Accrue Sick TimeCB_Accrue_Sick_Time:Boolean0
34STMACMTH SearchSick Time Accrual MethodGBInteger0
35SKTMACAM SearchSick Time Accrual AmountLI6_U2Long Integer6
36SIKTIMAV SearchSick Time AvailableLI6_S2Long Integer6
37SKTMHPYR SearchSick Time Hours Per YearLI6_U2Long Integer6
38WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroCB_WarnSickTimeFallsBelowZeroBoolean0
39USERDEF1 SearchUser Defined 1STR20String20
40USERDEF2 SearchUser Defined 2STR20String20
41EMPLOYMENTTYPE SearchType of EmploymentDDL_Employment_TypeInteger0
42MARITALSTATUS SearchMaritalStatusDDL_MaritalStatusInteger0
43BENADJDATE SearchBen Adj DateDTDate8
44LASTDAYWORKED_I SearchLast Day WorkedDTDate8
45BIRTHDAY SearchBirth DayINTInteger0
46BIRTHMONTH SearchBirth MonthINTInteger0
47SPOUSE SearchSpouseSTR15String15
48SPOUSESSN SearchSpouse SSNSTR15_Social_Security_NumberString15
49NICKNAME SearchNickNameSTR20String20
50ALTERNATENAME SearchAlternate NameSTR20String20
51HRSTATUS SearchHR StatusDDL_HRStatusInteger0
52DATEOFLASTREVIEW_I SearchDate Of Last ReviewDTDate8
53DATEOFNEXTREVIEW_I SearchDate Of Next ReviewDTDate8
54BENEFITEXPIRE_I SearchBenefit ExpireDTDate8
55HANDICAPPED SearchHandicappedCB_HandicapBoolean0
56VETERAN SearchVeteranCB_MilitaryBoolean0
57VIETNAMVETERAN SearchVietnam VeteranCB_VietnamBoolean0
58DISABLEDVETERAN SearchDisabled VeteranCB_DisableVetBoolean0
59UNIONEMPLOYEE SearchUnion EmployeeCB_Union_EmpBoolean0
60SMOKER_I SearchSmokerCB_SmokerBoolean0
61CITIZEN SearchCitizenCB_CitizenBoolean0
62VERIFIED SearchVerifiedCB_VerifedBoolean0
63I9RENEW SearchI9renewDTDate8
64Primary_Pay_Record SearchPrimary Pay RecordSTR6_Payroll_CodeString6
65CHANGEBY_I SearchChange BySTR15_User_IDString15
66CHANGEDATE_I SearchChange DateDTDate8
67NOTEINDX SearchNote IndexDLR14Currency14
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 Index2DLR14Currency14
69UNIONCD SearchUnion CodeSTR6String6
70RATECLSS SearchRate ClassSTR15String15
71FEDCLSSCD SearchFederal Classification CodeSTR10_LBAUString10
72OTHERVET SearchOther VeteransCB_OtherVetBoolean0
73Military_Discharge_Date SearchMilitary Discharge DateDTDate8
74EMPLSUFF SearchEmployee SuffixSTR4_Employee_SuffixString4
75STATUSCD SearchStatus CodeSTR15_LBUString15
76Workflow_Approval_Status SearchWorkflow Approval StatusDDL_WorkflowApprovalStatusInteger0
77Workflow_Priority SearchWorkflow PriorityDDL_WorkflowPriorityInteger0
78Workflow_Status SearchWorkflow StatusWorkflow StatusInteger0
79AFSMVET SearchArmed Forces Service Medal VeteranCB_Armed_ForcesBoolean0
80RECSEPVET SearchRecently-Separated VeteranCB_Recently_Sep_VetBoolean0
81USERID SearchUser IDSTR15_User_IDString15
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 Searchdatetimedatetime3
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 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.

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

Leave a Reply

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