DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our HR scripts. All of our scripts for Dynamics GP can be found here
HR Scripts
General
 Direct Deposit Advice report
Module List > Module COMPANY..HR tables
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change


ClearPixel
Freq
Used		 Display Name
 AE031000Archive_BEN_FMLA_INFO
 BE010130HR_Benefit_MSTR
 BE011031BEN2_FMLA_Master
 BE012032HRP_BEN2_CoPay_Setup
 BE020230HR_Benefit_SETP
 BE021030BEN2_FMLA_Line
 BE031000BEN_FMLA_INFO
 DD010000Down Days
 DD020000Down On Weekends
 DD030000Up_Days
 EU010130HR_User_Defined
 EX010130HR_Employee_Extra
 OR022330HR_Orientation_Setup_LINE_V2
 OR025230HR_Orientation_LINE_V2
 pc00900Position YTD Summary Amounts
 RV010121HR_Review_MSTR_V2
 RV010221HR_Review_LINE_V2
 RV020121HR_Review_Setup_MSTR_V2
 RV020221HR_Review_Setup_LINE_V2
 RV030121HR Review Words Setup MSTR
 RV030221HR Review Words Setup LINE
 SK010230HR_Skills_Line
 SK020130HR Skills Query MSTR
 SK020230HR Skills Query LINE
 SK030130Archive_HR_Skills_Line
 TE022330HR_Termination_Setup_LINE_V2
 TE024230HR_Termination_V2
 TE025230HR_Termination_LINE_V2
 UD020130HR_User_Defined_Report_Setup
 UPR00400_OTPayroll Pay Code OT Master
 UPR00401 
 UPR40600_OTPay Type Setup OT Code
 UPRA0100Archive Payroll Master
 UPRA0102Payroll Address Master - Archive
 UPRA0111Payroll Master Dependent - Archive
 UPRA0112Payroll Master Education - Archive
 UPRA0113Payroll Master Contacts - Archive
Freq
Used		 Display Name
 AEU10130Archive_HR_User_Defined
 AEX10130Archive_HR_Employee_Extra
 ARV10121Archive_HR_Review_MSTR_V2
 ARV10221Archive_HR_Review_LINE_V2
 BEA10130Archive_HR_Benefit_MSTR
 BEA11031Archive_BEN2_FMLA_Master
Freq
Used		 Display Name
 AHR2BE04Archive_HR_Benefit_Checklist
 AHR2BE31Archive_BEN2_COBRA_Lists
 AHR2BE34Archive_BEN2_Total_Compensation
 AHR2DI01Archive_HR_Discipline_V2
 AHR2DI02Archive_HR_Discipline_LINE_V2
 AHR2DI04Archive_DIS_POINTS_MSTR
 AHR2DI05Archive_DIS_POINTS_LINE
 AHR2EM02Archive_HR_Employee_History
 AHR2GR02Archive_HR_Grievance_Line
 AHR2GR03Archive_HR_Grievance
 AHR2IN01Archive_HR_Injury
 AHR2SA01Archive_HR_Salary
 AHR2SA02Archive_HR_Salary_Other
 AHR2SK04Archive_HR_Skills_MSTR
 AHR2TF01Archive_HR_Transfer
 AHR2TR04Archive_HR_Train_Employee
 AHR2UN01Archive_HR_Union
 AR24BE15Archive_HR_Benefit_Fund_Allocation
 AR24BE17Archive_HR_Benefit_Life_Hist
 AR2BEN08Archive_HR_Benefit_History
 AR2BEN10Archive_HR_Benefit_History_2
 AR2BEN22Archive_HR_Benefit_Tiers_MSTR
 AR2BEN39Archive_HR_Benefit_Retire_Hist
 AR2BEN40Archive_HR_Benefit_Tiers_MSTR_Hist
 BEA21030Archive_BEN2_FMLA_Line
 HR24BE15HR_Benefit_Fund_Allocation
 HR24BE17HR_Benefit_Life_Hist
 HR2ADA01HR_ADA_MSTR
 HR2BEN04HR_Benefit_Checklist
 HR2BEN05HR_Benefit_Types
 HR2BEN07HR_Benefit_Entrance_Dates
 HR2BEN08HR_Benefit_History
 HR2BEN10HR_Benefit_History_2
 HR2BEN11HR_Benefit_Fund
 HR2BEN12HR_Benefit_MDVE_Table
 HR2BEN13HR_Benefit_Life_Premiums
 HR2BEN14HR_Benefit_MDVE_Types
 HR2BEN17BEN2_Beneficiary
 HR2BEN21HR_Benefit_Tiers_SETP
 HR2BEN22HR_Benefit_Tiers_MSTR
 HR2BEN31BEN2_COBRA_Lists
 HR2BEN34BEN2_Total_Compensation
 HR2BEN35BEN2_Total_Compensation_Options
 HR2BEN36BEN2_Total_Compensation_Setup
 HR2BEN39HR_Benefit_Retire_Hist
 HR2BEN40HR_Benefit_Tiers_MSTR_Hist
 HR2DIS01HR_Discipline_V2
 HR2DIS02HR_Discipline_LINE_V2
 HR2DIS03HR_Discipline_Suspended_V2
 HR2DIS04DIS_POINTS_MSTR
 HR2DIS05DIS_POINTS_LINE
 HR2DIV02HR_Division2
 HR2EMP02HR_Employee_History
 HR2GRI02HR_Grievance_Line
 HR2GRI03HR_Grievance
 HR2IMP01HR_Import_ErrorLog
 HR2LNK01HR_LinkTemplate
 HR2NJ01HR_Injury
 HR2SAL01HR_Salary
 HR2SAL02HR_Salary_Other
 HR2SKL04HR_Skills_MSTR
 HR2TFR01HR_Transfer
 HR2TRA01HR_Train_Course
 HR2TRA03HR_Train_Class
 HR2TRA04HR_Train_Employee
 HR2TRX01HR_Employee_Export_TRX
 HR2UDE02HR_User_Defined_Form_Setup
 HR2UNI01HR_Union
 ORA25230Archive_HR_Orientation_LINE_V2
 TEA24230Archive_HR_Termination_V2
 TEA25230Archive_HR_Termination_LINE_V2
