United Brotherhood of Carpenters
and Joiners of America
Affiliate User's Guide


Previous Contents Index


Chapter 42
MEMEMP - Members by Employer Report



            +------------Inquiry/Report Procedures-------------+ 
            |                                                  | 
            |           Membership Inquiries/Reports           | 
            |  MEMINQ         Member Inquiry                   | 
            |  CONTACT        Member Inquiry by Contact Info   | 
            |  FINHIST        Member Financial History         | 
            |  MEMAFFINQ      Member Inquiry by Affiliate      | 
            |  DUESCODE       Members by Dues Code Report      | 
            |  ARRLTR         Arrears/Susp-Report/Letter/Lab   | 
            |  ACTIVITY       Membership Changes Activity      | 
            |  MEMBAL         Membership Balance Report        | 
            |  CLASSSUM       Membership Summary by Class      | 
            |  CRAFTSUM       Membership Summary by Craft      | 
            |  GENDERSUM      Membership Summary by Gender     | 
            |  MEMEMP         Members by Employer Report       | 
            |  ELIGRPT        Officer/Voter Election Eligibi   | 
            |  OFFELIG        Current Officer Eligibility      | 
            |  AVGAGE         Membership Average Age Report    | 
            |  MEMCOUNTY      Members by City/County Report    | 
            |  ARRSALERT      Membership Alert Inquiry         | 
            |  RETIRE         Retirement Eligibility Report    | 
            |  IDCARD         Print Member ID Card             | 
            |  IDROSTER       Member ID Roster                 | 
            |  PHOTO_REPORT   Member Photo Report              | 
            +--------------------------------------------------+ 

The MEMEMP - Members by Employer Report is used to inquire and report on membership by employer information. You can select members and/or non-members, by contractor, job site and referral dates, and how to sort the selected report data within employer.

You can create lists of active members who are currently employed by one or more employers/contractors, or get lists of all members who have been referred to selected contractors during a specified period of time.

This chapter explains how to create members by employer reports.

42.1 Members by Employer Report Input Screen

After MEMEMP is selected from the menu, the members by employer report screen is displayed.



 ULTRA     United Brotherhood of Carpenters and Joiners of America       (date) 
                                  Tucson Local                         UBC01444 
 
Affiliate ID         : UBC01444 -- Tucson Local 
 
Membership           : 
 
Contractor           : 
 
All Current Employees: 
 
Job Site             : 
 
Referred Start Date  : 
 
Referred End Date    : 
 
Sort                 : 
 
 
 
 
 +---------Membership---------+ 
 |  Members and Non-Members   | 
 |  Members Only              | 
 |  Non-Members Only          | 
 +----------------------------+ 
 
<ESC>=Exit                   MEMBERS BY EMPLOYER RPT         <F2>=Back <F1>=Help

Affiliate ID

Note: If you are a local affiliate user, the affiliate ID and name are displayed, and this prompt is skipped.



 Affiliate ID? ________ 

If a default affiliate ID is provided and it is correct, you can press [Enter] to accept the default. Otherwise, enter the appropriate affiliate ID.

You can enter the affiliate number which is a number from 1 to 99999, or enter the entire affiliate ID.

After the affiliate ID is entered, the affiliate name is displayed.

Membership Selection

You are asked which active members you want to include on the report. You can include members and/or non-members.



   +---------Membership---------+ 
   |  Members and Non-Members   | 
   |  Members Only              | 
   |  Non-Members Only          | 
   +----------------------------+ 

Select the appropriate item from the membership menu options.

Contractor/Employer Selection

You are asked for the contractor/employer ID.



 Contractor? __________________________________________________ 
 
                Enter "ALL" if you want to select all contractors 

Enter "all" to include all contractors/employers on the report.

Enter one or more characters of the contractor/employer ID or short name.

If more than one contractor/employer ID begins with the entered characters, a menu of contractors/employers is displayed. You can then select a contractor/employer from the list. For example:



 +------------- Select Contractor (from 2 Matching Contractors) --------------+ 
 |                                                                            | 
 |  Aff ID    Contractor ID    Contractor Name                                | 
 |  UBC01444  JONES & SONS     Ed Jones & Sons Construction                   | 
 |  UBC01444  JOHNSON          Donald R. Johnson Construction                 | 
 +----------------------------------------------------------------------------+ 

You can enter one or more contractors/employers.

Your selections are displayed in the top portion of the screen.

Employee Selection

You are asked if you want to include only the current employees.



   +All~Current~Employees+ 
   |  Yes                | 
   |  No                 | 
   +---------------------+ 

Select "Yes", if you want to create a report of members who are currently employed by the selected contractors.

Select "No", if you want to report on members who are currently, or have in the past, been employed by the selected contractors. or If "Yes", the next prompt will be for the sort option.

If "No", you will be asked for job sites and referral dates.

Job Sites

A list of job sites associated with the selected contractors, is displayed, and you are asked to select the job site(s) you want to report on.



   +----------------------Job Site----------------------+ 
   |  all                                               | 
   |----------------------------------------------------| 
   |  AM/PM MINIMART   AM/PM Minimart - Speedway        | 
   |  BINGO HALL       North Church Bingo Hall          | 
   |  BROOKHOUSE       Brooks's House                   | 
   |  BROOKS BARN      Brooks Barn and Garage           | 
   |  HOME DEPOT       Home Depot - Eastside            | 
   |  HORSE BARN       Don's Horse Barn                 | 
   |  PRICE CLUB       Price Club - North Tucson        | 
   |  TOWN HOMES SO    Town Homes/Condos - So. Tucson   | 
   |  PRICE CLUB       Price Club Of Tempe              | 
   +----------------------------------------------------+ 

Select "all" to include all the job sites.

Select one of the job sites from the menu.

Referral Dates

You can select members who were referred to or accepted jobs during a specific time period.

First, you are asked for the referral start date of the time period you want to report on.



 Referred Start date (MMDDYYYY)? FIRST___ 
 
               Enter FIRST to start at the beginning of the records 

Enter "FIRST" to start with the oldest referral/acceptance date.

Enter a referral/acceptance start date in MMDDYYYY format.

Next, you are asked for the end date of the referral/acceptance date range.



 Referred End date (MMDDYYYY)? LAST____ 
 
                   Enter LAST to read to the end of the records 

Enter "LAST" to include members with the most current referral/acceptance dates.

Enter an end date in MMDDYYYY format.

Sort Selection

The report data is sorted by contractor/employer. You can select how to sort the data within contractor/employer. A list of sort options is displayed, and you are asked to select one of the options.



   +----Select Sort-----+ 
   |  Last Name         | 
   |  Member ID         | 
   |  Employee Number   | 
   |  Dues Code         | 
   +--------------------+ 

Select one of the sort options from the menu.

Proceed

You are asked if you want to proceed with creating the members by employers report.



   +Proceed-+ 
   |  Yes   | 
   |  No    | 
   +--------+ 

Select "Yes" to generate the report.

Select "No" to return to the sort option prompt.

Press <ESC> to abort this report procedure.

If "Yes", the report is generated.

Report Example

The following is an example of part of a members by employer report for members and non-members:


30-Mar-2006  United Brotherhood of Carpenters and Joiners of America      Page 3 
                        Active Status Roster By Employer 
                              Members & Non-Members 
 
Employer: UBC01444 Donald R. Johnson Construction 
 
Member Name               Member ID       Employee Number  Paid Thru  Dues Code 
------------------------- --------------- ---------------  ---------- --------- 
Bauer, Tom                U-6431-2011                      11/30/2005 
                                      ** Traveler ** 
Board, Carl L             U-1933-0245                      02/28/2006 CTR_JOUR 
Cork, Casey               U-5690-1153                      02/28/2006 CTR_JOUR2 
Harper, Jess W            U-2000-3217                      03/31/2006 CTR_APP1 
Simmons, Jack T           U-1806-7747                      00/00/0000 
                                      ** Traveler ** 
 
   Total Members For Employer: UBC01444 JOHNSON -  5 


