SalariessalaryPayRateComponents
SalariessalaryPayRateComponents
Columns
| Name | Type | Description |
| SalariesSalaryId [KEY] | Long | Unique identifier of the salary for a worker assignment. |
| SalaryId | Long | Unique identifier of the salary. |
| SalaryPayComponentId [KEY] | Long | Unique identifier of the salary rate component. |
| PayRateDefinitionId | Long | Unique identifier of the rate definition. |
| RateDisplaySequence | Int | Display sequence of the rate component. |
| RateType | String | Type of the rate, such as Primary or Derived. |
| RateAmount | Double | Amount on the rate component of the person's salary. |
| RateFactor | Double | Percentage on the rate component of the person's salary. |
| RatePeriodicityCode | String | Code of the rate periodicity, such as ANNUAL, MONTHLY, or HOURLY. |
| RateCurrencyCode | String | Currency code that the rate is stored in, such as USD. |
| RateScale | Long | Decimal precision of the rate definition. |
| RateAnnualAmount | Double | Annual value of the rate amount. |
| RateAnnualFtAmount | Double | Annual value of the rate amount, if the worker was working full time. |
| Name | String | Name of the salary rate component, which can be configured to capture an amount, factor, or derived. |
| FTEFlag | Bool | Indicates whether the rate is prorated for full time equivalent. Valid values are Yes and No, and the default value is No. |
| RateOverallSalaryFlag | Bool | Indicates whether the rate is an overall salary type. Valid values are Yes and No, and the default value is No. |
| ReturnPrecision | Long | Decimal precision of the returned rate value. |
| ShortName | String | Short name of the salary rate component. |
| RateFrequencyName | String | Frequency of the rate definition, such as Annually, Monthly, Weekly, or Hourly. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AssignmentId | Long | AssignmentId |
| EffectiveDate | Date | EffectiveDate |
| Finder | String | finder |