HR POSITION STATUS Table
View exposing HR position status reference data including status codes and descriptions used to classify position lifecycle state in reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADD_TO_HEADCOUNT_CODE |
Column ADD_TO_HEADCOUNT_CODE. |
VARCHAR2 |
3 |
ADD_TO_HEADCOUNT_REASON |
Column ADD_TO_HEADCOUNT_REASON. |
VARCHAR2 |
100 |
HR_POSITION_STATUS_KEY |
Column HR_POSITION_STATUS_KEY. |
VARCHAR2 |
14 |
IS_POSITION_CLOSED |
Column IS_POSITION_CLOSED. |
VARCHAR2 |
1 |
IS_POSITION_FILLED |
Column IS_POSITION_FILLED. |
VARCHAR2 |
3 |
POSITION_STATUS |
Column POSITION_STATUS. |
VARCHAR2 |
60 |
WAIVER_REASON_CODE |
Column WAIVER_REASON_CODE. |
VARCHAR2 |
3 |
WAIVER_REASON_DESCRIPTION |
Column WAIVER_REASON_DESCRIPTION. |
VARCHAR2 |
100 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |