|
| |
AUXINFO
What is AUXINFO?
AUXINFO is a source where any member can to obtain information
on the Auxiliary. It is a web based means where data is taken from
AUXDATA (the Auxiliary data system) and presented in a meaningful,
understandable, graphic way through the use of "cubes".
How do I access AUXINFO?
You may enter AUXINFO via the internet at
http://www.auxinfo.uscg.gov. No
password is required. See the Training Tools
section below for sources to learn more about AUXINFO. Some
Pre-formatted reports are available.
Helpful hints about using the AUXINFO page are also shown
below.
Where Do I Find What I Need?
In AUXINFO, in the AUDATA Cubes, you will find most of the data that is input
into AUXDATA. It is updated every Sunday.
-
The AWARDS Cube contains the number and type awards issued to members.
All of your awards may not show up if you earned them years ago. So check yours
out and if you are missing any, work with your DSO-IS to get them in the system.
-
The DEMOGRAPHICS Cube contains profile information for all regions and
units showing age groups, genders, and ethnicity.
-
The MEMBER ACTIVITIES Cube will be the most used to find out if all of
your hours are showing up. Reports may be run by Area, District, Division,
Flotilla, Member, or by Resource, showing the total hours or total missions, the
number of VSCs performed, or the number of
PVs performed. This data is
available by calendar year, fiscal year, quarter, month, week, or day. Just
remember that the system takes your date and time of mission and converts it to
Zulu or Greenwich mean time so the dates may be different by one day. Helpful
Hints: You must remember when first opened, the data displayed is for the number
of hours spent in the missions. To see the number of VSCs performed, you must
click on the "Mission Hours" button and select a "measure" from the pop up menu,
"Vessel Safety Checks Count." Other "measures" such as "Marine Dealer Visits
Count", "ATON Aids Verified", "SAR - Persons Assisted" and "Commercial Fishing
Vessel Exams" can also be selected.
-
From the UNIT ACTIVITIES Cube you may obtain the same information as the
Member Activities Cube with the exception that it only goes down to Unit level
and not by member. The major difference here is that only the lead hours from
each mission are included in the totals where in the Member Activity Cube ALL
hours are included in the totals. Again, remember to select the proper "measure"
so as to present the data you desire. (Hours or Count.)
-
There is an UPDATE NOTIFICATIONS Cube, which shows the date of the last
update.
-
The COMPETENCIES Cube contains information by Resource (Air, Boat,
General, or Unit.) Under Air, you will find all who have air certifications.
Under Boat, you will find ATON Technicians, Aid Verifiers, Coxswain, Crew, and
PWC Operators.
-
Under General, there are items listed that are all found in other areas.
-
Under Unit you will find APC, (it is nearing election time and this will be one
point you will need to check.)
-
You can find those who are AUXOP, some workshops are appearing here but
they are not complete. Workshops are found under Tasks.
-
The FACILITIES Cube - has Units, Radios, Boats, and Aircraft. Under the
Units, it will tell you how many Districts, Divisions, and Flotillas there are.
The other Resources (Radios, Boats, and Aircraft) are listed by type down to
flotilla level.
-
The TASKS Cube includes Currency Maintenance which shows the required
annual air and boat tasks including the Operations Workshop.
-
General Training is not valid at this time.
-
The Initial Qualification has all the qualifications obtained from the open book
tests.
-
Pilot Tasks/Competencies has all of the pilot information.
-
Professional Development has the APC course, all of the Specialty
courses, Leadership courses, Good Mate Course, and ICS 100, 200, and 300.
-
Workshops has all of the workshops taken.
-
The UNIT LOCATION Cube gives the addresses or cities of all units in the
Auxiliary. May be interesting if you plan to visit new areas.
Pre-formatted Reports
Frequently used District
reports and Division reports have been pre-formatted. More types of Pre-Formatted reports can be found at the
Chief Director’s (G-OCX) web page. Select 8WR region to view our district. By
“drilling down” you can also view your division, flotilla or individual member.
USCG G-OCX Web Site - AUXDATA Preformatted Report
About the Report
Page
The general appearance of a report page is
shown below.
Zero suppression has been turned on for each
report. In some cases that might prevent some names from being listed. To turn
off this field, click on the
 button
at the bottom of the page. To turn the Zero Suppression back on, click on the
button
again. Note - If you turn zero suppression off on the awards screen, it will
include blank columns from 2007 back to 1949. That is why it has been
turned on!
To make the report so that the items across
the top are down the side and the items down the side are across the top click
on
 Swap
Axis button at the bottom of the page. (This button swaps rows and columns.)
Reports are formatted for on-line
information.
To Print a
report:
- Click on the
 button
(when you move your mouse over this icon a Screen Tip message will drop down
identifying the icon as "File");
- After selecting the icon a drop down
window will appear which provides "Export" options for the type of software in
which you may open the report - PDF is opens in Adobe Acrobat, CSV is Comma
Separated Value which opens in MS Excel and XLS is the MS Excel extension and
will open in MS Excel
- Click on your software choice and the
report will open in the respective software
- As indicated above, both CSV and XLS
open in MS Excel. Suggest selecting XLS rather than CSV as the the
cells fill-in without need for adjustment when using the XLS option;
- If PDF is selected a window will open
titled Export PDF which allows you to select an Orientation (Portrait or
Landscape) and Paper Size. Make your selection then click on the Apply
button then the Export button and your report should appear as an
Adobe Acrobat document.
- Print from the document in the same
manner as you would any other Adobe Acrobat PDF file.
An AUXDATA/AUXINFO Elected Officers PowerPoint
is available from the
T-Department Value Added Training page located at
http://www.auxtdept.org/Members.htm
. The
presentation is a simplified explanation of the AUXDATA/AUXINFO systems and the
reports that can be generated. The direct link to the presentation is
http://www.auxtdept.org/PDF/AUXDATA_AUXINFO_2007.ppt
The above notes will help get you started.
Have fun!
|
