G081 User s Manual UNITED STATES AIR FORCE HEADQUARTERS AIR MOBILITY COMMAND LOGISTICS INTEGRATION SCOTT AFB, ILLINOIS 62225

Transcription

1 G081 User s Manual UNITED STATES AIR FORCE HEADQUARTERS AIR MOBILITY COMMAND LOGISTICS INTEGRATION SCOTT AFB, ILLINOIS Analysis 12 June 2019

2 Preface The nature of the Mobility Air Force (MAF) mission demands a high level of performance. Our ability to effectively manage the rapid and safe movement of people, equipment, and supplies on a global scale is the primary catalyst that sustains the United States military forces as the best in the world. A significant element of our ability to accomplish this mission is the high caliber of people within MAF and the level of training and preparation they receive. Several years ago, during a G081 user conference, the need to improve Web G081/Mobility Air Force Logistics Command & Control (Web G081/MAF LOG C2) Maintenance Management Information System (MIS) training was expressed. To that end, HQ AMC/A4PI, took on the task to have all the G081 User Training Manuals revised. Since the completion of that revision, as programs have been updated and changed, the User Manuals have also been kept current with the new processes. Now, with the migration of G081 to a completely web-based environment, once again we are fielding a major revision of the User Manuals to accurately reflect new program views and changes to processes where needed. This User s Manual is designed to help you learn how to process the Web G081 programs pertinent to your job and then serve as a reference tool as you go through the daily routine of entering and extracting data. The manuals provide you with general information such as creating passwords, logging on to the system, getting help and entering data. After you have developed an understanding of the system basics, look through the various programs. You will see that each one is described in detail to help you collect and organize the data needed to process the different tasks that you ll be completing. Web G081 is a very broad program with many variables. It was designed that way because of the unique documentation needs of the various aircraft types within AMC. Due to this flexibility, special coding is required in order for Web G081 to understand exactly what you are trying to do. To accomplish this, the writers have broken the programs down to their most basic level, showing a step-by-step method for filling in the data fields for each one. Program instructions in this manual depict the default mode of operation for Web G081. The basic system requirements for each program are shown with examples to help readers understand how to properly format the data. The exact application in your activity may be slightly different due to local programming and protocol. ii

3 Table of Contents Table of Content iii CHAPTER 1 8 Introduction INTRODUCTION TO WEB G081/MAF LOG C2 9 What Is Web G081? What Part Do I Play? How Does The G081 System Work? System Security How Do I Learn To Use Web G081? CHAPTER Series Programs PROGRAM Maintenance Failures by WUC/REFDES PROGRAM MDC Work Unit Code Analysis PROGRAM In-Flight Engine Shutdown PROGRAM Operational Status of All Aircraft at a Given Base PROGRAM Bench Check Analysis Summary for a WUC PROGRAM Detail Aircraft Status Report PROGRAM Discrepancy Report CHAPTER Series Program iii

4 PROGRAM Process Requests For Supply (SBSS) How to Order a Part (Initial Issue Request) Backordering MICAP 57 Mission Capable Part What is a MICAP? When Can I Initiate A MICAP? How Can I Satisfy A MICAP Condition? How Can I Use a Cannibalization Action To Prevent A MICAP? How Can I Terminate A MICAP Condition With A Cannibalization? What Computer Actions Will I Take To Complete The Cannibalization/ MICAP Process? To Upgrade a MICAP PROGRAM Job Estimates PROGRAM Monthly Aircraft Status Summary PROGRAM 9025B 66 Aircraft Utilization Data PROGRAM 9032C 69 Repeat/Recur Discrepancy Batch Request (67089) PROGRAM Maintenance Summary by System PROGRAM MDC Inquiry/Delete Utility PROGRAM 9058/ Shop Batch Job/FOCUS Report Update and Execution PROGRAM User Printer Change PROGRAM Deployed Aircraft Information iv

5 PROGRAM Mass Deployment/Undeployment Form PROGRAM DIT MDC / Error Correction PROGRAM Supervisor MDC Review / Error Correction CHAPTER Batch Programs BATCH PROGRAMS 114 Why Can't I Just Process The Report Back To My Screen? What Will This Chapter Do For Me? Processing Batch Programs PROGRAM 9058/ Shop Batch Job/FOCUS Report Update and Execution PROGRAM A/C Departure Delay List Program PROGRAM Workload Distribution Histograms PROGRAM Highest Failing Rate Work Unit Code/Reference Designators PROGRAM Aircraft Possessed Hour Distribution PROGRAM Monthly A/C Status Summary PROGRAM NRTS /Base Self Sufficiency Report (Summary or Detailed) PROGRAM Database Search v

6 PROGRAM Aircraft Flying Hours PROGRAM Maintenance Data Collection (MDC) Work Summary Reports PROGRAM REFDES Analysis Report On Current MDC Data PROGRAM Supply Information Request PROGRAM Lists Database Schemas PROGRAM Base/Aircraft Commitment Rate Report PROGRAM Units and Labor Actions PROGRAM High 25 Hours/Failures By Work Unit Code PROGRAM Maintenance Summary by System PROGRAM Aircraft Status By WUC PROGRAM Debrief Reports PROGRAM (9032C) 200 Possible Repeat/Recur Discrepancies PROGRAM Operational Status by Base/Fleet PROGRAM Monthly MDC Transaction History vi

7 PROGRAM Work Unit Code Removal and Failure Summary PROGRAM WUC/REFDES Analysis PROGRAM Open Supply for Completed Job GLOSSARY 218 Terms and Abbreviations GLOSSARY OF TERMS AND ABBREVIATIONS 219 If you have suggestions for improving any of the G081 manuals or if you note any errors, please the Field Support Team at Remember any problems with G081 programs must be addressed through your local G081 Manager/Analysis office. vii

8 CHAPTER 1 Introduction 8

9 Introduction to Web G081/MAF LOG C2 MAF Logistics C2 System What Is Web G081? Web G081/Mobility Air Force Logistics (MAF) Command & Control (C2) System is used to manage and document maintenance activities and processes exclusively for MAF assets. Maintenance information on C-5, C-17, C-40 C-130, HH-60, KC-10, KC-46A and KC-135 aircraft is fed to Air Force Materiel Command (AFMC) via WebG081 to aid in making fleet management decisions. The system is currently used by over 30,000 Air Force personnel & contractors worldwide. Initially developed during the late 1970s and early 1980s as an enhancement to the C-5 Malfunction, Detection, Analysis, and Recording System (MADARS), Web G081 has evolved to a universal system which provides real-time aircraft status, tracks component failure trends, and develops statistical records for analysis. Although the Web G081 system was initially developed to track aircraft status and provide a resource for Maintenance Data Collection (MDC), it has been adapted to aid in supply, training, and personnel management. Web G081 is key to the reliability, sustainability, and deployment capability of the nation's mobility fleet in support of both MAF and the United States Transportation Command (USTRANSCOM) mission. Additionally, data from Web G081 is provided to other organizations such as Air Logistics Centers (ALC), where it is integrated with data from the Reliability and Maintainability Information System (REMIS) and other systems to develop a picture of overall weapons system status. Interfaces between the various systems linked to Web G081 make it possible for the data you input to be used in a very wide application. One of the most important data-sharing components is the MAF C2 system called Global Decision Support System (GDSS). Other interfaces include Air Force Standard Base Supply System (SBSS), ADEM (C17 engine), and CEMS. The Global Reach (GR) webpage allows for easy retrieval of data in a variety of reports. The GR website is updated at various times throughout each day with most data available in near real time (0-15 minutes following Web G081 update). Some reports (to name a few) are: Generation Report, Availability Report, Commander s Summary, Situational Awareness, Training Status, and Aircraft Status Sheet. For a complete list of available reports go to the GR page at: What Part Do I Play? In any system of record keeping, the accuracy of the data introduced to the system will dictate the reliability of the information produced as a final product. In the case of Web G081, that responsibility rests squarely on the shoulders of the technicians who perform the hundreds of tasks associated with operating and maintaining the world's largest and most capable air transport fleet. Every day, as you complete a job, order parts, document 9

10 a flight, or begin a repair action, you input several pieces of information to the system. These pieces of information are added to similar inputs from everyone all over the world to create a composite data base that can be used to do many things from predicting component failure to planning a mobilization. The validity of the decisions made by individuals using Web G081 is dependent upon how well you complete your part of the mission. By inputting accurate and timely data, you will continually increase the capability of planners to develop war-winning strategies and aid logisticians in buying better aircraft, parts and support equipment. There are over 7 million transactions a month in Web G081. How Does The G081 System Work? The Web G081 system is physically located at DISA Oklahoma City, Tinker AFB, OK. It is accessed via a cluster of load balanced web servers. In order to access the system, users must establish a connection to the server via the web link: Users must have a valid user identification (ID) and password prior to logging on to the system. This authorization is established by submitting a properly filled out DD Form 2875 to their local G081 Managers. Types of Programs There are five ways in which you will typically interface with Web G081. All of them use a similar process for accessing the system, which is detailed in the WEBG081 INITIAL TRAINING quick guide located on Global Reach under G081 Training Manuals. Prior to actually using the system, it is important to understand what each of these programs are and what they do for you. Batch Programs -Batch programs (67XXX series) generate reports on paper or text file which provide you with specific data on fields that you select. For example, if you were asked to prepare a report of all repeat and recurring discrepancies against the aircraft in your squadron, you could run Program and Web G081 would provide it for you. Commanders, managers, and supervisors typically use batch reports to review status, manage assets, allocate resources, and assist in management decisions. The G081 Manager grants you access to execute certain 67XXX programs pertinent to your functional area. Info-Assist+ -Info-Assist+ is a report writing program used by local G081 Managers to extract information custom-tailored to your specific needs. These reports provide a valuable tool for managers at all levels. Output Programs -Output programs (8XXX series) are similar to batch reports; however, information is entered through formatted screens and processed on-line. Although these screens provide valuable information to managers and supervisors, they are also beneficial to all G081 users by allowing them to check previously input actions. 10

11 Input/Update Programs -Input/Update programs (9XXX series) are the heart of the system. They make updates to the database. Most of the input data is provided by maintenance personnel based on completed maintenance actions. It is CRITICAL that everyone using the system ensure the ACCURACY of the data being entered. Management decisions at all levels rely on valid and timely data. Help Screens -Help screens have been developed to assist you by making the system more user-friendly. A detailed explanation of these tools can be found in the WEBG081 INITIAL TRAINING quick guide located on Global Reach under G081 Training Manuals. System Security Security of the G081 system is the responsibility of all personnel. The Web G081 system is not authorized to process or transmit classified data. A Common Access Card (CAC) issued by the users assigned organization, a USERID provided by the local G081 Manager and a password, are required to log into the system for the initial sign in. After the initial login users must enable their CAC to allow logging to G081. Users who solely access Web G081 using their CAC will only require their assigned PIN to log-in once they link their Web G081 account to their CAC card. This process is detailed in the REGISTERING YOUR CAC CARD FOR WEBG081 AND GR quick guide located on Global Reach under G081 Training Manuals. Users must safeguard their CAC card and the PIN to ensure they are not compromised. Individuals must coordinate through their local G081 Manager when they are reassigned or change positions where access is not required or their requirements for access have changed. Any user, through their G081 Management office, may submit changes or suggestions for improvements to the G081 system. Program F9038 (usage restricted to G081 Managers), which is an automated version of Oklahoma City (OC) ALC Form 529, System Deficiency Report, allows reporting of any deficiencies in software or documentation. The reports you send are logged, analyzed, and appropriate action taken. Users can review previously submitted request on the Global Reach website under the Analysis link. Deficiency reports, which affect all users of the system, automatically print to all Analysis Sections to allow on-line review and comments. HQ AMC/A4PM is the Office of Collateral Responsibility (OCR) and HQ AMC/A4PI is the Office of Primary Responsibility (OPR) for management of the deficiency reporting program. How Do I Learn To Use Web G081? Normally, a functional area of a squadron, such as DEBRIEF or MOC, will have a set of programs corresponding with the tasks falling under the respective functional area. The G081 USER S MANUALs have been designed as learning tools and references specifically for personnel that will update or run inquiries using Web G081 in their specific 11

12 functional area. In addition to serving as a reference, they are training tools that will help you gain an expert knowledge of Web G081 data management in your area of responsibility. It is the responsibility of each individual supervisor to ensure their trainees receive the necessary required training. The G081 USER S MANUAL collection serves as the central focus for training. In them, you will find step-by-step guidance on processing the many programs/screens associated with your functional area. Information contained in these manuals will assist you from initial system run-up to processing complex batch reports. In addition to the manuals, a G081 Training Team assigned to HQ AMC/A4PI at Scott AFB, IL is available to provide on-site, shop level training. Training visits can be requested through your local G081 Manager to have the team provide hands-on instruction at your unit. The training provided is fully funded at the AMC level and provided at no cost to the unit. Information on availability and scheduling is located on the G081 Community SharePoint. 12

13 CHAPTER Series Programs 13

14 Program 8003 Maintenance Failures by WUC/REFDES Purpose The program provides maintenance and failure data for specific Work Unit Codes (WUC) for a period of from 1 to 6 months. It lists detailed records by How Malfunction (HM) Code. It then breaks the data down by Action Taken (AT) Codes starting with the most recent occurrence and going back however many months requested. Program 8004 does not sort by Action Taken. If information on anything other than C-5 or C-141 aircraft is needed, Program 8004 must be used. Input Instructions Once you access the G081 system, select F8003 Maintenance Failures by WUC/REFDES from the Program Listing page. You can also enter 8003 or F8003 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 8003 Screen 14

15 FIELD EXPLANATION Note: You may use the same inputs to process Program 8003 or Program This is the 2- to 10-position Work Unit Code (WUC) or Reference Designator (REFDES) you are processing the report for. Select an WUC/REFDES option from the menu by clicking the WUC/REFDES icon or use the appropriate -06 manual to enter it manually. Base Code This is the 4-position Base code or the 3-position command. If left blank, all Bases will be selected. See Program 8007 for a list of Base codes. Select an option from the menu by clicking the Base Code icon or enter it manually. The Span code allows you to select the Span of the months. Select an option from the drop-down menu or enter it manually. Month Span # Of Months Offshore MDS A/C Wkctr CMD Code 1 - Full calendar months 2 - Date to date months 3 - Calendar months with current month This is the number of Months of data you wish to display. Select a number from 1 to 6 for the Months. Select an option from the # Of Months drop-down menu or enter it manually. Check the Offshore field block to exclude Offshore, or leave blank to include Offshore or away from home station. This identifies either the 4-position Mission Design (MD) or the 5- position Mission Design Series (MDS). You may also enter AGE, PMEL, or TRAN. If you are processing this report for only one Aircraft, enter either the 8- position Aircraft Serial Number or the 6-position Aircraft Identification Number. Leave blank for all Aircraft. Select an option from the menu (sorted by MDS) by clicking the A/C icon or enter it manually. If you are processing the report for a specific base code in the Base field, you may enter a 5-position Work Center number or 4- to 5-position Work Center mnemonic in this field. Because Little Rock AFB has more than one Command assigned to the base, the report may be processed by entering a Command Code in this field. If left blank, all Commands will be displayed. 15

16 Note: This information is updated by Program 9099, MDC update and is only as accurate as the MDC reported by the shops. Program 8003 Output Screen For information about Program 8003 click on the next to the program number. 16

17 Program 8004 MDC Work Unit Code Analysis Purpose This program provides failure data for a specific Work Unit Code (WUC) by How Malfunction (HM) Code and provides a summary of activity for 1 to 6 months. Note: If the user desires system, subsystem, or component data grouped together Program 9041 provides grouping (i.e. input 23A the output will reflect all Work Unit Codes under each component with a summary line for the system and subsystem). This program sorts the data strictly by How Mal Code and date. It list data from the most recent occurrence to the last date requested. Input Instructions Once you access the G081 system, select F8004 MDC Work Unit Code Analysis from the Program Listing page. You can also enter 8004 or F8004 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 8004 Screen 17

18 FIELD EXPLANATION Note: You may use the same inputs to process Program 8003 or Program This is the 2- to 10-position Work Unit Code (WUC) or Reference Designator (REFDES) you are processing the report for. Select an WUC/REFDES option from the menu by clicking the WUC/REFDES icon or use the appropriate -06 manual to enter it manually. Base Code This is the 4-position Base code or the 3-position command. If left blank, all Bases will be selected. Select an option from the menu by clicking the Base Code icon or enter it manually. This is the number of Months and Span of data you wish to display. Select an option from the Month Span drop-down menu or enter it manually. Month Span # Of Month Offshore MDS A/C Wkctr CMD Code 1 - Full calendar months 2 - Date to date months 3 - Calendar months with current month This is the number of Months of data you wish to display. Select a number from 1 to 6 for the Months. Select an option from the # Of Month drop-down menu or enter it manually. Check the Offshore field block to exclude Offshore, or leave blank to include Offshore or away from home station. This identifies either the 4-position Mission Design (MD) or the 5- position Mission Design Series (MDS). You may also enter AGE, PMEL, or TRAN. If you are processing this report for only one Aircraft, enter either the 8- position Aircraft Serial Number or the 6-position Aircraft Identification Number. Leave blank for all Aircraft. Select an option from the menu (sorted by MDS) by clicking the A/C icon or enter it manually. If you are processing the report for a specific base code in the Base field, you may enter a 5-position Work Center number or 4- to 5-position Work Center mnemonic in this field. Because Little Rock AFB has more than one Command assigned to the base, the report may be processed by entering a Command Code in this field. If left blank, all Commands will be displayed. 18

19 Note: For all aircraft or all base totals leave the base and aircraft fields blank. Program 8004 Output Screen For information about Program 8004 click on the next to the program number. 19

20 Program 8011 In-Flight Engine Shutdown Purpose This program displays the engine shutdown history at a particular base or for a particular engine or for a particular CEI or CEI and base. Input Instructions Once you access the G081 system, select F8011 In-Flight Engine Shutdown from the Program Listing page. You can also enter 8011 or F8011 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 8011 Screen 20

21 FIELD EXPLANATION The 7-position Component End Item (CEI) is used to link all parts to a particular engine, regardless of who manufactured the parts. See Program 9123 for an inquiry or other information on CEI s. Select an option from the menu by clicking the CEI icon or enter it manually. CEI Engine Serial Number A00001A for C-5A, B, C engines A00001M for C-5M engines A00001C for C-130E, H engines A00001J for C-130J engines A00001D for C-17 engines A00001E for KC-10 engines A00001H for KC-135R engines A00001L for C-40 engines A00001N for H-60 engines If the shutdown request is for a single engine, enter the 10-position Engine Serial Number of the engine that was shutdown. Leave Blank for ALL engine shutdowns associated with the CEI entered in the CEI field. This is the 4-position Base Code. If left blank, G081 will default to your home Base. Base Code Select an option from the menu by clicking the Base icon or enter it manually. NOTE: If processing the report for a Base and you want to list all CEIs and serial numbers, leave the CEI and Engine Serial Number fields blank. If selection is to begin at a specific Date, enter it in this field. Start Date Select an option by clicking the Start Date icon or enter it manually in MM/DD/YYYY format. Note: If no dates are entered, the entire in-flight engine shutdown history will be displayed. 21

22 FIELD End Date EXPLANATION If selection is to End at a specific Date, enter it in this field. Select an option by clicking the End Date icon or enter it manually in MM/DD/YYYY format. Enter 'L' or 'P' in 'BASE OPTION' to select: Base Option 'L' Location where shutdown took place 'P' Possessed base at time of shutdown Notes: 1. Both CEI and Serial Number must be Blank to only select by Base Code. The base selected is the possessor of the engine at the time the shutdown was recorded. 2. The selection by CEI will get will get all possessors. 3. Selection by CEI and Base Code will only get engines presently located at that base with shutdowns. 4. If no Dates are entered, the entire inflight engine shutdown history will be displayed. 22

23 Program 8011 Output Screen The Program 8011 screen provides the following output information: Engine serial number of the engine on which the shutdown occurred Position of the affected engine on the aircraft Aircraft Serial number that had the shutdown occurrence Engine hours - Number of flying hours on the affected engine Date of shutdown Date that the shutdown occurred Base Occurred Base where the shutdown occurred JCN Job Control Number assigned to work the shutdown WO - When the Shutdown Occurred: I=Inflight, G=Ground, T=Takeoff Reason for the engine shutdown Note: The Work Unit Code, When Discovered Code, How Malfunction Code, and the Action Taken Code are displayed on the printed report only. For information about Program 8011 click on the next to the program number. 23

24 Program 8020 Operational Status of All Aircraft at a Given Base Purpose This program displays maintenance and status information for aircraft assigned to or possessed by a given base. Input Instructions Once you access the G081 system, select F8020 Operational Status of All Aircraft at a Given Base from the Program Listing page. You can also enter 8020 or F8020 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 8020 Screen 24

25 FIELD EXPLANATION Enter the 4-position Base Code or Command Code for which you are processing the report. Select an option from the menu by clicking the Base icon or enter it manually. For a Command report, enter one of the following: AMC Selects all AMC Bases RESV Selects all Reserve Bases ANGD Select all Guard Bases Base Code Note: The above three command options automatically run Generation Reports to your printer for the given MDS. If MDS is blank, then it s run for all MDS. EURP Selects the following bases: QFQE, MQNA, LJYC, UDHY, TYFR, TGZK, UMXB, VRJT, ADL3, ALDD, FGDC, ACVZ, QUUG, ASHE, QPUF, CSCR, LQUD, GKVB PACF Select the following bases: FXSB, KNMN, LXEZ, ZNRE, AJJY, LCPU, UELU The Option Codes tell G081 what information it must gather to respond to your request. The option you select will determine many of the later entries in this screen. Select an option from the Option Code drop-down menu or enter one of the following manually: Option Code P Plain Report in Tail Number Sequence R Includes remarks F - Flight Line Report (Printer Only) G - Report of Any Aircraft On Station or Inbound sorted in Generation Sequence S On Station Gen Rpt in Serial Seq T Transient A/C Generation B - Aircraft Generation for both Transient and Aircraft On Station 25

26 FIELD EXPLANATION This field allows you to Select Assigned, Generated, or Possessed Aircraft. Select an option from the A/C Select Code drop-down menu or enter it manually: AC Select Code A - Assigned A/C (Aircraft owned by a base) P - Possessed A/C (Aircraft owned by another base but are deployed to another base for certain missions.) G - Aircraft assigned to a base but includes remarks from F9018 screen This field will always be pre-filled with A (Assigned A/C). MDS WSC Poss Org ZULU Time Configuration 8020 Refresh Settings Send Report To Grid This identifies either the Mission Design (MD) or the Mission Design Series (MDS). This field identifies the Weapon System Controller (WSC) or the position to which the aircraft is assigned. Enter WSC number or letter, or leave Blank. Enter the 4-position Assigned Wing to display just those aircraft assigned to that wing. Check in this field block for ZULU Time. Leave Blank for local time. If you want to run the report to for only those aircraft with specific configurations, Check the applicable field(s). Aircraft configuration is on Program Leave all fields Unchecked to select all aircraft. If you want your report to Auto Refresh, select the desired interval. Select an option from the 8020 Refresh Settings drop-down list or enter it manually. Uncheck box to not display a listing of redirect screens from the report. The program default is checked, which will display redirect screens. 26

27 Program 8020 Output Screen - Sent to Grid Notes: 1. A list of available pass-thru screens from Program 8020 will be shown under the Action Dropdown of the output. Select the desired aircraft data line and click on the appropriate pass-thru screen. 2. User must have access to the selected screen to allow updates. See your G081 Manager for access. For information about Program 8020 click on the next to the program number. 27

28 Program 8031 Bench Check Analysis Summary for a WUC Purpose This program displays work accomplished (off equipment) for maintained aircraft items. It displays the number of times a particular action has been taken against a Work Unit Code (WUC) or Reference Designator (RD). The program also displays the percentage of items made serviceable through repair and the percentage of items Not Repairable This Station (NRTS). Input Instructions Once you access the G081 system, select F8031 Bench Check Analysis Summary for a WUC from the Program Listing page. You can also enter 8031 or F8031 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 8031 Screen 28

29 FIELD WUC Base Code MDS # of Months EXPLANATION This is the 5-position Work Unit Code (WUC) or 10-position Reference Designator (RD). The REFDES is only for the C-17 aircraft. Select an option from the menu by clicking the WUC/REFDES icon or use the appropriate -06 manual to enter it manually. This is the 4-position Base code. If left blank, all Bases will be displayed. Select an option from the menu by clicking the Base Code icon or enter it manually. This identifies either the 4-position Mission Design (MD) or the 5- position Mission Design Series (MDS). Enter the MDS. Input a number from 1 to 6 depending on how many Months you wish to view. Input an A to scan all records available in the database. Select an option from the # of Months drop-down menu or enter it manually. The Span Code allows you to select how you want your monthly data displayed. Input either a 1 or 2 in this field. Span Code: CMD Enter one of the following options: 1 - To view full calendar months but not the present calendar month 2 - To view the number of months entered in the Months field and all data up to the current date This is the Command code for Little Rock AFB inquiries. Leave blank for all Commands. 29

30 Program 8031 Input Screen 30

31 Program 8031 Output Screen Note: This report names the item to which the work unit code refers, and breaks the output into 6 areas: Serviceable, reparable, NRTS, Misc codes, and other codes. It also displays the percentage of units the base has checked ok, NRTS'd, repaired, or on which other maintenance has been performed. See the Help screen for additional information on the output listing. For information about Program 8031 click on the next to the program number. 31

32 Program 8047 Detail Aircraft Status Report Purpose This program displays two types of records: aircraft status records and inventory records. Inventory records are created during the gain/loss of aircraft possession in Program Input Instructions Once you access the G081 system, select F8047 Detail Aircraft Status Report from the Program Listing page. You can also enter 8047 or F8047 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 8047 Screen 32

33 FIELD REQUIRED FIELD EXPLANATION AC Serial Start Date Enter the 8-position Aircraft serial number. Select an option from the menu (sorted by MDS) by clicking the Aircraft icon or enter it manually. Enter the desired Start Date in the MMDDYYYY format. If left blank, the program will show status records for the current day and 4 days back. Select an option from the calendar by clicking the Start Date icon or enter it manually in MM/DD/YYYY format. ONLY REQUIRED if Start Date is input Stop Date Select an option from the calendar by clicking the Stop Date icon or enter it manually in MM/DD/YYYY format. Program 8047 Output Screen For information about Program 8047 click on the next to the program number. 33

34 Program 8070 Discrepancy Report Purpose This program produces a report of aircraft discrepancies. The options include non-scheduled, scheduled, repeat/recurring, TCTO s and -6/Time Change discrepancies. Discrepancies may also be grouped by Work Unit Codes, Work Zones, or Date Range. Input Instructions Once you access the G081 system, select F8070 Discrepancy Report from the Program Listing page. You can also enter 8070 or F8070 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 8070 Screen 34

35 FIELD AC Serial/ID JCN EXPLANATION Enter the 8-position Serial number or the 6-position aircraft ID number. Select an option from the menu by clicking the Serial/ID icon or enter it manually. This is a 9-position field containing the Job Control Number (JCN) used to identify open and closed discrepancies for the specified Serial/ID. If left blank, G081 will list only closed discrepancies within the other parameters you set. Enter the 3-position Work Event Separator (WES). WES Notes: 1) If you enter the aircraft and JCN and leave WES blank, it will display the JCN and all the WES s associated with job. 2) If you enter the aircraft, JCN, and WES it will only display the info for that specific WES. The Option codes tell G081 what information it must gather to respond to your request. Select one of the following from the Option drop-down list or enter it manually: Option / - All discrepancies 0 (zero) - Support General Jobs (WUC Beginning with 0) A Non-Scheduled Maintenance Jobs D - All -6 and Time Change Jobs H - Limits Jobs to a Specific When Discovered Code L - To Select C005M TLD (Time Limited Dispatch) Jobs Only R - Repeat and Recurring Discrepancies S - Scheduled Maintenance Jobs (When Disc is K or M) T - TCTO Jobs W - Work Unit Code/RefDesc X - Limits Jobs to a Particular Workcenter Z - Limits Jobs to a Work Zone Range Note: If JCN is specified all maintenance actions will be listed. 35

36 FIELD Shop/WUC/REFDES EXPLANATION This field allows you to refine the report by asking you to define whether you want to select by Shop (enter manually), Work Unit Code (WUC) or Reference Designator (REFDES). You may select a specific shop or All for all shops. You can obtain a list of work centers from Program Inputs for Option W Enter at least a 2-position WUC or REFDES. Select an option from the menu by clicking the Shop/WUC/Ref icon or use the appropriate -06 manual to enter it manually. Start Date Stop Date Input a Start Date for your report in the From field. This will refine the report by specifying discrepancies that were completed within a specific date range. Select an option from the calendar by clicking the Start Date icon or enter it manually in MM/DD/YYYY format. Leave blank for all. Input a Stop Date for your report in the To field. This will refine the report by specifying discrepancies that were completed within a specific date range. Select an option from the calendar by clicking the Stop Date icon or enter it manually in MM/DD/YYYY format. Leave blank for all discrepancies through the current date. ONLY REQUIRED for Option Z Start Zone End Zone Symbol If using Option Z, enter the Starting work Zone. For most reports that are concerned with general information on an aircraft, this field will be left blank. ONLY REQUIRED if Start Zone is input If using Option Z, enter the Ending work Zone. This field allows you to limit your report to a specific discrepancy Symbol. You can select a Red X, Red Diagonal (/), or Inspection (-) jobs. Leave blank for all. Select an option from the drop-down menu or enter it manually. 36

37 FIELD Man Num. When Discovered Select By Create Date Accomplished Offshore EXPLANATION You may further limit your output to those discrepancies containing MDC accomplished by a specific user by entering their 5-position Employee (Man) Number. The When Discovered (WD) Code is a 1-position field used to identify when the discrepancy was discovered. Select an option from the menu by clicking the When Disc icon or enter it manually. Check the Select By Create Date field to confine your report to those discrepancies that were created within the specified From and To dates. Leave blank to default to discrepancies closed within the specified date range. Check the Accomplished Offshore field to confine your report to those discrepancies which were created offshore (any location other than the assigned base of the aircraft). Leave blank to select all jobs, regardless of the where they were created. Notes: 1. The AC Serial/ID, Option, Shop/WUC/REFDES, Start/End Zones and/or date range are used for normal input. 2. If you input the AC Serial/ID and JCN, it will display all details regarding the job entered, including any WESs attached to that JCN. It will display the job whether it is open or closed. 3. If you enter the AC Serial/ID, JCN and WES, it will only display the information for that specific WES, regardless of whether it is open or closed. 4. The program automatically limits the date range to 30 days for Option R [Repeat and Recurring Discrepancies]. Specifying ALL in the Shop/WUC/REFDES field requires a date range but limits selection to 40 days. 37

38 Program 8070 Input Screen 38

39 Program 8070 Output Screen For information about Program 8070 click on the next to the program number. 39

40 CHAPTER Series Program 40

41 Program 9006 Process Requests For Supply (SBSS) Purpose This program is used to order and/or maintain G081 and SBSS data for supply related items. Updates/retrieves info from M391/S11/S12, M359S11/S17, M377S11/S17, M376S14/S17, and M396. This program has 3 sections: SBSS Data, Cannibalization/Transfers and Cancel/New Doc #. Input Instructions Once you access the G081 system, select F9006 Process Requests For Supply (SBSS) from the Program Listing page. You can also enter 9006 or F9006 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9006 Screen Notes: You can view the history of any document number in Program

42 1. When you have a reject from SBSS and need help (and it s not a G081 or user issue) call Supply Customer Service. For AMC Bases (or units supported by AMC Base) DSN For ACC Bases (or units supported by ACC Base) DSN You can t do an initial order against a CANN (***52**) JCN. The proper procedure is to order the part for the original job. If it s decided they are going to CANN it, create a CANN (***52**) job in Program 9050, then transfer the document number to this CANN JCN in Program When processing a shop stock, request AZ only for Initial Issue and BZ/CZ for backorders only. 4. If the user has Hold in their Program 9039 access or does not have any 9039 access the initial order against a paperless ISO/HSC, aircraft will be put into ISO Hold. A user that doesn t have Hold in their 9039 access can order a document number without it going into Hold as well as the ability to push a Held document number to SBSS. 5. Mark 4 changes can only be made under the following circumstances: A/C to A/C A/C to refuel POD for KC135/KC10 A/C to uninstalled engine Installed engine to A/C Uninstalled engine to uninstalled engine APU to APU APU to A/C Support equipment to support equipment Off equipment prop to off equipment prop 6. To transfer the document number to a 350 Tag, it has to originate from a 350 Tag and the transfer to 350 Tag has to be a prop (Part Number CEI = AL0010C) to transfer the document number from a 350 Tag. You can only transfer to another 350 Tag and this to 350 Tag has to be a Prop 350 Tag. 7. Any individual field denoted with ** indicates more detailed information is available in AFMAN Vol 2 Part There are certain fields on the screen which are unique to G081 and are not passed to SBSS. These fields can be updated via the CHG transaction. Anytime you update a field on the screen which has to be sent to SBSS, the program will force you to use a DIT or NOR transaction. 9. These SBSS TRAN (ING, CHG, DEL, DOR, KIL, ERR, RMD) are G081 only actions. They do not update SBSS. 10. If at the bottom of the screen it says, LAST ACT SBSS ERROR **************************, THIS IS AN ERROR FROM SBSS AND MUST BE RESOLVED ON THE SBSS SIDE. 42

43 FIELD Trans Access Key System Doc # Serial /ID # How to Order a Part (Initial Issue Request) EXPLANATION Enter the 3-position SBSS Tran code in this field. This is what you want the program to do. Select the ISU (Issue) from the Trans drop-down menu or enter it manually. Note: Depending on your Program 9057C permissions set by your G081 Manager, some of these SBSS Trans may or may not work for you. See the help screen for a list of Transaction codes. Contact your G081 Manager if you need access. This field may require a 2-position Access Code, or Key, which is available through your local G081 Manager. The System field is used to tell the program which System to update. Leave blank or enter B to update both G081 and SBSS as applicable. Normally, this is the option that will be used. Select an option from the System drop-down menu or enter it manually. This is the 14-position Document Number you wish to view or update. This is required for all Transactions except ISU. For an ISU the Document Number field is left blank. When ordering a Part, the Document Number will be assigned. Enter the Aircraft Serial or 6-position ID Number, the ID Number for off wing engine or AGE/SE or leave blank for off equipment and shop stock. (i.e., QGxxxx). Select an option from the menu (sorted by MDS) by clicking the Serial /ID # icon or enter it manually. JCN/TAG Enter the 9-position Job Control Number (JCN) or 350 Tag number or for shop stock input SHOPSTK and leave the aircraft/id number blank. This is a mandatory field for ISU transactions. 43

44 FIELD Org/Shop EXPLANATION This is the Organization or the Shop which designates the funding site. This is the 5-position ID that Supply uses to identify your account. The first three positions of this field must be numerical. This field is only used during the Initial ISU transaction. DISPLAY ONLY NO INPUT REQUIRED Create Date Emp # Shop Base This is the Date the document number was added into G081. This field is for output only. No user input can be made. This is the 5-position Employee Number of the individual requiring the part. It is not the number of the person doing the input unless it is the same person. This is the Shop Mnemonic of the Employee Number input in the Employee # field. DISPLAY ONLY NO INPUT REQUIRED At Home Station this field must be blank. OR SRAN UHHZ (Y/N) When TDY or deployed SRAN may be entered. Only used when ordering parts at TDY locations. Example: Memphis person is TDY to McGuire working on Memphis aircraft (also TDY to McGuire). As long as Supply has their side setup the user should be able to input McGuire s SRAN to order parts vs. leaving blank and allowing the default of Memphis to be used. This is used by Robbins AFB only. When checked with a Y will allow AMC base code to input a document number for the depot base code. 44

45 FIELD EXPLANATION The Urgency Justification Code (UJC) indicates the Urgency of need and the type of requirement for the requested supply asset. It identifies the order as being either a Mission Capable Part (MICAP) or routine. Select an option from the UJC drop-down menu or enter it manually. For initial order use: AA (for aircraft) AM (for engine) AG (for AGE/SE) AR (for 350 TAGS) If the item kills (no stock on base) and you need to backorder use one of these UJC's: UJC Unit/ISU ** AU TCTO/TIME CHANGE AZ SHOPSTK WORK STOPPAGE 1A AIRCRAFT MICAP NMC JA AIRCRAFT MICAP PMC JG AGE/SE MICAP PMC 1G AGE/SE MICAP NMC 1M ENGINE MICAP NMC BG AGE/SE ROUTINE BR OFF-EQ ROUTINE BM ENGINE ROUTINE BQ AIRCRAFT ROUTINE BU TCTO/TIME CHANGE BZ SHOPSTK PRIORITY CZ SHOPSTK ROUTINE Enter the Unit of Issue for the requested supply asset. To verify the Unit of Issue for a part, an SBSS inquiry can be made on Program The Unit of Issue must match what is listed in SBSS. Some examples are BX for box, EA for each, FT for foot, PG for package. Select an option from the Unit/ISU drop-down menu or enter it manually. Need Time Enter the Time that you must have the item. 45

46 FIELD Date Quantity Del Priority Del Dest Stock # QLN Part # WUC/RefDes Nomenclature EXPLANATION Enter the Date that you must have the item. Select an option by clicking the Date icon or enter it manually in MM/DD/YYYY format. Note: On the DUO action is the UJC is B X then the need Time/Date will need to be blank or the Date will need to be 22 days greater than today. This field will be to show the required delivery Date. Enter up to a 5-position numeric Quantity of items you want to order. The Delivery Priority field indicates the maximum time allowed from the day Base Supply receives a request to the day it delivers on-the-shelf items. i.e. 03 or 04. Enter Delivery Destination (3-position code). Must be TNB for all aircraft back orders. Input the National Stock Number. Leave blank if Part Number or QLN is used or input P followed by a Part Number. If this option is used, the Part Number is sent to SBSS. If you are ordering the item by Quick List Number (QLN) enter it in this field. Leave blank if Part Number or Stock # is used. The QLN will be converted to an NSN in G081 Part Number Database and the NSN is sent to SBSS. Leave blank if not ordering by QLN. If you are ordering the item using the Part Number, enter it in this field. Leave blank if NSN or QLN is used. The Part Number is converted to an NSN using the G081 Part Number database and sent to SBSS. If the Part Number and WUC combo exist in Program 9132, then it will automatically populate the stock number, nomenclature, T.O. Vol, Fig, and Index. Enter the 5-position Work Unit Code (WUC) or the 9/10-position Reference Designator (REF DES) for the line replacement unit. The WUC/REFDES must be a valid WUC/REFDES existing in G081. Select an option from the menu by clicking the WUC/REFDES icon or use the appropriate -06 manual to enter it manually Enter the name of the part being ordered/back ordered. 46

47 FIELD T.O. Vol Fig Index Requestor/ PH Verify By Remarks DIFM Doc # Time Date Time Date EXPLANATION Enter the Technical Order (T.O.) number. Enter the Technical Order Volume. Enter the T.O. Figure number. Enter the T.O. Index number. Enter the Requester name and Phone number in this field. Enter the name of the Verifier in this field. You can enter up to 25-positions of Comments/Remarks, if any in this field. This is the Document Number (used for in shop repairs) from the onequipment Document Number. In other words, a DIFM item is ordered/received for an aircraft, the Document Number used during that process is the one input here. NODIFM can be input when you have a 350 Tag but no DIFM asset is associated (used with AR UJC). MICAP Start Enter the Time the MICAP started in this field. Enter the Date the MICAP started in this field. Select an option by clicking the Date icon or enter it manually in MM/DD/YYYY format. MICAP Stop Enter the Time the MICAP stopped in this field. Enter the Date the MICAP stopped in this field. Select an option by clicking the Date icon or enter it manually in MM/DD/YYYY format. 47

48 FIELD Validated By Time Date By Time Date Advice Proj** IEX** TEX** Demand** EXPLANATION Enter the name of the person who Validated the request in this field. Parts Rcvd Enter the Time the Parts were received from Supply in this field. Enter the Date the Parts were received from Supply in this field. Select an option by clicking the Date icon or enter it manually in MM/DD/YYYY format. Enter the name of the person receiving the part. When a part is issued to customer either directly or through TNB, enter the name of the customer receiving the part. Parts Issued Enter the Time the Parts are issued to customer from TNB or Time/Date Part is issued directly to customer if Part did not go to the TNB first. When Parts issue straight to customer, this field should be same as parts received issued Time/Date. Enter the Date the Parts are issued to customer from TNB or Time/Date Part is issued directly to customer if Part did not go to the TNB first. When Parts issue straight to customer, this field should be same as parts received issued Time/Date. Enter the date in the MM/DD/YYYY format or use the calendar. SBSS Data Section Indicates how and under what restrictions an item will be issued. This field may be left blank. Enter the code that tells SBSS what Project this request is for. This is used by the Supply Deport to prioritize. This code tells SBSS something special about the requisition. (continuous fleet, hazardous material, etc.). This code is used to tell SBSS what to do with this requisition. For example, M firms up a back order, 4 is a fill/kill, etc.). This code is what tells SBSS that the item is an initial issue, a one- time order, a recurring item, etc. Select an option from the Demand drop-down menu or enter it manually. 48

49 FIELD SRD BLISS/WRM** NHA ERRC** TNB** Residue** Source Code** JOCAS # OAM AWN INW AWP AWI NRTS Serv Line SOS QPA Bench Stock EXPLANATION Enter the Standard Reporting Designator of the end item. See G081 Program 9061 for a list. Enter Base Level In Stock Supply/WAR Reserve Material in this field. Enter the number of items available in BLISS/WRM. Enter the Next Higher Assembly in this field. Enter the Expendability, Recoverabilty, Reparability, Cost Designator in this field. When it is XD* or XF* you can only order a quantity of 1. Enter the Tail Number Bin in this field. Lists the number of items in the TNB. Enter the serviceable items procured through Air Force means and stored in a central location until needed. The Source Code indicates whether a supply acquisition is depot or local. This field is used by Edwards AFB only. All others leave blank. Enter the number of items in OAM status. Enter the number of items in Awaiting Maintenance status. Enter the number of items In Work in back shop. Enter the number of items Awaiting Parts in back shop. Enter the number of items Awaiting Install in back shop. Enter the number of items Not Reparable this Station. Enter the number of items on Service Line. Enter the Source of Supply in this field. Enter Quantity Per Assembly (QPA) in this field. Enter number of items in Bench Stock in this field. 49

50 FIELD Repair Cap Off Base Req # Status Est Delivery Date Fields to Send (U = UJC, A = SERIAL ID, W = WUC) Time Date By Time Date Cann for Ser ID Cann JCN EXPLANATION Enter the Base Repair Capability in this field. Displayed as a percentage of the requisitioned supply asset. Enter the Off Base Requisition Number in this field. Normally this is updated by SBSS passing to G081. Enter the last Status code from SBSS. This is updated by SBSS passing to G081. Enter the Estimated Delivery Date of the item. This is updated by SBSS passing to G081. Select an option by clicking the Date icon or enter it manually in MM/DD/YYYY format. Enter the Fields you want to send the items to. Enter W to send Work Unit Code, A for Serial or U for UJC. Cannibalization/Transfers Section Cann Approved: Enter the Time the Cann was approved. Enter the Date the Cann was approved. Select an option by clicking the Date icon or enter it manually in MM/DD/YYYY format. Enter the name of the person that did the Cann action. Verify Cann Enter the Time the Cann was verified. Enter the Date the Cann was verified. Select an option by clicking the Date icon or enter it manually in MM/DD/YYYY format. DISPLAY ONLY NO INPUT REQUIRED This is the Ser/ID the item was Canned for. DISPLAY ONLY NO INPUT REQUIRED This is the JCN the item was Canned for. 50

51 FIELD Recommend Cann Del Code** Install Date Removal Date EXPLANATION Enter the name of the person Recommending the item be Canned. Enter the Delivery Code in this field. Select an option from the Del Code drop-down menu or enter it manually. DISPLAY ONLY NO INPUT REQUIRED Leave Blank. Not input - This field is for display only. DISPLAY ONLY NO INPUT REQUIRED Leave Blank. Not input - This field is for display only. DISPLAY ONLY NO INPUT REQUIRED Initial Cann Date This is the Date the item was first Canned. If this is a high Cann item that is Canned over and over, this is the Date from the first time it was Canned. Leave Blank. Not input - This field is for display only Doc Only > Cancel Qty Action Code** Cond Code 349/350? New Doc # Cancel/New Doc # Section Used with the DOC transaction only. This is the number of items you wish to cancel. Indicates what the Action Code was. The code must be A, B, F, G, J, K, L, V, X or Z. See Applicable -06 WUC Manual. Used with the DOC transaction only. Select an option from the drop down list or enter it manually. Leave Blank. This field has been marked for deletion pending approval and implementation of SCR M. Allows a 349 and/or 350 Tag to be printed. Must use the INQ transaction unless other updates are being performed. In which case use the Chg transaction. Select an option from the 349/350? drop-down list or enter it manually. This field is used with the Change Document Number (CDN) transaction to change the Document number. The New Document Number is required if system option is S. Normally left blank. Ordering: After all required fields are input, press the Enter key to send the data. Your request will be passed from G081 to the SBSS database. If SBSS accepts the order, the Document Number portion on the top line will now contain your newly created document number. If any of the data input is incorrect, an error message with a description of the problem will be provided at the bottom of the screen. SBSS will send a management notice notifying you of the status (See Figure 1 for 51

52 an example of a Kill notice), but it may take some time. Instead of waiting, just run an INQ to learn the status. Inquiring: Now you need to run an Inquiry to check the status of the newly created document number. An item that has issued will return a message indicating such. An item that is zero balance will return a message indicating the document has Killed. The message indicating the document status is displayed at the bottom of the screen. Killed documents need to be resubmitted so a Due Out may be established. Information on resubmitting a Kill can be found in the section covering Back Ordering a Part. Note: It is necessary to wait a period of time to allow your ISU and DUO request to be processed. If your inquiry has not returned a proper response within a reasonable time, i.e., 5 minutes, an error within SBSS or G081 is most likely the cause. When you have a reject from SBSS and need help (and it's not a G081 or user issue), call supply customer service. Note: Check the bottom of the screen to verify status of your supply request. Program 9006 Initial Req. Input for ISU items After Processing Status Message DATA PROCESSED SUCCESSFULLY AND SENT TO SBSS 52

53 Program 9006 Input for ISU items 53

54 Figure 1 - Printed Management Notice from SBSS If the item you have ordered is not available in local stocks, the returned response from your INQ will be a KILL. At this point, you will have to backorder the part. 54

55 Backordering To back order the part, a DUO (Backorder) request must be submitted. Select DUO from SBSS Trans Dropdown, update UJC and Del Priority to correct backorder status and insert employee number in the Validated by field. Hit Enter. Program 9006 Initial Req. Tab Input for DUO DIFM item 55

56 Program 9006 Input for DUO Items 56

57 MICAP Mission Capable Part What is a MICAP? A MICAP is a Mission Capable Part, which the aircraft requires to complete its assigned missions. Without the part, the aircraft is put into a Not Mission Capable Supply (NMCS) status. What Are The MICAP Procedures? MICAP procedures are used to secure material needed to repair mission essential equipment of the highest priority. The MICAP system provides a method of obtaining the kinds of items required by Air Force organizations to maintain mission capability. All personnel involved in the MICAP system should be familiar with all procedures. When Can I Initiate A MICAP? The use of MICAP procedures are to be used only after all efforts have been made to resolve material shortage problems through other local resources. A check of all base level resources must be carried out before MICAP requisitions are initiated. Before a MICAP requisition is submitted, supply and maintenance personnel must ensure that all possible base-level resources are exhausted. They should determine whether a substitute item can be used; search for items issued for time change and Time Compliance Technical Order (TCTO) kits; check repair lists; consider cannibalization or items Due In From Maintenance (DIFM) not Awaiting Parts (AWP); assess the possibility of priority repair; and determine if a Next Higher Assembly (NHA) is available or cannibalization is feasible. A MICAP condition will be confirmed at base level only after Maintenance verifies that the end item is not mission capable and both Supply and Maintenance personnel verify that the requirement cannot be satisfied using base level resources. When it is certain that all material searches have been carried out and that the item is not available through base resources, a MICAP condition can be confirmed at base level. At this point, a MICAP issue request should be processed. If the Standard Reporting Designator (SRD) is MICAP reportable, this input will generate a MICAP requisition and a MICAP report. 57

58 How Can I Satisfy A MICAP Condition? As a last resort, when all other means have been exhausted, a cannibalization action may be initiated to clear the MICAP. How Can I Use a Cannibalization Action To Prevent A MICAP? Once the cannibalization action is created in G081, you may use Program 9006 to preclude a MICAP before verification and processing of a MICAP due-out. This is done by processing a NOR transaction. How Can I Terminate A MICAP Condition With A Cannibalization? You may use Program 9006 to terminate a MICAP condition. A NOR transaction with delete code 8 and advice code Z will be input. Refer to AFMAN , Vol 2, Part 2, Chapter 17 for more information on NOR formats. What Computer Actions Will I Take To Complete The Cannibalization/ MICAP Process? The following information will guide you through the cannibalization and MICAP procedures. There may be restrictions at your base limiting access to these transactions. Consult your local G081 Manager for guidance. You must process an inquiry (INQ) Transaction before processing any other Transaction. Select INQ under SBSS Trans Field. Leave System field blank and input 14-position document number. Press Enter and the screen will prefill. To Upgrade a MICAP Select NOR from SBSS Trans Field and then change the UJC field to the appropriate MICAP UJC. Because we are upgrading this order, we have to upgrade the Urgency Justification Code (UJC). Select an option from the drop down list or enter it manually. Note: You may not use a UJC of AA to upgrade an item for an aircraft or AR for 350 Tags. This UJC is only used when initially ordering the part using Program Hit Enter. 58

59 Program 9006 Part MICAP Processing 1. Change SBSS Tran to DUO. 2. Change UJC to 1G. 3. Change Del Priority to Set Need T/D date field to 22 days in the future. 59

60 Program 9006 MICAP Processing Cont. 1. Enter 7 in Tex field. 2. Enter last name of person authorizing MICAP in Validated By field. 3. Enter current Time/Julian date in Mission Capable Time/Date Start field. 4. Press Enter to submit. For information about Program 9006 click on the next to the program number. 60

61 Program 9022 Job Estimates Purpose This program provides for updating job estimates by Work Unit Code (WUC) and Action Taken (AT). Special tools and instructions for the Action can be added or updated. A read transaction will display the current data base information on the scope or printer. Input Instructions Once you access the G081 system, select F9022 Job Estimates from the Program Listing page. You can also enter 9022 or F9022 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9022 Screen 61

62 FIELD Trans MDS WUC/REFDES EXPLANATION The Transaction codes tell G081 what information it must gather to respond to your request. Select an option from the Trans drop-down menu or enter it manually. Enter one of the following options: A to add a record C to change records D to delete records R to read records This identifies either the 4-position Mission Design (MD) or the 5- position Mission Design Series (MDS). Enter the 5- to 10-position Work Unit Code or Reference Designator in this field. Select an option from the menu by clicking the WUC/REFDES icon or use the appropriate -06 manual to enter it manually. Action Taken Repair Shop Elapsed Time Est. Crew Size Date CDB Device Enter the Action Taken code in this field. Select an option from the Action Taken icon or enter it manually. Enter the Repair Shop for this Action Taken code. Enter the Elapsed Time to process this action. Enter the Estimated Crew Size to do this action. This field cannot be updated. This field cannot be updated. The Device field allows you to select your output destination. Select an option from the Device drop-down menu or enter it manually. For information about Program 9022 click on the next to the program number. 62

63 Program 9025 Monthly Aircraft Status Summary Purpose This program reports status for a given tail, base or fleet. Data can be selected for one, many or all commands. The request can include or exclude status data for depot. Input Instructions Once you access the G081 system, select F9025 Monthly Aircraft Status Summary from the Program Listing page. You can also enter 9025 or F9025 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9025 Screen 63

64 FIELD AC Serial Base Code MDS Display All Aircraft Start Date Stop Date Command EXPLANATION Enter the 8-byte Aircraft Serial Number or select from the AC Serial dropdown. If selecting a fleet report (all serial numbers for a particular MDS) then enter 'ALL' Note: When requesting data for single aircraft, all base records are included based upon Depot/Command selection. Example: If aircraft was at Charleston, Dover and Memphis, and Command AMC is selected both Charleston and Dover would be included in the report. If selecting a base report, enter valid 4-position G081 Base Code Note: The ALL and BASE option will exclude current day in date range. All aircraft pulled by possessed base code. This identifies either the 4-position Mission Design (MD) or the 5- position Mission Design Series (MDS). This is not required when one serial number is input. Select to include an individual report for each aircraft and a summarized base report. Leave unchecked to display only the summarized base report. Enter a 4- or 6-position Start Date. If requesting partial months, then enter data in YYMMDD format. If requesting full months, then enter in YYMM format. Note: For full months, input start YYMM only, program will report for that month + the 3 previous months. When inputting YYMMDD range, program reports that range + additional 3 previous months. Enter a 4- or 6-position Stop Date. If requesting partial months, then enter data in YYMMDD format. If requesting full months, then enter in YYMM format. Select which Commands to include in the report. If none selected, default will be all. Select the applicable Possession Type: Possession Type Chargeable: Includes PPC Codes that start with C, I, P, and Z Maintenance: Includes PPC Codes that start with B Depot: Includes PPC Codes that start with D Surplus: Includes PPC Codes that start with X 64

65 Program 9025 Output Screen For information about Program 9025 click on the next to the program number. 65

66 Program 9025B Aircraft Utilization Data Purpose This program reports utilization data for a given tail number, base or fleet. Data can be selected for one, many or all commands. Retrieves info from M359/S16. Input Instructions Once you access the G081 system, select F9025B Aircraft Utilization Data from the Program Listing page. You can also enter 9025B or F9025B in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9025B Screen 66

67 FIELD AC Serial Base Code EXPLANATION This identifies the 8-position Aircraft Serial Number. The 6-position aircraft ID is not valid for this transaction. Select an option from the menu (sorted by MDS) by clicking the AC Serial dropdown or enter it manually. Input Base Code for a single Base or input ALL for all bases. Must be entered if the AC Serial field is Blank. Select an option from the menu by clicking the Base Code dropdown or enter it manually. REQUIRED FIELD MDS This identifies either the 4-position or 5-positions Mission Design (MD) or the 5-position Mission Design Series (MDS) for your aircraft. If the aircraft has a 7-position MDS, drop the first 2-characters. REQUIRED FIELD Start Date Enter the Start Date for the information you are requesting in the YYMM format. ONLY REQUIRED if you want a date range report (ie Jan-Mar). Stop Date Flying SQD Command Enter the Stop Date for the information you are requesting in the YYMM format. You may leave blank if you are only requesting data for the month designated in the Start Date field. Input the 2-position designator for the Flying Squadron to limit your selection. Leave blank for ALL. Select the Command Code(s) to produce a Command report for a particular base or command wide for a particular MDS. If processing this report for a particular squadron, leave this field blank. This will provide a report for ALL Commands. 67

68 Program 9025B Output Screen For information about Program 9025B click on the next to the program number. 68

69 Program 9032C Repeat/Recur Discrepancy Batch Request (67089) Purpose This screen submits a batch job request (Batch Program 67089) for a list of discrepancies which have been identified as repeat or recurring. Input Instructions Once you access the G081 system, select F9032C Repeat/Recur Discrepancy Batch Request from the Program Listing page. You can also enter 9032C or F9032C in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9032C Screen 69

70 FIELD Key EXPLANATION A 2-position access code, or Key, may be required to process this program. Key codes are available through your local G081 Manager. This field requires user to enter a valid printer ID as the output Destination for the product. Destination Duplex The G081 Manager maintains a list of local G081 printer IDs or you can use Program 9072 to identify your assigned G081 printer ID. If it errors on the printer ID, contact your G081 Manager. Check this field if you want the product printed in Duplex. Leave blank for normal print. NOTE: This function only works if the Destination printer has duplex capabilities. Enter a 4-position Base code for all assigned aircraft at the specified location or select up to 5 individual aircraft by entering the 8-position Aircraft Serial number, not the 6-position ID number, for desired aircraft. A/C or Base Select a Base code from the menu by clicking the Base icon or enter it manually. Only 1 base can be processed per transaction. Select an Aircraft Serial number from the menu (sorted by MDS) by clicking the A/C Serial icon or enter it manually. This field tells G081 what type of report to generate. Only Options 1 and 4 are available. Select an Option from the drop down list or enter it manually. OPT Begin WUC 1 Lists the number of repeats and number of flights for Disc/Aircraft 4 Prints all aircrew discovered discrepancies for the selected sorties Enter the Begin Work Unit Code (WUC) for a range of WUCs or leave blank for ALL. Select an option from the menu by clicking the WUC icon or use the appropriate -06 manual to enter it manually. 70

71 FIELD End WUC EXPLANATION Enter the End Work Unit Code (WUC) for a range of WUCs or leave blank for ALL. Select an option from the menu by clicking the WUC icon or use the appropriate -06 manual to enter it manually. The 2-position Sortie field tells G081 how many previous Sortie recaps to include in the report. Srt You should enter a minimum of 05 to aid in properly identifying repeat/recur discrepancies. See AFI for further details. This field must be entered manually. If left blank, the default will be 07 sorties. Cpy Enter a number from 1-9 for the number of output Copies desired. If left blank, it will default to 1. ONLY REQUIRED when report is run by Base Code MDS Enter the 4-position Mission Design (MD) or the 5-position Mission Design Series (MDS). 71

72 Program 9032C (67089) Output Screen For information about Program 9032C click on the next to the program number. 72

73 Program 9041 Maintenance Summary by System Purpose This program provides a response, to the scope or a printer, consisting of all entries of a subsystem within the requested system. This response depicts the number of maintenance actions and various meantime calculations, depending on the type of format requested. Input Instructions Once you access the G081 system, select F9041 Maintenance Summary by System from the Program Listing page. You can also enter 9041 or F9041in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9041 Input Screen 73

74 FIELD WUC/RefDes EXPLANATION This field designates 2- to 5-position Work Unit Code or 2-to 10-position Reference Designator. Select an option from the menu by clicking the WUC/REFDES icon or use the appropriate -06 manual to enter it manually. This is the 4-position Base Code or you may enter a Command Code. Select an option from the menu by clicking the Base Code icon or enter it manually. For Command codes select from the following: Base Code MDS AC Serial/ID AMC for AMC AFR for AFRC ANG for ANG ATC for AETC EUR for USAFE PAC for PACAF Blank for all bases This identifies either the 4-position Mission Design (MD) or 5-position Mission Design Series (MDS). Select an option from the MDS dropdown menu or enter it manually. Enter AC Serial/ID 8-position serial number or 6-position ID number to select one aircraft tail number. Select an option from the menu (sorted by MDS) by clicking the AC Serial/ID drop-down or enter it manually. Enter specific MDC Card Type. Select an option from the Card Type drop-down menu or enter it manually. Enter one of the following options: Card Type Start Date Stop Date ALL all card types A aircraft on-equipment E on-equipment engine F off-equipment engines H off-equipment (except engines) Z zero WUC Summary Enter Start Date in YYMM format. Maximum of 6 months back. Enter Stop Date in YYMM format. Maximum of 6 months back. 74

75 FIELD CMD Display All WUCs Display Only Type Maint B&Y EXPLANATION This field is used by bases with multiple command assets (such as Little Rock) by inputting the Command Code. All other bases should leave blank. To get details for each/every WUC or REFDES, check this field. Used when a system WUC is entered. Check this field to Include transient Type Maintenance, else leave as blank to exclude. Program 9041 Output Screen Program 9041 Output Screen For information about Program 9041 click on the next to the program number. 75

76 Program 9056 MDC Inquiry/Delete Utility Purpose This program is used to correct invalid MDC, discrepancy and corrective action data. The following databases are updated: M384SR/S11, M359S11, M379S11 and M366S11. This program is primarily to be used by G081 Management, Analysis, Shop Chiefs and Data Integrity Team (DIT) members to correct inaccurate information in the system. Analysis is responsible for data integrity reviews in addition to those performed by the DIT. The Shop Chief is responsible to correct/ensure correction of invalid information. Analysis should not be updating this data, only reporting errors and ensuring they get corrected. Input Instructions Once you access the G081 system, select F9056 MDC Inquiry/Delete Utility from the Program Listing page. You can also enter 9056 or F9056 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9056 Screen 76

77 Notes: User can change the MDC against a deployed aircraft taken by a different base as long as the user is loaded to the DEPL or G081 LTERM - -LTERM = ****DEPL OR ****G081. When attempting to change or delete information, the operator must be E/= not G/> and the Date Operator must be E/= not L/<. FIELD EXPLANATION REQUIRED FIELD The Transaction codes tell G081 what information it must gather to respond to your request. Select an option from the drop down list or enter it manually. Trans Select an option from the Trans drop-down menu or enter one of the below manually: S to retrieve a record C to update records D to delete records to delete For FAO use Key A 2-position access code, or Key, may be required to process this program. Key codes are available through your local G081 Manager. REQUIRED FIELD Base This is the Base Code of the employee number that the MDC was taken against with Program 9099 or enter the Employee # used on the MDC to find the base. See the Employee # field. Select an option from the menu by clicking the Base icon or enter it manually. REQUIRED FIELD The WUC Operator field is used to select discrepancies for a specific Work Unit Code (WUC) or group of WUCs. WUC Operator Enter one of the following WUC Operator options: E/= to search for the specific WUC entered G/> to start searching at the WUC entered and continue to the next higher WUC 77

78 FIELD JCN/WES ID/Serial # EXPLANATION Enter the 9-positon Job Control Number (JCN) and the 3-positon Work Event Separator (WES) is applicable. Enter the 6-position ID Number (can be aircraft, engine or support equipment), or enter the 8-position aircraft tail number. You can leave blank to search on the JCN. Enter one of the following options: E/= to search for the exact date entered L to start at the date entered and search backwards Date Operator MDC Date Tag Wrk Ctr MDS Access 9154 Emp # A/T Output With E hit enter to pull up any records for this date. Continue to hit enter until no additional records exist for this date. At this point, L will automatically get filled in and will search backwards. When searching backwards, in order to stop at a specific date you have to overtype the 'L' with 'E' to stay on that date, otherwise it'll continue to search backwards. Enter the 6-position Date in the YYMMDD format or a 5-position Julian Date. This is the date entered in Block I on the original input in Program If you leave it blank, it will search backwards. Select a Date from the calendar or enter it manually. ONLY REQUIRED for Maintenance Documented on 350 tags Enter 350 Tag to select on Tag number. Enter the 5-position Shop Mnemonic. Enter a valid 5-position Mission Design Series (MDS). This will redirect the user back to the Supervisor MDC review/error correction screen for DIT/MDC updating. If you don t know the base the MDC was taken against, but you do know the Employee # on the MDC, you can enter the Employee # Instead of the base and Program 9056 will find the matching base code and search. If a base and an Employee # are entered/exist on the screen, the value in the base field supersedes that of what s in the Employee # field. Enter Action Taken (AT) to select on Action Taken. This field allows you to select your Output destination. Select an option from the Output drop down menu or enter it manually. 78

79 Notes: 1. Make corrections in White Blocks below the fields that require correction. Change Trans to C and press Enter. 2. When attempting to change or delete information, the operator must be 'E/=' not 'G/>' and the date operator must be E/= not 'L/<'. 3. The basic input is Trans, WUC, and Operator. This will search for any MDC starting with this WUC. Entering additional data will narrow down the search--jcn or Tag, Date, and Work Center. 4. The 'Units' field cannot be changed from '00' to '01' or more. Nor can it be changed from '01' or more to '00'. This is due to edit constraints in other programs. If you need to do this, then you must delete the record and re-input the MDC. 5. Certain fields within the program cannot be changed. A reject will inform you when this occurs. If/when this occurs, you have two choices. Leave the data as is or delete the record and have the user re-input the correct information using Program The bottom section is for updating WIP MDC (HM Code 689). Use Program 9031 Help Screen for further assistance with these fields. Note: The basic input is Trans, Base, WUC Operator, and WUC. This will search for any MDC starting with this WUC. Entering additional data will narrow down the search JCN or Tag, Date, Workcenter. Program 9056 Bottom Screen For information about Program 9056 click on the next to the program number. 79

80 Program 9058/9029 Shop Batch Job/FOCUS Report Update and Execution Purpose These programs are used to execute and update the Job Control Language (JCL) for Batch jobs and FOCUS reports. The output is sent to your destination printer or text file. Program 9058 displays all Batch jobs and FOCUS reports for your work center and Program 9029 is used to update the Batch jobs and FOCUS reports. Input Instructions Once you access the G081 system, select F9058 Shop Batch Job Execution from the Program Listing page. You can also enter 9058 or F9058 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9058 Screen 80

81 FIELD Base Shop EXPLANATION This is the 4-position Base code. If left Blank, G081 will default to your base. Select an option from the menu by clicking the Base icon or enter it manually. This is the mnemonic of the Shop for the batch products being processed. If left Blank, G081 will default to your shop. This field is left Blank for normal processing. Selecting Y will display a menu of jobs, but no executions or updates will be allowed. Selecting P will print the entire list to the users default printer. Select an option from the Scan List drop-down menu or enter it manually. Scan List Notes: 1. For normal processing, only the users Base and Shop can be input. They may also be left Blank to default to the users assigned designators. 2. When using the Y or P options, any Base and/or Shop may be input. Alternate Printer When Batch/FOCUS programs are created, a default G081 printer destination is assigned. If you want to process a Batch/FOCUS program to a different location, input the desired G081 Printer ID in the Alternate Printer field. This will bypass the printer specified in the Dest field on Program Note: If the Dest field is Blank on Program 9029, you must always put a valid G081 Printer ID in the Alternate Printer field in order for the job to run. Note: Pressing Enter or Submit without inputting any information in the fields will produce a menu of job names that you can update/execute for your Base and Shop. 81

82 Program 9058 Output Screen 82

83 FIELD EXPLANATION The Action tells G081 what type of transaction you want to process. Click the Printer icon to execute the report. Action Click the Notepad icon to update/edit the report before executing it. When you select the notepad icon, you will be passed through to Program 9029 to review, make updates and/or execute the report. Note: Not all Batch/FOCUS reports are updateable. This access is built within the report by your local G081 Manager. Contact them if you have any questions. *** The Below Fields Are Display Only *** This information can only be updated via Program 9029 by your local G081 Manager This is usually the mnemonic of the Shop for the batch products being processed. However, this can be any 1-5 character identifier as Shop determined by the G081 Manager or the person who requested the report. Job Copies Update Description Result This field shows the name of the Batch/FOCUS report. The name can be 1-8 characters long and is determined by the G081 Manager or the person who requested the report. The number of copies produced when the report is executed will be shown in this field. Typically, it will be 001 but up to 255 copies can be produced in a single execution. This identifies whether or not the Batch/FOCUS can be Updated by users via Program If this field displays NO, you will not have a Notepad icon in the Action field and must contact your local G081 Manager to make changes to the report. Provides a more detailed Description of the report. Once you have executed the report, this field will display a green if it processed successfully or a red X if it did not. For information about Program 9058 click on the next to the program number. 83

84 Input Instructions When you click on the Notepad icon the Program 9058 report list, it will pass you to Program As shown in the following pages, this is where you will make any required/allowed updates to process the Batch/FOCUS report. Rows available for update are identified with an asterisk (*) in Column 79; non-updateable rows will be greyed-out. Click in the row to edit the field. You must contact your G081 Manager to request changes to rows that have not been identified for user update. Program 9029 Screen 84

85 FIELD EXPLANATION Only those fields that are accessible via the Program 9058 pass-thru will be covered in this section The Action tells G081 what type of transaction you want to process. When accessing Program 9029 from Program 9058, the only actions allowed are: Action E Submit job for processing R Reset to Program 9058 U Update the lower part of the screen Select an option from the Action drop-down menu or enter it manually. Note: If Action is left Blank, changes will not be saved and the screen will reset to the original data. Dest Forms Copies Must be a valid G081 printer ID. If left Blank, the output will default to the printer shown in the Org field. Only used to request duplex printing. Ensure that the identified output G081 printer has duplex capability. Input DUPX to use this feature and (fill the entire field) to clear the request. This 3-position numeric field is used to request the number of printed products the user requires. Numbers between 001 and 255 are allowable. If left Blank, the field will default to 001 copy. To make updates/changes to allowable fields: Change the input fields or card columns 1) Scroll down to the row 2) Click in the row to open it for update 3) Over-type the data you need to change/update 4) Verify your changes/updates and ensure there is a U in the Action field 5) Click Submit to save changes/updates 6) Verify Batch/FOCUS update was successful, then input an E in the Action field to process the job. 85

86 Program 9029 Screen With Requested Report Data Only line items with an asterisk (*) in column 79 can be updated via Program 9058 pass-thru access Making Updates: 1. Identify which line(s) of input can be updated by looking for the asterisk in Column Using the Steps 1-5 specified on the previous page under Change the input fields or card columns, change the requested data for the report, as needed. Notes: a. The insert feature should be OFF. You want to over-type the old data with the new to ensure you do not move the asterisk from Column 79. b. If the asterisks is moved or deleted, you will no longer be able to make updates to that line. Only the G081 Manager can fix this field if altered. c. BEFORE processing the U Action to update the report, always double check that the asterisks is still located in Column 79. If it is not, leave the Action field blank and hit Submit to reset everything. Then, re-input your updates. 86

87 Program 9029 Screen With Updates Saved Start_Date changed to Stop_Date changed to Ensure (*) is still in Col 79 Reviewing Updates and Processing Report: 1. Once you have processed the U action, in the status line at the bottom of the screen, you should see the message UPDATE ACCEPTED. a. If the update was unsuccessful, you will receive an ERROR MESSAGE b. Make any necessary corrections and re-process the report c. If you continue to experience issues, contact your local G081 Manager for assistance 2. Review your changes to be sure everything is correct and then submit the job for processing by selecting E for the Action and click Submit. 87

88 Program 9029 Screen After Execution Report Processed: 1. In the status line you should see the message JOB SUBMITTED FOR EXECUTION. Notes: 1. You will not receive any messages detailing whether or not the report processed successfully. 2. In general, depending on the size of the requested product, the report should be on your printer or in the text file 5-15 minutes after execution. 3. If you have received no error messages when updating or executing the report, and are not receiving the product, contact your local G081 Manager. They can check to see if there is a backlog or if the report was in error. For information about Program 9029 click on the next to the program number. 88

89 Program 9072 User Printer Change Purpose This program allows a user to review and/or change the G081 printer ID assigned to their User- ID where they receive G081 products when Print is entered in the Device or the Output field on an online program. Input Instructions Once you access the G081 system, select F9072 User Printer Change from the Program Listing page. You can also enter 9072 or F9072 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9072 Screen 89

90 FIELD DISPLAY ONLY EXPLANATION User ID You assigned G081 User Identification (USERID). User IDs are assigned by your local G081 Manager. DISPLAY ONLY Base Code The Base Code to which the User ID is assigned will be displayed in this field. DISPLAY ONLY Generic LTerm Associated Printer This is the Generic Logical Terminal that allows/limits the users ability to process transactions and programs in G081. These are assigned/managed by local G081 Managers. The G081 Printer assigned to the LTERM and/or the User ID will be displayed in this field. This is where you currently receive printed products requested through G081. Update this field to the desired G081 printer ID. Note: A valid G081 printer ID must be input. REQUIRED to change Associated Printer field Change It? Check this field to Change the G081 printer where your products will be output. For information about Program 9072 click on the next to the program number. 90

91 Program 9141 Deployed Aircraft Information Purpose This program is used to maintain a list of deployed (staged) aircraft. This is for aircraft where operational control is changed. Deployed analysts, schedulers, or MOC personnel must update program at the deployed site. Home station is responsible to ensure this is accomplished and must update it if the deployed location fails to do so. Input Instructions Once you access the G081 system, select Program 9141 Deployed Aircraft Information from the Program listing page. You can also enter 9141 or F9141 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9141 Screen 91

92 FIELD EXPLANATION The Transaction code tells G081 what information it must gather to respond to your request. Select an option from the Trans drop-down menu or enter it manually. Trans A to add a new record B to query by deployed base D to delete an existing record P to query by possessed base or command S to query by aircraft serial number T to go to top of records U to update an existing record 1 7 to bring the details of a specific queried item to the top on the screen. Used after processing Transaction B or P, 1-7 refers to the numbered line items in the output. Enter the 8-position Aircraft Serial Number. A/C ID Select an option from the menu (sorted by MDS) by clicking the A/C ID icon or enter it manually. Enter the 4-position GEOLOC code for the aircraft s deployed location. For classified locations, enter CLSA, CLSB, CLSC, etc. Base More instructions will be provided for the deployed analyst as to which CLS code to use. Contact HQ AMC at DSN: or input the base or command to query. Select an option from the menu by clicking the Base icon or enter it manually. MDS Start Date Enter the MDS for any query option and program will only return data for given MD/MDS. Leave blank for ALL. Enter the Date the aircraft first arrived at the deployed location. This field may be left Blank for query, but if entered, query will search from this Date. Select an option by clicking the Start Date icon or enter it manually in MM/DD/YYYY format. 92

93 FIELD End Date EXPLANATION This is the Date the aircraft last departs from the deployed location, returning or rotating back to Home Station. For queries, a date may be entered for a stop range or left Blank to search to the end of the database. Note: This field must be left Blank until the aircraft departs the deployed location. Select an option by clicking the End Date icon or enter it manually in MM/DD/YYYY format. Reason aircraft is on deployment. Reason Code (Start) Time (End) Time DP = Tasked deployment. EX = Unit exercise/ore/ori. WX = Weather (hurricane, tornado, etc). RC = Runway closure. Enter the valid ZULU Time that the aircraft first arrived at the deployed location. This field may be left Blank for query, but if entered, query will search from the previously specified Start Date at this Time. Manually input the ZULU Time in HHMM format. Enter the valid ZULU Time that the aircraft last departed from the deployed location, returning or rotating back to Home Station. For queries, time may be entered for a stop range or left Blank to search to the end of the database. Note: This field must be left Blank until the aircraft departs the deployed location. Manually input the ZULU Time in HHMM format. Possess Base Possessing CMD DISPLAY ONLY NO INPUT REQUIRED Program will display and save this data when a record is added. DISPLAY ONLY NO INPUT REQUIRED Program will display and save this data when a record is added. 93

94 FIELD EXPLANATION Enter the reason the aircraft is rotating out of the deployed location. You can use one of the below options, when applicable, or other reason(s) specific to the situation. Remarks ISO HSC Depot Deployment ended No longer required Note: Using G081 Program 8038 option Y, scan the aircraft's 1st arrival date & time (start date/time). Look under the deployed base ICAO code first arrival time and enter that date/time into Program On final departure from the deployed base, also scan the aircrafts final departure (end date/time) under the deployed base ICAO code. Enter that date/time into Program

95 Progam 9141 Output Screen Any inquiry (Transaction B, P, or S ) will display the output list in the bottom section by numbered line item. The above screen output shows an inquiry by aircraft serial number. It displays: The date and time of a deployed aircraft s possesion change, The base that possessed the aircraft during the deployment, and The remarks for Due Home Date (DHD) To pull up the details of a specific aircraft record, input the specified line number in the Transaction field and click the Submit button. For information about Program 9141 click on the next to the program number. 95

96 Program 9151 Mass Deployment/Undeployment Form Purpose This program provides the ability to deploy or undeploy multiple personnel from a single shop or base, displays deployed personnel at a specific or multiple locations. It also resets Program 9046 Personnel Management Screen. Input Instructions Once you access the G081 system, select F9151 Mass Deployment/Undeployment Form from the Program Listing page. You can also enter 9151 or F9151 in the Search box. The system will present the screen pictured below. Program 9151 Screen 96

97 FIELD Key EXPLANATION A 2-position access code, or Key, may be required to process this program. Key codes are available through your local G081 Manager. REQUIRED FIELD Current Base This is the 4-position Base code. If left blank, G081 will default to your home Base. Select an option from the menu by clicking the Base icon or enter it manually. REQUIRED FIELD Shop To list personnel for a specific Shop, enter the Shop mnemonic. For a valid list of Shop mnemonics for your base, process Program 9045 to inquire. Deploy Base Deployed MIL/CIV Labor Code Res Labor Code From Date To Date Reset To 9046 Action This is the 4-position Base code. If left blank, G081 will default to your home Base. Select an option from the menu by clicking the Deployed Base dropdown or enter it manually. Check the box to display deployed personnel report. Select employment stated from MIL/CIV dropdown. Select Labor Code from the Labor Code dropdown. Select reserve status from the Res Labor Code dropdown. Enter or select from the Date Icon the start date of the deployment. Enter or select from the Date Icon the end date of the deployment. Check this box to bring up Program 9046 to make edits. Bottom of Screen Select applicable line under this column to display Deploy or Undeploy. If Deploy is selected it will reflect a d or Undepoly will reflect a u. 97

98 FIELD Employee Number Name Labor Code Res Labor Code Deploy Base EXPLANATION DISPLAY ONLY NO INPUT REQUIRED Displays the individual s Employee Number DISPLAY ONLY NO INPUT REQUIRED Displays the individual s name formatted as Last, First MI. Auto-updates or Manually Change Displays the labor code. Auto-updates or Manually Change Displays the Reserve Labor Code. This is the 4-position Base code. If left blank, G081 will default to your home Base. Select an option from the menu by clicking the Deploy Base dropdown or enter it manually. Deployed From Date Displays the start date of the deployment. Deployed To Date Displays the end date of the deployment. Shop Displays the Shop. Mil-Civ Displays member s duty/employment status. Origin Base Displays Origin location Last Base Displays last location Result Displays updated results for applicable line. 98

99 Program 9151 Input Mandatory fields are Current Base and Shop then click submit to display information on the bottom portion of the screen. 99

100 Program 9151 Input Under Action select Deploy or Undeploy or right click on the line for the Deploy or Undeploy to display. NOTE: If the Action column is not required right click on any header to uncheck the Action box. This will remove the Action column on the bottom portion of the screen. 100

101 Program 9151 Input Once you select deploy or undeploy there will be a d or u displayed under the Action line. For information about Program 9151 click on the next to the program number. 101

102 Program 9153 DIT MDC / Error Correction Purpose This program allows the Data Integrity Team (DIT) Members to perform reviews of all documented MDC within a specified time range, identify errors in reviewed documentation, correct errors once they have been identified and un-flag identified errors. Input Instructions Once you access the G081 system, select F9153 DIT MDC / Error Correction from the Program Listing page. You can also enter 9153 or F9153 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9153 Screen 102

103 FIELD Key EXPLANATION REQUIRED FIELD A 2-position access code, or Key, is required to process this program unless you are the local G081 Manager. Access Keys are available through your local G081 Manager. REQUIRED FIELD Base This is the 4-position Base code. If left blank, G081 will default to your home Base. Select an option from the menu by clicking the Base icon or enter it manually. REQUIRED FIELD Start Date Defaults to maximum allowable date range or you can enter desired start date using calendar tool. Calendar will only allow selection of available dates. Note: You cannot select a date earlier than the date shown. REQUIRED FIELD End Date Defaults to 5 days back from current day or you can enter desired end date using the calendar tool. Calendar will only allow selection of available date. Note: You cannot select a date later than the default date shown. Wrk Ctr / Shop Errors Only Deployed Only Homestation Only Input the work center code (IE 1E710, QE710, ETC) or shop mnemonic (IE FUEL, ELEN, A1AFM, ETC). Leave blank for All. Note: If the shop Mnemonic is input, MDC records for all work center codes in that shop will be displayed Check this box to see a report of all errors identified for the input base and Work Center/ Shop. Errors can be corrected by using the action buttons in the Error Report. Check this box to view records for a deployed base only. Check this box to view records for Homestation only. 103

104 FIELD Print Total Records EXPLANATION Click to process a Web-Focus Report of all identified, corrected and uncorrected and uncorrected errors that can be saved in PDF Format and/or sent to any network printer. Displays the total number of records available for review or in the error report, as applicable. Program 9153 Input 104

105 Program 9153 Input Once the DIT Review Report is displayed, the DIT Member will have 4 actions available for MDC review documentation: Reviewed, No Errors: Used to identify the MDC had been reviewed and no errors were found Reviewed Errors Found: Used to identify that the MDC record has been reviewed and errors in documentation have been found. When this is selected, the DIT Member will be provided with a list of standard error types to select from and use, as applicable. Currently up to 5 Error Types can be identified per MDC Record. There is also a 9999 Error Code which allows manual text input for any error not identified in one of the standard options (DO NOT use this option for notes or remarks it ll be count as identified errors). (Max 100 Bytes) Unflag Errors: Used to unflag previously identified errors that were entered in error or explained by User to be correct. Selecting this option will remove all flagged errors for the job being reviewed. For example, if 3 errors were identified and only 1 should be unflagged, if 3 errors were identified and only 1 should be unflagged, you will need to re-input the errors for the other 2 items. 105

106 Program 9153 Input MDC Update: This option will only be available after errors have been flagged for the MDC record being reviewed. When selected, a modified 9056 screen displays to allow corrections to identified errors, which will be displayed in the bottom portion of the pop-up NOTE: The box next to each error item must be checked once the error has been corrected in order to update the release. For information about Program 9153 click on the next to the program number. 106

107 Program 9154 Supervisor MDC Review / Error Correction Purpose This program allows the Shop Supervisors to perform daily supervisory review of all documented MDC, identify errors in documentation, correct errors once they have been identified and unflag identified errors using the Supervisor option. MDC for the current day plus 3 days back will be available for review by supervisors. It also allows maintainers to review identified errors and process MDC corrections using the User option and the Error Only Report. Input Instructions Once you access the G081 system, select F9154 Supervisor MDC Review / Error Correction from the Program Listing page. You can also enter 9154 or F9154 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9154 Screen 107

108 FIELD Key EXPLANATION REQUIRED FIELD A 2-position access code, or Key, may be required to process this program. Key codes are available through your local G081 Manager. REQUIRED FIELD Base This is the 4-position Base code. If left blank, G081 will default to your home Base. Select an option from the menu by clicking the Base icon or enter it manually. REQUIRED FIELD Super/User Homestation Only Start Date Select S for Supervisor or U for Users from the Super/User drop-down or enter it manually. Check this box to see records for homestation only. REQUIRED FIELD Defaults to maximum allowable date range or you can enter desired start date using calendar tool. Calendar will only allow selection of available dates. Note: You cannot select a date earlier than the default date shown. REQUIRED FIELD End Date Defaults to 3 days back from current day or you can enter desired end date using the calendar tool. Calendar will only allow selection of available date. Note: You cannot select a date later than the default date shown. Wrk Ctr / Shop Errors Only Emp#/UserID Input the work center code (IE 1E710, QE710, ETC) or shop mnemonic (IE FUEL, ELEN, A1AFM, ETC). Leave blank for All. Note: If the shop Mnemonic is input, MDC records for all work center codes in that shop will be displayed Check this box to see a report of all errors identified for the input base and Work Center/ Shop. Errors can be corrected by using the action buttons in the Error Report. Enter an employee number or UserID to see only records for that employee or UserID. 108

109 FIELD Deployed Only Print Total Records EXPLANATION Check this box to only see records for a deployed base. Click to process a Web-Focus Report of all identified, corrected and uncorrected and uncorrected errors that can be saved in PDF Format and/or sent to any network printer. Displays the total number of records available for review or in the error report, as applicable. Program 9154 Input 109

110 Program 9154 (User Option) User: Everyone can run a User option report if you have the Program 9154 loaded to your shop (If it is required and not loaded to your shop contact your local G081 Manager). No key is required for this action. The user can place their Employee ID # or UserID to bring up all the documentation for the entered Employee ID # or UserID. The Homestation Only and Deployed Only display options are available. 110

111 Program 9154 (Supervisor Option) Once the Supervisory Review Report is displayed and the Action button is selected, the Supervisor will have 4 actions available for MDC review documentation: Reviewed, No Errors: Used to identify the MDC had been reviewed and no errors were found Reviewed Errors Found: Used to identify that the MDC record has been reviewed and errors in documentation have been found. When this is selected, the DIT Member will be provided with a list of 15 standard error types to select from and use, as applicable. Currently up to 5 Error Types can be identified per MDC Record. There is also a 9999 Error Code which allows manual text input for any error not identified in one of the 15 standard options. DO NOT use this option for notes or remarks it ll be count as identified errors. (Max 100 Bytes) Unflag Errors: Used to unflag previously identified errors that were entered in error or explained by User to be correct. Selecting this option will remove all flagged errors for the job being reviewed. For example, if 3 errors were identified and only 1 should be unflagged, if 3 errors were identified and only 1 should be unflagged, you will need to re-input the errors for the other 2 items. 111

112 Program 9154 Input MDC Update: This option will only be available after errors have been flagged for the MDC record being reviewed. When selected, a modified 9056 screen displays to allow corrections to identified errors, which will be displayed in the bottom portion of the pop-up NOTE: The box next to each error item must be checked once the error has been corrected in order to update the release. For information about Program 9154 click on the next to the program number. 112

113 CHAPTER 4 Batch Programs 113

114 Batch Programs Batch programs are 67XXX series programs which provide you with specific data based on the fields you enter using Programs 9058 and Your local G081 Manager will initially set up your batch programs and then grant you access to process most of your own batch reports. Why Can't I Just Process The Report Back To My Screen? Because the reports that are generated contain vast amounts of data, the output is typically too large to be displayed on your screen. The output is generated to your designated printer, or you may save the output to a text file. What Will This Chapter Do For Me? There are many different batch programs, several of which may provide data necessary to do your job. This chapter will show you what batch programs are normally processed to assist you in accomplishing your duties, as well as some others that have been identified as commonly used batch programs to consider for your use. Processing Batch Programs The local G081 Manager will initially set up the batch programs for you. If you need to update or change the input fields, you can do so by accessing Program Program 9058 will display all batch or FOCUS jobs that are loaded to your shop. If you determine you need to update the fields, Program 9058 will automatically pass you to Program 9029, which will allow you to update the card columns. The following pages provide information on how to use Program 9058 to update and process your batch programs. 114

115 Program 9058/9029 Shop Batch Job/FOCUS Report Update and Execution Purpose These programs are used to execute and update the Job Control Language (JCL) for Batch jobs and FOCUS reports. The output is sent to your destination printer or text file. Program 9058 displays all Batch jobs and FOCUS reports for your work center and Program 9029 is used to update the Batch jobs and FOCUS reports. Input Instructions Once you access the G081 system, select F9058 Shop Batch Job Execution from the Program Listing page. You can also enter 9058 or F9058 in the Search box and click on the magnifying glass. The system will present the screen pictured below. Program 9058 Screen 115

116 FIELD Base Shop EXPLANATION This is the 4-position Base code. If left Blank, G081 will default to your base. Select an option from the menu by clicking the Base icon or enter it manually. This is the mnemonic of the Shop for the batch products being processed. If left Blank, G081 will default to your shop. This field is left Blank for normal processing. Selecting Y will display a menu of jobs, but no executions or updates will be allowed. Selecting P will print the entire list to the users default printer. Select an option from the Scan List drop-down menu or enter it manually. Scan List Notes: 1. For normal processing, only the users Base and Shop can be input. They may also be left Blank to default to the users assigned designators. 2. When using the Y or P options, any Base and/or Shop may be input. Alternate Printer When Batch/FOCUS programs are created, a default G081 printer destination is assigned. If you want to process a Batch/FOCUS program to a different location, input the desired G081 Printer ID in the Alternate Printer field. This will bypass the printer specified in the Dest field on Program Note: If the Dest field is Blank on Program 9029, you must always put a valid G081 Printer ID in the Alternate Printer field in order for the job to run. Note: Pressing Enter or Submit without inputting any information in the fields will produce a menu of job names that you can update/execute for your Base and Shop. 116

117 Program 9058 Output Screen 117

118 FIELD EXPLANATION The Action tells G081 what type of transaction you want to process. Click the Printer icon to execute the report. Action Click the Notepad icon to update/edit the report before executing it. When you select the notepad icon, you will be passed through to Program 9029 to review, make updates and/or execute the report. Note: Not all Batch/FOCUS reports are updateable. This access is built within the report by your local G081 Manager. Contact them if you have any questions. *** The Below Fields Are Display Only *** This information can only be updated via Program 9029 by your local G081 Manager This is usually the mnemonic of the Shop for the batch products being processed. However, this can be any 1-5 character identifier as Shop determined by the G081 Manager or the person who requested the report. Job Copies Update Description Result This field shows the name of the Batch/FOCUS report. The name can be 1-8 characters long and is determined by the G081 Manager or the person who requested the report. The number of copies produced when the report is executed will be shown in this field. Typically, it will be 001 but up to 255 copies can be produced in a single execution. This identifies whether or not the Batch/FOCUS can be Updated by users via Program If this field displays NO, you will not have a Notepad icon in the Action field and must contact your local G081 Manager to make changes to the report. Provides a more detailed Description of the report. Once you have executed the report, this field will display a green if it processed successfully or a red X if it did not. For information about Program 9058 click on the next to the program number. 118

119 Input Instructions When you click on the Notepad icon the Program 9058 report list, it will pass you to Program As shown in the following pages, this is where you will make any required/allowed updates to process the Batch/FOCUS report. Rows available for update are identified with an asterisk (*) in Column 79; non-updateable rows will be greyed-out. Click in the row to edit the field. You must contact your G081 Manager to request changes to rows that have not been identified for user update. Program 9029 Screen 119

120 FIELD EXPLANATION Only those fields that are accessible via the Program 9058 pass-thru will be covered in this section The Action tells G081 what type of transaction you want to process. When accessing Program 9029 from Program 9058, the only actions allowed are: Action E Submit job for processing R Reset to Program 9058 U Update the lower part of the screen Select an option from the Action drop-down menu or enter it manually. Note: If Action is left Blank, changes will not be saved and the screen will reset to the original data. Dest Forms Copies Must be a valid G081 printer ID. If left Blank, the output will default to the printer shown in the Org field. Only used to request duplex printing. Ensure that the identified output G081 printer has duplex capability. Input DUPX to use this feature and (fill the entire field) to clear the request. This 3-position numeric field is used to request the number of printed products the user requires. Numbers between 001 and 255 are allowable. If left Blank, the field will default to 001 copy. To make updates/changes to allowable fields: Change the input fields or card columns 7) Scroll down to the row 8) Click in the row to open it for update 9) Over-type the data you need to change/update 10) Verify your changes/updates and ensure there is a U in the Action field 11) Click Submit to save changes/updates 12) Verify Batch/FOCUS update was successful, then input an E in the Action field to process the job. 120

121 Program 9029 Screen With Requested Report Data Only line items with an asterisk (*) in column 79 can be updated via Program 9058 pass-thru access Making Updates: 3. Identify which line(s) of input can be updated by looking for the asterisk in Column Using the Steps 1-5 specified on the previous page under Change the input fields or card columns, change the requested data for the report, as needed. Notes: a. The insert feature should be OFF. You want to over-type the old data with the new to ensure you do not move the asterisk from Column 79. b. If the asterisks is moved or deleted, you will no longer be able to make updates to that line. Only the G081 Manager can fix this field if altered. c. BEFORE processing the U Action to update the report, always double check that the asterisks is still located in Column 79. If it is not, leave the Action field blank and hit Submit to reset everything. Then, re-input your updates. 121

122 Program 9029 Screen With Updates Saved Start_Date changed to Stop_Date changed to Ensure (*) is still in Col 79 Reviewing Updates and Processing Report: 3. Once you have processed the U action, in the status line at the bottom of the screen, you should see the message UPDATE ACCEPTED. a. If the update was unsuccessful, you will receive an ERROR MESSAGE b. Make any necessary corrections and re-process the report c. If you continue to experience issues, contact your local G081 Manager for assistance 4. Review your changes to be sure everything is correct and then submit the job for processing by selecting E for the Action and click Submit. 122

123 Program 9029 Screen After Execution Report Processed: 2. In the status line you should see the message JOB SUBMITTED FOR EXECUTION. Notes: 1. You will not receive any messages detailing whether or not the report processed successfully. 2. In general, depending on the size of the requested product, the report should be on your printer or in the text file 5-15 minutes after execution. 3. If you have received no error messages when updating or executing the report, and are not receiving the product, contact your local G081 Manager. They can check to see if there is a backlog or if the report was in error. For information about Program 9029 click on the next to the program number. 123

124 Program A/C Departure Delay List Program Purpose This program provides a list, based on data card specifications, of departure delay information. Information is passed from Program 9018 inputs and/or Program 9070 updates. Information is stored in the M387SR Database. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 124

125 FIELD EXPLANATION Enter a valid 4-position Base Code or for All bases or XXXX for non-g081 aircraft for a specific ICAO. A list of Base Codes can be found in Program This is the 4-position valid ICAO for the departure station or leave blank for All. Only required for non-g081 when base = XXXX. This identifies the 4-position Mission Design (MD) or the 5-position Mission Design Series (MDS). This is a Mandatory field Note: If you are at a unit that needs more than one MDS (such as C130 and LC130) the process can run as 2 steps in 1 job. Key WC130 for WC130H, Key LC130 for LC130H. Enter one of the following Delay Field options: 14 D for Delay O for On-Schedule. A or Blank for All aircraft Enter one of the following Start Date options: Beginning date (YYDDD) Daily provides previous day(s) Prev provides previous month Curr provides current month Enter Stop Date (YYDDD). This is based on scheduled Take-Off date Note: Leave blank when using Daily/Prev/Curr option, except previous day(s) option is used with "Daily" and use number in YY of Stop Date. Leave blank for all or enter a specific Aircraft Serial Number. 125

126 FIELD 40 EXPLANATION Enter one of the following Report Type options: D - Detail S - Summary B - Both with Detail print first Enter one of the following Sort Option options: 42 1 for MDS, Base, SCH T/O Date &Time, Depart Station Blank for Base, MDS, SCH T/O Date &Time, Depart station 2 for Base, MDS, Actual T/O Date & Time 3 for Base, MDS, ACFT, Actual T/O Date & Time Enter a 5-position Owning Work Center. Program Output Screen For information about Program click on the next to the program number. 126

127 Program Workload Distribution Histograms Purpose This program produces three Histogram/Reports from data selected from the M379S11 database segment. Workload Distribution Histogram for Average Number of Workers by Hour of the Day, Workload Distribution Histogram for Productive Man hours by Hour of the Day, Workload Distribution Histogram for Productive Man hours by Day of the Month. Note: This program will sort and print up to 50 shops for a given base. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 127

128 FIELD EXPLANATION Enter a valid 4-position Base Code. A list of Base Codes can be found in Program Enter the 1- to 5-position Shop Mnemonic for the Beginning Work Center. Enter the 1- to 5-position Shop Mnemonic for the Ending Work Center. Leave Blank if for only one (the Beginning Work Center). Enter from 1 to 6 Months for number of Months of data desired. Enter one of the following Span Code options: 1 - Full Calendar Month 2 - Date to Date Month(s) 3 - Calendar Month(s) With Current Enter one of the following Offshore Request options: 17 Y - Will Include Offshore N - Or BLANK will Exclude Offshore 128

129 Program Output Screen For information about Program click on the next to the program number. 129

130 Program Highest Failing Rate Work Unit Code/Reference Designators Purpose This program searches a range of Work Unit Codes (WUC)/Reference Designators (REFDES) and lists the WUC/REFDES with the highest number of failures. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 130

131 FIELD EXPLANATION This identifies either the 4-position Mission Design (MD) or the 5- position Mission Design Series (MDS). (left-justified) This is the 1- to 5-position Work Unit Code (WUC) or the 1- to 10- position Reference Designator (Ref Des) to obtain failures. This is either the 4-position Base code, command option (AMC, AFR, ANG, PAC, EUR or ATC) or M for CONUS bases. If left blank, all Bases will be displayed. Note: This option only works for possessing bases. It will not work for en route bases. This identifies either the 6-position Aircraft Identification Number or the 8-position Aircraft Serial Number. If processing the Sorties Option, an entry in this field is required. If left blank, all Aircraft will be displayed. Enter a number from 1-99 to limit the number of Work Unit Codes (WUC) you wish to display on your report. This is the number of Months of data you wish to display on your report. Enter a number from 1-6. The Span Code allows you to select what type of months or Span you wish to display. Enter one of the following Span Code options: for full calendar months 2 for date-to-date months 3 for full calendar months plus the current month s data. The current month data is in addition to the number of requested months in the Month Span field. An example is if you entered 6 for a month span you would get the past 6 months of data plus the data for the current month. 4 for full calendar months including current month data. The current month data is part of the Month Span entered. An example is if you entered 6 for the Month Span you would get the past 5 months of data plus the data for the current month. If you would like to include those failures that occurred Offshore or away from home station, enter a Y. 131

132 FIELD EXPLANATION The Sort Option allows you to select how you would like your data displayed or Sorted. Enter one of the following Sort Option options: for sort by total failures 2 for sort by total Mean Time Between Failures (MTBF) 3 for sort by total type 1 and type 2 failures 4 for sort by total type 1 failures 5 for sort by total type 2 failures If you are processing the report for a specific aircraft, you may enter a Y in the Sortie Option field to replace flying hours with the number of Sorties flown. This field is used only for C-17 aircraft. Enter an R for a report by Reference Designator or enter a W for a cross referenced report by Work Unit Code (WUC). To limit your research by Date, enter the Start Date, in the YYMMDD format. If left blank, G081 will use the current Date. If you entered a start Date, enter a Stop Date, in the YYMMDD format. You may not select more than 6 months of data. To limit your report by Action Taken, you may enter up to 5 Action Taken Codes. This field is used only for C-17 aircraft. If your report is to show accumulated totals, you may enter a Length of 4, 6, 8, or 10. This option groups the Reference Designators together based on a partial Reference Designator. Because Little Rock AFB has more than one Command assigned to base, the report may be processed by entering the Command Code. Note: This job is long running and requires extra time.. you must use 060 minutes in the Max Run Time field on Program 9029 JCL update. Start-Date and Stop-Date are optional. Use instead of Month-Span and Span-Code for a specific Date range. 132

133 Program Output Screen For information about Program click on the next to the program number. 133

134 Program Aircraft Possessed Hour Distribution Purpose This program lists all the possessed hour utilization summary and the top 25 Work Unit Codes/Reference Designators (WUC/REFDES) causing Not Mission Capable Maintenance (NMCM), Not Mission Capable Supply (NMCS), Not Mission Capable Both (NMCB), Partially Mission Capable Both (PMCB), Partially Mission Capable Supply (PMCS), or Partially Mission Capable Maintenance (PMCM) conditions for a specific aircraft, group of aircraft, base, or fleet. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 134

135 FIELD EXPLANATION Card 1 Input Option The Date field provides you with many different Date options for processing this report. Enter one of the following options: 1-5 The beginning Date in the YYDDD format in columns 1-5 and enter the ending Date in the YYDDD format in columns 6-9 The Date, in the YYMM format, in columns 6-9, to obtain data for any prior month(s) which data is desired. Columns 1-5 and 10 should be blank Curr in columns 6-9 for the current month s data. Columns 1-5 and 10 should be blank Prev in columns 6-9 for the previous month s data. Columns 1-5 and 10 should be blank NN in columns 6-9 for number of days from current date. Columns 1-5 and 8-10 should be blank Enter the Start Date in the Julian format YYDDD. 1-5 when Curr or previous is used in columns 6-9 when Prior months is entered in columns 6-9 when number of previous days in columns 6-7 Enter the Ending Date in the Julian Format YYDDD if a Start YYDDD is entered in column 1-5. Column 1-5 must be blank to use the below options: 6-9 Curr in columns 6-9 for the current month s data. Columns 1-5 and 10 should be blank Prev in columns 6-9 for the previous month s data. Columns 1-5 and 10 should be blank NN in columns 6-9 for number of days from current date. Columns 1-5 and 8-10 should be blank 135

136 FIELD 11 EXPLANATION This is only needed if column 6-10 has a YYMM value in it. Used to select 1, 2, or 3 months back from date entered in column 6-9. Enter the Time Span in column 11. Enter one of the following options: 1 for 1 month of data 2 for 2 months of data 3 for 3 months of data This designates the Type of status you want to display. Enter the Enter one of the following Type options: 12 A for all status B for Not Mission Capable Both (NMCB) D for all Not Mission Capable (NMC) Reports E for all Partially Mission Capable (PMC) Reports F for Partially Mission Capable Both (PMCB) G for Partially Mission Capable Maintenance (PMCM) M for Not Mission Capable Maintenance (NMCM) P for Partially Mission Capable Supply (PMCS) S for Not Mission Capable Supply (NMCS) T for Total Not Mission Capable Maintenance (TNMCM) X for Total Not Mission Capable Supply (TNMCS) This is the Command you want to process the report for. Enter one of the following Command options: 13 A for all commands E for Air Reserve Component F for Air Force Materiel Command O for Air Force Reserve Q for Air Mobility Command T for Air Education and Training Command 4 for Air National Guard P for Pacific Air Force D for US Air Forces in Europe 136

137 FIELD EXPLANATION If interested in processing this report for a specific system, subsystem, or Work Unit Code (WUC), Enter a 2-, 3-, or 5-position WUC. Enter one of the following WUC options: for the 25 highest 6-position REFDES (C-17 only) 5 for the 25 highest 5-position (component) WUCs 4 for the 25 highest 4-position REFDES (C-17 only) 3 for the 25 highest 3-position (subsystem) REFDES/WUCs 2 for the highest 2-position (system) REFDES/WUCs 0 for the 25 highest 10-position REFDES (C-17 only) A 2-position system for the 25 highest 5-position WUC for the user specified system A 2-position system and * for the 25 highest 3-position user specified subsystem A 3-position subsystem for the 25 highest 5-position WUC for the user specified subsystem This is the 4-position Base code or All for all Bases. This identifies either the 4-position Mission Design or the 4-position Mission Design (MD). If interested in the specific Series for the Mission Design Series (MDS) entered here. To Include depot possessions, enter a Y. Card 2 Input Option If processing this report by individual Aircraft, enter the 8-position Aircraft Serial Number. Only 8 Aircraft Serial Numbers are allowed per input card. 137

