Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCNTMOD


                             ACCNTMOD FILE

Contracts can be incrementally funded.  Throughout the contract life the
dollar amount, point of contact, and period of performance dates may change.
The system maintains an audit trail of modifications if the modifications
audit flag on the activity group is set to yes.  A modification is a record of
contract changes.  This  file maintains contract modifications to allow the
user to track these changes. This file represents a map of the ACCNTMOD fields
that will update the ACADDLCNTR file after approval. The "new" values will be
come "current" values in the ACADLCNTR file. The primary program that updates
this file is  BR10.5.

REFERENCED BY

BR212     BR90.1

UPDATED BY

AC300     BR10.5    BR10.8    BR10.1    BR10.4    PW110


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CMD-CONTRACT           Alpha 15                                  BR10.5
Element: Contract      The contract that is being modified.
                       The contract is created on BR10.1 and
                       modified on BR10.5.

CMD-ACTIVITY-GRP       Alpha 15                                  BR10.5
Element: Activity Grp  The activity group associated with the
                       contract related to this record.

CMD-MOD-NBR            Alpha 15  (Lower Case)                    BR10.5
Element: Mod Nbr       The user defined Contract Modification
                       Number created in Contract Modification
                       (BR10.5).

CMD-MOD-DATE           Numeric 8  (yyyymmdd)                     BR10.5
Element: Mod Date      The date the contract was modified. The
                       date will default to the system date if
                       left blank.

CMD-CRT-CREATOR        Alpha 30                                  BR10.5
Element: Crt Creator   The user who created the modification.

CMD-APPROVAL-DESC      Alpha 30  (Lower Case)                    BR10.8
Element: Approval Desc The status description.
                       The translations are:
                       Unapproved
                       Approved

CMD-LONG-DESC          Alpha 60  (Lower Case)                    BR10.5
Element: Long Desc     The Long description of the
                       modification maintained in Contract
                       Modification  (BR10.5).

CMD-APPROVAL-DATE      Numeric 8  (yyyymmdd)                     BR10.8
Element: Approval Date The date of the approval.  This is
                       system generated.

CMD-STATUS-CD          Alpha 1                                   BR10.5  BR10.8
Element: Status Cd     The Status Code.
                       The values are:
                       A = Approved
                       U = Unapproved

CMD-PR-CNT-COST        Signed 18.2                               BR10.5
Element: Intl Amt      Previous contract cost amount maintained
                       in Additional information (BR10.4).

CMD-PR-CNT-VAL         Signed 18.2
Element: Intl Amt      The previous Contract Value which is
                       derived from the cost amount and the fee
                       amount.

CMD-PR-CNT-FEE         Signed 18.2                               BR10.5
Element: Intl Amt      The previous Contract Fee maintained in
                       Additional Information (BR10.4)

CMD-ENTR-CNT-COST      Signed 18.2                               BR10.5
Element: Intl Amt      The entered contract cost amount
                       maintained in Contract Modification
                       (BR10.5).

CMD-ENTR-CNT-VALUE     Signed 18.2
Element: Intl Amt      The sum of the entered contract cost and
                       the entered contract fee amounts.

CMD-ENTR-CNT-FEE       Signed 18.2                               BR10.5
Element: Intl Amt      The entered Contract Fee Amount
                       maintained on Contract Modification
                       (BR10.5).

CMD-NEW-CNT-COST       Signed 18.2                               BR10.5
Element: Intl Amt      The new Contract Cost Amount.

CMD-NEW-CNT-FEE        Signed 18.2                               BR10.5
Element: Intl Amt

CMD-NEW-CNT-VAL        Signed 18.2                               BR10.5
Element: Intl Amt

CMD-PR-AWD-COST        Signed 18.2                               BR10.5
Element: Intl Amt

CMD-PR-AWD-VAL         Signed 18.2
Element: Intl Amt

CMD-PR-AWD-FEE         Signed 18.2                               BR10.5
Element: Intl Amt

CMD-ENTR-AWD-COST      Signed 18.2                               BR10.5
Element: Intl Amt

CMD-ENTR-AWARD-VAL     Signed 18.2
Element: Intl Amt

CMD-ENTR-AWARD-FEE     Signed 18.2                               BR10.5
Element: Intl Amt

CMD-NEW-AWARD-COST     Signed 18.2                               BR10.5
Element: Intl Amt

CMD-NEW-AWARD-FEE      Signed 18.2                               BR10.5
Element: Intl Amt

CMD-NEW-AWD-VAL        Signed 18.2                               BR10.5
Element: Intl Amt

CMD-PR-FUND-COST       Signed 18.2                               BR10.5
Element: Intl Amt

CMD-PR-FUND-VAL        Signed 18.2
Element: Intl Amt

CMD-PR-FUND-FEE        Signed 18.2                               BR10.5
Element: Intl Amt

CMD-ENTR-FUND-COST     Signed 18.2                               BR10.5
Element: Intl Amt

CMD-ENTR-FUND-VAL      Signed 18.2
Element: Intl Amt

