General Business Rule description by hkx3mP08

VIEWS: 7 PAGES: 13

									                                                                                      FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX

      STEP                       Air Force                                          Army                                          Navy                                     USMC                                         WHS
Pre-processing      Check that the current FAC is assigned and     Check that the current FAC is assigned and     Check that the current FAC is assigned     Check that the current FAC is assigned     Check that the current FAC is assigned
(in RPAD)           correct as necessary.                          correct as necessary.                          and correct as necessary.                  and correct as necessary.                  and correct as necessary.
                    Check that the primary FAC UM is used          Check that the primary FAC UM is used          Check that the primary FAC UM is used      Check that the primary FAC UM is used      Check that the primary FAC UM is used
                    and convert as necessary.                      and convert as necessary.                      and convert as necessary.                  and convert as necessary.                  and convert as necessary.
                    Check that only validated records exceed       Check that only validated records exceed       Check that only validated records exceed   Check that only validated records exceed   Check that only validated records exceed
                    FAC upper limit and correct as necessary.      FAC upper limit and correct as necessary.      FAC upper limit and correct as             FAC upper limit and correct as             FAC upper limit and correct as
                                                                                                                  necessary.                                 necessary.                                 necessary.
1) Correct FAC      Correct FAC assignments to the FY08            Correct FAC assignments to the FY08            Correct FAC assignments to the FY08        Correct FAC assignments to the FY08        Correct FAC assignments to the FY08
assignments and     RPCS.                                          RPCS (note UM correction to LF for CC          RPCS (note UM correction to LF for CC      RPCS.                                      RPCS.
Merge tables        Merge RPAD relational tables into model        87140).                                        87125).                                    Merge RPAD relational tables into          Merge RPAD relational tables into
                    database format.                               Merge RPAD relational tables into model        Merge RPAD relational tables into          model database format.                     model database format.
                    For RPUID will use 8-characher site            database format.                               model database format.                     Segregate USMC facility records from       For RPUID will use 5-digit site number
                    number (INSNO) plus 5-digit facility           Adjust the asset size for each ARNG record     Segregate Navy facility records from       Navy records based on RPA command          (INSNO) plus 5-digit facility number
                    number (FACNO).                                by using the agreement support codes           USMC records based on RPA                  claimant code using the RPA Table.         (FACNO).
                                                                   from the RPA Use Table and the Army            command claimant code using the RPA        Records with code M00027 will be
                                                                   National Guard Agreement Support Codes         Table. Records with code M00027 will       Marine, all others will be Navy records.
                                                                   with Federal Support % Table [A-10             be Marine, all others will be Navy         Marine Corps will use true random
                                                                   below].                                        records.                                   number as RPUID rather than the NFA
                                                                                                                  Navy will use true random number as        number.
                                                                                                                  RPUID rather than the NFA number.




2) Add / modify     Add pseudo installations for non-modeled       Add pseudo installations for non-modeled       Add pseudo installations for non-          Add pseudo installations for non-          WHS will have no major commands.
installation data   costs in accordance with table [C-13].         costs in accordance with table [C-13].         modeled costs in accordance with table     modeled costs in accordance with table
                                                                   Army does not intend to need pseudo            [C-13].                                    [C-13].
                                                                   installations.
3) Assign model     Assign a model installation and site to each   Assign a model installation and site to each   Assign a model installation and site to    Assign a model installation and site to    Assign a model installation and site to
installation        record, based upon its installation code       record, based upon its installation code       each record, based upon its installation   each record, based upon its installation   each record, based upon its installation
                    using the Installation Table, the real         using the Installation Table, the real         code using the Installation Table, the     code using the Installation Table, the     code using the Installation Table, the
                    property site unique identifier (RPSUID)       property site unique identifier (RPSUID)       real property site unique identifier       real property site unique identifier       real property site unique identifier
                    using the Site Table, and the real property    using the Site Table, and the real property    (RPSUID) using the Site Table, and the     (RPSUID) using the Site Table, and the     (RPSUID) using the Site Table, and the
                    unique identified (RPUID) using the RPA        unique identified (RPUID) using the RPA        real property unique identified            real property unique identified            real property unique identified
                    Table.                                         Table.                                         (RPUID) using the RPA Table.               (RPUID) using the RPA Table.               (RPUID) using the RPA Table.




                                                                                                  1                                                                                       7/4/2012
                                                                                          FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX

      STEP                            Air Force                                         Army                                          Navy                                      USMC                                        WHS
4) Assign managing      Assign a managing command to each              Assign a managing command to each              Assign a managing command to each          Assign a managing command to each          Not used for the WHS.
command                 facility record, using the site command        facility record, using the site command        facility record, based upon its site       facility record, based upon its site
                        claimant code using the Site Table.            claimant code using the Site Table.            command claimant code using the            command claimant code using the
                        Reassign ANG as the major command for                                                         associated Site Table. For any record      associated Site Table.
                        records with command in the RPA Use AF                                                        with a RPA command claimant code of
                        Table equal to “54”.                                                                          N00018 (BUMED) set the managing
                                                                                                                      command to BUMED.
                                                                                                                      Navy is reporting a Region UIC (RUIC)
                                                                                                                      for each asset in the RPA Table. These
                                                                                                                      will be entered into the FXM database
                                                                                                                      for each record. Navy will separately
                                                                                                                      provide a list of RUICs, together with
                                                                                                                      their text names; these will also be
                                                                                                                      associated with each record.
5) Assign location      Assign a country, state (if applicable),       Assign a country, state (if applicable),       Assign a country, state (if applicable),   Assign a country, state (if applicable),   Assign a country, state (if applicable),
                        county, and city to each facility record       county, and city to each facility record       county, and city to each facility record   county, and city to each facility record   county, and city to each facility record
                        based upon the location data, using the Site   based upon the location data, using the Site   based upon the location data, using the    based upon the location data, using the    based upon the location data, using the
                        Address Table for the site at which it is      Address Table for the site at which it is      Site Address Table for the site at which   Site Address Table for the site at which   Site Address Table for the site at which
                        located.                                       located.                                       it is located.                             it is located.                             it is located.
