Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: PERJTOT Human Resources
SGHE Banner Operational Data Store Composite View Source: PERJTOT - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
PERJTOT_EARN_CODE PEIJTOT COMPOSITE VIEW

AP_EARNING_TOTALS_CY

AP_EARNING_TOTALS_FY

AP_EMPLOYEE_EARNING_FY

AP_EMPLOYEE_EARNING_CY

EARNINGS

EARNINGS

EARNINGS

EARNINGS

NA
PERJTOT_EMPR_CODE PEIJTOT COMPOSITE VIEW

AP_EARNING_TOTALS_FY

AP_EMPLOYEE_EARNING_FY

AP_EMPLOYEE_EARNING_CY

AP_EARNING_TOTALS_CY

EMPLOYER

EMPLOYER

EMPLOYER

EMPLOYER

NA
PERJTOT_GRS PEIJTOT COMPOSITE VIEW

AP_EMPLOYEE_EARNING_CY

AP_EMPLOYEE_EARNING_FY

GROSS

GROSS

NA
PERJTOT_HRS PEIJTOT COMPOSITE VIEW

AP_EMPLOYEE_EARNING_CY

AP_EMPLOYEE_EARNING_FY

HOURS

HOURS

NA
PERJTOT_MONTH PEIJTOT COMPOSITE VIEW

AP_EMPLOYEE_EARNING_CY

AP_EMPLOYEE_EARNING_FY

MONTH

MONTH

NA
PERJTOT_PIDM PEIJTOT COMPOSITE VIEW

AP_EARNING_TOTALS_CY

AP_EMPLOYEE_EARNING_CY

AP_EARNING_TOTALS_FY

AP_EMPLOYEE_EARNING_FY

PERSON_UID

PERSON_UID

PERSON_UID

PERSON_UID

NA
PERJTOT_POSN PEIJTOT COMPOSITE VIEW

AP_EMPLOYEE_EARNING_FY

AP_EARNING_TOTALS_CY

AP_EARNING_TOTALS_FY

AP_EMPLOYEE_EARNING_CY

POSITION

POSITION

POSITION

POSITION

NA
PERJTOT_SUFF PEIJTOT COMPOSITE VIEW

AP_EMPLOYEE_EARNING_CY

AP_EARNING_TOTALS_CY

AP_EARNING_TOTALS_FY

AP_EMPLOYEE_EARNING_FY

SUFFIX

SUFFIX

SUFFIX

SUFFIX

NA
PERJTOT_YEAR PEIJTOT COMPOSITE VIEW

AP_EARNING_TOTALS_CY

AP_EMPLOYEE_EARNING_CY

CALENDAR_YEAR

CALENDAR_YEAR

NA


Ver: