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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
SysEffectiveDate | Date | SysEffectiveDate |
Finder | String | finder |