Budgetary Accounts Payable w/o Activity for 12 Months Report

Provides DOE Budgetary Accounts Payable information on accounts w/o activity for
12 Months

Provides a detailed listing of PO Budgetary Accounts Payable balances as reported on the 2108 that are old and have had no activity for the past 12 months. Initially developed to support the CFO Tiger Team's FM-PMO 2108 Issue.

Parameters: Allottee From, Allottee To, Fund Parent, Period Name

SGL Values: 41720000, 49010000, 49310000, 49710000, 49810000
Excluded Periods: Periods 1 and 15.
Uses Custom CID table

Budgetary Accounts Payable w/o Activity for 12 Months Report (CSV output)

Provides DOE Budgetary Accounts Payable information on accounts w/o activity for
12 Months

Provides a detailed listing of PO Budgetary Accounts Payable balances as reported on the 2108 that are old and have had no activity for the past 12 months. Initially developed to support the CFO Tiger Team's FM-PMO 2108 Issue.

Parameters: Allottee, Fund Parent, Period Name

DOE AP by CID Abnormal Balance Variance Report (CSV output)

SGL: 21000000 – 21zzzzzz

• Only display those CIDs in where the Net Amount is greater than zero (abnormal balance).

DOE Abnormal Balances by Trading Partner Report (Text Output)

Assists in the identification of abnormal SGL Debit/Credit charges

Identifies abnormal SGL Debit/Credit amounts rolled up by Allottee, Reporting Entity, SGL and Trading Partner

Parameters:

• Period Name (required)
• Display Type (required) – derived from the DOE_CGLABTPR_DISP_TYPES value set. Possible values are: “SGL”, “ALLOTTEE, SGL”, “ALLOTTEE, REPORTING ENTITY, SGL”
• Allottee From (optional)
• Allottee To (optional)
• Reporting Entity From (optional)
• Reporting Entity To (optional)

1. The main table used is the GL_JE_LINES and not the GL_BALANCES table.
2. The SGL range is to only pick up Proprietary Accounts which are 00000000 – 3zzzzzzz and 50000000 – zzzzzzzz. It excludes the Budgetary Accounts of 40000000 - 4zzzzzzz.
3. Obtains the SGL ranges from the Abnormal Balance by Allottee Column Set.
4. If the SGL has a Debit Flag and the Debit amount is less than zero, then the record will be displayed as an exception. If the SGL has a Credit Flag and the Credit amount is greater than zero, then the record will be displayed as an exception. Only those records with a trading partner will be displayed.

DOE Abnormal Balances Report (CSV output)

Assists the GL Functional Team to spot any abnormal SGL Debit/Credit amounts based on the Category (see parameters for list of categories).

Report will facilitate end users being able to routinely review all abnormal balances

Parameters:

• As of Period (required)
• Category (optional) – derived from the DOE_CGLABRCSV_CATEGORIES value set which will continue to grow. Possible sample values are: “Proprietary Accounts Receivable”, “Proprietary Advances”, “Proprietary All Other”, “Budgetary Accounts Payable”, “Budgetary Reimbursements Earned”, ”Budgetary Undelivered Orders”, ”Budgetary Unfilled Customer Orders”
• Display Type (required) – derived from the DOE_CGLABRCSV_DISP_TYPES value set. Possible values are: “ALLOTTEE, FUND, REP ENTITY, SGL, WFO, CID, TP” or “AFF, CID, TP”
• Allottee From - To (optional)
• Reporting Entity From - To (optional)
• Parent Fund (optional)
• Fund From - To (optional)
• PO Number From - To (optional)

• Obtains the debit credit flag from the Abnornal Balance by Allottee Column Set for a given SGL.
• Column Set used for the SGL ranges of the different categories: CGLABRCSV
• For the Category of Proprietary All Other, if the SGL has a Debit Flag and the Debit amount is less than zero, then the record will be displayed as an exception. If the SGL has a Credit Flag and the Credit amount is greater than zero, then the record will be displayed as an exception.
• Exclude those records in where the Local Use is 9500000 and Fund is 02501.
• If the Account Type is either ‘D’ or ‘C’ signifying a Budgetary Type, the data will be obtained from the custom.c_gl_cid_balances table. Otherwise, the data will be obtained from the gl_je_lines table.

DOE Accounts Payable Trading Partner Variances Report w/o TP Count Logic (CSV output)

• The logic to count the number of distinct trading partners has been excluded from this report in order to speed up performance

• SGL: 21100000 – 2190zzzz and 61000000
• Include the CID smart logic lookup
• Exclude IC CIDs and NULL CIDs
• If the user does not specify a CID in the parameters, then the report will attempt to find all CIDs that contain more than one distinct trading partner.
• If at least one CID/SGL (2-digit) contains more than one trading partner, then display the entire CID records on the report.

DOE Account Analysis Report (CSV output)

This report provides the full AFF string and includes the capability to select on specific source and/or category values of journal data

Report facilitates research and analysis of combination and balancing edit errors

Parameters: Type, Currency, Balance Type, Budget or Encumbrance Name, Starting Period, Ending Period, JE Source, JE Category, Flexfield From, Flexfield To

DOE Accrual Detail Report (CSV output)

This report will replace the "Accrual Formula" column in the DOE Accrual QA Report.

• Status is ‘NEW’
• Accrual amount > 0
• SGL ‘21900000’
• Future value ‘000000’

DOE Accrual QA Report (CSV output)

Used to reconcile the YTD Payments to the Accrual Batches.
The report should be able to prove definitively that this accrual calculation is working properly by indicating 12-month rolling payments used, uncosted obligation balance limitation, and default accrual with a separate column showing the VIAS adjustments.

Assists EFASC, program personnel and outside reviewers to determine how automated accruals are derived.

Parameters:

• Period Name (required)
• Fund From - To
• Appropriation Year From - To
• Allottee From - To
• Reporting Entity From - To
• Object Class From - To
• Program From - To
• Project From - To
• WFO From - To
• Local Use From - To
• CID From - To
• Default Accrual Batch Name (required)
• Accrual Adjustment Batch Name (required)

• The value set CPOCOCDR2 is used to look up the SGLs that make up the Obligations, Costs, Prepayments, Payments.
• The 12-month rolling payment column is derived from the UNCOSTED OBLIGATIONS ACCRUAL REPORT.
• The Default Accrual Amount and Accrual Adjustment are derived from the GL_JE_LINES table for the month that the user specified and the batch name that the user specified in the parameters. SGL value: 61000000.
  ** Note**
• Currently the Pre-Accrual Uncosted is subtracting the accrual amount from Cum Uncosted which is incorrect. To remedy - instead add the accrual amount to the Cum Uncosted because the Cum Uncosted is multiplied by -1.

DOE Accruals Comparison Report (CSV output)

Report compares 4901 and 4902 balances 50 days apart and compares the differences
with the automated accrual results

Report is used to compare monthly Accrual Results with Actual Payments. Any major differences between accrual result and actuals will result in a change to the Accrual Formula

Parameters: Period Name, Fund, Appropriation Year, Allottee, Reporting Entity, Object Class, Program, Project, WFO, Local Use, CID, Default Accrual Batch Name

DOE ASAP CID Summary Report (CSV output)

Report shows CID commitments, obligations, costs, prepayments and payments for ASAP related CIDs.

Provides visibility of ASAP CIDs that will need a change to the ASAP cost Flag to be in compliance with the needs of the Accrual team

Displays CID, ASAP, Cost Flag, Commitments, Obligations, Costs, Prepayments, Payments

Parameters: Period Name, Allottee From, Allottee To, Reporting Entity From, Reporting Entity To

Uses Custom CID table

DOE Automated Comparison of CDR and UDO Balances Report (CSV output)

• Column Set used: CPOCOCDR. Segment5 (SGL) is populated.
• SGLs values:
  48010000 - 4801zzzz
  48310000 - 4831zzzz
  48710000 - 4871zzzz
  48810000 - 4881zzzz

DOE Balances Report by Reporting Entity (CSV output)

DOE Balance Sheet Intragovernmental Detail by Customer/Supplier Name (CSV Output)

Parameters.

• As of Period (required)
• Display Type (required) – derived from the DOE_CGLBSIDCSCSV_DISP_TYPES value set. Possible values are “Accounts Payable Supplier Records” or “Accounts Receivable Customer Records”
• Allottee From (optional)
• Allottee To (optional)
• Fund From (optional)
• Fund To (optional)

DOE Balances to be Recast by CID Report (CSV output)

Parameters:

• Period From thru To (required)
• Fund From thru To
• Allottee From thru To
• CID From thru To

• Column Set used to obtain Recast balances: CGLBRCRCSV
• CID smart logic will be used.

DOE Budgetary Accounts Payable Report

List payment information for budgetary accounts

Use this report to determine the award type for grants and other budgetary disbursements

Allottee, Fund, Fund Description, PO Number, Award Type, Amount, Random Select

Allottee From, Allottee To, Fund Parent (required), Period Name (required)

Uses Custom CID table

• C_GLOBAL_SET reference for SGLs
• Randomly select the lesser of 5% of the total number of rows or 10 items.

DOE Budgetary Accounts Payable Report (CSV output)

List payment information for budgetary accounts

Use this report to determine the award type for grants and other budgetary disbursements

Allottee, Fund, Fund Description, PO Number, Award Type, Amount, Random Select

Allottee, Fund Parent (required), Period Name (required)

Uses Custom CID table

• C_GLOBAL_SET reference for SGLs
• Randomly select the lesser of 5% of the total number of rows or 10 items.

DOE Budgetary Accounts Payable w/o Activity for 12 Months Report

Report provide a detailed listing of PO Budgetary Accounts Payable balances as reported on the 2108 that are old and have had no activity at all for the past 12 months

Report needed to support the CFO Tiger Team's FM-PMO 2108 Issue. It is used by allottees to support quarterly 2108 CFO review/certifications and to provide an easy means of seeing and reviewing stale POs

Allottee, Fund Parent, Period Name

DOE Budgetary Accounts Payable w/o Activity for 12 Months Report (CSV output)

Report provide a detailed listing of PO Budgetary Accounts Payable balances as reported on the 2108 that are old and have had no activity at all for the past 12 months

Report needed to support the CFO Tiger Team's FM-PMO 2108 Issue. It is used by allottees to support quarterly 2108 CFO review/certifications and to provide an easy means of seeing and reviewing stale POs

Allottee, Fund Parent, Period Name

DOE Budgetary Accounts Undelivered Orders SEPADJ1-04 Report (CSV output)

DOE Budgetary Outlays by Treasury Symbol Report (Custom)

**Reporting FOOTER information displays SGL values in the column set

DOE Budgetary Reimbursements Earned Report

DOE Budgetary Reimbursements Earned Report (CSV output)

DOE Budgetary Reimbursements Earned w/o Activity for 12 Months Report

Provides a detailed listing of of WFO Number balances as reported on the 2108 that have had no activity for the past 12 months

Used by allottees to support quarterly 2108 CFO review/certifications

Displays Allottee, WFO, Reporting Entity, Fund, Fund Description, SGL, Amount

Parameters: Allottee From, Allottee To, Fund Parent, Period Name

SGL Values: 41660000, 41680000, 41710000, 42510000

DOE Budgetary Reimbursements Earned w/o Activity for 12 Months Report (CSV output)

Provides a detailed listing of WFO Number balances as reported on the 2108 that have had no activity for the past 12 months

Used by allottees to support quarterly 2108 CFO review/certifications

Displays Allottee, WFO, Reporting Entity, Fund, Fund Description, SGL, Amount

Parameters: Allottee From, Allottee To, Fund Parent, Period Name

SGL Values: 41660000, 41680000, 41710000, 42510000

DOE Carryover Orders vs Allocations Report

Compares the beginning balance in 422***00 to 461001200 by WFO and assures that the Appropriation Year is not equal to the current FY

This report is used to verify that Orders are fully Allocated. Compares the beginning balance in 422***00 to 461001200 by WFO and the Appropriation Year is not equal to the current FY

Parameters: Report Display Type, Period Name, Allottee

DOE Carryover Orders vs Allocations Report (CSV output)

Compares the beginning balance in 422***00 to 461001200 by WFO and assures that the Appropriation Year is not equal to the current FY

This report is used to verify that Orders are fully Allocated. Compares the beginning balance in 422***00 to 461001200 by WFO and the Appropriation Year is not equal to the current FY

Parameters: Report Display Type, Period Name, Allottee

DOE Closing Package RBSH Footnotes

Display depends on the Category Type parameter answer and a partial list of those categories follows:

• Available Categories to choose from:
  • Accounts and Taxes Receivable
  • Cash
  • Loans Receivable
  • Securities and Investments
  • Inventory and Related Property
  • Inventory and Related Property – Allowance
  • PPE
  • PPE – Depreciation and Amortization
  • Depreciation, Amortization and Depletion
  • Accounts Payable
    etc...

Parameters:

• Category Type
• Period Name
• SGL From thru To

DOE Closing Package RBSH Footnotes (CSV output)

Display depends on the Category Type parameter answer and a partial list of those categories follows:

• Available Categories to choose from:
  • Accounts and Taxes Receivable
  • Cash
  • Loans Receivable
  • Securities and Investments
  • Inventory and Related Property
  • Inventory and Related Property – Allowance
  • PPE
  • PPE – Depreciation and Amortization
  • Depreciation, Amortization and Depletion
  • Accounts Payable
    etc...

Parameters:

• Category Type
• Period Name
• SGL From thru To

DOE Confirmation of Inter-Office Balances (CSV output)

Parameters:

• Display Type (required) – Possible values are ‘REAL’, ‘NOMINAL or 'BOTH’
• As of Period (required)
• Allottee

Real Account SGL Values:

• SGLs between 10100000 and 33100900

Nominal Account SGL Values:

• SGLs between 51000000 and 76000000

DOE Cost Allocation Details Report CSV (custom)

Parameters:

• Period Name (required)
• JE Batch Name (required)

DOE Current Month Obs, Costs and Pays Report (Custom)

• Period Name (required)
• Sort1 (required, any AFF segment)
• Sort2 (any AFF segment)
• Sort3 (any AFF segment)
• Sort4 (any AFF segment)
• Fund From thru To
• Appropriation From thru To
• Allottee From thru To
• Reporting Entity From thru To
• Object Class From thru To
• Program From thru To
• Project From thru To
• WFO From thru To
• Local Use From thru To
• Specific CID From thru To

DOE Current Year Orders vs Allocations Report

Compares the balances in 42100400 to 45900400 by WFO and Appropriation Year

Used to verify that orders are fully allocated

Parameters: Report Display Type, Period Name, Allottee

DOE Current Year Orders vs Allocations Report (CSV output)

Compares the balances in 42100400 to 45900400 by WFO and Appropriation Year

Used to verify that orders are fully allocated

Parameters: Report Display Type, Period Name, Allottee

DOE CY Obligations by Allottee Report - CSV (Custom)

The procedure parameters are:

• Period (Required)
• Fund From
• Fund To
• Allottee From
• Allottee To

CY obligations can be calculated as follows:

1. Ending - Beginning balances for SGLs 48010000, 48020000, and 49010000, plus
2. Ending balances for SGLs 48810000, 48820000, 49020000, 49810000, and 49820000 (these SGLs do not have beginning balances)

(Note: the normal signs of these SGLs is negative, report "reverses the sign" so that CY obligations usually appear as a +.)

A columnset has been created with the SGL values
- CGLOBLALL

DOE Detail Suspense Transactions Report (CSV output)

Lists GL batches that are in suspense

Use this report to identify GL batches that have not been posted and pertinent details about that batch

Period From, Period To, Appropriation Year From, Appropriation Year To, Allottee From, Allottee To, Reporting Entity From, Reporting Entity To, Object Class From, Object Class To, Program From, Program To, Project From, Project To, WFO From, WFO To, Local Use From, Local Use To, Future From, Future To

DOE D&D Fund Potential Invoices Pending Report

1) The Summary of D&D payments by month by CID report is run by month. 2) D&D Fund Potential Invoices Pending report shows all open invoices that are due for payment by month.

This report is used to monitor D&D payments.

Displays Fiscal Year, Period Name, Invoice Number, CID, Vendor Name, Invoice Due Date, Invoice Amount

Parameters: Period Name, Fiscal Year, Allottee

DOE D&D Fund Potential Invoices Pending Report (CSV output)

1) The Summary of D&D payments by month by CID report is run by month. 2) D&D Fund Potential Invoices Pending report shows all open invoices that are due for payment by month.

This report is used to monitor D&D payments.

Displays Fiscal Year, Period Name, Invoice Number, CID, Vendor Name, Invoice Due Date, Invoice Amount

Parameters: Period Name, Fiscal Year, Allottee

DOE Eliminations Trial Balance (CSV output)

DOE Environmental Liabilities Report - All (Custom)

Summary page is produced after the regular report when users choose to report “by Allottee

Parameters:

• Period Name (required)
• Exclude Period Name (From Current Yr Changes)
• Display Type (Required) (values: Allottee, Allottee and Rep Entity, Summary)
• Parent Fund
• Allottee From
• Allottee To
• Reporting Entity From
• Reporting Entity To

Column set containing selection criteria values: CGLEMLR is used to store all the relevant FUND, SGL and PROGRAM values to be used in this report

DOE FACTS 1 4-Digit SGL Accounts by Treasury Fund Group Report

This report provides the same data being produced by the FACTS 1 and used in the FACTS 1 ATB reports but also shows the total 4 position SGL accounts by Treasury Account Code

This report was provided to show the total 4 position SGL accounts by Treasury Fund Group

DOE FACTS 1 ATB File Report

This report shows all of the Treasury Fund Groups and all of the Treasury attributes

The report allows the FACTS 1 preparer to see what the file looks like before it is sent to Treasury

DOE FACTS 1 Trading Partner Exception Report (CSV output)

Report identifies all trial balance summary data that does not comply with the DOE SGL Trading Partner Rules.

Report used to display those SGLs transactions that do not have the correct Trading Partner

Parameters: As of Period, Allottee, Reporting Entity

• The SGL range to only pick up Proprietary Accounts which are 00000000 - 3zzzzzzz and 50000000 - zzzzzzzz. It excludes the Budgetary Accounts of 40000000 - 4zzzzzzz.
• For balance sheet accounts (A,O,L), the beginning period to check is SEP-04. For all other accounts (E, R), the beginning period to check is the first non-adjustment period of the Fiscal Year of the user-entered Period, ie. most likely Period 2.
• Only SGLs that contain an Attribute1 DFF that matches the DOE_TRADING_PARTNER_TYPE will be processed.
• The following are the validation rules in checking to see if the trading partner is valid:
  • If Attribute1 is N and Trading Partner IS NOT NULL, then TP_ERROR is set to Y.
  • If Attribute 1 is Y and Trading Partner IS NULL, then TP_ERROR is set to Y.
  • If Attribute1 is 20 and Trading Partner <> 20, then TP_ERROR is set to Y.
  • If Attribute1 is 89 and Trading Partner <> 89, then TP_ERROR is set to Y.
  • If Attribute1 is N89 and Trading Partner = 89, then TP_ERROR is set to Y.
  • If Attribute1 is 16 and Trading Partner <> 16, then TP_ERROR is set to Y.
  • If Attribute1 is 99 and Trading Partner <> 99, then TP_ERROR is set to Y.
  • If Attribute1 is 31F and Trading Partner IS NULL and Fund is 00556 or 00910, then TP_ERROR is set to Y.
  • Else TP_ERROR is set to E

DOE FMS 224 Statement of Transactions Exception Report - CSV

DOE Funded Environmental Liability Analysis

Parameters:

• As of Period (required)
• Display Type (required) – Possible values are: “ALLOTTEE, FUND” or “ALLOTTEE, FUND, REP ENTITY”
• Fund From thru To
• Allottee From thru To
• Reporting Entity From thru To

• Column Set used for the SGL ranges of the different categories: CGLFELA

DOE Funded Environmental Liability Analysis (CSV output)

Parameters:

• As of Period (required)
• Display Type (required) – Possible values are: “ALLOTTEE, FUND” or “ALLOTTEE, FUND, REP ENTITY”
• Fund From thru To
• Allottee From thru To
• Reporting Entity From thru To

• Column Set used for the SGL ranges of the different categories: CGLFELA

DOE Funds Availability Journal Details Report (CSV output)

• Defaulted Project parameter value: 0000000
• Defaulted Local Use parameter value: 0000000
• Defaulted Future parameter value: 000000

DOE GL Balances Query (CSV output)

Parameters: All are REQUIRED

• Period Name
• Flexfield From thru To

• The report will calculate the ending GL debit and credit balances.

DOE GL Balancing Edits Detail Report (CSV output)

Report is used to analyze and resolve issues with the financial report edits. The report displays the detail journal entries for the passed-in Edit parameter

Provides users with the ability research detailed journal entries for a particular Edit

Parameters:

• Edit Name (required)
• Period From thru To (required)
• Fund
• Appropriation Year
• Allottee (required)
• Reporting Entity
• WFO
• Suppress Net Zero Batches (required)

DOE GL Budgetary Expenditures Report (CSV output)

• Fund Parent: NBAL
• SGL values: 4901, 4902, 4971, 4981, 4972, 4982
• Obtain those program children where the Program Parent range is between P000001 and P000146.
• Obtain the Goal Parent and Program Parent for each child program value.

DOE GL Combination Edits Detail Report (CSV output)

This displays journal detail line information similar to the DOE GL Balancing Edits Detail for the combination edits. Many of the combination edits have been included in the edit prioritization scheme.

This assists the users to research issues with specific journal entries

Parameters: Edit Name, Period, Fund, Appropriation Year, Allottee, Reporting Entity

DOE GL Disabled AFF Values for YE Processing (CSV output)

DOE GL Funding Exception Report

DOE GL Journal Detail Report (CSV output)

To ensure proper align data for pivot table purposes; remove extra commas from the description fields.

DOE GL Journal Detail Report by CID (CSV output)

This is STARS report that is ran from GL by CID to report SGL and detail journal transactions

This report in CSV format offers converting the output with a pivot table in Excel to get the desired results

Parameters: Period From, Period To, CID, Flexfield From, Flexfield To

Describe sort selections

Period Name, AFF, Batch Name, JE Name, JE Source, Status, Actual Flag,
Entered Dr, Entered Cr, Net Amount, T-Code, CID, Asset Type, Asset Status,
OPI, Environmental Liability Type, Public Law Code, Advance Type,
Transfer Dept ID, Trading Partner, Transfer Main Account

** Warning notice will appear in View Output if at least one of the AFF values is not answered

DOE GL Journal Detail Report by CID (text output)

This is STARS report that is ran from GL by CID to report SGL and detail journal transactions

This report avoids the need to run the report from STARS and convert the output with a pivot table in Excel to get the desired results

Parameters: Period From, Period To, CID, Flexfield From, Flexfield To

Describe sort selections

Period Name, AFF, Batch Name, JE Name, JE Source, Status, Actual Flag,
Entered Dr, Entered Cr, Net Amount, T-Code, CID, Asset Type, Asset Status,
OPI, Environmental Liability Type, Public Law Code, Advance Type,
Transfer Dept ID, Trading Partner, Transfer Main Account

** Warning notice will appear in View Output if at least one of the AFF values is not answered

DOE GL Journal Detail Report by Invoice Number (CSV output)

DOE GL Journal Detail Report by Trading Partner Code Cross Indexed-Logic (CSV output)

** Warning message will display on View Output when failing to enter at least ONE AFF value

DOE GL Journal Detail Report for DOE Trading Partner (CSV output)

DOE GL Journal Detail Report for Grants-related POs (CSV output)

DOE GL Journal Detail Report with Program Parent Segment (CSV output)

DOE GL Journal Detail Report with Trading Partner Code Cross Indexed-Logic (CSV output)

Parameters:

• Period From (required)
• Period To (required)
• GL Posted Date From (optional)
• GL Posted Date To (optional)
• Fund Parent (optional)
• SGL Parent (optional)
• Program Parent (optional)
• Display Type (required) – uses the DOE_CGLJDRCILCSV_DISP_TYPES value set
  (contains the following display types: “ALL FIELDS”, “ALLOTTEE, FUND, SGL”, “ALLOTTEE, FUND, SGL, TP”, “ALLOTTEE, SGL, TP, CID”, "ALLOTTEE, FUND, SGL, WFO, TP"
• CID (optional)
• Display only Blank CIDs (required)
• Trading Partner Code (optional)
• Display only Blank TPs (required)
• Flexfield From (required)
• Flexfield To (required)

** Warning message will display on View Output when failing to enter at least ONE AFF value

The report will check the gl_je_lines.last_update_date against the GL Posted Date From/To parameters.

DOE GL NULL CID Research (CSV output)

Parameters:

• Period From thru To (required)
• All AFF components

AND Lines.status = 'P'
AND Lines.period_name = prds.period_name
AND Header.actual_flag = 'A'
AND Header.currency_code = 'USD'
AND glh.je_source != 'Year End Close'

DOE GL Payments Details CSV Report

This report provides a CSV file with Payment details from gl_je_lines, including source, category reference and attribute columns for a selected accounting period

This report facilitates Payment data research and analysis

Parameters: Period and all AFF components

DOE GL Quarterly Interagency XMIT (CSV output)

Excludes all (89 & 95) trading partners and retrieves SGL account codes (1, 2, 3102, 3103, 5, 6, 7, 8)

• Substitute agency code 95 with 89.
• The logic for exchange/nonexchange is:
  • If SGL Code is '5100', '5109', '5200', '5209', '5400', '5409', '5500', '5509', '7180', '7280', '5319', '5320', '5329', '5909', '5990', '5991', '7110', '7190', '7210', '7290',
    then exchange/nonexchange is ‘X’.
  • If SGL Code is: '5600', '5609', '5610', '5619', then exchange/nonexchange is ‘T’.
  • If SGL Code is: '5310' and if Fund Group is '4054' or SGL like N1 or N2,
    then exchange/nonexchange is ‘T’
    else exchange/nonexchange is ‘X’
  • If SGL Code is '5900' and SGL like N1,
    then exchange/nonexchange is ‘T’
    else exchange/nonexchange is ‘X’
  • If SGL Code is '5311' and SGL like N1 or N2,
    then exchange/nonexchange is ‘T’
    else exchange/nonexchange is ‘X’
  • If SGL Code is '7111', '7211' and SGL like 05,
    then exchange/nonexchange is ‘T’
    else exchange/nonexchange is ‘X’.
    Add department id = '96' to the selection criteria for this report to pick up fund 02299

DOE GL Reconciliation with General and Program Parents Report (CSV output)

Parameters:

• As of Period (required)
• nclude Period Name as Column (required)

• SGL parents: NETER, NETPC
• Only process those records in where the SGL is Fed or either Fed or NonFed.
• Consolidated Breakout logic: If Fund is 04350 then 52, else if allottee is 96 then FERC, else if allottee between 91 and 95 then PMA, else OTHER.
• Fed NonFed logic: If Trading Partner is NULL then NonFed else FED.
• Goal D Parent logic: program parent starting with D0
• Program P Parent logic: program parent starting with P0

DOE GL Special Situations by CID (CSV Output)

This report identifies special situations that may require corrections such as SGLs that should normally have a CID associated and some should not

This report allows the GL/PO team to be pro-active in identifying data issues

Parameters: Allottee (optional)

DOE GL Year End Validation Report

• Allottee
• Fund From thru To
• SGL From thru To
• Run with Reporting Entity Detail (required)

DOE Inventory Roll-Forward Allottee Report

• Allottee
• Row Number
• Category
• Sub-category

Parameters:

• As of Period (required)
• Allottee

• Column Set used to obtain SGL and Program ranges: CGLIRFA
• If the SGL sign is a minus ‘-‘ (obtained from the CGLIRFA column set), then use special logic criteria to obtain the period-to-date activity for the latest open period in the GL_BALANCES table.

DOE Inventory Roll-Forward Allottee Report (CSV output)

• Allottee
• Row Number
• Category
• Sub-category

Parameters:

• As of Period (required)
• Allottee

• Column Set used to obtain SGL and Program ranges: CGLIRFA
• If the SGL sign is a minus ‘-‘ (obtained from the CGLIRFA column set), then use special logic criteria to obtain the period-to-date activity for the latest open period in the GL_BALANCES table.

DOE KPMG Current Year Obs – Schedule A (CSV output)

• Fund (optional)
• Allottee (optional)
• CID (optional)
• Period From (required)Period To (required)
• Display NWF Only (required) (defaults to No)
• Display D and D Only (required) (defaults to No)

column set: CGLCYOSACSV

DOE KPMG Current Year Obs - Schedule B (CSV output)

Provides visibility of original obligation detail entries for a particular CID.

Used by the KPMG auditors to obtain the original obligation entries for a particular CID.

Parameters: Allottee, CID, Period From, Period To, Suppress Non Orig Obs, NWF or D&D

1. For regular CIDs, Funds are: (‘00000’ to ‘04105’) or (‘04162’ to ’04163’) or (‘04350’ to ‘zzzzz’).
2. For NWF CIDs, Funds are: (‘01100’ to ‘01101’) or (‘02800’ to ‘02804’) or (‘02806’ to ‘02812’) or (‘02846’ to ‘02849’).
   The Decontamination and Decommissioning (D&D) funds are 03000 through 03011.
3. SGLs: 4801, 4802, 4871, 4971, 4881, 4882, 4901, 4902, 4981, 4982.
4. For consolidated breakout logic: If fund is ‘04350’, then ‘5Z’ else if fund is ‘96’, then ‘FERC’, else if Allottee between ‘91’ and ‘95’ then ‘PMA’, else ‘OTHER’.
5. Record marked as Orig Obs (‘Y) if source is ‘Purchasing’ and category is ‘Purchases’.
6. Record marked as Orig Obs (‘C’) if source is ‘Manual’ and category are: ‘OB Adjustments’, ‘Adjustment’, ‘Conversion Category’.
7. Record marked as (Net Zero) ‘X’ if record nets to zero by AFF and CID to another record with same AFF and CID.
8. Exclude Appropriation 89-X-0315 (Funds 01750 thru 01756) data for the display "D&D Only" criteria feature.

column set: CGLCYOSACSV

DOE Managerial Cost Allocations Report (CSV output)

DOE Manual Journal Entries Summary

DOE Merge FSG Output Files

DOE Orders not Allocated Report

This report compares 1) the balances in 42100400 to 45900400 by WFO and Appropriation Year and the 2) beginning balance in 422***00 to 461001200 by WFO and the Appropriation Year is not equal to the current FY

This report is used by the field offices to review the Carry Forward and/or Current Year Order vs Allocations

Displays Allottee, WFO, WFO Description, Fund, Approp Year, Funds Available

Parameters: Report Type, Period Name, Appropriation Year, Allottee

• If the Report Type is Current Year, then the SGL will be SGL parent: RWORDER.
• If the Report Type is Carry Forward, then the SGL will be SGL parent: RWCFORDR
• Suppressed zero dollar amount lines.

DOE Other - Transaction Code Listing Report

This report is simular to a current STARS report (Other - Transaction Code Listing) but is modified to add a parameter to select (Active, Inactive or parameter left blank both) transaction codes

This report Report displays Transaction Code Debit and Credit SGL accounts along with the Start and End Dates of the Transaction Codes.

Displays Debit Account, Description, Credit Account, Description

Parameters: Transaction Code (optional), Display Type (optional)

DOE Pension/PRB Information Report

• The report contains two display sections. The first section display Current Year balances. The latter section displays Cumulative balances.

Displays Allottee, CID, SGL, Net Amount for both Current Year and Cumulative balances.

Displays a legend at the bottom of the report that provides the user with the SGL, Program value selection criteria.

• As of Period (required)
• Allottee From and To (optional)
• PO Number From and To (optional)

• Column Set: C_GLOBAL_SET
• The report obtain the Current Year Net Amount for all SGLs specified in the column set mentioned above.
  

DOE PNR Navy Contract Report

Lists accounting information and contract dollar amount for open contracts between the Pittsburgh Naval Reactor and the Department of the Navy for a given time period

Use this report to reconcile open contracts by WFO number or other AFF string.

Period Name, WFO, SGL, Reporting Entity, Local Use, CID, Total

Period

DOE PO New Obligations Report (CSV output)

DOE PP&E Roll-Forward Allottee Report

This report is an additional Property Plant and Equipment (PP&E) rollforward statement.

Report (text version) is needed to support third quarter and year-end footnotes to be prepared by EFASC, used by the field offices to review PP&E SGL account YTD amounts by Allottee

Displays Allottee, Category, Sub-Category, and Amount.

Parameters: As of Period (required), Allottee

• Column Set used to obtain SGL and Program ranges: CGLPPERFA

DOE PP&E Roll-Forward Allottee Report (CSV output)

• Column Set used to obtain SGL and Program ranges: CGLPPERFA
  

DOE PP&E Roll-Forward Report

DOE PP&E Roll-Forward Report (CSV output)

DOE Prior Year Deobligation Adjustments (CSV output)

• Currency (required)
• Period Name (required)
• Amount Type (required)

DOE Quarterly Interagency Report

Display (Depends on output choice ALL Fields are listed) : Agency Code, Bureau Code, Fund Group, SGL code (4 digit only), Fed Non-Fed, Partner Code, Amount, Exchange Nonexchange, Duplidate Partner

• SGL
• Fund Code
• Allottee
• TP Code.

Parameters:

• Period Through (required)
• Allottee (optional)
• SGL Code (optional)
• Display Type (required)

Excludes all (89 & 95) trading partners and retrieves SGL account codes (1, 2, 3102, 3103, 5, 6, 7, 8)

• Substitute agency code 95 with 89.The logic for exchange/nonexchange is:
  • If SGL Code is '5100', '5109', '5200', '5209', '5400', '5409', '5500', '5509', '7180', '7280', '5319', '5320', '5329', '5909', '5990', '5991', '7110', '7190', '7210', '7290',
    then exchange/nonexchange is ‘X’.
  • If SGL Code is: '5600', '5609', '5610', '5619',
    then exchange/nonexchange is ‘T’.
  • If SGL Code is: '5310' and if Fund Group is '4054' or SGL like N1 or N2,
    then exchange/nonexchange is ‘T’
    else exchange/nonexchange is ‘X’
  • If SGL Code is '5900' and SGL like N1,
    then exchange/nonexchange is ‘T’
    else exchange/nonexchange is ‘X’
  • If SGL Code is '5311' and SGL like N1 or N2,
    then exchange/nonexchange is ‘T’
    else exchange/nonexchange is ‘X’
  • If SGL Code is '7111', '7211' and SGL like 05,
    then exchange/nonexchange is ‘T’
    else exchange/nonexchange is ‘X’.
    Add department id = '96' to the selection criteria for this report to pick up fund 02299

DOE Quarterly Interagency Report (CSV output)

This format convert to Excel and use pivot tables

Display (Depends on output choice ALL Fields are listed) : Agency Code, Bureau Code, Fund Group, SGL code (4 digit only), Fed Non-Fed, Partner Code, Amount, Exchange Nonexchange, Duplidate Partner

• SGL
• Fund Code
• Allottee
• TP Code.

Parameters:

• Period Through (required)
• Allottee (optional)
• SGL Code (optional)
• Display Type (required)

Excludes all (89 & 95) trading partners and retrieves SGL account codes (1, 2, 3102, 3103, 5, 6, 7, 8)

• Substitute agency code 95 with 89.
• The logic for exchange/nonexchange is:
  • If SGL Code is '5100', '5109', '5200', '5209', '5400', '5409', '5500', '5509', '7180', '7280', '5319', '5320', '5329', '5909', '5990', '5991', '7110', '7190', '7210', '7290',
    then exchange/nonexchange is ‘X’.
  • If SGL Code is: '5600', '5609', '5610', '5619',
    then exchange/nonexchange is ‘T’.
  • If SGL Code is: '5310' and if Fund Group is '4054' or SGL like N1 or N2,
    then exchange/nonexchange is ‘T’
    else exchange/nonexchange is ‘X’
  • If SGL Code is '5900' and SGL like N1,
    then exchange/nonexchange is ‘T’
    else exchange/nonexchange is ‘X’
  • If SGL Code is '5311' and SGL like N1 or N2,
    then exchange/nonexchange is ‘T’
    else exchange/nonexchange is ‘X’
  • If SGL Code is '7111', '7211' and SGL like 05,
    then exchange/nonexchange is ‘T’
    else exchange/nonexchange is ‘X’.
    Add department id = '96' to the selection criteria for this report to pick up fund 02299

DOE R and D Cost by Programs Report

DOE R and D Cost by Programs Report (CSV output)

DOE Reimbursable Work Full Cost Recovery Report (CSV output)

Parameters: Fiscal Period (required)

• Allottee
• Reporting Entity

• Program Parent: D000014
• SGL Parent values: NETER, NET PC
• Category based on Fund:
  • If Fund is: '00556', '00910', '01404', '02504', then category is: Reimbursable Work for Others – Federal
  • If Fund is: '00555', '00909', '01403', '01850', '02503', then category is: Reimbursable Work for Others - Non-Federal
  • If Fund is: '00554', '00908', then category is: Crada/Technology Transfer
  • If Fund is: ' 02851', then category is: Federal Aministrative Charge

DOE RW Carryforward/Orders = Allocation Report

• Allottee, Fund, WFO, SGL

Parameters:

• Period Name (required)
• Report Type (required) – Possible values are: “CARRYFORWARD” or “ORDERS = ALLOCATION”
• Treasury Symbol
• Allottee From Thru To
• WFO From Thru To

• Column Set used to obtain SGL ranges: CGLRWCFOA
• The report pulls ending minus beginning balances

DOE RW Carryforward/Orders = Allocation Report (CSV output)

