ASR CYCLE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASR_CYCLE_KEY |
XXX |
VARCHAR2 |
9 |
CYCLE |
XXX |
VARCHAR2 |
40 |
CYCLE_CATEGORY |
XXX |
VARCHAR2 |
40 |
CYCLE_CATEGORY_CODE |
XXX |
VARCHAR2 |
4 |
CYCLE_CODE |
XXX |
VARCHAR2 |
3 |
CYCLE_EFFECTIVE_DATE |
XXX |
DATE |
|
CYCLE_ELIGIBILITY_DATE |
XXX |
DATE |
|
CYCLE_END_DATE |
XXX |
DATE |
|
CYCLE_PERCENT |
XXX |
NUMBER |
5,2 |
CYCLE_START_DATE |
XXX |
DATE |
|
CYCLE_VERSION |
XXX |
VARCHAR2 |
2 |
FISCAL_YEAR |
The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998) |
VARCHAR2 |
4 |
IS_FACULTY |
The indicator that the person is a member of the faculty (YES, NO). |
VARCHAR2 |
1 |
IS_HOURLY |
XXX |
VARCHAR2 |
1 |
IS_RANK_LIST2 |
XXX |
VARCHAR2 |
1 |
IS_UNION |
XXX |
VARCHAR2 |
1 |
STEP |
XXX |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |