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 |