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 | Double | Salary amount on the salary record for the worker assignment. |
| AdjustmentAmount | Double | Calculated adjustment amount based on the previous salary. |
| AdjustmentPercentage | Double | Calculated adjustment percentage based on the previous salary . |
| AnnualSalary | Double | Annual value of the worker's salary. |
| AnnualFullTimeSalary | Double | 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 | Double | Salary as a percentage of the grade range midpoint. Salary at the midpoint is 100. |
| RangePosition | Double | Position of the worker's salary within the assignment grade salary range, expressed as a percentage of 100. |
| SalaryRangeMinimum | Double | Salary range minimum based on the worker assignment grade. |
| SalaryRangeMidPoint | Double | Salary range midpoint based on the worker assignment grade. |
| SalaryRangeMaximum | Double | Salary range maximum based on the worker assignment grade. |
| SearchDate | String | Date used to find the applicable salary for the day. |
| FrequencyName | String | Frequency of the salary basis, such as Annually, Monthly, Weekly, or Hourly. |
| AssignmentNumber | String | Assignment number for the given assignment. |
| DisplayName | String | Unique name for the set of details linked to a worker's base pay. These details include the payroll characteristics used to pay base earnings, the duration of the quoted base pay, and the factor used to annualize base pay. The details also include any components used to connect base pay adjustments to different reasons and any associated grade rate for salary validation. |
| ActionId | Long | Unique identifier of the action. |
| ActionReasonId | Long | Unique identifier of the action reason. |
| ActionCode | String | Code of the action. |
| ActionReasonCode | String | Code of the action reason. |
| ActionReason | String | Reason for the action being done on the record. Valid values are defined in the actionReasonsLOV. |
| ActionName | String | Action being done on this assignment, such as, Hire, Add Pending Worker, Manager Change and so on. Valid values are defined in the actionsLOV. |
| Code | String | Code for the salary basis. |
| LegalEmployerName | String | Legal employer for the person's assignment. |
| GradeLadderName | String | Name of the grade ladder associated with the person's assignment. |
| GradeName | String | Name of the step associated with the person's assignment. |
| GradeStepName | String | Name of the grade associated with the person's assignment. |
| GeographyName | String | Geographical zone used in compensation to calculate salary ranges. |
| GeographyTypeName | String | Geographical zone type used in compensation to calculate salary ranges. |
| GradeId | Long | Unique identifier for the assignment grade. |
| LastUpdateDate | Datetime | Identifies the date and time that the row was most recently updated. |
| LastUpdatedBy | String | Identifies the user who most recently updated the row. |
| CreatedBy | String | Identifies the user who created the row. |
| CreationDate | Datetime | Identifies the date and time that the row was created. |
| FTEValue | Double | Factor that represents the proportion of full-time hours a person works. |
| NextSalReviewDate | Date | Date to review a person's assignment salary. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| EffectiveDate | Date | EffectiveDate |
| Finder | String | finder |