Chapter 43
ELIGRPT - Officer/Voter Election Eligibility



            +------------Inquiry/Report Procedures-------------+ 
            |                                                  | 
            |           Membership Inquiries/Reports           | 
            |  MEMINQ         Member Inquiry                   | 
            |  CONTACT        Member Inquiry by Contact Info   | 
            |  FINHIST        Member Financial History         | 
            |  MEMAFFINQ      Member Inquiry by Affiliate      | 
            |  DUESCODE       Members by Dues Code Report      | 
            |  ARRLTR         Arrears/Susp-Report/Letter/Lab   | 
            |  ACTIVITY       Membership Changes Activity      | 
            |  MEMBAL         Membership Balance Report        | 
            |  CLASSSUM       Membership Summary by Class      | 
            |  CRAFTSUM       Membership Summary by Craft      | 
            |  GENDERSUM      Membership Summary by Gender     | 
            |  MEMEMP         Members by Employer Report       | 
            |  ELIGRPT        Officer/Voter Election Eligibi   | 
            |  OFFELIG        Current Officer Eligibility      | 
            |  AVGAGE         Membership Average Age Report    | 
            |  MEMCOUNTY      Members by City/County Report    | 
            |  ARRSALERT      Membership Alert Inquiry         | 
            |  RETIRE         Retirement Eligibility Report    | 
            |  IDCARD         Print Member ID Card             | 
            |  IDROSTER       Member ID Roster                 | 
            |  PHOTO_REPORT   Member Photo Report              | 
            +--------------------------------------------------+ 

The ELIGRPT - Officer/Voter Election Eligibility menu option is used by affiliates to create reports of members who are eligible to vote, or who are eligible to be delegates and officers.

You select which members to include on the reports --- only eligible members or all members. If all members are selected, the reports show the reasons why members are not eligible to vote or to be delegates and officers.

The report data is sorted by member name.

This chapter explains how to create officer/voter eligibility reports.

43.1 Eligibility Reporting Input Screen

After ELIGRPT is selected from the menu, the eligibility reporting input screen is displayed.



 ULTRA     United Brotherhood of Carpenters and Joiners of America       (date) 
                                  Tucson Local                         UBC01444 
 
Affiliate ID : UBC01444 -- Tucson Local 
 
Report Option: 
 
Members      : 
 
 
 
 
 
 
 +----------Report Option-----------+ 
 |  Eligible to Vote                | 
 |  Eligible for Delegate/Officer   | 
 +----------------------------------+ 
 
<ESC>=Exit                    Eligibility Reporting          <F2>=Back <F1>=Help

43.2 Prompts and Responses

The following sections describe the prompts displayed when you create eligibility reports.

Affiliate ID

You are asked for the affiliate ID.

Note: If you are a local affiliate user, the affiliate ID and name are displayed, and this prompt is skipped.



 Affiliate ID? ________ 

If a default affiliate ID is provided and it is correct, you can press [Enter] to accept the default. Otherwise, enter the appropriate affiliate ID.

Note: If a council affiliate ID is entered, all the locals in the council will be included.

You can enter the affiliate number which is a number from 1 to 99999, or enter the entire affiliate ID.

After the affiliate ID is entered, the affiliate name is displayed.

Report Option

You are asked if you want to create a report of members eligible to vote or eligible to be delegates and officers.



   +----------Report Option-----------+ 
   |  Eligible to Vote                | 
   |  Eligible for Delegate/Officer   | 
   +----------------------------------+ 

Select one of the menu options.

Select Members

You are asked which members you want to include on the report.



   +----------Select----------+ 
   |  Only Eligible Members   | 
   |  All Members             | 
   +--------------------------+ 

Select "Only Eligible Members" to get a list of members who are eligible to vote or to be delegates and officers.

Select "All Members" to list all members, and their eligibility. If a member is not eligible, the reasons why they are not eligible are given.

Output Options

If you select the report option "Eligible to Vote", and select "Only Eligible Members", you can create a report of the members, labels and an export file.

You are asked for the output option.



   +------Output Option-------+ 
   |  Report                  | 
   |  Labels                  | 
   |  Export File             | 
   |--------------------------| 
   |  finished with outputs   | 
   +--------------------------+ 

Select "Report" to create a report.

Select "Labels" to create member labels.

Select "Export File" to create an export file.

Select "finished with outputs" to exit this procedure.

Proceed with Report

You are asked if you want to proceed with creating the eligibility report.



   +Proceed with Report+ 
   |  Yes              | 
   |  No               | 
   +-------------------+ 

Select "Yes" to proceed with report generation.

Select "No" to go back to the previous prompt.

