Definition:
The most current record for each employee and job, not future-dated, as of the most recent refresh of the Data Warehouse table contains the value "Y" in this field. Records other than the current one contains the value "N".
This field exists only the Data Warehouse.
Technically speaking, "most current" means the row with the maximum Effective Date and, if applicable, maximum Effective Sequence number; note, however, that future-dated rows are excluded when making this determination.
For employees with multiple concurrent jobs recorded in the EMPLOYEE_DIM views, multiple rows (with different values of EMPL_REC_NO) exist for which CUR_REC_FLAG is "Y". That is, a row with CUR_REC_FLAG set to "Y" is the most current record for a given EMPL_ID and EMPL_REC_NO.
Short definition...