6) Identify             Identify consolidated hospitals (records       Not used for the Army.                         Not used for the Navy.                     Not used for the Marine Corps.             Not used for the WHS.
consolidated hospital   with RPA predominant current use
or medical center       CATCODE code of 510001 or 510101 in
records                 the RPA Table). Record their RPUIDs for
                        use later.




                                                                                                      2                                                                                        7/4/2012
                                                                                            FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX

       STEP                          Air Force                                            Army                                          Navy                                      USMC                                          WHS
7) Remove non-         Identify records with RPA interest code          Identify records with RPA interest code         Identify records with RPA interest code     Identify records with RPA interest code     Identify records with RPA interest code
sustained facilities   of FEE, JVO, LEAS] and grant                     of FEE, JVO, LEAS (and grant                    of FEE, JVO, LEAS (and grant                of FEE, JVO, LEAS (and grant                of FEE, JVO, LEAS (and grant
from the RPI           maintenance indicator = Y), LICN,                maintenance indicator = Y), LICN,               maintenance indicator = Y), LICN,           maintenance indicator = Y), LICN,           maintenance indicator = Y), LICN,
                       ONFA, ONFG, ONST, OPRI, OTHR, and                ONFA, ONFG, ONST, OPRI, OTHR, and               ONFA, ONFG, ONST, OPRI, OTHR,               ONFA, ONFG, ONST, OPRI, OTHR,               ONFA, ONFG, ONST, OPRI, OTHR,
                       PRMT in the RPA Table. Retain these              PRMT in the RPA Table. Retain these             and PRMT in the RPA Table. Retain           and PRMT in the RPA Table. Retain           and PRMT in the RPA Table. Retain
                       records and remove all others.                   records and remove all others.                  these records and remove all others.        these records and remove all others.        these records and remove all others.
                       Identify and eliminate any record with           Identify and eliminate any record with          Identify and eliminate any record with      Identify and eliminate any record with      Identify and eliminate any record with
                       RPA operational status code of DISP in           RPA operational status code of DISP in          RPA operational status code of DISP         RPA operational status code of DISP         RPA operational status code of DISP
                       the RPA Table.                                   the RPA Table.                                  in the RPA Table.                           in the RPA Table.                           in the RPA Table.
                       Identify and eliminate any record with a         Identify and eliminate any record with a        Identify and eliminate any record with a    Identify and eliminate any record with a    Identify and eliminate any record with a
                       RPA facility construction type of R.             RPA facility construction type of R.            RPA facility construction type of R.        RPA facility construction type of R.        RPA facility construction type of R.
                       No other adjustments will be made in this        No other adjustments will be made in this       No other adjustments will be made in        No other adjustments will be made in        No other adjustments will be made in
                       step.                                            step.                                           this step.                                  this step.                                  this step.
                       All Air Force inventory control code X           All leases and relocatable temporary            All leases and relocatable temporary        All leases and relocatable temporary        All leases and relocatable temporary
                       records are to be properly reported if they      facilities are to be properly reported in the   facilities are to be properly reported in   facilities are to be properly reported in   facilities are to be properly reported in
                       are central utility plants or excluded if they   submission to RPAD; there will be no            the submission to RPAD; there will be       the submission to RPAD; there will be       the submission to RPAD; there will be
                       represent real property installed equipment.     separate data call for these.                   no separate data call for these.            no separate data call for these.            no separate data call for these.
                       All leases and relocatable temporary
                       facilities are to be properly reported in the
                       submission to RPAD; there will be no
                       separate data call for these.




                                                                                                        3                                                                                        7/4/2012
                                                                                           FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX

      STEP                          Air Force                                           Army                                             Navy                                          USMC                                            WHS
8) Assign funding     For facility records determine the funding       For facility records determine the funding       For facility records determine the             For facility records determine the             For facility records determine the
organization and      organization and fund source for each            organization for each record using the asset     funding organization for each record           funding organization for each record           funding organization for each record
source                record using the asset allocation                allocation sustainment organization and          using the asset allocation sustainment         using the asset allocation sustainment         using the asset allocation sustainment
                      sustainment organization and the fund            the fund source using the asset allocation       organization and the fund source using         organization and the fund source using         organization and the fund source using
                      source using the asset allocation                sustainment fund source from the RPA             the asset allocation sustainment fund          the asset allocation sustainment fund          the asset allocation sustainment fund
                      sustainment fund source from the RPA             Use Table, The mapping from                      source from the RPA Use Table, The             source from the RPA Use Table, The             source from the RPA Use Table, The
      C-17.xls        Use Table. The mapping from                      organization code to FSM organization            mapping from organization code to              mapping from organization code to              mapping from organization code to
                      organization code to FSM organization            and the mapping from fund source code to         FSM organization and the mapping from          FSM organization and the mapping from          FSM organization and the mapping from
                      and the mapping from fund source code to         FSM fund source are in the Funding               fund source code to FSM fund source            fund source code to FSM fund source            fund source code to FSM fund source
                      FSM fund source are in the Funding               Organization Cross-Reference Table and           are in the Funding Organization Cross-         are in the Funding Organization Cross-         are in the Funding Organization Cross-
                      Organization Cross-Reference Table and           the Fund Source Cross-Reference Table            Reference Table and the Fund Source            Reference Table and the Fund Source            Reference Table and the Fund Source
      C-18.xls        the Fund Source Cross-Reference Table            [C-17 and C-18 at left].                         Cross-Reference Table [C-17 and C-18           Cross-Reference Table [C-17 and C-18           Cross-Reference Table [C-17 and C-18
                      [C-17 and C-18 at left].                                                                          at left].                                      at left].                                      at left].
                                                                                                                        Change the managing command code to            Change the managing command code to
                                                                                                                        N00018 (BUMED) for all records where           N00018 (BUMED) for all records where
                                                                                                                        the funding organization equals TMA.           the funding organization equals TMA.
                                                                                                                        Navy is reporting a Maintenance UIC
                                                                                                                        (MUIC) for each asset in the RPA Table.
                                                                                                                        These will be entered into the FXM
                                                                                                                        database for each record. Navy will
                                                                                                                        separately provide a list of MUICs,
                                                                                                                        together with their text names; these will
                                                                                                                        also be associated with each record.