• Allottee, Fund, WFO, SGL

Parameters:

• Period Name (required)
• Report Type (required) – Possible values are: “CARRYFORWARD” or “ORDERS = ALLOCATION”
• Treasury Symbol
• Allottee From Thru To
• WFO From Thru To

• Column Set used to obtain SGL ranges: CGLRWCFOA
• The report pulls ending minus beginning balances

DOE SNR Navy Contract Report

Lists accounting information and contract dollar amount for open contracts between the Schenectady Naval Reactor and the Department of the Navy for a given time period

Use this report to reconcile open contracts by WFO number or other AFF string.

Period Name, WFO, SGL, Reporting Entity, Local Use, CID, Total

Period

DOE SPRO Change in Inventory Report (Custom)

DOE SPRO GL Journal Detail Report (CSV output)

To ensure proper align data for pivot table purposes; remove extra commas from the description fields.

-- SGL selection 1010300, 61000000

DOE STARS AFP Reconciliation Report

Parameters:
Period Name
Subtotal Display Type (required)
Allottee
Suppress Zero Dollar Line

The FY2007 FDS Stars Approved data comes from the fds.stars_approved_afp@fdsdb table as of a certain timestamp and that data is stored in the custom.c_cglafpr_rpt_v_fy07 table

• The Subtotal Display Type parameter references the DOE_CGLAFPRCSV_SUBTOTAL_TYPES value set which contains the following 2 values: ALLOTTEE and ALLOTTEE, FUND, PARENT RE, PARENT PROGRAM
• Suppress Zero parameter only works where all 5 columns of the report are zero dollar amounts
• If the Period Name entered by the user is on or before MAR-07, then obtain the Prior Year Deobligation for the Period entered. If the Period Name entered by the user is after MAR-07, then obtain the Prior Year Deobligation for the Period: MAR-07. If the Period Year is 2008 or beyond, then obtain the Prior Year Deobligation for the Period entered.

DOE STARS Allottee Reconciliation Report

Lists variances between STARS and FDS allotment balances

Use this report to reconcile STARS and FDS allotment amounts by period

Parameters:

Period Name, Suppress Zero Dollar Line

DOE STARS Appropriation Apportionment Reconciliation Report

Lists variances between STARS and OMB apportionment balances

Use this report to reconcile STARS and OMB apportionment amounts by period

Parameters:

Period Name, Appropriation Year From, Appropriation Year To, Suppress Zero Dollar Line

DOE STARS Appropriation Reconciliation Report

Similar to the DOE STARS Appropriation Reconciliation Report but provides two reports; one for appropriation balances and one for apportionment balances.

Report derives balances as is currently being done in the combined report but report them by period to date (current year balances) Approp

Parameters: Fiscal Year

DOE STARS Control Level Reconciliation Report

DOE STARS Control Level Reconciliation Report - CSV

DOE Statement of Budgetary Resources Detail Report

Report provides SGL detail for five (5) lines of the Statement of Budgetary Resources

Report was requested by KPMG for audit support

Displays Title, SGL, YTD Amount

Parameters: Period Name, Fund Parent

• Fund Parent parameter defaults to S0001.
• For those SGLs in where it is categorized as [E-B], Ending Balance
  • Beginning Balance, the Beginning Balance is actually the Ending Balance of the first period (Period 1).
• SGLs:
• 4251 - Spending Authority from Offsetting Collections - Change in Receivable from Federal Sources [E-B]
• 4222 - Spending Authority from Offsetting Collections - Change in Unfilled Customer Orders - Advance Received [E-B]
• 4167, 4168, 4170, 4173, 4175, 4166, 4171, 4172 - Non-expenditure Transfers, Net - Budget Authority [Beginning Balance only]
• 4166, 4171, 4172 - Non-expenditure Transfers, Net - Budget Authority [E-B]
• 4176, 4190 - Non-expenditure Transfers, Net - Unobligated Balances - [Beginning Balance only]
• 4620, 4720 - Unobligated Balance Available - Exempt From Apportionment - [Beginning Balance only]
• Suppressed zero dollar amount lines.

DOE Statement of Costs Incurred and Claimed (Custom)

Report displays paid invoice information by approving official.

Report is used by the field offices to reconcile against hard-copy Statement of Costs Incurred and Claimed report for their Reporting Entity

Parameters: As of Period, Reporting Entity, Allottee, Net Operating Cost SGL 1,Net Operating Cost SGL 2, Net Operating Cost SGL 3, Net Operating Cost SGL 4, Net Operating Cost SGL 5, Net Operating Cost SGL 6, Net Operating Cost SGL 7, Net Operating Cost SGL 8, Net Operating Cost SGL 9, Net Operating Cost SGL 10, Net Operating Cost SGL 11, Net Operating Cost SGL 12, Net Operating Cost SGL 13 , Net Operating Cost SGL 14, Net Operating Cost SGL 15, Net Operating Cost SGL 16, Net Operating Cost SGL 17, Net Operating Cost SGL 18, Net Operating Cost SGL 19, Net Operating Cost SGL 20, Net Operating Cost SGL 21, Net Operating Cost SGL 22, Net Operating Cost SGL 23, Net Operating Cost SGL 24, Net Operating Cost SGL 25, Net Operating Cost SGL 26, Non-Reimb Transfers SGL 1, Non-Reimb Transfers SGL 2, Non-Reimb Transfers SGL 4, Non-Reimb Transfers SGL 5, Non-Reimb Transfers SGL 6, Reconciling Transfers SGL 1, Reconciling Transfers SGL 2, Reconciling Transfers SGL 3, Reconciling Transfers SGL 4, Reconciling Transfers SGL 5, Reconciling Transfers SGL 6,Acounts Receivable SGL 11,

DOE Status of Funding by Program Parent Report

DOE Status of Funding by Program Parent Report (CSV output)

DOE Status of Funds For a Reimbursable Work Order

Report provides cumulative (LTD) dollars by WFO (RW Order).

Report is used for cumulative orders to assure that billings do not exceed the other agency's funds

Displays Cumulative RWO Received, Cumulative Obligations, Cumulative Budgetary Costs Fund, Cumulative Funded Order Billed, Cumulative Fac Billed, Cumulative Funded Order Collected, Cumulative Fac Collected, Unobligated Orders, Cumulative Billed Bdgt Cost Fund, Cumulative Billed Bdgt Costs Fac, Uncosted Obs

Parameters:

• Order By (required)
• Period Name (required)
• Fund (From To)
• Appropriation (From To)
• Allottee (From To)
• Reporting Entity (From To)
• Object (From To)
• Program (From To)
• Project (From To)
• WFO (From To)
• CID From To)
• Customer

DOE Status of Funds For a Reimbursable Work Order (CSV output)

Parameters:

• Order By (required)
• Period Name (required)
• Fund (From To)
• Appropriation (From To)
• Allottee (From To)
• Reporting Entity (From To)
• Object (From To)
• Program (From To)
• Project (From To)
• WFO (From To)
• CID (From To)
• ustomer

DOE Summary of D&D Payments Report

Report is used to monitor D&D payments

Used to monitor D&D payments by month by CID and to identify pending D&D payments

Displays CID, Vendor Name, Amount

Parameters: Period Name, Amount Type, Allottee

• Fund Value - 03000
• SGL Value - 49020000 through 4902zzzz
• Multiply amount by -1 for cosmetic reasons.
• Suppress zero dollar amount records.

DOE Summary of D&D Payments Report (CSV output)

Report is used to monitor D&D payments

Used to monitor D&D payments by month by CID and to identify pending D&D payments

Displays CID, Vendor Name, Amount

Parameters: Period Name, Amount Type, Allottee

