Composite View Source: PERJTOT

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: PERJTOT Human Resources

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
PERJTOT_EARN_CODE	PEIJTOT	COMPOSITE VIEW	AP_EARNING_TOTALS_CY AP_EMPLOYEE_EARNING_CY AP_EARNING_TOTALS_FY AP_EMPLOYEE_EARNING_FY	EARNINGS EARNINGS EARNINGS EARNINGS	NA
PERJTOT_EMPR_CODE	PEIJTOT	COMPOSITE VIEW	AP_EMPLOYEE_EARNING_FY AP_EMPLOYEE_EARNING_CY AP_EARNING_TOTALS_CY AP_EARNING_TOTALS_FY	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_FY AP_EMPLOYEE_EARNING_CY	HOURS HOURS	NA
PERJTOT_MONTH	PEIJTOT	COMPOSITE VIEW	AP_EMPLOYEE_EARNING_FY AP_EMPLOYEE_EARNING_CY	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_CY AP_EARNING_TOTALS_CY AP_EARNING_TOTALS_FY AP_EMPLOYEE_EARNING_FY	POSITION POSITION POSITION POSITION	NA
PERJTOT_SUFF	PEIJTOT	COMPOSITE VIEW	AP_EARNING_TOTALS_FY AP_EMPLOYEE_EARNING_CY AP_EARNING_TOTALS_CY AP_EMPLOYEE_EARNING_FY	SUFFIX SUFFIX SUFFIX SUFFIX	NA
PERJTOT_YEAR	PEIJTOT	COMPOSITE VIEW	AP_EMPLOYEE_EARNING_CY AP_EARNING_TOTALS_CY	CALENDAR_YEAR CALENDAR_YEAR	NA

Ver: