Use the FACTS Transaction Register to review and analyze SGL account balances and FACTS attribute information. The FACTS Transaction Register prints SGL account information by fund within a treasury symbol and associated attributes affected by FACTS I and FACTS II requirements.
The FACTS I Transaction Register is an RXi report. The Default Attribute set groups the data by treasury symbol, fund, organization, program, project, and budget object class. This attribute set can be copied in order to customize the layout to suit the reporting needs of the agency. In the Default Attribute set, the organization, program, project, and budget class segments were assigned default segment columns. To maintain this level of detail, the agency must create a customized attribute set to map the segment of the Accounting Flexfield to the appropriate column headings.
Use the Standard Request Submission windows to submit the FACTS Transaction Register.
The prerequisites for generating the FACTS II bulk file and the FACTS I ATB are also applicable to generating the FACTS Transaction Register.
Note: To ensure that the FACTS I attributes are correct, the FACTS I ATB should be generated prior to submitting the FACTS Transaction Register for the period the FACTS Transaction Register End Period will be submitted.
Select the ledger to use for the report.
Enter the currency to use for the report.
Enter the treasury symbol range for the report.
Enter the General Ledger period range for the report.
Enter the General Ledger source to use for the report.
Enter the General Ledger category to use for the report.
Enter the attribute set to use for the report.
Enter the output format to use for the report.
The following table describes the heading section of the FACTS Transaction Register report.
| Heading | Description |
|---|---|
| Ledger Name | The ledger name |
| Report Date | The report date |
| Currency | The report currency |
| Treasury Symbol Range | The report treasury symbol range |
| Accounting Period | The report accounting period |
| Journal Source | The report journal source |
| Journal Category | The report journal category |
| Treasury Symbol | The report treasury symbols |
| Fund | The report fund |
| Organization Code | Values in the segment assigned by the default attribute set.
Note: If the segment assigned in the default attribute set does not reflect organization code, the default attribute set would need to be copied and modified to assign the appropriate segment for organization. |
| Program | Values in the segment assigned by the default attribute set.
Note: If the segment assigned in the default attribute set does not reflect program, the default attribute set would need to be copied and modified to assign the appropriate segment for program. |
| Project | Values in the segment assigned by the default attribute set.
Note: If the segment assigned in the default attribute set does not reflect project, the default attribute set would need to be copied and modified to assign the appropriate segment for project. |
| BOC | Values in the segment assigned by the default attribute set.
Note: If the segment assigned in the default attribute set does not reflect budget object class, the default attribute set would need to be copied and modified to assign the appropriate segment for budget object class. |
The following table describes the FACTS Transaction Register report.
| Heading | Description |
|---|---|
| Acct No | Natural account segment. |
| Transaction Source | Transaction journal source. |
| Transaction Number | Transaction document number. |
| Transaction Date | Transaction document date. |
| Creation Date/Time | Date and time the transaction was created. |
| Entry User | Name of the user who created the transaction. |
| FNF | Federal (F) or Non-Federal (N). |
| TPC | Descriptive flexfield value for Trading Partner if FNF attribute is Federal (F). |
| ENE | Exchange (X) or Non-Exchange (T). |
| BSF | Budget Subfunction lookup code associated to the fund, if required for this account. |
| CNC | Custodial (S) or Non-Custodial (A). |
| AUT | Authority type. |
| DEF | Definite (D) or Indefinite (I) flag. |
| PL | Public law code. |
| CAT | Apportionment category. |
| PRC | Program Reporting Category for Category A. |
| CBS | Apportionment Category B Code. |
| RIF | Reimbursable flag: Direct (D) or Reimbursable (R). |
| AVT | Period of availability: Available in current period (A) or Available in a subsequent period (S). |
| TRP | Transaction partner code: Federal (F), Non-federal (X), Non-federal exception (E). |
| BOR | Borrowing source |
| BEA | Budget Enforcement Agency (BEA) category: Discretionary (D) or Mandatory (M). |
| YRB | US SGL attribute that distinguishes between outlays from new budget authority versus outlays from balances carried forward from a prior year; used for noncredit financing No-year appropriations only: NEW or BAL. |
| TAG | Department identifier of the agency involved in the transfer. |
| TAC | Main account code of the agency involved in the transfer. |
| ADF | Indicates that a portion of the appropriation is advanced from a future year (F) or made available in a prior year (P). |
| FUN | Classifies data according to major purpose served: Defense (DEF) or Non-Defense (NND). |
| CYR | Cohort year, in two-digit format. |
| PYA | Adjustments to prior year reporting. |
| Debit Amount | Transaction debit, if applicable. |
| Credit Amount | Transaction credit, if applicable. |