9) Adjust inventory   Identify and remove any facilities that are      Identify and remove any facilities that are      Identify and remove any facilities that        Identify and remove any facilities that        Identify and remove any facilities that
for inter-Service     permitted in from another Service                permitted in from another Service                are permitted in from another Service          are permitted in from another Service          are permitted in from another Service
permits               Services are to report all of the real           Services are to report all of the real           Services are to report all of the real         Services are to report all of the real         Services are to report all of the real
                      property located on their sites, regardless of   property located on their sites, regardless of   property located on their sites, regardless    property located on their sites, regardless    property located on their sites, regardless
                      what organization funds that property.           what organization funds that property.           of what organization funds that property.      of what organization funds that property.      of what organization funds that property.
                      Similarly, property on a Sister-Service site     Similarly, property on a Sister-Service site     Similarly, property on a Sister-Service        Similarly, property on a Sister-Service        Similarly, property on a Sister-Service
                      is not to be credited to the Service it is       is not to be credited to the Service it is       site is not to be credited to the Service it   site is not to be credited to the Service it   site is not to be credited to the Service it
                      permitted to. Identify and remove all            permitted to. Identify and remove all            is permitted to. Identify and remove all       is permitted to. Identify and remove all       is permitted to. Identify and remove all
                      records with grantor organization code of        records with grantor organization code of        records with grantor organization code         records with grantor organization code         records with grantor organization code
                      00, 01, 02, 06, 07, 08, 09 or 54.                03, 04, 05, 06, 07, 08, 09 or 54.                of 00, 01, 02, 03, 04, 05, 08, 09 or 54.       of 00, 01, 02, 03, 04, 05, 06, 07 or 54.       of 00, 01, 02, 03, 04, 05, 06, 07, 08 or
                      Air Force will provide MAJCOM for each                                                            Navy will provide RUIC and MUIC for                                                           09.
                      Air Force-funded asset on a Sister-Service                                                        each Navy-funded asset on a Sister-
                      installation.                                                                                     Service installation.




                                                                                                       4                                                                                              7/4/2012
                                                                                        FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX

      STEP                         Air Force                                          Army                                           Navy                                         USMC                                             WHS
10) Adjust funding   Identify each record with its CATCODE           Identify each record with its CATCODE          Identify each record with its CATCODE          Identify each record with its CATCODE          Identify each record with its CATCODE
by CATCODE use       listed in the Sustainment Filter Ratio Table    listed in the Sustainment Filter Ratio Table   listed in the Sustainment Filter Ratio         listed in the Sustainment Filter Ratio         listed in the Sustainment Filter Ratio
for DLA fuel         [C-3 at left] that is also assigned to          [C-3 at left] that is also assigned to         Table [C-3 at left] that is also assigned to   Table [C-3 at left] that is also assigned to   Table [C-3 at left] that is also assigned to
facilities           organization code 30-38 (DLA). Split            organization code 30-38 (DLA). Split           organization code 30-38 (DLA). Split           organization code 30-38 (DLA). Split           organization code 30-38 (DLA). Split
                     these records into the percents shown in the    these records into the percents shown in the   these records into the percents shown in       these records into the percents shown in       these records into the percents shown in
                     filter ratio table and assign funding           filter ratio table and assign funding          the filter ratio table and assign funding      the filter ratio table and assign funding      the filter ratio table and assign funding
                     organization(s) and funding source(s) for       organization(s) and funding source(s) for      organization(s) and funding source(s) for      organization(s) and funding source(s) for      organization(s) and funding source(s) for
      C-3.xls        each record. Assign installation                each record. Installation default              each record. Installation default              each record. Installation organization         each record. Installation organization
                     organization and funding defaults to each       organization and fund source to be based       organization and funding codes will be         and funding codes will be 08 (Marine           and funding codes will be 54 and 09
                     installation supported facility record, using   on the managing command for each facility      06 (Navy Active) and 03 (O&M); except          Corps Active) and 03 (O&M); except for         (WHS and WCF),
                     the site command claimant code in the           record, using the site command claimant        for those installations listed on the Navy     installations M67021 and M68479 which
                     Site Table and the Air Force Organizations      code using the Site Table (see step 4). If     Non-O&MN Bases Table [N-11].                   will be 09 (Marine Corps Reserve) and
                     & Fund Sources Cross-Reference Table [F-        managing command is Army Active, that                                                         03 (O&M).
                     3 below] .                                      will be the funding organization and the
                                                                     fund source will be O&M. If managing
                                                                     command is Army Reserve, that will be the            N-11.xls
                                                                     funding organization and the fund source
                            F-3.xls                                  will be O&M. If managing command is
                                                                     Army National Guard, that will be the
                                                                     funding organization and the fund source
                                                                     will be O&M. At Army Active installations
                                                                     that are also listed on Army Installation
                                                                     Fund Codes Table [A-1 below] change the
                                                                     Installation default organization and fund
                                                                     source as indicated in A-1.



                                                                            A-1.xls


11) Adjust funding   Identify all RPA use records measured in        Not used for the Army.                         Not used for the Navy.                         Not used for the Marine Corps.                 Not used for the WHS.
for hospital and     SF with RPUIDs that are parts of hospitals
medical center       or medical centers, by matching RPUIDs
components           to RPA records identified previously (step
                     6). For these records, adjust the FAC to
                     5100 if the RPA predominant current
                     use CATCODE code is 510001, or 5101 if
                     the RPA predominant current use
                     CATCODE code is 510101.




                                                                                                    5                                                                                             7/4/2012
                                                                                      FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX

      STEP                         Air Force                                        Army                                        Navy                                        USMC                                           WHS
12) Adjust funding   For each site, adjust the fund source of       For each installation, adjust the SRM       No adjustments for family housing PPV        No adjustments will be made as part of       No adjustments for family housing
for family housing   records with CATCODEs specified in the         sustainment fund code of records with       will be made in this step. Services are to   this step. Services are to report the real   infrastructure will be made in this step.
infrastructure       Family Housing Infrastructure Category         CATCODEs specified in the Family            report the real property located on their    property located on their sites, at the      Services are to report the real property
 (see Note 1)        Codes Table [C-4 at left], to account for      Housing Infrastructure Category Codes       sites, at the proper level to indicate the   proper level to indicate the separate        located on their sites, at the proper level
                     FH infrastructure. For those sites listed in   Table [C-4 at left], to account for FH      separate funding organizations and fund      funding organizations and fund sources.      to indicate the separate funding
                     the 100% Family Housing Sites Table [F-        infrastructure.                             sources.                                                                                  organizations and fund sources.
                     15 below], do not apply the above              Examine all records with sustainment fund
                     adjustment.                                    source of family housing and reset the
                                                                    funding organization to Army Active (code
                                                                    00), except for records with organization
                                                                    codes for DLA (codes 30 through 38)
                                                                    which will be unchanged.

                     Examine all records with sustainment fund
                     source of family housing and reset the
                     funding organization to Air Force Active
                     (code 03).
13) Assign Defense   For all records where the funding              For all records where the funding           For all records where the funding            For all records where the funding            For all records where the funding
Agency sub-          organization is DLA or DoDEA, assign a         organization is DLA or DoDEA, assign a      organization is DLA or DoDEA, assign         organization is DLA or DoDEA, assign         organization is DLA or DoDEA, assign
organization         subordinate organization as described in       subordinate organization as described in    a subordinate organization as described      a subordinate organization as described      a subordinate organization as described
(see Note 2)         Note 2.                                        Note 2.                                     in Note 2.                                   in Note 2.                                   in Note 2.

14) Add ANG          Add facilities at civilian airfields used by   Not used for the Army.                      Not used for the Navy                        Not used for the Marine Corps.               Not used for the WHS.
facilities           the ANG listed in the Air National Guard
                     Shared-Use Facilities Table [F-6 below] to
                     ANG assets at the installation indicated in
                     the table.




                                                                                                 6                                                                                          7/4/2012
                                                                                           FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX

      STEP                            Air Force                                         Army                                          Navy                                      USMC                                         WHS
15) Adjust for UM       Adjust for closed facilities (including        Adjust for closed facilities (including        Change the RPA operational status           Adjust for closed facilities (including     Adjust for closed facilities (including
differences, Closed,    inactive landfills). Identify records listed   inactive landfills). Identify records listed   code to ACT (active) for all records with   inactive landfills). Identify records       inactive landfills). Identify records
and Excess Facilities   with RPA operational status code of            with RPA operational status code of            funding organization of DLA, DoDEA,         listed with RPA operational status          listed with RPA operational status
                        CLSD or NONF in the RPA Table;                 CLSD in the RPA Table; sustainment costs       or TMA (org code = 30-38, 51, 53).          code of CLSD in the RPA Table;              code of CARE or CLSD in the RPA
                        sustainment costs for these facilities to      for these facilities to zero.                  Adjust for closed facilities (including     sustainment costs for these facilities to   Table; sustainment costs for these
                        zero.                                          Adjust for excess Army facilities. Identify    inactive landfills). Identify records       zero.                                       facilities to zero.
                        Adjust for excess Air Force facilities.        records with organization codes 00, 01, and    listed with RPA operational status          Adjust for excess Marine Corps              Adjust for excess WHS facilities.
                        Identify records with organization codes       02 listed with RPA operational status          code of CARE or CLSD in the RPA             facilities. Identify records with           Identify records with organization code
                        03, 04, and 05 listed with RPA                 code of CARE, EXCS, or SURP in the             Table; sustainment costs for these          organization codes 08 and 09 listed with    54 listed with RPA operational status
                        operational status code of CARE, or            RPA Table; sustainment costs for these         facilities to zero.                         RPA operational status code of CARE,        code of EXCS, or SURP in the RPA
                        EXCS, or SURP in the RPA Table;                facilities to 15 percent.                      Adjust for excess Navy facilities.          EXCS, or SURP in the RPA Table;             Table; sustainment costs for these
                        sustainment costs for these facilities to 15   Adjust for different UM calculation.           Identify records with organization codes    sustainment costs for these facilities to   facilities to 15 percent.
                        percent.                                       Identify records in FAC 8122; adjust the       06 and 07 listed with RPA operational       15 percent.
                        Adjust for mission supported facilities at     sustainment for each to 33% of its original    status code of EXCS, or SURP in the
                        Thule. For all assets at installation WWCX     amount to account for inventory process of     RPA Table; sustainment costs for these
                        that are assigned to Air Force Active/O&M      LF of wire versus LF of circuit.               facilities to 15 percent.
                        (org code = 03 and Fund Code = 03),
                        change the funding to 40 percent Other
                        (Fund Code = 15).
16) Create baseline     Not used for FSM.                              Not used for FSM.                              Not used for FSM.                           Not used for FSM.                           Not used for FSM.
data for current RPI




                                                                                                      7                                                                                        7/4/2012
                                                                                          FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX

      STEP                           Air Force                                        Army                                           Navy                                   USMC                                       WHS
17) Adjust             Adjust the inventory for future changes to     Adjust the inventory for future changes to    Adjust the inventory for future changes   Adjust the inventory for future changes   Adjust the inventory for future changes
inventory through      determine the supported assets through         determine the supported assets through        to determine the supported assets         to determine the supported assets         to determine the supported assets
the FYDP               each year of the FYDP (10-15) using RPA        each year of the FYDP (10-15) using RPA       through each year of the FYDP (10-15)     through each year of the FYDP (10-15)     through each year of the FYDP (10-15)
(see Note 3)           Forecast Tables for Sites, New                 Forecast Tables for Sites, New                using RPA Forecast Tables for Sites,      using RPA Forecast Tables for Sites,      using RPA Forecast Tables for Sites,
                       Construction, Transfers, Aggregate             Construction, Transfers, Aggregate            New Construction, Transfers, Aggregate    New Construction, Transfers, Aggregate    New Construction, Transfers, Aggregate
                       Disposals, Facility Disposals, and Site        Disposals, Facility Disposals, and Site       Disposals, Facility Disposals, and Site   Disposals, Facility Disposals, and Site   Disposals, Facility Disposals, and Site
                       Closures (previously called the Closure        Closures (previously called the Closure       Closures (previously called the Closure   Closures (previously called the Closure   Closures (previously called the Closure
                       Profile Table).                                Profile Table).                               Profile Table).                           Profile Table).                           Profile Table).
                       Air Force will provide MAJCOM for each         Transfer assets (assets being transferred     For records transferring from Army or
                       asset on a Sister-Service installation being   within DoD to the Army) will be assigned      Air Force to the Navy, adjust
                       transferred to the Air Force.                  to the command claimant based on the          organization and fund source codes for
                                                                      sustainment organization code (Army           records as indicated in Table N-12
                                                                      Reserve funding organization will have        below.
                                                                      ARRES as the command claimant, Army
                                                                      National Guard will have ARGUARD as
                                                                      the command claimant, all other records
                                                                      will have ARACT as the command                      N-12.xls
                                                                      claimant,). The transfer funding
                                                                      organization and fund source to be applied
                                                                      to all use records for each specific RPUID.
                                                                      Adjust the funding organization for the
                                                                      new construction records at RPSUID
                                                                      170710 to show funding organization WHS
                                                                      and fund source WCF (org = 54 and fund =
                                                                      09).
18) Adjust funding     Not used for FSM.                              Not used for FSM.                             Not used for FSM.                         Not used for FSM.                         Not used for FSM.
to CATCODE use
rule
19) Apply tenant       Not used for FSM.                              Not used for FSM.                             Not used for FSM.                         Not used for FSM.                         Not used for FSM.
function assignments




                                                                                                    8                                                                                     7/4/2012
                                                                                            FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX

       STEP                           Air Force                                          Army                                            Navy                                       USMC                                          WHS
20) Determine cost      Determine the area cost factor (ACF) for        Determine the area cost factor (ACF) for        Determine the area cost factor (ACF) for     Determine the area cost factor (ACF) for     Determine the area cost factor (ACF) for
factors for location,   each record:                                    each record:                                    each record:                                 each record:                                 each record:
year, and FAC           1. For records with site codes. listed in the   1. For records with site codes. listed in the   1. For records with site codes. listed in    1. For records with site codes. listed in    1. For records with site codes. listed in
                        Area Cost Factors Table [C-10 at left], use     Area Cost Factors Table [C-10 at left], use     the Area Cost Factors Table [C-10 at         the Area Cost Factors Table [C-10 at         the Area Cost Factors Table [C-10 at
                        the ACF specified in the table.                 the ACF specified in the table.                 left], use the ACF specified in the table.   left], use the ACF specified in the table.   left], use the ACF specified in the table.
      C-12.xls          2. For all other records, first determine the   2. For all other records, first determine the   2. For all other records, first determine    2. For all other records, first determine    2. For all other records, first determine
                        city code in which its site is located using    city code in which its site is located using    the city code in which its site is located   the city code in which its site is located   the city code in which its site is located
                        the Site Address Table. Using the city          the Site Address Table. Using the city          using the Site Address Table. Using the      using the Site Address Table. Using the      using the Site Address Table. Using the
                        code, determine the ACF from table C-10.        code, determine the ACF from table C-10.        city code, determine the ACF from table      city code, determine the ACF from table      city code, determine the ACF from table
                        3. For all other records, determine the         3. For all other records, determine the         C-10.                                        C-10.                                        C-10.
      C-10.xls          county code in which its site is located        county code in which its site is located        3. For all other records, determine the      3. For all other records, determine the      3. For all other records, determine the
                        using the Site Address Table. Using the         using the Site Address Table. Using the         county code in which its site is located     county code in which its site is located     county code in which its site is located
                        county code, determine the ACF from table       county code, determine the ACF from table       using the Site Address Table. Using the      using the Site Address Table. Using the      using the Site Address Table. Using the
                        C-10.                                           C-10.                                           county code, determine the ACF from          county code, determine the ACF from          county code, determine the ACF from
                        4. For records whose county is not listed in    4. For records whose county is not listed in    table C-10.                                  table C-10.                                  table C-10.
                        table C-10, determine the state or country      table C-10, determine the state or country      4. For records whose county is not listed    4. For records whose county is not listed    4. For records whose county is not listed
                        in which its site is located using the Site     in which its site is located using the Site     in table C-10, determine the state or        in table C-10, determine the state or        in table C-10, determine the state or
                        Address Table. Using the state or country,      Address Table. Using the state or country,      country in which its site is located using   country in which its site is located using   country in which its site is located using
                        determine the statewide or countrywide          determine the statewide or countrywide          the Site Address Table. Using the state      the Site Address Table. Using the state      the Site Address Table. Using the state
                        average ACF from table C-10.                    average ACF from table C-10.                    or country, determine the statewide or       or country, determine the statewide or       or country, determine the statewide or
                        5. For any remaining records, use an ACF        5. For any remaining records, use an ACF        countrywide average ACF from table C-        countrywide average ACF from table C-        countrywide average ACF from table C-
                        of 1.0.                                         of 1.0.                                         10.                                          10.                                          10.
                        6. Change the ACFs for the following            Determine the sustainment cost factor for       5. For any remaining records, use an         5. For any remaining records, use an         5. For any remaining records, use an
                        PACAF remote sites to the ACF for               each record based upon its FAC using the        ACF of 1.0.                                  ACF of 1.0.                                  ACF of 1.0.
                        Eareckson Air Station (VNMH): BIG               Sustainment, Replacement, Modernization         Determine the sustainment cost factor        Determine the sustainment cost factor        Determine the sustainment cost factor
                        MOUNTAIN RADIO RELAY SITE                       & Operations Factors Table [C-12 at left]       for each record based upon its FAC           for each record based upon its FAC           for each record based upon its FAC
                        (BPLZ) ; CAPE LISBURNE LONG                                                                     using the Sustainment, Replacement,          using the Sustainment, Replacement,          using the Sustainment, Replacement,
                        RANGE RADAR SITE (DBQT); CAPE                                                                   Modernization & Operations Factors           Modernization & Operations Factors           Modernization & Operations Factors
                        NEWENHAM LONG RANGE RADAR                                                                       Table [C-12 at left]                         Table [C-12 at left]                         Table [C-12 at left]
                        SITE (DBST); COLD BAY LONG
                        RANGE RADAR SITE (ECMV); KING
                        SALMON AIRPORT (MFJF);
                        KOTZEBUE LONG RANGE RADAR
                        SITE (MLGD); SPARREVOHN LONG
                        RANGE RADAR SITE (VYLK); TIN
                        CITY LONG RANGE RADAR SITE
                        (WWXD).
                        Determine the sustainment cost factor for
                        each record based upon its FAC using the
                        Sustainment, Replacement, Modernization
                        & Operations Factors table [C-12 at left]



                                                                                                        9                                                                                          7/4/2012
                                                                                         FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX

      STEP                          Air Force                                          Army                                           Navy                                        USMC                                           WHS
