ASR CYCLE Table
View exposing Annual Salary Review cycle reference data, including fiscal year, cycle, category, and related effective date attributes used for compensation review processing and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASR_CYCLE_KEY |
Surrogate key identifying the asr cycle. |
VARCHAR2 |
9 |
CYCLE |
Cycle as provided by the source. |
VARCHAR2 |
40 |
CYCLE_CATEGORY |
Cycle category as provided by the source. |
VARCHAR2 |
40 |
CYCLE_CATEGORY_CODE |
Code identifying cycle category. |
VARCHAR2 |
4 |
CYCLE_CODE |
Code identifying cycle. |
VARCHAR2 |
3 |
CYCLE_EFFECTIVE_DATE |
Date associated with cycle effective. |
DATE |
|
CYCLE_ELIGIBILITY_DATE |
Date associated with cycle eligibility. |
DATE |
|
CYCLE_END_DATE |
Date associated with cycle end. |
DATE |
|
CYCLE_PERCENT |
Cycle percent as provided by the source. |
NUMBER |
5,2 |
CYCLE_START_DATE |
Date associated with cycle start. |
DATE |
|
CYCLE_VERSION |
Cycle version as provided by the source. |
VARCHAR2 |
2 |
FISCAL_YEAR |
Fiscal year as provided by the source. |
VARCHAR2 |
4 |
IS_FACULTY |
Indicator identifying whether faculty (Y/N). |
VARCHAR2 |
1 |
IS_HOURLY |
Indicator identifying whether hourly (Y/N). |
VARCHAR2 |
1 |
IS_RANK_LIST2 |
Indicator identifying whether rank list2 (Y/N). |
VARCHAR2 |
1 |
IS_UNION |
Indicator identifying whether union (Y/N). |
VARCHAR2 |
1 |
STEP |
Step as provided by the source. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |