TABLE OF CONTENTS

• WHAT IS THE NO HIT LIST?
• WHERE IS NO HIT LIST? 
• HOW DO I READ THE NO HIT LIST? 
  • CONTROLS
  • DETAIL TABS
  • LIST TABLES
• HOW DO I UPDATE THE NO HIT LIST?
• FAQ’s

WHAT IS THE NO HIT LIST?

The purpose of the No Hit List (NHL) is to find individuals contributing to IUPAT related Funds and work to them Active Dues Paying Members.

The IUPAT works with the International Pension Fund to compare the last six months of Working Hour Contributions by Employee and compares those Employees to the Current Active Membership in the IUPAT.  The Working Employees that do not have a Member ID tied to their IPF Employee Record create the No Hit List.

WHERE IS NO HIT LIST? 

Log into UNITE

Go to My Account - Reports Portal

Go to the No Hit List from the Menu Items (Your menu may vary)

HOW DO I READ THE NO HIT LIST?

The NHL is broken down into three main parts, the Controls, Detail Tabs, and List Tables.

CONTROLS

These allow you to Filter the NHL 

-By DC (This will already be set based on your Account Information)

-By Employer Name (Type any part of an Employer Name to filter the list to only that Employer)

Clear Filters removes the filtering by Person ID (This does not remove Employer Name controls)

DETAIL TABS

The No Hit List Tab breaks down the List of Employees into groups.

The Individual Employee Details gives information on the selected Person ID.

LIST TABLES

Each of the No Hit List Tables are designed to break down the NHL by Priority Level

HIGH PRIORITY - These are employees that have not had a response added to their records in the last six months.

PENDING/SUSPENDED MEMBERS - These are employees that match to a Member ID, however, their Membership Records are Pending (Paying on Application or in a Card Granted Status) or are Suspended to be Dropped.

LOW PRIORITY GROUPS (Multiple) - These are employees that have had a response given within the last six months, but are not Active Members.  This could be due to such things as being a PLA, CORE or Temporary Employee, choosing Right to Work (Each has their own group).

Each of the Individual Member Data Tables are designed to give information on a single Person ID

MEMBER DATA - This is the Membership Data contained within IMSe/UNITE

V3 HOURS DATA - These are all the hours reported by Employer and Agreement Name within the last 6 months.

V3 PERSON DATA - This is the information received contained within the Pension Fund System

