AHPSLH01 - Archive_HRP_Salary_History
Dynamics GP table AHPSLH01 (Archive_HRP_Salary_History) contains 13 columns including EMPLOYID, PAYRCORD, EFFECTIVEDATE_I....
SQL Query Builder
13 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| EMPLOYID | Employee ID | String | 16 | |
| PAYRCORD | Pay Record | String | 8 | |
| EFFECTIVEDATE_I | Effective Date0 | Date | 4 | |
| SEQNUMBR | Sequence Number | Long Integer | 4 | |
| PAYRTAMT | Pay Rate Amount | Currency | 10 | |
| PAYUNIT | Pay Unit | String | 26 | |
| PAYUNPER | Pay Unit Period | Integer | 2 | |
| PAYPEROD | Pay Period | Integer | 2 | |
| PAYPRPRD | Pay Per Period | Currency | 10 | |
| ANNUALSALARY_I | Annual Salary | Currency | 10 | |
| CHANGEREASON_I | Change Reason | String | 32 | |
| USERID | User ID | String | 16 | |
| CHANGEDATE_I | Change Date | Date | 4 |
Related Tables
Tables that share columns with AHPSLH01. Click "Join" to add to your query.
PAYRCORD
EFFECTIVEDATE_I
CHANGEREASON_I