Salaries
Salaries
Columns
| Name | Type | Description |
| AssignmentId | Long | Unique identifier for the assignment. |
| SalaryId [KEY] | Long | Unique identifier for a salary record generated by the application. |
| SalaryBasisId | Long | Unique identifier for the salary basis. |
| SalaryFrequencyCode | String | Code of the salary basis frequency, such as ANNUAL, MONTHLY, HOURLY. |
| SalaryBasisType | String | Type of the salary basis, such as Salary amount determined by the user or Components. |
| CurrencyCode | String | Currency code that the salary amount is stored in, such as USD. |
| DateFrom | Date | Start date of the salary. |
| DateTo | Date | End date of the salary. |
| SalaryAmount | Decimal | Salary amount on the salary record for the worker assignment. |
| AdjustmentAmount | Decimal | Calculated adjustment amount based on the previous salary. |
| AdjustmentPercentage | Decimal | Calculated adjustment percentage based on the previous salary . |
| AnnualSalary | Decimal | Annual value of the worker's salary. |
| AnnualFullTimeSalary | Decimal | Annual value of the worker's salary, if working full time. |
| Quartile | String | Quartile containing the worker's salary. The salary range for the worker's grade is divided into four equal parts called quartiles. |
| Quintile | String | Quintile containing the worker's salary. The salary range for the worker's grade is divided into five equal parts called quintiles. |
| CompaRatio | Decimal | Salary as a percentage of the grade range midpoint. Salary at the midpoint is 100. |
| RangePosition | Decimal | Position of the worker's salary within the assignment grade salary range, expressed as a percentage of 100. |
| SalaryRangeMinimum | Decimal | Salary range minimum based on the worker assignment grade. |
| SalaryRangeMidPoint | Decimal | Salary range midpoint based on the worker assignment grade. |
| SalaryRangeMaximum | Decimal | Salary range maximum based on the worker assignment grade. |
| SearchDate | String | SearchDate of Salaries |
| FrequencyName | String | FrequencyName of Salaries |
| AssignmentNumber | String | AssignmentNumber of Salaries |
| DisplayName | String | DisplayName of Salaries |
| ActionId | Long | Unique identifier of the action. |
| ActionReasonId | Long | Unique identifier of the action reason. |
| ActionCode | String | ActionCode of Salaries |
| ActionReasonCode | String | ActionReasonCode of Salaries |
| ActionReason | String | ActionReason of Salaries |
| ActionName | String | ActionName of Salaries |
| Code | String | Code of Salaries |
| LegalEmployerName | String | LegalEmployerName of Salaries |
| GradeLadderName | String | GradeLadderName of Salaries |
| GradeName | String | GradeName of Salaries |
| GradeStepName | String | GradeStepName of Salaries |
| GeographyName | String | GeographyName of Salaries |
| GeographyTypeName | String | GeographyTypeName of Salaries |
| GradeId | Long | Unique identifier for the assignment grade. |
| LastUpdateDate | Datetime | LastUpdateDate of Salaries |
| LastUpdatedBy | String | LastUpdatedBy of Salaries |
| CreatedBy | String | CreatedBy of Salaries |
| CreationDate | Datetime | CreationDate of Salaries |
| FTEValue | Decimal | Factor that represents the proportion of full-time hours a person works. |
| NextSalReviewDate | Date | Date to review a person's assignment salary. |
| AssignmentType | String | Type of assignment, such as an employee, contingent worker, nonworker, or pending worker. |
| SalaryBasisName | String | SalaryBasisName of Salaries |
| AmountDecimalPrecision | Decimal | AmountDecimalPrecision of Salaries |
| SalaryAmountScale | Int | Decimal precision of the salary amount, configured in salary basis. |
| AmountRoundingCode | String | AmountRoundingCode of Salaries |
| AnnualRoundingCode | String | AnnualRoundingCode of Salaries |
| RangeRoundingCode | String | RangeRoundingCode of Salaries |
| WorkAtHome | String | WorkAtHome of Salaries |
| QuartileMeaning | String | Lookup code meaning of the quartile containing the worker's salary. |
| QuintileMeaning | String | Lookup code meaning of the quintile containing the worker's salary. |
| LegislativeDataGroupId | Long | LegislativeDataGroupId of Salaries |
| HasFutureSalary | String | HasFutureSalary of Salaries |
| MultipleComponents | String | Indicates whether the given salary record has any child records that are either Components, Simple Components, or Rates. |
| ComponentUsage | String | ComponentUsage of Salaries |
| PendingTransactionExists | String | Indicates if a salary change for the person assignment is pending approval. |
| RangeErrorWarning | String | RangeErrorWarning of Salaries |
| PayrollFactor | Decimal | Payroll multiplier used to convert the salary amount to an annual salary amount, when the frequency is chosen as payroll period. |
| SalaryFactor | Decimal | Multiplier that converts the salary amount to an annual salary amount. For example, if a worker's base pay is quoted hourly, the annualization factor is 2080 (40 hours per week x 52 weeks). |
| PayrollFrequencyCode | String | Code for the payroll frequency when the frequency is chosen as payroll period. |
| PersonId | Long | PersonId of Salaries |
| BusinessTitle | String | BusinessTitle of Salaries |
| PersonNumber | String | PersonNumber of Salaries |
| PersonDisplayName | String | PersonDisplayName of Salaries |
| GradeCode | String | GradeCode of Salaries |
| AssigGradeLadderId | Long | AssigGradeLadderId of Salaries |
| AssigGradeStepId | Long | AssigGradeStepId of Salaries |
| BusinessUnitId | Long | BusinessUnitId of Salaries |
| EffectiveDate | Date | EffectiveDate of Salaries |
| EffectiveStartDate | Date | EffectiveStartDate of Salaries |
| Finder | String | Finder of Salaries |
| JobId | Long | JobId of Salaries |
| LocationId | Long | LocationId of Salaries |
| OfferId | Long | OfferId of Salaries |
| ReloadTransactionId | Long | ReloadTransactionId of Salaries |
| RestFlow | String | RestFlow of Salaries |