Press <ESC> to abort this report procedure.

If "Yes", the eligibility report is generated.

Creating Labels

If you are creating labels, you are asked for the type of labels you want to create.



   +-------Type of Labels-------+ 
   |  1 Up                      | 
   |  1 Up (Avery 4013 label)   | 
   |  2 Up (Avery 5262 label)   | 
   |  3 Up (Avery 5160 label)   | 
   +----------------------------+ 

Select one of the label types.

Proceed with Creating Labels

You are asked if you want to proceed with creating member labels.



   +Proceed with Labels+ 
   |  Yes              | 
   |  No               | 
   +-------------------+ 

Select "Yes" to proceed with creating the labels.

Select "No" to go back to the previous prompt.

Press <ESC> to abort this procedure.

If "Yes", the member labels are created.

Creating an Export File

If you create an export file, the following message is displayed, and you can load the export file down to your PC.



      Export File USER:[TESTER.WWW]ELIGIBLE_TO_VOTE_20051108.TXT Created 
 
        Use Web Browser to Save to Your PC from the UBCJA.ORG Web Page 
        (File Name Will be Listed Under "Your Personal Download Files") 
 
                        Press the RETURN key to continue 

Press [Enter] to return to the output options prompt.

The information in the export file includes the following:


        Last Name 
        First Name 
        Initial 
        Suffix 
        Local 
        ID 
        Address1 
        Address2 
        City 
        State or Province 
        Zip or Postal Code 

43.2.1 Report Examples

The following is an example of a report listing members who are eligible to vote:


26-Oct-2002  United Brotherhood of Carpenters and Joiners of America      Page 1 
                            UBC01444 -- Tucson Local 
                 Active Status Membership Eligibility Reporting 
                                Eligible to Vote 
                        Eligible Members Only - UBC01444 
 
Member Name                 Member ID     Class        Status      Init Date 
--------------------------  ------------  -----------  ----------  ---------- 
Aimes, Art                  U-1201-9585   APPRENTIC2   GOODSTANDG  11/15/2000 
Allen, George               U-3766-6144   MEMBER       GOODSTANDG  01/02/2001 
Allenson, Bruce             U-6770-6739   MEMBER       GOODSTANDG  01/15/2001 
Appleby, Sam                U-7689-7132   APPRENTIC1   GOODSTANDG  03/20/2001 
Arnold, Edward J.           U-3770-7704   MEMBER       GOODSTANDG  12/15/2000 
Arnoldson, Ruth A.          U-8771-2850   MEMBER       GOODSTANDG  05/15/2001 
Bakerson, Sam               U-4770-7865   MEMBER       GOODSTANDG  12/15/2000 
Banks, Fred                 U-3689-2147   MEMBER       GOODSTANDG  06/01/1999 
Banks, Thomas X.            U-6760-9447   MEMBER       GOODSTANDG  08/15/2001 
Barker, Amos A.             U-5431-3297   APPRENTIC2   GOODSTANDG  05/07/2001 
Barringer, Robert           U-8771-1403   APPRENTIC2   GOODSTANDG  01/02/2001 
Base, Archie                U-2771-6228   50DISABLED   GOODSTANDG  06/15/2000 
Bates, Bryan                U-1770-4327   MEMBER       GOODSTANDG  06/01/2001 
Bean, Herbert J.            U-3009-1839   MEMBER       GOODSTANDG  10/07/1969 
Bird, Lenny J.              U-3767-0486   MEMBER       GOODSTANDG  06/15/2000 
Blackinger, Wallace         U-2689-6167   MEMBER       GOODSTANDG  11/10/2001 
Blow, Joe J.                U-8766-5661   APPRENTIC5   GOODSTANDG  04/01/2001 
. . . . . . 
 
                 UBC01444 -- Total Number Eligible     :      73 

The following is an example of part of a report showing members who are and who are not eligible to vote:


26-Oct-2002  United Brotherhood of Carpenters and Joiners of America      Page 1 
                            UBC01444 -- Tucson Local 
                 Active Status Membership Eligibility Reporting 
                                Eligible to Vote 
                             All Members - UBC01444 
 
