![](media/image1.wmf){width="2.170138888888889in"
height="2.170138888888889in"}

**GOVERNMENT-WIDE**

**COMMON AVIATION MANAGEMENT INFORMATION SYSTEM STANDARD**

**(C-AMIS)**

###### PROCESS DEFINITION AND DATA DICTIONARY

**VERSION 3.0**

**September, 2000**

Prepared For:

**UNITED STATES GENERAL SERVICES ADMINISTRATION**

# OFFICE OF GOVERNMENT-WIDE POLICY

# AIRCRAFT MANAGEMENT POLICY DIVISION

18th & F Streets NW, Room G241

Washington, DC 20405

In Behalf Of The:

# INTERAGENCY COMMITTEE FOR AVIATION POLICY

Prepared By:

**Varone Consulting Group, Inc.**

####### 30103 Merchant Court

Great Falls, Virginia 22066

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

#### EXECUTIVE SUMMARY

In 1977 and again in 1983, the United States General Accounting Office
(GAO) reported on many cases of wasteful and inefficient aircraft
management practices by Federal civilian agencies. GAO found that
agencies acquired aircraft without justifying their cost-effectiveness
and used them for a variety of missions including routine administrative
travel. Following the 1983 report, the Federal Executive branch took
positive actions to improve the management and use of Government
aircraft resources. The Office of Management and Budget (OMB) Circular
A-126 requires the Administrator of the General Services Administration
(GSA) to maintain a single coordinating office for Government-wide
aircraft management that applies to all Government-owned, leased,
chartered, and rented aircraft and related services operated by
Executive Branch agencies except aircraft while in use or in support of
the President or Vice President.

The GSA developed the Federal Aviation Management Information System
(FAMIS) to meet its responsibilities pursuant to the OMB Circular A-126
including the ability to annually collect and report Government-wide
non-military aviation information to the OMB and Congress. In response
to a 1989 GAO follow-up study, the OMB directed the GSA to form a
Government-wide committee on aviation policy, the Interagency Committee
for Aviation Policy (ICAP). The ICAP then established a Management Data
and Systems Subcommittee (MDSS) to emphasize the development of policy
and automated tools for the purpose of minimizing operational costs and
improving management and use of Government aviation resources.

The ICAP requested a study to determine the current status of Federal
aircraft Management Information Systems (MISs), and to develop a new
common aviation MIS. The result of that study was a Common Aviation
Management Information System (C-AMIS) Concept of Operation (CONOPS)
that defined the initial C-AMIS Functions and Processes and an aviation
MIS Data Dictionary. GSA Aircraft Management Policy Division (staff
symbol MTA) personnel and a contractor, the Varone Consulting Group,
Inc. (VCG) performed the study. Conducted in five steps, the study
resulted in the following major findings:

-   There was and is a significant overlap in the features and functions
    of many of the agency-unique aviation support systems.

-   There was a wide range of information technology (IT) system
    capabilities among systems designed to accomplish the same tasks
    from agency to agency.

-   Agencies were continuing to actively develop their own systems.

-   There was no single system suited for Government-wide
    implementation.

    As a result of this study, the team recommended that a new
    Government-wide common, system standard be developed to meet
    ICAP-directed initiatives while providing agencies with a complete
    and effective tool to manage their aviation resources as well as to
    facilitate the GSA/FAMIS reporting function. The GSA further
    determined that FAMIS would no longer meet the needs of the
    agencies.

    The GSA and the ICAP, through the MDSS, jointly determined that the
    FAMIS should be replaced with a more modern, web-based, interactive
    system that would provide user agencies with a tool that could help
    them to manage their aviation assets more efficiently and
    effectively. The GSA and VCG then developed the Federal Aviation
    Interactive Reporting System (FAIRS) based on the C-AMIS standard,
    modern web-based technology, the need to provide agencies with
    information and management tools, and the GSA Office of
    Government-wide Policy (OGP), Office of Personal Property and
    Transportation (staff symbol MT) information technology (IT)
    architecture. At this time, MT also rewrote Circular A-126 to
    incorporate the C-AMIS-based FAIRS reporting requirements. In
    addition, the GSA with concurrence from the OMB also determined that
    the reporting requirement covered under FAIRS would be limited to
    civilian agency aviation assets.

The subsequent definition and development of FAIRS caused several
changes that had to be retrofitted to C-AMIS as well as incorporated
into A-126. FAIRS caused redefinition of the business rules for managing
aviation assets as well as the basic definition of the use of the
assets. In addition, the FAIRS rules redefined more precisely, the state
of Federal aircraft, i.e., leased owned, bailed, etc. All of the GSA
definition and development efforts were reviewed with the MDSS to ensure
agency acceptance.

The following table contains the high-level functions of FAIRS that were
based on C-AMIS.

+-----------------------------------------------------------------------+
| **High-level Functions**                                              |
+=======================================================================+
| Capture detail, per flight data that relates to the cost of operating |
| an aircraft. The data must be captured in a manner that places a      |
| minimum burden on the agencies and does not interfere with the        |
| agency's ability to meet its operational objectives. The data will    |
| become a history repository.                                          |
+-----------------------------------------------------------------------+
| FAIRS has a flexible and powerful query package that will enable      |
| GSA/MTA and the user agencies to perform Operations Research and/or   |
| statistical analysis on the data to support the development of        |
| informed policy.                                                      |
+-----------------------------------------------------------------------+
| Captures all aviation data to allow:                                  |
|                                                                       |
| -   Establishment of guidelines and "benchmarks" by GSA/MTA for use   |
|     of aviation assets,                                               |
|                                                                       |
| -   Measurement of agency effectiveness against predefined benchmarks |
|     and other agency performance,                                     |
|                                                                       |
| -   Provide a mechanism for the oversight agencies to measure         |
|     performance against goals, and                                    |
|                                                                       |
| -   Measurement of impact of policy change by GSA/MTA.                |
+-----------------------------------------------------------------------+
| Operates in an "open" systems environment without unique information  |
| technology requirements that are incompatible with the overall GSA    |
| technical architecture.                                               |
+-----------------------------------------------------------------------+
| Incorporates Aircraft Bluebook data to be able to include into        |
| cost/price and make/buy analysis.                                     |
+-----------------------------------------------------------------------+
| Incorporates the Aviation Cost Accounting Guide (CAG) narrative to be |
| able to reference when making complex decisions.                      |
+-----------------------------------------------------------------------+
| Incorporates the Aircraft Residual Guide data to be able to include   |
| into cost/price and make/buy analysis.                                |
+-----------------------------------------------------------------------+
| Incorporates the Aircraft Cost Evaluator data to be able to include   |
| into cost/price and make/buy analysis.                                |
+-----------------------------------------------------------------------+
| Provides interactive communications with the agencies that allows     |
| them a way to retrieve the necessary information to more effectively  |
| manage their aviation assets.                                         |
+-----------------------------------------------------------------------+
| Provides secure communications for those agencies where it would      |
| endanger mission or agents lives to have a security leak.             |
+-----------------------------------------------------------------------+
| Enables agencies to gracefully and easily provide data to GSA with a  |
| minimum of effort from their existing aviation operations system.     |
+-----------------------------------------------------------------------+
| Avoids agency inputting the same data multiple times for their own    |
| internal information system and a GSA Government-wide policy making   |
| executive information system.                                         |
+-----------------------------------------------------------------------+

There are two principal differences between the replaced FAMIS and
FAIRS. The first is the volume of data. The second difference is that
FAIRS is interactive. The agency ability to see their own data as well
as to compare their data against aggregated Government-wide data
presents a significant new analysis tool to the agencies. FAIRS also
will allow GSA/MTA to develop or change aviation policy based on
analysis of real data. The most important advantage with FAIRS is that
it enables agencies to begin to apply GP&RA to Government aviation.

**TABLE OF CONTENTS**

+-----------------------------------------------------------------+-----+
|                                                                 | **  |
|                                                                 | Pag |
|                                                                 | e** |
+-----------------------------------------------------------------+-----+
|                                                                 |     |
+-----------------------------------------------------------------+-----+
| 1\. INTRODUCTION . . . . . . . . . . . . . . . . . . . . . . .  | 1   |
| . . . . . . . . . . . . . . . . . . . . . . . . .               |     |
+-----------------------------------------------------------------+-----+
|                                                                 |     |
+-----------------------------------------------------------------+-----+
| 2\. STUDY ENVIRONMENT . . . . . . . . . . . . . . . . . . . . . | 7   |
| . . . . . . . . . . . . . . . . . . . .                         |     |
+-----------------------------------------------------------------+-----+
|                                                                 |     |
+-----------------------------------------------------------------+-----+
| 3\. METHODOLOGY . . . . . . . . . . . . . . . . . . . . . . . . | 9   |
| . . . . . . . . . . . . . . . . . . . . . . .                   |     |
+-----------------------------------------------------------------+-----+
|                                                                 |     |
+-----------------------------------------------------------------+-----+
| 4\. ANALYSIS AND FINDINGS . . . . . . . . . . . . . . . . . . . | 15  |
| . . . . . . . . . . . . . . . . . . .                           |     |
+-----------------------------------------------------------------+-----+
| > 4.1. C-AMIS Standard High-level Requirements . . . . . . . .  | 15  |
| > . . . . . . . . . . . .                                       |     |
+-----------------------------------------------------------------+-----+
| > 4.2. C-AMIS Standard Development Issues . . . . . . . . . . . | 18  |
| > . . . . . . . . . . . . .                                     |     |
+-----------------------------------------------------------------+-----+
| > 4.3. C-AMIS Standard Module Descriptions . . . . . . . . . .  | 20  |
| > . . . . . . . . . . . . .                                     |     |
+-----------------------------------------------------------------+-----+
| > 4.3.1 Property Management Module . . . . . . . . . . . . . .  | 23  |
| > . . . . . . . . . . .                                         |     |
+-----------------------------------------------------------------+-----+
| > 4.3.2 Finance and Accounting Module . . . . . . . . . . . . . | 21  |
| > . . . . . . . . . . .                                         |     |
+-----------------------------------------------------------------+-----+
| > 4.3.3 Maintenance Module . . . . . . . . . . . . . . . . . .  | 21  |
| > . . . . . . . . . . . . . . .                                 |     |
+-----------------------------------------------------------------+-----+
| > 4.3.4 Logistics Module . . . . . . . . . . . . . . . . . . .  | 22  |
| > . . . . . . . . . . . . . . . .                               |     |
+-----------------------------------------------------------------+-----+
| > 4.3.5 Training Module . . . . . . . . . . . . . . . . . . . . | 22  |
| > . . . . . . . . . . . . . . . .                               |     |
+-----------------------------------------------------------------+-----+
| > 4.3.6 Contract Support and Acquisition Module . . . . . . . . | 23  |
| > . . . . . . . .                                               |     |
+-----------------------------------------------------------------+-----+
| > 4.3.7 Agency-unique Requirements Module . . . . . . . . . . . | 23  |
| > . . . . . . . .                                               |     |
+-----------------------------------------------------------------+-----+
| > 4.3.8 Communications and Administration Module. . . . . . . . | 23  |
| > . . . . . .                                                   |     |
+-----------------------------------------------------------------+-----+
|                                                                 |     |
+-----------------------------------------------------------------+-----+
| 5.0 RECOMMENDATIONS . . . . . . . . . . . . . . . . . . . . . . | 25  |
| . . . . . . . . . . . . . . . . . . .                           |     |
+-----------------------------------------------------------------+-----+
|                                                                 |     |
+-----------------------------------------------------------------+-----+
| APPENDICES                                                      | 27  |
+-----------------------------------------------------------------+-----+
|                                                                 |     |
+-----------------------------------------------------------------+-----+
| A. ACRONYM LIST . . . . . . . . . . . . . . . . . . . . . . . . | 29  |
| . . . . . . . . . . . . . . . . . . . . . . .                   |     |
+-----------------------------------------------------------------+-----+
| B. C-AMIS STANDARD PROCESSES . . . . . . . . . . . . . . . . .  | 31  |
| . . . . . . . . . . . . . . .                                   |     |
+-----------------------------------------------------------------+-----+
| C. C-AMIS STANDARD DATA DICTIONARY . . . . . . . . . . . . . .  | 71  |
| . . . . . . . . . . .                                           |     |
+-----------------------------------------------------------------+-----+

**LIST OF EXHIBITS**

+-----+------------------------+----------------------------------+----+
| #   |                        |                                  | ** |
| ### |                        |                                  | Pa |
| # E |                        |                                  | ge |
| XHI |                        |                                  | ** |
| BIT |                        |                                  |    |
+-----+------------------------+----------------------------------+----+
|     |                        |                                  |    |
+-----+------------------------+----------------------------------+----+
| 4-1 | Aviation MIS Issues    |                                  | 20 |
|     | That Could Impede      |                                  |    |
|     | Success                |                                  |    |
+-----+------------------------+----------------------------------+----+

**1. INTRODUCTION**

In 1977 and again in 1983, the United States General Accounting Office
(GAO) reported on many cases of wasteful and inefficient aircraft
management practices by Federal civilian agencies. At that time, GAO
found that agencies acquired aircraft without justifying their
cost-effectiveness and used them for a variety of missions including
routine administrative travel. Following the 1983 report, the Federal
Executive branch took positive actions to improve the management and use
of Government aircraft resources.

Management responsibility for Government aircraft resources is directed
by the Office of Management and Budget (OMB) Circular A-126 (revised May
26, 1992 and draft revision in August, 2000) and promulgated by the
General Services Administration (GSA) Federal Property Management
Regulations Title 41 Part 101-37, Government Aviation Administration and
Coordination also revised in draft in August, 2000. The OMB Circular
A-126 requires the Administrator of the GSA to maintain a single
coordinating office for Government-wide agency aircraft management and
the office shall:

-   Coordinate development of effective measures and standards, policy
    recommendations, and guidance for procurement, operation, safety,
    and disposal of civilian agency aircraft. This is the only
    restriction that eliminates the Department of Defense (DOD), all
    other responsibilities include DOD.

-   Operate a Government-wide aircraft Management Information System
    (MIS).

-   Ensure that all agencies conduct a cost analysis in accordance with
    the OMB Circular A-76 streamlined aircraft cost studies for all
    newly acquired aircraft.

-   Identify opportunities to share, transfer, or dispose of
    underutilized aircraft, reduce excessive aircraft operations and
    maintenance costs, and replace obsolete aircraft.

-   Develop generic aircraft information system standards and software.

-   Provide other technical assistance to agencies to establish
    automated aircraft information systems and conduct cost analyses of
    aircraft utilization.

-   Review internal agency policies for compliance with the OMB guidance
    and report discrepancies to the OMB.

-   Conduct an annual study of the variable and fixed costs of operating
    the different categories of Government aircraft.

    The OMB Circular A-126 applies to all Government-owned, leased,
    chartered, and rented aircraft and related services operated by
    Executive Branch agencies except aircraft while in use or in support
    of the President or Vice President. However, the GSA and the OMB
    have mutually agreed that military aircraft resources should not be
    managed the same way as civilian resources due to their unique
    national security nature. The GSA originally developed the Federal
    Aviation Management Information System (FAMIS) to meet its
    responsibilities pursuant to the OMB Circular A-126 including the
    ability to annually collect and report Government-wide non-military
    aviation information to the OMB and the Congress.

    In 1989, the GAO did a follow-up study to determine the extent and
    effectiveness of improvements. The GAO found that, although
    improvements had been made, many of the problems still existed. As a
    result of the follow-up study, the OMB directed the GSA to form a
    Government-wide committee on aviation policy. The resulting
    Interagency Committee on Aviation Policy (ICAP) was established to
    develop guidelines and strategies for managing Government aircraft.
    The ICAP then established a Management Data and Systems Subcommittee
    (MDSS) to emphasize the development of policy and automated tools
    for the purpose of minimizing operational costs and improving
    management and use of Government aviation resources. The ICAP then
    held a strategic planning session to meet the OMB directive.

    The ICAP Strategic Planning Session identified an objective to
    \"\...establish an authoritative interagency MIS to meet the
    requirements of Federal agencies and their aircraft operators\". On
    October 21, 1993, the ICAP established the MIS Task Group for the
    purpose of pursuing this objective. The group proposed an MIS
    mission statement as follows:

    "The Government aviation MIS will provide accurate standardized
    information on civilian Federal aviation. This modular system will
    address aircraft acquisition, utilization, operation, maintenance,
    and disposal and will be responsive in supporting agencies\' and
    ICAP needs."

    The ICAP also determined it was necessary to widen the scope of the
    FAMIS software to become more property management-oriented to enable
    tracking of all Federal civilian aircraft and to make it easier for
    agencies to report meaningful data. The FAMIS did not support agency
    management of aircraft and aircraft services. It was intended to be
    a reporting system that the agencies could use to report required
    data. It also was intended to be a summary-level tool for agencies
    to use if they so desired. However, there was no interactive
    component of FAMIS severely limiting its usefulness. FAMIS collected
    summary data that was not suitable as an agency-level management
    tool.

    Today, as in the past, Federal agencies manage their own air fleets
    from a mission-oriented perspective and have a wide variety of
    information systems to support air fleet mission management. The
    orientation of management processes is effective from a mission
    perspective.

    The ICAP recognized situation and requested a study to determine the
    actual current "state of affairs" in Federal aircraft management IT
    systems. The committee wanted to determine if a Government-wide
    system for aviation IT systems could increase Federal aircraft
    resource management effectiveness and efficiency and, if so, develop
    a concept of an MIS that will meet agency, GSA, and OMB overall
    requirements.

    The study was performed by a study team comprised of the GSA
    Aircraft Management Policy Division (staff symbol MTA) and the
    Varone Consulting Group, Inc. (VCG). The study was conducted in five
    steps as follows:

-   [Step I]{.underline} - Develop a survey and conduct data gathering
    activities to determine current agency MIS capabilities and future
    plans.

-   [Step II]{.underline} - Analyze the gathered data, document
    findings, and develop recommendations for an upgrade/replacement for
    FAMIS.

-   [Step III]{.underline} - Define the Government-wide C-AMIS Standard
    system functions and processes and data dictionary.

-   [S]{.underline}tep IV -- Define a Concept of Operations (CONOPS) for
    the FAMIS-replacement, the Federal Aviation Interactive Reporting
    System (FAIRS).

    The ICAP strategic goal of "\... establishing an authoritative
    interagency MIS" is recognized as a worthwhile endeavor. The
    establishment of the C-AMIS Standard and the subsequent development
    of FAIRS enable agencies to realize substantial cost savings and to
    better measure their effectiveness.

    During the first study, the team found a significant overlap in the
    features and functions of many of the agency-unique systems. Despite
    the fact that they were developed for many of the same reasons, the
    application systems were, for the most part, unique to specific
    agency missions and were rarely able to communicate with, or pass
    information to, other closely related systems. The study team also
    found a wide range of MIS capabilities among systems basically
    designed to accomplish the same tasks. The application systems
    ranged from costly, legacy, multi-user, mainframe systems to
    inexpensive, personal computer based, single user spreadsheets that
    were created to fill a specific need. The study team did not find
    any single existing system suited for Government-wide
    implementation.

    One of the most important findings of the study team was the mission
    use of aircraft clustered around the following six basic groups:

-   Law enforcement and surveillance;

-   Fire fighting and disaster response;

-   Search and rescue;

-   Transportation of passengers and/or cargo;

-   Research and development including scientific experimentation; and

-   Training (each of these groups also have a significant emphasis on
    training.)

    Subsequent to the initial study findings during the FAIRS
    development effort, GSA Revised these groups as follows:

```{=html}
<!-- -->
```
-   Law enforcement.

-   Transportation of passengers.

-   Surveillance.

-   Fire fighting and disaster response.

-   Search and rescue.

-   Transportation of cargo.

-   Training.

-   Resource management.

-   Flight inspection/calibration.

-   Research and development including scientific experimentation.

    Each of the mission groups is different and places different
    emphasis and requirements on the aviation resources as well as the
    MIS that supports aviation management. In addition, the mission
    groups categorize similar missions within these groups for
    accounting purposes. The study group determined that any
    Government-wide MIS initiative must recognize and support the
    expanded mission types. The study team also concluded that the
    information collected and analyzed supported the development of a
    new standard that could meet the ICAP and individual agency and
    GSA/OMB objectives. Such a standard would result in:

```{=html}
<!-- -->
```
-   Additional valuable data that could be used for decision support to
    improve aircraft management mission effectiveness with additional
    cost efficiencies;

-   Improved agency mechanism for sharing information thereby promoting
    cooperation and contributing to the ability to attain additional
    effectiveness and efficiency benefits; and

-   More accurate data being reported to the GSA, thereby improving the
    OMB and the Congress oversight ability by giving them accurate
    decision-support data.

    Another significant finding was that agencies were continuing to
    actively develop their own systems. This fact helped to substantiate
    the study team's findings and conclusions. During Step II of the
    study, the study team discovered that the United States Department
    of Agriculture (USDA), the Federal Aviation Administration (FAA),
    the Department of Energy (DOE), the Drug Enforcement Agency (DEA),
    the United States Coast Guard (USCG) the National Aeronautics and
    Space Administration (NASA), and the Department of Interior are each
    expending varying efforts to develop more robust and/or new systems
    to enhance their ability to manage their aviation resources. Since
    the adoption of the C-AMIS standard, the individual agencies have
    provided their IT and/or contracting staffs with the C-AMIS
    Standard. These staffs have, in turn, begun building their own
    individual systems in accordance with the standard. Specifically,
    NASA, NOAA, Interior, Marshals Service, Energy, FAA, and State all
    have adopted C-AMIS to the degree that makes sense to their
    environment. The FAA's development contractor, Inair, Inc., has had
    their system, which is now commercially available, certified as
    being C-AMIS compliant. This commercial package is now the most
    common package throughout Government.

    One of the most important benefits of C-AMIS was that the acceptance
    of the standard facilitated a new attitude of agency cooperation
    with the GSA that enabled GSA to develop and implement FAIRS. During
    development of FAIRS, the agencies were given additional beneficial
    FAIRS capabilities that enhanced the cooperation resulting in a
    agency user community that wants FAIRS to succeed.

    The C-AMIS CONOPS detailed the reasons for the study, the GSA
    Aviation Management Policy Division and ICAP objectives, and defined
    the high level requirements of the C-AMIS Standard. The ICAP-stated
    C-AMIS standard strategic objectives were expanded based on the
    results of FAIRS development as stated above. The technical
    architecture and C-AMIS study team defined high-level basic
    processes for the following C-AMIS Standard functions remain in
    C-AMIS and FAIRS:

-   Property Management

-   Finance and Accounting

-   Maintenance

-   Logistics

-   Training

-   Contract Support and Acquisition

-   Agency-unique Processes

    These high level processes became the requirements for the C-AMIS
    Standard. Data classification definitions for each of these
    functions also were defined and updated during and after FAIRS
    development. The data classifications became the C-AMIS Standard
    data dictionary.

    The focus of the C-AMIS study team analysis was on specific
    functionality and requirements. A significant finding is that
    agencies have both unique combinations of previously defined mission
    requirements and significant amounts of common data and functions.
    Furthermore, the analysis substantiated the feasibility of common,
    Government-wide core functions and data supported by an
    agency-unique capability. The study team then developed the C-AMIS
    Standard internal system infrastructure required to support an
    operational environment throughout the Government. This
    infrastructure, documented as the Communications Module defines the
    functions and data to support Internet communications, file
    transfers, and bulletin boards to share information internally as
    well as across agencies. During the development of FAIRS, a
    significant number of changes to this module were accomplished to
    ensure agency input compatibility and security integrity.

    The comprehensive set of the C-AMIS Standard Functions and Processes
    and the definition of an equally comprehensive C-AMIS Standard Data
    Dictionary that was originally published in September of 1996. A
    major benefit of the study team approach was the definition of a new
    Government-wide MIS built from a consensus of agency requirements.
    The standard was updated in May of 1998 after the FAIRS requirements
    were defined and in September of 2000 after FAIRS implementation.

    One of the tasks of the study group was the preparation of a charter
    for an ICAP C-AMIS Standard Configuration Management (CM) Task Group
    to continue to:

-   Enhance the C-AMIS Standard specifications;

-   Promote the use of agency developed systems that meet the C-AMIS
    Standard specifications;

-   Catalogue and document agency-unique extensions to the C-AMIS
    Standard; and

-   Continue to save moneys that agencies expend for aviation IT system
    development.

Additionally, part of the ICAP C-AMIS Standard CM Working Group charter,
which is presented in this document, includes establishing certification
guidelines for agency IT systems. The objective of developing a
certification process was to establish a C-AMIS compliance evaluation
and certification mechanism that will serve to ensure interoperability
and identify new C-AMIS Standard functionality to the MDSS for the ICAP
approval. The certification process for agency systems is a five-step
process and can be requested either by a specific agency or by GSA to
ensure compliance with the C-AMIS Standard. The purpose of the
certification process is threefold:

1.  To validate that the data requested by GSA is being captured and
    reported, and is consistent with standard processes.

```{=html}
<!-- -->
```
2.  To obtain recommendations regarding the efficiency and effectiveness
    of agency IT systems in reporting data to GSA.

```{=html}
<!-- -->
```
3.  To show the level of "functional" compliance with the C-AMIS
    Standard.

The certification process is an audit of how information is gathered and
submitted to GSA in order to ensure accuracy and completeness.
Additionally, this process determines if data is compliant with GSA
requirements. Only the agency data that is being provided to GSA is a
candidate for certification. However, since the data provided to GSA is
a summary of the agency data, all agency data will be reviewed to ensure
that the data being certified is complete and accurate. The FAA/Inair
system has been certified and is in various states of implementation at
several agencies at the time of this C-AMIS printing.

**2. STUDY ENVIRONMENT**

The study to develop and update the C-AMIS Standard Functions,
Processes, and Data Dictionary was conducted using standard analytical
techniques. The effort also is a natural progression to the effort to
develop the C-AMIS Standard Concept of Operations. Previous to and
during the development of FAIRS, the study team continued to analyze
information gathered during additional interview and data gathering
steps, conducted additional site visits, and gathered and analyzed
specific agency systems requirements. The resulting updates to the
processes and data definitions were categorized into the C-AMIS Standard
modules and populated into the Microsoft Access data dictionary
database. Specifically, in study Step V, the team:

-   Eliminated the Joint Aircraft Logistics Information System (JALIS)
    specifications and replaced them with Energy's less complex aircraft
    management information system specifications;

-   Incorporated changes resulting from comments received on the C-AMIS
    Standard Version 1.0 and 2.0;

-   Updated and then eliminated Senior Federal Travel specifications to
    comply with GSA decision to move it from aviation oversight to
    travel policy definition;

-   Added a Trip Planning function to allow agencies to pre-plan trips
    and determine the economics of using Government-owned versus
    commercially available flights;

-   Enhanced tracking flight and maintenance crew training and
    certification in the Training Module;

-   Restructured the Acquisition Module data structures for efficiency
    and information technology reasons;

-   Added significant detail information on Flight legs;

-   Added a bulk fuel inventory capability;

-   Enhanced the Property Management module with added detail on
    aircraft ownership and modification history; and

-   Further enhanced the Property Management Module with the ability to
    better track special equipment on aircraft.

    During the initial study, the team had visited the U.S. Customs
    Service, the USDA Forest Service, and the Energy to gain additional
    information. During the CONOPS phase, the team re-visited the USDA
    Forest Service, Energy, and Customs Service to gather additional
    documentation. The team collected user guides for existing and
    planned, under-development IT systems as well as concept
    documentation for the Energy aviation management system. During the
    Process Definition and Data Dictionary phase, the team revisited the
    Department of Energy several times to review the development effort
    on their new Aviation Information System (AIS). The team also
    conducted multiple site visits to Coast Guard installations in
    Beltsville, Maryland, and Elizabeth City, North Carolina, to NASA
    headquarters in Washington DC, as well as to the FAA center in
    Oklahoma City, Oklahoma. The visits were conducted to obtain first
    hand knowledge and system documentation on their respective systems
    development efforts. In addition, the team received updated FAMIS
    documentation from GSA as well as updated JALIS documentation from
    the Navy. Included with the documentation received from NASA, the
    study team collected a document detailing the analysis of over sixty
    commercially available products that were analyzed to meet NASA's
    aviation MIS needs. The C-AMIS Standard development team developed
    the initial FAIRS CONOPS and requirements and significantly
    contributed to the FAIRS development and acceptance efforts.

    The collected data and consensus of requirements were continually
    updated. Data definitions to support the functions and processes
    also were originally defined and updated. The result was then
    re-populated into the C-AMIS Standard Microsoft Access database.

    **3. METHODOLOGY**

    The ICAP, through the GSA, selected a contractor, VCG, to work with
    them to conduct a study of existing agency IT system, develop a
    C-AMIS Standard Concept of Operations, and to define the C-AMIS
    Standard Functions and Processes as well as to define the common
    Government-wide aviation data dictionary. The GSA then contracted
    with VCG to develop the FAIRS CONOPS, initial FAIRS Requirements,
    the FAIRS Request for Proposals (RFP) and related Proposal
    Evaluation PLAN, and maintain the C-AMIS Standard throughout the
    FAIRS development cycle. The team, comprised of VCG and at various
    times GSA representatives, conducted the effort in multiple steps as
    follows:

-   Development of a Government-wide survey and the subsequent data
    gathering effort.

-   Analysis of gathered information, documentation of the findings, and
    the development of recommendations to improve/upgrade FAMIS.

-   Definition and development of the C-AMIS Standard Concept of
    Operations.

-   Definition and development of the C-AMIS Standard Processes and Data
    Dictionary.

-   Evolution of the C-AMIS Standard specifications to make them more
    effective for all agencies, and a CM process to ensure that the
    various agency development efforts continue to meet C-AMIS
    specifications.

-   Development of the FAIRS CONOPS and requirements based on the C-AMIS
    Standard and operational understandings gained in earlier steps and
    update the C-AMIS Standard after FAIRS Requirements definition.

-   Development of the related acquisition documents such as RFP and
    Evaluation plan to select a development contractor for FAIRS.

-   Performed independent verification and validation (IV&V) of the
    FAIRS development contractor during development and prepare the
    Government acceptance FAIRS Beta Test Scenarios and Scripts and
    FAIRS.

    The study team determined that in order to conduct an effective
    study, it would be necessary to gather information from all of the
    agencies with aircraft resources. They determined that the most cost
    effective and quickest method to use to gather information was to
    develop a survey, send it to agencies, and ask them to respond. The
    study team also noted that surveys have inherent constraints due to
    interpretation. To minimize the effects of the constraints, the team
    decided to conduct follow-up site visits and conduct telephone
    interviews to verify the results, obtain a first-hand view of the
    ease of use and usefulness of agency IT systems, determine the
    extent that multiple agency IT systems had to be manipulated to meet
    FAMIS reporting requirements, and to verify the evidence that data
    is not being kept at a level that could support aircraft management
    as a separate cost center. Follow-up interviews and site visits
    were, therefore, conducted to address the constraints of the survey.

    The study team first prepared a Government-wide aviation MIS survey
    questionnaire in support of the ICAP MIS Task Group. The
    questionnaire was sent to twelve agencies and required a response
    for each agency MIS. The study group received twenty-eight detailed
    responses. The agencies represent the majority of non-tactical
    Federal aircraft resources and cover the complete range of mission
    requirements. The agencies that responded are:

-   Department of Agriculture,

-   Department of Commerce,

-   Department of Defense,

-   Department of Energy,

-   Department of the Interior,

-   Department of Justice (DOJ),

-   Department of State,

-   Department of Transportation (DOT),

-   Department of the Treasury,

-   General Services Administration,

-   National Aeronautics and Space Administration, and

-   Tennessee Valley Authority (TVA).

    The survey was designed for use by agencies with systems of varying
    complexities supporting aircraft programs. It attempted to gather
    information along the lines of functional business processes in an
    effort to assess which systems currently deployed or planned would
    be applicable for use during the concept development phase of the
    new ICAP-initiated standard and GSA collection system, FAIRS. After
    analyzing the responses, the study team concluded that a new C-AMIS
    Standard should be developed.

    The team decomposed the ICAP objectives into a set of high-level
    C-AMIS Standard requirements. The last task in the development of
    the C-AMIS Standard Concept Of Operations was the definition of
    high-level functional processes and data classifications that must
    be inherent to the C-AMIS Standard in order to be an effective
    aviation management tool for the agencies. The processes and data
    classification definitions were derived from the expanded ICAP
    objectives, data gathered during the survey and interviews,
    additional follow-up meetings, and analysis of existing
    documentation provided by the agencies. The processes and data
    classification definitions also were updated before and after FAIRS
    development to ensure total compatibility. The resulting CONOPS
    became the basis for the more detailed C-AMIS Standard Data
    Dictionary and Process Definitions.

    The C-AMIS Standard processes and data definitions presented later
    in this document are a direct result of analysis of the following:

-   Information gathered during the C-AMIS Standard survey.

-   Additional data gathered during the initial site visits and
    interviews at a number of agencies in Washington, DC.

-   Data gathering during telephone interviews with additional
    non-visited agencies.

-   The United States (US) Customs Service (USCS) Computerized Aircraft
    Reporting and Material Control System (CARMAC) User's Guide.

-   The U.S. Forest Service's Aircraft Management Information System
    (AMIS) User's Guide.

-   The U.S. Navy-developed JALIS User's Guide and system documentation.

-   The results of the Conklin & deDecker Associates, Inc.,
    Government-wide Life Cycle Cost Study for the Federal Civil Aircraft
    Fleet report created in August, 1995 and updated in 1998.

-   The GSA's FAMIS and DLMS User's Guides, documentation, and reports,
    as well as available ICAP documentation.

-   Site visits at the US Coast Guard (USCG) facility in Beltsville,
    Maryland, and Elizabeth City, North Carolina, as well as analysis of
    system and user level documentation on the Aircraft Configuration
    Management System (ACMS) and the Aircraft Maintenance Management
    Information System (AMMIS).

-   Site visits to the FAA development site at Oklahoma City, Oklahoma
    as well as analysis of provided Aviation Standard Information System
    (ASIS) documentation.

-   Site visits to Energy as well as analysis of AIS documentation.

-   A site visit to NASA headquarters to determine the status of the
    NASA Aviation Management Information System (NAMIS).

-   OMB Circular A-126 and the draft update of A-126 dated August, 2000.

-   FAIRS CONOPS and Requirements Analysis.

-   FAIRS Detailed Requirements Definition.

-   FAIRS System Design Specification.

-   FAIRS Data Dictionary.

-   FAIRS Beta Test Plan.

-   FAIRS Operations and Maintenance Manual.

    The analysis of the documentation resulted in a realization that,
    although differences between agencies occur, the basic mission types
    and process module requirements are virtually the same across
    agencies. This became the justification of using a consensus of
    processes and data definitions for the C-AMIS Standard.
    Specifically, the C-AMIS Standard Processes and Data Dictionary was
    built from:

-   UCCS CARMAC;

-   DOE AIS;

-   USCG ACMS;

-   USDA Forest Service AMIS;

-   NASA NAMIS;

-   GSA FAMIS;

-   Navy JALIS; and

-   GSA FAIRS.

    It should be noted that the FAA ASIS system, although a very close
    match to the C-AMIS Standard functionality was not used to initially
    develop the C-AMIS Standard data and process specifications. This
    fact is further proved that the core of agency aviation IT systems
    were and are similar especially when considering that the Inair
    system is now commercially available and in use at several
    commercial airlines.

    The study also revealed areas of the C-AMIS Standard that required
    further analysis to make the specification stronger and, therefore,
    more beneficial to the agencies. The determinations were made based
    on additional analysis of agency needs as well as feedback received
    from the agencies on the existing C-AMIS Standard. These
    enhancements were made to the C-AMIS Standard and the updated
    specifications are attached to this document and published as the
    C-AMIS Standard Version 2.0. C-AMIS Standard Version 3.0 is a direct
    result of FAIRS development and implementation and ensures total
    compatibility with agency operational systems.

    The charter for the ICAP C-AMIS Standard CM Task Group is to
    continue to:

-   Enhance the C-AMIS Standard specifications;

-   Promote the use of agency developed systems that meet the C-AMIS
    Standard specifications;

-   Catalogue and document agency-unique extensions to the C-AMIS
    Standard;

-   Continue to save moneys that agencies expend for aviation MIS
    development; and

-   Establish certification guidelines for agency IT systems.

    The study team continued to analyze information gathered during
    additional interview and data gathering steps, conducted additional
    site visits, and gathered and analyzed additional specific agency
    systems requirements both before and since FAIRS development. The
    resulting updates to the processes and data definitions were
    categorized into the existing C-AMIS Standard modules and populated
    into the Microsoft Access database. Specifically, the team:

-   Eliminated the Joint Aircraft Logistics Information System (JALIS)
    specifications and replaced them with Energy's less complex aircraft
    management information system specifications;

-   Incorporated changes resulting from comments received on the C-AMIS
    Standard Version 1.0;

-   Eliminated the latest Senior Federal Travel Module specifications;

-   Added a Trip Planning function to allow agencies to pre-plan trips
    and determine the economics of using Government-owned versus
    commercially available flights;

-   Enhanced tracking flight and maintenance crew training and
    certification in the Training Module;

-   Restructured the Acquisition Module data structures for efficiency
    and information technology reasons;

-   Added significant detail information on Flight legs;

-   Added a bulk fuel inventory capability;

-   Enhanced the Property Management module with added detail on
    aircraft ownership and modification history;

-   Further enhanced the Property Management Module with the ability to
    better track special equipment on aircraft; and

-   Updated the standard processes and data definitions based on the
    FAIRSA development effort.

    The study team coordinated with the DOE and FAA systems development
    teams to ensure that they continued to develop their systems in
    accordance with the C-AMIS Standard specifications. New and/or
    enhanced specifications that were best suited for the C-AMIS
    Standard were incorporated. Technical incompatibilities were
    addressed and resolved. The team also coordinated with the GSA FAIRS
    development efforts to ensure Government-wide compatibility.

    **4. ANALYSIS AND FINDINGS**

    This section presents the C-AMIS Standard high level requirements
    and process group descriptions.

    **4.1 C-AMIS Standard High-level Requirements**

    The basic ICAP objective is presented below.

    "The Government aviation MIS will provide accurate, standardized
    information on civilian Federal aviation. This modular system will
    address aircraft acquisition, utilization, operation, maintenance,
    and disposal and will be responsive in supporting agencies\' and
    ICAP needs."

    To meet this objective, a new IT system Standard must promote intra-
    and inter- agency aircraft resource management. Functionality of
    existing systems, including FAIRS, should form the baseline of the
    new system.

    Mission-orientation must not be sacrificed by the new standard. The
    ten basic non-tactical military mission types must be accommodated.
    These mission types are:

```{=html}
<!-- -->
```
-   Law enforcement;

-   Transportation of passengers;

-   Surveillance;

-   Fire fighting and disaster response;

-   Search and rescue;

-   Transportation of cargo;

-   Training;

-   Resource management;

-   Flight inspection/calibration; and

-   Research and development including scientific experimentation.

    The new C-AMIS Standard should be able to provide agencies with
    their own operational support at site locations and facilitate
    roll-ups to bureau/service, Department, and Government-wide levels
    as defined by the OMB, the Congress, and the GSA. The new common MIS
    Standard should be the logical maturation of the initiative begun
    with FAMIS. The C-AMIS Standard also should take advantage of the
    planned enhancements to existing agency IT systems if technically
    feasible.

    The broad ICAP objective has been decomposed into information
    technology system specific objectives for the C-AMIS Standard as
    follows:

```{=html}
<!-- -->
```
-   The C-AMIS Standard should support the ability to manage aircraft
    resources as a separate cost center. The process groups that must be
    present are:

-   Property management;

-   Finance and accounting;

-   Maintenance;

-   Logistics;

-   Training;

-   Contract support and acquisition;

-   Communications and administration; and

-   Agency-unique information functional and reporting requirements.

-   The system standard should be flexible enough to support any
    combination of unique aircraft operation missions while continuing
    to support the overall agency mission.

-   The C-AMIS Standard should be able to define information at a
    significant level of detail to support the aircraft management
    function, and summarize that information for agency-unique and
    Government-wide reporting. The summarization or roll-up process
    should include reporting at the regional, bureau/service,
    Department, and OMB/Congress/GSA Government-wide levels.

-   C-AMIS Standard compliant systems should be able to have true cost
    comparisons to commercially available services when and where
    applicable. The data used must be at a detailed enough level to
    ensure like comparisons. These systems also should have the ability
    to account for the fact that some agencies have missions that are
    unique to Government and have no commercial counterpart. In those
    cases, costs should be able to be compared to other agencies, state,
    and/or local government units with similar missions.

-   The C-AMIS Standard must be able to differentiate between actual
    aircraft operational costs and the sometimes very expensive special
    equipment that may have to be installed on an aircraft to meet
    mission requirements. These costs should not be included in the cost
    comparisons to commercial aircraft operations.

-   Any system that is developed in accordance with the C-AMIS Standard
    should promote potential shared resource facilities and services
    where appropriate. Examples of these potentially shared facilities
    and services could include fleet consolidation to increase
    effectiveness or shared acquisitions resulting in greater economies
    of scale and lower operating costs. These systems also should
    promote agency coordination by enabling benefits that would not be
    available without sharing.

-   C-AMIS Standard compliant systems should be cognizant of the fact
    the Federal Government Aircraft Fleet has ten diverse basic
    non-tactical missions as stated above. Any C-AMIS-compliant system
    must support any combination of these distinct missions within a
    given agency.

-   The C-AMIS Standard should support the basic mission types of an
    agency, and facilitate inter-agency cooperation to achieve optimum
    effectiveness and efficiency.

-   C-AMIS Standard compliant systems should be built with a common data
    architecture, and standard definitions and attributes to be useful
    across agency boundaries as well as to allow true comparisons and
    accurate reporting of information to FAIRS.

-   The C-AMIS Standard should be a tool that agencies can use to
    develop their own systems to manage their own aircraft resources. It
    should not be solely for oversight. In fact, oversight should be
    secondary and transparent to agency use.

-   As a tool for Federal aircraft resource management, the C-AMIS
    Standard should define and promote a standard management methodology
    that is applicable to aircraft management.

-   C-AMIS Standard compliant systems should be modular. Modularity will
    facilitate step-by-step implementation, thereby allowing agencies to
    receive the benefits quicker and in a logical sequence that will
    minimize operational disruptions. Modularity also allows agencies to
    selectively implement the portions of systems that the C-AMIS
    Standard defines that are applicable to their mission. This approach
    also gives the agencies more control and contributes to the
    acceptance of the C-AMIS Standard.

-   C-AMIS Standard compliant systems should capture data electronically
    at aircraft locations with less work than with the current
    paper-based data input. These systems must be easier to use and
    eliminate manual effort and work. In addition, the data entry
    process must be accomplished with intelligence using data already
    inputted rather than requiring aircraft operations personnel to
    re-enter the same data multiple times. Data entry into C-AMIS
    compliant systems should automatically generate batch input to FAIRS
    eliminating error prone re-entry.

-   The reports of C-AMIS compliant systems should support the
    management needs of individual site locations as well as roll-up to
    summary levels. This means that the C-AMIS complaint systems must be
    able to provide aircraft operational personnel with information that
    they require to manage their resources while still meeting oversight
    requirements.

-   C-AMIS compliant systems should support query into the site database
    and into bureau/service, department, and, in some cases,
    Government-wide level databases. Any individual site should be able
    to leverage activities and capabilities across agencies if and when
    it makes sense. This is especially needed in the training and
    contract and acquisition support modules and, by itself, should save
    the Government substantial sums of money. The leveraging capability,
    for example, would allow an agency to include its' requirements with
    another agency's similar requirements, resulting in a purchase of
    larger, more economical quantities. The decision to leverage another
    agency's work should be accomplished at each site location based on
    individual situations. The system also should "remember" that an
    opportunity to leverage another agency's efforts was declined. By
    providing a leveraging capability without forcing interagency
    interaction, decisions can be made when agency mission is not
    jeopardized and economies can be realized.

-   One of the more important C-AMIS Standard objectives is to support
    the use of available aircraft resource management software where
    possible, thereby, encouraging economical implementation. If the
    cost of implementation is too great, the resulting benefits will be
    jeopardized. In addition, agencies may not even be able to consider
    the tool. To be effective, C-AMIS compliant systems must be
    developed with the budget situation in mind.

-   From a technical point of view, C-AMIS compliant systems should be
    developed with the latest technology and should avoid outdated,
    obsolete technology. The selected technology, however, must be
    robust enough to handle all C-AMIS Standard processing functions or
    modules. In addition, the system should, if possible, meet all
    Federal standards for open and secure systems. This objective should
    ensure agency ability to implement without costly new hardware
    investment.

-   C-AMIS compliant systems should specifically address the need for
    security and unauthorized access to protect and eliminate the
    identification and location of law enforcement aviation assets.

-   C-AMIS compliant systems must, by definition, be totally compatible
    with FAIRS.

    The C-AMIS Standard process and data definitions were developed and
    updated to meet these objectives. In addition the evolution of the
    specifications through enhancements and additional functionality
    also meet ICAP objectives. Meeting these objectives should ensure
    the C-AMIS Standard acceptance and success and enable the
    realization of the cost savings predicted by other studies.

    **4.2 C-AMIS Standard Development Issues**

    The C-AMIS Standard Concept Of Operations defined issues that were
    common to all architectures and stated how the selected C-AMIS
    Standard architecture addressed those issues. During the development
    of the C-AMIS Standard processes and data definitions contained
    herein, the study team further addressed the issues. Exhibit 4-1
    present the issues that could impede the successful implementation
    of the C-AMIS Standard as defined in the C-AMIS Standard Concept Of
    Operations.

+-----------------------------------------------------------------------+
| **ISSUES**                                                            |
+-----------------------------------------------------------------------+
| -   Mission objectives and jurisdictions overlap agencies and         |
|     departments.                                                      |
|                                                                       |
| -   Agencies within a department can have different missions and any  |
|     particular agency may have several missions.                      |
|                                                                       |
| -   Agencies may have their aircraft resources located centrally,     |
|     regionally, and/or at specific locations that may or may not      |
|     support local operations.                                         |
|                                                                       |
| -   Departments can have extensions of the Federal Acquisition        |
|     Regulations (FARs), resulting in organizational-uniqueness or     |
|     differences in their acquisition methodologies.                   |
|                                                                       |
| -   Control of aircraft resources can be at a departmental, agency,   |
|     or lower level.                                                   |
|                                                                       |
| -   The need to transport people may be common to most agencies, but  |
|     the amount and nature of their transportation needs will vary     |
|     greatly from agency to agency.                                    |
|                                                                       |
| -   The size of the aircraft fleet of agencies also will vary.        |
|                                                                       |
| -   Mission-oriented information systems to support the aircraft      |
|     resource have resulted in different information system and cost   |
|     accounting needs.                                                 |
|                                                                       |
| -   Agencies' missions may require domestic and/or international      |
|     flight operations.                                                |
|                                                                       |
| -   Aircraft pilots and/or maintenance personnel may have another     |
|     overriding responsibility such as law enforcement officer and     |
|     member of the armed forces resulting in different cost            |
|     constraints from those that dedicate personnel to air operations. |
|                                                                       |
| -   Determination of common data definitions and source of the data   |
|     requirements and attributes definitions                           |
|                                                                       |
| -   Implementation of aggregating requirements of all agencies into   |
|     one MIS system or, development of multiple systems                |
|                                                                       |
| -   There may be no commercial system support alternative for some    |
|     Government missions.                                              |
|                                                                       |
| ```{=html}                                                            |
| <!-- -->                                                              |
| ```                                                                   |
| -   The financing authority or who should/will be funding the         |
|     development of the system will have to be determined.             |
+-----------------------------------------------------------------------+

**Exhibit 4-1 \-- Aviation Issues That Could Impede Success IT Success**

In the study, the team continued to analyze each of the issues, outlined
in Exhibit 4-1, as follows:

-   Nothing can be done about overlapping jurisdictions and mission
    objectives within the constraints of this study. However, by
    incorporating agency-developed applications into the C-AMIS
    Standard, agencies should be able to continue to operate as they are
    today. In addition, as the ICAP objective to foster interagency
    cooperation continues to be achieved, issues caused by overlapping
    missions as they relate to the C-AMIS Standard continue to be worked
    out. The C-AMIS Standard, by defining a common set of requirements
    used by most, if not all, agencies, will facilitate the ability to
    deal with operational issues resulting from overlapping missions
    more effectively. The information base used to make decisions will
    be common across agency bounds thereby promoting an ability to
    cooperate for mutual benefit.

-   The ability to support multiple mission types within an organization
    continues to be included in the C-AMIS Standard.

-   Location of aviation resources will not affect any processes of the
    C-AMIS Standard, as The Communications and Administration Module may
    be utilized depending on location.

-   The Agency-unique Module is defined to allow each agency to
    manipulate data to meet any unique requirements. In addition, this
    module has been designed to allow agencies the ability to logically
    append data to the existing database thereby adding another level of
    independence to the C-AMIS Standard.

-   With the design of the C-AMIS Standard specifications, control of
    aviation resources can be at any level of an agency's organization,
    thereby, capturing data at the source, such as from a pilot in an
    aircraft.

-   Even though comparisons to commercial services may not be applicable
    for all Government aircraft uses, comparisons to other similar
    agencies, to other Governmental levels, and/or to a history is
    definitely applicable. The C-AMIS Standard supports this ability.

-   The study team determined that the most economical development
    strategy from an ICAP and GSA perspective was to encourage Energy,
    the FAA, and other agencies to continue with their development
    efforts and to work with the development teams to ensure that they
    remain compatible to and in accordance with the C-AMIS Standard
    specifications. This decision was partly driven by the fact that
    neither ICAP nor GSA have funds for the development of a new system
    and partly by the facts that the Energy and FAA development teams
    have been using the C-AMIS Standard specifications, are cooperating
    with the study team, and that other agencies such as the U.S.
    Marshals Service and the Department of Interior have accepted the
    systems and are currently implementing the Energy or FAA system in
    their environments.

-   The technical differences between the Energy and the FAA systems add
    to rather than detract from the benefits of the C-AMIS Standard.
    Because of these differences, agencies have a wide range of
    technical requirements that can be employed to implement the
    systems. This means that the agencies can utilize the system that
    best meets their own needs without major investment in technology.

    **4.3 C-AMIS Standard Module Descriptions**

    The paragraphs below describe the C-AMIS Standard modules for each
    of the eight processing modules. The definitions are still at a high
    level and may require further decomposition to implement. The
    modules and processes detailed later in this document represent a
    consensus of requirements as reported to, documented, and/or
    provided to the study team by the agencies. As stated above, some
    interaction between the study team and every agency that has/uses
    aircraft was accomplished. The represented processes are not the
    study team's views. They are the requirements of the agencies.

    **4.3.1 Property Management Module**

    The Property Management Module of the C-AMIS Standard compliant
    system supports the management of aircraft inventory and the
    facilities required to maintain and house the aircraft. The module
    captures agency contact information, ownership category, operational
    category, and inventory data for each aircraft added to or deleted
    from the inventory, as well as records such additional data as
    aircraft valuation, primary and secondary mission, utilization
    (flight hours), capital improvements, status, and interagency
    availability. The module also captures point of contact information
    for each facility and the services which it offers (maintenance,
    refueling, storage, training, research and development, and other).
    Reference information useful in property management, such as
    comparable life cycle, operational, contract, and retail aircraft
    cost data will be captured, and the average market price of
    Government aircraft by type and model will be accessed and retrieved
    from a COTS database. In addition, the module will capture
    commercially available and use facility information such as services
    available, fees, points of contact, and comparable operational
    costs. A model for predicting life cycle costs for Government
    aircraft will be defined and implemented. Module information in the
    C-AMIS Standard compliant system database will be reported and/or
    displayed to assist the property manager.

    **4.3.2 Finance and Accounting Module**

    The Finance and Accounting Module of C-AMIS Standard compliant
    systems capture aircraft utilization, and variable and fixed cost
    information, including costs for crews and leases, landing and tie
    down, maintenance, hull and liability self-insurance, operation and
    administration overhead, capital, and depreciation costs. The module
    provides a data entry capability using the standard accounts
    proposed in the GSA Cost Accounting Guide (CAG), but also allows the
    CAG accounts to be cross-referenced to user-entered agency accounts.
    The module facilitates the management of aircraft on a fleet basis
    as well as by individual tail number. However, the module is not a
    true finance module. The module is designed to allow all input to an
    approved agency finance module thereby eliminating a separate set of
    accounting record for aviation resources. It allows and fosters
    aviation resources as a separate cost center. The module calculates
    the annual summary costs, fixed cost per hour, and variable cost per
    hour for each aircraft and aircraft type, and generates the annual
    report on aircraft costs for Government operated aircraft. It also
    provides the capability to monitor and report on Senior
    Federal/Special Category Travel. The module also will produce a
    Balance Sheet and Income Statement, and compute actual vs. projected
    expenditures for each aircraft operation. In addition, the module
    will project life cycle costs by aircraft type, summarize aviation
    operations by OMB object class code, and track warranty expirations
    and renewals. Module information in the C-AMIS Standard compliant
    system databases will be reported and/or displayed to assist finance
    and accounting managers.

**4.3.3 Maintenance Module**

The Maintenance Module of the C-AMIS Standard compliant systems contain
a configuration control and management function and is based on the
concept of a configuration list that defines and documents the \"as
designed\" assembly and component hierarchy for each aircraft type. Each
assembly may have one or more individual components that are tracked
against it by serial number. The module records and reports the removal
or installation of any major assembly, sub-assembly, or component
identified on the configuration list from its parent assembly and tracks
the operation time and location of all attached lower level items.
Maintenance due lists and configuration status reports are available on
demand for any aircraft or major assembly. Significant component history
records are maintained and automatically updated on all items contained
in the configuration lists. The module also configures tasks, associated
tasks, depot tasks, equipment tasks, and tracks their execution.

The module generates component replacement and engine overhaul
schedules, and tracks the ordering lead-time for components. The module
identifies alternative or substitute components, verifies inventories
(ordered, on-site, back-ordered), tracks credits for returned items, and
schedules maintenance and inspections. The module also tracks equipment
replacements, incomplete maintenance and repair activities, and the
manufacturer and serial number of parts. It provides information on
stock location, item condition, inventory type, average unit price, and
replacement cost. A complete part number history by manufacturer is
recorded by the module, which also provides serial number tracking by
part number. The module identifies frequently ordered components,
forecasts overhauls and upgrades based on age, cross-references actions
with ATA chapter number, and generates aircraft maintenance history
reports. It monitors time compliance for life-limited components, and
the dissemination of air-worthiness directives and service bulletin
information. Module information in the C-AMIS Standard compliant system
database will be reported and/or displayed to assist the maintenance
manager.

**4.3.4 Logistics Module**

The Logistics Module of the C-AMIS Standard compliant system captures
the registration number and other identification and contact information
for each Government aircraft. The module also captures aircraft flight,
passenger, passenger mission, and Government/commercial cost information
such as flight rate per hour, standby rate per hour, and overnight
charge. In addition, the module captures agency flight schedules, cost
justifications, flight crew data, and airlift request information. The
module periodically updates the status of logistics information, and
produces agency flight schedules, cost justifications, and flight crew
information. The module matches the capacity of aircraft to airlift
requests, computes cost savings, and summarizes flights by passenger and
organization. It tallies aircraft utilization information by aircraft,
aircraft type, and organization, tracks unsatisfied airlift requests,
calculates mission costs by aircraft, and reports the number of flights
by mission. In addition, it provides centralized on-demand air logistics
requesting, planning, scheduling, and messaging services, and supports
ad hoc reporting capabilities and the consolidation of historical
airlift data. Module information in the C-AMIS Standard compliant
database will be reported and/or displayed to assist the logistics
manager.

**4.3.5 Training Module**

The Training Module of the C-AMIS Standard compliant system captures
employee identification, labor category, and hourly rate information.
The module also captures school and certification information, flight
hour information for the pilot in command and second in command, and
employee qualification information. Information is periodically updated
with training information and reports on the currency of takeoffs and
landings, IFR approaches, and inoculations. In addition, the module
tracks check ride requirements, physical due dates, and monthly and
annual flight times by crew. Module information in the C-AMIS Standard
compliant database will be reported and/or displayed to assist the
training manager.

**4.3.6 Contract Support and Acquisition Module**

The Contract Support and Acquisition Module of the C-AMIS Standard
compliant system will capture agreement identification information,
including mission, aircraft make and model, and cost information for the
aircraft and pilot. The module also captures service descriptions and
costs, vendor information, and agreement contact information. The module
periodically updates the current status of contract support and
acquisition information, and summarizes contract information by
agreement type and region. The Contract Support and Acquisition Module
is designed to support acquisition personnel with their purchasing and
contracting efforts. Module information in the C-AMIS Standard compliant
database will be reported and/or displayed to assist the contract
support and acquisition manager.

**4.3.7 Agency-unique Requirements Module**

The Agency-unique Requirements Module of the C-AMIS Standard supports
processes that are uniquely needed by one or more (but not all) of the
participating agencies. An example is the capability to capture and
report mishap (accident/incident) information, which may or may not be
required by a specific agency. Agency-unique information in the C-AMIS
Standard database will be reported and/or displayed to assist managers
with unique agency requirements.

**4.3.8 Communications and Administration Module**

The Communications and Administration Module of the C-AMIS Standard
compliant system provides a means of data transport, collection,
dissemination, security, user account administration, and user interface
to the system. The module also provides system usage accounting on an
agency/department level. Login data is captured to track unauthorized
login attempts for security purposes. System security reports can be
generated and forwarded to the appropriate authorities.

**5.0 RECOMMENDATIONS**

The study team continues to recommend that the C-AMIS Standard be
maintained and updated as the Government aviation business processes
evolve. The study team also continues to recommend that operational
system be developed by the agencies and that the ICAP function as
Configuration Manager of the C-AMIS Standard. The recommendation to
continue the effort to maintain the C-AMIS Standard is even more
conclusive when analyzing agency development efforts and agency
acceptance since the original C-AMIS publication. The C-AMIS Standard
development strategy is designed to maximize agency "buy-in" through an
specification that utilizes a consensus of requirements, fosters mutual
benefit, protects the sanctity of agency mission, is developed by
multiple agencies, each with a different technical architecture allowing
choice, and minimizes cost and effort. In addition, the study team
continues to recommend an iterative approach that continues to build on
existing systems. Agencies who have their own development efforts should
be monitored and encouraged to use the C-AMIS Standard specifications in
their efforts or, if feasible, the C-AMIS-certified systems to meet
their needs.

The advantages of continuing to develop the C-AMIS Standard based on the
strategies are:

-   Agency-unique mission requirements will continue to be supported by
    the C-AMIS Standard;

-   Agencies would reap the benefits of the IT systems as they are
    developed;

-   Impact to the way agencies collect data in the field would be
    minimized, and overall organizational impact would be less
    traumatic;

-   Data reported to FAIRS will continue to be more and more accurate
    and timely; and

-   Agencies would have a larger sense of "owning" the resulting C-AMIS
    Standard, thereby further increasing acceptance and effectiveness.

    Continued development and implementation of the C-AMIS Standard
    would result in:

-   Additional valuable data that could be used for decision support
    that improves aircraft management mission effectiveness with cost
    efficiencies;

-   Improved agency mechanism for sharing information thereby promoting
    cooperation and contributing to additional effectiveness and
    efficiency improvements;

-   New and improved automated tools for entering, processing,
    comparing, and sharing relevant aircraft resource management data;
    and

-   Cost savings and cost sharing arrangements when those arrangements
    make sense and continue to support agency mission requirements.

New ICAP-approved features to be included in future versions of the
C-AMIS Standard could come from evaluation of new COTS products,
regulatory changes, and/or new policies that promote Government
Performance and Results Act outcomes and/or measurements.

**APPENDICES**

**A. ACRONYM LIST**

  -------------- --------------------------------------------------------
  AER            Airflight Exception Report

  AFC            Automatic Facility Carrier

  AMIS           Aircraft Management Information System

  APU            Auxiliary Power Unit

  ATA            Air Transport Association

  C-AMIS         Common Aviation Management Information System

  CARMAC         Computerized Aircraft Reporting and Material Control

  CONUS          Continental United States

  COS            Concept Of Operations

  COTS           Commercial Off-the-Shelf (Software)

  DIFM           Due In From Maintenance

  DLMS           Demand Logistics Management System

  DOD            Department of Defense

  DOE            Department of Energy

  DOJ            Department of Justice

  DOT            Department of Transportation

  DST            Daylight Savings Time

  DTG            Date/Time Group

  FAA            Federal Aviation Administration

  FAMIS          Federal Aviation Management Information System

  FAR            Federal Acquisition regulations

  FBA            Aviation Management Branch

  FMC            Full Mission Capable

  FTS            Federal Telecommunications System

  GAO            General Accounting Office

  GMT            Greenwich Mean Time

  GOTS           Government Off-The-Shelf (Software)

  GSA            General Services Administration

  GUI            Graphical User Interface

  ICAO           International Civilian Aviation Organization

  ICAP           Interagency Committee on Aviation Policy

  IFR            Instrument Flight Rules

  JALIS          Joint Aviation Logistics Information System

  LFR            Logistics Flight Record

  MIS            Management Information System

  NALIS          Navy Aviation Logistics Information System

  NASA           National Aeronautics and Space Administration

  NIIN           National Item Identification Number

  NIST           National Institute for Standards in Technology

  OMB            Office of Management and Budget

  PAX            Passenger

  PLAD           Plain Language Address

  PMC            Partial Mission Capable

  POC            Point of Contact

  PPR            Prior Permission Request

  PUJC           Priority Urgency Justification Code

  R&D            Research & Development

  SSN            Social Security Number

  TCN            Terminal Change Notice

  TVA            Tennessee Valley Authority

  UIC            Unit Identification Code

  USDA           United States Department of Agriculture

  VIP            Very Important Person

                 

                 

                 

                 

                 

                 

                 

                 
  -------------- --------------------------------------------------------

**B.** **C-AMIS** **STANDARD PROCESSES**

IDENTIFIER 500

PROCESS Manage Government-wide aviation information.

DEFINITION Provide functional support for aircraft property management,
finance and

accounting, maintenance, logistics, training, contract support and
acquisition,

agency unique requirements, and communications on a Government-wide
basis.

IDENTIFIER 1000

PROCESS Manage aviation property (PM) information.

DEFINITION Provide functional support for the management of aviation
property information on

a Government-wide basis.

IDENTIFIER 1100

PROCESS Manage aircraft inventory information.

DEFINITION Capture and maintain relevant information about the
Government\'s inventory of

aircraft and aircraft facilities.

IDENTIFIER 1110

PROCESS Enter, modify, query, delete aircraft identification
information.

DEFINITION Maintain valid information for the aircraft\'s make and
model, year manufactured,

acquisition date and method, acquisition source, serial no., FAA
registration no.,

location city and state, and ownership category: bailed, leased,
lease/purchase, or

owned.

IDENTIFIER 1120

PROCESS Enter, modify, query, delete aircraft ownership categories.

DEFINITION Maintain valid information for the aircraft\'s ownership
category: awaiting disposal,

loaned Federal, loaned non-Federal, loaned permanently Federal, loaned

permanently non-Federal, in-use, parts, storage, maintenance, or
display.

IDENTIFIER 1130

PROCESS Enter, modify, query, delete aircraft operational categories.

DEFINITION Maintain valid information for the aircraft\'s current
operational category.

IDENTIFIER 1140

PROCESS Enter, modify, query, delete aircraft primary and secondary
missions.

DEFINITION Maintain valid information about the aircraft\'s primary and
secondary missions.

IDENTIFIER 1150

PROCESS Enter, modify, query, delete aircraft capabilities information.

DEFINITION Maintain valid information about the aircraft\'s crew seats,
passenger seats

(manufactured),

passenger seats (used), payload (in pounds), cargo space, and special
equipment.

IDENTIFIER 1160

PROCESS Enter, modify, query, delete interagency availability
information.

DEFINITION Maintain valid information about the availability of the
aircraft or facility to other

Government agencies.

IDENTIFIER 1170

PROCESS Enter, modify, query, delete aircraft status information.

DEFINITION Maintain valid information for the aircraft\'s status
(active, transferred, or deleted),

and if transferred or deleted, the method (transfer, exchange sale,
accident, etc.)

and recipient.

IDENTIFIER 1180

PROCESS Enter, modify, query, delete aircraft utilization information.

DEFINITION Maintain valid information for the aircraft\'s utilization
(flight hours for the current

period and the life of the aircraft).

IDENTIFIER 1190

PROCESS Enter, modify, query, delete aircraft modification history
information.

DEFINITION Maintain a history of the aircraft\'s special equipment
modifications.

IDENTIFIER 1200

PROCESS Manage aircraft valuation information.

DEFINITION Capture and maintain valid information about the acquisition
and current market

value of Government-owned aircraft and facilities.

IDENTIFIER 1210

PROCESS Enter, modify, query, delete aircraft acquisition and useful
life information.

DEFINITION Maintain valid information about the aircraft\'s acquisition
cost, residual value,

useful life, and replacement cost.

IDENTIFIER 1220

PROCESS Enter, modify, query, delete aircraft capital improvements
information.

DEFINITION Maintain valid information about aircraft and facility
capital improvements:

description, acquisition date, acquisition cost, residual value, and
useful life.

IDENTIFIER 1230

PROCESS Calculate depreciation for aircraft and aircraft capital
improvements.

DEFINITION Using valid current information calculate depreciation and
relative market value for

aircraft and facilities, including capital improvements.

IDENTIFIER 1240

PROCESS Enter, modify, query, delete aircraft cost and market value
information

DEFINITION Capture aircraft cost and market value information for use in
predicting life cycle

costs for Government-owned and/or Government-operated aircraft.

IDENTIFIER 1250

PROCESS Query comparable commercial aircraft information from COTS
databases.

DEFINITION Obtain comparable life cycle cost data on commercial aircraft
by querying

Commercial Off the Shelf (COTS) databases.

IDENTIFIER 1260

PROCESS Calculate average age and value of aircraft by organization.

DEFINITION Use previously entered information to calculate the average
age and value of

aircraft by department/agency and bureau/office/service.

IDENTIFIER 1270

PROCESS Calculate aircraft operating costs by mission.

DEFINITION Using previously entered information calculate aircraft
operating costs by mission

for each department/agency and bureau/office/service.

IDENTIFIER 1280

PROCESS Analyze alternative strategies for accomplishing required
aircraft missions.

DEFINITION Using previously entered information calculate and compare
the cost of alternatives

such as the use of contractor vs. Government-owned aircraft, or
combining missions

to increase aircraft utilization.

IDENTIFIER 1290

PROCESS Estimate the value of each Government aircraft and the total
value for the fleet.

DEFINITION Retrieve the retail value of commercial aircraft from a
Commercial Off the Shelf

OTS) database by make, model, and year in order to estimate the value of

Government-owned aircraft individually and as a fleet.

IDENTIFIER 1300

PROCESS Manage aircraft point of contact information.

DEFINITION Capture and maintain valid information about
department/agency and

bureau/office/service points of contact for aircraft and aircraft
facilities.

IDENTIFIER 1310

PROCESS Enter, modify, query, delete aircraft Government contact
information.

DEFINITION Maintain valid information about aircraft points of contact
(POCs), including name,

title, job function, address, city, state, zip, country, phone no., fax
no.; and, if other

than the official address, the courier address, city, state, zip, and
country.

IDENTIFIER 1320

PROCESS Enter, modify, query, delete facility points of contact
information.

DEFINITION Maintain valid information about facility points of contact,
including name, title, job

function, address, city, state, zip, country, and phone no.; and, if
other than the official

address, the courier address, city, state, zip, and country.

IDENTIFIER 1400

PROCESS Manage aircraft facility information.

DEFINITION Capture and maintain valid information about available
aircraft facility services.

IDENTIFIER 1410

PROCESS Enter, modify, query, delete identification information on
facilities offering services.

DEFINITION Maintain valid identification information on facilities
offering services, including name, ICAO

code, city, state, zip, and country.

IDENTIFIER 1420

PROCESS Enter, modify, query, delete information on facility maintenance
services.

DEFINITION Maintain valid information on facilities offering maintenance
services, including service

descriptions and the contact name and phone no., if different from the
principal facility

contact information.

IDENTIFIER 1440

PROCESS Enter, modify, query, delete facility training services
information.

DEFINITION Maintain valid information on facilities offering training
services, including service

descriptions and the contact name and phone no., if different from the
principal facility

contact information.

IDENTIFIER 1450

PROCESS Enter, modify, query, delete facility research and development
services information.

DEFINITION Maintain valid information on facilities offering research
and development services, including

service descriptions and the contact name and phone no., if different
from the principal

facility contact information.

IDENTIFIER 1460

PROCESS Enter, modify, query, delete facility services interagency
availability information.

DEFINITION Maintain valid information on facilities making their
services available to other agencies,

including service descriptions and the contact name and phone no., if
different from the

principal facility contact information.

IDENTIFIER 1470

PROCESS Enter, modify, query, delete information on available commercial
facilities.

DEFINITION Maintain valid information on commercial facilities offering
services, including service

descriptions and the contact name and phone no.

IDENTIFIER 1500

PROCESS Manage aircraft transfer and deletion information.

DEFINITION Capture and maintain valid information on aircraft transfers
and deletions.

IDENTIFIER 1510

PROCESS Enter, modify, query, delete aircraft transfer information.

DEFINITION Maintain valid information on aircraft transfers including
both the transferring and

receiving agency/department and bureau/office/service, and the period of
ownership for

which each Government organization is responsible.

IDENTIFIER 1520

PROCESS Enter, modify, query, delete aircraft deletion information.

DEFINITION Maintain valid information on aircraft deletions including
both the deleting

agency/department and bureau/office/service, and the recipient.

IDENTIFIER 1600

PROCESS Manage information on commercially available aircraft.

DEFINITION Capture and maintain valid information on aircraft that are
commercially available

alternatives to Government-owned and operated aircraft.

IDENTIFIER 1610

PROCESS Enter, modify, query, delete aircraft charter/rental/contract
information.

DEFINITION Maintain valid information about aircraft charters, rentals,
and contracts, including aircraft

make and model, FAA registration no., passenger seats, special
equipment, daily rate, rate

per hour, overnight charge, and charges for pilot and/or crew.

IDENTIFIER 1620

PROCESS Enter, modify, query, delete support services agreement
information.

DEFINITION Maintain valid information about each support services
agreement, including vendor

identification and contact information, service description, agreement
type, begin date, end

date, and service cost description.

IDENTIFIER 1800

PROCESS Report aircraft property management information.

DEFINITION Generate standard and ad hoc reports to display and summarize
aircraft property

management information previously entered into the system.

IDENTIFIER 1810

PROCESS Generate aircraft inventory reports.

DEFINITION Generate reports which display aircraft inventory information
previously entered into the

system.

IDENTIFIER 1815

PROCESS Generate special equipment history reports.

DEFINITION Generate reports which display for individual aircraft the
special equipment history

information previously entered into the system.

IDENTIFIER 1820

PROCESS Generate aircraft cost and valuation reports.

DEFINITION Generate reports which display aircraft cost and valuation
information previously entered

into the system.

IDENTIFIER 1830

PROCESS Generate aircraft point of contact reports.

DEFINITION Generate reports and other output products which display the
aircraft point of contact

information previously entered into the system. For example, a telephone
book for points

of contact would be such a product.

IDENTIFIER 1840

PROCESS Generate aircraft modification history reports.

DEFINITION Generate reports which display aircraft modification history
information previously entered

into the system.

IDENTIFIER 1850

PROCESS Generate aircraft transfer and deletion reports.

DEFINITION Generate reports which display aircraft transfer and deletion
information previously entered

into the system.

IDENTIFIER 1860

PROCESS Generate aircraft facility reports.

DEFINITION Generate reports which display aircraft facility information
previously entered into the

system.

IDENTIFIER 1870

PROCESS Generate support services agreement reports.

DEFINITION Generate reports which display support services agreement
information previously entered

into the system.

IDENTIFIER 1880

PROCESS Generate reports on available contract/rental/charter aircraft.

DEFINITION Generate reports which display information previously entered
into the system on available

contract, rental, and charter aircraft.

IDENTIFIER 1890

PROCESS Generate reports on reference data.

DEFINITION Generate reports which display reference information
previously entered into the system.

IDENTIFIER 1900

PROCESS Manage aircraft property management reference information.

DEFINITION Maintain valid reference information for aircraft property
management, including tables of

codes and descriptions for on-line validation, and pop-up lists of
values.

IDENTIFIER 1910

PROCESS Enter, modify, query, delete agency/department codes.

DEFINITION Maintain a valid table of agency/department codes and
descriptions.

IDENTIFIER 1920

PROCESS Enter, modify, query, delete service/office/bureau codes.

DEFINITION Maintain a valid table of service/office/bureau codes and
descriptions..

IDENTIFIER 1930

PROCESS Enter, modify, query, delete codes for aircraft make and model.

DEFINITION Maintain a valid table of codes and descriptions for
manufacturer-designated aircraft makes

and models.

IDENTIFIER 1940

PROCESS Enter, modify, query, delete aircraft mission codes.

DEFINITION Maintain a valid table of aircraft mission codes and
descriptions.

IDENTIFIER 1950

PROCESS Enter, modify, query, delete aircraft operational category
codes.

DEFINITION Maintain a table of valid aircraft operational category codes
and descriptions.

IDENTIFIER 1960

PROCESS Enter, modify, query, delete state codes.

DEFINITION Maintain a valid table of state codes and names.

IDENTIFIER 1970

PROCESS Enter, modify, query, delete location and ICAO codes.

DEFINITION Maintain a table of valid location codes with the city,
state, and ICAO code for the location.

IDENTIFIER 2000

PROCESS Manage aviation finance and accounting (F&A) information.

DEFINITION Provide functional support for the management of aviation
finance and accounting

information on a Government-wide basis.

IDENTIFIER 2200

PROCESS Manage information about Government owned and operated aircraft.

DEFINITION Maintain valid maintenance information to support the
management of Government aircraft

activities.

IDENTIFIER 2210

PROCESS Enter, modify, query, delete Government cost identification
information.

DEFINITION Maintain valid information about the identification of costs
for Government owned and

operated aircraft, including department/agency and
bureau/office/service, FAA registration

no., and aircraft make and model

IDENTIFIER 2220

PROCESS Enter, modify, query, delete aircraft variable costs.

DEFINITION Maintain valid information about variable costs for
Government owned and operated

aircraft.

IDENTIFIER 2230

PROCESS Enter, modify, query, delete aircraft variable maintenance
costs.

DEFINITION Maintain valid information for aircraft variable costs for
fuel and lubricants, crew costs,

lease costs, landing and tie down fees, maintenance labor and parts,
maintenance contracts,

and other maintenance expense.

IDENTIFIER 2240

PROCESS Enter, modify, query, delete aircraft variable overhaul and
repair costs.

DEFINITION Maintain valid information for the cost of engine overhaul,
aircraft refurbishment, and

major component repairs.

IDENTIFIER 2250

PROCESS Enter, modify, query, delete aircraft fixed crew costs.

DEFINITION Maintain valid information for aircraft fixed crew costs.

IDENTIFIER 2260

PROCESS Enter, modify, query, delete aircraft fixed maintenance and
lease costs.

DEFINITION Maintain valid information for maintenance parts and labor,
maintenance contracts, and

leases.

IDENTIFIER 2270

PROCESS Enter, modify, query, delete aircraft self-insurance costs.

DEFINITION Maintain valid information for aircraft hull and liability
self-insurance costs.

IDENTIFIER 2280

PROCESS Enter, modify, query, delete aircraft indirect costs.

DEFINITION Maintain valid information for indirect costs, including
operations and administrative

overhead.

IDENTIFIER 2290

PROCESS Enter, modify, query, delete other aircraft costs.

DEFINITION Maintain valid information for other aircraft costs,
including the cost of capital or finance

and depreciation.

IDENTIFIER 2300

PROCESS Manage information on aircraft persons.

DEFINITION Capture and maintain valid information on personnel
associated with the operation of

Government-owned aircraft.

IDENTIFIER 2310

PROCESS Enter, modify, query, delete information on persons (aircraft
flight personnel).

DEFINITION Maintain valid information on flight crews and other persons
associated with the operation

of Government-owned aircraft.

IDENTIFIER 2320

PROCESS Enter, modify, query, delete flight crew information.

DEFINITION Maintain valid information about flight crews, including the
persons associated with the

crew.

IDENTIFIER 2330

PROCESS Enter, modify, query, delete flight crew member information.

DEFINITION Maintain valid information for flight crew personnel,
including name, qualifications, and

currency of physical examinations.

IDENTIFIER 2340

PROCESS Enter, modify, query, delete flight crew member roles.

DEFINITION Maintain valid information about the roles crew members are
qualified to perform.

IDENTIFIER 2350

PROCESS Enter, modify, query, delete flight crew role certifications.

DEFINITION Maintain valid and current information on role certifications
for flight crew members.

IDENTIFIER 2360

PROCESS Enter, modify, query, delete flight crew compensation
information.

DEFINITION Capture and maintain valid information on flight crew
compensation, including labor

category and hourly rate.

IDENTIFIER 2400

PROCESS Manage aircraft use information.

DEFINITION Capture and maintain valid information on the utilization of
Government owned and

operated aircraft.

IDENTIFIER 2410

PROCESS Enter, modify, query, delete aircraft use report information.

DEFINITION Maintain valid and current information on the utilization
(flight hours, take-offs and

landings, etc.) of Government owned and operated aircraft.

IDENTIFIER 2420

PROCESS Enter, modify, query, delete aircraft use details (flight leg
information).

DEFINITION Maintain valid information on the detailed use of Government
owned and operated aircraft

(flight leg information), including flight origin and destination,
flight date and time, FAA

registration no., and pilot names.

IDENTIFIER 2500

PROCESS Manage allocated and assigned aircraft cost information.

DEFINITION Capture and maintain valid information for the allocation and
assignment of costs to

individual aircraft for quarterly or monthly accounting periods.

IDENTIFIER 2510

PROCESS Enter, modify, query, delete allocable costs.

DEFINITION Maintain valid information for the allocation of an
individual aircraft\'s yearly costs to a

quarterly or monthly basis.

IDENTIFIER 2520

PROCESS Generate detailed posted costs by accounting month from
allocable costs.

DEFINITION Generate standard and ad hoc reports showing the allocation
of detailed costs for individual

aircraft by accounting month.

IDENTIFIER 2530

PROCESS Generate tail number assigned costs.

DEFINITION Generate standard and ad hoc reports showing detailed costs
for individual aircraft by

accounting month.

IDENTIFIER 2600

PROCESS Manage aircraft cost information using local accounting codes.

DEFINITION Capture and maintain aircraft cost information using local
accounting codes cross

referenced to CAG codes.

IDENTIFIER 2610

PROCESS Enter, modify, query, delete local accounting codes for aircraft
costs.

DEFINITION Maintain valid information about local accounting codes.

IDENTIFIER 2620

PROCESS Generate cost information using local accounting codes.

DEFINITION Generate standard and ad hoc reports using local accounting
codes.

IDENTIFIER 2700

PROCESS Manage home base changes and special equipment.

DEFINITION Capture and maintain valid and current information about
aircraft home bases and special

equipment.

IDENTIFIER 2710

PROCESS Enter, modify, query, delete home base change information.

DEFINITION Maintain valid and current information about home bases for
aircraft.

IDENTIFIER 2720

PROCESS Enter, modify, query, delete special equipment history
information.

DEFINITION Maintain a historical record of special equipment changes to
an aircraft.

IDENTIFIER 2800

PROCESS Report aircraft finance and accounting information.

DEFINITION Generate standard and ad hoc reports to display and summarize
aircraft finance and

accounting information previously entered into the system.

IDENTIFIER 2810

PROCESS Generate Senior Federal/Special Category travel reports.

DEFINITION Generate reports which display the Senior Federal/Special
Category travel information

previously entered into the system.

IDENTIFIER 2820

PROCESS Generate Government operated aircraft cost reports.

DEFINITION Generate reports which display the Government operated
aircraft cost information previously

entered into the system.

IDENTIFIER 2830

PROCESS Generate aircraft persons reports.

DEFINITION Generate reports which display information about aircraft
persons previously entered into

the system.

IDENTIFIER 2840

PROCESS Generate aircraft use reports.

DEFINITION Generate reports which display the aircraft use information
previously entered into the

system.

IDENTIFIER 2850

PROCESS Generate account type summary reports.

DEFINITION Generate reports which summarize and display by account type
the financial information

previously entered into the system.

IDENTIFIER 2852

PROCESS Generate cost category summary reports.

DEFINITION Generate reports which summarize and display by cost category
the financial information

previously entered into the system.

IDENTIFIER 2854

PROCESS Generate CAG code summary reports.

DEFINITION Generate reports which summarize and display by CAG code the
financial information

previously entered into the system.

IDENTIFIER 2856

PROCESS Generate cost code summary reports.

DEFINITION Generate reports which summarize and display by cost code the
financial information

previously entered into the system.

IDENTIFIER 2860

PROCESS Generate cost reports using local accounting codes.

DEFINITION Generate reports which display cost information using local
accounting codes previously

entered into the system.

IDENTIFIER 2870

PROCESS Generate home base and home base change reports.

DEFINITION Generate reports which display the home base and home base
change information

previously entered into the system.

IDENTIFIER 2900

PROCESS Manage aircraft finance and accounting reference information.

DEFINITION Capture and maintain valid reference information for aircraft
finance and accounting,

including tables of codes and descriptions for pop-up lists of values.

IDENTIFIER 2902

PROCESS Enter, modify, query, delete passenger status codes.

DEFINITION Maintain a valid table of passenger status codes and
descriptions.

IDENTIFIER 2904

PROCESS Enter, modify, query, delete passenger purpose codes.

DEFINITION Maintain a valid table of passenger purpose codes and
descriptions.

IDENTIFIER 2906

PROCESS Enter, modify, query, delete user codes.

DEFINITION Maintain a valid table of user codes and descriptions.

IDENTIFIER 2908

PROCESS Enter, modify, query, delete pay codes.

DEFINITION Maintain a valid table of pay codes and descriptions.

IDENTIFIER 2910

PROCESS Enter, modify, query, delete account types.

DEFINITION Maintain a valid table of account type codes and
descriptions.

IDENTIFIER 2912

PROCESS Enter, modify, query, delete agency cost codes.

DEFINITION Maintain a valid table of agency cost codes and descriptions.

IDENTIFIER 2914

PROCESS Enter, modify, query, delete aircraft cost summary codes.

DEFINITION Maintain a valid table of aircraft cost summary codes.

IDENTIFIER 2922

PROCESS Enter, modify, query, delete home base codes.

DEFINITION Maintain a valid table of home base codes and descriptions.

IDENTIFIER 2924

PROCESS Enter, modify, query, delete Cost Accounting Guide (CAG) codes.

DEFINITION Maintain a valid table of Cost Accounting Guide (CAG) codes
and descriptions.

IDENTIFIER 2926

PROCESS Enter, modify, query, delete cost categories.

DEFINITION Maintain a valid table of cost categories and descriptions.

IDENTIFIER 2928

PROCESS Enter, modify, query, delete object classes.

DEFINITION Maintain a valid table of object classes and descriptions.

IDENTIFIER 2930

PROCESS Enter, modify, query, delete local accounting codes.

DEFINITION Maintain a valid table of local accounting codes and
descriptions.

IDENTIFIER 2932

PROCESS Enter, modify, query, delete storage location codes.

DEFINITION Maintain a valid table of storage location codes and
descriptions.

IDENTIFIER 2934

PROCESS Enter, modify, query, delete closing dates.

DEFINITION Maintain a valid table of closing start and end dates by
accounting month.

IDENTIFIER 3000

PROCESS Manage aviation maintenance (MNT) information.

DEFINITION Provide functional support for the management of aviation
maintenance information on a

Government-wide basis.

IDENTIFIER 3100

PROCESS Manage aircraft Maintenance Procedure Card (MPC) action
information.

DEFINITION Capture and maintain maintenance procedure action information
related to aircraft

Maintenance Procedure Cards (MPCs).

IDENTIFIER 3110

PROCESS Enter, modify, query, delete component removal information.

DEFINITION Maintain valid information concerning aircraft component
removals.

IDENTIFIER 3120

PROCESS Enter, modify, query, delete component installation information.

DEFINITION Maintain valid information concerning aircraft component
installations.

IDENTIFIER 3130

PROCESS Enter, modify, query, delete component shipping information.

DEFINITION Maintain valid information concerning the shipping of
aircraft components.

IDENTIFIER 3140

PROCESS Enter, modify, query, delete component receipt acknowledgment
information.

DEFINITION Maintain valid information concerning aircraft component
receipt acknowledgments.

IDENTIFIER 3150

PROCESS Enter, modify, query, delete component acceptance check
information.

DEFINITION Maintain valid information concerning aircraft component
acceptance checks.

IDENTIFIER 3160

PROCESS Enter, modify, query, delete modify reference information
related to components.

DEFINITION Maintain valid information related to components (Time
Compliance Technical Orders,

revisions, bulletins, etc.).

IDENTIFIER 3170

PROCESS Enter, modify, query, delete component repair information.

DEFINITION Maintain valid information about component repairs.

IDENTIFIER 3180

PROCESS Enter, modify, query component status information

DEFINITION Maintain valid information about the status of components.

IDENTIFIER 3200

PROCESS Manage enrollment information.

DEFINITION Capture and maintain valid enrollment information for
components, aircraft, installed avionics

equipment, spare equipment, and Special Requirements (SR) components.

IDENTIFIER 3210

PROCESS Enter, modify, query, delete component enrollment information.

DEFINITION Maintain valid enrollment information for components.

IDENTIFIER 3220

PROCESS Enter, modify, query, delete enrollment information for an
aircraft.

DEFINITION Maintain valid enrollment information for aircraft

IDENTIFIER 3230

PROCESS Enter, modify, query, delete enrollment information for
installed avionics equipment.

DEFINITION Maintain valid enrollment information for installed avionics
equipment.

IDENTIFIER 3240

PROCESS Enter, modify, query, delete spare equipment enrollment
information.

DEFINITION Maintain valid enrollment information for spare equipment.

IDENTIFIER 3250

PROCESS Enter, modify, query, delete Special Requirements (SR)
components enrollment

information.

DEFINITION Maintain valid enrollment information for Special
Requirements (SR) components.

IDENTIFIER 3300

PROCESS Manage component history and Time Compliance Technical Order
(TCTO) tracking

information.

DEFINITION Capture and maintain valid information for the history of
components and avionics

components, and the tracking of Time Compliance Technical Orders
(TCTOs).

IDENTIFIER 3310

PROCESS Enter, modify, query, delete component history information.

DEFINITION Maintain valid information concerning the history of
components.

IDENTIFIER 3320

PROCESS Enter, modify, query, delete avionics component history
information.

DEFINITION Maintain valid information concerning the history of avionics
components.

IDENTIFIER 3330

PROCESS Enter, modify, query, delete Time Compliance Technical Order
(TCTO) tracking information.

DEFINITION Capture and maintain valid information on the tracking of
Time Compliance Technical

Orders (TCTOs).

IDENTIFIER 3400

PROCESS Manage Aircraft Statistics Report (ASR) information.

DEFINITION Capture and maintain valid statistical information on
aircraft maintenance.

IDENTIFIER 3410

PROCESS Enter, modify, query, delete aircraft maintenance status
information.

DEFINITION Capture and maintain valid information concerning the
maintenance status of aircraft.

IDENTIFIER 3420

PROCESS Create and run ad hoc Aircraft Assembly Reports (ASRs).

DEFINITION Generate user-defined Aircraft Assembly Reports (ASRs) as
required, and save report

definitions for subsequent use.

IDENTIFIER 3500

PROCESS Manage Mandatory Special Requirements (MSR) action information.

DEFINITION Capture and maintain Mandatory Special Requirements (MSR)
action information.

IDENTIFIER 3510

PROCESS Enter, modify, query, delete Mandatory Special Requirements
(MSR) enrollment information.

DEFINITION Capture and maintain valid Mandatory Special Requirements
(MSR) item enrollment

information.

IDENTIFIER 3520

PROCESS Remove/disenroll a Mandatory Special Requirements (MSR) item.

DEFINITION Capture and maintain valid information of the removal or
disenrollment of a Mandatory

Special Requirements (MSR) item.

IDENTIFIER 3530

PROCESS Transfer a Mandatory Special Requirements (MSR) item.

DEFINITION Capture and maintain valid information on the transfer of a
Mandatory Special

Requirements (MSR) item from one organizational unit to another.

IDENTIFIER 3540

PROCESS Change the serial number of a Mandatory Special Requirements
(MSR) item.

DEFINITION Accomplish and record valid information about the change of
serial number of a Mandatory

Special Requirements (MSR) item.

IDENTIFIER 3550

PROCESS Change the field identifier of a Mandatory Special Requirements
(MSR) item.

DEFINITION Accomplish and record valid information about the change of
field identifier of a

Mandatory Special Requirements (MSR) item.

IDENTIFIER 3560

PROCESS Change the location of a Mandatory Special Requirements (MSR)
item.

DEFINITION Accomplish and record valid information about location
changes for a Mandatory Special

Requirements (MSR) item.

IDENTIFIER 3570

PROCESS Assign a Mandatory Special Requirements (MSR) item to a Search
and Rescue (SAR)

mission.

DEFINITION Accomplish and record valid information about the assignment
of a Mandatory Special

Requirements (MSR) item to a Search and Rescue (SAR) mission.

IDENTIFIER 3700

PROCESS Report aviation maintenance information.

DEFINITION Generate standard and ad hoc reports to display and summarize
aircraft maintenance

information previously entered into the system.

IDENTIFIER 3702

PROCESS Generate configuration reports of an aircraft or any
user-selected assembly.

DEFINITION Generate reports which display aircraft or assembly
configuration information previously

entered into the system.

IDENTIFIER 3704

PROCESS Generate Maintenance Due List (MDL) for a user-selected
projection interval.

DEFINITION Generate maintenance schedules based on information
previously entered into the system.

IDENTIFIER 3706

PROCESS Generate status report showing the most recent occurrence of
selected maintenance actions.

DEFINITION Generate status reports which display information on
maintenance actions previously

entered into the system.

IDENTIFIER 3708

PROCESS Generate Significant Component History (SCH) reports based on
user-selected parameters.

DEFINITION Generate reports which display component history information
previously entered into the

system.

IDENTIFIER 3710

PROCESS Generate Overdue Maintenance Due Lists (OMLs) based on
user-selected parameters.

DEFINITION Generate reports based on information previously entered into
the system which display

overdue maintenance actions by organizational unit.

IDENTIFIER 3712

PROCESS Generate Search and Rescue (SAR) assigned equipment reports.

DEFINITION Generate reports which display information previously entered
into the system concerning

equipment assigned to Search and Rescue (SAR) missions.

IDENTIFIER 3714

PROCESS Generate Maintenance Requirements List (MRL) established since
start date.

DEFINITION Generate reports which display inception to date information
on maintenance schedules

previously entered into the system.

IDENTIFIER 3716

PROCESS Generate Component Summary (CSU) report for any serial number
tracked component.

DEFINITION Generate reports which summarize and display previously
entered information for any

serial number tracked components.

IDENTIFIER 3718

PROCESS Generate maintenance history for one user-selected aircraft or
assembly.

DEFINITION Generate reports which display previously entered maintenance
history information for an

aircraft or assembly.

IDENTIFIER 3720

PROCESS Generate Component Removal Explanation (CRE) reports.

DEFINITION Generate reports which display component removal explanation
information previously

entered into the system.

IDENTIFIER 3722

PROCESS Generate Performance and Reliability Summary (PRS) reports.

DEFINITION Generate reports which summarized and display performance and
reliability information

previously entered into the system.

IDENTIFIER 3724

PROCESS Generate Inspections and Services Summary (ISS) reports.

DEFINITION Generate reports which summarize and display inspections and
services information

previously entered into the system.

IDENTIFIER 3726

PROCESS Generate Programmed Depot Maintenance (PDM) reports.

DEFINITION Generate reports which display depot maintenance schedule
information previously entered

into the system.

IDENTIFIER 3728

PROCESS Generate Maintenance Due Lists (MDLs) for Special Requirements
(SR) components.

DEFINITION Generate reports which display information on maintenance
schedules for Special

Requirements (SR) components previously entered into the system.

IDENTIFIER 3730

PROCESS Generate component monitoring reports.

DEFINITION Generate reports which display component monitoring
information previously entered into

the system.

IDENTIFIER 3732

PROCESS Generate status report on serial number tracked components.

DEFINITION Generate reports which display information serial number
tracked components previously

entered into the system.

IDENTIFIER 3734

PROCESS Generate comprehensive Time Compliance Technical Order (TCTO)
status report.

DEFINITION Generate reports which display status information on Time
Compliance Technical Orders

(TCTOs) previously entered into the system.

IDENTIFIER 3736

PROCESS Generate trend analysis report on component removal rate because
of failure.

DEFINITION Generate reports which display trend analyses of the
component removal rates for failed

components.

IDENTIFIER 3740

PROCESS Generate aircraft grounded or deployed reports.

DEFINITION Generate reports which display aircraft grounded or deployed
information previously entered

into the system.

IDENTIFIER 3742

PROCESS Generate overall Not Mission Capable (NMC) flight report for an
aircraft type.

DEFINITION Generate reports which display information previously entered
into the system for Not

Mission Capable (NMC) aircraft by aircraft type.

IDENTIFIER 3744

PROCESS Generate Not Mission Capable (NMC) how goes it reports.

DEFINITION Generate how goes it reports which display previously entered
Not Mission Capable (NMC)

information for a user-selected number of days less than a month.

IDENTIFIER 3746

PROCESS Generate Not Mission Capable (NMC) and percent program hours
reports.

DEFINITION Generate reports which display previously entered Not Mission
Capable (NMC) program

hours and a computed percentage for a user-selected month.

IDENTIFIER 3748

PROCESS Generate day and duty hours reports on Not Mission Capable (NMC)
status.

DEFINITION Generate reports which display previously entered information
on Not Mission Capable

(NMC) status as related to day and duty hours.

IDENTIFIER 3750

PROCESS Generate monthly operating statistics reports.

DEFINITION Generate reports which compute and display aircraft operating
statistics on the basis of

information previously entered into the system.

IDENTIFIER 3752

PROCESS Generate reports showing aircraft status for each 24-hour period
of the month.

DEFINITION Generate reports which display for each 24-hour period of the
month the previously entered

status information for an aircraft.

IDENTIFIER 3800

PROCESS Report avionics tracking information.

DEFINITION Generate standard and ad hoc reports to display and summarize
avionics tracking

information previously entered into the system.

IDENTIFIER 3802

PROCESS Generate configuration reports of serial number tracked items
for an aircraft type.

DEFINITION Generate reports which display previously entered
configuration information for serial

number tracked items by aircraft type.

IDENTIFIER 3804

PROCESS Generate component summary reports for any serial number tracked
component.

DEFINITION Generate reports which summarize and display previously
entered component information

for one or more serial number tracked components.

IDENTIFIER 3806

PROCESS Generate component history reports showing significant actions
for an item.

DEFINITION Generate reports which display previously entered component
history information,

highlighting significant actions for an item.

IDENTIFIER 3808

PROCESS Generate inspection and service summary reports.

DEFINITION Generate reports which summarize and display previously
entered inspection and service

information.

IDENTIFIER 3810

PROCESS Generate intransit shipping reports.

DEFINITION Generate reports which display previously entered intransit
shipping information.

IDENTIFIER 3812

PROCESS Generate unit inventory summary reports of components at the
selected activity.

DEFINITION Generate reports which summarize and display previously
entered component unit

inventory information for selected activities.

IDENTIFIER 3814

PROCESS Generate aircraft status reports - a summarized listing of
configuration codes.

DEFINITION Generate reports which summarize and display previously
entered configuration codes and

related information for one or more aircraft.

IDENTIFIER 3816

PROCESS Generate Time Compliance Technical Order (TCTO)/bulletin status
summary reports.

DEFINITION Generate reports which summarize and display previously
entered information on the status

of Time Compliance Technical Orders (TCTOs) and bulletins.

IDENTIFIER 3818

PROCESS Generate Time Compliance Technical Order (TCTO)/Bulletin status
reports.

DEFINITION Generate reports which display previously entered status
information on Time Compliance

Technical Orders (TCTOs) and bulletins.

IDENTIFIER 3820

PROCESS Generate Maintenance Due Lists (MDLs) for a specified period.

DEFINITION Generate reports which display previously entered maintenance
schedule information for a

specified period.

IDENTIFIER 3822

PROCESS Generate component removal reports for a specified period of
time.

DEFINITION Generate reports which display previously entered component
removal information for a

specified period of time.

IDENTIFIER 3824

PROCESS Generate comprehensive shipping reports showing items in
transit.

DEFINITION Generate reports which display all items in transit on the
basis of previously entered

shipping information.

IDENTIFIER 3900

PROCESS Manage aircraft maintenance reference information.

DEFINITION Capture and maintain valid reference information for aircraft
maintenance, including tables of

codes and descriptions for pop-up lists of values.

IDENTIFIER 3902

PROCESS Enter, modify, query, delete task information.

DEFINITION Capture and maintain valid task information by task type,
position, primary labor type, and

procedure; tasks are uniquely identified by a system-generated number.

IDENTIFIER 3904

PROCESS Enter, modify, query, delete depot task information.

DEFINITION Capture and maintain valid depot-related information for a
task.

IDENTIFIER 3906

PROCESS Enter, modify, query, delete equipment task information.

DEFINITION Capture and maintain valid equipment-related information for
a task.

IDENTIFIER 3908

PROCESS Generate equipment task history records.

DEFINITION Tracks the history of equipment tasks; creates a record for
each time a given equipment task

is executed for a particular part.

IDENTIFIER 3910

PROCESS Enter, modify, query, delete associated task information.

DEFINITION Capture and maintain valid associated task information,
including the identifier for the

topmost node of the association tree; associated tasks are uniquely
identified by a

system-generated number.

IDENTIFIER 3912

PROCESS Enter, modify, query, delete part information.

DEFINITION Capture and maintain valid part information, including parent
and ancestor part identifiers,

the component type and identifier, and the organization and position
identifiers; parts are

uniquely identified by a system-generated number.

IDENTIFIER 3914

PROCESS Enter, modify, query, delete component information.

DEFINITION Capture and maintain valid component information, including
the component type and

parent and ancestor identifiers; components are uniquely identified by a
system-generated

number.

IDENTIFIER 3916

PROCESS Enter, modify, query, delete part task information.

DEFINITION Capture and maintain a valid list of tasks associated with
specific parts.

IDENTIFIER 3918

PROCESS Generate part task history records.

DEFINITION Tracks the history of maintenance transactions, with
system-generated part, task, and

history record identifiers.

IDENTIFIER 3920

PROCESS Generate maintenance transactions.

DEFINITION Assigns a unique, system-generated identifier to each
maintenance transaction (group

consisting of a primary task and all associated tasks signed off
simultaneously). Each task

contains information common to all tasks in the transaction.

IDENTIFIER 3922

PROCESS Generate log entries.

DEFINITION Tracks the date and sequence number of a logged event.

IDENTIFIER 3924

PROCESS Enter, modify, query, delete equipment task type information.

DEFINITION Capture and maintain valid information about task types and
descriptions; a task type is

uniquely identified by a system-generated number.

IDENTIFIER 3926

PROCESS Generate case (mission) history records.

DEFINITION For Mandatory Special Requirements (MSR) use only. Associates
a given part with each

case (mission) on which it was deployed during its lifetime.

IDENTIFIER 3928

PROCESS Enter, modify, query, delete task labor type information.

DEFINITION Capture and maintain valid information to associate each task
with the labor type(s) and

person hours required for its execution.

IDENTIFIER 3930

PROCESS Enter, modify, query, delete task parameter information.

DEFINITION Capture and maintain valid information which specifies how
often each task will be

performed based on a given parameter, part class, and range of iteration
values. Associates

each range of iteration with the parameter value for aging of the part.

IDENTIFIER 3932

PROCESS Enter, modify, query, delete task type status information.

DEFINITION Capture and maintain valid information which associates a
given status (e.g., installed,

uninstalled, etc.) with the task types that may legally be performed on
a component having

that status.

IDENTIFIER 3934

PROCESS Enter, modify, query, delete Time Compliance Technical Order
(TCTO) information.

DEFINITION Capture and maintain valid Time Compliance Technical Order
(TCTO) information to track

a given order to do a specific, one-time repair or change to a certain
item or class of items

from origination until it is entered into the system as a task.

IDENTIFIER 3936

PROCESS Enter, modify, query, delete procedure class member information.

DEFINITION Capture and maintain valid information which associates each
procedure class with its

procedure members.

IDENTIFIER 3938

PROCESS Enter, modify, query, delete procedure revision information.

DEFINITION Capture and maintain valid information which associates each
procedure with its last date of

revision.

IDENTIFIER 3940

PROCESS Enter, modify, query, delete suspension information.

DEFINITION Capture and maintain valid information which identifies each
part that has been suspended

from service due to defects.

IDENTIFIER 3942

PROCESS Enter, modify, query, delete task category information.

DEFINITION Capture and maintain valid information about task categories,
including a system-generated

unique identifier.

IDENTIFIER 3944

PROCESS Enter, modify, query, delete task category reasons.

DEFINITION Capture and maintain valid information to associate each task
category with every task

reason that legally justifies the performance of tasks for that
category.

IDENTIFIER 3946

PROCESS Enter, modify, query, delete task category types.

DEFINITION Capture and maintain valid information to associate each task
category with each of its task

type members.

IDENTIFIER 3948

PROCESS Enter, modify, query, delete task class information.

DEFINITION Capture and maintain valid information to assign a unique,
system-generated identifier to

each task class (group of tasks which users may create for any reason).

IDENTIFIER 3950

PROCESS Enter, modify, query, delete task class task information.

DEFINITION Capture and maintain valid information to associate each task
class with each of its task

members.

IDENTIFIER 3951

PROCESS Enter, modify, query, delete component version information.

DEFINITION Capture and maintain valid information to assign a unique,
system-generated identifier to

each component version (unique configuration of a particular assembly).

IDENTIFIER 3952

PROCESS Enter, modify, query, delete component version member
information.

DEFINITION Capture and maintain valid information to associate each
component version with each of

its member components which must be excluded from the complete assembly
in order to

obtain the version.

IDENTIFIER 3953

PROCESS Enter, modify, query, delete component type task information.

DEFINITION Capture and maintain a list which associates each component
type with a system-generated

unique identifier.

IDENTIFIER 3954

PROCESS Enter, modify, query, delete component type parameter
information.

DEFINITION Capture and maintain valid information to associate each
component type with each

parameter used to track its age, and with the maximum and minimum values
by which the

parameter may be incremented.

IDENTIFIER 3955

PROCESS Enter, modify, query, delete component part type information.

DEFINITION Capture and maintain valid information to associate each
component type with each part

type that satisfies the component type\'s unique form, fit, and
function.

IDENTIFIER 3956

PROCESS Enter, modify, query, delete component class type information.

DEFINITION Capture and maintain valid information to associate each
component class with its

component type members.

IDENTIFIER 3957

PROCESS Enter, modify, query, delete task type information.

DEFINITION Capture and maintain a valid list of task types with unique,
system-generated identifiers.

IDENTIFIER 3958

PROCESS Enter, modify, query, delete component class information.

DEFINITION Capture and maintain valid information which assigns a
unique, system-generated identifier

to each component class (group of component types that users may create
for any reason).

IDENTIFIER 3959

PROCESS Enter, modify, query, delete position information.

DEFINITION Capture and maintain a valid list of standard positions with
unique, system-generated

identifiers.

IDENTIFIER 3960

PROCESS Enter, modify, query, delete labor type information.

DEFINITION Capture and maintain valid information about standard labor
types, uniquely identified by

system-generated numbers.

IDENTIFIER 3962

PROCESS Enter, modify, query, delete procedure information.

DEFINITION Capture and maintain valid information about maintenance
procedures; each procedure is

uniquely identified by a system-generated number.

IDENTIFIER 3963

PROCESS Enter, modify, query, delete part type information.

DEFINITION Capture and maintain valid information about part types,
including the part category,

manufacturer's identifier, and a description of the part type; each part
type is uniquely

identified by a system-generated number.

IDENTIFIER 3964

PROCESS Enter, modify, query, delete organization information.

DEFINITION Capture and maintain valid information about organizations,
including organization code,

description of the organization, parent organization identifier, and a
top-down list of the

organization\'s ancestors.

IDENTIFIER 3965

PROCESS Enter, modify, query, delete component type information.

DEFINITION Capture and maintain valid information about component types,
including the component

type code and description; each component type is uniquely identified by
a

system-generated number.

IDENTIFIER 3966

PROCESS Enter, modify, query, delete manufacturer information.

DEFINITION Capture and maintain valid information about manufacturers,
including name and CAGE

code; each manufacturer is uniquely identified by a system-generated
number.

IDENTIFIER 3967

PROCESS Enter, modify, query, delete part class information.

DEFINITION Capture and maintain valid information about part classes,
including a description, the

component type, and the logic type which applies to the part class
(equal to, not equal to,

etc.); each part class is uniquely identified by a system-generated
number.

IDENTIFIER 3968

PROCESS Enter, modify, query, delete task reason information.

DEFINITION Capture and maintain valid information about task reasons
(justification for the execution of

a task), including the task code, a statement of the reason for the
task, and a unique

system-generated identifier.

IDENTIFIER 3969

PROCESS Enter, modify, query, delete organization assembly type
information.

DEFINITION Capture and maintain valid information which associates a
given assembly type at a given

organization with the current annual allocation of flight hours and the
number of

assemblies.

IDENTIFIER 3970

PROCESS Enter, modify, query, delete parameter information.

DEFINITION Capture and maintain valid information about maintenance
parameters, including a

description, the parameter abbreviation, and the system-generated unique
identifier of the

parameter.

IDENTIFIER 3971

PROCESS Generate organization assembly statistics.

DEFINITION Records statistical information about assemblies by
organization; computes each month the

amount of aging for a given assembly and selected parameter.

IDENTIFIER 3972

PROCESS Record organization assembly type statistics.

DEFINITION Capture statistical information on assembly types by
organization, including annual

complement, operational hours, and unavailability percentages due to
maintenance and

supply.

IDENTIFIER 3973

PROCESS Enter, modify, query, delete organization procedure card
information.

DEFINITION Capture and maintain valid information which associates each
organization with specific

information on maintenance procedure cards for inventory purposes.

IDENTIFIER 3974

PROCESS Enter, modify, query, delete part class member information.

DEFINITION Capture and maintain valid information which associates a
part class with each of its

members, which may be parts, part types, or organizations.

IDENTIFIER 3976

PROCESS Enter, modify, query, delete part class part code information.

DEFINITION Capture and maintain valid information on part codes (serial
numbers) which are potential

members of a part class which does not yet exist in the system.

IDENTIFIER 3978

PROCESS Enter, modify, query, delete part class tasks.

DEFINITION Capture and maintain valid information which associates each
part class with the tasks

performed on its members.

IDENTIFIER 3980

PROCESS Enter, modify, query, delete part comments.

DEFINITION Capture and maintain valid system-generated or user-provided
comments on parts.

IDENTIFIER 3982

PROCESS Enter, modify, query, delete part location information.

DEFINITION For Mandatory Special Requirements use only (parts not
directly attached to an assembly.

Capture and maintain valid information which associates each part with
general and specific

locations and the case number (if any) on which it is currently
deployed.

IDENTIFIER 3984

PROCESS Enter, modify, query, delete part log information.

DEFINITION Capture and maintain valid information which associates each
log with the parts (entry

points) to which each parameter applies.

IDENTIFIER 3986

PROCESS Enter, modify, query, delete part log parameter information.

DEFINITION Capture and maintain valid information which associates each
point of entry of an assembly

with its age in terms of its parameters at the time of the log entry.

IDENTIFIER 3990

PROCESS Enter, modify, query, delete part parameter information.

DEFINITION Capture and maintain valid information which associates each
part with the current value of

its relevant parameters (e.g., landings, flight hours).

IDENTIFIER 3992

PROCESS Generate part task labor history information.

DEFINITION Capture and maintain valid information which associates each
execution of a task on a

given part with each labor type and the associated number of manhours
required to

complete the task.

IDENTIFIER 3994

PROCESS Enter, modify, query, delete part task parameter information.

DEFINITION Capture and maintain valid information which associates
relevant parameters and their

values for the last execution of a given task on a given part.

IDENTIFIER 3996

PROCESS Enter, modify, query, delete procedure class information.

DEFINITION Capture and maintain valid information on procedure classes
which group procedures;

procedure classes are uniquely identified by a system-generated number.

IDENTIFIER 4000

PROCESS Manage aviation logistics (LOG) information.

DEFINITION Provide functional support for the management of aviation
logistics information on a

Government-wide basis.

IDENTIFIER 4100

PROCESS Manage flight crew scheduling actives.

DEFINITION Maintain valid flight crew information to support the
management of flight crew scheduling.

IDENTIFIER 4110

PROCESS Enter, modify, query, delete flight crew pay information.

DEFINITION Capture and maintain valid flight crew compensation
information, including standard rate

per hour, benefits rate per hour, and overtime rate per hour.

IDENTIFIER 4120

PROCESS Enter, modify, query, delete flight crew role and certification
information.

DEFINITION Capture and maintain valid information on roles and
certifications for flight crew members.

IDENTIFIER 4130

PROCESS Enter, modify, query, delete flight crew physical examination
information.

DEFINITION Capture and maintain valid information on the currency of
required physical examinations

for crew members.

IDENTIFIER 4140

PROCESS Enter, modify, query, delete flight crew duty time information.

DEFINITION Capture and maintain flight crew duty time information for
each flight leg flown, including

regular and overtime hours worked.

IDENTIFIER 4150

PROCESS Enter, modify, query, delete flight crew role performance
information.

DEFINITION Capture and maintain flight crew role information for each
flight leg flown, including the

role performed by each crew member.

IDENTIFIER 4200

PROCESS Manage air travel planning information.

DEFINITION Maintain valid Government passenger information to support
the management of air travel

planning.

IDENTIFIER 4210

PROCESS Enter, modify, query, delete Government rank and pay
information.

DEFINITION Capture and maintain Government rank and pay information to
support air travel planning.

IDENTIFIER 4220

PROCESS Enter, modify, query, delete Senior Federal Travel passenger
information.

DEFINITION Capture and maintain a record of Senior Federal and Special
Category Travel passenger

information.

IDENTIFIER 4230

PROCESS Enter, modify, query, delete passenger flight data.

DEFINITION Capture and maintain individual passenger information by
flight.

IDENTIFIER 4240

PROCESS Enter, modify, query, delete passenger flight leg information.

DEFINITION Capture and maintain individual passenger information by
flight leg.

IDENTIFIER 4300

PROCESS Manage flight planning information.

DEFINITION Maintain valid information about commercial and Government
flight costs to support the

management of flight planning activities.

IDENTIFIER 4310

PROCESS Enter, modify, query, delete aircraft type information.

DEFINITION Capture and maintain valid logistical information about
aircraft types, including a code for

the aircraft make and model, the maximum hours the crew can fly, the
cargo load time, and

the average cruising speed.

IDENTIFIER 4320

PROCESS Enter, modify, query, delete cost information about specific
flights.

DEFINITION Capture and maintain valid information on the cost of a
flight, including commercial cost,

contract cost, and chartered cost.

IDENTIFIER 4330

PROCESS Enter, modify, query, delete flight leg information.

DEFINITION Capture and maintain valid information about flight legs,
including scheduled take-off and

landing date and time, the cargo configuration and seat capacity of the
aircraft, and the

calculated flying distance.

IDENTIFIER 4340

PROCESS Enter, modify, query, delete Senior Federal Travel aircraft
information.

DEFINITION Capture and maintain information about aircraft used for
Senior Federal Travel.

IDENTIFIER 4800

PROCESS Report aircraft logistics information.

DEFINITION Generate standard and ad hoc reports to display and summarize
aircraft logistics

information reviously entered into the system.

IDENTIFIER 4810

PROCESS Generate flight crew scheduling reports.

DEFINITION Generate reports which display information about flight crew
schedules previously entered

into the system.

IDENTIFIER 4820

PROCESS Generate flight crew role and certification reports.

DEFINITION Generate reports which display role and certification
information previously entered into

the system.

IDENTIFIER 4830

PROCESS Generate flight crew physical examination timeliness reports.

DEFINITION Generate reports which display information on the timeliness
of flight crew physical

examinations previously entered into the system.

IDENTIFIER 4840

PROCESS Generate flight crew duty time reports.

DEFINITION Generate flight crew duty time reports which display
information previously entered into

the system.

IDENTIFIER 4860

PROCESS Generate flight crew role performance and cost reports.

DEFINITION Generate reports which display flight crew role performance
and cost information

Previously entered into the system.

IDENTIFIER 4870

PROCESS Generate flight information reports.

DEFINITION Generate reports which display flight logistics and cost
information previously entered into

the system.

IDENTIFIER 4880

PROCESS Generate flight leg information reports.

DEFINITION Generate reports which display flight leg crew, passenger,
and cost information previously

entered into the system.

IDENTIFIER 4890

PROCESS Generate Senior Federal Travel aircraft reports.

DEFINITION Generate reports which display Senior Federal information
previously entered into the

system.

IDENTIFIER 4900

PROCESS Manage aircraft logistics reference information.

DEFINITION Capture and maintain valid reference information for aircraft
logistics, including tables of

codes and descriptions for pop-up lists of values.

IDENTIFIER 4910

PROCESS Enter, modify, query, delete passenger purpose of travel
information.

DEFINITION Capture and maintain purpose of travel codes and information.

IDENTIFIER 4920

PROCESS Enter, modify, query, delete passenger type information.

DEFINITION Capture and maintain passenger type codes and descriptions.

IDENTIFIER 4930

PROCESS Enter, modify, query, delete flight purpose information.

DEFINITION Capture and maintain flight purpose codes and descriptions.

IDENTIFIER 5000

PROCESS Manage aviation training (TRN) information.

DEFINITION Provide functional support for the management of aviation
training information on a

Government-wide basis.

IDENTIFIER 5100

PROCESS Manage aviation personnel training information.

DEFINITION Capture and maintain valid information to support the
management of training for aviation

personnel.

IDENTIFIER 5110

PROCESS Enter, modify, query, delete identification information for
aircraft personnel.

DEFINITION Capture and maintain valid identifying and status information
on aircraft personnel eligible

for training or required to complete training.

IDENTIFIER 5120

PROCESS Enter, modify, query, delete training certification information.

DEFINITION Capture and maintain valid information which associates an
aircraft person with the

school(s) where he or she received certification.

IDENTIFIER 5130

PROCESS Enter, modify, query, delete pilot flight hours information for
aircraft personnel.

DEFINITION Capture and maintain aircraft personnel pilot flight hours
information.

IDENTIFIER 5140

PROCESS Edit, modify, query, delete qualification information for
aircraft personnel.

DEFINITION Capture and maintain valid aircraft personnel qualification
information.

IDENTIFIER 5800

PROCESS Report training information.

DEFINITION Generate standard and ad hoc reports to display and summarize
training information

previously entered into the system.

IDENTIFIER 5810

PROCESS Generate reports on the current qualifications of aviation
personnel.

DEFINITION Generate reports which display the currency of aviation
personnel\'s qualifications in

takeoffs and landings, IFR approaches, and inoculations.

IDENTIFIER 5820

PROCESS Generate requirements forecasting reports.

DEFINITION Generate reports forecasting check ride requirements and due
dates for physicals.

IDENTIFIER 5830

PROCESS Generate aircraft personnel training reports.

DEFINITION Generate reports which display previously entered training
information for aircraft

personnel.

IDENTIFIER 5840

PROCESS Generate aircraft personnel qualification reports.

DEFINITION Generate reports which display previously entered
qualification information for aircraft

personnel.

IDENTIFIER 5850

PROCESS Generate pilot flight hours reports for aircraft personnel.

DEFINITION Generate monthly and annual aircraft personnel pilot flight
hours reports.

IDENTIFIER 5900

PROCESS Manage aviation training reference information.

DEFINITION Capture and maintain valid reference information for aviation
training, including tables of

codes and descriptions for pop-up lists of values.

IDENTIFIER 5910

PROCESS Enter, modify, query, delete information on schools.

DEFINITION Capture and modify valid information about aviation schools,
including name, address, and

type of school.

IDENTIFIER 6000

PROCESS Manage aviation contract support and acquisition (CSA)
information.

DEFINITION Provide functional support for the management of aviation
contract support and acquisition

information on a Government-wide basis.

IDENTIFIER 6100

PROCESS Manage aircraft agreement information.

DEFINITION Capture and maintain valid information to support the
management of aircraft agreements.

IDENTIFIER 6110

PROCESS Enter, modify, query, delete agreement identification
information.

DEFINITION Capture and maintain valid information on aircraft
agreements, including

department/agency/bureau, type of agreement, agreement number, and begin
and end dates.

IDENTIFIER 6120

PROCESS Enter, modify, query, delete agreement mission and aircraft
identification information.

DEFINITION Capture and maintain valid information on mission and
aircraft identification for the

agreement, including mission code, aircraft make and model, FAA
Registration number,

home base, IFR capability, equipment, and passenger seats.

IDENTIFIER 6130

PROCESS Enter, modify, query, delete agreement cost information.

DEFINITION Capture and maintain valid information on agreement costs,
including flight rate per hour,

standby rate per hour, guaranteed availability per hour, overnight
charge, and pilot cost.

IDENTIFIER 6140

PROCESS Enter, modify, query, delete agreement service information.

DEFINITION Capture and maintain valid information on agreement services,
including service

description and service costs.

IDENTIFIER 6150

PROCESS Enter, modify, query, delete agreement vendor information.

DEFINITION Capture and maintain valid information on agreement vendors,
including vendor name,

vendor phone number, and vendor city, state, and ZIP code.

IDENTIFIER 6160

PROCESS Enter, modify, query, delete agreement contact information.

DEFINITION Capture and maintain valid information on agreement contacts,
including contact name,

contact title, contact address, contact phone number, and courier
address.

IDENTIFIER 6170

PROCESS Enter, modify, query, delete agreement support services
information.

DEFINITION Capture and maintain valid information on support services
provided by agreements,

including a description of each support service provided.

IDENTIFIER 6200

PROCESS Manage the entry of incurred costs against aircraft agreements.

DEFINITION Capture and maintain valid information on costs incurred
against aircraft agreements.

IDENTIFIER 6210

PROCESS Enter, modify, query, delete agreement costs for aircraft.

DEFINITION Capture and maintain valid information on aircraft agreement
costs by fiscal year, including

hours flown, in-house cost, and total cost.

IDENTIFIER 6800

PROCESS Report aircraft contract support and acquisition information.

DEFINITION Generate standard and ad hoc reports to display and summarize
contract support and

acquisition information previously entered into the system.

IDENTIFIER 6810

PROCESS Generate agreement summary reports.

DEFINITION Generate reports which summarize and display previously
entered agreement information.

IDENTIFIER 6820

PROCESS Generate agreement status reports.

DEFINITION Generate reports which display previously entered agreement
status information.

IDENTIFIER 6830

PROCESS Generate vendor reports.

DEFINITION Generate reports which display previously entered vendor
information.

IDENTIFIER 6840

PROCESS Generate agreement reports by unit and region.

DEFINITION Generate reports which display unit and regional extracts of
previously entered agreement

information.

IDENTIFIER 6900

PROCESS Manage aviation contract support and acquisition reference
information.

DEFINITION Capture and maintain valid reference information for aviation
contract support and

acquisition, including tables of codes and descriptions for on-line
validation and pop-up

lists of values.

IDENTIFIER 6910

PROCESS Enter, modify, query, delete vendor reference information.

DEFINITION Capture and maintain valid vendor codes and other vendor
reference information.

IDENTIFIER 7000

PROCESS Manage aviation agency unique requirements (AUR) information.

DEFINITION Provide functional support for the management of aviation
agency unique requirements

information on a Government-wide basis.

IDENTIFIER 7100

PROCESS Manage flight invoice information.

DEFINITION Capture and maintain valid information to support the
production of USDA Forest Service

flight invoices.

IDENTIFIER 7110

PROCESS Enter, modify, query, delete flight information for a flight
invoice.

DEFINITION Capture and maintain valid information on USDA Forest Service
invoices, including

invoice id, agreement number, date of the flight. aircraft make and
model, FAA

Registration number, aircraft type, and remarks about the flight

IDENTIFIER 7120

PROCESS Enter, modify, query, delete leg information for a flight
invoice.

DEFINITION Capture and maintain valid information for flight legs
associated with a USDA Forest

Service invoice, including invoice id, leg number, origin and
destination, captain id,

hourly/daily rate, cargo type and weight, copilot id, crew count, and
elapsed time.

IDENTIFIER 7130

PROCESS Print flight invoices.

DEFINITION Generate USDA Forest Service flight invoices to display
previously entered flight and leg

information.

IDENTIFIER 7200

PROCESS Manage the mishap recording process.

DEFINITION Capture and maintain valid information to support the USDA
Forest Service mishap

(accident/incident) recording process.

IDENTIFIER 7210

PROCESS Enter, modify, query, delete mishap information.

DEFINITION Capture and maintain valid information on USDA Forest Service
mishaps, including

mishap id, cause factor code(s), mishap type, aircraft make and model,
FAA Registration

number, aircraft type, mishap date, mission code, vendor id, pilot id,
and remarks.

IDENTIFIER 7800

PROCESS Report aviation agency unique requirements

DEFINITION Generate standard and ad hoc reports to display and summarize
agency unique requirements

information previously entered into the system.

IDENTIFIER 7810

PROCESS Report flight invoice status and summary information.

DEFINITION Generate reports which summarize and display previously
entered USDA Forest Service

flight invoice information.

IDENTIFIER 7820

PROCESS Report mishap information.

DEFINITION Generate reports which summarize and display previously
entered mishap information.

IDENTIFIER 7900

PROCESS Manage aviation agency unique requirements reference
information.

DEFINITION Capture and maintain valid reference information for aviation
agency unique requirements,

including tables of codes and descriptions for on-line validation and
pop-up lists of values.

IDENTIFIER 7910

PROCESS Enter, modify, query, delete mishap factor codes.

DEFINITION Capture and maintain valid information on USDA Forest Service
mishap factor codes and

descriptions.

IDENTIFIER 8000

PROCESS Manage communications information (COM) for C-AMIS.

DEFINITION Provide functional support for the management of
communications information for

C-AMIS on a Government-wide basis.

IDENTIFIER 8100

PROCESS Manage user login information.

DEFINITION Capture and maintain valid information to ensure the on-line
availability of C-AMIS

software, documentation, and user support.

IDENTIFIER 8110

PROCESS Manage user role information.

DEFINITION Capture and maintain valid information on the role of users
to be Administrator, agency

reviewer, or agency user for control purposes.

IDENTIFIER 8120

PROCESS Enter, modify, query, delete user account information.

DEFINITION Capture and maintain valid information on users, including a
system-generated unique

identifier, and the user\'s name, encrypted password, Internet address,
and organization.

IDENTIFIER 8130

PROCESS Enter, modify, query, delete user organization information.

DEFINITION Capture and maintain valid information on the organization to
which each user belongs,

including a system-generated unique identifier and the name of the
organization.

**C. C-AMIS STANDARD DATA DICTIONARY**

*MODULE* *Property Management*

*DESCRIPTION* *The property management module of C-AMIS supports the
management of aircraft*

*inventory and the facilities required to maintain and house the
aircraft. The module*

*captures agency contact information, the ownership category, the
operational category,*

*and inventory data for each aircraft added to or deleted from the
fleet, and records such*

*additional data as aircraft valuation, primary and secondary mission,
utilization (flight*

*hours), capital improvements, status, and interagency availability. It
records the method*

*of acquisition and disposal for aircraft in the fleet inventory, and
information about*

*modifications and certificates of airworthiness for each aircraft. The
module also captures*

*point of contact information for each facility and the services which
it offers (maintenance,*

*refueling, storage, training, research and development, and other).
Reference information*

*useful in property management, such as comparable life cycle,
operational, contract, and*

*retail aircraft cost data will be captured, and the residual value of
Government aircraft by*

*type and model will be accessed and retrieved from a COTS database. In
addition, the*

*module will capture commercially available and used facility
information such as services*

*available, fees, points of contact, and comparable operational costs.
Module information*

*in the C-AMIS database will be reported and/or displayed to assist the
property manager.*

TABLE ACQ_SOURCE_TYPE

DESCRIPTION Stores the acceptable values for the type of organization
from which the Fleet

aircraft was acquired.

COLUMN TYPE DEFINITION

ACQ_SOURCE_TYPE VARCHAR2(50) Describes the type of organization from
which the aircraft

was acquired.

ACQ_SOURCE_TYPE_DESC VARCHAR2(2000) Description of the acquisition
source type.

ACQ_SOURCE_TYPE_SEQ NUMBER(3) Unique identifier of a acquisition source
type and the

primary key to this table.

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

TABLE ACQUISITION_METHOD

DESCRIPTION Stores the acceptable values for the method used to acquire
the Fleet aircraft.

COLUMN TYPE DEFINITION

ACQ_METH_SEQ NUMBER(3) Unique identifier of an acquisition method and
the primary

key to this table.

ACQ_METHOD_DESC VARCHAR2(2000) Description of the acquisition method.

ACQUISITION_METHOD VARCHAR2(30) Acquisition method used to acquire the
aircraft.

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

TABLE AIRCRAFT_BUREAU_HIST

DESCRIPTION Stores the history of a Fleet aircraft with one (or more)
bureau/office/service(s).

COLUMN TYPE DEFINITION

AC_BUR_END_DATE DATE The ending date when the bureau/office_service has
usage

or costs associated with the aircraft.

AC_BUR_HIST_SEQ NUMBER(8) Unique identifier of an aircraft bureau
history entry and

primary key to this table.

AC_BUR_START_DATE DATE The starting date when the bureau/office/service
has usage

or costs associated with the aircraft.

ACH_UPDATE_NUM NUMBER(3) Used for internal processing only.

AIRCRAFT_SEQ NUMBER(8) Unique identifier of a Fleet aircraft in the
database and

foreign key to the FLEET_AIRCRAFT table.

BUREAU_SEQ NUMBER(5) Unique indentifier of a bureau/office_service and
foreign

key to the BUREAU_OFFICE_SVC table.

DATA_AVAIL_STAT_SEQ NUMBER(2) Unique identifier of data availability
status and foreign key

to the DATA_AVAIL_STAT table.

ENTERED_BY_USER_ID VARCHAR2(30) Userid for the user who entered the data
into the database.

ENTRY_DATE DATE Date the information was stored in the database.

FLTAC_REP_BUR_IND CHAR(1) Indicates (Y/N) if the bureau identified in
the record is the

owner of the inventory data for this aircraft. This field is

populated automatically by the system.

MISSION_SENS_IND CHAR(1) Indicates (Y/N) if the data associated with the
aircraft is

protected.

MODIFIED_BY_USER_ID VARCHAR2(30) Userid of user who last modified the
information.

MODIFIED_DATE DATE Date the information was last modified.

REPORTING_ID VARCHAR2(15) Code that, in combination with the make and
model,

uniquely identifies the aircraft and is used for reporting

purposes. Normally the serial number, but for

mission-sensitive aircraft it is a code assigned by the

agency owning the aircraft.

REVIEWER_COMMENT VARCHAR2(2000) Remarks added by the Agency Designated
Reviewing

Official during the review process.

TABLE AIRCRAFT_C_OF_A

DESCRIPTION Stores the Certificate of Airworthiness (C of A) information
for each Fleet aircraft.

COLUMN TYPE DEFINITION

ACOA_SEQ NUMBER(8) Unique identifier of a Certificate of Airworthiness
record

and primary key to this table.

AIRCRAFT_SEQ NUMBER(8) Unique identifier of an aircraft in the database
and foreign

key to the FLEET_AIRCRAFT table.

C_OF_A_CLASS_SEQ NUMBER(5) Unique identifier of a Certificate of
Airworthiness class and

foreign key to the C_OF_A_CLASS table.

DATA_AVAIL_STAT_SEQ NUMBER(2) Unique identifier of data availability
status and foreign key

to the DATA_AVAIL_STAT table.

EFFECTIVE_DATE DATE The first date on which this entry is valid.

ENTERED_BY_USER_ID VARCHAR2(30) Userid of user who entered the
information into the

database.

ENTRY_DATE DATE Date the information was entered into the database.

EXPIRATION_DATE DATE The last date on which this entry is valid.

MODIFIED_BY_USER_ID VARCHAR2(30) Userid of user who last modified the
information.

MODIFIED_DATE DATE Date the information was last modified.

REVIEWER_COMMENT VARCHAR2(2000) Comments entered by the reviewer of this
record.

TABLE AIRCRAFT_CAPITAL_IMPROVEMENTS

DESCRIPTION Contains information about aircraft capital improvements.

COLUMN TYPE DEFINITION

ACQ_DATE DATE Acquisition date for the capital improvement.

ACQ_VALUE NUMBER(8) Value in dollars of the capital improvement.

AIRCRAFT_SEQ NUMBER(8) Identifier of the aircraft to which the capital
improvement

has been made and foreign key to the FLEET_AIRCRAFT

table. AIRCRAFT_SEQ, IMPROV_NO is the primary key of

this table.

EXEC_AGENCY_SEQ NUMBER(4) Identifier of the executive agency to which
the aircraft

belongs and foreign key to the EXECUTIVE_AGENCY

table.

IMPROV_NO NUMBER(2) Sequential identifier for the capital improvement
assigned

by the system. AIRCRAFT_SEQ, IMPROV_NO is the

primary key of this table.

IMPROVEMENT VARCHAR2(2000) Describes capital improvement.

ORG_CODE VARCHAR2(8) Identifier of the organization which owns the
aircraft and

foreign key to the ORGANIZATION_CODES table.

RESIDUAL_VALUE NUMBER(8) Residual value of the capital improvement.

USEFUL_LIFE NUMBER(2) Useful life of the capital improvement.

TABLE AIRCRAFT_CATEGORY

DESCRIPTION Stores the acceptable values for the type of power with
which a Fleet aircraft is

operating when in flight.

COLUMN TYPE DEFINITION

AIRCRAFT_CAT_DESC VARCHAR2(2000) Description of the aircraft category.

AIRCRAFT_CAT_SEQ NUMBER(3) Unique identifier of an aircraft category and
primary key of

this table.

AIRCRAFT_CATEGORY VARCHAR2(25) Category of aircraft \-- airplane,
helicopter, lighter than air, or

glider.

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

TABLE AIRCRAFT_MOD

DESCRIPTION Stores information on any permanent modification made to a
Fleet aircraft.

COLUMN TYPE DEFINITION

AC_MOD_SEQ NUMBER(8) Unique identifier of the aircraft modification and
primary

key to this table.

AIRCRAFT_SEQ NUMBER(8) Unique identifier of an aircraft in the database
and foreign

key to the FLEET_AIRCRAFT table.

DATA_AVAIL_STAT_SEQ NUMBER(2) Unique identifier of data availability
status and foreign key

to the DATA_AVAIL_STAT table.

ENTERED_BY_USER_ID VARCHAR2(30) Userid of the user who entered the
information into the

database.

ENTRY_DATE DATE Date the information was entered into the database.

MOD_DESCRIPTION VARCHAR2(2000) Describes the permanent modification made
to the airframe

of the aircraft. This excludes modifications needed to make

the aircraft airworthy and special mission equipment not

part of the airframe.

MODIFICATION_COST NUMBER(12) Dollar value of the permanent modification
made to the

airframe of the aircraft. This excludes modifications needed

to make the aircraft airworthy and special mission

equipment not part of the airframe.

MODIFIED_BY_USER_ID VARCHAR2(30) Userid of the user who last modified
the information.

MODIFIED_DATE DATE Date the information was last modified.

REVIEWER_COMMENT VARCHAR2(2000) Comments entered by the reviewer of this
record.

TABLE AIRCRAFT_OWNERS

DESCRIPTION Contains information about aircraft owners.

COLUMN TYPE DEFINITION

COMPANY VARCHAR2(50) If privately owned, the company to which the
aircraft

belongs.

CONTACT_ID NUMBER(7) Identifier of contact person for the aircraft owner
and

foreign key to the CONTACTS table.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier of an executive agency which
owns the

aircraft and foreign key to the EXECUTIVE_AGENCY table.

FED_AGENCY VARCHAR2(1) Indicates (Y/N) if the aircraft is owned by the
Federal

Government.

ORG_CODE VARCHAR2(8) Code which identifies the organization to which the
aircraft

is assigned and foreign key to the

ORGANIZATION_CODES table.

OWNER_ID NUMBER(7) System-generated identifier for an aircraft owner and
the

primary key of this table.

TABLE AIRCRAFT_OWNERSHIP_HISTORY

DESCRIPTION Records information about the ownership history of aircraft.

COLUMN TYPE DEFINITION

ACQ_DATE_TIME DATE Date and time recorded for the acquisition of the
aircraft.

AIRCRAFT_SEQ, ACQ_DATE_TIME is the primary key to

this table.

ACQ_METHOD_SEQ NUMBER(3) Unique identifier of an acquisition method and
foreign key

to the ACQUISITION_METHOD table.

ACQ_VALUE NUMBER(8) Acquisition value of the aircraft in dollars.

AIRCRAFT_SEQ NUMBER(8) Unique identifier of a aircraft in the database
and foreign

key to the FLEET_AIRCRAFT table.

CARGO_HEIGHT NUMBER(4) Height of the cargo space in inches.

CARGO_LENGTH NUMBER(4) Length of the cargo space in inches.

CARGO_WIDTH NUMBER(4) Width of the cargo space in inches.

CONTACT_ID NUMBER(7) Unique identifier of the contact person for the
owned

aircraft and foreign key to the CONTACTS table.

DEL_DATE_TIME DATE Date and time recorded for deletion of the aircraft
from

inventory.

DELETE_METH VARCHAR2(20) The method by which the aircraft was deleted
from

inventory (transfer, exchange, sale, accident, etc.).

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier of an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

HB_CODE VARCHAR2(16) Home base code for the aircraft and foreign key to
the

HOME_BASES table.

HRS_FY NUMBER(4) Flying hours accumulated by the aircraft this fiscal
year.

HRS_LIFE NUMBER(6) Flying hours accumulated by the aircraft in its total
life.

IAG_FLAG CHAR(1) Indicates (Y/N) if the aircraft is available for use by
other

Government agencies.

IFR_CAPABLE CHAR(1) Indicates (Y/N) if aircraft has Instrument Flight
Capability.

MISS_CAT_SEQ NUMBER(4) Unique identifier of a mission category and
foreign key to

the MISSION table. In this case it identifies the primary

mission reason why the aircraft was acquired.

MISS_CAT_SEQ_SEC NUMBER(4) Unique identifier of mission category and
foreign key to the

MISSION table. In this case it represents the secondary

mission reason why the aircraft was acquired.

OP_CAT_SEQ NUMBER(3) Unique identifier of an operational category and
foreign key

to the OPERATIONAL_CATEGORY table.

ORG_CODE VARCHAR2(8) Code for the organization to which the aircraft
belongs and

foreign key to the ORGANIZATION_CODES table.

OWN_CAT_SEQ NUMBER(3) Unique identifier of an ownership category and
foreign key

to the OWNERSHIP_CATEGORY table.

PASS_CONFIG NUMBER(3) Maximum passenger seating capacity for the
configuration

of the aircraft.

PAYLOAD_LBS NUMBER(7) The difference between the aircraft\'s equipped
weight and

the maximum allowable gross weight.

RATE_HR NUMBER(8) Cost of flying the aircraft on a per hour basis.

RECIP_OWN_ID NUMBER(7) Unique identifier of the ownership recipient of
the aircraft

and foreign key to the AIRCRAFT_OWNERS table.

REGISTRATION_NO VARCHAR2(15) Registration mark or \"tail number\"
(usually numbers and

letters) displayed on Government aircraft \-- including

foreign aircraft hired as CAS.

RESID_VALUE NUMBER(8) Estimated dollar value of the aircraft at the
conclusion of its

useful life.

SERV_DATE_TIME DATE Date and time the aircraft was put into service.

SOURCE_OWN_ID NUMBER(7) Identifier of the ownership source of the
aircraft and foreign

key to the AIRCRAFT_OWNERS table.

USEFUL_LIFE NUMBER(2) Useful life of the aircraft in years.

TABLE AIRFIELD_LOCATIONS

DESCRIPTION Contains the ICAO or other agency-assigned code and other
information about

airfield locations.

COLUMN TYPE DEFINITION

AIRFIELD_CODE VARCHAR2(4) ICAO or other code established by an agency to
identify

the point of origin or destination for an aircraft.

AIRFIELD_CODE is the primary key of this table.

AIRFIELD_NAME VARCHAR2(50) Name of airfield associated with the
AIRFIELD_CODE.

CITY VARCHAR2(20) Name of the city associated with the location.

COUNTRY VARCHAR2(15) Identifies the country where the airfield is
located.

ELEVATION NUMBER(8) Elevation above sea level in feet for the airfield
location.

FAVORITE CHAR(1) Indicates (Y/N) if user has selected the location as
\"one of

my favorites.\"

GMT_OFFSET NUMBER(8) GMT offset for the airfield location. GMT is the
number of

hours from Greenwich Mean Time.

LAT_DECIMAL VARCHAR2(12) Latitude of the airfield expressed as a
decimal.

LAT_DEGREES NUMBER(8) Degrees of latitude for the airfield location.

LAT_MINUTES NUMBER(8) Minutes of latitude for the airfield location.

LONG_DECIMAL VARCHAR2(12) Longitude of the airfield expressed as a
decimal.

LONG_DEGREES NUMBER(8) Degrees of longitude for the airfield location.

LONG_MINS NUMBER(8) Minutes of longitude for the airfield location.

METRO_AREA VARCHAR2(20) Identifier of the metropolitan area where the
airfield is

located and foreign key to the METROPOLITAN_AREAS

table.

OFFICIAL_ICAO CHAR(1) Indicates (Y/N) if AIRFIELD_CODE is an official
ICAO

code.

RANK NUMBER(2) For favorite locations specifies position in the top 100.

REGION VARCHAR2(4) Identifier of the regional area where the airfield is
located

and foreign key to the REGIONAL_AREAS table.

STATE_PROV VARCHAR2(5) Code for the state or province associated with
the location

and foreign key to the STATE_CODES table.

TABLE BUREAU_OFFICE_SVC

DESCRIPTION Stores the acceptable values for the subunits within each
executive agency.

COLUMN TYPE DEFINITION

ALLOW_SECURE_AC_IND CHAR(1) Indicates (Y/N) if this
bureau/office/service can specify that

an aircraft is a secure aircraft.

BUREAU_OFFICE_SVC VARCHAR2(60) Identifies the subunit designator within
the executive

agency.

BUREAU_SEQ NUMBER(5) Unique identifier for a bureau/office/service and
primary

key to this table.

DATA_QTRS_ALLOWED NUMBER(2) Number of calendar quarters for which this
agency is

allowed to report data.

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

EXPIRATION_DATE DATE The last date on which this entry is valid.

POST_DISP_QTRS_ALOWD NUMBER(2) Number of calendar quarters for which an
agency/bureau is

allowed to report data for a disposed aircraft.

REPT_FOR_OTHERS_IND CHAR(1) Indicates (Y/N) if this
bureau/office/service can report for

other bureau/office/services.

TABLE C_OF_A_CLASS

DESCRIPTION Stores the acceptable values for the C of A classes within C
of A types that a

Fleet aircraft may have.

COLUMN TYPE DEFINITION

C_OF_A_CLASS VARCHAR2(30) Class of airworthiness for an aircraft.

C_OF_A_CLASS_DESC VARCHAR2(2000) Description of a Certificate of
Airworthiness class.

C_OF_A_CLASS_SEQ NUMBER(5) Unique identifier of a Certificate of
Airworthiness class and

primary key to this table.

C_OF_A_TYPE_SEQ NUMBER(3) Unique identifier of a Certificate of
Airworthiness type and

foreign key to the C_OF_A_TYPE table.

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last day on which this entry is valid.

TABLE C_OF_A_TYPE

DESCRIPTION Stores the acceptable values for the types of C of A that a
Fleet aircraft may have.

COLUMN TYPE DEFINITION

C_OF_A_TYPE VARCHAR2(20) Type of Certificate of Airworthiness held by
the aircraft.

C_OF_A_TYPE_DESC VARCHAR2(2000) Description of Certificate of
Airworthiness type.

C_OF_A_TYPE_SEQ NUMBER(3) Unique identifier of a Certificate of
Airworthiness type and

primary key to this table.

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

TABLE CONGRESS_DISTRICT

DESCRIPTION Stores the acceptable values for Congressional districts in
the United States.

COLUMN TYPE DEFINITION

CONG_ADDRESS VARCHAR2(256) Address of the Congressional office building
for the

member of Congress.

CONG_PHONE_NUMBER VARCHAR2(13) The telephone number, including area
code, for the

Washington, D.C. office of the Congressional

representative.

CONGRESS_DISTRICT VARCHAR2(2) Two digit code of the Congressional
district and primary

key of this table.

CONGRESS_FIRST VARCHAR2(15) First name of the member of Congress who
represents the

district.

CONGRESS_LAST VARCHAR2(15) Last name of the member of Congress who
represents the

district.

POLITICAL_PARTY CHAR(1) Party affiliation of the member of Congress.

STATE_ABBREVIATION VARCHAR2(2) Two character abbreviation of the state
where the

Congressional district is located.

TABLE CONTACTS

DESCRIPTION Contains information about contact persons.

COLUMN TYPE DEFINITION

ADDRESS1 VARCHAR2(30) First line of primary address for contact person.

ADDRESS2 VARCHAR2(30) Second line of primary address for contact person.

CITY VARCHAR2(18) Primary address city for contact person.

CONTACT_ID NUMBER(7) Unique identifier for the contact person and
primary key to

this table.

CONTACT_TYPE VARCHAR2(15) Specifies type of contact (aircraft, facility,
etc.).

COUNTRY VARCHAR2(20) Primary address country for contact person.

COURIER_ADD1 VARCHAR2(30) First line of courier address for contact
person.

COURIER_ADD2 VARCHAR2(30) Second line of courier address for contact
person.

COURIER_CITY VARCHAR2(18) Courier address city for contact person.

COURIER_CNTRY VARCHAR2(20) Courier address country for contact person.

COURIER_STATE VARCHAR2(2) Courier address state code for contact person.

COURIER_ZIP VARCHAR2(9) Courier address zip code for contact person.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier of an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

FAX VARCHAR2(20) Fax number of contact person.

NAME_FIRST VARCHAR2(12) First name of contact person.

NAME_LAST VARCHAR2(18) Last name of contact person.

ORG_CODE VARCHAR2(8) Organization of the contact person.
EXEC_AGENCY_SEQ,

ORG_CODE is the concatenated foreign key to the

ORGANIZATION_CODES table.

PHONE VARCHAR2(20) Phone number of contact person.

STATE VARCHAR2(2) Primary address state code for contact person.

TITLE VARCHAR2(20) Title of contact person.

ZIP VARCHAR2(9) Primary address zip code for contact person.

TABLE DATA_AVAIL_STAT

DESCRIPTION Stores the acceptable values for data availability status.

COLUMN TYPE DEFINITION

DATA_AVAIL_STAT_DESC VARCHAR2(2000) Describes the data availability
status.

DATA_AVAIL_STAT_SEQ NUMBER(2) Unique identifier of the data availability
status and primary

key of this table.

DATA_AVAIL_STATUS VARCHAR2(40) Categorizes the availability of inventory
and cost data to

support the possibility of allowing users to review data in

the joint agency database prior to displaying the data in

reports.

TABLE DISP_RECIPIENT_TYPE

DESCRIPTION Stores the acceptable values for types of disposal
recipients for a Fleet aircraft.

COLUMN TYPE DEFINITION

DISP_RECIP_TYPE VARCHAR2(30 Name of the disposal recipient type
accepting title to the

Fleet aircraft from the owning agency.

DISP_RECIP_TYPE_DESC VARCHAR2(2000) Description of the disposal
recipient type.

DISP_RECIP_TYPE_SEQ NUMBER(3) Unique identifier of a disposal recipient
type and primary

key of this table.

EXPIRATION_DATE DATE The last date on which this entry is valid.

TABLE DISPOSAL_METHOD

DESCRIPTION Stores the acceptable values of the ways that a Fleet
aircraft can be disposed of.

COLUMN TYPE DEFINITION

DISPOSAL_METHOD VARCHAR2(30) Transaction method used to dispose of the
aircraft.

DISPOSAL_METHOD_DESC VARCHAR2(2000) Description of the disposal method.

DISPOSAL_METHOD_SEQ NUMBER(4) Unique identifier of the disposal method
and primary key of

this table.

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

INTRA_GOV_TRANS_IND CHAR(1) Indicates if the disposal method is a
transfer between two

agencies (A) or two bureaus within an executive agency

(B).

TABLE ERROR_HOLD

DESCRIPTION Holds the explanation for every error which occurs during
the loading process of

the data sent by the agencies via batch transfer.

COLUMN TYPE DEFINITION

DATA_ROW_IN_ERROR VARCHAR2(2000) Complete record of the input data that
are in error.

ERROR_CODE NUMBER(20) Numeric identifier of a specific error.

ERROR_SEQ NUMBER(5) Unique identifier of a batch load transfer of data
and

primary key of this table.

ERROR_TEXT VARCHAR2(2000) Description of a specific error.

MESSAGE_SENT_IND CHAR(1) Indicates (Y/N) if a message was sent to the
user who

submitted the batch file.

RECEIVED_DATE DATE Date the batch input process detected the error.

USERID VARCHAR2(30) Userid of the user who submitted the batch file.

TABLE EXECUTIVE_AGENCY

DESCRIPTION Stores the acceptable values for the department, agency, or
independent

establishment in the executive branch.

COLUMN TYPE DEFINITION

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier of an executive agency and
primary key to

this table.

EXECUTIVE_AGENCY VARCHAR2(60) Identifies any executive department or
independent

establishment in the executive branch of the Government,

including any wholly-owned Government corporation.

EXPIRATION_DATE DATE The last date on which this entry is valid.

TABLE FACILITIES

DESCRIPTION Contains information about Government owned and/or operated
facilities.

COLUMN TYPE DEFINITION

AGREEMENT_ID NUMBER(7) Identifier for the agreement (if any) under which
the facility

is provided, and an optional foreign key to the

AGREEMENTS_AND_CONTRACTS table.

CONTACT_ID NUMBER(7) Unique identifer of the contact person for the
facility and

foreign key to the CONTACTS table.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifer of an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

FACILITY_CODE CHAR(10) Code which identifies the facility. EXEC\_
AGENCY_SEQ,

ORGANIZATION_CODE, FACILITY_CODE is the primary

key to this table.

FACILITY_NAME VARCHAR2(40) Name of the facility.

ORG_CODE VARCHAR2(8) Code which identifies the organization to which the
facility

belongs. EXEC_AGENCY_SEQ, ORG_CODE is the

concatenated foreign key to the ORGANIZATION_CODES

table.

TABLE FACILITY_SERVICE_TYPES

DESCRIPTION Defines the types of services available from Government
owned and/or operated

facilities.

COLUMN TYPE DEFINITION

SERVICE_TYPE VARCHAR2(20) Defines the types of service available through
the facility.

SERVICE_TYPE is the primary key of this table.

TABLE FACILITY_SERVICES

DESCRIPTION Contains information about maintenance, research and
development, refueling,

storage, training, and other services available from Government owned
and/or

operated facilities.

COLUMN TYPE DEFINITION

CONTACT_ID NUMBER(7) Identifier of the facility contact person for the
service and

foreign key to the CONTACTS table.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifer of an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

FACILITY_ID VARCHAR2(10) Identifier of the facility. EXEC_AGENCY_SEQ,

ORG_CODE, FACILITY_CODE is the concatenated foreign

key to the FACILITIES table.

IAG_FLAG CHAR(1) Indicates (Y/N) if the facility provides the service to
other

Government agencies.

ORG_CODE VARCHAR2(8) Code which identifies the organization to which the
facility

belongs. EXEC_AGENCY_SEQ, ORG_CODE is the

concatenated foreign key to the ORGANIZATION_CODES

table.

SERVICE_DESC VARCHAR2(2000) Description of the service available.

SERVICE_TYPE VARCHAR2(20) Identifies each type of service available
through the facility:

maintenance, research and development, refueling, storage,

training, and other. EXEC_AGENCY_SEQ,

ORGANIZATION_CODE, FACILITY_CODE,

SERVICE_TYPE is the primary key of this table.

SPEC_COND VARCHAR2(2000) Details special conditions which apply to
interagency use.

TABLE FLEET_AIRCRAFT

DESCRIPTION Stores the basic nformation on every aircraft in the Fleet.

COLUMN TYPE DEFINITION

ACQ_METHOD_SEQ NUMBER(3) Unique identifier of an acquisition method and
foreign key

to the ACQUISITION_METHOD table.

ACQ_SOURCE_TYPE_SEQ NUMBER(3) Unique identifier of an acquisition source
type and foreign

key to the ACQ_SOURCE_TYPE table.

ACQUISITION_DATE DATE Date the acquiring agency took responsibility for
the

aircraft (e.g., received title, signed lease/purchase

agreement, signed a bailment agreement, accepted physical

transfer, or signed an SF 122).

ACQUISITION_VALUE NUMBER(10) Value initially recorded on agency property
records and/or

accounting records at the time of acquisition.

AIRCRAFT_COMMENT VARCHAR2(2000) Relevant or clarifying remarks
concerning the aircraft

information.

AIRCRAFT_SEQ NUMBER(8) Unique identifier of an aircraft in the database
and primary

key to this table.

CITY_NAME VARCHAR2(28) Name of the city from which the aircraft is
normally

operated and/or scheduled.

DATA_AVAIL_STAT_SEQ NUMBER(2) Unique identifier of data availability
status and foreign key

to the DATA_AVAIL_STAT table.

DISP_RECIP_TYPE_SEQ NUMBER(3) Unique identifier of a disposal recipient
type and foreign

key to the DISP_RECIPIENT_TYPE table.

DISPOSAL_DATE DATE Date when the Bureau/Office/Service within an
executive

agency transferred title or otherwise disposed of the

aircraft.

DISPOSAL_METH_SEQ NUMBER(4) Unique identifier of a disposal method and
foreign key to

the DISP_METHOD table.

DISPOSAL_RECIPIENT VARCHAR2(30) Name of the organization, company, or
individual that is

acceptiing title to the aircraft from the owning agency.

ENTERED_BY_USER_ID VARCHAR2(30) Id of the user who entered the
information into the

database.

ENTRY_DATE DATE Date the information was entered into the database.

FOREIGN_LOCATION VARCHAR2(256) Identifies the foreign home base location
of an aircraft.

MISSION_CAT_SEQ NUMBER(4) Unique identifier of mission category and
foreign key to the

MISSION_CATEGORY table.

MISSION_CAT_SEQ_SEC NUMBER(4) Unique identifier of mission category and
foreign key to the

MISSION_CATEGORY table. In this case it represents the

secondary misson reason why an aircraft was acquired.

MISSION_SENS_IND CHAR(1) Indicates (Y/N) if data associated wiith the
aircraft is

protected.

MODEL_SEQ NUMBER(5) Unique identifier of a model of any aircraft and
foreign key

to the MODEL_OF_AIRCRAFT table.

MODIFIED_BY_USER_ID VARCHAR2(30) Id of user who last modified the
information.

MODIFIED_DATE DATE Date the information was last modified.

OP_CAT_SEQ NUMBER(3) Unique identifier of an operational category and
foreign key

to the OPERATIONAL_CATEGORY table.

OWN_CAT_SEQ NUMBER(3) Unique identifier of an ownership category and
foreign key

to the OWNERSHIP_CATEGORY table.

REGISTRATION_NUMBER VARCHAR2(9) Unique identification mark or \"tail
number\" (usually

numbers and letters) displayed on Government aircraft \--

including foreign aircraft hired as CAS.

REPORTING_EXEMP_IND CHAR(1) Indicates (Y/N) if an agency has to report
costs associated

with a specific aircraft in the Fleet.

REPORTING_ID VARCHAR2(15) Code that, in combination with the make and
model,

uniquely identifies the aircraft, and is used for reporting

purposes. Normally a serial number, but for a mission-

sensitive aircraft it is a code assigned by the agency

owning the aircraft.

REVIEWER_COMMENT VARCHAR2(2000) Comments by the reviewer of this record.

SERIAL_NUMBER VARCHAR2(15) Serial number assigned to the aircraft by the
original

equipment manufacturer \-- as designated on the aircraft

dataplate.

STATE_ABBREVIATION VARCHAR2(2) Code for the state from which the
aircraft is normally

operated and/or scheduled.

YEAR_MANUFACTURED NUMBER(4) Year the aircraft was manufactured.

ZIP_CODE NUMBER(10) Zip code of the location from which the aircraft is
normally

operated and/or scheduled.

TABLE HOME_BASE_CHANGES

DESCRIPTION Contains information about home base changes for an
aircraft.

COLUMN TYPE DEFINITION

CHANGE_DATE DATE Date and time of the home base change.

HB_CHANGE_ID NUMBER(4) Unique identifier for the home base change and
primary key

of this table.

NEW_HOME_BASE VARCHAR2(16) Code which identifies the new home base and
foreign key

to the HOME_BASES table.

OLD_HOME_BASE VARCHAR2(16) Code which identifies the old home base and
foreign key to

the HOME_BASES table.

REGISTRATION_NUMBER VARCHAR2(15) Identification mark or \"tail number\"
(usually numbers and

letters) displayed on Government aircraft \-- including

foreign aircraft hired as CAS.

TABLE HOME_BASES

DESCRIPTION Contains information about home bases (airfield locations)
for aircraft.

COLUMN TYPE DEFINITION

HB_CITY VARCHAR2(25) Home base city for the aircraft.

HB_CODE VARCHAR2(16) Code which identifies the home base for the
aircraft and

primary key to this table.

HB_NAME VARCHAR2(40) Name of the home base for the aircraft.

HB_STATE VARCHAR2(2) Abbreviation of the home base state.

TABLE MANUFACTURER

DESCRIPTION Stores the list of acceptable values for aircraft
manufacturers.

COLUMN TYPE DEFINITION

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

MANUFACTURER VARCHAR2(50) The original manufacturer of the aircraft as
designated on

the aircraft dataplate.

MANUFACTURER_SEQ NUMBER(4) Unique identifier of the manufacturer and
primary key of

this table.

TABLE METROPOLITAN_AREAS

DESCRIPTION Specifies metropolitan areas associated with airfield
locations.

COLUMN TYPE DEFINITION

METRO_AREA VARCHAR2(20) Name of the metropolitan area and primary key of
this table.

TABLE MISSION

DESCRIPTION Stores the list of acceptable values for aircraft missions.

COLUMN TYPE DEFINITION

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

MISSION VARCHAR2(65) Principal purpose for which the aircraft was
dispatched.

MISSION_CAT_SEQ NUMBER(4) Unique identifier of a mission category and
foreign key to

the MISSION_CATEGORY table.

MISSION_DESC VARCHAR2(2000) Description of the mission.

MISSION_SEQ NUMBER(5) Unique identifier of a mission and primary key to
this table.

TABLE MISSION_CATEGORY

DESCRIPTION Stores the list of acceptable values for the groupings of
missions.

COLUMN TYPE DEFINITION

EFFECTIVE_DATE DATE The first date on which this entry is valid.

MISSION_CAT_DESC VARCHAR2(2000) Description of the mission category.

MISSION_CAT_SEQ NUMBER(4) Unique identifier of the mission category.

MISSION_CATEGORY VARCHAR2(65) High level grouping of missions.

TABLE MISSION_HOURS

DESCRIPTION Stores the hours flown information for the utilization of
Federal aircraft.

COLUMN TYPE DEFINITION

BLOCK_TO_BLOCK_TIME NUMBER(5,1) Total elapsed flight time, expressed in
hours and tenths of

an hour, from when the aircraft begins to move under its

own power until it comes to a rest and shuts down after

completion of the flight.

HOURS_FLOWN NUMBER(5,1) Amount of time, expressed in hours and tenths of
an hour,

from when the aircraft leaves the ground until the time it

touches down again.

MISSION_SEQ NUMBER(5) Unique identifier of the mission.

RPTPD_SEQ NUMBER(8) Unique identifier for a reported period of cost and
hours

data for an aircraft.

TABLE MODEL_OF_AIRCRAFT

DESCRIPTION Stores the list of acceptable values for the aircraft models
within each

manufacturer.

COLUMN TYPE DEFINITION

AIRCRAFT_CAT_SEQ NUMBER(3) Unique identifier of an aircraft category and
foreign key to

the AIRCRAFT_CATEGORY table.

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

MANUFACTURER_SEQ NUMBER(4) Unique identifier of the manufacturer of the
aircraft and

foreign key to the MANUFACTURER table..

MODEL_OF_AIRCRAFT VARCHAR2(30) Identifies the model number of the
aircraft as designated on

the aircraft dataplate.

MODEL_SEQ NUMBER(5) Unique identifier of the model of the aircraft and
primary

key to this table.

POWER_PLANT_SEQ NUMBER(3) Unique identifier of the propulsion type of
the aircraft and

foreign key to the POWERPLANT table.

SINGLE_MULTI_ENG_SEQ NUMBER(3) Unique identifier of the single / multi-
engine type for the

aircraft and foreign key to the SINGLE_MULTI_ENGINE

table.

TABLE OPERATIONAL_CATEGORY

DESCRIPTION Stores the list of acceptable values for the current
operational status of the

aircraft.

COLUMN TYPE DEFINITION

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

OP_CAT_SEQ NUMBER(3) Unique identifier of the operational category and
primary

key to this table.

OPERATIONAL_CAT_DESC VARCHAR2(2000) Description of the operational
category.

OPERATIONAL_CATEGORY VARCHAR2(35) Describes the current status of the
aircraft.

TABLE ORGANIZATION_CODES

DESCRIPTION Contains the agency and organization codes which uniquely
identify each

bureau/office/service.

COLUMN TYPE DEFINITION

ADDRESS1 VARCHAR2(35) First line of the address for the organization.

ADDRESS2 VARCHAR2(35) Second line of the address for the organization.

CITY VARCHAR2(35) City where the organization is located.

EXEC_AGENCY_SEQ NUMBER(4) Code identifying the executive agency to which
the

organization belongs and foreign key to the

EXECUTIVE_AGENCY table. The primary key to this table

is E XECUTIVE_AGENCY_SEQ, ORG_CODE.

FAX VARCHAR2(14) Fax number for the organization.

ORG_ABBR VARCHAR2(10) Abbreviation for the organization.

ORG_CODE VARCHAR2(8) Code which identifies an organization.

ORG_NAME VARCHAR2(35) Name of the organization.

STATE VARCHAR2(2) State where the organization is located.

TELEPHONE VARCHAR2(14) Telephone number for the organization.

ZIP_CODE VARCHAR2(10) Zip code for the organization.

TABLE POWERPLANT

DESCRIPTION Stores the acceptable values for the types of propulsion
systems on Fleet aircraft.

COLUMN TYPE DEFINITION

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

POWER_PLANT VARCHAR2(20) Name of the aircraft propulsion system.

POWER_PLANT_DESC VARCHAR2(2000) Description of the propulsion system(s)
on the aircraft.

POWER_PLANT_SEQ NUMBER(3) Unique identifier of the propulsion system(s)
on the

aircraft.

TABLE REGIONAL_AREAS

DESCRIPTION Specifies regional areas associated with airfield locations.

COLUMN TYPE DEFINITION

REGION CHAR(20) Name of the regional area and primary key to this table.

TABLE RESIDUAL_VALUE

DESCRIPTION Stores the Aircraft Bluebook Residual Value data.

COLUMN TYPE DEFINITION

AVERAGE_EQUIPPED VARCHAR2(10) Sticker price of the aircraft plus options
when new.

AVERAGE_RETAIL VARCHAR2(10) Used price for the aircraft when published.

FACTORY_STANDARD NUMBER(10) Sticker price of the aircraft when new.

HIGH_WHOLESALE NUMBER(10) High wholesale to dealer price for the
aircraft.

HIGH_WHOLESALE_CHG NUMBER(9) Change in high wholesale price for the
aircraft since last

report.

LOW_WHOLESALE NUMBER(10) Low wholesale to dealer price for the aircraft.

LOW_WHOLESALE_CHANGE NUMBER(9) Change in low wholesale price for the
aircraft since last

report.

MANUFACTURER VARCHAR2(60) Name of the manufacturer.

MODEL_ID NUMBER(10) ID number for the model.

MODEL_NAME VARCHAR2(35) Name of the aircraft model.

MODEL_YEAR VARCHAR2(4) Year of the aircraft model.

PUBLICATION_QTR VARCHAR2(1) Identifies the publication quarter for the
residual value data.

PUBLICATION_YEAR VARCHAR2(4) Identifies the publication year for the
residual value data.

SERIAL_NUMBER VARCHAR2(100) Factory assigned serial number for the
aircraft.

THRU_YEAR VARCHAR2(4) Used when multiple year models appear on one line.

TABLE SINGLE_MULTI_ENGINE

DESCRIPTION Stores the acceptable values for the type of power on a
Fleet aircraft.

COLUMN TYPE DEFINITION

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

SINGL_MULTI_ENG_SEQ NUMBER(3) Unique identifer of the
single/multi-engine type and primary

key to this table.

SINGLE_MULTI_ENG_DSC VARCHAR2(2000) Description of the single or
multi-engine type.

SINGLE_MULTI_ENGINE VARCHAR2(20) Name of the single or multi-engine
type.

TABLE SPECIAL_EQUIPMENT_INVENTORY

DESCRIPTION Contains information about special equipment installed on
specific aircraft.

COLUMN TYPE DEFINITION

AIRCRAFT_SEQ NUMBER(8) Identifier of the aircraft and foreign key to the

FLEET_AIRCRAFT table.

ASSET_NO CHAR(50) Asset number assigned to the special equipment.

EQUIP_COST NUMBER(7,2) Cost of the special equipment.

EQUIP_DESC CHAR(50) Description of the special equipment.

EQUIPMENT_ID NUMBER(7) Unique identifier for a special equipment item.

AIRCRAFT_SEQ, EQUIPMENT_ID is the primary key of

this table.

MODEL_NO CHAR(50) Manufacturer-assigned model number for the special

equipment.

PURCH_DATE DATE Date the special equipment was purchased.

REGIS_NO VARCHAR2(9) Unique identification mark or \"tail number\"
(usually

numbers and letters) displayed on Government aircraft \--

including foreign aircraft hired as CAS.

SERIAL_NO VARCHAR2(15) Manufacturer-assigned serial number for the
special

equipment.

STOR_BIN_LOC VARCHAR2(50) Location of the bin in which the special
equipment is

stored.

STORAGE_LOC VARCHAR2(20) Storage location for the special equipment.

TABLE SPECIAL_EQUIPMENT_MODS_HIST

DESCRIPTION Contains information about the history of modifications to
specific aircraft.

COLUMN TYPE DEFINITION

AIRCRAFT_SEQ NUMBER(8) Identifier of the aircraft on which the special
equipment was

installed or deinstalled and foreign key to the

FLEET_AIRCRAFT table.

ASSET_NO VARCHAR2(50) Asset number assigned to the special equipment.

DEINST_DATE DATE Time and date the special equipment was deinstalled.

EQUIP_MOD_NO NUMBER(3) Modification number sequentially assigned for the
special

equipment by the system. EQUIPMENT_ID,

EQUIP_MOD_NO is the primary key to this table.

EQUIPMENT_ID NUMBER(7) Unique identifier for the special equipment. The
primary

key to this table is EQUIPMENT_ID, EQUIP_MOD_NO.

INSTALL_DATE DATE Time and date the special equipment was installed.

REGIS_NO VARCHAR2(9) Unique identification mark or \"tail number\"
(usually

numbers and letters) displayed on Government aircraft \--

including foreign aircraft hired as CAS.

TABLE STATE_CODES

DESCRIPTION Stores the acceptable values for the states where the Fleet
aircraft is normally

operated and/or scheduled.

COLUMN TYPE DEFINITION

FIPS_CODE NUMBER(2) Two-digit code assigned by the Federal Government to

each of the 50 states and various territories.

STATE_ABBREV VARCHAR2(2) Two-character state abbreviation.

STATE_PROV VARCHAR2(35) Name of state or province where the aircraft is
normally

operated and/or scheduled.

TABLE STORAGE_LOCATIONS

DESCRIPTION Contains codes and descriptions of storage locations by home
base.

COLUMN TYPE DEFINITION

HB_CODE VARCHAR2(16) Code which identifies a home base and foreign key
to the

HOME_BASES table. HB_CODE, STOR_LOC is the

primary key of this table.

STOR_LOC VARCHAR2(20) Code which identifies a storage location for a
home base.

HB_CODE, STOR_LOC is the primary key of this table.

STOR_LOC_DESC VARCHAR2(50) Description of the storage location.

TABLE TRANSACTION_METHODS

DESCRIPTION Contains the transaction methods used in acquiring or
disposing of an aircraft.

COLUMN TYPE DEFINITION

TRANS_METHOD VARCHAR2(20) Defines the method of acquisition or disposal
for an

aircraft.

TABLE ZIP_CODE

DESCRIPTION Stores the acceptable zip code values associated with
locations from which a Fleet

aircraft is normally operated and/or scheduled.

COLUMN TYPE DEFINITION

AREA_CODE VARCHAR2(3) The most prevalent area code for the zip code.

CITY_NAME VARCHAR2(28) City from which the aircraft is normally operated
and/or

scheduled.

CONGRESS_DIST VARCHAR2(2) Two digit code for the Congressional district
associated

with the zip code.

COUNTY_FIPS VARCHAR2(5) Five digit code for the most prevalent county
associated

with the zip code.

COUNTY_NAME VARCHAR2(25) Name of the most prevalent county associated
with the zip

code.

DAYLIGHT_SVGS_IND CHAR(1) Indicates (Y/N) if Daylight Savings time is
observed in the

zip code area.

LATITUDE VARCHAR2(9) Latitude of the zip code.

LONGITUDE VARCHAR2(9) Longitude of the zip code.

MSA VARCHAR2(4) Code for the metropolitan statistical area.

PMSA VARCHAR2(4) Code for the primary metropolitan statistical area.

PREF_CITY_NAME_FLAG CHAR(1) Indicates (Y/N) if this is the preferred
city name for delivery

of mail to the associated zip code.

STATE_ABBREVIATION VARCHAR2(2) Two character code for the state from
which the aircraft is

normally operated and/or scheduled.

TIME_ZONE VARCHAR2(5) Standard time zone designation for the zip code.

ZIP_CODE VARCHAR2(10) Zip code of the location from which the aircraft
is normally

operated and/or scheduled.

*MODULE* *Finance and Accounting*

*DESCRIPTION* *The finance and accounting module of C-AMIS captures
aircraft utilization, and variable*

*and fixed cost information, including costs for crews and leases,
landing and tie down,*

*maintenance, hull and liability self-insurance, operation and
administration overhead,*

*capital, and depreciation costs. The module provides a data entry
capability using the*

*standard accounts proposed in the GSA Cost Accounting Guide (CAG), but
also allows the*

*CAG accounts to be cross-referenced to user-entered local accounts. The
module*

*facilitates the management of aircraft on a fleet basis as well as by
individual tail number;*

*fleet costs may be distributed to individual tail numbers, and annual
costs allocated to*

*monthly periods. The module calculates the annual summary costs, fixed
cost per hour,*

*and variable cost per hour for each aircraft and aircraft type, and
generates the annual*

*report on aircraft costs for Government operated aircraft. It also
provides the capability to*

*monitor and report on the financial aspects of Senior Federal/Special
Category Travel.*

*The module computes actual vs. projected expenditures for each aircraft
operation, and*

*accounts for purchases of bulk fuel. In addition, the module will
compute life cycle costs*

*by aircraft type, and summarize aviation operations by OMB object class
codes. Module*

*information in the C-AMIS database will be reported and/or displayed to
assist the finance*

*and accounting managers.*

TABLE ACCOUNT_TYPES

DESCRIPTION Contains account type and description.

COLUMN TYPE DEFINITION

ACCOUNT_TYPE VARCHAR2(2) Code which identifies the type of account and
primary key

to this table.

TYPE_DESC VARCHAR2(30) Description of the type of account.

TABLE AGENCY_COST_CODES

DESCRIPTION Contains agency cost codes and descriptions.

COLUMN TYPE DEFINITION

AG_COST_CODE VARCHAR2(10) Unique identifier of an agency cost account
and primary

key of this table.

AG_COST_DESC VARCHAR2(40) Description of the agency cost account.

TABLE AIRCRAFT_COST_AND_UTILIZATION

DESCRIPTION Contains aircraft cost and utilization information by
agency, organization,

agreement, and aircraft.

COLUMN TYPE DEFINITION

AGREEMENT_ID NUMBER(7) Identifier of an agreement or contract and
foreign key to the

AGREEMENTS_AND_CONTRACTS table.

AIRCRAFT_SEQ NUMBER(8) Unique identifier of the aircraft and foreign key
to the

FLEET_AIRCRAFT table.

COMM_COST NUMBER(8) Total commercial cost of the aircraft.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for an executive agency and
foreign key to

the EXECUTIVE_AGENCY table. EXEC_AGENCY_SEQ,

ORG_CODE, AGREEMENT_ID, and AIRCRAFT_ID make

up the primary key to this table.

HRS_FLOWN NUMBER(8) Total hours flown for the aircraft.

INHOUSE_COST NUMBER(8) Total in house cost of the aircraft.

ORG_CODE VARCHAR2(8) Code which identifies the organization and foreign
key to

the ORGANIZATION_CODES table.

TABLE AIRCRAFT_COST_SUMMARY_CODES

DESCRIPTION Contains aircraft cost summary codes and descriptions.

COLUMN TYPE DEFINITION

COST_SUM_DESC VARCHAR2(80) Describes the cost summary category.

SUM_CODE NUMBER(4) Unique identifier of the aircraft cost summary
category and

primary key to this table.

TABLE AIRCRAFT_SUPPORT_SERVICES_COST

DESCRIPTION Contains aircraft support services information by agency,
organization, aircraft,

and agreement.

COLUMN TYPE DEFINITION

AGREEMENT_ID NUMBER(7) Identifier of the agreement or contract and
foreign key to

the AGREEMENTS_AND_CONTRACTS table.

AIRCRAFT_SEQ NUMBER(8) Unique identifier of the aircraft and foreign key
to the

FLEET_AIRCRAFT table.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier of an executive agency and
foreign key to

the EXECUTIVE_AGENCY table. EXEC_AGENCY_SEQ,

ORG_CODE, AGREEMENT_ID, and AIRCRAFT_SEQ

make up the primary key to this table.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau and
foreign

key to the ORGANIZATION_CODES table.

SERV_COST NUMBER(8) Total support services cost.

SERV_DESC CHAR(2000) Description of services provided.

TABLE ALLOCABLE_COSTS

DESCRIPTION Contains allocated cost information by agency, organization,
CAG code, object

class, local accounting code, life cycle analysis code, aircraft,
flight, and flight leg

COLUMN TYPE DEFINITION

AIRCRAFT_SEQ NUMBER(8) Unique identifier for an aircraft and foreign key
to the

FLEET_AIRCRAFT table.

ALLOCATE CHAR(1) Allocate as variable cost on the basis of C = Crew, A =

Aircraft Hours, or N = Don\'t Allocate.

ASSET_NO VARCHAR2(15) Asset number associated with the transaction.

CAG_CODE CHAR(6) Code which identifies the CAG account associated with
the

transaction. Foreign key to the CAG_CODES table.

COST_TYPE CHAR(1) Identifies the type of cost represented by the
transaction as

F (fixed), V (variable), or N (neither).

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

FLIGHT_ID NUMBER(7) Identifier for the aircraft flight and foreign key
to the

FLIGHTS table.

FLIGHT_LEG_ID NUMBER(7) Identifier for the flight leg and with FLIGHT_ID
the foreign

key to the FLIGHT_LEGS table.

FLIGHT_NO VARCHAR2(15) Flight number associated with the transaction.

LC_CODE VARCHAR2(6) Life cycle analysis code which applies to this
transaction

and foreign key to the LIFE_CYCLE_ANALYSIS_CODES

table.

LOCAL_CODE VARCHAR2(6) Local accounting code which applies to this
transaction

and foreign key to the LOCAL_ACCOUNTING_CODES

table.

OBJ_CLASS VARCHAR2(6) Code which identifies the object class for the
transaction

and foreign key to the OBJECT_CLASSES table.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau
responsible

for the aircraft costs to be allocated. Foreign key to the

ORGANIZATION_CODES table.

POSTED_TIME DATE Date and time the transaction was posted.

REGIS_NO VARCHAR2(9) Unique identification mark or \"tail number\"
(usually

numbers and letters) displayed on Government aircraft \--

including foreign aircraft hired as CAS.

TRANS_AMT NUMBER(7,2) Amount of the transaction.

TRANS_DATE DATE Date of the transaction.

TRANS_ID NUMBER(7) Unique identifier for the transaction and primary key
of this

table.

TRANS_UNITS NUMBER(8) Number of units used in this transaction.

WORK_ORDER VARCHAR2(25) Work order number associated with the
transaction.

TABLE BULK_FUEL_INVENTORY

DESCRIPTION Contains information on the date, amount, cost, and storage
location of bulk fuel

purchases.

COLUMN TYPE DEFINITION

COST_GAL NUMBER(6) Bulk fuel cost per gallon.

FUEL_TYPE VARCHAR2(15) Type of fuel purchased.

GALS_PURCH NUMBER(8) Number of gallons purchased.

GALS_REMAIN NUMBER(8) Number of gallons of fuel remaining.

PURCH_DATE DATE Date and time of bulk fuel purchase.

PURCHASE_ID NUMBER(7) Unique identifier for the purchase and primary key
to this

table.

TANK_LOC VARCHAR2(30) Location of the tank where the purchased fuel was
stored.

TANK_NAME VARCHAR2(30) Name of the tank where the fuel purchase was
stored.

TABLE CAG_CODES

DESCRIPTION Contains codes, descriptions, and other information about
accounts defined in the

GSA Cost Accounting Guide (CAG).

COLUMN TYPE DEFINITION

ACCOUNT_TYPE VARCHAR2(2) Code which identifies the CAG account type and
foreign

key to the ACCOUNT_TYPES table.

AG_COST_CODE VARCHAR2(6) Agency cost code associated with the CAG
account and

foreign key to the AGENCY_COST_CODES table.

ALLOC_CREW_HRS CHAR(1) Allocate as variable cost on the basis of C =
Crew, A =

Aircraft Hours, or N = Don\'t allocate.

CAG_CODE VARCHAR2(6) Code which identifies a Cost Accounting Guide (CAG)

account and primary key to this table.

COST_CATEGORY VARCHAR2(10) Code which identifies the cost category for
the CAG

account and foreign key to the COST_CATEGORY_CODES

table.

DEFINITION VARCHAR2(2000) Definition of the CAG account from the Cost
Accounting

Guide.

DESCRIPTION VARCHAR2(50) Description of the CAG account.

FIX_OR_VAR_COST CHAR(1) Indicates cost type: F = Fixed, V = Variable, N
= Neither.

LOCAL_CODE VARCHAR2(6) Default local accounting code associated with the
CAG

code.

MISS_RELATED CHAR(1) Indicates (Y/N) if account is mission-related.

REQS_N_NUMBER CHAR(1) Indicates (Y/N) if CAG account requires N number.

SUM_CODE VARCHAR2(6) Code which identifies the cost summary code
associated

with the CAG code and foreign key to the

AIRCRAFT_COST_SUMMARY_CODES table.

TABLE CLOSING_DATES

DESCRIPTION Contains approved closing dates by accounting month and
year.

COLUMN TYPE DEFINITION

ACCTNG_MONTH NUMBER(6) Identifies accounting month and year in the form
199705

(for May 1997).

COMPLETED CHAR(1) Indicates (Y/N) if closing has been completed for this

accounting period.

END_DATE DATE End date for accounting month. START_DATE,

END_DATE is the primary key for this table.

FISCAL_YEAR VARCHAR2(4) Fiscal year for the closing dates.

START_DATE DATE Start date for accounting month. START_DATE,

END_DATE is the primary key for this table.

TABLE COMM_FED_CATEGORY

DESCRIPTION Stores the acceptable values for commercial and Federal
aircraft cost categories.

COLUMN TYPE DEFINITION

COMM_FED_CAT VARCHAR2(30) Name of the commercial or Federal cost
category.

COMM_FED_DESC VARCHAR2(2000) Description of the commercial or Federal
cost category.

COMM_FED_SEQ NUMBER(3) Unique identifier for a commercial/Federal
aircraft cost

category and primary key to this table.

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

TABLE COST

DESCRIPTION Stores specific aircraft cost information for a reporting
period.

COLUMN TYPE DEFINITION

ACTUAL_COST_IND VARCHAR2(1) Indicates if the reported cost is an actual
(A) or an

estimated (E) cost.

COST NUMBER(12) The dollar amount of a particular cost for a specific
aircraft,

for a specific mission, for a specified period of time.

QUAL_COST_TYPE_SEQ NUMBER(4) Unique identifier of a C-AMIS cost type and
foreign key to

the QUALIFIED_COST_TYPE table.

RPTPD_SEQ NUMBER(8) Unique identifier for a reporting period of cost and
hours

data for an aircraft and with QUAL_COST_TYPE_SEQ the

primary key to this table..

TABLE COST_CATEGORY

DESCRIPTION Stores the acceptable values for the grouping of different
types of cost.

COLUMN TYPE DEFINITION

COST_CAT_SEQ NUMBER(4) Unique identifier of the cost category and
primary key to

this table.

COST_CATEGORY VARCHAR2(50) Name of the cost category.

COST_CATEGORY_DESC VARCHAR2(2000) Description of the cost category.

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this date is valid.

TABLE COST_CATEGORY_CODES

DESCRIPTION Defines and describes cost category codes.

COLUMN TYPE DEFINITION

CATEGORY_DESC VARCHAR2(30) Describes the cost category.

COST_CATEGORY VARCHAR2(10) Code which identifies the cost category and
primary key of

this table.

TABLE DETAIL_POSTED_COSTS

DESCRIPTION Contains detailed cost information by transaction for
agencies and organizations.

COLUMN TYPE DEFINITION

ACCTG_MO NUMBER(6) Identifies the accounting month and year in the form
199705

(for May 1997).

AIRCRAFT_SEQ NUMBER(8) Unique identifier for the aircraft and foreign
key to the

FLEET_AIRCRAFT table.

ASSET_NO VARCHAR2(50) Number assigned to the asset involved in the
transaction.

CAG_CODE VARCHAR2(6) Code which identifies the CAG account and foreign
key to

the CAG_CODES table.

COMP_GEN CHAR(1) Indicates (Y/N) if the transaction is
computer-generated.

DET_COST_ID NUMBER(7) Identifier of the detailed posted cost. The
primary key to

this table is made up of EXEC_AGENCY_SEQ,

ORG_CODE, DET_COST_ID.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for an executive agency and
foreign key to

the EXECUTIVE_AGENCY table. EXEC_AGENCY_SEQ,

ORG_CODE, DET_COST_ID is the primary key of this

table.

FLIGHT_ID NUMBER(7) Identifier of the flight and foreign key to the
FLIGHTS table.

FLIGHT_LEG_ID NUMBER(2) Identifier of the flight leg and with FLIGHT_ID
the foreign

key to the FLIGHT_LEGS table.

FLIGHT_NO VARCHAR2(15) Flight number associated with the transaction.

LC_CODE VARCHAR2(8) Life cycle analysis code and foreign key to the

LIFE_CYCLE_ANALYSIS_CODES table.

LOCAL_CODE VARCHAR2(6) Local accounting code and foreign key to the

LOCAL_ACCOUNTING_CODES table.

OBJECT_CLASS VARCHAR2(6) Object class for the detail posted costs and
foreign key to

the OBJECT_CLASSES table.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau and
foreign

key to the ORGANIZATION_CODES table. The primary

key to this table is EXEC_AGENCY_SEQ, ORG_CODE,

DET_COST_ID.

POSTED_TIME DATE Date and time the transaction was posted.

PURCH_ORD_NO VARCHAR2(25) Purchase order number associated with the
transaction.

REGIS_NO VARCHAR2(9) Unique identification mark or \"tail number\"
(usually

numbers and letters) displayed on Government aircraft \--

including foreign aircraft hired as CAS.

TRANS_AMT NUMBER(12,2) Amount of the transaction.

TRANS_DATE DATE Date of the transaction.

TRANS_UNITS NUMBER(8) Number of units involved in this transaction.

TYPE_OF_COST CHAR(1) Code which identifies the cost type as fixed (F),
variable

(V), or neither (N).

WORK_ORD_NO VARCHAR2(15) Work order number associated with the
transaction.

TABLE FIXED_OR_VARIABLE_COSTS

DESCRIPTION Classifies costs as fixed or variable.

COLUMN TYPE DEFINITION

COST_DESC VARCHAR2(20) Cost description and primary key to this table.

FIX_OR_VAR_COST CHAR(1) Code which identifies the cost type as fixed
(F), variable

(V), or neither (N).

TABLE FIXED_VARIABLE_CAT

DESCRIPTION Stores the acceptable values for fixed and variable aircraft
cost categories

COLUMN TYPE DEFINITION

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

FIXED_VAR_SEQ NUMBER(3) Unique identifier of a fixed or variable
aircraft cost category

and primary key to this table.

FIXED_VARIABLE_CAT VARCHAR2(30) Name of the fixed or variable aircraft
cost category.

FIXED_VARIABLE_DESC VARCHAR2(2000) Description of the fixed or variable
aircraft cost category.

TABLE GOVT_AIRCRAFT_COST_UTILIZATION

DESCRIPTION Contains aircraft cost utilization information by agency,
organization, aircraft, and

aircraft cost summary code.

COLUMN TYPE DEFINITION

AIRCRAFT_ID NUMBER(7) Identifier of the aircraft and foreign key to the

FLEET_AIRCRAFT table. AGENCY_CODE, ORG_CODE,

AIRCRAFT_ID, SUM_CODE is the primary key of this

table.

AMOUNT NUMBER(12,2) Utilization amount.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier of an exceutive agency and
foreign key to

the EXECUTIVE_AGENCY table. EXEC_AGENCY_SEQ,

ORG_CODE, AIRCRAFT_ID, SUM_CODE is the primary

key to this table.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau and
foreign

key to the ORGANIZATION_CODES table.

SUM_CODE VARCHAR2(6) Code which identifies the aircraft cost summary
code and

foreign key to the

AIRCRAFT_COST_SUMMARY_CODES table.

TABLE JOB_FUNCTIONS

DESCRIPTION Contains codes and descriptions for job functions.

COLUMN TYPE DEFINITION

JOB_DESC VARCHAR(250) Description of the job function.

JOB_FUNCTION VARCHAR2(3) Code which identifies a job function and
primary key of this

table.

TABLE LIFE_CYCLE_ANALYSIS_CODE_TYPES

DESCRIPTION Defines and describes life cycle analysis code types.

COLUMN TYPE DEFINITION

LC_CODE_TYPE VARCHAR2(2) Identifier of the type of life cycle analysis
code and primary

key of this table.

LC_TYPE_DESC VARCHAR2(25) Describes the type of life cycle analysis
code.

TABLE LIFE_CYCLE_ANALYSIS_CODES

DESCRIPTION Defines and describes life cycle analysis codes by agency
and organization.

COLUMN TYPE DEFINITION

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

LC_CODE VARCHAR2(8) Code used for aircraft life cycle analysis.

LC_CODE_DESC VARCHAR2(25) Description of the life cycle analysis code.

LC_CODE_TYPE VARCHAR2(2) Type of life cycle analysis code and foreign
key to the

LIFE_CYCLE_ANALYSIS_CODE_TYPES table.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau and
foreign

key to the ORGANIZATION_CODES table.

TABLE LIFE_CYCLE_ANALYSIS_COMP_COSTS

DESCRIPTION Contains comparative cost information by aircraft type and
life cycle analysis

code.

COLUMN TYPE DEFINITION

AIRCRAFT_CODE VARCHAR2(6) Code which identifies the type of aircraft and
foreign key to

the AIRCRAFT_CODES table. AIRCRAFT_CODE,

LC_CODE is the primary key of this table.

COST NUMBER(12,2) Total cost of the aircraft type for the life cycle
analysis

code.

FREQ_CYCLES NUMBER(8) Frequency expressed in cycles.

FREQ_HOURS NUMBER(8) Frequency expressed in hours.

FREQ_YEARS NUMBER(8) Frequency expressed in years.

INSP_PREM_REM NUMBER(8) Number of inspections.

LC_CODE VARCHAR2(8) Code which identifies the life cycle analysis code
and

foreign key to the LIFE_CYCLE_ANALYSIS_CODES table.

AIRCRAFT_CODE, LC_CODE is the primary key of this

table.

TABLE LOCAL_ACCOUNTING_CODES

DESCRIPTION Contains local accounting codes with the corresponding CAG
codes by agency

and organization.

COLUMN TYPE DEFINITION

AGENCY_CODE VARCHAR2(2) Code which identifies the department or agency
and

foreign key to the AGENCY_CODES table.

CAG_CODE VARCHAR2(6) Code for a CAG account equivalent to the local
account

and foreign key to the CAG_CODES table.

LOCAL_CODE VARCHAR2(6) Code which identifes a local account and primary
key of

this table.

LOCAL_DESC VARCHAR2(40) Description of the local accounting code.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau and
foreign

key to the ORGANIZATION_CODE table.

TABLE OBJECT_CLASSES

DESCRIPTION Defines and describes object classes.

COLUMN TYPE DEFINITION

DESCRIPTION VARCHAR2(50) Description of the object class.

OBJECT_CLASS VARCHAR2(6) Code which identifies object class and primary
key to this

table.

TABLE PAY_ITEM_CODES

DESCRIPTION Defines and describes pay item codes.

COLUMN TYPE DEFINITION

PAY_ITEM_CODE VARCHAR2(5) Code which defines the pay item and primary
key of this

table.

PAY_ITEM_DESC VARCHAR2(30) Description of the pay item.

TABLE PERSONS

DESCRIPTION Contains information about persons.

COLUMN TYPE DEFINITION

BENE_PER_HR NUMBER(6,2) Standard benefits per hour to which the person
is entitled.

CREW_PERSON CHAR(1) Indicates (Y/N) if the person belongs to a flight
crew.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

JOB_FUNCTION VARCHAR2(3) Identifier of the job function performed by the
person and

foreign key to the JOB_FUNCTIONS table.

NAME_FIRST VARCHAR2(20) First name of person.

NAME_LAST VARCHAR2(20) Last name of person.

NAME_MI VARCHAR2(1) Middle initial of person.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau to
which

the person belongs and foreign key to the

ORGANIZATION_CODES table.

PERSON_ID NUMBER(7) System-generated unique identifier for a person
record and

primary key to this table.

PILOT_CERT CHAR(1) Indicates (Y/N) if the person is certified as a
pilot.

RATE_PER_HR NUMBER(6,2) Standard pay rate per hour for the person.

SALUTATION VARCHAR(10) Specifies the appropriate salutation for letters
to the

STATUS_CODE NUMBER(4) Identifier of the person\'s status and foreign key
to the

PERSONS_STATUS table.

TITLE VARCHAR2(50) Title of the person

UNIQUE_ID VARCHAR2(30) Unique Government ID for the person.

WEIGHT NUMBER(3) Weight of the person.

TABLE PERSONS_STATUS

DESCRIPTION Contains status codes and descriptions for persons.

COLUMN TYPE DEFINITION

STATUS_CODE NUMBER(5) Unique identifier for the status and primary key
to this

table.

STATUS_DESC VARCHAR2(50) Description of the person\'s status.

TABLE QUALIFIED_COST_TYPE

DESCRIPTION Stores the acceptable values for the type of cost incurred
to operate and maintain

fleet aircraft.

COLUMN TYPE DEFINITION

COMM_FED_SEQ NUMBER(3) Unique identifier of the cost paid to a
commercial source

(i.e., not paid to the Federal Government) and foreign key to

the COMM_FED_CATEGORY table..

COST_CAT_SEQ NUMBER(4) Unique identifier of a higher level grouping of
costs and

foreign key to the COST_CATEGORY table.

COST_OFFSET_IND VARCHAR2(1) Indicates (Y/N) that a cost is a fixed
amount of money

contributed by other agencies to share the cost of aircraft

operations.

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

FIXED_VAR_SEQ NUMBER(3) Unique identifier of a fixed/variable cost
category and

foreign key to the FIXED_VARIABLE_CAT table.

INCLUDE_AC_TOT_IND VARCHAR2(1) Indicates (Y/N) that the cost is to be
included in totals for

the aircraft.

PART_LABOR_CAT_SEQ NUMBER(3) Unique identifier of the parts/labor cost
category and

foreign key to the PART_LABOR_CATEGORY table.

QUAL_COST_TYPE_DESC VARCHAR2(2000) Description of the type of cost
incurred to operate and

maintain a Fleet aircraft.

QUAL_COST_TYPE_SEQ NUMBER(4) Unique identifier of a qualified cost type
and primary key to

this table.

QUALIFIED_COST_TYPE VARCHAR2(100) The type of cost incurred to operate
and maintain a Fleet

aircraft.

SCHED_UNSCHED_SEQ NUMBER(3) Unique identifier of the
Scheduled/Unscheduled

Maintenance category and foreign key to the

SCHED_UNSCHED_CAT table.

TABLE REPORTED_PERIOD

DESCRIPTION Stores the beginning and end dates of the period for which
the Fleet aircraft cost

and hours flown data are submitted.

COLUMN TYPE DEFINITION

AC_BUR_HIST_SEQ NUMBER(8) Unique identifier of an aircraft bureau
history item and

primary key to this table.

BATCH_INPUT_IND VARCHAR2(1) Indicates (Y/N) if the record information
was entered by

batch file input.

COST_COMMENT VARCHAR2(2000) Remarks which clarify the cost reporting.

COST_THIS_PERIOD_IND VARCHAR2(1) Indicates (Y/N) if the agency/bureau
has incurred costs for

the reporting period for the aircraft.

DATA_AVAIL_STAT_SEQ NUMBER(2) Unique identifier of data availability
status and foreign key

to the DATA_AVAIL_STAT table.

ENTERED_BY_USER_ID VARCHAR2(30) Id of user who entered the information
into the database.

ENTRY_DATE DATE Date the information was entered into the database.

HRS_THIS_PERIOD_IND VARCHAR2(1) Indicates (Y/N) if the agency has hours
flown for the

reporting period for the aircraft.

MODIFIED_BY_USER_ID VARCHAR2(30) Id of user who last modified
information in the record.

MODIFIED_DATE DATE Date the record was last modified.

REVIEWER_COMMENT VARCHAR2(2000) Reviewer comments on this record.

RPT_PER_BEG_DATE DATE The first day of the period for which data is
being reported.

RPT_PER_END_DATE DATE The last day of the period for which data is being
reported.

RPTPD_SEQ NUMBER(8) Unique identifier for a reported period of cost and
hours

data for an aircraft.

TABLE SCHED_UNSCHED_CAT

DESCRIPTION Stores the acceptable values for scheduled and unscheduled
maintenance aircraft

cost categories

COLUMN TYPE DEFINITION

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

SCHED_UNSCHED_CAT VARCHAR2(35) Name of the scheduled or unscheduled
maintenance aircraft

cost category.

SCHED_UNSCHED_DESC VARCHAR2(2000) Description of the scheduled or
unscheduled maintenance

aircraft cost category.

SCHED_UNSCHED_SEQ NUMBER(3) Unique identifier of the scheduled or
unscheduled

maintenance aircraft cost category and primary key to this

table.

*MODULE* *Maintenance*

*DESCRIPTION* *The maintenance module of C-AMIS is based on the concept
of a configuration list which*

*defines and documents the \"as designed\" assembly and component
hierarchy for each*

*aircraft type. Each assembly may have one or more individual components
which are*

*tracked against it by serial number. The module records and reports the
removal or*

*installation of any major assembly, sub-assembly, or component
identified on the*

*configuration list from its parent assembly and tracks the operation
time and location of*

*all attached lower level items. Maintenance due lists and configuration
status reports are*

*available on demand for any aircraft or major assembly. Significant
component history*

*records are maintained and automatically updated on all items contained
in the*

*configuration lists. The module also configures and tracks the
execution of tasks,*

*associated tasks, depot tasks, and equipment tasks.*

*The module generates component replacement and engine overhaul
schedules, and tracks*

*the ordering lead time for components. The module identifies
alternative or substitute*

*components, verifies inventories (ordered, on-site, back-ordered),
tracks credits for*

*returned items, and schedules maintenance and inspections. The module
also tracks*

*equipment replacements, incomplete maintenance and repair activities,
and the*

*manufacturer and serial number of parts. It provides information on
stock location, item*

*condition, inventory type, average unit price, and replacement cost. A
complete part*

*number history by manufacturer is recorded by the module, which also
provides serial*

*number tracking by part number. The module identifies frequently
ordered components,*

*forecasts overhauls and upgrades based on age, cross references actions
with ATA chapter*

*number, and generates aircraft maintenance history reports. It monitors
time compliance*

*for life-limited components, and the dissemination of air worthiness
directives and service*

*bulletin information. Module information in the C-AMIS database will be
reported and/or*

*displayed to assist the maintenance manager.*

TABLE ASSOC_TASKS

DESCRIPTION Contains information about parts, including parent and
ancestor part identifiers,

the component type and identifier, and the organization and postition
identifiers.

COLUMN TYPE DEFINITION

ANCESTOR_ASSOC_ID NUMBER(4) Identifier of the task at the topmost node
of this associated

task\'s association tree (used for navigation).

ASSOC_ID NUMBER(4) Unique identifier for each association between a
primary

and an associated task. (Note: an associated task may have

associated tasks of its own.) Primary key of this table.

ASSOC_TYPE VARCHAR2(20) Code which identifies the type of the associated
task

(manual, automatic, iteration reset).

HIST_IND CHAR(1) Indicates (Y/N) if a history record is created upon
execution

of this task.

ITERATION_RESET NUMBER(2) Iteration value which this associated task
assumes upon

iteration reset.

ITERATION_RESET_IND CHAR(1) Indicates (Y/N) if the iteration value is
reset upon execution

of this task.

PARENT_ASSOC_ID NUMBER(4) Identifies the associated task record which
references the

primary task.

PATH VARCHAR2(49) Top-down list of the task\'s ancestors, beginning with
the

topmost node and ending with itself. An auxilliary column

used to move through the organizational tree structure.

SEQUENCE_NO NUMBER(2) System-generated sequence number which indicates
the

order in which this associated task is executed relative to

other associated tasks under the same primary task.

TASK_ID NUMBER(4) Unique identifier for the associated task and primary
key to

this table..

TABLE CASE_HISTS

DESCRIPTION For Mandatory Special Requirements (MSR) use only.
Associates a given part

with each case (mission) on which it was deployed during its lifetime.

COLUMN TYPE DEFINITION

CASE_NUMBER VARCHAR2(10) Number assigned to the case (mission) for which
the part

was deployed. For Mandatory Special Requirements

(MSR) use only.

HIST_ID NUMBER(2) Sequential identifier for a row in the part task
history

assigned by the system. PART_ID, TASK_ID, HIST_ID is

the primary key of the table.

PART_ID NUMBER(4) Identifier of a part and foreign key to the PARTS
table.

TASK_ID NUMBER(4) Identifier of a task and foreign key to the TASKS
table.

TABLE COMP_CLASS_TYPES

DESCRIPTION Associates each component class with its component type
members.

COLUMN TYPE DEFINITION

COMP_CLASS_ID NUMBER(2) Identifier of a component class and foreign key
to the

COMP_CLASSES table.

COMP_CLASS_TYPE VARCHAR2(30) Description of the component class type.

COMP_TYPE_ID NUMBER(2) Identifier of a component type and foreign key to
the

COMP_TYPES table. COMP_CLASS_ID,

COMP_TYPE_ID is the primary key of this table.

TABLE COMP_CLASSES

DESCRIPTION Contains a list of component classes (groups of component
types that users may

create for any purpose) with system-generated identifiers.

COLUMN TYPE DEFINITION

COMP_CLASS_DESC VARCHAR2(30) Description of the component class.

COMP_CLASS_ID NUMBER(2) Unique identifier for the component class and
primary key

to this table.

OWNER_GROUP_ID NUMBER(2) Identifier of the user group authorized to
modify the

component class.

TABLE COMP_PART_TYPES

DESCRIPTION Associates each component type with each part type that
satisfies the component

type\'s unique form, fit, and function. A component type may be
satisfied by

multiple part types, and a given part type may satisfy multiple
component types.

COLUMN TYPE DEFINITION

COMP_TYPE_ID NUMBER(2) Unique identifier of a component type and foreign
key to

the COMP_TYPES table.

PART_TYPE_ID NUMBER(4) Unique identifier of a part type and foreign key
to the

PART_TYPES table. COMP_TYPE_ID, PART_TYPE_ID is

the primary key of this table.

VALID_PART_TYPE_IND CHAR(1) Indicates (Y/N) if the part type is valid
(having a valid part

number and manufacturer). Used as a system reminder

only, it does not disallow the combination of a component

type with an invalid part type.

TABLE COMP_TYPE_PARAMETERS

DESCRIPTION Associates each component type with each parameter used to
track its age, and

with the maximum and minimum values by which the paramter may be
increased.

COLUMN TYPE DEFINITION

COMP_TYPE_ID NUMBER(4) Unique identifier of a component type and foreign
key to

the COMP_TYPES table.

DATA_ENTRY_IND CHAR(1) Indicates (Y/N) if the parameter is updated at
the level of

the component type.

MAX_PARAM_INCRE NUMBER(4) Highest acceptable value by which the
parameter may be

incremented.

MIN_PARAM_INCRE NUMBER(4) Lowest acceptable value by which the parameter
may be

incremented.

PARAM_ID NUMBER(2) Unique identifier of a parameter and foreign key to
the

PARAMETERS table. COMP_TYPE_ID, PARAM_ID is

the primary key of this table.

TABLE COMP_TYPE_TASKS

DESCRIPTION Associates each task with the component type(s) on which the
task is performed.

COLUMN TYPE DEFINITION

COMP_TYPE_ID NUMBER(2) Unique identifier for a component type and
foreign key to

the COMP_TYPES table.

TASK_ID NUMBER(4) Unique identifier for a task and foreign key to the
TASKS

table.

TABLE COMP_TYPES

DESCRIPTION Contains a list of component types with system-generated
identifiers.

COLUMN TYPE DEFINITION

ASSEMBLY_IND CHAR(1) Indicates (Y/N) if the component type is a complete

assembly.

COMP_TYPE_CODE VARCHAR2(15) Code for the component type which is
meaningful to the

end user.

COMP_TYPE_DESC VARCHAR2(30) Description of the component type.

COMP_TYPE_ID NUMBER(2) Unique identifier for a component type and
primary key of

this table.

IMAGE_FILENAME VARCHAR2(30) Name of the file holding the graphic image
of the

component type. Used by the graphical user interface.

MAJ_COMP_IND CHAR(1) Indicates (Y/N) if the component type is a major

component. A major component is often, but not

necessarily, a type 1 (level 2) component, and is

distinguished by cost and other criteria.

SERIALIZE_IND CHAR(1) Indicates (Y/N) if the component type is serial
tracked.

Serial tracked parts can be removed and installed. Non-

serial tracked parts (having no physical identifier) can only

be replaced, not removed and installed.

TABLE COMP_VERS_MEMBERS

DESCRIPTION Associates each component version with each of its member
components which

must be excluded from the complete assembly in order to obtain the
version.

COLUMN TYPE DEFINITION

COMP_ID NUMBER(4) Identifier for a component which must be excluded from
the

complete assembly in order to obtain the version. Foreign

key to the COMPONENTS table. COMP_VERSION_ID,

COMP_ID is the primary key of this table.

COMP_VERSION_ID NUMBER(4) Identifier of a component version and foreign
key to the

COMP_VERSIONS table.

TABLE COMP_VERSIONS

DESCRIPTION Assigns a system-generated identifier to each component
version (unique

configuration of a particular assembly). Component version member lists
the

components which must be excluded from the complete assembly in order to

obtain a version.

COLUMN TYPE DEFINITION

ASSEMBLY_COMP_ID NUMBER(4) Component identifier of an assembly type to
which the

component version applies. Foreign key to the

COMPONENTS table.

COMP_VERS_DESC VARCHAR2(30) Description of the component version.

COMP_VERSION_ID NUMBER(4) Unique identifier for a component version and
primary key

of this table.

TABLE COMPONENTS

DESCRIPTION Contains information about components, including the
component type and

parent and ancestor identifiers.

COLUMN TYPE DEFINITION

ANCESTOR_COMP_ID NUMBER(4) Component identifier of the top node (highest
item in the

assembly, parent of all parents) of this component. Used

for navigation.

ASSEMBLY_IND CHAR(1) Indicates (Y/N) if this component is part of a
complete

assembly.

COMP_ID NUMBER(4) Unique identifier of a component and primary key of
this

table.

COMP_TYPE_ID NUMBER(2) Component type identifier (form, fit, and
function) of this

component.

DISPLAY_SEQ NUMBER(2) Indicates the order in which this component will
appear in

configuration reports, in relation to the other components

in its assembly.

PARENT_COMP_ID NUMBER(4) Identifier of the component to which this
component is

attached.

PATH VARCHAR2(49) Top-down list of all ascendants of this component,

beginning with its ancestor and ending with itself. An

auxilliary column used to move through the organizational

tree structure.

POSITION_ID NUMBER(2) Position identifier of this component.

REQ_STATUS CHAR(1) Status (M = Mandatory, O = Optional) of this
component.

TABLE DEPOT_TASKS

DESCRIPTION Provides additional columns, when needed, for information on
tasks performed at

the depot (rather than at an air station).

COLUMN TYPE DEFINITION

MANDATORY_QA_IND CHAR(1) Indicates (Y/N) if the task requires quality
assurance.

MPC_REQ_IND CHAR(1) Indicates (Y/N) if a maintenance procedure card is
to be

used at the depot for the task.

PDM_OPS_NO NUMBER(2) Periodic depot maintenance operation number.
Identifies

the group of tasks (pdm operation) to which the task

belongs.

PDM_SEQUENCE_NO NUMBER(2) Periodic depot maintenance sequence number.
Indicates

the order which this task is done in relation to other tasks

within the pdm operation.

PDM_SHOP NUMBER(2) Periodic depot maintenance shop where the task was

performed.

TAG_NUMBER VARCHAR2(8) Number optionally assigned to the task within the
depot.

TASK-TYPE_ID NUMBER(2) Identifier of the type for the task and foreign
key to the

TASK_TYPES table.

TASK_ID NUMBER(4) Identifier of a task and foreign key to the TASKS
table, with

which it could be combined. DEPOT_TASKS provides

additional columns, when needed, for information on tasks

performed at the depot rather than the air station. Primary

key of this table.

TABLE EQUIPMENT_TASK_HISTS

DESCRIPTION Tracks the history of equipment tasks. Maintains a row for
each time a given

equipment task was executed on a given part.

COLUMN TYPE DEFINITION

COMMENT VARCHAR2(350) Optional space for additional information about
the task.

HIST_ID NUMBER(2) With TASK_ID the identifier of this record and primary
key

to this table.

MAINT_DATE DATE Date on which the task was executed.

SCHEDULED_IND CHAR(1) Indicates (Y/N) if the task was scheduled
maintenance.

TASK_ID NUMBER(4) Identifier of a task and foreign key to the TASKS
table.

TECH_CODE CHAR(4) Identifies the person who performed the task.

TABLE EQUIPMENT_TASK_TYPES

DESCRIPTION Assigns a system-generated identifier to each equipment task
type, which

describes the action of an equipment task (inspect, lubricate, etc.).

COLUMN TYPE DEFINITION

TASK_TYPE_DESC VARCHAR2(30) Description of the equipment task type
(inspect, lubricate,

etc.).

TASK_TYPE_ID NUMBER(2) Unique identifier for a task type and primary key
of this

table.

TABLE EQUIPMENT_TASKS

DESCRIPTION For Special Requirement (SR) use only. Defines, describes,
and assigns a unique,

system-generated identifier to each equipment task (one or more
operations

performed on a part).

COLUMN TYPE DEFINITION

APPLICABLE_TO VARCHAR2(30) Applicable technical order (documentation)
required to do

the task.

CREATE_DATE DATE Date on which the task was created.

EQUIPMENT_CODE VARCHAR2(15) Serial number assigned to the item on which
the task is

performed.

INTERVAL NUMBER(4) Number of days between schedulings of the task.

LAST_HIST_ID NUMBER(2) Identifier (along with TASK_ID) of the row in

EQUIP_TASK_HISTS which records the most recent

execution of the task.

LAST_MAINT_DATE DATE Date on which the task was last perfomed.

MODIFY_DATE DATE Date on which the task was last modified.

ORG_ID NUMBER(4) Identifier of the organization where the task is
performed,

and foreign key to the ORGANIZATIONS table.

PROCEDURE_CODE VARCHAR2(8) Identifier for the procedure for the task
which is meaningful

to the end user. Only applies if the task has a Maintenance

Procedure Card (MPC).

TASK_CODE VARCHAR2(6) Code for a task which is meaningful to the end
user.

TASK_DESC VARCHAR2(30) Description of the task.

TASK_ID NUMBER(4) System-generated unique identifier for a task and
foreign

key to the TASKS table, with which it could be combined.

Special Requirement (SR) use only. Primary key of this

table.

TASK_TYPE_ID NUMBER(2) Identifier for the task type and foreign key to
the

EQUIP_TASK_TYPES table.

TABLE LABOR_TYPES

DESCRIPTION Contains a list of standard labor types with
system-generated identifiers.

COLUMN TYPE DEFINITION

LABOR_TYPE VARCHAR2(30) Description of the labor type.

LABOR_TYPE_CODE VARCHAR2(10) Code for the labor type which is meaningful
to the end user.

LABOR_TYPE_ID NUMBER(2) Unique identifier for the labor type and primary
key of this

table.

TABLE LOGS

DESCRIPTION Contains statistical information about assemblies by
organization.

COLUMN TYPE DEFINITION

LOG_DATE DATE Date of the log event.

LOG_ID NUMBER(4) Unique identifier for a log event and primary key of
this

table.

LOG_SEQUENCE NUMBER(1) Indicates the order of the log event in relation
to other log

events with the same log date.

TABLE MAINT_TRANSACTIONS

DESCRIPTION System-generated identifier for each maintenance transaction
(group consisting of

a primary task and all associated tasks signed off simultaneously). Each
task

contains information common to all tasks in the transaction.

COLUMN TYPE DEFINITION

ASSEMBLY_PART_ID NUMBER(4) Part identifier of the assembly on which this
maintenance

transaction was performed.

COMMENT VARCHAR2(140) Additional information abouk the maintenance
transaction.

DISCREP_IND CHAR(1) Indicates (Y/N) if a discrepancy was found during
the

performance of the maintenance transaction. Used for

inspection.

ENTRY_DATE DATE Date on which this transaction was entered into the
system.

LOG_ID NUMBER(4) Identifier of the log (list of parameters of a given
assembly

at a given time) that applies to this transaction.

MAINT_DATE DATE Date on which this transaction took place.

MAINT_ORG_ID NUMBER(4) Identifier of the organization where the
maintenance

transaction was executed. Foreign key to the

ORGANIZATIONS table.

REVISION_DATE DATE Revision date entered by the user on the procedure
card

used to perform the primary task of this maintenance

transaction.

SCHED_IND CHAR(1) Indicates (Y/N) if the maintenance transaction was

scheduled.

TASK_REASON_ID NUMBER(4) Identifier of the reason the task was performed
(scheduled,

due to failure, etc.).

TECH_CODE VARCHAR2(4) Identifier for the mechanic who performed this
maintenance

transaction.

TRANSACTION_ID NUMBER(4) Unique identifier of a maintenance transaction
and primary

key of this table.

USER_CODE VARCHAR2(20) Identifier of the user who signed off this
transaction.

VALID_PROCED_IND CHAR(1) Indicates (Y/N) if the revision date was
current when the

maintenance task was performed.

TABLE MANUFACTURERS

DESCRIPTION Contains a list of manufacturers with system-generated
identifiers.

COLUMN TYPE DEFINITION

CAGE_CODE VARCHAR2(25) Government code combining manufacturer name and

location (address).

MANUFACTURER VARCHAR2(30) Name of the manufacturer.

MANUFACTURER_ID NUMBER(4) Unique identifier for a manufacturer and
primary key to this

table..

TABLE ORG_ASSEM_TYPE_STATS

DESCRIPTION Contains statistical information on assembly types.

COLUMN TYPE DEFINITION

ASSEMBLY_TYPE VARCHAR2(20) Identifier of the assembly type.

AUGMENT_FACTOR NUMBER(4) Indicates whether the organization has less
than, equal to,

or more than the allocated personnel and number of

assemblies up to the present time.

HOURS NUMBER(2) Actual number of operational hours logged in by the

assembly type for the organization and month.

ORG_ID NUMBER(4) Identifier of an organization and foreign key to the

ORGANIZATIONS table.

PERCENT_NMC_BOTH NUMBER(5,2) Percent of time the assembly is unavailable
(not mission

capable) due to both maintenance and supply.

PERCENT_NMC_MAINT NUMBER(5,2) Percent of the time the assembly is
unavailable (not mission

capable) due to maintenance.

PERCENT_NMC_SUPPLY NUMBER(5,2) Percent of time the assembly is
unavailable (not mission

capable) due to supply.

PROGRAM_HRS NUMBER(2) Number of annual operating hours allocated to the

assembly type during the current month.

STATS_DATE DATE End date of a month.

TABLE ORG_ASSEMBLY_STATS

DESCRIPTION Contains statistical information about assemblies by
organization.

COLUMN TYPE DEFINITION

ASSEMBLY_ID NUMBER(4) Part identifier of an assembly and foreign key to
the PARTS

table.

ORG_ID NUMBER(4) Identifier of an organization and foreign key to the

ORGANIZATIONS table.

PARAM_ID NUMBER(2) Identifier of the parameter totalled in the record.

PARAM_VALUE NUMBER(4) Amount of aging, in terms of the parameter,
recorded for

the currently referenced assembly, organization, and month.

STATS_DATE DATE End date of the month for which the parameter is
totalled.

TABLE ORG_ASSEMBLY_TYPES

DESCRIPTION Associates a given assembly at a given organization with the
current annual

allocation of flight hours and number of assemblies.

COLUMN TYPE DEFINITION

ASSEMBLY_TYPE VARCHAR2(20) Identifies the assembly type.

AUGMENT_FACTOR NUMBER(4) Indicates whether the organization has had less
than, equal

to, or more than the allocated personnel and number of

assemblies up to the present time.

COMPLEMENT NUMBER(2) Number of the currently referenced assembly type
annually

allocated to the organization at the present time.

ORG_ID NUMBER(4) Identifier of an organization and foreign key to the

ORGANIZATIONS table.

PROGRAM_HRS NUMBER(2) Number of operational hours allocated to the
assembly at

the organization.

TABLE ORG_PROCEDURE_CARDS

DESCRIPTION Associates each organization with the specific information
on maintenance

procedure cards for inventory purposes.

COLUMN TYPE DEFINITION

CONSUMED_QTY NUMBER(4) Number of maintenance procedure cards that were
used for

the procedure and organization since the last mailed date.

LAST_MAILED_DATE DATE Date on which this procedure card was last mailed
to the

organization.

LAST_MAILED_QTY NUMBER(4) Number of maintenance procedure cards that
were last

mailed to the organization for the procedure.

MAILED_QTY NUMBER(4) Number of maintenance procedure cards that were
mailed to

the organization for the procedure on the

REFERENCE_DATE.

ORDER_QTY NUMBER(4) Number of cards for this procedure mailed to the

organization.

ORG_ID NUMBER(4) Identifier of an organization and foreign key to the

ORGANIZATIONS table.

PROC_CARD_TYPE VARCHAR2(20) Identifies the procedure card type.

PROCEDURE_ID NUMBER(4) Identifier of a procedure and foreign key to the

PROCEDURES table.

REFERENCE_DATE DATE Date on which the system began counting cards for
this

procedure for the organization.

TABLE ORGANIZATIONS

DESCRIPTION Contains a list of organizations with system-generated
identifers and information

about the organizations.

COLUMN TYPE DEFINITION

FACILITY_TYPE VARCHAR2(30) Identifies the facility type (depot
maintenance center, air

station, etc.) for the organization.

ORG_CODE VARCHAR2(10) Code for this organization which is meaningful to
the end

user.

ORG_DESC VARCHAR2(30) Description of the organization.

ORG_ID NUMBER(4) Unique identifier for an organization and primary key
to this

table.

PARENT_ORG_ID NUMBER(4) Identifies the organization of which this
organization is a

subsidiary.

PATH VARCHAR2(49) Top-down list of the organization\'s ancestors,
beginning

with the topmost node and ending with itself. An auxilliary

column used to mofe through the organizational tree

structure.

PROCED_CARD_IND CHAR(1) Indicates (Y/N) if the organization is on the
mailing list to

receive maintenance procedure cards.

SEVERITY_FACTOR NUMBER(4) Number which is multiplied by actual flight
hours in order

to obtain equivalent flight hours. Equivalent flight hours

are used to measure relative wear and tear.

TABLE PARAMETERS

DESCRIPTION Contains information about maintenance processes.

COLUMN TYPE DEFINITION

DEFAULT_IND CHAR(1) Indicates (Y/N) if the parameter is automatically
associated

with any newly created component type.

PARAM_DESC VARCHAR2(30) Description of the parameter.

PARAM_ID NUMBER(2) Unique identifier of a parameter and primary key to
this

table.

PARAM_PROMPT VARCHAR2(15) Text which appears on the screen during
sign-off

requesting that a value be entered for the parameter.

PARAM_SHORT_NAME VARCHAR2(3) Abbreviated version of the parameter name.

TABLE PART_CLASS_MEMBERS

DESCRIPTION Associates a part class with each of its members, which may
be parts, part types,

or organizations.

COLUMN TYPE DEFINITION

ID NUMBER(4) Identifier of the part, part type, or organization which is
a

member of the class. PART_CLASS_ID, OBJECT_ID, ID is

the primary key of this table.

OBJECT_ID NUMBER(4) Identifier of the part type, organization, or part
which

determines membership for this part class.

PART_CLASS_ID NUMBER(4) Identifier of a part class.

TABLE PART_CLASS_PART_CODES

DESCRIPTION Contains a list of part codes (serial numbers) which are
potential members of a part

class which does not yet exist in the system. Associates each part class
with

each member part code.

COLUMN TYPE DEFINITION

PART_CLASS_ID NUMBER(4) Identifier of a part class and foreign key to
the

PART_CLASSES table.

PART_CODE VARCHAR2(15) Code which identifies a part (serial number).

PART_CLASS, PART_CODE is the primary key of this

table.

TABLE PART_CLASS_TASKS

DESCRIPTION Associates each part class with each of its members, which
may be parts, part

types, or organizations.

COLUMN TYPE DEFINITION

PART_CLASS_ID NUMBER(4) Identifier of a part class and foreign key to
the

PART_CLASSES table.

TASK_ID NUMBER(4) Identifier of a task and foreign key to the TASKS
table.

PART_CLASS_ID, TASK_ID is the primary key of this

table.

TABLE PART_CLASSES

DESCRIPTION Contains a list of part classes with system-generated
identifiers.

COLUMN TYPE DEFINITION

COMP_TYPE_ID NUMBER(2) Identifier of the component type for the part
class and

foreign key to the COMP_TYPES table.

LOGIC_COUNT NUMBER(1) Number of test (logic types) that apply to the
part class.

LOGIC_TYPE VARCHAR2(20) Logic type which applies to the part class
(equal to, not

equal to, etc.).

PART_CLASS_DESC VARCHAR2(30) Description of the part class.

PART_CLASS_ID NUMBER(4) Unique identifier of a part class and primary
key to this

table.

PRIORITY NUMBER(4) Integer indicating the level of importance of the
part class

in relation to other part classes. For instance, when a

component type is a member of more than one part class,

the part class with the lowest priority number is of highest

priority.

UPDATE_IND CHAR(1) Indicates (Y/N) if the part class may be updated. For

internal use only, to control recursion.

TABLE PART_COMMENTS

DESCRIPTION Contains system-generated or user-provided comments on
parts.

COLUMN TYPE DEFINITION

COMMENT VARCHAR2(350) Comment on the part.

COMMENT_DATE DATE Date on which the comment was made.

COMMENT_TYPE VARCHAR2(20) Identifies the type of comment.

ENTRY_DATE DATE Date on which the comment was entered into the system.

PART_ID, ENTRY_DATE is the primary key of this table.

FACILITY VARCHAR2(30) Name of the facility to which the comment applies.

PART_ID NUMBER(4) Identifier of a part and foreign key to the PARTS
table.

TABLE PART_LOCATIONS

DESCRIPTION For Mandatory Special Requirements use only (parts not
directly attached to an

assembly). Associates each part with general and specific locations and
the case

number (if any) on which it is currently deployed.

COLUMN TYPE DEFINITION

CASE_NUMBER VARCHAR2(10) Number of the case on which the part is now
deployed.

LOCATION_1 VARCHAR2(15) General location of the part.

LOCATION_2 VARCHAR2(15) Specific location of the part.

PART_ID NUMBER(4) Identifier of a part, foreign key to the PARTS table,
and

primary key of this table. For Mandatory Special

Requirements use only (parts not attached to an assembly).

TABLE PART_LOG_PARAMETERS

DESCRIPTION Associates each point of entry of an assemble with its age
in terms of its

parameters at the time of the log entry. Also associates any part of the
asssembly

for which maintenance was performed with its age in terms of its
tracking process.

COLUMN TYPE DEFINITION

ENTRY_PART_ID NUMBER(4) Identifier of the part at which the parameter
value was

entered.

LOG_ID NUMBER(4) Identifier of a log and foreign key to the LOGS table.

PARAM_ID NUMBER(4) Identifier of a parameter and foreign key to the

PARAMETERS table. LOG_ID, PART_ID, PARAM_ID is

the primary key of this table.

PARAM_VALUE NUMBER(4) Value of the parameter at the time specified in
the log.

PART_ID NUMBER(4) Identifier of a part and foreign key to the PARTS
table.

TABLE PART_LOGS

DESCRIPTION Associates each log with the parts (entry points) to which
each parameter applies.

COLUMN TYPE DEFINITION

LOG_ID NUMBER(4) Identifier of a log and foreign key to the LOGS table.

PART_ID NUMBER(4) Identifier of a part (entry point) and foreign key to
the

PARTS table. LOG_ID, PART_ID is the primary key of this

table.

TABLE PART_PARAMETERS

DESCRIPTION Associates each part with the current value of its relevant
parameters (e.g.,

landings, flight hours). The table does not infer part age in terms of
calendar time.

COLUMN TYPE DEFINITION

PARAM_ID NUMBER(2) Identifier of a parameter and foreign key to the

PARAMETERS table. PART_ID, PARAM_ID is the

primary key to this table.

PARAM_VALUE NUMBER(4) Present value of the parameter.

PART_ID NUMBER(4) Identifier of a part and foreign key to the PARTS
table.

UPDATE_IND CHAR(1) Indicates (Y/N) if the part class may be updated. For

internal use only, to control recursion.

TABLE PART_TASK_HISTS

DESCRIPTION Contains historical information about maintenance
transactions, with

system-generated part and task identifiers.

COLUMN TYPE DEFINITION

COMP_ID NUMBER(4) Identifier of the component to which the part belongs
and

foreign key to the COMPONENTS table.

HIST_ID NUMBER(2) Sequential identifier of a history record for a given
part/task

combination assigned by the system. PART_ID,

TASK_ID, HIST_ID is the primary key of this table.

INSTALL_SEQ NUMBER(2) Indicates the number of times a part has been
installed on a

higher assembly. Even numbered sequences (0.2.4.etc.)

indicate periods when the part was uninstalled; odd

numbered sequences indicate periods when the part was

installed on a higher assembly.

ITERATION NUMBER(2) Iteration number of the part task.

PARENT_PART_ID NUMBER(4) Identifier of the part to which this part is
connected.

PART_ID NUMBER(4) Identifier of the part and foreign key to the PARTS
table.

PART_TYPE_ID NUMBER(4) Identifier of the type for this part and foreign
key to the

PART_TYPES table.

SIGN_OFF_TYPE VARCHAR2(10) Identifies the type of sign-off (automatic or
manual) for the

part task.

STATUS VARCHAR2(20) Identifies the status of the part (installed, in
transit, etc.).

TASK_CATEGORY VARCHAR2(20) Identifies the category to which the part
task belongs.

TASK_ID NUMBER(4) Identifier of the task and foreign key to the TASKS
table.

TRANSACTION_ID NUMBER(4) Identifier of the transaction containing this
part tasks and

foreign key to the MAINT_TRANSACTIONS table.

TSO DATE Amount of time elapsed since the last overhaul of the part.

TABLE PART_TASK_LABOR_HISTS

DESCRIPTION Associates each execution of a given task on a given part
with each labor type

and the association number of person hours required to complete the
task.

COLUMN TYPE DEFINITION

HIST_ID NUMBER(2) Sequential identifier of a history record for a given
part/task

combination. PART_ID, TASK_ID, HIST_ID,

LABOR_TYPE_ID is the primary key of this table.

LABOR_TYPE_ID NUMBER(2) Identifier of the labor type employed and
foreign key to the

LABOR_TYPES table. PART_ID, TASK_ID, HIST_ID,

LABOR_TYPE_ID is the primary key of this table.

MANHOURS NUMBER(4) Number of manhours used to complete the task.

PART_ID NUMBER(4) Identifier of a part and foreign key to the PARTS
table.

TASK_ID NUMBER(4) Identifier of a task and foreign key to the TASKS
table.

TABLE PART_TASK_PARAMETERS

DESCRIPTION Lists the relevant paramters and their values for the last
execution of a given task

on a given part.

COLUMN TYPE DEFINITION

LAST_MAINT_VALUE NUMBER(4) Value of the parameter at the last
maintenance date for the

task.

PARAM_ID NUMBER(2) Identifier of a parameter and foreign key to the

PARAMETERS table. PART_ID, TASK_ID, PARAM_ID

is the primary key of this table.

PART_ID NUMBER(4) Identifier of a part and foreign key to the PARTS
table.

TASK_ID NUMBER(4) Identifier of a task and foreign key to the TASKS
table.

TABLE PART_TASKS

DESCRIPTION Contains a list of tasks associated with specific parts.

COLUMN TYPE DEFINITION

ACTIVE_IND CHAR(1) Indicates (Y/N) if the task is being scheduled at the
current

time.

CONTROL_USER VARCHAR2(20) Identifier of the user who last changed the
active indicator

from the system defined value.

ITERATION NUMBER(2) Sequence of the task. If there are multiple
intervals

scheduled for a task, this value dictates which interval is to

be used.

LAST_HIST_ID NUMBER(2) Identifier of the record in the PART_TASK_HISTS
table

containing the most recent execution of this task on this

part.

LAST_MAINT_DATE DATE Last date on which the task was performed on the
part.

PART_CLASS_ID NUMBER(4) Identifier of the class to which the part
belongs and foreign

key to the PART_CLASSES table.

PART_ID NUMBER(4) Identifier for a part and foreign key to the PARTS
table.

SUSPEND_DAYS NUMBER(2) Number of days that the part\'s assembly was
suspended

(removed from use) during the execution of the task.

TASK_ID NUMBER(4) Identifier of a task and foreign key to the TASKS
table.

PART_ID, TASK_ID is the primary key of the

PART_TASKS table.

UPDATE_IND CHAR(1) Indicates (Y/N) if the part class may be updated. For

internal use only, to control recursion.

TABLE PART_TYPES

DESCRIPTION Contains part type and part manufacturer information.

COLUMN TYPE DEFINITION

MANUFACTURER_ID NUMBER(4) Identifier of the manufacturer who sells this
part type.

PART_CATEGORY CHAR(20) Part category to which the part type belongs.

PART_TYPE_CODE CHAR(20) Identifier of this part type which is meaningful
to the end

user (the part number).

PART_TYPE_DESC VARCHAR2(30) Description of this part type.

PART_TYPE_ID NUMBER(4) Unique identifier for this part type and primary
key to this

table.

SELF_TEST_IND CHAR(1) Indicates (Y/N) if this part type has built-in
test equipment.

SERIALIZE_IND CHAR(1) Indicates (Y/N) if the part type is tracked by
serial number.

TABLE PARTS

DESCRIPTION Contains information about parts, including parent and
ancestor part identifiers,

the component type and identifier, and the organization and position
identifiers.

COLUMN TYPE DEFINITION

ACCEPT_DATE DATE Date on which this part was enrolled.

ANCESTOR_PART_ID NUMBER(4) Identifier of this part\'s ancestor (highest
component in the

assembly).

ASSEMBLY_IND CHAR(1) Indicates (Y/N) if this part is an assembly (top
node).

BAR_CODE VARCHAR2(9) Machine-scannable code enabling an optical scanner
to

identify this part.

COMP_ID NUMBER(4) Component identifier for this part and foreign key to
the

COMPONENTS table.

COMP_TYPE_ID NUMBER(2) Identifier of the component type for this part
and foreign

key to the COMP_TYPES table.

INSTALL_SEQ NUMBER(2) Number of times a part has been installed on a
higher

assembly. Even install sequence numbers (0,2,4,etc.)

indicate periods when the part was not installed; odd install

sequence numbers indicate periods when the part was

installed on a higher assembly.

MAJ_COMP_IND CHAR(1) Indicates (Y/N) if this part is a major component
(usually

level one and highly priced, along with other criteria).

ORG_ID NUMBER(4) Identifier of organization which owns this part and
foreign

key to the ORGS table.

PARENT_PART_ID NUMBER(4) Part identifier of this part\'s parent (next
higher assembly).

PART_CODE VARCHAR2(15) Code for this part which is meaningful to the
user (the serial

number).

PART_ID NUMBER(4) Unique identifier for a part and primary key of this
table.

PART_MONITOR_IND CHAR(1) Indicates (Y/N) if this part is component
monitored (very

closely tracked).

PART_TYPE NUMBER(4) Part type identifier for this part.

PATH VARCHAR2(49) Top-down list of this part\'s ascendants, beginning
with its

ancestor and ending with itself. An auxilliary column used

to move through the organizational tree structure.

POSITION_ID NUMBER(2) Identifier for the position of the component type
and

foreign key to the POSITIONS table.

STATUS VARCHAR2(20) Code which identifies the status of the part (ready
for issue,

installed, inactive, etc.).

TABLE POSITIONS

DESCRIPTION Contains a list of standard positions with system-generated
tables.

COLUMN TYPE DEFINITION

POSITION_CODE VARCHAR2(4) Code for the position which is meaningful to
the end user.

POSITION_DESC VARCHAR2(30) Description of the position.

POSITION_ID NUMBER(2) Unique identifer of a position and primary key of
this table.

TABLE PROC_CLASS_MEMBERS

DESCRIPTION Associates each procedure class with its procedure members.

COLUMN TYPE DEFINITION

PROC_CLASS_ID NUMBER(2) Identifier of a procedure class.

PROCEDURE_ID NUMBER(4) Identifier of a procedure and foreign key to the

PROCEDURES table. PROC_CLASS_ID, PROCEDURE_ID

is the primary key of this table.

TABLE PROCEDURE_CLASSES

DESCRIPTION Contains procedure classes which group procedures performed
at a particular

organization with system-generated identifiers. Air station and depot
procedures

can overlap.

COLUMN TYPE DEFINITION

PROC_CLASS_ID NUMBER(4) Unique identifier for a procedure class and
primary key of

this table.

PROCEDURE_CLASS VARCHAR2(30) Description of the procedure class.

TABLE PROCEDURE_REVS

DESCRIPTION Associates each procedure with its last date of revision.

COLUMN TYPE DEFINITION

PROCEDURE_ID NUMBER(4) Identifier of a procedure and foreign key to the

PROCEDURES table.

REV_DATE DATE Date on which the procedure was last revised.

TABLE PROCEDURES

DESCRIPTION Contains information about maintenance transactions.

COLUMN TYPE DEFINITION

ASSEMBLY_TYPE VARCHAR2(20) Identifies the type of assembly, or top node,
for the

procedure.

PROCED_TEXT_CODE VARCHAR2(8) Mandatory Special Requirements only - The
number

identifying the instruction portion of the procedure card.

PROCEDURE_CODE VARCHAR2(8) Code for the procedure which is meaningful to
the end user.

PROCEDURE_ID NUMBER(4) Unique identifier for the procedure and primary
key to this

table.

REVISION_DATE DATE Date when the procedure was last revised.

TABLE SUSPENSIONS

DESCRIPTION Identifies each part that has been suspended from service
due to defects. When a

part is suspended, the parameter \"calendar time\" is stopped for the
part and any

of its descendants.

COLUMN TYPE DEFINITION

END_DATE DATE End date of the suspended time for the part.

PART_ID NUMBER(4) Identifier of a part and foreign key to the PARTS
table.

START_DATE DATE Start date of the suspended time for the part. PART_ID,

START_DATE is the primary key of this table.

TABLE TASK_CAT_REASONS

DESCRIPTION Associates each task category with every task reason that
legally justifies the

performance of tasks for that category.

COLUMN TYPE DEFINITION

TASK_CAT_ID NUMBER(1) Unique identifier for a task category and primary
key to this

table.

TASK_REASON_ID NUMBER(2) Identifier of the reason for the task category
and foreign

key to the TASK_REASONS table. TASK_CAT_ID,

TASK_REASON_ID is the primary key of this table.

TABLE TASK_CAT_TYPES

DESCRIPTION Associates each task category with every task reason that
legally justifies the

performance of tasks for that category.

COLUMN TYPE DEFINITION

TASK_CAT_ID NUMBER(1) Identifier for a task category and foreign key to
the

TASK_CATEGORIES table.

TASK_TYPE_ID NUMBER(2) Identifier for a task type and foreign key to the

TASK_TYPES table. TASK_CAT_ID, TASK_TYPE_ID is

the primary key of this table.

TABLE TASK_CATEGORIES

DESCRIPTION Assigns a system-generated identifier to text descriptions
of each task category.

For example, the task category \"clean\" would include any task types
containing a

clean procedure (clean, clean/inspect, etc.).

COLUMN TYPE DEFINITION

TASK_CAT_DESC VARCHAR2(30) Description of the task category.

TASK_CAT_ID NUMBER(1) Unique identifier for a task category and primary
key to this

table.

TABLE TASK_CLASS_TASKS

DESCRIPTION Associates each task with each of its member tasks.

COLUMN TYPE DEFINITION

TASK_CLASS_ID NUMBER(2) Identifier for a task class and foreign key to
the

TASK_CLASSES table.

TASK_ID NUMBER(4) Identifier for a task and foreign key to the TASKS
table.

TASK_CLASS_ID, TASK_ID is the primary key of this

table.

TABLE TASK_CLASSES

DESCRIPTION Assigns a system-generated identifier to each task class
(group of tasks which

users may create for any reason).

COLUMN TYPE DEFINITION

TASK_CLASS_DESC CHAR(30) Description of the task class.

TASK_CLASS_ID NUMBER(1) Unique identifier for a task class and primary
key to this

table.

TABLE TASK_LABOR_TYPES

DESCRIPTION Associates each task with the labor type(s) and person hours
required for its

execution.

COLUMN TYPE DEFINITION

LABOR_TYPE_ID NUMBER(2) Identifier of a labor type and foreign key to
the

LABOR_TYPES table. TASK_ID, LABOR_TYPE_ID is the

primary key of this table.

MANHOURS NUMBER(4) Number of manhours of the labor type used to execute
the

task.

TASK_ID NUMBER(4) Identifier of a task and foreign key to the TASKS
table.

TABLE TASK_PARAMETERS

DESCRIPTION Specifies how often each task will be performed based on a
given parameter, part

class, and range of iteration values. Associates each range of iteration
values

with the parameter values with the parameter value for aging of the
part.

COLUMN TYPE DEFINITION

END_ITERATION NUMBER(2) Parameter value for the last iteration of the
task.

INTERVAL NUMBER(4) Maintenance scheduling interval expressed in terms of
the

parameter. This value dictates how often the task is

performed.

INTERVAL_EXTENSION NUMBER(4) In terms of the parameter the amount of
leeway (additional

aging of the part in question) permitted when scheduling

the task referred to by this task.

PARAM_ID NUMBER(2) Identifier of a parameter and foreign key to the

PARAMETERS table.

PART_CLASS_ID NUMBER(4) Identifier of a part class and foreign key to
the

PART_CLASSES table.

START_ITERATION NUMBER(2) Parameter value for the first iteration of the
task. TASK_ID,

PARAM_ID, PART_CLASS_ID, START_ITERATION is

the primary key of the table.

TASK_ID NUMBER(4) Identifier of a task and foreign key to the TASKS
table.

TABLE TASK_REASONS

DESCRIPTION Assigns system-generated identifiers to task reasons
(justifications for the

execution of a task).

COLUMN TYPE DEFINITION

TASK_REASON VARCHAR2(30) Statement of the reason for the task.

TASK_REASON_CODE VARCHAR2(4) Code for the task reason which is
meaningful to the end

user.

TASK_REASON_ID NUMBER(2) Unique identifier for a task reason and primary
key to this

table.

TABLE TASK_TYPE_STATUS

DESCRIPTION Associates a given status (e.g., installed, uinstalled,
etc.) with the task types that

my legally be peformed on a component having that status.

COLUMN TYPE DEFINITION

STATUS_ID NUMBER(2) Identifies a given status (installed, uninstalled,
etc.) with

the task types which may be legally performed on a

component having that status. TASK_TYPE_ID,

STATUS_ID is the primary key of this table.

TASK_TYPE_ID NUMBER(2) Identifier of a task type and foreign key to the

TASK_TYPES table.

TABLE TASK_TYPES

DESCRIPTION Contains a list of task types with system-generated
identifiers.

COLUMN TYPE DEFINITION

TASK_TYPE VARCHAR2(20) Specific maintenance procedure performed during
part

maintenance (clean, remove/install, inspect, overhaul, etc.).

TASK_TYPE_ID NUMBER(2) Unique identifer for a task type and primary key
to this

table.

TABLE TASKS

DESCRIPTION Contains information about maintenance tasks by task type,
position, primary

labor type, and procedure.

COLUMN TYPE DEFINITION

ACTIVE_IND CHAR(1) Indicates (Y/N) if the task is currently being
scheduled for

maintenance.

CREATE_DATE DATE Date on which this task was created.

DEFAULT_IND CHAR(1) Indicates (Y/N) if task is performed on every member
of the

referenced component type.

INIT_FACTOR NUMBER(4) Number of intervals to subtract from the current
parameter

value of a part when initializing the task.

MODIFY_DATE DATE Date on which this task was last modified.

PDM_IND CHAR(1) Indicates (Y/N) if the task is performed during periodic

depot maintenance.

POSITION_ID NUMBER(2) Identifier for the position of the component type
and

foreign key to the POSITIONS table.

PRI_LABOR_TYPE_ID NUMBER(2) Unique identifier for the primary labor type
(electrician,

mechanic, etc.) needed to complete the task. Foreign key to

the LABOR_TYPES table.

PROCEDURE_CODE VARCHAR2(8) Code for the procedure which is meaningful to
the end user.

PROCEDURE_ID NUMBER(4) Unique identifier of the procedure card
containing this task.

Foreign key to the PROCEDURES table.

RESTRICT_STAT_IND CHAR(1) Indicates (Y/N) if the task sign-off is
restricted to a certain

group of users.

REVISION_DATE DATE Date on which the task procedure was last revised.

SCHED_METHOD VARCHAR2(20) Identifies the scheduling method (on
condition, scheduled,

one time, etc.) of the task.

SERIAL_TRACKED_IND CHAR(1) Indicates (Y/N) if component type on which
the task is

performed is serial tracked. For remove/install tasks Y

indicates the component type is the item being worked on;

N indicates the work is performed on one of the component

type\'s descendants.

SERIES_APPL_IND CHAR(1) Indicates (Y/N) if task is associated with at
least one part

class (series).

SUSPEND_IND CHAR(1) Indicates (Y/N) if the component type on which the
task is

performed is suspended during execution of the task.

TASK VARCHAR2(30) Description of the task.

TASK_CODE VARCHAR2(6) Code for the task which is meaningful to the user.

TASK_DESC VARCHAR2(140) Description of the task.

TASK_ID NUMBER(4) Unique identifier of the task and primary key of this
table.

TASK_SOURCE VARCHAR2(4) Code which identifies the origin of the
currently referenced

task (TCTO, ACMS, or service bulletin).

TASK_TYPE_ID NUMBER(2) Unique identifier of the task type (clean,
inspect, etc.) and

foreign key to the TASK_TYPES table.

WORK_AREA VARCHAR2(2) General area on the assembly where the task is
performed.

TABLE TCTONOZTAB

DESCRIPTION Time Compliance Technical Order (TCTO) Numbering Table.
Tracks a given order

to do a specific, one-time repair of change to a certain item or class
of times from

origination until it is entered into the system as a task.

COLUMN TYPE DEFINITION

ARSCMAIL1 DATE Date on which ARSC finished with the TCTO and mailed it

to EAE (Aeronautical Engineering).

ARSCMAIL2 DATE Date on which ARSC mailed the TCTO to ACMS.

ARSCRECV1 DATE Date on which ARSC (Aircraft Repair and Supply Center)

received the TCTO.

ARSCREV2 DATE Date on which ARSC received the TCTO from EAE.

ATAZCHAPTER NUMBER(4) Airline Transportation Association Chapter. A
2-letter

code used in the process of building TCTO numbers; part

of the TCTO type code.

DRAFTER VARCHAR2(25) Name of the person who drafts the TCTO, thereby

beginning the tracking process.

EAERECV DATE Date on which EAE received the TCTO, after it has been

drafted.

EAERECYCL CHAR(1) Indicates (Y/N) if EAE sent the TCTO on to ARSC or
sent it

back to restart the process.

MRLZDATEE DATE Date on which the TCTO was entered into the system, after

completion of the tracking process.

ORIGINATOR VARCHAR2(15) Person who determined that the TCTO is needed.

ORIGINZDATE DATE Date on which the TCTO was originated.

RECPNTR NUMBER(4) Record pointer; flag to indicate where on the screen
the

user left off in the tracking process.

SUBTYPZCODE VARCHAR2(3) Subtype of the TCTO type code.

TCTOCOMPLZDATE DATE Date on which the entire process is completed. This
date

cannot be entered until mrl date. After this time the TCTO

can no longer be changed.

TCTOTYPZCODE CHAR(1) Indicates the type of assembly on which the TCTO is

performed. TCTOZNO, TCTOTYPZCODE is the primary

key of this table.

TCTOZNO NUMBER(4) Identifies a Time Compliance Technical Order (order to
do a

specific, one-time repair or change to a certain item or class

of items within a certain amount of time) from origination

until it is entered into the system as a task.

TCTOZTITLE VARCHAR2(25) Description of the TCTO.

