Positions
Positions
Columns
| Name | Type | Description |
| PositionId [KEY] | Long | System generated primary key column. |
| EffectiveStartDate [KEY] | Date | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. |
| EffectiveEndDate [KEY] | Date | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. |
| BusinessUnitId | Long | Foreign key to HRW_BUSINESS_UNITS table. |
| PositionCode | String | Code of the position. |
| Name | String | Denotes the translated name of the position. |
| DepartmentId | Long | Foreign Key to HR_ALL_ORGANIZATION_UNITS_F |
| JobId | Long | Foreign Key to PER_JOBS_F table. |
| LocationId | Long | Foreign Key to PER_LOCATIONS table. |
| EntryGradeId | Long | Identifier of the entry grade. |
| EntryStepId | Long | Identifier of the entry step. |
| ActiveStatus | String | Indicates if a position is active or inactive. |
| RegularTemporary | String | Indicates if a position is regular or temporary. |
| FTE | Double | Position full time equivalent. |
| CalculateFTE | String | Indicates whether FTE should be calculated for this position. |
| HiringStatus | String | Indicates the hiring status of the position, for example approved or frozen. |
| FullPartTime | String | Indicates if a position is full-time or part-time. |
| PositionType | String | Indicates the type of the position for example pooled or single. |
| HeadCount | Int | Position headcount. |
| OverlapAllowedFlag | Bool | Indicates if overlap is allowed. |
| SeasonalFlag | Bool | Indicates if a position is seasonal. |
| SeasonalStartDate | Date | Seasonal start date. |
| SeasonalEndDate | Date | Seasonal end date. |
| ProbationPeriod | Double | Number of the probation period. |
| SecurityClearance | String | Indicates the security clearance of a position. |
| GradeLadderId | Long | Foreign Key to PER_GRADE_LADDERS_F |
| CreationDate | Datetime | CreationDate of Positions |
| LastUpdateDate | Datetime | LastUpdateDate of Positions |
| BudgetAmount | Double | Budget Amount for the Position. |
| BudgetAmountCurrency | String | Currency in which Budget Amount is measured. |
| BudgetedPositionFlag | Bool | Flag to indicate whether this is a Budgeted Position. |
| CostCenter | String | Cost Center for the position. |
| DelegatePositionId | Long | Position to which duties and resposibilities of the current position will be delegated when the current position is away. |
| FundedByExistingPositionFlag | Bool | Flag to indicate whether this position is funded by existing positions. |
| DelegatePositionCode | String | Code of Delegate Position. |
| DelegatePositionBusinessUnitId | Long | Business Unit Id of Delegate Position. |
| DelegatePositionBusinessUnitName | String | Business Unit Name of Delegate Position. |
| CostCenterName | String | Cost Center Name of the position. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SysEffectiveDate | Date | SysEffectiveDate |
| Finder | String | finder |