21) Calculate          Calculate the sustainment requirement for      Calculate the sustainment requirement for      Calculate the sustainment requirement         Calculate the sustainment requirement         Calculate the sustainment requirement
sustainment            each record and year (FY10 through             each record and year (FY10 through             for each record and year (FY10 through        for each record and year (FFY10 through       for each record and year (FY10 through
requirement for each   FY15), by multiplying the supported asset      FY15), by multiplying the supported asset      FY15), by multiplying the supported           FY15), by multiplying the supported           FY15), by multiplying the supported
record                 by the FAC sustainment cost factor by the      by the FAC sustainment cost factor by the      asset by the FAC sustainment cost             asset by the FAC sustainment cost factor      asset by the FAC sustainment cost factor
(see Note 4)           area cost factor by the inflation factor for   Area Cost Factor by the inflation factor for   factors by the Area Cost Factor by the        by the Area Cost Factor by the inflation      by the Area Cost Factor by the inflation
                       the given year.                                the given year.                                inflation factor for the given year.          factor for the given year.                    factor for the given year.
                       Adjust costs for monumental facilities by      Adjust costs for monumental facilities by      Adjust costs for monumental facilities by     Adjust costs for monumental facilities by     Adjust costs for monumental facilities by
                       multiplying individual facilities listed on    multiplying individual facilities listed on    multiplying individual facilities listed on   multiplying individual facilities listed on   multiplying individual facilities listed on
      C-11.xls         the Monumental Facilities Table [C-21 at       the Monumental Facilities Table [C-21 at       the Monumental Facilities Table [C-21         the Monumental Facilities Table [C-21         the Monumental Facilities Table [C-21
                       left] by a factor of 2.01.                     left] by a factor of 2.01.                     at left] by a factor of 2.01.                 at left] by a factor of 2.01.                 at left] by a factor of 2.01.
                       Determine the inflation rates through the      Determine the inflation rates through the      Determine the inflation rates through the     Determine the inflation rates through the     Determine the inflation rates through the
                       FYDP using the Inflation Factors Table         FYDP using the Inflation Factors Table         FYDP using the Inflation Factors Table        FYDP using the Inflation Factors Table        FYDP using the Inflation Factors Table
                       [C-11 at left].                                [C-11 at left].                                [C-11 at left].                               [C-11 at left].                               [C-11 at left].
      C-13.xls
                       Add “Special Bills” records with               Add “Special Bills” records with               Add “Special Bills” records with              Add “Special Bills” records with              Add “Special Bills” records with
                       predetermined sustainment costs from the       predetermined sustainment costs from the       predetermined operations costs from the       predetermined sustainment costs from          predetermined sustainment costs from
                       Non-Modeled Costs Table [C-13 at left].        Non-Modeled Costs Table [C-13 at left].        Non-Modeled Costs Table [C-13 at left].       the Non-Modeled Costs Table [C-13 at          the Non-Modeled Costs Table [C-13 at
                       Adjust fund source codes for all records for   Adjust fund source codes for all records for   Adjust fund source codes for all records      left].                                        left].
      C-21.xls         the following organization codes: For Org      the following organization codes: For Org      for the following organization codes: For     Adjust fund source codes for all records      Adjust fund source codes for all records
                       Code = 30 thru 38 make Fund Code = 09,         Code = 30 thru 38 make Fund Code = 09,         Org Code = 30 thru 38 make Fund Code          for the following organization codes: For     for the following organization codes: For
                       unless 05, 06, 11, 81, 82, or 83; for Org      unless 05, 06, 11, 81, 82, or 83; for Org      = 09, unless 05, 06, 11, 81, 82, or 83; for   Org Code = 30 thru 38 make Fund Code          Org Code = 30 thru 38 make Fund Code
                       Code = 51 and 53 make Fund Code = 03,          Code = 51 and 53 make Fund Code = 03,          Org Code = 51 and 53 make Fund Code           = 09, unless 05, 06, 11, 81, 82, or 83; for   = 09, unless 05, 06, 11, 81, 82, or 83; for
                       unless 11, 81, 82, or 83; for Org Code = 23    unless 11, 81, 82, or 83; for Org Code = 23    = 03, unless 11, 81, 82, or 83; for Org       Org Code = 51 and 53 make Fund Code           Org Code = 51 and 53 make Fund Code
                       make Fund Code = 11 unless 81, 82, or 83.      make Fund Code = 11 unless 81, 82, or 83.      Code = 23 make Fund Code = 11 unless          = 03, unless 11, 81, 82, or 83; for Org       = 03, unless 11, 81, 82, or 83; for Org
                                                                                                                     81, 82, or 83.                                Code = 23 make Fund Code = 11 unless          Code = 23 make Fund Code = 11 unless
                                                                                                                                                                   81, 82, or 83.                                81, 82, or 83.
