The Cost Accounting Modification (CAM) document is the vehicle by which the setup established in multiple cost accounting-related tables is updated by a single document. The purpose of this document type is to facilitate a more efficient means of adding, modifying or deleting what was entered by the Cost Accounting Setup (CAS) document. It also addresses the ability to create a new budget line and/or modify the existing Budget line.
The CAM document may not be cancelled or modified once final.
The CAM document allows for the modification of the following:
a Major Program (MJPRG) table record
Program Setup (PROG) table record(s)
Program Period (PPC) table record(s)
Program Phase (PHPRG) table record(s)
Funding Profile table record(s)
Funding Priority table record(s)
Funding Line table record(s)
Internal Buyer Funding Line table record(s)
Funding Profile Inference 5 table, Grant Funding Profile Inference, Funding Profile Inference 2 record(s), and
Budget documents (structures 37 (BGPHE), 38 (BGPDE), 39 (BGPDR), and 40 (BGPHR) respectively).
Note: Attachments added to the following sections are included with the record when it is added to the corresponding reference table upon submitting the document to Final. You can manage the attachments from the reference tables by selecting the Attachments link.
Major Program (MJPRG) table record
Program Setup (PROG) table record(s)
Program Period (PPC) table record(s)
Program Phase (PHPRG) table record(s)
Funding Line table record(s)
Once submitted, the CAM document code does not allow any further modifications. If any modifications are subsequently needed, changes are made directly within the aforementioned table and budget documents.
This document contains the following sections:
|
The Header section allows you to enter data within the standard Document Name, Record Date, Budget FY, Fiscal Year, Period, and Document Description fields. The system displays information regarding the document history (that is, the Created By, Created On, Modify By, and Modify On fields). |
|
Within this section, you can modify information related to the Major Program, which defines the high-level initiative under which funds are received and identifies global characteristics for all Programs defined within that Major Program . The CAS document allows you to specify only one Major Program per document; therefore, the system only allows one Major Program line per CAM document. If you wish to modify multiple Major Programs, a separate CAM document needs to be submitted for each Major Program. The CAM document makes updates only to existing Major Programs and its hierarchy records, either by modifying the existing attributes or by adding hierarchy records to the Major Program. A Major Program cannot be created using a CAM Document. If the Major Program record does not exist on the Cost Accounting setup tables it must be added via the CAS document or via direct table entry. User will be able to modify the values loaded on to the Major Program tab in CAM document except for Split Type. Once the CAM document is successfully submitted, the system will update the Major Program (MJPRG) table with the changes made to it. |
|
Within this tab, the user will enter information related to a Program, which defines the breakdown of Major Program based on budgeting, reporting and/or Chart of Accounts inference requirements. Within the document, each Program line will be a child record of the Major Program line and multiple lines are allowed. Under the Program tab, the CAM document will allow line types of Add and Modify. The Program tab will also include the Load Value link. This will add the values related to the Program selected from Program table on to the Program tab of the CAM document. Users will be required to select and load each Program record that is being updated. There will not be an option to load all children Program records for a single Major Program. A new Program code can be automatically generated from the Cost Accounting Modification (CAM) document when the Line Type is Add. If the Program field is blank and the Auto Generate flag is selected when validating or submitting the CAM document, the system will automatically generate the Program code if a matching record is found on the Cost Accounting Auto Numbering (AUTOCANO) page. Refer to the CAM page help and field help for more information. Once the CAM document is successfully submitted, the system will update the Program (PROG) table with the changes made to it. |
|
Within this section, you can enter information related to a Program Period, which establishes award periods (or Cost Accounting fiscal years) under each Major Program entered on CAM documents Major Program tab. Within the document, each Program Period line will be a child record of the Major Program line and multiple lines are allowed. The CAM Program Period tab will allow line types of Add and Modify. The existing Program Period values can be loaded by using the Load Program Period Details link in the Major Program tab. The loaded Program Period Codes can be modified by using the line type of Modify, or you can enter an existing Program Period value via data entry. You can also create new Program Period Codes using the line type of Add. You cannot modify the key fields of Department, Program Period and Major Program. The Program Period table has specific edits that govern PPC Inference Date sequencing. When the Load Program Period Details link is selected you will be able to see all the Program Period records related to Major Program to ease the Program Period record modification. If new PPC records are being inserted without loading the existing PPC records for a Major Program, the effective from and to date specified in the new record will be validated against the dates of the records existing for the Major Program in PPC Table. If the dates specified in the new record fall within the dates previously available in PPC Table, you will receive an error. If you are adding records without loading existing PPC records, care should be taken that the Dates specified in the new PPC record does not fall within the dates available in the PPC Table. Once the CAM document is successfully submitted, the system will update the Program Period (PPC) table with the changes made to it. |
|
Within this tab, you will be able to enter information related to a Program Phase, which associates a Phase to a specific Program . Within the document, each Program Phase line will be a child record of the Program line and multiple lines are allowed. The system allows new Program Phase values to be entered. To modify an existing record use the Load Values link. All the Program Phase attributes will be loaded & then you can modify the same record. Users will be required to select and load each Program Phase record that is being updated. There will not be an option to load all children Program Phase records for a single Program. Once the CAM document is successfully submitted, the system will update the Program Phase (PHPRG) table with the changes made to it. |
|
The reimbursement structure is a hierarchy of four levels: the Funding Profile, Funding Priority, Funding Line, and Internal Buyer Funding Line. The reimbursement structure specifies how expenditures will be submitted for reimbursement from the Program’s funding source(s). It also captures the funding levels and match rates provided by the funding sources both for budgetary control and to generate reimbursement requests from the funding sources. The Funding Profile is directly related with Major Program. Through the CAM document, the Funding Profile related to Major Program can be added or modified. To modify the record select the Load Funding Profile link which will then display the existing attributes of Funding Profile. If Load Funding Profile Link is selected, the attributes for any child records (Funding Priority, Funding Lines, and Internal Buyer Lines) for that Funding Profile will load to the respective CAM section. You will be required to select and load each Funding Profile record that is being updated. There will no option to load all children Funding Profile records for a single Major Program . If the Major Program has Split Type of either FES or BES, an edit evaluates whether there is a Funding Profile. Once the CAM document is successfully submitted, the system will update the Funding Profile (FPRFLST) table with the changes made to it. |
|
A Funding Priority allows you to specify the “stages” of billing for a Funding Profile. It is used to define one or more sequential billing ceilings according to the agreements with funding sources. Within the document, each Funding Priority line will be a child record of the Funding Profile line and multiple lines are allowed. There is no Load Value link available on the CAM document. If you wish to modify the existing Funding Priority record then select a Funding Profile record and on the Funding Profile tab, select the Load Funding Profile Details link. All the child records such as Funding Priority attributes will be loaded on to the Funding Priority section. You can then modify the values on the Funding Priority section. Once the CAM document is successfully submitted, the system will update the Funding Priority table with the changes made to it. |
|
The Funding Line allows the user to identify the billing information related to a specific Customer within a Funding Profile and Funding Priority. Within the document, each Funding Line is a child record of the Funding Priority line and multiple lines are allowed. Within a Funding Priority, one or more Funding Lines must exist to identify the funding sources. Therefore, the system will issue an error if the document is validated or submitted and there is not a child Funding Line for each of the document’s Funding Priority lines. The CAM document requires a total of the reimbursement percentages on funding lines to equal 100%. In this section the Load Value link is not available. If you wish to modify or delete an existing Funding Line record then select a Funding Profile record and select the Load Funding Profile Details link. All the child records such as Funding Line attributes will be loaded on to the Funding Line section. You can then modify the values. Once the CAM document is successfully submitted, the system will update the Funding Line table with the changes made to it. |
Internal Buyer Funding Line Section
|
The Internal Buyer Funding Line allows you to identify one or more buyer codes to be associated with inter-governmental payments for a specific Funding Line. The percentages entered within this Internal Buyer Funding Line are used to split the expenditures among multiple internal buyers to support inter-governmental service agreements. On an Add or Modify an error is issued if the total of the Internal Buyer Funding Line % values does not equal 100.00% for a given Department/Major Program /Funding Profile/Funding Priority/Funding Line (note that this error is specific to the documents only and is not invoked on the Internal Buyer Funding Line table). Within the document, each Internal Buyer Funding Line will be a child record of the Funding Line and multiples lines are allowed. The Load Value link is not available. To modify an existing Internal Buyer Funding Line record select a Funding Profile record select the Load Funding Profile Details link. All the child records such as Funding Line and Internal Buyer Funding Line attributes will be loaded on to the Funding Line section. You can then modify the values. An Internal Buyer Funding Line can be deleted. Once the CAM document is successfully submitted, the system will update the Internal Buyer Funding Line table with the changes made to it. |
Funding Profile Inference Section
|
The baseline Funding Profile Inference tables define the inference rules for the Funding Profile codes to be used by accounting and procurement documents. Within the CAM document, the Funding Profile Inference tab will allow you to link a Program or Program Phase code to a Funding Profile code. The Funding Profile Inference lines are not children records of any other document component. Multiples lines are allowed. Records can be added or modified but the Load Value link is not available because you must to enter the values manually to set the Cost Accounting COA combination. FPI5, GFPI and FPI2 tables are supported in the CAM document Once the CAM document is successfully submitted, the system will update the Funding Profile Inference information in the respective table. |
|
The Budget tab allows you to specify what budget document for example, for structures (37 (BGPHE), 38 (BGPDE), 39 (BGPDR), and 40 (BGPHR) respectively) and budget lines are to be created. The Budget lines are not children records of any other document component. Multiples lines are allowed. The system will issue an error if the Major Program does not have Split Type equal to Front End Split (FES) or Back End Split (BES) and the Budget Type ID is equal to 4 for the budget structure ID associated with the specified Budget Doc Code value. The CAM document will have both New and Modify actions but either option creates a new budget document because existing budget cannot be modified but existing budget lines will be updated after successful submission of the budget document created through the CAM document. The CAM document will have following additional functionality as compared to CAS document:
Budget Document Generation Logic Each line within the Budget tab will be a separate line within the generated budget document, which will be created, loaded and submitted after successful submission of the CAM document. Where the Funding Priority radio button is selected, Funding Priority budget line will result in one or more Funding Line budgets being generated. The type of budget document generated depends on the Budget Doc Code field value within the Budget line. For example:
Any cloned budget documents set up on BSBD may also be generated if the cloned document code is selected on the CAM document. The budget document’s Doc Code and Doc Dept will is equal to the Budget Doc Code and Department value specified within the Budget line. The Doc ID will be an auto-generated number, based on the automatic document numbering functionality. The system shall issue an error if the COA fields populated within that Budget line are not applicable to the budget structure specified. The COA fields that are required are determined by looking up the BUDST table record for the Structure ID associated with the specified Budget Doc Code. The CAM will create budget lines on the spawned budget document as follows:
Budget Document Breaking Logic There can be multiple Budget lines within a CAM document. The system will evaluate all Budget lines and determine whether any can be combined into the same budget document that is to be automatically generated. The following logic is from the original CAS document design: A smart budget rollup is automatically performed on generated budget documents. The action values of Activate, De-activate and Delete require that you record all levels of the budget that are being updated. The Smart Budget Rollup function is not executed when the action is Activate, De-activate or Delete. In CAM Document, all generated budget documents are submitted when the CAM document is submitted. The Created Budget Documents tab should list the generated documents. |
|
The Created Documents section displays the document information related to the reimbursable budget documents that are created as a result of the CAS or CAM document being processed to Final. |