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


Previous Contents Index


Chapter 53
AFFINQ - Affiliate Inquiry

The UBCJA system allows you to inquire on/review affiliate data. When you inquire on an affiliate, you can also:

You can inquire on/review affiliate data by selecting the AFFINQ option on the inquiry procedures menu.



            +------------Inquiry/Report Procedures-------------+ 
            |                                                  | 
            |           Membership Inquiries/Reports           | 
            |  ...                                             | 
            |                                                  | 
            |             Other Inquiries/Reports              | 
            |  BILLTRANS      Billing Transaction Inquiry      | 
            |  AFFINQ         Affiliate Inquiry                | 
            |  AFFROSTER      Member Roster with Address       | 
            |  SUMAFFINQ      Summary Affiliate Inquiry        | 
            |  OPTIONS        Reports, Letters, Labels         | 
            |  MEMLTRLAB      Member Letters and Labels        | 
            |  DAYBOOK        Day Book Report                  | 
            |  TRSTEEDB       Trustee Day Book                 | 
            |  CHRGPAY        Charges & Payments Report        | 
            |  FUNDALLOC      Dues Fund Allocation Report      | 
            |  QTRFUNDALLOC   Quarterly Dues Fund Allocation   | 
            |  PERMITSINQ     Traveler Inquiry                 | 
            |  PRINTOBLIFORM  Reprint Obligation Form          | 
            |  EMPBILL        Employer Billing for Dues        | 
            |  DUESPAID       Dues Paid Statement Letters      | 
            |  ESTDELEGATE    Convention Delegate Estimate R   | 
            |  AFFREPLAB      Affiliate Report and Labels      | 
            |  FINADJUST      Financial Adjustments Report     | 
            |  10YRSTATS      10-Year Statistics Report        | 
            |  12MOSTATS      12-Month Active Membership       | 
            |  GROWTH         Growth Reporting                 | 
            |  CERTIFICATE    Delegate Goodstanding Certific   | 
            |  USERAUDIT      User Audit Report                | 
            |  LM2_REPORT     LM2 Report                       | 
            +--------------------------------------------------+ 

This chapter describes the affiliate inquiry procedure and options.

53.1 Affiliate Inquiry Screens

After you select AFFINQ from the menu, the first of two "affiliate inquiry" screens is displayed.



 ULTRA     United Brotherhood of Carpenters and Joiners of America       (date) 
                         Arizona State District Council                UBC04003 
 
Aff ID : 
Cust Nm: 
Status :               Date:              Level:             Type: 
Council:           District:            Members:        Chartered: 
General:                           Charter Type: 
 
AFFILIATE ADDRESS: 
Street :                                   City: 
State  :            Country:                Zip: 
County : 
 
Meeting:                                  Dates: 
 
Phone  :                Alt:                Fax: 
 
Tax Sch:           Init Fee:          Cntr Dues:         Checkoff: 
Beck % :        Econ Growth:              Cycle:         Stm Type: 
Elect'n:               Term:           Emp Acct: 
Bond Rp:             Amount:                           Net Assets: 
Process:         ULTRA Date:              Juris:         Branches: 
 
 
 
Affiliate ID? UBC04003 
 
 
<ESC>=Exit                      AFFILIATE INQUIRY            <F2>=Back <F1>=Help

53.2 Displaying Affiliate Data

After the first affiliate inquiry screen is displayed, you provide the affiliate ID of the affiliate you want to inquire on.

Affiliate ID

You are asked for the affiliate ID.



 Affiliate ID? ________ 

The affiliate ID is required. The affiliate must exist in the affiliate file.

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

After the affiliate ID is entered, the first screen of affiliate data is displayed.

Note: Only general information such as address, phone, officers, etc., is displayed for affiliates that you do NOT have access to.



 ULTRA     United Brotherhood of Carpenters and Joiners of America       (date) 
                         Arizona State District Council                UBC04003 
 