• Fund Value - 03000
• SGL Value - 49020000 through 4902zzzz
• Multiply amount by -1 for cosmetic reasons.
• Suppress zero dollar amount records.

DOE Summary Reclassified Trading Partner Report (CSV output)

DOE Summary Trading Partner Report (CSV output)

DOE Summary Verification of Trading Partner Cost Data (CSV output)

DOE Trading Partner and WFO Report

Parameters:

• As of Period (required)
• Trading Partner
• SGL From Thru To
• Display Type (required) – derived from the DOE_CGLTPWFOCSV_DISP_TYPES value set. Possible values are: “TP, WFO” or “TP, FUND, ALLOTTEE, WFO”

DOE Trading Partner and WFO Report (CSV output)

Parameters:

• As of Period (required)
• Trading Partner
• SGL From Thru To
• Display Type (required) – derived from the DOE_CGLTPWFOCSV_DISP_TYPES value set. Possible values are: “TP, WFO” or “TP, FUND, ALLOTTEE, WFO”

DOE Trial Balance by Trading Partner Code (CSV output)

DOE Trial Balance of Trading Partner Variances by Fed Reimb WFO (CSV output)

DOE Trial Balance w/Smart CID and TP Logic (CSV output)

This report is needed to provide Trading Partner information at the Trial Balance level

Display depends on Flexfield Display Type answer
This parameter offers numerous display types choices as an example
1. ALL SEGMENTS heading follow
Fund, Approp Year, Allottee, Reporting Entity, SGL, Object Class, Program, Project, WFO, Local Use, Future, Trading Partner, Entered Dr, Entered Cr, Net Amount
2. SGL, CID, TP headings follow
SGL, SGL description, CID, Trading Partner, Beginning Balance, Period Activity, Ending Balance, PY Beginning Balance, PY Period Activity, PY Ending Balance

etc....

• Period Name (required)
• Trading Partner Code From thru To
• Exclude Trading Partner Code (required)
• Display Trading Partner not equal to Blank Only (required)
• Exclude Budgetary Accounts (required)
• CID From thru To
• Flexfield Display Type (required)
  This parameter offers numerous display types choices as an example
  1. ALL SEGMENTS
  2. FUND, ALLOTTEE, REPORTING ENTITY, SGL, WFO, CID, TP
     etc...
• Flexfield From thru To (required)
• Suppress Zero Dollar Ending Balances (required)
• Display Prior Year Data (required)
• Prior Period Name

• For SGL: 99110000 and 99150000, selected E out of L and E.
• For SGL: 99410000, selected L out of L and E.
• For SGL: 99420000, selected forced a match so that CCID account type and account type are the same value in order to process SGL.
• For SGL 33100900, obtained data from the GL_BALANCES table.
• For Budgetary SGLs (account type of C,D), obtained data from the CUSTOM.C_GL_CID_BALANCES table.
• For Proprietary SGLs (account type of A,L,O,E,R), obtained data from the GL_JE_LINES table.
• Trading Partner Agency Name is derived from the DOE_TP_AGENCY_MAPPING value set.
• The Display Prior Year Data default should display the period 12 months before the current period, but users should have an option to change the prior year period to something other than 12 months prior to the current period selected.

DOE Undelivered Orders Report

Lists undelivered orders by allottee

Use this report to reconcile reports that have not be delivered and their corresponding PO and award type

Allottee From, Allottee To, Fund Parent, Period Name

DOE Undelivered Orders Report (CSV output)

Lists undelivered orders by allottee

Use this report to reconcile reports that have not be delivered and their corresponding PO and award type

Allottee From, Allottee To, Fund Parent, Period Name

Uses Custom CID table

DOE Unfilled Customer Orders Report

DOE Unfilled Customer Orders Report (CSV output)

DOE Unfilled Customer Orders w/o Activity for 12 Months Report

DOE Unfilled Customer Orders w/o Activity for 12 Months Report (CSV output)

EM Capital Expenditures Reconciliation Report - All (Custom)

Provides information on current year capitalized costs, current year legacy write-off, non-legacy waste capitalized costs and environmental liability, unreconciled difference and other HQ PBC by Allottee

Used by EM field office (Environmental Management) to reconcile their Capital Expenditures with DOE GL entries

The Display Type parameter answer determines detail display data

• Display Type (Required)
  (values: Allottee, Allottee and Fund, Allottee and Program)
• Allottee From
• Allottee To
• Period Name (required)
• Fund From
• Fund To
• Program From
• Program To

Only the ‘Actual’ balance type entries are included.

For the Reduction Env Liab axis and Current Yr Legacy Write-off, pull these amounts from Lines instead of Balances so we can also look for gl_je_lines.attribute5 beginning with EMF.

EM Operating Expenditures Reconciliation Reports (Custom)

Provides current year costs, current year HQ PBC costs and environmental costs by allottee

Used by EM field office (Environmental Management) to reconcile their operating expenditures with DOE GL entries

The Order By parameter answers determine detail display data

Parameters:

• Order By1 (Required)
  (values: any AFF Components)
• Order By2 (values: any AFF Components)
• Parent Fund
• Fund From thru To
• Appr Yr From thru To
• Allottee From thru To
• Rep. Entity From thru To
• Object Class From thru To
• Program From thru To
• Project From thru To
• WFO From thru To
• Period Name (required)

The column set (CGLEMOPE_COLUMN_SET) is created to enter the appropriate Program values for this report. The report refers to this column set for SGL and Program values. Axis_name called Exclude Funds available in column_set to offer excluding funding code ranges.

Only the ‘Actual’ balance type entries are included.

Excludes segment1(fund = 04251).

Excess Plutonium Capital Expenditures Reconciliation Report - All (Custom)

The Display Type parameter answer determines the detail display data.

• Display Type (Required)
  (values: Allottee, Allottee and Fund, Allottee and Program)
• Allottee From
• Allottee To
• Period Name (required)
• Fund From
• Fund To
• Program From
• Program To

The columns Current Yr Operating Costs and Current Yr HQ PBS comes from GL Balances table, but the column Reduction Env Liab comes from gl_je_lines because for that column we have an additional criteria- we only include rows with attribute5 LIKE 'OTH%'.
In addition, like all STARS reports we only include rows where and Status = 'P' and Actual_Flag = 'A' and Currency_Code = 'USD'.

Excess Plutonium Operating Expenditures Reconciliation Report (Custom)

Parameters:

• Order By1 (Required) (values: any AFF Components)
• Order By2 (values: any AFF Components)
• Parent Fund
• Fund From thru To
• Appr Yr From thru To
• Allottee From thru To
• Rep. Entity From thru To
• Object Class From thru To
• Program From thru To
• Project From thru To
• WFO From thru To
• Period Name (required)

GL Activity for an Invoice (Custom)

GL Balances with CID Parameter - Detail (Custom)

** Warning message will display on View Output when failing to enter at least ONE AFF value

Uses Custom CID table

• SGL: 33100900 is also displayed on the report.

GL Balances with CID Parameter - Detail (Custom) (CSV output)

** Warning message will display on View Output when failing to enter at least ONE AFF value

Uses Custom CID table

• SGL: 33100900 is also displayed on the report.

GL Balancing Edits (Custom)

GL Balancing Edits (Custom) (CSV output)

GL Balancing Edits Report (FST USE ONLY) (CSV output)

GL Combination Edits Revised (Custom)

GL Combination Edits Revised (Custom) (CSV output)

GL TO PO UNDELIVERED ORDERS RECONCILIATION AND STALE PO UDO BALANCES REPORT    **Discoverer Report **

FYI - The STALE meaning:
An obligation for certain award types have been on the books for a long period of time, and it lets the field offices know that they need to take some sort of action to get rid of the obligation. More than likely, that action would be a deobligation.

