anchor.diff:  B7.2,"GrossOutlaysDeliveredOrdersPaidTotal (CPE)= USSGL(4902 + 4908 + 4982). This applies to the program activity and object class level.",n,program_activity,warning,,b7_object_class_program_activity_2,"Within File B, GrossOutlaysDeliveredOrdersPaidTotal_CPE should equal USSGL 4902_CPE + 4908_CPE + 4982_CPE. However, the Broker cannot determine which element is incorrect in this rule. Refer to your source information to distinguish which elements may be incorrect.","accuracy"
   B9,"Must be a valid program activity name/program activity code combination for the corresponding funding TAS/TAFS, as defined in the OMB Program Activity MAX Collect Exercise. However, if there are no obligations or outlays on the TAS, a program activity name of ""Unknown/Other"" combined with a program activity code of 0000 should be used.",n,program_activity,warning,,b9_object_class_program_activity,"A valid program activity code","existence"
   B9,"Must be a valid program activity name/program activity code combination for the corresponding funding TAS/TAFS, as defined in the OMB Program Activity MAX Collect Exercise. However, if there are no obligations or outlays on the TAS, a program activity name of ""Unknown/Other"" combined with a program activity code of 0000 should be used.",n,award_financial,warning,,b9_award_financial,"A valid program activity code","existence"
  -B11.1,"Must be valid 3-digit object class as defined in OMB Circular A-11 Section 83.6, or a 4-digit code which includes a 1-digit prefix that distinguishes direct, reimbursable, and allocation obligations. Do not include decimal points when reporting in the Schema.",n,award_financial,fatal,,b11_award_financial_1,"A valid object class code",
  +B11.1,"Must be valid 3-digit object class as defined in OMB Circular A-11 Section 83.6, or a 4-digit code which includes a 1-digit prefix that distinguishes direct, reimbursable, and allocation obligations. Do not include decimal points when reporting in the Schema.",n,award_financial,fatal,,b11_award_financial_1,"A valid object class code","existence"
   B11.2,"Must be valid 3-digit object class as defined in OMB Circular A-11 Section 83.6, or a 4-digit code which includes a 1-digit prefix that distinguishes direct, reimbursable, and allocation obligations. Do not include decimal points when reporting in the Schema. Object Class Codes of 000 will prompt a warning.",n,award_financial,warning,,b11_award_financial_2,"A valid object class code","existence"
  -B11.3,"Must be valid 3-digit object class as defined in OMB Circular A-11 Section 83.6, or a 4-digit code which includes a 1-digit prefix that distinguishes direct, reimbursable, and allocation obligations. Do not include decimal points when reporting in the Schema.",n,program_activity,fatal,,b11_object_class_program_activity_1,"A valid object class code",
  +B11.3,"Must be valid 3-digit object class as defined in OMB Circular A-11 Section 83.6, or a 4-digit code which includes a 1-digit prefix that distinguishes direct, reimbursable, and allocation obligations. Do not include decimal points when reporting in the Schema.",n,program_activity,fatal,,b11_object_class_program_activity_1,"A valid object class code","existence"
   B11.4,"Must be valid 3-digit object class as defined in OMB Circular A-11 Section 83.6, or a 4-digit code which includes a 1-digit prefix that distinguishes direct, reimbursable, and allocation obligations. Do not include decimal points when reporting in the Schema. Object Class Codes of 000 will prompt a warning.",n,program_activity,warning,,b11_object_class_program_activity_2,"A valid object class code","existence"
   B12.1,"Reimbursable flag indicator is required when reporting obligation or outlay USSGL account balances (excluding downward adjustments SGL accounts). Valid values are ""R"" for ""ReimbursableFundingSource"" and ""D"" for ""DirectFundingSource"".",n,award_financial,warning,,b12_award_financial_1,"D or R","completeness"
   B12.2,"The reimbursable flag indicator (bydirectreimbursablefundingsource) must be empty, R, or D",n,award_financial,warning,,b12_award_financial_2,"(null), D, or R","accuracy"
  