Aff ID : UBC01444 -- Tucson Eastside 
Cust Nm: Tucson Eastside 
Status : ACTIVE        Date: 03/20/2006   Level: LOCAL       Type: REGULAR 
Council: UBC04003  District: WST        Members: Y      Chartered: 03/20/2006 
General: CONSTRUCTION              Charter Type: CARPENTER 
 
AFFILIATE ADDRESS: 
Street : 10000 Speedway                    City: Tucson 
State  : AZ         Country: UNITED STATES  Zip: 85749 
County : PIMA 
 
Meeting: Main Hall                        Dates: 2nd Weds of month 
 
Phone  : (520) 555-4441 Alt: (520) 555-1455 Fax: (520) 555-1466 
 
Tax Sch: 001       Init Fee: 200.00   Cntr Dues:         Checkoff: 
Beck % : 25%    Econ Growth:              Cycle: EOM     Stm Type: REG 
Elect'n:               Term:           Emp Acct: 
Bond Rp: 01/01/2007  Amount:                           Net Assets: 
Process: ULTRA   ULTRA Date: 02/28/2006   Juris: N       Branches: 
 
 
+------------------------------------------------------------------------------+ 
|  Next Screen    Next Affiliate    Statistics    Notes    Officers          >>| 
+------------------------------------------------------------------------------+ 
 
<ESC>=Exit                      AFFILIATE INQUIRY            <F2>=Back <F1>=Help

Note: If the affiliate is a consolidated affiliate, the "legal consolidate date" is displayed. For example:



Aff ID : UBC00857 -- Tucson, AZ 
Cust Nm: 
Status : CONSOLIDAT    Date: 06/01/1994   Level: LOCAL       Type: REGULAR 
Council: UBC04003  District: WST        Members: N      Chartered: 
General: CONSTRUCTION              Charter Type: CARPENTER 
                         Legal Consolidate Date: 06/01/1994 
. . . . . 

Second Screen

To display the second screen of affiliate data, select the "Next Screen" option from the menu bar at the bottom of the screen.



 ULTRA     United Brotherhood of Carpenters and Joiners of America       (date) 
                         Arizona State District Council                UBC04003 
 
Origin : UBC  Aff Num: 01444 
                 Name: Tucson Eastside 
OFFICER MAIL: 
Street : 10000 Speedway                    City: Tucson 
State  : AZ         Country: UNITED STATES  Zip: 85749 
 
DELIVERY ADDRESS: 
Street : 10000 Speedway                    City: Tucson 
State  : AZ         Country: UNITED STATES  Zip: 85749 
 
E-mail Address: 
Web Site      : 
Charter Name  : Local 1444 Tucson Eastside 
New Local Elig: Y   Photo ID Required: Y   Uses Restricted Skill Codes: Y 
         Can Use ITC/TRAIN Skill Data: Y     Non-ITC Skill Expire Days: 60 
 
 
 
 
 
+------------------------------------------------------------------------------+ 
|  Prev Screen    Next Affiliate    Statistics    Notes    Officers          >>| 
+------------------------------------------------------------------------------+ 
 
<ESC>=Exit                      AFFILIATE INQUIRY            <F2>=Back <F1>=Help

To go back to the first screen, select the "Prev Screen" option from the menu bar at the bottom of the screen.

53.3 Inquiry Options

When the affiliate's data is displayed, a bar menu appears at the bottom of the screen. This menu shows the different actions you can take. For example, you can display affiliate membership statistics, notes, review officer information, etc.

Not all of the menu options appear in the menu bar. To see the options that are not shown, press the right arrow key several times to move the cursor through the menu options toward the ">>" symbol.



+------------------------------------------------------------------------------+ 
|  Next Screen    Next Affiliate    Statistics    Notes    Officers          >>| 
+------------------------------------------------------------------------------+ 

When the ">>" disappears, all options have been displayed.



+------------------------------------------------------------------------------+ 
|<<  Statistics    Notes    Officers    Dispensation    Branches    Exit       | 
+------------------------------------------------------------------------------+ 

Use the left arrow to move toward the "<<" symbol to see the options not shown.