CMD-ENTR-FUND-FEE      Signed 18.2                               BR10.5
Element: Intl Amt

CMD-NEW-FUND-COST      Signed 18.2                               BR10.5
Element: Intl Amt

CMD-NEW-FUND-FEE       Signed 18.2                               BR10.5
Element: Intl Amt

CMD-NEW-FD-VALUE       Signed 18.2                               BR10.5
Element: Intl Amt

CMD-PR-CNT-HOURS       Signed 18.2                               BR10.5
Element: Intl Amt

CMD-PR-AWD-HOURS       Signed 18.2                               BR10.5
Element: Intl Amt

CMD-PR-FUND-HOURS      Signed 18.2                               BR10.5
Element: Intl Amt

CMD-ENTR-CNT-HOURS     Signed 18.2                               BR10.5
Element: Intl Amt

CMD-ENTR-AWD-HOURS     Signed 18.2                               BR10.5
Element: Intl Amt

CMD-ENTR-FD-HOURS      Signed 18.2                               BR10.5
Element: Intl Amt

CMD-NEW-CNT-HOURS      Signed 18.2                               BR10.5
Element: Intl Amt

CMD-NEW-AWD-HOURS      Signed 18.2                               BR10.5
Element: Intl Amt

CMD-NEW-FD-HOURS       Signed 18.2                               BR10.5
Element: Intl Amt

CMD-PR-TO-TOT-POP      Numeric 8  (yyyymmdd)                     BR10.5
Element: Pr To Tot Pop Previous Contract Begin Date - Contract
                       Period  of Performance Dates.
                       Informational only.

CMD-PR-FR-TOT-POP      Numeric 8  (yyyymmdd)                     BR10.5
Element: Pr Fr Tot Pop Previous Contract End Date - Period of
                       Performance Dates.  Informational only.

CMD-NEW-TO-TOT-POP     Numeric 8  (yyyymmdd)                     BR10.5
Element: New To Tot PopNew Contract Begin Date - Period of
                       Performance Dates.  Informational only.

CMD-NEW-FR-TOT-POP     Numeric 8  (yyyymmdd)                     BR10.5
Element: New Fr Tot PopNew Contract End Date - Period of
                       Performance Dates.  Informational only.

CMD-PR-TO-AWD-POP      Numeric 8  (yyyymmdd)                     BR10.5
Element: Pr To Awd Pop Previous Award Begin Date - Period of
                       Performance Dates.  Informational Only.

CMD-PR-FR-AWD-POP      Numeric 8  (yyyymmdd)                     BR10.5
Element: Pr Fr Awd Pop Previous Award End Date - Period of
                       Performance Dates.  Informational only.

CMD-NEW-TO-AWD-POP     Numeric 8  (yyyymmdd)                     BR10.5
Element: New To Awd PopNew Award Begin Date - Period of
                       Performance Dates.  Informational only.

CMD-NEW-FR-AWD-POP     Numeric 8  (yyyymmdd)                     BR10.5
Element: New Fr Awd PopNew Award End Date - Period of
                       Performance Dates.  Informational only.

CMD-PR-TO-FD-POP       Numeric 8  (yyyymmdd)                     BR10.5
Element: Pr To Fd Pop  Previous Funded Begin Date - Period of
                       Performance Dates.  Informational only.

CMD-PR-FR-FD-POP       Numeric 8  (yyyymmdd)                     BR10.5
Element: Pr Fr Fd Pop  Previous funded period of performance
                       begin date.  Informational only.

CMD-NEW-TO-FD-POP      Numeric 8  (yyyymmdd)                     BR10.5
Element: New To Fd Pop New funded period of performance begin
                       date.  Informational only.

CMD-NEW-FR-FD-POP      Numeric 8  (yyyymmdd)                     BR10.5
Element: New Fr Fd Pop New funded period of performance end
                       date.  Informational only.

CMD-TIME               Numeric 8                                 BR10.8
Element: Time          This field is updated automatically to
                       indicate the time that the record was
                       created or maintained. It is
                       system-maintained.

                         ACCNTMOD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CMDSET1   CONTRACT                                               BR10.1  BR10.4
          MOD-NBR                                                BR10.5  BR10.7
                                                                 BR10.8  BR212
                                                                 BR90.1  PW110

CMDSET2   CONTRACT      KeyChange                                BR10.5  BR90.1
          APPROVAL-DATE
          TIME
          MOD-NBR

CMDSET4   ACTIVITY-GRP  KeyChange                                AC300   BR90.1
          CONTRACT
          MOD-NBR

CMDSET5   ACTIVITY-GRP  KeyChange                                BR90.1
          CONTRACT
          APPROVAL-DATE
          TIME
          MOD-NBR

                         ACCNTMOD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Required

                            CMD-CONTRACT    -> CNT-CONTRACT

                         ACCNTMOD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntadx       ACCNTADX

                            CMD-CONTRACT    -> CMA-CONTRACT
                            CMD-MOD-NBR     -> CMA-MOD-NBR
                                               CMA-MATRIX-CAT