138 Program Output Screen For information about Program click on the next to the program number. 138

139 Program Monthly A/C Status Summary Purpose The purpose of this program is to display utilization or status data for one aircraft, one base or an entire fleet. The Aircraft Utilization Report will reflect total aircraft hours by mission categories and by specific squadrons. This program can run multiple input cards. Please use this method when multiple runs are needed. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task. Program Status Option Screen 139

140 FIELD 1-6 EXPLANATION Card 1 Input Option Aircraft Status Report This identifies the Beginning Date for your report. Enter it in the YYMM format for the full month option, or enter it in the YYMMDD format for the partial month option. Program starts with selection and goes back 12 months. Enter one of the following Beginning Date options: The Date Curr for the current month Prev for the previous month This identifies the Ending Date for your report in the YYMM format. Leave this field blank for the full month option, or enter it in the YYMMDD format for the partial month option. This identifies the 8-position aircraft Serial Number, 4-position Base Code (left justified), or enter All for all aircraft. Note: All Bases option will not include current day. This field identifies the Record Type. Enter an X if the A/C Report is desired (could be long report). This field will not work if you selected All in the Serial Number field. This identifies the 4-position Mission Design (MD) or the 5-position Mission Design Series (MDS). Input Y to include Depot time. Blank or N to exclude. 140

141 FIELD EXPLANATION This identifies the Command you want to process the report for. If left blank all commands are selected. Enter X in one of the columns below: 28 'X' to include AMC CMD 29 'X' to include ANG CMD 30 'X' to include AFRC CMD 31 'X' to include AETC CMD 32 'X' to include AFMC CMD 33 'X' to include PACAF CMD 34 'X' to include USAFE CMD 35 'X' to include OTHER Card 2 Input Option Aircraft Utilization/Flying Hours Report This identifies the Utilization field. Enter UTIL to signal to the program to execute Utilization logic. This identifies the Beginning Date for your report. Enter it in the YYMM format. This identifies the Ending Date for your report. Enter it in the YYMM format. This is the 4-position Base code or enter All for all bases. A list of Base codes can be found in Program Enter the 8-position Aircraft Serial Number if the report is for a specific Aircraft or leave blank for All Serial Numbers. This identifies the 4-position Mission Design (MD) or the 5-position Mission Design Series (MDS) and is entered if you are processing the report for all aircraft. 141

142 FIELD EXPLANATION This identifies the Command you want to process the report for. Enter X in one of the columns below: 30 'X' to include AMC CMD 31 'X' to include ANG CMD 32 'X' to include AFRC CMD 33 'X' to include AETC CMD 34 'X' to include AFMC CMD 35 'X' to include PACAF CMD 36 'X' to include USAFE CMD 37 'X' to include OTHER If left blank, all commands are selected You may further limit your report to a certain Squadron by entering a Squadron Code. See Program 9020 Help for the squadron code listing. The Report Option allows you to select either a detailed or summary Report. 40 Enter one of the following Report options: X for detail Leave blank for summary The Sort Option allows you to choose how you want your data Sorted. Enter one of the following Sort options: 41 A for aircraft (aircraft, date, base) B for base (base, aircraft, date) (default) C for command (command, base, aircraft, date) D for base and date (base, date, aircraft) 142

143 Program Status (Summary) Option Output Screen Program Utilization (Summary) Option Output Screen 143

144 Program Utilization (Detailed) Option Output Screen For information about Program click on the next to the program number. 144

145 Program NRTS /Base Self Sufficiency Report (Summary or Detailed) Purpose This program is used to produce a Not Repairable This Station (NRTS) and Repair Action Report for in shop work. Program has a detailed or summary option. Program only uses off equipment Maintenance Data Collection (MDC) data. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 145

146 FIELD 1-4 EXPLANATION This is the 4-position Base Code of the Base you are processing this report for. A list of Base Codes can be found in Program The Report Type is used to define your selection criteria Enter one of the following options: D for Not Repairable This Station (NRTS) detailed report S for Not Repairable This Station (NRTS) summary report Input a 3- to 5-position Work Unit Code (WUC), or a 10-position Reference Designator (REFDES) (for C-17 aircraft only). For support equipment, the WUC is usually made up of part of the equipment designator. For more information about WUCs for support equipment, contact your local Plans, Scheduling, and Documentation Section. Input a number from 1 to 6. This is the number of Months, or Month Span you want to view. The Span Code allows you to select how you want your monthly data displayed. Select one of the following options: Allows you to view a full calendar month 2 - Allows you to view date to date month(s) 3 - Allows you to view calendar months with current month 4 - Date Range (must fill in columns 34-45) The Offshore Request is a 1-position field. Enter one of the following options: 18 Y - Include Offshore Requests N - Exclude Offshore Requests Leave column 19 blank. 146

147 FIELD EXPLANATION This identifies either the 4-position Mission Design (MD) or the 5-position Mission Design Series (MDS). This field must be entered if you are processing a summary report in Report Type field. Enter 1 to 9 Action Codes for Detail Report. Must enter at least one Action for detail report. Enter Start Date for report in MMDDYY format. Use with Span Code 4 only. Enter End Date for report in MMDDYY format. Use with Span Code 4 only. Program Output Screen For information about Program click on the next to the program number. 147

148 Program Database Search Purpose This program provides several reports from the M383 database (9029/9058). The available reports are: 01 - Job Statistics by shop, 02 - Job Detail Print, 03 - Job Report by Database Name (FOCUS only), 04 - Deadline Job Report by day, time, shop and job, 05 - Deadline Job Report by printer day and time, 06 - Database search for a given string, 07 - Jobs not executed/updated within limit. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen Note: This program has multiple input cards (lines). The input cards may be coded and left in place even when they are not needed for the specific option being requested. In fact, you are better off entering the cards and leaving them there. 148

149 This report will give you all the Batch/Focus Reports for a base and or a base and shop. Use Report 01 and indicate base and or base/shop. See Note #1 on Help screen for Program 9029 setup. FIELD EXPLANATION Enter the word Report (columns 9-10 blank) and the desired Report Number in columns Enter one of the following options: Card for a job statistics by shop report 02 for a job detail print report 03 for a job report by database name 04 for a deadline job report by day, time, shop, and job 05 for a deadline job report by printer day and time 06 for a database search for a given string 07 for jobs not executed/updated within limit Leave columns blank. Card Card This field is used if you are entering a Search Range for your data. Enter the word SRRange. Leave columns 9-10 blank. If you are entering a Search range, enter the Starting Search Key. Leave column 28 blank. If you entered a starting search key, enter the Ending Search Key. Leave columns blank. Enter the Base, Shop, or Job Name. Leave columns 9-10 blank. 149

150 FIELD EXPLANATION If you intend to limit the data to certain characteristics, enter the Selection Code in column 11. Leave column 12 blank. Enter one of the following options: Card Card E for equal to G for greater than L for equal to or greater than M for less than or equal to S for less than U for unequal to If you entered a selection code, enter the Value. G081 will use this as a limiting parameter. If entering more than one Compare To Value List, separate by commas. Columns are blank. You can have 3 of these cards. Enter the word Search. Leave columns 9-10 blank. Enter the 2- to 30-position Search Strings. You can have 6 of these cards for up to 6 different search strings. Leave columns blank. Enter TimeLim. Leave columns 9-10 blank. The Time Limit is the number of units (days, hours, or minutes) to limit the report to. The Time field is used to designate whether you are processing the report for day, hours, and minutes. Enter one of the following options: 14 D for days H for hours M for minutes Leave columns blank. 150

151 Program Output Screen For information about Program click on the next to the program number. 151

152 Program Aircraft Flying Hours Purpose This program provides a listing of aircraft flying hours for a twelve month period to include the current month and the eleven preceding months. A request for a selected Base and MDS will display each aircraft serial number and the hours flown by the selected base for each aircraft with a summary line for the base. A request for the "total fleet" will display each aircraft serial number and the hours flown by each base that has flown the aircraft during the past 12 months. A base summary line is displayed which shows the total hours flown by each base. Additionally, a command summary line is shown with a total line. This program displays flying hour data which has been input via Program Input Instructions Once you access the G081 system, select F9058 Shop Batch Job Execution from the Program Listing page. You can also enter 9058 or F9058 in the Search box and click on the magnifying glass. Follow instructions for Program 9058/9029 processing in this manual to access the screen pictured below. Note: This Batch job may or may not be available in your shop. These reports are provided by request ONLY. If you want access to this Batch job through Program 9058, contact your local G081 Manager Batch Screen 152

153 COLUMNS EXPLANATION The below only covers updates/edits for the Bottom Portion of the screen ONLY. Refer to instructions for Program 9058/9029 processing in this manual for detailed information on updating the Top Portion of this screen. Enter the 4-byte Base Code of the requesting base. 1-4 For a list of Base Codes, use Program Enter the 4-byte Base Code of the base to be included in the report. Enter ALL for ALL bases. For a list of Base Codes, use Program Enter the 4-byte Mission Design (MD) or the 5-byte Mission Design Series (MDS) of the aircraft. Specify the 2-byte Squadron to limit the report to ONLY those designated. Up to 5 squadrons can be requested. Leave Blank for ALL squadrons. Enter one of the following options: AMC for Air Mobility Command AET for Air Training Command AFE for European Command AFR for Air Force Reserve ANG for Air National Guard LOG or SYS for Depot data PAF for Pacific Command ALL for all commands Enter F to List Amberly, Brize Norton and Trenton. Enter A to Add Amberly, Brize Norton and Trenton to the report. 153

154 Program Update Screen Once you have made the desired changes to the report parameters: 1. Update/Save your changes by processing a U Action 2. Review updated line to ensure it is correct 3. Execute the report by processing an E Action 4. Process an R Action to return to Program 9058 Note: When editing the data line, ensure the asterisks remains in Column 79. If it is deleted or moved and you update the report, you will no longer be able to edit that line. You will have to contact your local G081 Manager to fix the Batch job for user access. 154

155 Program Output Screen For information about Program click on the next to the program number. 155

156 Program Maintenance Data Collection (MDC) Work Summary Reports Purpose This program produces an MDC Work Summary or activity identifier report including Standard Reporting Designator (SRD), Mission Design Series (MDS), Identification Number (ID), Type Maintenance (TM), and total labor hours by work center for both on and off equipment work. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 156

157 FIELD 1-4 EXPLANATION This is the 4-position Base Code of the Base you are processing this report for. A list of Base codes can be found in Program This is the 2-position Report Type and designates the type of report you would like to process. 5-6 Enter one of the following options: AI for command code reports WS for work summary reports If you are processing a Report type of WS, enter the 1-position Report Option. 7 Enter one of the following options: D for active duty R for reserve B for both This is the type of Labor you want to display on your report. Input the Labor Option in column Enter one of the following options: D for direct labor I for indirect labor If you are processing a report type of AI. Enter AL to print all Command Codes. This is the starting point you want G081 to Begin its search. Input the Begin Date in the YYMM format. Enter the Ending Date in the YYMM format. Note: There is a 3 month limit per request. 157

158 Program Output Screen For information about Program click on the next to the program number. 158

159 Program REFDES Analysis Report On Current MDC Data Purpose Program builds the report from the live database which contains six months of current data from the G081 database which has not been removed and written to a history tape. If you need to process a report for past data that has already been transferred to a history tape, process batch Program This program produces a Mean Time Between Failures/Mean Time Between Repairs/Mean Man Hour (MTBF/MTBR/MMHR) report for a selected time period by Work Unit Code (WUC). It can also be run for one month only. The failures are reported by Type 1, 2, and 6. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 159

160 FIELD EXPLANATION This is the 4-position Base Code of the base you are processing this report for. A list of Base codes can be found in Program This is the Date you want G081 to begin its search of the database. Input the Start Date in the YYMM format. This is the Date you want G081 to conclude its search of the database. Input the Stop Date in the YYMM format. If you are interested in one Work Unit Code (WUC)/Reference Designator (REFDES) or a range of WUCs/REFDESs, enter the 1-10 position WUC Start. If you entered a WUC Start, and you are interested in processing a report for a range of WUCs/REFDES s enter the Ending WUC. If you want to Print Detail lines, enter Y or N for no. Enter a Y if you would like the Print total for the Work Unit Code Component (1st position of the WUC) or N for no. If you would like to Print a total for the Work Unit Code Subsystem (3rd position of the WUC) enter a Y or N for no. If you would like to Print a total for the Work Unit Code (WUC) System (2nd position of the WUC) enter a Y. This is the 1-position Print Overall. If you would like a grand total, enter a Y. This identifies either the 4-position Mission Design (MD) or the 5- position Mission Design Series (MDS). This is used for G081 to select those items which fall within a specified range for calculating Mean Time Between Failure (MTBF). 160

161 FIELD EXPLANATION If you entered a Start Mean Time Between Failure (MTBF) range in Field 12, enter Stop range. This is the 1-position Month Option. Input M for current month information. Enter X to exclude ISO, HSC and Refurb data. ISO is any job with 'B' or 'C' in 4th position. Refurb is any job with '65' or '66' in position 4-5. Leave blank to include this data. If the report is desired for a specific aircraft, enter the 8-position Tail Number. Program Output Screen 1 161

162 Program Output Screen 2 For information about Program click on the next to the program number. 162

163 Program Supply Information Request Purpose The purpose of this program is to request supply data stored in G081. Select only jobs with open JCN s and/or supply. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 163

164 FIELD EXPLANATION This identifies the Type of Report you wish to process. Enter one of the following options: 1 A for aircraft E for support equipment O for off-equipment Blank for all The Scope of Request allows you to select information for the entire fleet, base, command, or single piece of equipment or aircraft. Enter one of the following options: 2 A for fleet B for command C for base D for single aircraft E for specific piece of support equipment Here you will enter information based on what was entered in column 2. This will either be the Base code, Command, or equipment serial number. A list of Base codes can be found in Program Enter one of the following options: AMC, AFR, ANG, AETC, PACF, AFMC, or USFE if you entered B in column 2 Base Code if you entered C in column 2 Serial Number if you entered D in column 2 the Base Code and 6-position ID Number if you entered E in column 2 Leave blank if you entered A in column 2 The Work Center Mnemonic field allows you to select information for a specific Work Center. 164

165 FIELD 18 EXPLANATION The Due In Only field allows you to list jobs which have supplies on order. Enter one of the following options: K to select open supply documents which are in Kill status Y to select jobs which have a supply quantity greater than zero Leave blank for all The Sort Option allows you to select how you would like your data displayed or Sorted. Enter one of the following options: A to sort by ID/serial number, Job Control Number (JCN), and then document number B to sort by document number C to sort by stock number and then document number D to sort by document number and then ID/serial number E to sort by Urgency Justification Code (UJC), ID/serial number, and then JCN F to sort by UJC, ID/serial number, and then document number G to sort by stock number, ID/serial number, and then document number H to sort by source of supply (SOS) and document number I to sort by SOS and stock number J to sort by off-base requisition number and document number K to sort by off-base requisition number and stock number L to sort by Mission Design Series (MDS) and base M to sort by work center and then ID/serial number N to sort by Work Unit Code/Reference Designator (WUC/REFDES) and serial number O to sort by cannibalization date The Days Back field is used for showing only items from current Day minus the requested number of Days. If left blank this will default to 90 days. 165

166 FIELD EXPLANATION Enter a Y in this field to show Only items in Tail Number Bin (TNB). The UJC field allows you to select data for specific Urgency Justification Codes (UJC) in this field. You many select up to four UJC codes. This identifies the 4-position Mission Design (MD) or the 5-position Mission Design Series (MDS). If processing option C in the Scope of Request field, you may further define your report by selecting Assigned or Possessed aircraft. Enter one of the following options: A for assigned aircraft B for aircraft that are possessed and assigned by the same base E for aircraft that are possessed or assigned to the requested base P for possessed aircraft only Leave blank for possessed aircraft only Enter Y to include Depot items, or leave blank to exclude Depot items. To select supply for a Specific WUC or Reference Designator (REFDES), enter the REFDES. If you want the report to Break after each Sort option, which was entered in column 19, enter a Y. Enter Y to view the Cannibalization (Cann) Report. 166

167 FIELD EXPLANATION If you entered a Y in column 49 you must enter the Cannibalization Report Range in this field. Enter one of the following options: 1 for past 30 days 2 for past 60 days 3 for past 90 days A for current month B for past month C for two months from current month Enter Y to show only those records with an Off Base Requisition Number. Leave blank or enter N to show all. Because Little Rock AFB has more than one command assigned, the report may be processed by entering a command code in this field. Enter one of the following options: 52 N to show only the Air Mobility Command (AMC) unit at Little Rock AFB Y to select the Air Education and Training Command (AETC) unit at Little Rock AFB Leave blank to show both units together Enter your Line Spacing in this field. Enter one of the following options: 53 1 or leave blank for single spacing 2 for double spacing 3 for triple spacing 4 for quadruple spacing Note: For Cann report individual equipment can be requested. Can be for entire base or for 1 aircraft, 1 engine or 1 shop (350 Tags). If running for one of the above (not base option) you will need to input specific aircraft serial or engine/age ID or shop. 167