22) Sum                Sum sustainment costs for all records by       Sum sustainment costs for all records by       Sum sustainment costs for all records by      Sum sustainment costs for all records by      Sum sustainment costs for all records by
sustainment costs by   FAC and by installation.                       FAC and by installation.                       FAC and by installation.                      FAC and by installation.                      FAC and by installation.
FAC and installation
23) Sum                Sum sustainment costs for each major           Sum sustainment costs for each managing        Sum sustainment costs for each region         Sum sustainment costs for each region         Sum sustainment costs for WHS.
sustainment costs at   command and all Air Force.                     command and all Army.                          and all Navy.                                 and all USMC.
higher levels




                                                                                                    10                                                                                           7/4/2012
                                                               FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX

                                                                                                        NOTES
NOTE         Business rule          Description                                                                                              Methodology
           Adjust funding    Estimates and allocates           Determine the “FH ratio” for the Army installation or Air Force site by dividing all FH-related assets (records with CATCODEs in the Family Housing
Note 1     for FH            the percentage of                  Category Codes Table [C-23 at left]) measured in square feet, by the total non-leased assets on the installation/site measured in square feet:
           infrastructure    infrastructure on an
           (see Step 12)     installation supporting                                        Assets FH SF
                             family housing (a                            FH ratio                                         (for each installation/site)
                             separate fund source).
                                                                                           Assets TotalSF
                                                                    [If this value equals zero (reflecting an absence of FH-related assets), do not proceed to the next step.]

                                                               Split all assets in the specified FH infrastructure CATCODEs [table C-4] for each installation/site into FH-funded and installation-funded:
                                                                     o For records in CATCODEs labeled “RATIO” in table C-4, multiply the asset size for each record by the FH ratio above to obtain the FH asset
                                                                           allocation:


                                                                           Asset FH infrastructure  FH ratio  Asset infrastructure

                                                                     o    For records in CATCODEs labeled with a fixed percentage in table C-4 and a FH ratio greater than zero, multiply the asset size for each record by
                                                                          this percentage to obtain the FH asset allocation:

                                                                           Asset FH infrastructure  Fixed %  Asset infrastructure

                                                                     o    Adjust the fund source for these assets to FH. Make the asset size of the installation/site infrastructure assets equal to the remainder, so that
                                                                          installation infrastructure/site assets + FH infrastructure assets = 100% of total infrastructure assets:

                                                                           Asset installation infrastructure  Asset infrastructure  Asset FH infrastructure

           Assign Defense    Assigns facilities        For all RPA use records where the asset allocation sustainment organization is DLA (codes 30-38) or DoDEA (code is 51), assign the sub-organization (area) as
Note 2     Agency sub-       belonging to specified    follows:
           organizations     Defense Agencies to                For DLA facilities assign business areas as indicated in DLA Business Areas Table [C-15] at right. DESC records will get organization code 33 and DAPS
           (see Step 13)     subordinate                         will get code 37.
                             organizations of those             For facilities in a country or state listed in the DoDEA Areas Table [C-16 at left], use the area specified.
C-15.xls
                                                                For any remaining DoDEA facilities, use the area “Other.”
                             agencies




                                                                          11                                                                                            7/4/2012
                                                               FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX
NOTE       Business rule          Description                                                                                      Methodology
         Adjust inventory   Adjusts the baseline      Starting with the baseline inventory of facilities, make adjustments as follows to forecast the inventory to year 1 of the FYDP:
