HRMSi - Workforce Gain (Organization Hierarchy) Status Analytics: by Geography Area

Description
Categories: Discoverer
Columns: Bg Security Flag Code Y, Value, Application Id, C 4, C 3, C 1, C 2 ...
Investigates the different ways workforce is growing. For example people may be added to an organization as new hires or transfers
Owner: SYSADMIN (System Administrator)
Identifier: HRIAWGNS
SELECT  o101640.VALUE as BG_Security_Flag_Code____Y_,o101643.VALUE,o101627.VALUE,as108169_168047_OLD as Application_id,SUM(CASE WHEN o101679.GAIN_ORG_INDICATOR = 1 THEN o101679.GAIN_ORG_INDICATOR-HRI_OLTP_DISC_ORG.INDICATE_IN_ORGH(o101667.ORG_HIERARCHY_VERSION_ID,o101667.SUP_ORGANIZATION_ID,o101679.ORGANIZATION_FROM_ID) ELSE 0 END*o101679.ACTIVE_INDICATOR*(HRI_OLTP_DISC_WRKFRC.CALC_ABV_LOOKUP((o101679.ASSIGNMENT_TO_ID),(o101679.BUSINESS_GROUP_TO_ID),:workforce_measurement_type,o101679.EVENT_DATE,(o101679.PRIMARY_TO_FLAG_CODE)) )) as C_4,SUM(o101679.GAIN_LTA_INDICATOR*o101679.ACTIVE_INDICATOR*(HRI_OLTP_DISC_WRKFRC.CALC_ABV_LOOKUP((o101679.ASSIGNMENT_TO_ID),(o101679.BUSINESS_GROUP_TO_ID),:workforce_measurement_type,o101679.EVENT_DATE,(o101679.PRIMARY_TO_FLAG_CODE)) )) as C_3,SUM(o101679.GAIN_HIRE_INDICATOR*o101679.ACTIVE_INDICATOR*(HRI_OLTP_DISC_WRKFRC.CALC_ABV_LOOKUP((o101679.ASSIGNMENT_TO_ID),(o101679.BUSINESS_GROUP_TO_ID),:workforce_measurement_type,o101679.EVENT_DATE,(o101679.PRIMARY_TO_FLAG_CODE)) )) as C_1,SUM(o101679.GAIN_ASG_INDICATOR*o101679.ACTIVE_INDICATOR*(HRI_OLTP_DISC_WRKFRC.CALC_ABV_LOOKUP((o101679.ASSIGNMENT_TO_ID),(o101679.BUSINESS_GROUP_TO_ID),:workforce_measurement_type,o101679.EVENT_DATE,(o101679.PRIMARY_