VOIDED CHAR(1) Indicates (Y/N) if the TCTO number is still being used.
(If a

TCTO is not being used, it isn\'t included on reports.)

*MODULE* *Logistics*

*DESCRIPTION* *The logistics module of C-AMIS captures the registration
number and other identification*

*and contact information for Government aircraft. The module also
captures flight and*

*flight leg information, with particular emphasis on Senior or Special
Category travel. It*

*records information about flight purposes, passengers and passenger
types, and the*

*purpose of travel. It assists in travel planning, including the
planning of Senior*

*Federal/Special Category travel, providing Government pay rates and
using Government*

*and commercial cost information such as flight rate per hour, charter
costs, and scheduled*

*airline ticket costs to minimize travel expenditures. In addition, the
module supports flight*

*planning using crew duty hour and certification information, and
captures actual crew*

*and passenger flight leg usage information. Module information in the
C-AMIS database*

*will be reported and/or displayed to assist the logistics manager.*

TABLE CREW_MEMBERS_ON_FLIGHT_LEG

DESCRIPTION Records crew members flying a particular flight leg by
agency and organizaton.

COLUMN TYPE DEFINITION

EXEC_AGENCY_SEQ NUMBER(4) Unique identifies for an executive agency and
foreign key

to the EXECUTIVE_AGENCY table.

FLIGHT_ID NUMBER(7) Identifier for the flight and foreign key to the
FLIGHTS

table. FLIGHT_ID, FLIGHT_LEG_ID, PERSON_ID is the

primary key of this table.

FLIGHT_LEG_ID NUMBER(2) Identifier of flight leg and foreign key to the
FLIGHT_LEGS

table.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau and
foreign

key to the ORGANIZATION_CODES table.

PERSON_ID NUMBER(7) Identifier for a person and foreign key to the
PERSONS

table.

ROLE VARCHAR2(10) Code which identifies a role for the crew member and

foreign key to the ROLES table.

TABLE EACH_FLIGHT_LEGS_PASSENGERS

DESCRIPTION Details passengers and travel purposes by flight leg.

COLUMN TYPE DEFINITION

CHARTER_COST NUMBER(8) Passenger share of charter cost for the flight
leg.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

FLIGHT_ID NUMBER(7) Identifier for the flight and foreign key to the
FLIGHTS

table. FLIGHT_ID, FLIGHT_LEG_ID, PASSENGER_ID is

the primary key of this table.

FLIGHT_LEG_ID NUMBER(2) Identifier for the flight leg and foreign key to
the

FLIGHT_LEGS table.

GOV_COST NUMBER(7,2) Cost to the Government of the passenger\'s flight
leg.

MANIFEST_ID NUMBER(7) Identifier of the passenger manifest for the
flight leg and

foreign key to the PASSENGER_MANIFEST table.

ORG_CODE VARCHAR2(8) Code which identifies the service/offfice/bureau
and

foreign key to the ORGANIZATION_CODES table.

PASS_TYPE VARCHAR2(10) Code which defines the type of passenger.

PASSENGER_ID NUMBER(7) Identifier for the passenger and foreign key to
the

PASSENGERS table.

REIMB_AMT NUMBER(7,2) Reimbursement amount for the passenger.

SCHED_AL_COST NUMBER(7,2) Scheduled airline cost for the passenger.

TABLE FLIGHT_CREW_DUTY_TIMES

DESCRIPTION Details individually the hours worked on a flight by the
crew members.

COLUMN TYPE DEFINITION

COST_OVERTIME NUMBER(6,2) Cost of overtime on the flight for the crew
member.

COST_REG_TIME NUMBER(6,2) Cost of regular time on the flight for the
crew member.

DUTY_END DATE Date and time duty ended for the crew member.

DUTY_START DATE Date and time duty started for the crew member.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

FLIGHT_ID NUMBER(7) Identifier for the flight and foreign key to the
FLIGHTS

table. FLIGHT_ID, PERSON_ID is the primary key of this

table.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau and
foreign

key to the ORGANIZATION_CODES table.

OVERTIME_HRS NUMBER(5,2) Number of hours of overtime for the crew
member.

PERSON_ID NUMBER(7) Identifier of the crew member and foreign key to the

PERSONS table. FLIGHT_ID, PERSON_ID is the primary

key of this table.

REG_TIME_HRS NUMBER(5,2) Number of regular time hours for the crew
member.

TABLE FLIGHT_LEGS

DESCRIPTION Contains information about flight legs by agency,
organization, and flight.

COLUMN TYPE DEFINITION

AGENCY_FUEL CHAR(1) Indicates (Y/N) if agency fuel was used for the
flight leg.

CARGO_IN_LBS NUMBER(7) Weight of the cargo for the flight leg in pounds.

DEP_IN_CHARGE VARCHAR2(12) Deputy in charge for the flight leg.

DUTY_END DATE End date and time of crew duty hours for the flight leg.

DUTY_HRS NUMBER(5,2) Crew duty hours for the flight leg.

DUTY_START DATE Start date and time of crew duty hours for the flight
leg.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for an executiver agency and
foreign key

to the EXECUTIVE_AGENCY table.

FLIGHT_ID NUMBER(7) Identifier of the flight and foreign key to the
FLIGHTS table.

FLIGHT_ID, FLIGHT_LEG_ID are the primary key to this

table.

FLIGHT_TIME NUMBER(5,2) Flight time in hours.

FUEL_COST NUMBER(5,2) Cost per gallon of the fuel purchased for the
flight leg.

FUEL_LANDING NUMBER(7,2) Pounds of fuel at landing for the flight leg.

FUEL_PURCH NUMBER(7,2) Gallons of fuel purchased for the flight leg.

FUEL_TAKEOFF NUMBER(7,2) Pounds of fuel at takeoff for the flight leg.

HOBBES_END DATE End date and time of Hobbes metering of the flight leg.

HOBBES_READ NUMBER(8) Hobbes meter reading for the flight leg.

HOBBES_START DATE Start date and time of the Hobbes metering of the
flight leg.

LEAD_DEPUTY VARCHAR2(12) Lead deputy for the flight leg.

LOC_DESTIN VARCHAR2(4) Code which identifies the location of the
destination airfield

for the flight leg and foreign key to the

AIRFIELD_LOCATIONS table.

LOC_ORIGIN VARCHAR2(4) Code which identifies the location of the
originating airfield

for the flight leg and foreign key to the

AIRFIELD_LOCATIONS table.

MISSION_SEQ NUMBER(5) Code which identifies the mission for the flight
leg and

foreign key to the MISSION table.

NAUT_MILES NUMBER(5) Number of nautical miles for the flight leg.

NOTES VARCHAR2(100) Pertinent notes on the flight leg.

ORDER_NO VARCHAR2(25) Records order or dispatch record number for the
flight leg.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau and
foreign

key to the ORGANIZATION_CODES table.

PASS_SEATS NUMBER(3) Number of passenger seats for the flight leg.

PASS_TOTAL NUMBER(3) Total number of passengers for the flight leg.

PAY_ITEM_CODE VARCHAR2(5) Code which identifies the pay item associated
with the fuel

purchase and foreign key to the PAY_ITEM_CODES

PILOT_FLYING VARCHAR2(12) Name of the pilot for the flight leg.

POSTED CHAR(1) Indicates (Y/N) that the transaction has been posted.

PROJECT VARCHAR2(20) Name of the project associated with the flight leg.

SIGNED_RECVD VARCHAR2(25) Records who has signed for receiving cargo for
the flight

leg.

TIME_ARRIV DATE Date and time of arrival at the destination for the
flight leg.

TIME_DEPART DATE Date and time of departure for the flight leg.

WORK_ORD_NO VARCHAR2(25) Work order number associated with the flight
leg.

TABLE FLIGHT_PURPOSES

DESCRIPTION Contains flight purpose codes and descriptions.

COLUMN TYPE DEFINITION

FLIGHT_PURP CHAR(1) Code which indicates the purpose of the flight and
primary

key of this table.

PURPOSE_DESC VARCHAR2(150) Description of the purpose of the flight.

TABLE FLIGHTS

DESCRIPTION Contains information about flights by agency, organization,
aircraft, and

agreement.

COLUMN TYPE DEFINITION

AGREEMENT_ID NUMBER(7) Identifier of the agreement by which the flight
is provided

and foreign key to the

AGREEMENTS_AND_CONTRACTS table.

AIRCRAFT_SEQ NUMBER(7) Aircraft identifier and foreign key to the

FLEET_AIRCRAFT table.

CHART_COST NUMBER(7,2) Charter cost of the flight.

COMMENTS VARCHAR2(2000) Comments pertinent to the flight.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

FLIGHT_DATE DATE Date and time of the flight.

FLIGHT_ID NUMBER(7) Identifier for the flight and primary key of this
table.

FLIGHT_NO VARCHAR2(15) Flight number designation for the flight.

FLIGHT_PURP CHAR(1) Code which identifies the purpose of the flight and
foreign

key to the FLIGHT_PURPOSES table.

FLIGHT_RATE NUMBER(7,2) Flight rate to be used.

MISSION_SEQ NUMBER(5) Unique identifier for the mission of the flight
and foreign

key to the MISSSION table.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau and
foreign

key to the ORGANIZATION_CODES table.

REGIS_NO VARCHAR2(9) Unique identification mark or \"tail number\"
(usually

numbers and letters) displayed on Government aircraft \--

including foreign aircraft hired as CAS.

SCHEDULER NUMBER(7) Identifier for the flight scheduler and foreign key
to the

PERSONS table.

STAY_OVER CHAR(1) Indicates (Y/N) if the flight involves a stay over.

VARIABLE_COST NUMBER(7,2) Variable cost of the flight.

WEATH_BRIEF CHAR(1) Indicates (Y/N) if there is a weather briefing for
the flight.

TABLE PASS_SUMRY_ON_EACH_FLIGHT_LEG

DESCRIPTION Contains a count of passengers by passenger type on flight
legs.

COLUMN TYPE DEFINITION

COUNT NUMBER(4) Passenger count for the passenger type on the flight
leg.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for an executive agency and
foreign key to

the EXECUTIVE_AGENCY table. AGENCY_CODE,

ORG_CODE, FLIGHT_ID, FLIGHT_LEG_ID,

PASSENGER_TYPE make up the primary key to this table.

FLIGHT_ID NUMBER(7) Identifier of the flight and foreign key to the
FLIGHTS table.

FLIGHT_LEG_ID NUMBER(2) Identifier of the flight leg and foreign key to
the

FLIGHT_LEGS table.

ORG_CODE CHAR(8) Code which identifies the service/office/bureau and
foreign

key to the ORGANIZATION_CODES table.

PASS_TYPE CHAR(10) Code which identifies the passenger type and foreign
key

to the PASSENGER_TYPES table.

TABLE PASSENGER_MANIFEST

DESCRIPTION Details the passengers and purposes for travel for a flight.

COLUMN TYPE DEFINITION

AGENCY_CODE CHAR(2) Code which identifies the department or agency and
foreign

key to the AGENCY_CODES table.

CHART_COST NUMBER(7,2) Passenger\'s share of the charter cost for the
flight.

FLIGHT_ID NUMBER(7) Identifer for the flight and foreign key to the
FLIGHTS

table.

GOV_COST NUMBER(7,2) Cost to the Government of the passenger\'s flight.

MANIFEST_ID NUMBER(7) Unique identifer of the manifest record and
primary key of

this table.

NOTES VARCHAR2(2000) Contains pertinent information on the flight and/or
the

passenger.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau and
foreign

key to the ORGANIZATION_CODES table.

PASSENGER_ID NUMBER(7) Identifier for the passenger and foreign key to
the

PASSENGERS table.

REIMB_AMT NUMBER(7,2) Reimbursement amount for the passenger.

SCHED_AL_COST NUMBER(7,2) Scheduled airline cost for the passenger\'s
fllight.

TRAV_PURPOSE VARCHAR2(3) Code which defines the passenger\'s travel
purpose and

foreign key to the PURPOSE_OF_TRAVEL_CODES.

UNIQUE_ID VARCHAR2(30) Unique Government ID for the passenger.

TABLE PASSENGER_TYPES

DESCRIPTION Defines and describes the types of passengers.

COLUMN TYPE DEFINITION

PASS_TYPE VARCHAR2(10) Code which defines the type of passenger and
primary key

of this table.

PROMPT_PERM CHAR(1) Indicates (Y/N) if there should be a prompt for
permission.

TYPE_DESC VARCHAR2(25) Description of the passenger type.

TABLE PASSENGERS

DESCRIPTION Contains information about passengers on a Senior Federal or
Special Category

travel flight.

COLUMN TYPE DEFINITION

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for the executive agency of
the passenger

and foreign key to the EXECUTIVE_AGENCY table.

NAME_FIRST VARCHAR2(15) First name of the passenger.

NAME_LAST VARCHAR2(15) Last name of the passenger.

NAME_MIDDLE VARCHAR2(15) Middle name of the passenger.

ORG_CODE VARCHAR2(8) Code which identifies the service/office/bureau to
which

the passenger belongs and foreign key to the

ORGANIZATION_CODES table.

PASS_TYPE VARCHAR2(10) Code which identifies the type of passenger and
foreign

key to the PASSENGER_TYPES table.

PASSENGER_ID NUMBER(7) Unique identifier for the passenger and primary
key of this

table.

SALARY NUMBER(8,2) Salary of the passenger.

SES CHAR(1) Indicates (Y/N) if the passenger is an SES.

UNIQUE_ID VARCHAR2(30) Unique Government ID for the passenger.

WEIGHT NUMBER(3) Weight of the passenger.

TABLE PURPOSE_OF_TRAVEL_CODES

DESCRIPTION Contains purpose of travel codes and descriptions.

COLUMN TYPE DEFINITION

PURPOSE_DESC VARCHAR2(60) Description of the travel purpose.

TRAV_PURPOSE CHAR(3) Code which identifies the travel purpose.

TABLE ROLES

DESCRIPTION Contains information about roles available for crew members.

COLUMN TYPE DEFINITION

ROLE VARCHAR2(10) Role played by a crew member on a flight and primary
key

of this table.

ROLE_DESC VARCHAR2(20) Description of the role.

TABLE SENIOR_TRAVEL_FLIGHTS

DESCRIPTION Contains information about flights involving Senior Federal
or Special Category

travel.

COLUMN TYPE DEFINITION

AIRFIELD_CODE VARCHAR2(4) ICAO code, or other code established by the
agency, for

the departure point or destinaton of the aircraft. Foreign

key to the AIRFIELD_LOCATIONS table.

DEPART_TIME DATE Date and time of the take-off (24-hour format) for the
first

leg of the flight.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier of an executive agency and
foreign key to

the ORGANIZATION_CODES table.

FLIGHT_ID NUMBER(7) Unique identifier for the flight and primary key of
this table.

FLIGHT_NO VARCHAR2(10) Number assigned to the flight.

FLIGHT_PURPOSE CHAR(1) Code identifying the reason the aircraft was
dispatched on

the leg of the flight. (M = conduct agency\'s official

responsibilities; R = communications, security needs, or

exceptional scheduling requirements; T = other.)

MODEL_SEQ NUMBER(5) Unique identifier for the make and model of the
aircraft and

foreign key to the MODEL_OF_AIRCRAFT table.

ORG_CODE VARCHAR2(8) Code which identifies the bureau/office/service and
foreign

key to ORGANIZATION_CODES table.

REGIS_NO CHAR(9) Unique identification mark or \"tail number\" (usually

numbers and letters) displayed on Government aircraft \--

including foreign aircraft hired as CAS.

SCHED_FAX VARCHAR2(20) The fax number for the scheduler.

SCHED_ID NUMBER(7) Unique identifier for the scheduler of the flight and
foreign

key to the PERSONS table.

SCHED_PHONE VARCHAR2(20) Phone number for the scheduler.

SCHED_TITLE VARCHAR2(20) Official title of the person scheduling the
flight.

SERIAL_NO VARCHAR2(15) Manufacturer-assigned serial number of the
aircraft.

TABLE SFT_AIRCRAFT

DESCRIPTION Contains information about aircraft used for Senior Federal
or Special Category

travel.

COLUMN TYPE DEFINITION

AIRCRAFT_SEQ NUMBER(8) Unique identifier of the Senior Federal Travel
(SFT) aircraft

and primary key of this table.

MODEL_SEQ NUMBER(5) Unique identifier for the make and model of the
aircraft and

primary key to this table.

REGIS_NO VARCHAR2(6) Unique identification mark or \"tail number\"
(usually

numbers and letters) displayed on Government aircraft \--

including foreign aircraft hired as CAS.

SERIAL_NO VARCHAR(15) Manufacturer assigned serial number of the
aircraft.

VAR_COST_HR NUMBER(8) Variable cost per hour of the aircraft.

*MODULE* *Training*

*DESCRIPTION* *The training module of C-AMIS captures employee
identification, labor category, and*

*hourly rate information. The module also captures school and
certification information,*

*flight hours information for the pilot in command and second in
command, and employee*

*qualification information. The module periodically updates training
information, and*

*reports on the currency of takeoffs and landings, IFR approaches, and
inoculations. In*

*addition, the module tracks check ride requirements, physical due
dates, and monthly and*

*annual flight times by crew. Module information in the C-AMIS database
will be reported*

*and/or displayed to assist the training manager.*

TABLE CREW_CERTIFICATIONS

DESCRIPTION Contains information about roles certified for individual
crew members.

COLUMN TYPE DEFINITION

CERTIF_NO VARCHAR2(20) Certification number for the crew certification.

EXPIRATION DATE Date on which the certification expires.

TABLE CREW_CERTS_ON_EACH_FLIGHT_LEG

DESCRIPTION Counts crew certifications by type for a particular flight.

COLUMN TYPE DEFINITION

CERT_TYPE NUMBER(4) Identifier of the certification type and foreign key
to the

TYPES_OF_CERTIFICATION table. PERSON_ID,

FLIGHT_ID, FLIGHT_LEG_ID, CERT_TYPE is the primary

key of this table.

COUNT NUMBER(3) Count of certifications for the flight leg and
certification

type.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier of an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

FLIGHT_ID NUMBER(7) Identifier of the flight and foreign key to the
FLIGHTS table.

FLIGHT_LEG_ID NUMBER(2) Identifier of the flight leg and with FLIGHT_ID
the foreign

key to the FLIGHT_LEGS table.

ORG_CODE VARCHAR2(8) Code which identifies the sevice/office/bureau and
foreign

key to the ORGANIZATION_CODES table.

PERSON_ID NUMBER(5) Identifier for a person and foreign key to the
PERSONS

table.

UNIT_MEASURE VARCHAR2(15) Unit of measure for the certification.

TABLE PERSON_QUALS

DESCRIPTION Associates a person with the specific qualifications he or
she has attained.

COLUMN TYPE DEFINITION

PERSON_ID NUMBER(7) Identifier for a person and foreign key to the
PERSONS

table.

QUAL_CATEGORY VARCHAR2(25) Categories = Physical, Bi-Annual Flight
Review, Check

Ride, Landings/Takeoffs, IFR Approaches, Innoculations.

QUAL_DATE DATE Date of qualification event.

QUAL_NO NUMBER(3) Qualification identifier sequentially assigned by the

system. PERSON_ID, QUAL_NO is the primary key of this

table.

QUAL_TYPE VARCHAR2(25) Qualification type = type of check ride, or

type of inoculation.

TABLE PERSON_SCHOOLS

DESCRIPTION Associates a person with the schools where he or she has
received certificates.

COLUMN TYPE DEFINITION

CERT_DATE DATE Date of certification.

CERT_DESC VARCHAR2(30) Description of the certification.

CERT_TYPE VARCHAR2(20) Type of certification granted by the ground
school.

GROUND_SCHOOL_ID NUMBER(4) Identifier of the ground school and foreign
key to the

SCHOOLS table.

PERSON_ID NUMBER(7) Identifier of a person and foreign key to the
PERSONS

table.

SCHOOL_NO NUMBER(2) Sequential school identifier assigned by the system.

PERSON_ID, SCHOOL_NO is the primary key of this table.

TABLE SCHOOLS

DESCRIPTION Contains the address and other information about schools
which provide

certification.

COLUMN TYPE DEFINITION

ADDR1 VARCHAR2(30) First line of school address.

ADDR2 VARCHAR2(30) Second line of school address.

CITY VARCHAR2(18) City where school is located.

SCHOOL_ID NUMBER(4) Unique identifier of a school and primary key of
this table.

SCHOOL_NAME VARCHAR2(30) Name of the school.

SCHOOL_TYPE VARCHAR2(20) Type of school.

STATE_CODE CHAR(2) Code which identifies a state and foreign key to the

STATE_CODES table.

ZIP VARCHAR2(9) ZIP code for the school.

TABLE TYPES_OF_CERTIFICATION

DESCRIPTION Defines and describes the types of certification.

COLUMN TYPE DEFINITION

CERT_TYPE NUMBER(4) Unique identifier for the certification type and
primary key

of this table.

TYPE_DESC VARCHAR2(30) Description of the certification type.

*MODULE* *Contract Support and Acquisition*

*DESCRIPTION* *The contract support and acquisition module of C-AMIS
captures agreement identification*

*information, including mission, aircraft make and model, and cost
information for the*

*aircraft and pilot. The module also captures service descriptions and
costs, vendor*

*information, and agreement contact information. The module periodically
updates the*

*current status of contract support and acquisition information, and
summarizes contract*

*information by agreement type and region. Module information in the
C-AMIS database*

*will be reported and/or displayed to assist the contract support and
acquisition manager.*

TABLE AGREEMENT_DETAILS

DESCRIPTION Contains detailed information about contract items in an
agreement.

COLUMN TYPE DEFINITION

AGREEMENT_ID NUMBER(7) Unique identifier for the agreement and foreign
key to the

AGREEMENTS_AND_CONTRACTS table.

AIRCRAFT_SEQ NUMBER(7) Identifier of the aircraft provided by the
agreement and

foreign key to the FLEET_AIRCRAFT table.

ANNOTATIONS VARCHAR2(2000) Contains comments and remarks on the
provisions of the

contract item covered by this record.

AVAIL_RATE NUMBER(7,2) Minimum daily charge assessed the Government for

guaranteed availability under the agreement.

CONTR_ITEM_NO VARCHAR2(10) Identifies the contract item described in
this record.

DETAIL_ID NUMBER(7) Unique identifier for this record and the primary
key of this

table.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier of an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

HB_CODE VARCHAR2(16) Code which identifies the home base of the aircraft
and

foreign key to the HOME_BASES table.

ORG_CODE VARCHAR2(8) Code identifying the service/office/bureau entering
into the

agreement and foreign key to the

ORGANIZATION_CODES table.

OVRNIGHT_CHRG NUMBER(7,2) The per diem cost for each crew member
specified by the

agreement.

PILOT_CHARGE NUMBER(7,2) The cost provided by the agreement for an
additional pilot

or crew member not covered in the flight rate.

RATE_PER_DAY NUMBER(7,2) Fixed rate per day for an aircraft provided by
the agreement.

RATE_PER_HR NUMBER(7,2) The flight rate per hour which the Government
agrees to

pay under the agreement.

RATE_PER_MO NUMBER(7,2) Fixed rate per month for the aircraft as
provided by the

agreement.

STNDBY_PER_HR NUMBER(7,2) Standby rate per hour for the aircraft as
provided by the

agreement.

TABLE AGREEMENT_TYPE

DESCRIPTION Stores the acceptable values for types of commercial
aviation services in support

of an executive agency.

COLUMN TYPE DEFINITION

AGREE_TYPE_SEQ NUMBER(3) Unique identifier of an agreement type and
primary key to

this table.

AGREEMENT_TYPE VARCHAR2(50) Indicates the type of commercial aviation
service in support

of a Federal entity.

AGREEMENT_TYPE_DESC VARCHAR2(2000) Description of an agreement type.

EFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

TABLE AGREEMENT_USAGE

DESCRIPTION Contains information about specific uses of an agreement.

COLUMN TYPE DEFINITION

AGREEMENT_ID NUMBER(7) Identifier of the agreement and foreign key to
the

AGREEMENTS_AND_CONTRACTS table.

AIRCRAFT_SEQ NUMBER(7) Unique identifier of the aircraft associated with
the

agreement and foreign key to the FLEET_AIRCRAFT table.

CONTR_ITEM_NO VARCHAR2(10) Identifies the contract item number
associated with this

record.

COST_DESC VARCHAR2(50) Describes the service costs associated with this
agreement

usage record.

DETAIL_ID NUMBER(7) Identifier of the detailed contract item information

associated with this agreement usage record and foreign

key to the AGREEMENT_DETAILS table.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier of an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

FLIGHT_ID NUMBER(7) Identifier of the flight associated with this
agreement usage

record and primary key of this table. Also foreign key to

the FLIGHTS table.

HIRED_DATE DATE Specifies the hired date associated with this agreement

usage record.

HIRED_TIME DATE Specifies the hired time associated with this agreement

usage record.

MISSION_SEQ NUMBER(5) Unique identifier of the mission for the aircraft
provided by

the agreement and foreign key to the MISSION table.

ORG_CODE VARCHAR2(8) Code identifying the service/office/bureau entering
into the

agreement and foreign key to the

ORGANIZATION_CODES table.

RELEASED_DATE DATE Specifies the released date associated with this
agreement

usage record.

RELEASED_TIME DATE Specifies the released time associated with this
agreement

usage record.

SERVICE_DESC VARCHAR(50) Describes the services associated with this
agreement

usage record..

TABLE AGREEMENTS_AND_CONTRACTS

DESCRIPTION Contains information about an aircraft contract, charter, or
rental agreement.

COLUMN TYPE DEFINITION

AGREE_TYPE_SEQ NUMBER(3) Unique identifier of the agreement type and
foreign key to

the AGREEMENT_TYPE table.

AGREEMENT_ID NUMBER(7) Unique identifier for the agreement and primary
key of this

table.

BEG_DATE DATE The beginning date and time for the agreement.

CONTACT_ID NUMBER(7) Unique identifier of the agency contact for the
agreement

and foreign key to the CONTACTS table.

CONTR_BOA_NO VARCHAR2(20) Identifies the contract or BOA number for the
agreement or

contract.

END_DATE DATE The ending date and time for the agreement.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier for an executive agency and
foreign key to

the EXECUTIVE_AGENCY table.

ORG_CODE VARCHAR(8) Code which identifies the Government

service/office/bureau entering into the agreement and

foreign key to the ORGANIZATION_CODES table.

VENDOR_ID NUMBER(7) Identifier of the agreement or contract vendor and
foreign

key to the VENDORS table.

TABLE CAS

DESCRIPTION Stores the cost and hours flown of a Government aircraft
under a commercial

service.

COLUMN TYPE DEFINITION

AGREEMENT_NUMBER VARCHAR2(15) Reference number for a category of
services that includes

use of charter aircraft, contract aircraft, rental aircraft, and

related activities in support of a Federal entity.

AGREEMENT_TYPE_SEQ NUMBER(3) Unique identifier of an agreement type and
foreign key to

the AGREEMENT_TYPE table.

BATCH_INPUT_IND CHAR(1) Indicates (Y/N) if the information was entered
by a batch

file input.

BLOCK_TO_BLOCK_TIME NUMBER(5,1) Total time, expressed in hours and
tenths of an hour, from

the time the aircraft begins to move under its own power

until it comes to a rest and shuts down after completion of

the flight.

BUREAU_SEQ NUMBER(5) Unique identifier for a bureau/office/service and
foreign key

to the BUREAU_OFFICE_SVC table.

BUREAU_SEQ_SUPPLIER NUMBER(5) Unique identifier of a
bureau/office/service and foreign key

to the BUREAU_OFFICE_SVC table.

CAS_BEGIN_DATE DATE Date on which a category of services that includes
use of

charter aircraft, contract aircraft, rental aircraft, and related

services in support of a Federal entity, starts.

CAS_COMMENT VARCHAR2(2000) Relevant remarks which clarify the aircraft
CAS information.

CAS_END_DATE DATE Date on which the contract services end.

CAS_SEQ NUMBER(6) Unique identifier of a CAS record and primary key to
this

table.

DATA_AVAIL_STAT_SEQ NUMBER(2) Unique identifier of data availability
status and foreign key

to the DATA_AVAIL_STAT table.

ENTERED_BY_USER_ID VARCHAR2(30) Id of user who entered the information.

ENTRY_DATE DATE Date the information was entered into the database.

HOURS_FLOWN NUMBER(5,1) The amount of time, expressed in hours and
tenths of an

hour, from when the aircraft leaves the ground until it

touches down again.

IN_HOUSE_COST NUMBER(12) Operating expenses provided by the using
Government

agency which benefits form the commercial sevice, such as

pilot and fuel expenses.

MISSION_SEQ NUMBER(5) Unique identifier of a mission and foreign key to
the

MISSION table.

MODEL_SEQ NUMBER(5) Unique identifier of the model of an aircraft and
foreign key

to the MODEL_OF_AIRCRAFT table.

MODIFIED_BY_USER_ID VACHAR2(30) Id of user who last modified the
information

MODIFIED_DATE DATE Date the information was last modified.

PAID_OUT_COST NUMBER(12) Operating expenses paid out to commercial or
other

Government agency providers of the service.

REGIS_NO VARCHAR2(9) Unique identification mark or \"tail number\"
(usually

numbers and letters) displayed on Government aircraft \--

including foreign aircraft hired as CAS.

REVIEWER_COMMENT VARCHAR2(2000) Comments added by the reviewed of this
record.

RPT_PER_BEG_DATE DATE Beginning date of the period for which the CAS
information

is submitted.

RPT_PER_END_DATE DATE Ending date of the period for which the CAS
information is

submitted.

TABLE VENDORS

DESCRIPTION Contains information about vendors.

COLUMN TYPE DEFINITION

ADDRESS1 VARCHAR2(50) First line of vendor address.

ADDRESS2 VARCHAR2(50) Second line of vendor address.

CITY VARCHAR2(25) City where the vendor is located.

COMPANY VARCHAR2(50) Company name of the vendor.

CONTACT_ID NUMBER(7) Identifier of the contact person for the vendor and
foreign

key to the CONTACTS table.

COUNTRY VARCHAR2(20) Country where vendor is located.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier of executive agency and
foreign key to the

EXECUTIVE_AGENCY table.

MIN_CHARGE NUMBER(8) Minimum charge amount for the vendor.

MINORITY_CODE VARCHAR2(50) Code for minority owned vendor.

ORG_CODE VARCHAR2(8) Identifier of the service/office/bureau and foreign
key to the

ORGANIZATON_CODES table.

PAY_TERMS VARCHAR2(50) Payment terms for the vendor.

PERF_RATING VARCHAR2(50) Performance rating for the vendor.

POSTAL_CODE VARCHAR2(10) Postal code of the vendor.

SHIP_METHOD VARCHAR2(50) Shipping method for the vendor.

SIC_CODE VARCHAR2(4) Vendor\'s SIC Code.

STATE_CODE VARCHAR2(5) Code which identifies the state where the vendor
is located

and foreign key to the STATE_CODES table.

VENDOR_ID NUMBER(7) Unique identifier for the vendor and primary key of
this

table.

*MODULE* *Agency Unique Requirements*

*DESCRIPTION* *The agency unique requirements module of C-AMIS supports
processes which are uniquely*

*needed by one or more (but not all) of the participating agencies. An
example is the*

*capability to capture and report mishap (accident/incident)
information, which is*

*required by the USDA Forest Service. The Forest Service also needs to
be able to process*

*flight invoice data. Module information in the C-AMIS database will be
reported and/or*

*displayed to assist managers with unique agency requirements.*

TABLE INV_FLIGHTS

DESCRIPTION Contains information about flights associated with a USDA
Forest Service

invoice.

COLUMN TYPE DEFINITION

AC_CODE VARCHAR2(5) Code which uniquely identifies the make and model of
the

aircraft referenced by the invoice. Foreign key to the

AC_CODES table. This table is an agency unique

requirement of the USDA Forest Service.

AC_TYPE CHAR(1) Type of aircraft: H = Helicopter, F = Fixed Wing, T =
Air

Tanker.

AGREE_NO VARCHAR2(20) Unique identifier of the contract or rental
agreement.

Foreign key to the AGREEMENTS table.

FLIGHT_DATE DATE Date of the flight.

INVOICE_ID NUMBER(7) Unique identifier of the invoice and primary key of
this

table.

REGIS_NO VARCHAR2(6) Unique identification mark or \"tail number\"
(usually

numbers and letters) displayed on Government aircraft \--

including foreign aircraft hired as CAS.

REMARKS VARCHAR2(255) Remarks about the invoice, including remarks about
special

passengers.

VENDOR_ID NUMBER(7) Unique identifier of the vendor owning the aircraft.
Foreign

key to the VENDORS table.

TABLE INV_LEGS

DESCRIPTION Contains information about flight legs associated with a
USDA Forest Service

invoice.

COLUMN TYPE DEFINITION

AC_RATE NUMBER(8,2) Hourly or daily rate charged for this aircraft on
this leg.

CAPTAIN NUMBER(7) Unique identifier for the pilot-in-command of the
flight leg.

Foreign key to the PERSONS table.

CARGO_LBS NUMBER(7) Weight of cargo in pounds.

CARGO_TYPE CHAR(1) Type of cargo: P for Paracargo, S for Sling Load, C
for

Other.

COPILOT NUMBER(7) Unique identifier for the copilot of the flight leg.
Foreign

key to the PERSONS table.

CREW_COUNT NUMBER(2) Number of crew members on board

ELAPSED_TIME NUMBER(5,2) Elapsed time in hours and hundredths of hours.

EXEC_AGENCY_SEQ NUMBER(4) Unique identifier of an executive agency and
foreign key to

the EXECUTIVE_AGENCY tablle.

FLIGHT_DEST VARCHAR2(4) Identifies airport which is the destination of
the flight.

Foreign key to the AIRFIELDS_LOCATIONS table.

FLIGHT_ORIGIN VARCHAR2(4) Identifies airport where the flight
originated. Foreign key to

the AIRFIELD_LOCATIONS table.

FUEL_COST NUMBER(5,2) Cost per gallon of fuel.

INCIDENT_ORDER CHAR(20) Identifies the incident or project which is
reason the flight

leg is flown.

INVOICE_ID NUMBER(7) Unique identifier of the invoice and foreign key to
the

INV_FLIGHTS table.

LEG_NO NUMBER(2) Flight leg identifier sequentially assigned by the
system.

INVOICE_ID, LEG_NO is the primary key of this table.

METER_TYPE CHAR(1) Meter type for the aircraft: C for Clock, H for
Hobbes

Meter.

MISSION_SEQ NUMBER(5) Identifies mission of the flight. Foreign key to
the

MISSION table.

ORG_CODE VARCHAR2(8) Identifies an organization within an executive
agency.

Foreign key to the ORGANIZATION_CODES table.

PASS_COUNT NUMBER(3) Number of passengers on board the aircraft at the
time of

departure.

PASS_DELIV NUMBER(3) The number of Smoke Jumpers and Rappellers
delivered.

PAY_CODE CHAR(2) Code which identifies the purpose of the charges being

entered for the leg. Foreign key to the PAY_CODES table.

RET_GALS NUMBER(7) Number of gallons of retardant carried on the flight.

RET_TYPE CHAR(1) Retardant type: W for Water Base, L for Liquid Base, S
for

Solid Base, F for Foam.

START_TIME NUMBER(5,2) Start time for the flight leg in hours and
minutes (24-hour

format). If using the Hobbs Meter, enter the current

reading. Do not enter the colon or decimal point. (A clock

reading of 12:34 would be entered as 1234, a Hobbes

reading of 196.2 as 19620.)

STOP_TIME NUMBER(5,2) Stop time for the flight leg in hours and minutes
(24-hour

format). If using the Hobbs Meter, enter the current

reading. Do not enter the colon or decimal point. (A clock

reading of 12:34 would be entered as 1234, a Hobbes

reading of 196.2 as 19620.)

TABLE MISHAP_FACTOR_CODES

DESCRIPTION Contains codes and descriptions for mishap factors. This
table is an agency

unique requirement of the USDA Forest Service.

COLUMN TYPE DEFINITION

FACTOR_CODE CHAR(3) Identifies mishap factor. Primary key of this table,
which is

an agency unique requirement of the USDA Forest Service.

FACTOR_DESC CHAR(60) Describes mishap factor.

TABLE MISHAPS

DESCRIPTION Contains information about mishaps. This table is an agency
unique requirement

of the USDA Forest Service.

COLUMN TYPE DEFINITION

AC_CODE CHAR(5) Code identifying the make and model of the aircraft and

foreign key to the AC_CODES table. This table is an

agency unique requirement of the USDA Forest Service.

AC_TYPE CHAR(1) Type of aircraft: H =Helicopter, F = Fixed Wing, T = Air

Tanker.

ACTION_TAKEN CHAR(60) Description of action taken entered by a safety
officer.

CAUSE_FACTOR1 CHAR(3) Cause factor for the mishap entered by a safety
officer.

Foreign key to MISHAP_FACTOR_CODES table.

CAUSE_FACTOR2 CHAR(3) Cause factor for the mishap entered by a safety
officer.

Foreign key to the MISHAP_FACTOR_CODES table.

FS_UNIT VARCHAR2(6) Identifies the Forest Service unit (Region or
Region/Forest)

that is responsible for this report, not the location of the

mishap.

INFO_TYPE CHAR(2) Identifies the type of information: A for Accident, I
for

Incident, IP for Incident with Potential, or H for Hazard.

MISHAP_DATE DATE The date the accident or incident occurred.

MISHAP_ID NUMBER(7) Unique identifier for a MISHAPS record and primary
key to

this table.

MISSION_SEQ NUMBER(4) Identifies mission of the flight. Foreign key to
the

MISSION table.

PILOT NUMBER(7) Unique identifier for the pilot associated with the
mishap.

Foreign key to the PERSONS table.

REGIS_NO VARCHAR2(6) Unique identification mark or \"tail number\"
(usually

numbers and letters) displayed on Government aircraft \--

including foreign aircraft hired as CAS.

REMARKS VARCHAR2(240) Remarks about the mishap.

VENDOR_ID NUMBER(7) Unique identifier of the vendor owning the aircraft.
Foreign

key to the VENDORS table.

*MODULE* *Communications*

*DESCRIPTION* *The communications and data transport module of C-AMIS
provides a means of data*

*transport, collection, dissemination, security, user account
administration, and user*

*interface to the system. The module also provides system usage
accounting on an*

*agency/department level. Login data is captured to track unauthorized
Login attempts for*

*security purposes. System security reports can be generated and
forwarded to the*

*appropriate authorities.*

TABLE ROLE

DESCRIPTION Stores acceptable values for the different roles the users
are allowed to have in

C-AMIS.

COLUMN TYPE DEFINITION

EFFECTIVE_DATE DATE The first date on which this entry is valid.

EXPIRATION_DATE DATE The last date on which this entry is valid.

ROLE_DESC VARCHAR2(2000) Description of the user role.

ROLE_NAME VARCHAR2(256) Name of the user role, which is used to map
permissions to

perform functions to users who tasked to perform them.

ROLE_SEQ NUMBER(4) Unique identifier for a role and the primary key to
this table.

TABLE USER_ORGANIZATIONS

DESCRIPTION Contains information about valid user organizations.

COLUMN TYPE DEFINITION

ORGANIZATION VARCHAR2(40) Name of the user organization.

USER_ORG_ID NUMBER(4) Unique identifier for a user organization and
primary key to

this table.

TABLE USERS

DESCRIPTION Contains information about users to facilitate logins and
provide security for the

system.

COLUMN TYPE DEFINITION

EFFECTIVE_DATE DATE The first date on which this entry is valid.

ENCRYPT_PW VARCHAR2(20) Encrypted password for the user.

EXPIRATION_DATE DATE The last date on which this record is valid.

LOGIN_NAME VARCHAR2(8) Login name of the user.

USER_EMAIL VARCHAR2(40) Electronic mail address for the user.

USER_FAX VARCHAR2(20) Fax number for the user.

USER_FNAME VARCHAR2(15) First name of the user.

USER_ID NUMBER(6) Unique identifier for the user and primary key of this
table.

USER_LNAME CHAR(20) Last name of the user.

USER_MI VARCHAR2(1) Middle initial of the user.

USER_ORG_ID NUMBER(4) Unique identifier of the user\'s organization and
foreign key

to the USER_ORGANIZATIONS table.

USER_PHONE VARCHAR2(20) Phone number for the user.