Note 3   through the        (current) inventory to             Subtract asset disposals scheduled for completion through year 1. The completion year or effective year of a disposal is considered to be the year following
         FYDP               account for future                  the program year. Where disposals are identified by facility, adjust the record’s asset to zero; adjust all assets that have the same RPUID that is listed in the
         (see Step 17)      changes                             RPA Forecasts Facilities Disposal Table, regardless of FAC or funding responsibility. Where disposals are identified in aggregate by FAC and installation,
                                                                add a record with an asset value equal to the negative of the disposal amount.
                                                               Add new construction scheduled for completion through year 1. The completion year or effective year of new construction is considered to be the second
                                                                year following the program year. Add a record for the new construction amount by FAC and installation.
                                                               Adjust for transfers through year 1. Where identified, adjust the organization to that specified (usually, a defense agency return to the host service). The
                                                                effective year of a transfer is considered to be the program year.

                                                      To project inventory for each of the following years (year 2 through year 6) of the FYDP:
                                                               Subtract asset disposals scheduled for completion in year 2, as described above.
                                                               Add new construction scheduled for completion in year 2, as described above.
                                                               Adjust for transfers in year 2, as described above.
                                                               Adjust for excess assets identified in that year, as described above.
                                                               Repeat for years 3 through 6.

                                                      For all new records (i.e., new construction and aggregate-type disposals), assign a location, managing command using the methodology for existing facility records.
                                                      (For Navy forecasts, this requires using the Activity/installation default location from the installation table.)

                                                      Report projected inventory using the following terms:

                                                               Active Asset = projected on-hand asset less excess asset and closed asset.

                                                                         AssetActive = Asseton-hand — AssetExcess — Assetclosed                        (for any given FAC and
                                                                                                                                                         prime/parent installation)

                                                               Supported Asset = active asset plus the percentage of sustainment support to excess assets (15%) times the excess asset.

                                                                         AssetSupported = AssetActive           + (15%  AssetExcess ) (for any given FAC and prime/parent installation)

         Calculate          Calculates the            The supported asset size of each record will have already been determined for each FYDP year (see step 15 and step 17) The supported asset is generally the actual
Note 4   sustainment        contribution of each      size of a record, but can also be less that the actual size (for excess or closed facilities). Starting with the supported asset and FYDP year, the sustainment requirement
         requirement for    record toward the         is calculated as follows:
         each record in     sustainment benchmark
         each year          requirement.                       Sustainment Requirement =        AssetSupported  Sustainment Cost FactorFAC  Sustainment Area Cost FactorSite 
         (see Step 21)      Sustainment requirement                                                                                                                      Inflation
                            values do not represent
                                                       Factoryear
                            the exact sustainment
                            dollars required in any
                            year by the specific
                            facility.

                                                                         12                                                                                            7/4/2012
                                                                      FSM-12 BUSINESS RULE SYNCHRONIZATION MATRIX
FSM Reference Tables (not all tables listed are used for FSM)

                FSM-11 Common Tables
 Table                          Description
                                                                                        FSM-11 Air Force Tables                                   FSM-11 Army Tables
                                                                                Table                    Description                    Table                Description
C-2      No longer used
C-2a     No longer used                                                         F-1      No longer used                                 A-1     Army Installation Fund Codes Table
C-2b     No longer used                                                         F-2      No longer used                                 A-2     No longer used
C-2c     No longer used                                                                  Air Force Organizations & Fund                 A-3     No longer used
C-2d     No longer used                                                         F-3      Sources Cross-Reference Table                  A-4     No longer used
C-3      Sustainment Filter Ratio Table                                         F-4      No longer used                                 A-5     No longer used
C-3a     NAF Breakout Table (used for FOM only)                                          Air National Guard Shared-Use                  A-6     No longer used
C-3b     Remote & Isolated Locations Table (used for FOM only)                  F-6      Facilities Table                               A-7     No longer used
C-3c     Host/Tenant Breakout Table (used for FOM only)                         F-7      No longer used                                 A-8     No longer used
C-4      Family Housing Infrastructure Category Codes Table                     F-8      No longer used                                 A-9     No longer used
C-5      No longer used                                                         F-9      No longer used                                         Army National Guard Agreement Support
C-6      No longer used, data will be included with basic inventory             F-10     No longer used                                 A-10    Codes with Federal Support % Table
C-7      No longer used, data will be included with basic inventory             F-11     No longer used                                         Army Utilization Adjustments Table
C-8      Closure Profile Table                                                           Air Force Command Tenant Codes as              A-11    (used for FOM only)
C-9      No longer used, data will be included with basic inventory             F-12     MAJCOMs Table                                  A-12    No longer used
C-10     Area Cost Factors                                                      F-13     No longer used                                 A-13    No longer used
C-10a    Locality Indices Tables (used for FOM only)                                     Air National Guard Federal Share
C-11     Inflation Factors Table                                                F-14     Table (used for FOM only)
C-11a    Horizontal FACs (used for FMM only)                                    F-15     100% Family Housing Sites Table
                                                                                                                                                  FSM-11 Navy Tables
         Sustainment, Replacement, Modernization & Operations                   F-16     No longer used
C-12     Factors Table                                                          F-17     No longer used                                 Table                Description
C-12a    No longer used
                                                                                                                                        N-1     No longer used
C-13     Non-modeled Costs Table
                                                                                                                                        N-2     No longer used
C-14a    No longer used
                                                                                                                                        N-3     No longer used
C-14b    No longer used
                                                                                                                                        N-3     No longer used
C-15     DLA Areas Table                                                                 FSM-11 USMC Tables                             N-4     No longer used
C-16     DoDEA Areas Table
                                                                                Table                Description                        N-5     No longer used
C-17     Funding Organization Cross-Reference Table
                                                                                                                                        N-6     No longer used
C-18     Fund Source Cross-Reference Table                                      M-1     No longer used                                  N-7     No longer used
C-19     No longer used, data will be included in basic inventory               M-2a    No longer used                                  N-8     No longer used
C-20     Relocatable Assets Table (used for FOM only)                           M-2b    No longer used                                  N-9     No longer used
C-21     Monumental Facilities Table
                                                                                                                                        N-10    No longer used
C-22     No longer used
                                                                                                                                        N-11    Navy Non-O&MN Bases Table
C-23     Family Housing Category Codes Table
                                                                                                                                        N-12    Navy Joint Base Transfer Adjustments
C-24     Historic Facility Indicator Table (used for FMM only)
C-25     DESC Operated Sites (used for FOM only)
                                                                           13                                                7/4/2012

								
To top