168 67051 Output Screen For information about Program click on the next to the program number. 168

169 Program Lists Database Schemas Purpose This program will produce a list for all database schemas. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task. Program Screen 169

170 FIELD Enter %FOC2DCD. EXPLANATION This is the Database number that you wish to print the schema for. You may also enter All to print all schemas. You can also input non-ims databases such as PRLIST, ALLUSERS, MA379FF, and MA379TF. This allows you to select the desired schema. Enter the IMS/NON-IMS. Enter one of the following options: ALL for list of all databases IMS for production database Enter IMSD for development database IMST for test database NON for list of other FOCUS databases Note: Using 'All' in Column 11 and 20 will get you entire list of all FOCUS files. 170

171 Program Output For information about Program click on the next to the program number. 171

172 Program Base/Aircraft Commitment Rate Report Purpose This program produces several reports showing the availability of AFI aircraft. Note: The Control Record detail information is listed on the help screen. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 172

173 FIELD EXPLANATION This identifies either the 4-position Mission Design (MD) or the 5- position Mission Design Series (MDS). Enter the Aircraft Type. This is the 4-position Base Code. A list of Base Codes can be found in Program Leave blank if processing the report by command. The Option codes tell G081 what information it must gather to respond to your request. Depending on the type of Report you wish to generate, you must select from only those Options. 10 Enter one of the following options: W for AFI /Commitment Rate Report F for AFI /Commitment Rate Report w/fenced trainers S for Summary Report (Space) same as S The Mission Select field is used to process a report for a specific aircraft configuration. Enter an X in one of the following fields to select a mission/configuration: ADS in column 11 SKE in column 12 SOLL in column 13 MISSILE in column 14 GPS in column 15 JACC in column 16 If processing a report option of W or F in the Report Option field, you may enter a Y to print Detail records. 173

174 FIELD EXPLANATION If you are not processing the report for a specific base, enter the Command. Enter one of the following options: AMC for Air Mobility Command AFE for USAFE AFR for Air Force Reserve ANG for Air National Guard ARC for Air Reserve Component MTC for Air Force Materiel Command PAF for PACAF ALL for all commands The Transient field allows you to select only Transient or En route aircraft. 22 Enter one of the following options: E for en routes (Option Z only) Y for transient This field is used if you are processing the report for C135 aircraft. It allows you to select either EC135, KC135, or both Enter one of the following options: N for KC135 only Y for EC135 only Leave BLANK for all C135 aircraft Enter an X for TCAS. 174

175 Program Output Screen For information about Program click on the next to the program number. 175

176 Program Units and Labor Actions Purpose This program provides three Maintenance Data Collection (MDC) labor analysis reports. The Units by Action Taken Code report summarizes the number of units reported by Action Taken code for a given work center and date range. The Indirect Labor report totals units and labor hours by Work Unit Code (WUC). The Direct Labor report totals units and labor hours by Standard Reporting Designator (SRD) and type maintenance. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 176

177 FIELD EXPLANATION The Option codes tell G081 what information it must gather to respond to your request. The Option is the type or report you want to generate. Enter one of the following options: 1 for Units By Action Taken Code Report 2 for Indirect Labor Report 3 for Direct Labor Report This is the 4-position Base Code. A list of Base Codes can be found in Program This identifies the 5-position Work Center. This is required if you selected Option 1. This identifies the Beginning Date for your report. Enter it in the YYMM format. This is a required entry on all options. This identifies the Ending Date for your report. Enter it in the YYMM format. If left blank, the selection will be for the month and year entered as Begin Date. Enter 2- to 10-positions of the Beginning Work Unit Code (WUC) or Reference Designator (RD). This is required if you selected Option 3 in the Option field. Enter 2- to 10-positions of the Ending Work Unit Code (WUC) or Reference Designator (RD). This is required if you selected Option 3 in the Option field. If left blank, the selection will be the based on WUC/RD, WUC/RD subsystem, or WUC/RD system entered as Begin WUC. Notes: 1. The 'Direct Labor Report' can be a long running job if a large WUC span is requested. 2. The job card for this program requires a run time parameter of '50'. If the '50' is not in the job card, the job will bring IMS down. 177

178 Program Output Screen For information about Program click on the next to the program number. 178

179 Program High 25 Hours/Failures By Work Unit Code Purpose The purpose of this program is to provide a listing of the Work Unit Code (WUC) (Top 25 by total in hours and/or failures). Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 179

180 FIELD EXPLANATION This is the 4-position Base Code or Command. A list of Base Codes can be found in Program Enter one of the following options: The 4-position Base code AFR for Air Force Reserve bases ALL for a list of all base codes AMC for Air Mobility Command bases ANG for Air National Guard bases EUR for United States Air Forces Europe PAC for Pacific Air Forces This identifies either the 4-position Mission Design (MD) or the 5- position Mission Design Series (MDS). Note: You may also enter AGE for Aerospace Ground Equipment (AGE) or PMEL for Precision Measurement Equipment Laboratory (PMEL). If processing the report for only one Aircraft, enter the 8-position Aircraft Serial Number or leave Blank for All. The Report Option allows you to select how you would like your data displayed. Enter one of the following options: 18 G to produce the report in group form. All bases will be added together I to produce the report in individual form. All bases will be displayed individually Leave blank to produce a report that combines the G and I option into one report The Type Option allows you to select what Type of report you wish to process. 19 Enter one of the following options: F for a high failure report M for a high man-hour report Leave blank for both reports 180

181 FIELD EXPLANATION Enter the Date in the MMYY format in the Date Select field. Select the past 6 months of data. Leave blank for the most current data, to include the previous month plus 5 prior months. Note: Report only works for current 6 full calendar months. Because Little Rock AFB has more than one Command assigned to the base, the report may be processed by entering the Command Code in this field. Enter command code '1L for AMC or '0J' for AETC. If left blank, all data will be displayed, regardless of the Command. The Type Failure allows you to limit your report to certain Types of Failures. Enter one of the following options: Space will include Types 1 and 2 1 for Type 1 failures 2 for Type 2 failures 6 for Type 6 failures You may select a specific WUC/REFDES or group of WUCs/REFDESs by entering a Starting WUCREFDES. If you entered a Starting WUC/REFDES and want to select a group of WUCs/REFDESs, enter an Ending WUC/REFDES. 181

182 Program Output Screen Note: The failure report only reports on "failures". This is determined by certain Action Taken codes, How Mal codes and card types. Only On-equipment actions count as failures. For information about Program click on the next to the program number. 182

183 Program Maintenance Summary by System Purpose This program depicts the number of maintenance actions for a system or subsystem, to include various meantime calculations. This is the batch version of Program This is a very long running program. It can easily run for thirty minutes if six months of data is selected for several WUC s. Also selecting the B print option for several WUC s will generate a very long listing. Card types P/R/T/L are excluded. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 183

184 FIELD EXPLANATION Enter the 1- to 5-positions of the Starting Work Unit Code (WUC) or the 10-position Reference Designator (REFDES). This identifies the Ending Work Unit Code (WUC). Enter the same number of positions as you entered in the Start WUC field. This is the 4-position Base code or Command. A list of Base codes can be found in Program Enter one of the following options: The 4-position Base code AETC for Air, Education and Training Command bases ALL for all bases AFR for Air Force Reserve bases ANG for Air National Guard bases AMC for Air Mobility Command bases EUR for United States Air Forces Europe PAC for Pacific Air Forces Enter a number from 1 to 6 depending on how many Months you wish to view. The Span Code allows you to select how you want your monthly data displayed. Enter one of the following options: for full calendar months 2 for date to date months 3 for calendar months with current month 4 for one calendar month (current month) 5 must use with begin and end date This is the Beginning Date for your report. Enter the Date if you selected 5 in the Span Code field. Enter it in the YYMM format. This is the Ending Date for your report. Enter the Date if you selected 5 in the Span Code field. Enter it in the YYMM format. 184

185 FIELD EXPLANATION This identifies either the 4-position Mission Design (MD) or the 5- position Mission Design Series (MDS). If you want to process the report for a specific aircraft, enter the 8-position Aircraft Serial Number. The Print Option allows you to select the type of data or totals you want to display on the output. Enter one of the following options: 48 B to print bit-piece (5-position) WUC C to print component (4-position) WUC S to print subsystem (3-position) WUC T to print system total (2-position) WUC Note: Each print option prints the requested level and all levels above it. For instance, the 'B' option will print the 5-position WUC plus the 4-, 3-, and 2-position lines. The Sortie or Hour Option field is used to calculate the Mean Time Between Failures (MTBF) either based on Sorties or Hours Enter one of the following options: H to calculate elements using operating hours S to calculate elements using sorties Enter an X to exclude Offshore Data from your selection. Leave blank to include Offshore Data. This is the 1-position When Discovered (WD) option which allows you to exclude WD codes K and M. This is for C17 aircraft only. Enter a W for a Work Unit Code (WUC) Report, or leave blank for a Reference Designator (REFDES) Report. This field is for Little Rock AFB. If interested in processing this report for one organization, enter the 2-position Command Code that the organization is assigned to. You may leave this field blank to display all records for Little Rock, regardless of the Command. 185

186 Program Output Screen For information about Program click on the next to the program number. 186

187 Program Aircraft Status By WUC Purpose This program produces an aircraft status report by Work Unit Code (WUC) from data selected from the M359S15 Data Base Segment. Totals will be printed for each Partially Mission Capable (PMC) and Not Mission Capable (NMC) per WUC. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen 187

188 FIELD EXPLANATION This is the 4-position Base Code or 3-position command. A list of Base Codes can be found in Program Enter one of the following options: The 4-position Base code All for a list of all base codes AFR for Air Force Reserve bases ANG for Air National Guard bases AMC for Air Mobility Command bases PAF for Pacific Air Force bases AFE for United States Air Forces Europe bases This identifies either the 4-position Mission Design (MD) or the 5- position Mission Design Series (MDS). You may also enter All for all Aircraft.. This identifies either the 6-position Aircraft identification number, 8- position Aircraft serial number, or leave blank for All Aircraft. This is the Starting year and month that you want G081 to begin its search of the database Enter one of the following options: It in the YYMM format Curr for current month s data Prev for previous month s data This is the Ending year and month that you want G081 to End its search of the database. You may only request up to 6 months of data. Enter it in the YYMM format. Not required for Curr and Prev options. If you are interested in one Work Unit Code (WUC)/REFDES or a group of WUC s/refdes s, enter the 1-10-position Beginning WUC/REFDES. If you are interested in one Work Unit Code (WUC)/REFDES or a group of WUC s/refdes s, enter the 1- to 10-position Ending WUC/REFDES. 188

189 FIELD EXPLANATION The Report Option allows you to select how you would like your data displayed. Enter one of the following options: 46 A for a report by aircraft, then Work Unit Code (WUC) B for a report of top 10 WUCs by PMCB, PMCM, PMCS, NMCM, NMCB, NMCS C for a report of total hours by base, not WUCs D for a report of top 25 WUCs regardless of status E for a report requested by AMC for a flat file report G for a report for WUC by system. Lists scheduled and unscheduled NMC with percentages H for a report for WUC by system for all aircraft for a base. List scheduled and unscheduled NMC with percentages Leave blank for a report of all WUCs Note: E option output fields are in the following order: PMCB, PMCM, PMCS, NMCMS, NMCS, NMCBS, NMCBU, NMCMU, TOTAL. 47 If you enter an X in this field it will Combine C005A and C005B aircraft. This identifies the Command. If left blank, all Commands will be displayed. Enter one of the following options: E for Air Reserve Component (ARC) F for Air Force Materiel Command (AFMC) O for Air Force Reserve (AFR) P for Pacific Air Forces Q for Air Mobility Command (AMC) T for Air Education and Training Command (AETC) U for United States Air Forces Europe 4 for Air National Guard (ANG) To Include maintenance possessions, enter a Y. This field is used to increase Option D to top 50 by entering 50. Leave column 53 blank. 189

190 Program A Option Output Screen Program B Option Output Screen 190

191 Program G Option Output Screen For information about Program click on the next to the program number. 191

192 Program Debrief Reports Purpose This program will review basic debrief data (M366S12 Data). It will review discrepancies and corrective action Maintenance Data Documentation (MDD) for all in-flight report discrepancies for a sortie. It will also review aircraft system/subsystem capability rates, detailed break-fix rates, summarized break-fix rates by base, maintenance delivery reliability rates and breaks by WUC/REFDES and fix time consumers by WUC/REFDES. Input Instructions The fields you will be inputting are listed below. The Data Entry Fields which follow provide you with a field-by-field description of the entries needed to complete the task Batch Screen Note: A 'Break' is any arrival with a landing status code '3'. Once there Is a break, program looks for unscheduled NMC status data which has to start up to 6 minutes prior to arrival or 90 minutes afterwards (prior to next flight or scheduled maintenance). Once it finds this, the NMC time counts 192

193 toward the fix time. The count stops at either FMC, PMC, scheduled NMC or next departure. The NMC time must be from Pilot Reported Discrepancy (PRD) jobs. Report will not pull status with assignment code of B* or D*. FIELD EXPLANATION Enter the 1-position Report Option in this field. following options: Enter one of the for basic debrief report 2 for sortie(s) with JCN(s) and MDD report 3 for system capability report 4 for detailed break-fix rate report 5 for summarized break-fix rates by base 6 for maintenance delivery reliability rates by base 7 for summarized breaks and fix-time consumers by WUC/REFDES Enter the 8-position Aircraft Serial Number to limit the reports data to a specific aircraft. Leave blank for base/fleet reports. 193

194 FIELD EXPLANATION Enter the 4-position Base Code or Command Code. If used, then columns 2-9 should be blank. A list of Base Codes can be found in Program Note: This is a required input for Option 6, optional for all others. Or enter one of the following options: AETC for all AETC bases AFR for all AFR bases AMC for all AMC bases ANG for all ANG bases EUR for USAFE bases PAF for PACAF bases ARC combined report for AFR and ANG bases ACTV combined report for AMC and AETC bases ALL for all bases (must use "ALL" with En route report) Note: If run for Little Rock, columns must be filled in. Enter the Possessed/Assigned Aircraft Indicator in this field. If left blank, the program assumes Possessed. This is optional. Enter one of the following options: A for Assigned Aircraft P for Possessed Aircraft only E for En routes report (works with Options 1, 2, 4 and 5) D for Deployed report (must input Depart Base in columns 38-41) Enter any valid 7-position Mission Design Series (MDS). Precede with 0 s (i.e. 000KC135R, 00C005B ). If running serial number, leave these columns blank. 194

195 FIELD EXPLANATION Enter the Start Date in the YYMMDD format. Leave blank if the number of days from the current Date is used. Enter one of the following options: Curr for current month Prev for previous full month Enter the Stop Date in the YYMMDD format. If you entered a Start Date in the Start field, enter a Stop Date. If left blank, it defaults to the Current Date. If Number of Days from Current is used, then this field must be blank. Enter the 3-position Number representing the previous Number of Days to include in this report. Enter a valid Departing Base. This is required for Report Option 6. Data returned will be limited to that G081 Base code. Leave blank for default monthly base analysis reporting. Also this input is the deployed base when running the D (Deployed) Option. It must be input for that option. Enter a valid Arrival Base. Data returned will be limited to that G081 Base code.. Enter the Landing Status. This is an optional field. Leave blank to pull all open and closed debrief records. Enter one of the following options: 45 1 for aircraft mission capable with no additional discrepancies 2 for aircraft or system that has minor discrepancies but is capable of further mission assignment within normal turnaround times 3 for aircraft or system that has major discrepancies in mission essential equipment that may require extensive repair or replacement prior to further mission assignment. The discrepancy may not affect safety-of-flight and the aircraft may be NMC flyable 'A' to combine status code '1' and '2' 'B' to combine status code '2' and '3' 'O' to select open debriefs (works with report option 1) 195

196 FIELD Card EXPLANATION Enter the Effective Sortie in this field. This field is optional. Enter it in column 46. Enter one of the following options: Y to select only Effective Sorties N to select only non-effective Sorties Leave blank to select all Sorties Enter the 12-position Mission Number to select debrief records with matching Mission Numbers. This field is optional. Enter the 4-position Mission Symbol to select debrief records with matching Mission Symbols. This field is optional. Enter Y to receive the data in a semicolon-delimited file. This is valid for report Options 1, 2, 3, 5, and 6. Used with Option 7 only. Enter a number between 01 and 50 to get the specified number of breaks by WUC/REFDES and Fix-Time Consuming WUC/REFDES. If left blank, the report defaults to 10. Input 0019 for AMC, 0314 for AETC. Input X in this field to exclude those aircraft tail numbers used by NASA or the NSF. Limit Report Parameters to a Squadron. Enter a Y to display squadron. Indicate which squadron(s) to limit report. You can enter up to 10 squadron codes or leave blank for All. 196

197 Program Output Screen (Option 1) 197

198 Program Output Screen (Option 2) 198

199 Program Output Screen (Option 4) Note: See the Help Screen for the output screen header explanations for each option. For information about Program click on the next to the program number. 199