positive.code: rule_label,rule_error_message,rule_cross_file_flag,file_type,severity_name,target_file,query_name,expected_value,category
  A1.1,"TAS components: The combination of all the elements that make up the TAS must match the Treasury Central Accounting Reporting System (CARS). AgencyIdentifier, MainAccountCode, and SubAccountCode are always required. AllocationTransferAgencyIdentifier, BeginningPeriodOfAvailability, EndingPeriodOfAvailability and AvailabilityTypeCode are required if present in the CARS table.",n,appropriations,fatal,,a1_appropriations,"A valid TAS must be provided that consists of: AgencyIdentifier, MainAccountCode, and SubAccountCode are always required. AllocationTransferAgencyIdentifier, BeginningPeriodOfAvailability, EndingPeriodOfAvailability and AvailabilityTypeCode are required if they are part of the TAS.",
  A1.2,"TAS components: The combination of all the elements that make up the TAS must match the Treasury Central Accounting Reporting System (CARS). AgencyIdentifier, MainAccountCode, and SubAccountCode are always required. AllocationTransferAgencyIdentifier, BeginningPeriodOfAvailability, EndingPeriodOfAvailability and AvailabilityTypeCode are required if present in the CARS table.",n,program_activity,fatal,,a1_object_class_program_activity,"A valid TAS must be provided that consists of: AgencyIdentifier, MainAccountCode, and SubAccountCode are always required. AllocationTransferAgencyIdentifier, BeginningPeriodOfAvailability, EndingPeriodOfAvailability and AvailabilityTypeCode are required if they are part of the TAS.",
  A1.3,"TAS components: The combination of all the elements that make up the TAS must match the Treasury Central Accounting Reporting System (CARS). AgencyIdentifier, MainAccountCode, and SubAccountCode are always required. AllocationTransferAgencyIdentifier, BeginningPeriodOfAvailability, EndingPeriodOfAvailability and AvailabilityTypeCode are required if present in the CARS table.",n,award_financial,fatal,,a1_award_financial,"A valid TAS must be provided that consists of: AgencyIdentifier, MainAccountCode, and SubAccountCode are always required. AllocationTransferAgencyIdentifier, BeginningPeriodOfAvailability, EndingPeriodOfAvailability and AvailabilityTypeCode are required if they are part of the TAS.",
  A2,"TotalBudgetaryResources_CPE = BudgetAuthorityAppropriatedAmount_CPE + BudgetAuthorityUnobligatedBalanceBroughtForward_FYB + AdjustmentsToUnobligatedBalanceBroughtForward_CPE + OtherBudgetaryResourcesAmount_CPE",n,appropriations,fatal,,a2_appropriations,"TotalBudgetaryResources_CPE must equal the sum of these elements: BudgetAuthorityAppropriatedAmount_CPE + BudgetAuthorityUnobligatedBalanceBroughtForward_FYB + AdjustmentsToUnobligatedBalanceBroughtForward_CPE + OtherBudgetaryResourcesAmount_CPE. The Broker cannot distinguish which item is incorrect for this rule. Refer to related rule errors and warnings in this report (rules A3, A6, A7, A8, A12) to distinguish which elements may be incorrect.",
  A3,"OtherBudgetaryResourcesAmount_CPE = ContractAuthorityAmountTotal_CPE + BorrowingAuthorityAmountTotal_CPE + SpendingAuthorityfromOffsettingCollectionsAmountTotal_CPE",n,appropriations,fatal,,a3_appropriations,"OtherBudgetaryResourcesAmount_CPE must equal the sum of these elements: ContractAuthorityAmountTotal_CPE + BorrowingAuthorityAmountTotal_CPE + SpendingAuthorityfromOffsettingCollectionsAmountTotal_CPE. The Broker cannot distinguish which item is incorrect for this rule. Refer to related rule errors and warnings in this report (rules A9, A10, A11) to distinguish which elements may be incorrect.",
  A4,"StatusOfBudgetaryResourcesTotal_CPE= ObligationsIncurredTotalByTAS_CPE + UnobligatedBalance_CPE",n,appropriations,fatal,,a4_appropriations,"StatusOfBudgetaryResourcesTotal_CPE must equal the sum of these elements: ObligationsIncurredTotalByTAS_CPE + UnobligatedBalance_CPE. The Broker cannot distinguish which item is incorrect for this rule. Refer to related rule errors and warnings in this report (rules A15, A22, A23) to distinguish which elements may be incorrect.",
  A6,"TotalBudgetaryResources_CPE= CPE value for GTAS SF-133 line #1910",n,appropriations,fatal,,a6_appropriations,"(See SQL file)",
  A7,"BudgetAuthorityUnobligatedBalanceBroughtForward_FYB= value for GTAS SF-133 line #1000",n,appropriations,fatal,,a7_appropriations,"(See SQL file)",
  A8,"BudgetAuthorityAppropriatedAmount_CPE= CPE aggregate value for GTAS SF-133 line #1160 + #1180 + #1260 + #1280",n,appropriations,fatal,,a8_appropriations,"(See SQL file)",
  A9,"ContractAuthorityAmountTotal_CPE= CPE aggregate value for GTAS SF-133 line #1540 + #1640",n,appropriations,fatal,,a9_appropriations,"(See SQL file)",
  A10,"BorrowingAuthorityAmountTotal_CPE= CPE aggregate value for GTAS SF-133 line #1340 + #1440",n,appropriations,fatal,,a10_appropriations,"(See SQL file)",
  A11,"SpendingAuthorityfromOffsettingCollectionsAmountTotal_CPE= CPE aggregate value for GTAS SF-133 line #1750 + #1850",n,appropriations,fatal,,a11_appropriations,"(See SQL file)",
  A12,"AdjustmentsToUnobligatedBalanceBroughtForward_CPE= CPE aggregate value for GTAS SF-133 line #1010 through 1042",n,appropriations,fatal,,a12_appropriations,"(See SQL file)",
  A14,"GrossOutlayAmountByTAS_CPE= CPE value for GTAS SF-133 line #3020",n,appropriations,fatal,,a14_appropriations,"(See SQL file)",
  A15,"UnobligatedBalance_CPE= CPE value for GTAS SF-133 line #2490",n,appropriations,fatal,,a15_appropriations,"(See SQL file)",
  A16.1,"All the elements that have FYB in file A are expected in the first submission for a fiscal year",n,appropriations,warning,,a16_appropriations,"If the reporting period is Quarter 1, a non-null amount should be submitted for the following elements: BudgetAuthorityUnobligatedBalanceBroughtForward_FYB","completeness"
  A16.2,"All the elements that have FYB in file B are expected in the first submission for a fiscal year",n,program_activity,warning,,a16_object_class_program_activity,"If the reporting period is Quarter 1, a non-null amount should be submitted for the following elements: BudgetAuthorityUnobligatedBalanceBroughtForward_FYB, ObligationsUndeliveredOrdersUnpaidTotal_FYB, USSGL480100_UndeliveredOrdersObligationsUnpaid_FYB, ObligationsDeliveredOrdersUnpaidTotal_FYB, USSGL490100_DeliveredOrdersObligationsUnpaid_FYB, GrossOutlayAmountByProgramObjectClass_FYB, GrossOutlaysUndeliveredOrdersPrepaidTotal_FYB, USSGL480200_UndeliveredOrdersObligationsPrepaidAdvanced_FYB, GrossOutlaysDeliveredOrdersPaidTotal_FYB, USSGL490800_AuthorityOutlayedNotYetDisbursed_FYB.","completeness"
  A18,"The GrossOutlayAmountByTAS_CPE amount in the appropriation file (A) does not equal the sum of the corresponding GrossOutlayAmountByProgramObjectClass_CPE values in the award financial file (B).",y,appropriations,warning,program_activity,a18_cross_file,"(See SQL file)","accuracy"
  A19,"The ObligationsIncurredTotalByTAS_CPE amount in the appropriation file (A) does not equal the negative sum of the corresponding ObligationsIncurredByProgramObjectClass_CPE values in the award financial file (B).",y,appropriations,warning,program_activity,a19_cross_file,"(See SQL file)","accuracy"
  A22,"ObligationsIncurredTotalByTAS_CPE= CPE value for GTAS SF-133 line #2190",n,appropriations,fatal,,a22_appropriations,"(See SQL file)",
  A23,"StatusOfBudgetaryResourcesTotal_CPE= CPE value for GTAS SF-133 line #2500",n,appropriations,fatal,,a23_appropriations,"(See SQL file)",
  A24,"StatusOfBudgetaryResourcesTotal_CPE = TotalBudgetaryResources_CPE",n,appropriations,fatal,,a24_appropriations,"StatusOfBudgetaryResourcesTotal_CPE must equal TotalBudgetaryResources_CPE. The Broker cannot distinguish which side of the equation is correct for this rule. Refer to related rule errors and warnings in this report (rules A6, A23) to distinguish which elements may be incorrect.",
  A29,"DeobligationsRecoveriesRefundsByTAS_CPE = CPE aggregate value for GTAS SF-133 line 1021+1033",n,appropriations,fatal,,a29_appropriations,"(See SQL file)",
  A30.1,"All TAS values in File A (appropriations) should exist in File B (object class program activity)",y,appropriations,fatal,program_activity,a30_appropriations,"(See SQL file)",
  A30.2,"All TAS values in File B (object class program activity) should exist in File A (appropriations)",y,program_activity,fatal,appropriations,a30_object_class_program_activity,"(See SQL file)",
  A32,"TAS values in File A (appropriations) should be unique",n,appropriations,fatal,,a32_appropriations,"There must be only one line reported per TAS in File A.",
  A33.1,"Each TAS reported to GTAS for SF-133 should be reported in File A, with the exception of Financing Accounts, or when all monetary amounts are zero for the TAS.",n,appropriations,warning,,a33_appropriations_1,"With certain exceptions referenced in the Practices and Procedures, if a TAS is certified in GTAS for SF 133 purposes, it should also be reported for File A.","completeness"
  A33.2,"Each TAS reported in File A should be reported in GTAS for SF-133, with the exception of Financing Accounts, or when all monetary amounts are zero for the TAS.",n,appropriations,warning,,a33_appropriations_2,"With certain exceptions referenced in the Practices and Procedures, if a TAS is certified in GTAS for SF 133 purposes, it should also be reported for File A.","completeness"
  A34,"BudgetAuthorityUnobligatedBalanceBroughtForward_FYB= value for GTAS SF-133 line #2490 from the end of the prior fiscal year.",n,appropriations,fatal,,a34_appropriations,"(See SQL file)",
  A35,"DeobligationsRecoveriesRefundsByTAS_CPE in File A should equal USSGL (4871_CPE+ 4971_CPE+ 4872_CPE+ 4972_CPE) for the TAS in File B.",y,appropriations,warning,program_activity,a35_cross_file,"(See SQL file)","accuracy"
  A36,"BudgetAuthorityUnobligatedBalanceBroughtForward_FYB should have an amount populated for the reporting period, if GTAS line #1000 is populated for the same TAS as of the end of the same reporting period.",n,appropriations,fatal,,a36_appropriations,"(See SQL file)",
  B3.1,"ObligationsUndeliveredOrdersUnpaidTotal (FYB) = USSGL 4801. This applies to the program activity and object class level.",n,program_activity,warning,,b3_object_class_program_activity_1,"Within File B, ObligationsUndeliveredOrdersUnpaidTotal_FYB should equal USSGL4801_FYB. However, the Broker cannot determine which element is incorrect in this rule. Refer to your source information to distinguish which elements may be incorrect.","accuracy"
  B3.2,"ObligationsUndeliveredOrdersUnpaidTotal (CPE) = USSGL(4801 + 4881). This applies to the program activity and object class level.",n,program_activity,warning,,b3_object_class_program_activity_2,"Within File B, ObligationsUndeliveredOrdersUnpaidTotal_CPE should equal USSGL4801_CPE + 4881_CPE. However, the Broker cannot determine which element is incorrect in this rule. Refer to your source information to distinguish which elements may be incorrect.","accuracy"
  B4.1,"ObligationsDeliveredOrdersUnpaidTotal (FYB) = USSGL 4901. This applies to the program activity and object class level.",n,program_activity,warning,,b4_object_class_program_activity_1,"Within File B, ObligationsDeliveredOrdersUnpaidTotal_FYB should equal USSGL4901_FYB. However, the Broker cannot determine which element is incorrect in this rule. Refer to your source information to distinguish which elements may be incorrect.","accuracy"
  
