The purpose of this section is to describe in details all the tables used in the Oracle Reconstruction
rules.

A list of all the tables used by the Reconstruction rules, and a definition of the their acronym names is
presented in Table XX.

                    Table XX:  Reconstruction Tables and Acronyms Definitions
           __________________________________________________________________________________
           |      Table Names         |                Acronym Definitions                  |
           ----------------------------------------------------------------------------------
           | AFST                     |  Accumulated Frames Statistics Table                |
           | AFST_UNDO                |  Accumulated Frames Statistics Table, Undo version  |
           | ALL_STATES               |  All States                                         |
           | BFSTNULLNULLNULLNULLBAD  |  Null Bad Frames Statistics Table                   |
           | CDM_MFPT                 |  Current Data Mode and Major Frame Period Table     |
           | CONFIG_PARM              |  Configuration Parameters table for the mission     |
           | CS_LOOKUPT               |  ConSeq Lookup Table                                |
           | CS_STATE_REPORT          |  ConSeq State Report table                          |
           | CS_STATE_REPORT_UNDO     |  ConSeq State Report table, Undo version            |
           | GFSTNULLNULLNULLNULLGOOD |  Null Good Frames Statistics Table                  |
           | GRADE2_TEMP_STOR         |  GRADE2 TEMPoray STORage table                      |
           | IFST                     |  Inverted Frames Statistics Table                   |
           | IFST_UNDO                |  Inverted Frames Statistics Table, Undo version     |
           | LOGT                     |  LOG Table                                          |
           | MNFFPT                   |  MiNor Frame File Pointer Table                     |
           | MNFFPT_UNDO              |  MiNor Frame File Pointer Table, Undo version       |
           | MNFLT1                   |  Minor Frame Location Table number 1                |
           | MNFLT1_UNDO              |  Minor Frame Location Table number 1, Undo version  |
           | MNFLT2                   |  Minor Frame Location Table number 2                |
           | MNFLT2_UNDO              |  Minor Frame Location Table number 2, Undo version  |
           | MNFLT3                   |  Minor Frame Location Table number 3                |
           | MNFLT3_UNDO              |  Minor Frame Location Table number 3, Undo version  |
           | MNFLT4                   |  Minor Frame Location Table number 4                |
           | MNFLT4_UNDO              |  Minor Frame Location Table number 4, Undo version  |
           | MNFLT5                   |  Minor Frame Location Table number 5                |
           | MNFLT5_UNDO              |  Minor Frame Location Table number 5, Undo version  |
           | MNFQT                    |  Minor Frame Quality Table                          |
           | QUAL_COMP                |  Quality Comparision table                          |
           | RECIPE                   |  Reconstruction RECIPE table                        |
           | RECIPE2                  |  Reconstruction RECIPE2 table, used for trending    |
           | RECON_SWITCHES           |  Reconstruction switches table                      |
           | RULES_NUMBERS            |  Reconstruction rules numbers table                 |
           | SESSIONS_PARAMETERS      |  Sessions parameters table                          |
           | SPOINTERT                |  Small POINTERs Table.                              |
           | SYSTEM_STATE             |  SYSTEM STATE table                                 |
           | SYSTEM_STATE_UNDO        |  SYSTEM STATE table, Undo version                   |
           | TEMP_AFST                |  TEMPorary AFST                                     |
           | TREND_TIME               |  Trending major frame time table                    |
           | UNIQUE_TIME              |  Unique time table                                  |
           | WFST                     |  Working frames statistics table                    |
           ----------------------------------------------------------------------------------

*
QUAL_COMP.
----------

This is a temporary table created during reconstuction by procedure CREATE_QUAL_COMP.  The purpose of this table is to store quality inforamation for minor frames which where unpacked in the current session and had been unpakced in a previous session.  At the end of Reconstruction, the minor frame with the best overall quality is kept and table QUAL_COMP is dropped.  Table QUAL_COMP contains the following columns:

    - FP_UMF_DATETIME (NUMBER (16,6)).  The unpacked major frame floating point datetime.

    - UMNFC (NUMBER(3)).  The unpacked minor frame counter for the above major frame.

    - C_SPOINTER (NUMBER(3).  The current small pointer assigned to the current BFST in table MNFFPT.

    - P_QUAL (NUMBER(2)).  The quality rank that had been assigned to the current minor frame in a previous reconstruction session.

    - ROW_ID (ROWID).  The rowid of the current major frame, in one of the subtables where the minor frame that has been found again (in the current session) is stored.

This table is dropped at the end of reconstruction in procedure TERMINATE_REC, and also at the begining of reconstruction in procedure INITIALIZE.  The latter is a precautionary step in case the previous reconstruction session resulted in an error and therefore did not terminated as planned.


*
TEMP_AFST.
----------

This is a temporary table created by procedure CREATE_TEMP_AFST just prior to the execution of procedure QA_AFST.  Thepurpose of this table is to temporarilly store all major frame information for all major frames present in the AFST that are within the current session's timespan.  This table is used by procedure by procedure to reconcile the current session's information with the previous sessions' information and since previous sessions' information stored in the AFST are voluminous only those major frames in the AFST that are within the current timespan are of interest.  At the end of reconstruction, this table is dropped.  TEMP_AFST has the same table definition as the AFST.

*
SPOINTERT.
----------

This is a temporary table created during reconstuction by procedure CREATE_SPOINTERT1.  The purpose of this table is to store all the distinct small pointers for the major frames that will be reconstructed.  The small pointers are found from the subtables (MNFLT1, MNFLT2, MNFLT3, MNFLT4, MNFLT5) and inserted by procedure CREATE_SPOINTERT2.  Table SPOINTERT contains the following column:

    - SPOINTER (NUMBER(3)).   Refers to the numeric value (small pointer) assigned in table MNFFPT by procedure UPDATE_MNFFPT to allReconstruction sessions.  Spointers range from 0 to 999 and cycle where the 999 is reached.  Effectively, this is a short pointer that uniquely points to all sessoins processed thus far that are still online.

*
MNFQT.
------

This is a static table that stores all combination of Frame Synchronizer Error, Minor Frame Counter Error, Major Frame Counter Error, Mode Error, Date Error, and Quality Rank.  This table is created during the installation of the rules and does not change.  Table MNFQT is used by procedure BFST_ASS_QRANK to assign quality rank to minor frames based on the cummulative settings of their error flags cited above.  Table MNFQT contains the following columns:

    - QRANK (NUMBER(2)).  Refers to the minor frame quality rank.

    - FSERR (NUMBER(1)).  Refers to the frame synchronizer error flag.

    - MNFCERR ((NUMBER(1)).  Refers to the minor frame couter error flag.

    - MFCERR (NUMBER(1)).  Refers to the major frame counter error flag.

    - MODEERR (NUMBER(1)).  Refers to the mode error flag.

    - DATEERR (NUMBER(1)).  Refers to the date error flag.

*
CDM_MFPT.
---------

This is a static table that stores all Current Data Mode and Major frame period for a mission.  This table is created during the installation of the rules and does not change.  Table CDM_MFPT is used by procedure BFST_MODEERR to validate all unpacked current data mode in the BFST.  Table CDM_MFPT contains the following columns:

    - CDM (NUMBER(2)).  Refers to the current data mode.

    - MFP (NUMBER(3)).  Refers to the major frame period associated with this data mode.

*
TEMP1.
------

This is a temporary table that stores all CDM information for minor frames of major frames that will be reconstructed.  Table temp1 is created and dropped during the execution of procedure UPDATE_CDM.  Table temp1 contains the following columns:

    - UMNFC (NUMBER(3)).  Refers to the unpacked minor frame counter.

    - CDM (NUMBER(3)).  Refers to the current data mode.

    - MODEERR (NUMBER(1)).  Refers to the mode error flag.

    - MNFFILE (VARCHAR2(50)).  Refers to the name of the BFST where a minor frame of a major frame may be found.

*
AFST.
-----

Created during the initial installation of rules, the Accumulated Frame Statistics Table contains a running archive of the disposition of all expected major frames.  At the end of each Reconstruction session all major frames (grades 0, 1, and 2) from the current session, provided that they are not already in the AFST (i.e. some may have been part of a previous session), are recorded in the AFST for history tracking. Note that the TTCD_COUNT column is used only for the GEOTAIL mission.

    - ID (NUMBER(6).  Refers to the id of the minor frame, which is a running count of how many minor frames are in the GFST or BFST.

    - FP_UMF_DATETIME (NUMBER(16,6)).  Refers to the floating point unpacked major frame datetime.

    - FP_UMFGR_DATETIME (NUMBER(16,6)).  Refers to the floating point unpacked major frame ground receipt datetime.

    - UMFC (NUMBER(3)).  Refers to the unpacked major frame counter.

    - CDM (NUMBER(3)).  Refers to the current data mode.

    - MF_GRADE (NUMBER(1)).  Refers to the major frame grade.

    - MFP (NUMBER(10,6)).  Refers to the major frame period.

    - MNF_LOC (NUMBER(6)).  Refers to the location of the minor frame in the anotated minor frame file.

    - LPOINTER (NUMBER(10)).  Refer to a unique number that maps to a specific Reconstruction session.

    - FILL_STATE (NUMBER(1)).  Refers to a flag which which indicated whether a major frame time was actually unpacked or if it was computed (1 = computed, 0 or Null = unpacked).

    - NMNF_FOUND (NUMBER(3)).  Refers to the number of minor frames found for all grade 1 major frames. 

*
AFST_UNDO.
----------

This is the undo version of the AFST_UNDO table.  At the begining of reconstuction, before any new states are recorded, entries from the AFST table are copied into the AFST_UNDO table to serve as a backup should the current session need an UNDO.  AFST_UNDO is created during the initial installation of the Oracle Rules and contains the same columns as the AFST table.

*
ALL_STATES.
-----------

For each Reconstruction rule, this table contains information about all the states and their descriptions.  This table is created and populated during the initial installation of the Oracle rules and it must be updated where when states are modified or when new rules are added.  This table which may be manipulated through the STATES package, contains the following columns:

    - RULE (NUMBER(3)).  Refers to the number assigned to a rule in the hierarchical scheme.

    - STATE (NUMBER(3)).  Refers to the particular state a rule found itself in.

    - DESCRIPTION (VARCHAR2(1000)).  Refers to the worded description of the rules states.

*
UNIQUE_TIME.
------------

This temporary table contains all not null unpacked major frame datatimes from the BFST for minor frames that are not failed and don't have their DATEERR flag raised.  This table is created in procedure BFST_FILL_TIME and dropped in procedure TERMINATE_REC.  Unique_time contains the following columns:

    - FP_UMF_DATETIME (NUMBER(16,6)).  Refers to the floating point unpacked major frame datetime.

    - ID (NUMBER(6).  Refers to the id of the minor frame, which is a running count of how many minor frames are in the BFST. 

    - DATEERR (NUMBER(1)).  Refers to the date error flag.

*
UNIQUE_UMFC.
------------

This temporary table contains all not null UMFC from the BFST for minor frames that are not failed.  This table is created by procedure BFST_FILL_TIME and dropped by procedure BFST_REFILL_TIME.  Unique_umfc contains the following columns:

    - UMFC (NUMBER(3)).  Refers to the unpacked major frame counter for the major frame to which the minor frame belongs.

    - ID (NUMBER(6).  Refers to the id of the minor frame, which is a running count of how many minor frames are in the BFST. 

    - DISC.  Refers to the discontinuity flag.

*
CS_STATE_REPORT.
----------------

This table created during the initial installation of the rules, stores information on the state of all the conseqs found in the BFST after every run of the Oracle rules.  Table cs_state report contains the following columns:
 
    - LPOINTER (NUMBER(10)).  Refer to a unique number that maps to a specific Reconstruction session.

    - MIN_ID (INTEGER).  Refers to the lower bound of a conseq.

    - MAX_ID (INTEGER).  Refers to the upper bound of a conseq.

    - NUM_DT (INTEGER).  Refers to the number of distinct UMFDT found in a conseq.

    - NUM_UMFC (INTEGER). Refers to the number of distinct UMFC found in a conseq.

    - CS_STATE (VARCHAR2(8)).  Refers to the overall state of a conseq.  It is the concatenation of NUM_DT to NUM_UMFC (for example "11" would mean that one unpacked UMFDT and one UMFC where found in a conseq.

    - FILL_STATUS (NUMBER(1)).  Refers to whether a conseq was filled (0 = no and 1 = yes).

*
CS_STATE_REPORT_UNDO.
---------------------

This is the undo version of the CS_STATE_REPORT table.  At the begining of reconstuction, before any new states are recorded, entries from the CS_STATE_REPORT table are copied into the CS_STATE_REPORT_UNDO table to serve as a backup should the current session need an UNDO.  CS_STATE_REPORT_UNDO is created during the initial installation of the Oracle Rules and contains the same columns as the CS_STATE_REPORT table.

*
IFST.
-----

This is the inversion frames statistics table, which as its names indicates stores statistics information on inverted minor frames.  IFST is created during the initial installation of the rules and contains the following columns:

    - FP_UMF_DATETIME (NUMBER(16,6)).  Refers to the floating point unpacked major frame datetime.

    - FP_UMFGR_DATETIME (NUMBER(16,6)).  Refers to the floating point unpacked major frame ground receipt datetime.

    - LPOINTER (NUMBER(10)).  Refer to a unique number that maps to a specific Reconstruction session.

    - UMFC (NUMBER(3)).  Refers to the unpacked major frame counter for the major frame to which the minor frame belongs.

    - CDM (NUMBER(3)).  Refers to the current data mode.

    - UMNFC (NUMBER(3)).  Refers to the unpacked minor frame counter.
 
    - MNF_LOC (NUMBER(6)).  Refers to the location of the minor frame in the anotated minor frame file.

    - IA (NUMBER(1)).  Refers to the inversion befor the minor frame.

    - IB (NUMBER(1)).  Refers to the inversion after the minor frame.

*
IFST_UNDO.
---------------------

This is the undo version of the IFST table.  At the begining of reconstuction, before any new states are recorded, entries from the IFST table are copied into the IFST_UNDO table to serve as a backup should the current session need an UNDO.  IFST_UNDO is created during the initial installation of the Oracle Rules and contains the same columns as the IFST table.

*
LOGT.
-----

This is a temporary table created during Reconstruction by the packaged procedure RULES_STATES.CREATE_LOGT.  This table serves the purpose of effectively gathering and storing state information for each rule as it is executing and when its completed its execution,the state infortion is gathered, converted from binary format to integer, and written to the SYSTEM_STATE table for plotting and state tracking.  Having outlived its usefullness at the end of reconstruction, LOGT is dropped.  LOGT contains the following collumns:

    - RULE (VARCHAR2(30)).  Refers to the name of the rule.

    - COLUMNS S1, S2 through S9 (NUMBER(1)).  These nine columns represent each a state in a rule (should a rule have nine states).  Dynamically creating only nine columns means that a rule may not have more than nine individual states.  Should the analysts develop a rule with more than nine states, it should be modularized into sub-rules.  

    - STARTED (NUMBER).  Refers to a floating point number assigned by the native Oracle packaged function DBMS_UTILITY.GET_TIME, and which represent an internal recording by the Oracle DBMS of when an event started. 

    - ENDDED (NUMBER).  Refers to a floating point number assigned by the native Oracle packaged function DBMS_UTILITY.GET_TIME, an d which represent an internal recording by the Oracle DBMS of when an event ended.  The difference ENDDED - STARTED is the number of one hundredth of seconds elapsed since the event started.  The latter is the lowest precision of time offered by Oracle.

    - TIMESTAMP (DATE).  Refers to the datetime when a ruled was started its precision.  Note that this column has a default value of SYSDATE, which means that whenever an event is logged into this table, its startind datetime is automatically recorded for latter to later be posted into the SYSTEM_STATE table.

*
MNFLT1, MNFLT2, MNFLT3, MNFLT4, and MNFLT5.
-------------------------------------------

These are the minor frame location tables.  They are identical to one another exept that each one contains information about a certain range of minor frames.  For the WIND mission for example, MNFLT1 describes minor frame ranges 0 to 50, MNFLT2 describes ranges 51 to 100, MNFLT3 describes ranges 101 to 150, MNFLT4 describes ranges 151 to 200, and MNFLT5 describes ranges 201 to 249.  For each major frame reconstructed these tables contain inforamtion on which minor frames where found and where they were found.  All location tables are created during the initial installation of the Oracle Rules and contains the following columns:  

    - FP_UMF_DATETIME (NUMBER(16,6)).  Refers to the floating point unpacked major frame datetime.

    - MNF_0, MNF_1, ....MNF_x (NUMBER(3)).  For all tables these columns refer to the minor frame SPOINTER address, which in turn, when querried from table MNFFPT, lead to the exact file where each minor frame may be found.

*
MNFLT1_UNDO, MNFLT2_UNDO, MNFLT3_UNDO, MNFLT4_UNDO, and MNFLT5_UNDO.
--------------------------------------------------------------------

These are the UNDO versions of tables MNFLT1, MNFLT2, MNFLT3, MNFLT4, and MNFLT5.  At the begining of reconstuction, before any new states are recorded, entries from the latter tables are copied into their respective undo tables to serve as a backup should the current session need an UNDO.  All the undo tables are created during the initial installation of the Oracle Rules and contains the same columns as the original tables.
 
*
MNFFPT.
-------

This is the minor frames file pointer table which stores small pointers assigned to each session for quick tracking and long pointers also assigned to each session for tracking archived sessions.  All sessions are assigned their pointers by procedure UPDATE_MNFFPT.  Table MNFFPT is created during the initial installation of the Oracle Rules.  Also during installation, the spointer ranges from 0 to 999 are inserted into the SPOINTER column of this table by procedure INSERT_SPOINTER.  Through the life cycle of the Reonstruction rules, the small pointers will be assigned to sessions in a cyclical fashion (0 to 999 then back to 0) where as large ponters will keep incrementing because they are unique pointers to archived data.  The following is a description of the MNFFPT:

    - SPOINTER (NUMBER(3)).  Refers to the small pointer.

    - MNFFILE (VARCHAR2(40)).  Refers the minor frame file, which name is also that of the sessions's BFST.

    - LPOINTER (NUMBER(10)).  Refers to the large pointer.  Note that this session defines a 10 digit integer.  Should a larger number be needed, this column will have to be increased to handle the larger number of sessions.

    - AMF_FILE (VARCHAR2(40)).  Refers the anotated minor frame file.

    - INPUT_FILE (VARCHAR2(40)).  Refers the name of the input file received via ftp from JPL.

    - SESSION_ID (VARCHAR2(40)).  Refers to the session id assigned to an Assembly/Decom session by DPS.

*
BFSTNULLNULLNULLNULLBAD.
------------------------

This is a null table created during the initial installation of the Oracle rules.  When during an Assembly/Decom session, LabView determines that all major frames where successfully processed, instead of posting a BFST with no data, LabView passes to the main Reconstruction procedure this BFST's name and the rules will immediately recognize this state and proceed accordingly through a predefined path.  Therefore BFSTNULLNULLNULLNULLBAD is used as a signal; it is is also used by all the reconstruction rules that will normally querry a populated BFST but in this case all querries will return empty.  An example of when this table is used is when no bad frames are processed.  Though BFSTNULLNULLNULLNULLBAD will never be inserted into, this table contains the same columns as a polulated BFST: ID, UMFC, CDM, DISC, MFP, FP_UMF_DATETIME, FP_UMNFGR_DATETIME, UMNFC, MNFSKIP, MNFFF, QRANK, FSERR, MNFCERR, MFCERR, MODEERR, MNFDP, DATEERR, MNF_LOC. Only those columns that did not already get discribed in the AFST are shown below:

    - DISC (NUMBER(3)).  Refers to the discontinuity count in the data. Every time LabView determines that is a discontinuity in the data it increments this count by one, therefore fromes of the same continuity have the same DISC.

    - UMNFC (NUMBER(3)).  Refers to the unpacked minor frame counter.

    - MNFSKIP (NUMBER(1)).  Refers to the unpacked minor frame skip.  When a skip is detected in the data this flag is raised (MNFSKIP = 1) else it stays = 0.

    - MNFFF (NUMBER(1)).  Refers to the Minor frame fail flag.  If for any of the various reasons discussed in the reconstruction document, a minor frame should not be used in the recipe, this flag is raised (MNFFF = 1) else it stays = 0.

    - QRANK (NUMBER(1)).  Refers to the overall minor frame quality rank.

    - FSERR (NUMBER(1)).  Refers to the frame synchronizer error flag.

    - MNFCERR (NUMBER(1)).  Refers to the minor frame counter error flag.

    - MFCERR (NUMBER(1)).  Refers to the major frame counter error flag.

    - MODEERR (NUMBER(1)).  Refers to the mode error flag

    - MNFDP (NUMBER(16,6)).  Refers to the minor frame downlink period.  

    - DATEERR (NUMBER(1)).  Refers to the date error flag.

*
GFSTNULLNULLNULLNULLGOOD.
-------------------------

This is a null table created during the initial installation of the Oracle rules.  When during an Assembly/Decom session, LabView determines that there are no good major frames successfully processed, instead of posting a GFST with no data, LabView passes to the main Reconstruction procedure this GFST's name and the rules will immediately recognize this state and proceed accordingly through a predefined path.  Therefore GFSTNULLNULLNULLNULLGOOD is used as a signal; it is is also used by all the reconstruction rules that will normally querry a populated GFST but in this case all querries will return empty.  An example of when this table is used is when we solve the GTM failure case.  Though GFSTNULLNULLNULLNULLGOOD will never be inserted into, this table contains the same columns as a polulated GFST: ID, UMFC, CDM, DISC, MFP , MFDP, FP_UMF_DATETIME, FP_UMFGR_DATETIME, and MNF_LOC.  Only those columns that did not already get discribed in the AFST are shown below: 

    - MFDP (NUMBER(10,6)).  Refers to the major frame downlink period.  

*
GFST_EX.
--------

This is a temporary table created by procedures BFST_GET_MFT (or by procedure CREATE_GFST_FROM_BFST.OSP depending on the state of rule RECONSTRUCTION1) to store all major frames to be reconstructed from the BFST.  Having outlived its usefullness at the end of BFST_GET_MFT's execution, GFST_EX is dropped.  The structure of this table is the same as that of GFSTNULLNULLNULLNULLGFST except for these additional columns:

   - DATASPAN (NUMBER(3)).  This is a running count of the number dataspans found in the GFST.  Major frames of the same dataspan have the same DATASPAN number.
 
   - MF_GRADE (NUMBER(1)).  Refers to the grade of the major frame.  

   - DUPLICATE (CHAR(3)).  Refers to whether a major frame is a duplicate of another one.  

*
GRADE2_TEMP_STOR.
-----------------

This table has the same structure as that of table GFST_EX. It is a temporary table that is created by procedure GFST_PROCESS1 and dropped by procedure TERMINATE_REC.  The purpose of this table is to temporarily store information about all the major frames (grade 2 major frames) that have been found as missing within and accross data spans.  Once major frames have been reconstructed from the BFST, they are latter crosschecked against those originally reported as missig in table GRADE2_TEMP_STOR and those that have still not been found either in the AFST or the BFST will be logged into the AFST as grade 0 at the end of reconstruction.  The reason for saving isolating grade major frames at the onset of Reconstruction is to improve performance and reconstruct only major frames for which there are minor frames versus attempting to reconstruct major frames which are though to be missing and for which no minor frames may be present.  

*
CS_LOOKUPT.
-------------

This table stores all the possible states of a conseq, and the name of the appropriate procedure to call based on the state.  This table is created during the initial installation of the Oracle rules.  CS_LOOKUPT contains the following columns: 

    - S_CS_DT (NUMBER(1)).  Refers to the state of a conseq as to the number of UMFDT present.

    - S_CS_UMFC (NUMBER(1)).  Refers to the state of a conseq as to the number of UMFC present.

    - ACTION (VARCHAR2(20)).  Refers to the name of the procedure to invoke based on the conseq's state.

*
SESSIONS_PARAMETERS.
--------------------

This table stores parameters for all the Reconstructed sessions that have ever been executed.  The SESSIONS_PARAMETERS table is created during the initial installation of the Oracle rules.  Before Reconstruction is invoked by LabView and after the GFST and the BFST have been posted into the database, LabView inserts into this table the characteristics of the Reconstruction session its about to start.  The Oracle Rules use information from this table to a certain extent, to decide which path in the rules the data will take and to keep track of which session has already been processed and when.  SESSIONS_PARAMETERS contains the following information:

    - TIMESTAMP (DATE).  Refer to the date and time at when the session was started.

    - GFST (VARCHAR2(40)).  Refers to the name of the good frames statistics table.

    - BFST (VARCHAR2(40)).  Refers to the name of the bad frames statistics table.

    - DIRECTION (NUMBER(1)).  Refers to the direction of the data: 1 for forward ordered data and -1 for reversed ordered data.

    - AMF_FILE ((VARCHAR2(40)).  Refers to the annotated minor frames file created by Assembly/Decom during the decommution of frames from the input file. 

    - INPUT_FILE (VARCHAR2(40)).  Refers to the input file name received via ftp from JPL.

    - SESSION_ID (NUMBER(9)).  Refers to the identifying number assigned to the session by DPS.

*
RECIPE.
-------

At the end of a Reconstruction session, this table contains the recipe generated for the session.  During a Reconstruction run, table RECIPE is populated by procedure GEN_RECIPE4 for all major frames which need a Reconstruction recipe generated.  RECIPE is created during the initial installation of the Oracle rules and has the following collumns:

    - FP_UMF_DATETIME (NUMBER(16,6)).  Refers to the floating point unpacked major frame datetime.

    - PHRASE1 (VARCHAR2(15)).  Refers to one of two recipe phrases:  for found minor frames, PHRASE1 = "get from" and for filled minor frames, PHRASE1 = "fill".

    - SPOINTER (NUMBER(5)).  Refers to the numeric value (small pointer) assigned in table MNFFPT by procedure UPDATE_MNFFPT to all Reconstruction sessions.  Spointers range from 0 to 999 and cycle where the 999 is reached.  Effectively, this is a short pointer that uniquely points to all sessions processed thus far that are still online.

    - PHRASE2 (VARCHAR2(15)).  Refers to the following recipe phrase: "minor frame".

    - UMNFC (NUMBER(3)).  Refers to the unpacked minor frame counter.

    - PHRASE3 (VARCHAR2(15)).  Refers to the following recipe phrase for found minor frames: "at location".

    - MNF_LOC (NUMBER(6)).  Refers to the location of the minor frame in the anotated minor frame file.

    - PHRASE4 (VARCHAR2(15)).  Refers to the following recipe phrase: ", QF" where QF is the overall quality flag.

    - QFLAG (NUMBER(2)).  Refers to the minor frame overall quality flag which is determined during Reconstruction by procedure BFST_ASS_QRANK.

    - UMFC (NUMBER(3)).  Refers to the unpacked major frame counter.

*
RECIPE2.
--------

This table stores the Reconstruction recipe generated during a trending session.  RECIPE2 is created during the initial installation of the Oracle rules and has the same description as table RECIPE.  

*
RECON_SWITCHES.
---------------

This table stores all the switch settings for the Reconstruction rules.  A rule with a switch setting of 1 is on and on with a switch setting of 0 is off.  The RECON_SWITCHES table is created and populated during the initial installation of the Oracle rules.  Before a rule is executed, reconstruction checks its switch setting to see if this rule should execute or not.  This table may be accessed and manipulated easily through the SWITCH package.  RECON_SWITCHES contains the following collumns:

    - RULE (VARCHAR2(30)).  Refers to the name of the rule.

    - SWITCH (NUMBER(1))).  Refers to the switch setting of the rule.

*
RULES_NUMBERS.
--------------

This table stores the names of the rules, their associated number and the current version of the rules.  This table may be accessed and manipulated easily through the SWITCH package.  RULES_NUMBERS is created and populated during the initial installation of the Oracle rules and contains the following columns:

    - RULE (VARCHAR2(30)).  Refers to the name of the rule.

    - RULE_NUMBER (NUMBER(3)).  Refers to the number assigned to a rule in the hierarchical scheme.
 
    - VERSION (NUMBER(5,2)).  Refers to the current version of the rules.

    - INDICATOR (NUMBER(1)).  Refers to the an indicator parameter used by the RULE package to auto-update the RULES_NUMBERS table recursively when a change in  the numbering hierarchy is requested by the enduser.  Except the RULE package is rearranging the rules the indicator column will allways remain empty.
    
*
SYSTEM_STATE.
-------------

This table stores all the state information for all the rules as their are beeing invoked during reconstruction.  SYSTEM_STATE is updated dynamically during each Reconstruction session as each rule is executed.  SYSTEM_STATE is created during the initial installation of the Oracle Rules and contains the following columns:

    - LPOINTER (NUMBER(10)).  Refer to the large pointer, a unique integer that is assigned to each reconstruction session so that data can be easily recovered from tape and kept track of.

    - EVENT (NUMBER(5)).  Refers to the event number associated with the rule.  Every time a rule is done executing, the event number is incremented by one.  A summation on this column will yield the total number of events during a Reconstruction session.

    - RULE (NUMBER(3)).  Refers to the number assigned to a rule in the hierarchical scheme.

    - STATE (NUMBER(3)).  Refers to the particular state a rule found itself in.

    - STARTED (DATE).  Refers to timestamp (to seconds precision) at wich the rule began its execution.

    - SECONDS_ELAPSED (NUMBER).  Refers to the number of seconds elapsed (to one hundredth of seconds precision) during the execution of a rule.

    - VERSION (NUMBER(5,2)).  Refers to the current version of the rules.

*
SYSTEM_STATE_UNDO.
------------------
  
This is the undo version of the SYSTEM_STATE table.  At the begining of reconstuction, before any new states are recorded, entries from the SYSTEM_STATE table are copied into the SYSTEM_STATE_UNDO table to serve as a backup should the current session need an UNDO.SYSTEM_STATE_UNDO is created during the initial installation of the Oracle Rules and contains the same columns as the SYSTEM_STATE table.

*
TREND_TIME.
-----------

This table contains information for all the major frames for which a trending session will need reconstruction.  TREND_TIME is created during the initial installation of the Oracle Rules and contains the following columns:  

    - FP_UMF_DATETIME (NUMBER(16,6)).  Refers to the floating point unpacked major frame datetime.

    - UMFC (NUMBER(3)).  Refers to the unpacked major frame counter.


*
CONFIG_PARM.
------------

This table contains all the mission configuration parameters.  The table may be manipulated though the CONFIG package.  CONFIG_PARM is created and populated during the initial installation of the Oracle rules.  All configuration parameters in the Oracle Rules are stored in this table and accessed through the Oracle Rules.  CONFIG_PARM contains the following columns:

    - PARAMETER (VARCHAR2(30)).  Refers to the configuration parameters.

    - VALUE (VARCHAR2(100)).  Refers to the value of the configuration parameters.  Note that because this column is a VARCHAR2, parameters which are numbers are also stored as numbers but when retrieved from CONFIG_PARM through the CONFIG package, they are returned as number and not as characters as one may have expected. 
 

*
WFST.
-----

This is the Working Frames Statistics Table, temporarily created during reconstruction by procedure CREATE_WFST and dropped by procedure TERMINATE_REC.  The purpose of the WFST is to temporarily store information about major frames that are being reconstructed, up to the point where they have been reconstructed and are ready for transfer to the Accumulated Frames Statistics Table (AFST).  The WFST has the same table definition as the AFST in addition to this column:

    - INDICATOR (NUMBER(1) DEFAULT 0).  This column is used during reconstruction to indicate when a major frame being reconstructed has had at least one of its minor frame being found in the current session's BFST.  Of all the major frames in the WFST only those with INDICATOR=1 will be reconstructed.


*
MNFFPT_UNDO.
------------

This is the undo version of the MNFFPT table.  At the beginning of reconstruction, before any new states are recorded, entries from the MNFFPT table are copied into the MNFFPT_UNDO table to serve as a backup should the current session need an UNDO. MNFFPT_UNDO is created during the initial installation of the Oracle Rules and contains the same columns as the MNFFPT table.


