Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
ACCEPTED_IND
|
Indicates when an offer of employment was accepted by the applicant. VALUES will be yes or no. The HR_APPLICATION_STATUS reporting view will show this information.
|
VARCHAR2(63)
|
HR_APPLICATION
|
FUNCTION
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
APPLIED_IND
|
Indicates if an application was received by the fact there is information in the HR_APPLICATION reporting view. VALUES will be yes or no. Calculated.
|
VARCHAR2(63)
|
HR_APPLICATION
|
FUNCTION
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
EMPLOYED_IND
|
Indicates that beginning employment date has passed. VALUES will be yes or no based in the POSITION_BEGIN_DATE in the EMPLOYEE reporting view.
|
VARCHAR2(63)
|
HR_APPLICATION
|
FUNCTION
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
EMPLOYMENT_OFFERED_IND
|
Indicates when an offer of employment was made. VALUES will be yes or no.
|
VARCHAR2(63)
|
HR_APPLICATION
|
FUNCTION
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
HR_APPLICANT_STATUS_KEY
|
Key for the HR applicant status dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
INTERVIEWED_IND
|
Indicates if the applicant attended the interview that was scheduled. VALUES will be yes or no. Calculated based on if the INTERVIEW reporting view has data and the INTERVIEW_DATE has passed.
|
VARCHAR2(63)
|
HR_APPLICATION
|
FUNCTION
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
INTERVIEW_OFFERED_IND
|
Indicates if the applicant was offered an interview for the position. VALUES will be yes or no. Calculated based on if any records display through the INTERVIEW reporting view.
|
VARCHAR2(63)
|
HR_APPLICATION
|
FUNCTION
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|