negative.code: B14,"All the Direct Appropriation (D) amounts reported for (4801_CPE less 4801_FYB) + (4802_CPE less 4802_FYB) + 4881_CPE + 4882_CPE + (4901_CPE less 4901_FYB) + 4902_CPE + (4908_CPE less 4908_FYB) + 4981_CPE + 4982_CPE = the opposite sign of SF-133 line 2004 per TAS, for the same reporting period",n,program_activity,warning,,b14_object_class_program_activity,"(See SQL file)","accuracy"
  B15,"All the Reimbursable (R) amounts reported for (4801_CPE less 4801_FYB) + (4802_CPE less 4802_FYB) + 4881_CPE + 4882_CPE + (4901_CPE less 4901_FYB) + 4902_CPE + (4908_CPE less 4908_FYB) + 4981_CPE + 4982_CPE = the opposite sign of SF-133 line 2104 per TAS, for the same reporting period",n,program_activity,warning,,b15_object_class_program_activity,"(See SQL file)","accuracy"
  B18,"If object class is four digits and bydirectreimbursablefundingsource is provided, the object class prefix must be consistent with the value provided for bydirectreimbursablefundingsource",n,program_activity,warning,,b18_object_class_program_activity,"(null), D, or R","accuracy"
  B19,"The combination of TAS/object class/program activity code/reimbursable flag in File B (object class program activity) should be unique",n,program_activity,fatal,,b19_object_class_program_activity,"The combination of TAS/object class/program activity code/reimbursable flag in File B must be unique.","existence"
  B20,"All combinations of TAS/program activity code/object class in File C (award financial) should exist in File B (object class program activity).",y,award_financial,fatal,program_activity,b20_object_class_program_activity,"(See SQL file)","existence"
  C3.1,"ObligationsUndeliveredOrdersUnpaidTotalCPE = USSGL(4801 + 4881). This applies to the award level.",n,award_financial,warning,,c3_award_financial_1,"Within File C, ObligationsUndeliveredOrdersUnpaidTotal_CPE should equal USSGL4801_CPE + 4881_CPE. However, the Broker cannot determine which element is incorrect in this rule. Refer to your source information to distinguish which elements may be incorrect.","accuracy"
  C3.2,"ObligationsUndeliveredOrdersUnpaidTotalFYB = USSGL4801. This applies to the award level.",n,award_financial,warning,,c3_award_financial_2,"Within File C, ObligationsUndeliveredOrdersUnpaidTotal_FYB should equal USSGL4801_FYB. However, the Broker cannot determine which element is incorrect in this rule. Refer to your source information to distinguish which elements may be incorrect.","accuracy"
  C4.1,"ObligationsDeliveredOrdersUnpaidTotalCPE = USSGL(4901 + 4981). This applies to the award level.",n,award_financial,warning,,c4_award_financial_1,"Within File C, ObligationsDeliveredOrdersUnpaidTotal_CPE should equal USSGL4901_CPE + 4981_CPE. However, the Broker cannot determine which element is incorrect in this rule. Refer to your source information to distinguish which elements may be incorrect.","accuracy"
  