RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: APREHIS Advancement Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: APREHIS

Source Column Source Form Target Type Target Target Column Calculation Formula
APREHIS_ATYP_CODE APAEHIS       NA
APREHIS_ATYP_SEQNO APAEHIS       NA
APREHIS_COMMENT APAEHIS

REPORTING VIEW

CURRENT_EMPLOYMENT

EMPLOYMENT_HISTORY

EMPLOYER_COMMENT

EMPLOYER_COMMENT

NA
APREHIS_EMPL_POSITION APAEHIS

REPORTING VIEW

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

CURRENT_EMPLOYMENT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

POSITION_TITLE

POSITION_TITLE1

POSITION_TITLE4

POSITION_TITLE

POSITION_TITLE2

POSITION_TITLE3

NA
APREHIS_EMPR_NAME APAEHIS

REPORTING VIEW

CURRENT_EMPLOYMENT

EMPLOYER_NAME

NA
APREHIS_EMPR_PIDM NA

REPORTING VIEW

EMPLOYMENT_HISTORY

CURRENT_EMPLOYMENT

EMPLOYER_UID

EMPLOYER_UID

NA
APREHIS_EMPS_CODE APAEHIS

REPORTING VIEW

CURRENT_EMPLOYMENT

EMPLOYMENT_HISTORY

EMPLOYMENT_STATUS

EMPLOYMENT_STATUS

NA
APREHIS_FROM_DATE APAEHIS

REPORTING VIEW

CURRENT_EMPLOYMENT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

START_DATE

END_DATE2

END_DATE4

END_DATE1

END_DATE

END_DATE3

NA
APREHIS_JOBC_CODE APAEHIS

REPORTING VIEW

CURRENT_EMPLOYMENT

EMPLOYMENT_HISTORY

EMPLOYER_CATEGORY

EMPLOYER_CATEGORY

NA
APREHIS_JOBC_CODE2 APAEHIS

REPORTING VIEW

EMPLOYMENT_HISTORY

CURRENT_EMPLOYMENT

EMPLOYER_CATEGORY2

EMPLOYER_CATEGORY2

NA
APREHIS_JOBC_CODE3 APAEHIS

REPORTING VIEW

EMPLOYMENT_HISTORY

CURRENT_EMPLOYMENT

EMPLOYER_CATEGORY3

EMPLOYER_CATEGORY3

NA
APREHIS_JOBC_CODE4 APAEHIS

REPORTING VIEW

EMPLOYMENT_HISTORY

CURRENT_EMPLOYMENT

EMPLOYER_CATEGORY4

EMPLOYER_CATEGORY4

NA
APREHIS_MG_IND APAEHIS

REPORTING VIEW

CURRENT_EMPLOYMENT

MATCHING_GIFT_IND

NA
APREHIS_PIDM NA

REPORTING VIEW

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

CURRENT_EMPLOYMENT

PERSON_UID

PERSON_UID

PERSON_UID

NA
APREHIS_PRIMARY_IND APAEHIS

REPORTING VIEW

EMPLOYMENT_HISTORY

CURRENT_EMPLOYMENT

PRIMARY_EMPLOYMENT_IND

PRIMARY_EMPLOYMENT_IND

NA
APREHIS_SEQ_NO APAEHIS

REPORTING VIEW

EMPLOYMENT_HISTORY

CURRENT_EMPLOYMENT

EMPLOYMENT_ORDER

EMPLOYMENT_ORDER

NA
APREHIS_SICC_CODE APAEHIS

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

CURRENT_EMPLOYMENT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYER_TYPE2

EMPLOYER_INDUSTRIAL_TYPE

EMPLOYER_TYPE4

EMPLOYER_INDUSTRIAL_TYPE

EMPLOYER_TYPE1

EMPLOYER_TYPE3

NA
APREHIS_TO_DATE APAEHIS

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

START_DATE1

START_DATE2

START_DATE3

START_DATE4

START_DATE

NA
APREHIS_WKLY_HOURS APAEHIS

REPORTING VIEW

EMPLOYMENT_HISTORY

CURRENT_EMPLOYMENT

WEEKLY_HOURS

WEEKLY_HOURS

NA


Ver: 3.1