Next Affiliate and Exit

Select "Next Affiliate" to erase the current affiliate display, and get back to the affiliate ID prompt.

Note: Local users can only display affiliate information for their own local.



+------------------------------------------------------------------------------+ 
|  Next Screen    Next Affiliate    Statistics    . . . .    Branches    Exit  | 
+------------------------------------------------------------------------------+ 

Select "Exit" to exit out of the inquiry procedure and return to the inquiry procedures menu.

The following sections describe each of the other bar menu selections.

53.3.1 Statistics



+------------------------------------------------------------------------------+ 
|  Next Screen    Next Affiliate    Statistics    Notes    Officers          >>| 
+------------------------------------------------------------------------------+ 

The "Statistics" option is used to create a summary report of active members by class.

When "Statistics" is selected, you are placed into the procedure that creates the class summary report. You can then answer the prompts and generate a report. For detailed information on this report, refer to Chapter 39, CLASSSUM - Membership Summary by Class.

The following is an example of a membership summary by class report.


21-Jul-1999  United Brotherhood of Carpenters and Joiners of America      Page 1 
                      Active Status Roster as of 11/30/1997 
                               Summarized by Local 
                                 Sorted by Local 
 
                                                   Good- 
Dt Council  Aff ID   Classification              stnding Arrears Trnsfer   Total 
-- -------- -------- --------------------------- ------- ------- ------- ------- 
08 UBC04003 UBC01444 Membership Applicant            139       0       0     139 
                     Apprentice                      213      73       2     288 
                     Disabled Member                   1       0       0       1 
                     Early Retired                    89       3       0      92 
                     50 Yr Honorary Member           237       0       0     237 
                     Member - Regular              1,015     296       6   1,317 
                     Pre-apprentice                   17       5       0      22 
                     Retired Member                  427      10       0     437 
                                                 ======= ======= ======= ======= 
                            Local UBC01444 total   2,138     387       8   2,533 
 
                                                 ======= ======= ======= ======= 
                                                 ======= ======= ======= ======= 
                                     Grand total   2,138     387       8   2,533 

53.3.2 Affiliate Notes



+------------------------------------------------------------------------------+ 
|  Next Screen    Next Affiliate    Statistics    Notes    Officers          >>| 
+------------------------------------------------------------------------------+ 

The "Notes" option displays affiliate notes. When "Notes" is selected, the following screen is displayed:



 ULTRA     United Brotherhood of Carpenters and Joiners of America       (date) 
                         Arizona State District Council                UBC04003 
 
Aff ID : UBC01444 -- Tucson Local 
Cust Nm: Greater Tucson Local 1444 
Notes begin date : 
Notes ending date: 
 
 
 
 
 
 
Notes begin date (MMDDYYYY)? First___ 
 
 
<ESC>=Exit                      AFFILIATE INQUIRY            <F2>=Back <F1>=Help

Notes Begin Date

You have to specify which affiliate notes you want to see. You can display all of this affiliate's notes, or display notes for a specific period of time. For example, you might want to see notes for the period 01/01/1998 through 06/01/1998.

After the "Notes" screen is displayed, you are asked for the notes begin date.



 Notes begin date (MMDDYYYY)? First___ 

You can:

  1. Enter "First" to start the display with the oldest note.
  2. Enter a begin date in the format of MMDDYYYY. This displays notes dated the same date you enter, or having a date after the entered date.

Notes End Date

After you enter the notes begin date, you are asked for the end date.



 Notes ending date (MMDDYYYY)? Last____ 

You can:

  1. Enter "Last" to end the display with the most current note.
  2. Enter an ending date in the format of MMDDYYYY. This displays notes starting with the begin date through the end date you enter.

Proceed

You are asked if you want to proceed with the affiliate notes display.



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

Select "Yes" to start displaying the affiliate notes.

Select "No" to go back to the ending date prompt.

Press <ESC> to skip the notes display and return to the display of affiliate data.

Displaying Notes