Member Name                  Member ID     Eligibility 
---------------------------  ------------  ------------------------------------- 
Abbottson, Xenia             U-4770-3523   N  - Current Status ARREARS 
Acres, Jack S.               U-2770-7543   N  - Class WALKIN is non-voting 
Adams, James J.              U-3689-7936   N  - Current Status ARREARS 
                                           N  - Reinstated less than 12 Months 
Adamson, Bailey              U-5770-6579   N  - Current Status ARREARS 
Aimes, Art                   U-1201-9585   Y 
Allen, George                U-3766-6144   Y 
Allenson, Bruce              U-6770-6739   Y 
Appleby, Sam                 U-7689-7132   Y 
Arnold, Edward J.            U-3770-7704   Y 
Arnoldson, Ruth A.           U-8771-2850   Y 
August, Colby                U-5431-4744   N  - Current Status ARREARS 
                                           N  - Init 12/12/2001 not 12 Months 
Backer, Alex                 U-4771-5102   N  - Init 01/14/2002 not 12 Months 
Backer, Jim                  U-3688-9092   N  - Not Member of Affiliate 12 Mo 
Bacon, Jerry A.              U-2744-0843   N  - Override Set - Ineligible 
                                           N  - See Alert Notes 
. . . . . . . 
 
                 UBC01444 -- Total Number Eligible     :      73 
                 UBC01444 -- Total Number Not Eligible :      79 

The following is an example of a report listing members who are eligible to be delegates and officers:


26-Oct-2002  United Brotherhood of Carpenters and Joiners of America      Page 1 
                            UBC01444 -- Tucson Local 
                 Active Status Membership Eligibility Reporting 
                         Eligible For Delegate, Officer 
                        Eligible Members Only - UBC01444 
 
Member Name                 Member ID     Class        Status      Init Date 
--------------------------  ------------  -----------  ----------  ---------- 
Bean, Herbert J.            U-3009-1839   MEMBER       GOODSTANDG  10/07/1969 
Chilie, Lyle                U-7769-6769   MEMBER       GOODSTANDG  11/06/2000 
Cook, Sandy T.              U-4688-6519   MEMBER       GOODSTANDG  12/15/1997 
Iris, Jack                  U-4744-1165   MEMBER       GOODSTANDG  06/15/2000 
Smith, James W.             U-8474-4092   MEMBER       GOODSTANDG  07/05/1972 
 
                 UBC01444 -- Total Number Eligible     :       5 

The following is an example of part of a report showing members who are and who are not eligible to be delegates and officers:


26-Oct-2002  United Brotherhood of Carpenters and Joiners of America      Page 1 
                            UBC01444 -- Tucson Local 
                 Active Status Membership Eligibility Reporting 
                         Eligible For Delegate, Officer 
                             All Members - UBC01444 
 
Member Name                  Member ID     Eligibility 
---------------------------  ------------  ------------------------------------- 
Abbottson, Xenia             U-4770-3523   N  - Current Status ARREARS 
                                           N  - Init 01/15/2001 not 24 Months 
Acres, Jack S.               U-2770-7543   N  - WALKIN Ineligible for office 
Adams, James J.              U-3689-7936   N  - Current Status ARREARS 
                                           N  - Reinstated less than 24 Months 
Adamson, Bailey              U-5770-6579   N  - Current Status ARREARS 
                                           N  - Init 02/01/2001 not 24 Months 
Aimes, Art                   U-1201-9585   N  - APPRENTIC2 Ineligible for office 
Allen, George                U-3766-6144   N  - Init 01/02/2001 not 24 Months 
Allenson, Bruce              U-6770-6739   N  - Init 01/15/2001 not 24 Months 
                                           N  - Not Goodstanding for 12 Months 
Appleby, Sam                 U-7689-7132   N  - APPRENTIC1 Ineligible for office 
                                           N  - Init 03/20/2001 not 24 Months 
                                           N  - Reinstated less than 24 Months 
Arnold, Edward J.            U-3770-7704   N  - Init 12/15/2000 not 24 Months 
Arnoldson, Ruth A.           U-8771-2850   N  - Init 05/15/2001 not 24 Months 
                                           N  - Not Goodstanding for 12 Months 
. . . . . . . 
 
                 UBC01444 -- Total Number Eligible     :       5 
                 UBC01444 -- Total Number Not Eligible :     147 


Previous Next Contents Index