Work Tables
Freq
Used		 Display Name
 HR30100 
 HR30101 
 HR30102 
 PC30301PC Position Setup History
 PC30302PC Position Pay Codes History
 PC30303PC Position Benefits History
 PC30304PC Position Seats History
 PC30305PC Position Seats Detail History
Freq
Used		 Display Name
 AEMPNOTEArchive_HR_Employee_Notes
 AHPSLH01Archive_HRP_Salary_History
 AHREM602Archive_HR_Employee_Photo
 AHRIN022Archive_HR_Injury_Costs
 AHROR012Archive_HR_I9
 AHROR042Archive_HR_Orientation_V2
 AHRPR012Archive_HR_Property
 AHRTA130Archive_TA_MSTR_Types
 AHRTA230Archive_TA_MSTR_Year_Max
 AHRTA330Archive_TA_TRX_Detail
 AHRTE062Archive_HR_Termination_Exit_Interview
 AHRTS022Archive_HR_Tests
 AHRVAC12Archive_HR_Vacation
 ARPBEN02Archive_HRP_Benefit_Beneficiary
 ARPBEN12Archive_HRP_BEN2_CoPay_Employee
 AUSERMSTArchive_SETUP_Users
 BE040100HR_Benefit_COBRA_MSTR
 BE040200HR_Benefit_COBRA_LINE
 BEA40100Archive_HR_Benefit_COBRA_MSTR
 BEA40200Archive_HR_Benefit_COBRA_LINE
 BMDVETMPBEN_Totals_Report_Temp
 EMPNOTEHR_Employee_Notes
 HR70500hrReportOptions
 HRCACC01HR_Company_Access
 HRCOM022HR_Company2_Extra
 HRDEP022HR_Department2_Extra
 HRDIV022HR_Division2_Extra
 HREMP053HR_Employee_Address_Change
 HREMP602HR_Employee_Photo
 HREMP662HR_Employee_Position
 HREMP922HR_Emp_Filters
 HRINJ022HR_Injury_Costs
 HRORI012HR_I9
 HRORI022HR_Orientation_Setup_MSTR_V2
 HRORI042HR_Orientation_V2
 HRPBEN01HRP_Benefit_TEMP
 HRPBEN02HRP_Benefit_Beneficiary
 HRPBEN05HRP_BEN_FMLA_Set12Month
 HRPBEN11HRP_BEN2_CoPay_Setup_LINE
 HRPBEN12HRP_BEN2_CoPay_Employee
 HRPOS022HR_Position2_Extra
 HRPppc01HRP_Position_Pay_Code
 HRPREASNHRP_Reasons
 HRPRED01Redlined Employee Pay Codes
 HRPRO012HR_Property
 HRPRO022HR_Property_Setup
 HRPS0400Pay Step Table Header
 HRPS0401Pay Step Table Detail
 HRPSLH01HRP_Salary_History
 HRPSY01HRP_Synch_Error_Log
 HRREV032HR_Review_Interval_V2
 HRREV053Generate Unique Key Last
 HRSAX012HR_Salary_Matrix
 HRSAX022HR_Salary_Matrix_Table
 HRSAX032HR_Salary_Matrix_Row
 HRSAX042HR_Salary_Matrix_Col
 HRTCTMPHR_Train_Class_Temp
 HRTER022HR_Termination_Setup_MSTR_V2
 HRTER062HR_Termination_Exit_Interview
 HRTRA042HR_Train_Class_Skills
 HRTRPC02HR_Train_Position_Course_Class
 HRTRPS01HR_Train_Position_Course
 HRTST022HR_Tests
 HRVACA12HR_Vacation
 MPOSHISTMultiple_Positions_History
 MPOSMAINMultiple_Positions
 PC40100PC Setup Information
 PC40200PC Fund Setup
 PC40201PC Fund Accounts Setup
 PC40300Position Plans
 PC40301PC Position Setup
 PC40302PC Position Pay Codes
 PC40303PC Position Benefits
 PC40304PC Position Seats
 PC40305PC Position Seats Detail
 PC40306PC Position Setup Budget
 PC40307PC Position Setup Budget Funds
 PC40308PC Position Seat Budgets
 PC40309PC Position Seat Budget Funds
 PC40800PC Position Seat Inheritance
 PC40801PC Position Pay Codes Inheritance
 PC40802PC Position Benefit Inheritance
 PC70100PC Report Options
 TAAC0130TA_SETP_Accrual_Type
 TAAC0230TA_Accrual_Time_Codes
 TAAC1030TA_Seniority
 TAAC2030TA_Seniority_Table
 TAST0130TA_Setup
 TAST0230TA_Attendance_Reason
 TAST0330TA_Attendance_Type
 TAST0432TA_Pay_Period_Accrual_MSTR
 TAST0532TA_Pay_Period_Accrual_LINE
 TATM0130TA_SETP_Types
 TATM1030TA_MSTR_Types
 TATM2030TA_MSTR_Year_Max
 TATX0130TA_TRX_Next
 TATX1030TA_TRX_Detail
 TRNENTMPHR_Train_Enroll_List_TEMP
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Anchored Marriage
3