If no affiliate notes are found for the date range you entered, the message:


                  No notes found for affiliate affiliate ID

is displayed. If affiliate notes are found, they are displayed. For example:



 ULTRA     United Brotherhood of Carpenters and Joiners of America       (date) 
                         Arizona State District Council                UBC04003 
 
Aff ID : UBC01444 -- Tucson Local 
Cust Nm: Greater Tucson Local 1444 
Notes begin date : First 
Notes ending date: Last 
 
1) Wednesday Jan 7, 1998 08:48 PM TTI MEETING: UNION HALL 2ND WEDNESDAY 7PM 
2) Wednesday Jan 7, 1998 08:48 PM TTI NOTE: DISP 10/15/97 COMBINE FS/TREAS 
 
 
 
 
 
 
+------------------------------------------------------------------------------+ 
|  Exit                                                                        | 
+------------------------------------------------------------------------------+ 
 
<ESC>=Exit                      AFFILIATE INQUIRY            <F2>=Back <F1>=Help

During the notes display, you can select any of the options shown in the menu bar at the bottom of the screen. One, two or three options are provided depending on the number of screens of affiliate notes.

Select "Next" to display the next screen of notes. If "Next" is displayed in the menu bar, there is at least one more screen of affiliate notes.

Select "Prev" to display the previous screen of notes. If "Prev" is displayed in the menu bar, there were at least two screens of notes.

Select "Exit" when you have completed the notes review. "Exit" takes you back to the affiliate data display.

53.3.3 Officers



+------------------------------------------------------------------------------+ 
|  Next Screen    Next Affiliate    Statistics    Notes    Officers          >>| 
+------------------------------------------------------------------------------+ 

The "Officers" option displays officer information for this affiliate.

When "Officers" is selected, the officer inquiry screen is displayed, and you select the officer codes you want to inquiry on. For detailed information on officer inquiries, refer to Chapter 145, OFFINQ - Officer Inquiry.

After the officer inquiry is completed, you are returned to the affiliate display screen.

53.3.4 Dispensation



+------------------------------------------------------------------------------+ 
|<<  Statistics    Notes    Officers    Dispensation    Branches    Exit       | 
+------------------------------------------------------------------------------+ 

The "Dispensation" option displays dispensation information for an affiliate (if there has been any dispensations).

When the "Dispensation" option is selected, the following data is displayed:


14-Jan-1998  United Brotherhood of Carpenters and Joiners of America      Page 1 
                     Dispensation Inquiry - 2 Records Found 
                         All Dispensations for Affiliate 
 
UBC01444 Tucson Local              666-66-0905 Flags, Steve M 
  Type: TAXSCHED - Tax Schedule Change                    *PENDING* 
  Requested: 01-08-1998   by: TESTER       Amount: 0.00 
 
UBC01444 Tucson Local              666-66-3947 Soto, William 
  Type: TINEXP - Transfer Expired 
  Requested: 01-08-1998   by: TESTER       Amount: 0.00 
  *APPROVED* 01-08-1998   by: TESTER       Effective: 10-01-1997 thru 02-01-1998 

53.3.5 Affiliate Branches



+------------------------------------------------------------------------------+ 
|<<  Statistics    Notes    Officers    Dispensation    Branches    Exit       | 
+------------------------------------------------------------------------------+ 

If an affiliate has branches, you can display branch information by selecting the "Branches" option. If the affiliate does NOT have branches, "Branches" is NOT shown as an option on the bar menu.

After "Branches" is selected, the branch information is displayed. For example:



                ID                  Branch Information              
             MAIN_OFF Tucson Local - Main Office 
                      123 N. Wilmot 
                      Tucson, AZ 85712 
                      (520) 555-6567 
 
             NOTUCSON North Tucson 
                      9834 N. Craycroft 
                      Tucson, AZ 85730 
                      (520) 555-8159 
 
             SOTUCSON South Tucson 
                      556 S. Tucson Blvd. 
                      Tucson, AZ 85727 
                      (520) 555-8765 


Previous Next Contents Index