RESPONSES - This is a list of all responses received in the past (Including the previous Spreadsheet version of the NHL.

HOW DO I UPDATE THE NO HIT LIST?

Select a Person ID from the No Hit List Tables by clicking on the Person ID Column and then click on the Individual Employee Details Tab.

YOU MUST CLICK ON THE PERSON ID COLUMN FOR THE INDIVIDUAL EMPLOYEE DETAIL TABLES TO DISPLAY CORRECTLY.

Review the Individual Employee Details tables to understand why this person would appear on the NHL.

    Is there a Matching Member ID?

    Is the Person an Inactive/Pending/Suspended Member? Should they be Active?
Add a new response within the SUBMIT A NEW RESPONSE area at the bottom of the Individual Employee Details Tab.

-Enter the Person ID (Copy it from the V3 Person Data Table (Right-Click / Copy / Paste) or type in the value.

-Select the Type of Response from the pre-created list of options

-Add Detail to the Response

-Add your Email Address

-Click SUBMIT

Your Response will be recorded and will update the No Hit List Tables the next time the Dataset is refreshed

How do individuals end up in certain Priority Groups?

We have rules set up based on the previous response types that control where employees are displayed on the NHL, below is the actual code that is used to create the groups:

(CASE WHEN ((((((((((((((UPPER(`Response`) LIKE '%GOV ID. DISC%') 

OR (UPPER(`Response`) LIKE '%MEMBER #%')) 

OR (UPPER(`Response`) LIKE '%MEMBER ID%')) 

OR (UPPER(`Response`) LIKE '%MBR #%')) 

OR (UPPER(`Response`) LIKE '%MBR ID%')) 

OR (UPPER(`Response`) LIKE '%ID#%')) 

OR (UPPER(`Response`) LIKE '%ID #%')) 

OR (UPPER(`Response`) LIKE '%MEMBER I.D.%')) 

OR (UPPER(`Response`) LIKE '% ID %')) 

OR (UPPER(`Response`) LIKE '%SSN%')) 

OR (UPPER(`Response`) LIKE '%SS#%'))

 OR (UPPER(`Response`) LIKE '%S.S.N.%')) 

OR (UPPER(`Response`) LIKE '%MID%')) 

OR (UPPER(`Response`) LIKE '%SOCIAL SECURITY%')) 

                                                                                                    THEN 'EMPLOYEE/RECORD MISMATCH' 

WHEN (((UPPER(`Response`) LIKE '%RTW%') 

OR (UPPER(`Response`) LIKE '%RIGHT TO WORK%'))

 OR (UPPER(`Response`) LIKE '%JANUS%')) 

                                                                                THEN 'WILL NOT BE MEMBER - RIGHT TO WORK' 

WHEN ((((UPPER(`Response`) LIKE '%TRADESHOW EXTRA%') 

OR (UPPER(`Response`) LIKE '%TRADE SHOW EXTRA%')) 

OR (UPPER(`Response`) LIKE '%OVERHIRE%')) 

OR (UPPER(`Response`) LIKE '%SEASONAL SHOWS%')) 

                                                                    THEN 'EXTRA HIRE / TEMPORARY EMPLOYEE' 

WHEN (((((((((((UPPER(`Response`) LIKE '%CORE EMP%') 

OR (UPPER(`Response`) LIKE '%CWA%')) 

OR (UPPER(`Response`) LIKE '%PLA%'))

 OR (UPPER(`Response`) LIKE '%PLA/PSA%'))

 OR (UPPER(`Response`) LIKE '%PLA%')) 

OR (UPPER(`Response`) LIKE '%PLA/%')) 

OR (UPPER(`Response`) LIKE '%PROJECT LABOR AGREEMENT%')) 

OR (UPPER(`Response`) LIKE '%ONE TIME PARTICIPATION AGREEMENT%')) 

OR (UPPER(`Response`) LIKE '%BORROWED EMP%')) 

OR (UPPER(`Response`) LIKE '%CORE MEMBER%')) 

OR (UPPER(`Response`) LIKE '%AGENCY%')) 

                                            THEN 'WILL NOT BE MEMBER - AGENCY, CORE, CWA, PLA' 

WHEN ((UPPER(`Response`) LIKE 'DISTRICT COUNCIL' and UPPER(`Response`) like  'EMPLOYEE%') 

OR (UPPER(`Response`) LIKE '%IUPAT INDUSTRY PENSION FUND%')) 

                                                                                                THEN 'IUPAT EMPLOYEE' 

WHEN ((((((UPPER(`Response`) LIKE '%NO LONGER WORKING%') 

OR (UPPER(`Response`) LIKE '%NLW%'))

 OR (UPPER(`Response`) LIKE '%RESIGNED%')) 

OR (UPPER(`Response`) LIKE '%LEFT TRADE%')) 

OR (UPPER(`Response`) LIKE '%RETIRED%')) 

OR (UPPER(`Response`) LIKE '%TERMINATED EMPLOYMENT%') 

OR (UPPER(`Response`) LIKE '%NOT WORKING%')) 

                                                                                            THEN 'NO LONGER WORKING' 

WHEN (`status` like '%SUSPENDED%' or `status` like '%PENDING%') 

                                                                            THEN 'SUSPENDED & PENDING MEMBERS'

                                                                             ELSE 'HIGH PRIORITY' END)

FAQ’s

Can the List be broken down by Local Union?

We have added the Membership Local Union filter to the NHL.  This will only filter to the Employees that were last active within your District Council and have a Member ID connected to their Person ID. 

Who should work on the No Hit List?

Each District Council should have a plan in place between the BM/ST, Admin Staff, and Business Reps.’ 

Is this just cleaning up records at the International Office?

This is a side effect, however, the main goal of the No Hit List is making sure we retain and maintain Membership. Employees on the No Hit List are the easy targets when it comes to gaining Membership.’ 

How do I send the No Hit List?

The No Hit List is now updated in real time with your responses.  Each new response is recorded and added directly to the full dataset.  Each hour the data is updated with the most recent changes and the NHL will be updated accordingly based on the response information.