The Stale PO UDO Balances sheet displays:
Allottee, Fund, Reporting Entity, WFO,
PO Number, Award Type, Approving Official, Vendor Name, PO Last Update Date
PO UDO Balance

Special criteria (Logic associated to the Discoverer tool) for the Stale PO UDO Balances report:

CASE WHEN C gl udo recon2 mv."PO Last Update Date" < PCS STALE UDO CALC AND C gl udo recon2 mv.Award type = 'PCS' THEN 'Y' WHEN C gl udo recon2 mv."PO Last Update Date" < TDY STALE UDO CALC AND C gl udo recon2 mv.Award type IN ('CARD', 'CRDN', 'EMPM', 'TVL', 'LEGL', 'LOCAL', 'MISC', 'PENS', 'PILT', 'PRNT', 'SECY', 'TDY', 'TORT', 'TRNG', 'UTIL') THEN 'Y' WHEN C gl udo recon2 mv."PO Last Update Date" < OTHER AWARD TYPE UDO STALE CALC AND C gl udo recon2 mv.Award type NOT IN ('CARD', 'CRDN', 'EMPM', 'TVL', 'LEGL', 'LOCAL', 'MISC', 'PENS', 'PILT', 'PRNT', 'SECY', 'TDY', 'TORT', 'TRNG', 'UTIL', 'PCS') THEN 'Y' ELSE 'N' END

Other - Transaction Code Listings (Custom)

Property Plant and Equipment Reconciliation

The report is contains three sections including Inventory Reconciliation, Property Reconciliation and the combination of the two which is a Summary of the first two sections.

Provides asset net balance information at a Period.

Parameters: Period Name, Allottee and Fund

RW Revenues by Reporting Entity / Program Code / Sponsor Entity (Custom)

Uses Custom CID table

Schedule of Intra-Governmental Balances Balance Sheet

Report developed to support Year End Closing. Provided a single source of Net Asset information by Asset Type on Inter-Governmental activity

Provides consolidated asset balance information after eliminations by Agency

Displays FERC, PMA and Eliminations by Asset Type

Parameters: Period Name

Schedule of Intra-Governmental Balances Custodial Activities

Report developed to support Year End Closing. Provided a single source of Net Asset information by Asset Type on Custodial Activity

Provides consolidated asset balance information after eliminations for Custodial Activities

Displays FERC, PMA and Eliminations by Agency

Parameters: Period Name

Schedule of Intra-Governmental Balances Statement of Net Cost

Report developed to support Year End Closing. Provided a single source of Net Asset information by Asset Type on Custodial Activity

Provides consolidated asset balance information after eliminations for Statement of Net Cost

Parameters: Period Name

Status of Funds (Custom)

Lists status of obligations, costs and payments on the AFF and CID

Use this report to identify the status of obligations- year to date, costs- year to date, and payments on the AFF values and CID

Parameters:
Page Break Segment (required), Fund From, Fund To, Allottee From, Allottee To, Reporting Entity From, Reporting Entity To, Object Class From, Object Class To, Program From, Program To, Project From, Project To, WFO From, WFO To, Local Use From, Local Use To, CID From, CID High, Period Name (required)

Uses Custom CID table

Capability for the user to enter a Program Parent in the Program From/To parameters

Status of Funds (Custom) (CSV output)

Uses Custom CID table

Capability for the user to enter a Program Parent in the Program From/To parameters

Status of Funds Available for Obligations (Custom)

Lists the pertinent accounting data for funds that are allocated but not obligated

Use this report to determine available funds that can be used for procurement and to monitor spending by AFF segment

Parameters:

• Order By (required)
• Period Name (required)
• Fund From/To
• Appr Yr From/To
• Allottee From/To
• Reporting Entity From/To
• Object From/To
• Program From/To
• Project From/to
• WFO From/To
• Local Use From/To
• CID From/To

Uses Custom CID table

Capability for the user to enter a Program Parent in the Program From/To parameters

Uses the Global column_set

Status of Funds Available for Obligations (Custom) (CSV output)

Parameters:

• Order By (required)Period Name (required)
• Fund From/To
• Appr Yr From/To
• Allottee From/To
• Reporting Entity From/To
• Object From/To
• Program From/To
• Project From/to
• WFO From/To
• Local Use From/To
• CID From/To

Uses Custom CID table

Capability for the user to enter a Program Parent in the Program From/To parameters

Uses the Global column_set

Status of Obligational Authority - Current Year Data (Custom)

Lists the pertinent accounting data for obligated and unobligated funds

Use this report to view the overall obligation status for a given period of time or for an AFF segment and to monitor spending by AFF segment

Order By, Period Name, Period To, Appropriation Year From, Appropriation Year To, Allottee From, Allottee To, Reporting Entity From, Reporting Entity To, Object Class From, Object Class To, Program From, Program To, Project From, Project To, WFO From, WFO To, CID From, CID To

Uses Custom CID table

Capability for the user to enter a Program Parent in the Program From/To parameters

Trial Balance - Detail (Standard) (Custom)

This modification of the Standard Trial Balance - Detail report eliminates amount fields with zero balances.

The size of the file has been reduced by eliminating zero balance values to allow for better Excel downloading.

Parameters: Currency (required), Period Name (required), Amount Type (required), Parent Fund, Flexfield From, Flexfield To

• The Beginning Balance logic has been changed by taking the first periods's ending balance ((begin_balance_dr - begin_balance_cr) + (period_net_dr - period_net_cr)) from the GL_BALANCES table. Previously, the report derived the beginning balance by taking the first period's beginning balance (begin_balance_dr - begin_balance_cr) from the GL_BALANCES table.

Trial Balance - Detail (Standard) (Custom) (CSV output)

This modification of the Standard Trial Balance - Detail report eliminates amount fields with zero balances.

The size of the file has been reduced by eliminating zero balance values to allow for better Excel downloading.

Parameters: Currency (required), Period Name (required), Amount Type (required), Flexfield From, Flexfield To, Display Type (required) (3 values: ALL FIELDS and ALLOTTEE, FUND, SGL and Allottee, Fund, SGL, Appropriation Year.), Parent fund (S0001, NBAL, A0031, etc.)

• The Beginning Balance logic has been changed by taking the first periods's ending balance ((begin_balance_dr - begin_balance_cr) + (period_net_dr - period_net_cr)) from the GL_BALANCES table. Previously, the report derived the beginning balance by taking the first period's beginning balance (begin_balance_dr - begin_balance_cr) from the GL_BALANCES table.

Trial Balance - Detail IC (Standard) (Custom)

Trial Balance - Detail IC (Standard) (Custom) (CSV output)

Trial Balance - Summary 1 (Custom)

This report is similar to the layout of the (Non-Federal) Standard GL report with the addition of the following information:

• can be site specific


• Allottee and Reporting Entity as selection parameters
• CID as a parameter field

Use this report to identify debits and credits to assist in reconciliation and preparation of Financial Statements

Page Break Segment (Low/High), Currency, Period, Amount Type, CID

Trial Balance - Summary 2 (Custom)

• The Beginning Balance logic has been changed by taking the first periods's ending balance ((begin_balance_dr - begin_balance_cr) + (period_net_dr - period_net_cr)) from the GL_BALANCES table. Previously, the report derived the beginning balance by taking the first period's beginning balance (begin_balance_dr - begin_balance_cr) from the GL_BALANCES table.

Trial Balance - Summary 2 CSV (Custom)

• The Beginning Balance logic has been changed by taking the first periods's ending balance ((begin_balance_dr - begin_balance_cr) + (period_net_dr - period_net_cr)) from the GL_BALANCES table. Previously, the report derived the beginning balance by taking the first period's beginning balance (begin_balance_dr - begin_balance_cr) from the GL_BALANCES table.