Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

14E Year of Budget Authority Indicator

Year of Budget Authority Indicator is required for the applicable USSGL accounts.

YEAR OF 

BUDGET 

AUTHORITY 

CODE

FINANCING 

ACCOUNT 

CODE

Pass (BLANK) DPass (BLANK) GFail BAL DFail BAL GFail NEW DFail NEW G

15E Availability Time Indicator

Availability Time Indicator is required for the applicable USSGL accounts.

USSGL 

ACCOUNT 

NUMBER

Begin End 

Indicator

AVAILABILITY 

TIME 

INDICATOR

Fail 462000 B A

Fail 462000 B SFail 462000 E (BLANK)Pass 462000 B (BLANK)Pass 462000 E APass 462000 E S

17E Prior Year Adjustment Code

Prior Year Adjustment Code is required for the applicable USSGL accounts.

USSGL 

ACCOUNT 

NUMBER

PRIOR YEAR 

ADJUSTMENT 

CODE TAS STATUS

Fail 411100 X EFail 411200 X EFail 411300 X EFail 411400 X EFail 411500 X EFail 411600 X EFail 411700 X EFail 411800 X EFail 412100 X EFail 412300 X EFail 412400 X EFail 412500 X EFail 413100 X EFail 413200 X EFail 413600 X EFail 414100 X EFail 415000 X EFail 415700 X EFail 415800 X E

U.S. Standard General Ledger

Data Validations - Detail

Bulletin No. 2018-04 VII VDR - 1 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Fail 416800 X EFail 417000 X EFail 417500 X EFail 419000 X EFail 421200 X EFail 429000 X EFail 438200 X EFail 438700 X EFail 438800 X EFail 439200 X EFail 439400 X EFail 439700 X EFail 439800 X EFail 439801 X EFail 439900 X EFail 445000 X EFail 462000 X EFail 490800 X E

21E GTAS Fund Type

Specific USSGL accounts are valid for each GTAS Fund Type.

USSGL 

ACCOUNT 

NUMBER FUND TYPE

CONCATENATE

D TAS

Fail 411400 ET 015 X8526000Fail 411400 ET 015 X8585000Fail 411400 ET 015 X8594000Fail 411400 ET 015 X8595000Fail 411400 ET 015 X8596000Fail 411400 ET 015 X8600000Fail 411400 ET 015 X8602000Fail 411400 ET 015 X8604000Fail 411400 ET 015 X8608000Fail 411400 ET 070 X8530000Fail 411400 ET 070 X8598000

22E TAS Status

The USSGL accounts must be valid for the TAS Status.

USSGL 

ACCOUNT 

NUMBER FUND TYPE TAS STATUS

Fail 435000 EG UFail 435000 ER UFail 435000 EP UFail 435000 TR UFail 435000 EC UFail 435000 EM U

Bulletin No. 2018-04 VII VDR - 2 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass 435000 ES UPass 435000 ET U

23E Borrowing Source Code

Borrowing Source Code is required for applicable USSGL accounts.

USSGL 

ACCOUNT 

NUMBER

AUTHORITY 

TYPE

BORROWING 

SOURCE

Fail 438200 D FFail 438200 D TFail 438200 D PFail 438200 P FFail 438200 P TFail 438200 S FFail 438200 S TFail 438200 S PFail 438200 C FFail 438200 C TFail 438200 C PFail 438200 P PFail 438200 B (BLANK)Pass 438200 B FPass 438200 B PPass 438200 B TPass 438200 D (BLANK)Pass 438200 P (BLANK)Pass 438200 S (BLANK)Pass 438200 C (BLANK)Fail 438400 C FFail 438400 C PFail 438400 C TFail 438400 D FFail 438400 D PFail 438400 D TFail 438400 P FFail 438400 P PFail 438400 P TFail 438400 S FFail 438400 S PFail 438400 S TPass 438400 P (BLANK)Pass 438400 S (BLANK)Pass 438400 C (BLANK)

Bulletin No. 2018-04 VII VDR - 3 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass 438400 D (BLANK)Fail 439200 B (BLANK)Fail 439200 C FFail 439200 C TFail 439200 C PFail 439200 D FFail 439200 D TFail 439200 D PFail 439200 E FFail 439200 E TFail 439200 E PFail 439200 F FFail 439200 F TFail 439200 F PFail 439200 P FFail 439200 P TFail 439200 P PFail 439200 R FFail 439200 R TFail 439200 R PFail 439200 S FFail 439200 S TFail 439200 S PPass 439200 B FPass 439200 B TPass 439200 B PPass 439200 C (BLANK)Pass 439200 D (BLANK)Pass 439200 E (BLANK)Pass 439200 F (BLANK)Pass 439200 P (BLANK)Pass 439200 R (BLANK)Pass 439200 S (BLANK)Fail 439300 B (BLANK)Fail 439300 C FFail 439300 C TFail 439300 C PFail 439300 D FFail 439300 D TFail 439300 D P

Bulletin No. 2018-04 VII VDR - 4 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Fail 439300 E FFail 439300 E TFail 439300 E PFail 439300 F FFail 439300 F TFail 439300 F PFail 439300 P FFail 439300 P TFail 439300 P PFail 439300 R FFail 439300 R TFail 439300 R PFail 439300 S FFail 439300 S TFail 439300 S PPass 439300 B FPass 439300 B TPass 439300 B PPass 439300 C (BLANK)Pass 439300 D (BLANK)Pass 439300 E (BLANK)Pass 439300 F (BLANK)Pass 439300 P (BLANK)Pass 439300 R (BLANK)Pass 439300 S (BLANK)

24E Reporting Type Code

The USSGL Accounts must be valid for the Reporting Type Code.

USSGL 

ACCOUNT 

NUMBER

REPORTING 

TYPE CODE

CONCATENATE

D TAS

Pass 340000 U 020 X6311000

25 439100 and Appropriation Flag Validation

USSGL 439100 can only be used on the bulk file if the Appropriation Flag on the SMAF is I (Indefinite) or M (Mixed). Fail

USSGL 

ACCOUNT 

NUMBER

APPROPRIATIO

N FLAG

=439100 =(BLANK)

26

Anticipated USSGL Account Balance in Period 12

If the period is 12, then the account balance for all anticipated USSGL accounts must be zero. Fail

Reporting 

Period

DOLLAR 

AMOUNT

SGL 

ANTICIPATED

=12 <>0 =Y

Bulletin No. 2018-04 VII VDR - 5 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

27

Credit Cohort Year and Financing Account Code Validation

If Financing Account Code for the TAS is D (Direct) or G (Guaranteed) on the SMAF and the USSGL account is budgetary, then the Credit Cohort Year is required. Otherwise, Credit Cohort Year should be null. Pass

CREDIT 

COHORT YEAR

BUDGETARY 

PROPRIETARY

FINANCING 

ACCOUNT 

CODE

=(BLANK) =A =D

=(BLANK) =A =N=(BLANK) =A =G=(BLANK) =B =N=(BLANK) =P =D=(BLANK) =P =N=(BLANK) =P =G=1992 =B =D=1992 =B =G=1993 =B =D=1993 =B =G=1994 =B =D=1994 =B =G=1995 =B =D=1995 =B =G=1996 =B =D=1996 =B =G=1997 =B =D=1997 =B =G=1998 =B =D=1998 =B =G=1999 =B =D=1999 =B =G=2000 =B =D=2000 =B =G=2001 =B =D=2001 =B =G=2002 =B =D=2002 =B =G=2003 =B =D=2003 =B =G=2004 =B =D=2004 =B =G=2005 =B =D=2005 =B =G=2006 =B =D

Bulletin No. 2018-04 VII VDR - 6 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

=2006 =B =G=2007 =B =D=2007 =B =G=2008 =B =D=2008 =B =G=2009 =B =D=2009 =B =G=2010 =B =D=2010 =B =G=2011 =B =D=2011 =B =G=2012 =B =D=2012 =B =G=2013 =B =D=2013 =B =G=2014 =B =D=2014 =B =G=2015 =B =D=2015 =B =G=2016 =B =D=2016 =B =G=2017 =B =D=2017 =B =G=2018 =B =D=2018 =B =G

27E

Credit Cohort Year and Financing Account Code Validation

If Financing Account Code for the TAS is D (Direct) or G (Guaranteed) on the SMAF and the USSGL account is budgetary, then the Credit Cohort Year is required. Otherwise, Credit Cohort Year should be null.

CREDIT 

COHORT YEAR

CONCATENATE

D TAS

FINANCING 

ACCOUNT 

CODE

Pass (BLANK) 086 X4240000 DPass (BLANK) 086 X4240000 GPass (BLANK) 091 X4251000 DPass (BLANK) 091 X4251000 GPass (BLANK) 091 X4252000 DPass (BLANK) 091 X4252000 GPass (BLANK) 091 X4253000 DPass (BLANK) 091 X4253000 GPass (BLANK) 091 X4255000 DPass (BLANK) 091 X4255000 GPass (BLANK) 091 X4290000 D

Bulletin No. 2018-04 VII VDR - 7 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass (BLANK) 091 X4290000 GPass (BLANK) 091 X4449000 DPass (BLANK) 091 X4449000 GPass (BLANK) 091 X4453000 DPass (BLANK) 091 X4453000 GPass (BLANK) 091 X4459000 DPass (BLANK) 091 X4459000 GPass (BLANK) 091 X4300000 DPass (BLANK) 091 X4300000 GPass 1001 071 X4074000 DPass 1001 071 X4074000 GPass 1001 071 X4075000 DPass 1001 071 X4075000 GPass 2019 012 X4158000 DPass 2019 012 X4158000 GPass 2019 086 X4587000 DPass 2019 086 X4587000 G

28 PYA and Beginning Balance Validation

If the Begin End Indicator is B (Beginning), then the Prior Year Adjustment Code value must be X (not an adjustment to prior year reporting). Fail

Begin End 

Indicator

PRIOR YEAR 

ADJUSTMENT 

CODE

=B =B=B =P

29

Program Report Category Code and Apportionment Category Code Validation

If the Apportionment Category Code is E, then Program Report Category Code (number) must be null. Fail

APPORTIONME

NT CATEGORY 

CODE

PROGRAM 

REPORT 

CATEGORY 

NUMBER

=(BLANK) =##=E =##

29E

Program Report Category Code and Apportionment Category Code Validation

If the Apportionment Category Code is E, then Program Report Category Code (number) must be null.

USSGL 

ACCOUNT 

NUMBER

APPORTIONME

NT CATEGORY 

CODE

PROGRAM 

REPORT 

CATEGORY 

NUMBER

Fail 406000 B ##Fail 406000 A ##

Pass 406000 A (BLANK)

Pass 406000 B (BLANK)Fail 407000 A ##

Fail 407000 B ##Pass 407000 A (BLANK)

Pass 407000 B (BLANK)

Bulletin No. 2018-04 VII VDR - 8 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Fail 421000 A ##

Fail 421000 B ##Pass 421000 A (BLANK)

Pass 421000 B (BLANK)Fail 421500 A ##

Fail 421500 B ##Pass 421500 A (BLANK)

Pass 421500 B (BLANK)Fail 431000 A ##

Fail 431000 B ##Pass 431000 A (BLANK)

Pass 431000 B (BLANK)Fail 463000 A ##

Fail 463000 B ##Pass 463000 A (BLANK)

Pass 463000 B (BLANK)Fail 465000 A ##

Fail 465000 B ##Pass 465000 A (BLANK)

Pass 465000 B (BLANK)

30

Apportionment Category B and Apportionment Category B Program Code (Number) Validation

If Apportionment Category Code is B, then Apportionment Category B Program Code (number) is required. The values must be between 6011-6159. Fail

APPORTIONME

NT CATEGORY 

CODE

APPORTIONME

NT CATEGORY 

B PROGRAM

=(BLANK) =####=A =####

=B =(BLANK)=E =####

30E

Apportionment Category B and Apportionment Category B Program Code (Number) Validation

If Apportionment Category Code is B, then Apportionment Category B Program Code (number) is required. The values must be between 6011-6159.

USSGL 

ACCOUNT 

NUMBER

APPORTIONME

NT CATEGORY 

CODE

APPORTIONME

NT CATEGORY 

B PROGRAM

Fail 406000 B ####Pass 406000 B (BLANK)Fail 407000 B ####Pass 407000 B (BLANK)Fail 421000 B ####Pass 421000 B (BLANK)Fail 421500 B ####Pass 421500 B (BLANK)Fail 431000 B ####

Bulletin No. 2018-04 VII VDR - 9 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass 431000 B (BLANK)Fail 463000 B ####Pass 463000 B (BLANK)Fail 465000 B ####Pass 465000 B (BLANK)

31 BEA Category Validation

The Bulk File BEA Category Indicator must agree with the TAS level BEA Category Indicator on the SMAF, unless TAS level BEA Category Indicator on the SMAF is N (NET), in which Bulk File BEA Category would be M (Mandatory). Fail

BEA CATEGORY 

INDICATOR

TAS LEVEL BEA 

CATEGORY

=D =M=D =(BLANK)=D =I=D =G=D =N=M =D=M =(BLANK)=M =I=M =G

31E BEA Category Validation

The Bulk File BEA Category Indicator must agree with the TAS level BEA Category Indicator on the SMAF, unless TAS level BEA Category Indicator on the SMAF is N (NET), in which Bulk File BEA Category would be M (Mandatory).

BEA CATEGORY 

INDICATOR

CONCATENATE

D TAS

Pass M 020 X0503000

32

Is First Year and Year of Budget Authority Indicator Validation

If Is First Year is Y, then Year of BA must be NEW. If Is First Year is N, then Year of BA must be BAL for annual & multiyear TAS when using PYA of X, and can be NEW or BAL for X year TAS and for annual & multiyear TAS when using PYA B or P. Fail

AVAILABILITY 

TYPE CODE

YEAR OF 

BUDGET 

AUTHORITY 

CODE

PRIOR YEAR 

ADJUSTMENT 

CODE 

<>X =BAL =B <>X =BAL =P <>X =BAL =X <>X =BAL =(BLANK) <>X =NEW =X =X =BAL =B =X =BAL =P =X =BAL =X =X =BAL =(BLANK) 

Bulletin No. 2018-04 VII VDR - 10 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

32E

Is First Year and Year of Budget Authority Indicator Validation

If Is First Year is Y, then Year of BA must be NEW. If Is First Year is N, then Year of BA must be BAL for annual & multiyear TAS when using PYA of X, and can be NEW or BAL for X year TAS and for annual & multiyear TAS when using PYA B or P.

YEAR OF 

BUDGET 

AUTHORITY 

CODE IS FIRST YEAR

CONCATENATE

D TAS

Pass NEW N

57920102019 

8299000

Pass NEW N

08920162017 

0228000

Pass NEW N

08920162017 

0243000

Pass NEW N

08920162017 

0251000

Pass NEW N

08920162017 

0318000

Pass NEW N

08920162017 

0321000

Pass NEW N

08920162017 

0337000

33

Federal Non-Federal Code and Trading Partner Agency Identifier Validation

If Federal Non-Federal Code is F (Federal), then Trading Partner Agency Identifier is required. If Federal Non-Federal Code is G (General Fund of the U.S. Government), then Trading Partner Agency Identifier must be 099. Exceptions may apply. Fail

FEDERAL 

NONFEDERAL 

INDICATOR

TRADING 

PARTNER 

AGENCY 

IDENTIFIER

=(BLANK) =###=E =###=F <>###=F =099=G <>099=N =###=Z =###

33E

Federal Non-Federal Code and Trading Partner Agency Identifier Validation

If Federal Non-Federal Code is F (Federal), then Trading Partner Agency Identifier is required. If Federal Non-Federal Code is G (General Fund of the U.S. Government), then Trading Partner Agency Identifier must be 099. Exceptions may apply.

USSGL 

ACCOUNT 

NUMBER

FEDERAL 

NONFEDERAL 

INDICATOR

TRADING 

PARTNER 

AGENCY 

IDENTIFIER

Fail 421200 F ###Pass 421200 F (BLANK)Fail 422100 F ###Pass 422100 F (BLANK)

Bulletin No. 2018-04 VII VDR - 11 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Fail 422200 F ###Pass 422200 F (BLANK)Fail 423100 F ###Pass 423100 F (BLANK)Fail 425100 F ###Pass 425100 F (BLANK)Fail 425200 F ###Pass 425200 F (BLANK)Fail 425300 F ###Pass 425300 F (BLANK)Fail 487200 F ###Pass 487200 F (BLANK)Fail 497200 F ###Pass 497200 F (BLANK)

34

Federal Non-Federal Code and Trading Partner Main Account Validation

If Federal Non-Federal Code is F (Federal), then Trading Partner Main Account is required. The TP Main Account will be phasedin beginning in FY 2015. Fail

BEGINNING 

PERIOD OF 

AVAILABILITY

FEDERAL 

NONFEDERAL 

INDICATOR

TRADING 

PARTNER MAIN 

ACCOUNT 

CODE

<>2015 =E =####<>2015 =N =####<>2015 =Z =####<>2015 =(BLANK) =####<>2016 =E =####<>2016 =N =####<>2016 =Z =####<>2016 =(BLANK) =####<>2017 =E =####<>2017 =N =####<>2017 =Z =####<>2017 =(BLANK) =####<>2018 =E =####<>2018 =N =####<>2018 =Z =####<>2018 =(BLANK) =####=2015 =E =####=2015 =F =(BLANK)=2015 =G =(BLANK)=2015 =N =####=2015 =Z =####=2015 =(BLANK) =####

Bulletin No. 2018-04 VII VDR - 12 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

=2016 =E =####=2016 =F =(BLANK)=2016 =G =(BLANK)=2016 =N =####=2016 =Z =####=2016 =(BLANK) =####=2017 =E =####=2017 =F =(BLANK)=2017 =G =(BLANK)=2017 =N =####=2017 =Z =####=2017 =(BLANK) =####=2018 =E =####=2018 =F =(BLANK)=2018 =G =(BLANK)=2018 =N =####=2018 =Z =####=2018 =(BLANK) =####

34E

Federal Non-Federal Code and Trading Partner Main Account Validation

If Federal Non-Federal Code is F (Federal), then Trading Partner Main Account is required. The TP Main Account will be phasedin beginning in FY 2015.

USSGL 

ACCOUNT 

NUMBER

FEDERAL 

NONFEDERAL 

INDICATOR

TRADING 

PARTNER MAIN 

ACCOUNT 

CODE 

Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) 

Bulletin No. 2018-04 VII VDR - 13 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) 

Bulletin No. 2018-04 VII VDR - 14 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) (BLANK) (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Pass (BLANK) F (BLANK) Pass (BLANK) G (BLANK) Fail 421200 F #### Pass 421200 F (BLANK) Fail 422100 F #### Pass 422100 F (BLANK) Fail 422200 F #### Pass 422200 F (BLANK) Fail 423100 F #### Pass 423100 F (BLANK) Fail 425100 F #### Pass 425100 F (BLANK) Fail 425200 F #### Pass 425200 F (BLANK) Fail 425300 F #### Pass 425300 F (BLANK) Fail 487200 F #### Pass 487200 F (BLANK) Fail 497200 F #### Pass 497200 F (BLANK) 

35

Federal Non-Federal Code G and Trading Partner Main Account 0000 Validation

If Federal Non-Federal Code is G (General Fund of the U.S. Government), then Trading Partner Main Account must be 0000. Fail

FEDERAL 

NONFEDERAL 

INDICATOR

TRADING 

PARTNER MAIN 

ACCOUNT 

CODE

=G =####

Bulletin No. 2018-04 VII VDR - 15 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

35E

Federal Non-Federal Code G and Trading Partner Main Account 0000 Validation

If Federal Non-Federal Code is G (General Fund of the U.S. Government), then Trading Partner Main Account must be 0000.

FEDERAL 

NONFEDERAL 

INDICATOR

TRADING 

PARTNER MAIN 

ACCOUNT 

CODE

Pass G 0000

36

TAS Restrictions for USSGL 192100 Receivable from Appropriations Validation

USSGL account 192100 is restricted to specific TAS within the Department of the Treasury. Fail

USSGL 

ACCOUNT 

NUMBER Fund Family

=192100 <>0200500=192100 <>0200550=192100 <>0200551=192100 <>0200575=192100 <>0200903=192100 <>0200904=192100 <>0201875=192100 <>0200505

37 Pd 12 Zero Balance Validation

The Dollar Amount for specific USSGL accounts must be $0 in period 12. Fail

Reporting 

Period

USSGL 

ACCOUNT 

NUMBER

DOLLAR 

AMOUNT

=12 =109000 <>0=12 =209010 <>0=12 =424000 <>0=12 =439500 <>0

38

USSGL 435000 and TAS Status Transitioning Flag

If the TAS Status Transitioning Flag is K (Canceling), then USSGL 435000 Debit Credit Indicator must be C (Credit). Fail

USSGL 

ACCOUNT 

NUMBER

DEBIT CREDIT 

INDICATOR

TAS STATUS 

TRANSITIONING 

CODE

=435000 =D =K

39 PYA and Is First Year

If the Is First Year Indicator is Y (Yes) on the SMAF, then the PYA must be X (not an adjustment to prior year reporting). Fail

PRIOR YEAR 

ADJUSTMENT 

CODE IS FIRST YEAR

=B =Y

=P =Y

39E PYA and Is First Year

If the Is First Year Indicator is Y (Yes) on the SMAF, then the PYA must be X (not an adjustment to prior year reporting).

PRIOR YEAR 

ADJUSTMENT 

CODE

CONCATENATE

D TAS

40 TAS Status Transitioning Flag and 101000

If the TAS Status Transitioning Flag is K (Canceling), then 101000 ending balance must be $0. Fail

USSGL 

ACCOUNT 

NUMBER

DOLLAR 

AMOUNT

Begin End 

Indicator

=101000 <>0 =E 

41

Prior Year Upward and Downward Adjustments and Is First Year

Prior Year Upward and Downward Adjustments cannot be reported in the TAS first year. Fail

USSGL 

ACCOUNT 

NUMBER IS FIRST YEAR

Bulletin No. 2018-04 VII VDR - 16 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

=498100 =Y=498200 =Y

42 USSGL 490800 TAS limitation USSGL 490800 is restricted to specific TAS. Fail

USSGL 

ACCOUNT 

NUMBER

=490800

42E USSGL 490800 TAS limitation USSGL 490800 is restricted to specific TAS.

CONCATENATE

D TAS

Pass 010 X4518000Pass 020 X0550000Pass 088 X0300000Pass

020011 X0074000

43 USSGL 412200 is limited to TAS 20X0550 USSGL 412200 is limited to TAS 20X0550 Fail

AGENCY 

IDENTIFIER

AVAILABILITY 

TYPE CODE

MAIN ACCOUNT 

CODE

<>020 <>X <>0550 

44 USSGLs limited to X Authority Duration Code

Specific USSGLs are limited to TAS with Authority Duration Code X (No Year TAS). Fail

USSGL 

ACCOUNT 

NUMBER

AUTHORITY 

DURATION 

CODE

=412200 <>X=413600 <>X=414900 <>X=415700 <>X=415800 <>X=427300 <>X=436000 <>X=438400 <>X=439400 <>X=439401 <>X=439700 <>X=439701 <>X=439800 <>X=439801 <>X

44E USSGLs limited to X Authority Duration Code

Specific USSGLs are limited to TAS with Authority Duration Code X (No Year TAS).

USSGL 

ACCOUNT 

NUMBER

AUTHORITY 

TYPE

BEA CATEGORY 

INDICATOR

Pass 414900 (BLANK) (BLANK)

Pass 414900 (BLANK) (BLANK)

Bulletin No. 2018-04 VII VDR - 17 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass 415800 (BLANK) DPass 415800 (BLANK) DPass 438400 P MPass 438400 P MPass 438400 P MPass 438400 P MPass 438400 S DPass 438400 S DPass 438400 P DPass 438400 S DPass 438400 P DPass 438400 P DPass 438400 S DPass 438400 S DPass 438400 S DPass 438400 P DPass 438400 P DPass 438400 P DPass 438400 P DPass 438400 S DPass 438400 S DPass 438400 S M

Bulletin No. 2018-04 VII VDR - 18 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass 438400 S MPass 438400 S MPass 438400 S MPass 438400 S MPass 438400 S MPass 438400 S MPass 438400 S DPass 438400 S DPass 438400 S MPass 438400 P DPass 438400 S DPass 438400 P DPass 438400 S DPass 438400 S DPass 438400 P MPass 438400 S MPass 438400 S MPass 438400 S MPass 438400 S MPass 438400 S MPass 438400 S MPass 438400 P M

Bulletin No. 2018-04 VII VDR - 19 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass 438400 S MPass 438400 S MPass 438400 S MPass 438400 S MPass 438400 S MPass 439800 S DPass 439800 S D

45 TAS Restrictions for USSGL 432000

USSGL 432000 is restricted to TAS in the Department of Health and Human Services and the Social Security Administration. Fail

AGENCY 

IDENTIFIER

USSGL 

ACCOUNT 

NUMBER

<>028 =432000<>075 =432000

46 TAS Restrictions for Non-Federal Exceptions

Federal Non-Federal Code domain value E (Non-Federal exceptions) is restricted to specific TAS Fail

FEDERAL 

NONFEDERAL 

INDICATOR Fund Family

=E <>0110109=E <>0110210=E <>0120600=E <>0121103=E <>0121104=E <>0121105=E <>0121106=E <>0121115=E <>0121400=E <>0121500=E <>0121600=E <>0121801=E <>0122500=E <>0123700=E <>0124050=E <>0124605=E <>0124609=E <>0125161=E <>0125410=E <>0128028

Bulletin No. 2018-04 VII VDR - 20 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

=E <>0130300=E <>0131006=E <>0131450=E <>0134295=E <>0140680=E <>0140804=E <>0141039=E <>0141125=E <>0141611=E <>0141612=E <>0142100=E <>0144523=E <>0144529=E <>0145015=E <>0145017=E <>0145020=E <>0148069=E <>0150200=E <>0151060=E <>0151100=E <>0151300=E <>0171804=E <>0171810=E <>0201008=E <>0204444=E <>0204502=E <>0212032=E <>0254468=E <>0514596=E <>0573010=E <>0573020=E <>0573400=E <>0573600=E <>0608118=E <>0694089=E <>0698083=E <>0700500=E <>0700509=E <>0700530=E <>0700531

Bulletin No. 2018-04 VII VDR - 21 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

=E <>0700542=E <>0700610=E <>0705687=E <>0705694=E <>0800109=E <>0800110=E <>0800111=E <>0800114=E <>0800115=E <>0800122=E <>0804546=E <>0884578=E <>0930100=E <>0978337=E <>3391400=E <>3491712=E <>4554110=E <>5124331

46E TAS Restrictions for Non-Federal Exceptions

Federal Non-Federal Code domain value E (Non-Federal exceptions) is restricted to specific TAS

FEDERAL 

NONFEDERAL 

INDICATOR

CONCATENATE

D TAS

Fail E

01420102012 

2100000

Fail E

01420112012 

2100000

Fail E

01420112013 

2100000

Fail E

01420122012 

2100000

Fail E

01420122013 

2100000

Fail E

01420122014 

2100000

Fail E

01420132013 

2100000

Fail E

01420132014 

2100000

Fail E

01420132015 

2100000

Fail E

01420142014 

2100000

Bulletin No. 2018-04 VII VDR - 22 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Fail E

01420142015 

2100000

Fail E

01420142016 

2100000

Fail E

05720102012 

3010000

Fail E

05720112013 

3010000

Fail E

05720102012 

3020000

Fail E

05720112013 

3020000

Fail E

05720122012 

3400000

Fail E

05720132013 

3400000

Fail E

05720112012 

3600000

Fail E

05720122013 

3600000

Fail E

06905720122012 

3400005

Fail E

06905720132013 

3400005

47

Borrowing Authority from Treasury and Borrowing Source Validation

If the Borrowing Authority from Treasury Indicator is other than N (No Borrowing Authority from Treasury), then the USSGL Borrowing Source must be T (Treasury) or F (Federal Financing Bank). Fail

BORROWING 

SOURCE

BORROWING 

AUTHORITY 

FROM 

TREASURY

=F =N=P =I=P =D=P =M

47E

Borrowing Authority from Treasury and Borrowing Source Validation

If the Borrowing Authority from Treasury Indicator is other than N (No Borrowing Authority from Treasury), then the USSGL Borrowing Source must be T (Treasury) or F (Federal Financing Bank).

BORROWING 

SOURCE

BORROWING 

AUTHORITY 

FROM 

TREASURY

BORROWING 

AUTHORITY 

FROM THE 

PUBLIC

Pass P I MPass P D MPass P I DPass P I IPass P D I

Bulletin No. 2018-04 VII VDR - 23 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass P D DPass P M MPass P M IPass P M D

48

Borrowing Authority from the Public and Borrowing Source Validation

If the Borrowing Authority from the Public Indicator is other than null, then the USSGL Borrowing Source must be P (public). Fail

BORROWING 

SOURCE

BORROWING 

AUTHORITY 

FROM THE 

PUBLIC

=F =I=F =D=F =M=P =N=T =I=T =D=T =M

48E

Borrowing Authority from the Public and Borrowing Source Validation

If the Borrowing Authority from the Public Indicator is other than null, then the USSGL Borrowing Source must be P (public).

BORROWING 

SOURCE

BORROWING 

AUTHORITY 

FROM 

TREASURY

BORROWING 

AUTHORITY 

FROM THE 

PUBLIC

Pass F I MPass F I IPass F I DPass F D MPass F D IPass F D DPass F M MPass F M IPass F M DPass T I MPass T I IPass T I DPass T D MPass T D DPass T M MPass T M IPass T M DPass T D I

49

USSGL Accounts and Borrowing Authority Indicator

USSGLs 404200, 404400, 414000, 414100, 414300, 414400, 414500, 414800, 414900 are limited to TAS with Borrowing from the Treasury or Borrowing from the Public. Fail

USSGL 

ACCOUNT 

NUMBER

BORROWING 

AUTHORITY 

FROM 

TREASURY

BORROWING 

AUTHORITY 

FROM THE 

PUBLIC

Bulletin No. 2018-04 VII VDR - 24 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

=404200 =N =N=404400 =N =N=414000 =N =N=414100 =N =N=414300 =N =N=414400 =N =N=414500 =N =N=414800 =N =N=414900 =N =N

50

USSGL Accounts and Contract Authority Indicator

USSGLs 403200, 403400, 413000, 413100, 413200, 413300, 413400, 413500, 413600, 413800, 413900 are limited to TAS with Contract Authority. Fail

USSGL 

ACCOUNT 

NUMBER

CONTRACT 

AUTHORITY

=403200 =N=403400 =N=413000 =N=413100 =N=413200 =N=413300 =N=413400 =N=413500 =N=413600 =N=413800 =N=413900 =N

51

Backdated Transaction and Prior Year Adjustment

If a transaction has been backdated to a previous fiscal year in CARS, then the Prior Year Adjustment for the transaction is B. The Backdated Transaction field on the SMAF will be Y (yes) if a backdated transaction has been processed. Fail

PRIOR YEAR 

ADJUSTMENT 

CODE

Backdated 

Transaction

=B =N

51E

Backdated Transaction and Prior Year Adjustment

If a transaction has been backdated to a previous fiscal year in CARS, then the Prior Year Adjustment for the transaction is B. The Backdated Transaction field on the SMAF will be Y (yes) if a backdated transaction has been processed.

PRIOR YEAR 

ADJUSTMENT 

CODE

CONCATENATE

D TAS

Backdated 

Transaction

Pass B 075 X3966000 N

52 Is First Year and Beginning Balance Validation

If the TAS is in the First Year of Authority then the Beginning/Ending Attribute must be E. Fail

Begin End 

Indicator IS FIRST YEAR

=B =Y

Bulletin No. 2018-04 VII VDR - 25 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

52E Is First Year and Beginning Balance Validation

If the TAS is in the First Year of Authority then the Beginning/Ending Attribute must be E.

CONCATENATE

D TAS

53 USSGLs limited to ESF and Sinking Fund TAS

Some USSGL accounts are limited to TAS 020X4444 and 020X0575. Fail

USSGL 

ACCOUNT 

NUMBER

=120500=120900=134400=138400=167000=167100=167200=167900=219200=219300=426800=463500=633800=718100=719100=728100=729100

53E USSGLs limited to ESF and Sinking Fund TAS

Some USSGL accounts are limited to TAS 020X4444 and 020X0575.

CONCATENATE

D TAS

Pass 020 X0575000Pass 020 X4444000

55

USSGL 259000 with "G" Federal Non Federal Indicator limited to certain TAS'.

The use of the "G" domain value for USSGL 259000 is limited to certain TAS'. Fail

USSGL 

ACCOUNT 

NUMBER

FEDERAL 

NONFEDERAL 

INDICATOR

=259000 =G

55E

USSGL 259000 with "G" Federal Non Federal Indicator limited to certain TAS'.

The use of the "G" domain value for USSGL 259000 is limited to certain TAS'.

CONCATENATE

D TAS

Pass 089 1424000Pass 089 1435000Pass 089 2247000Pass 089 2248000Pass 089 2249000Pass 089 2814000Pass 089 X0302000Pass 089 X0303000

Bulletin No. 2018-04 VII VDR - 26 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass 089 X4045000Pass 089 X4452000Pass 089 X5068000Pass 089 X5649000

56

USSGL 199000 and Federal Non Federal Indicator "G" limited to certain Agencies.

Use of USSGL 199000 with Federal Non Federal Indicator "G" limited to certain agencies. Fail

USSGL 

ACCOUNT 

NUMBER

FEDERAL 

NONFEDERAL 

INDICATOR

=199000 =G

56E

USSGL 199000 and Federal Non Federal Indicator "G" limited to certain Agencies.

Use of USSGL 199000 with Federal Non Federal Indicator "G" limited to certain agencies.

AGENCY 

IDENTIFIER

Pass 018

57

USSGL 750000 with Federal Non Federal Indicator "G" limited to certain TAS'

Use of USSGL 750000 with Federal Non Federal Indicator "G" limited to certain TAS'. Fail

USSGL 

ACCOUNT 

NUMBER

FEDERAL 

NONFEDERAL 

INDICATOR

=750000 =G

57E

USSGL 750000 with Federal Non Federal Indicator "G" limited to certain TAS'

Use of USSGL 750000 with Federal Non Federal Indicator "G" limited to certain TAS'.

CONCATENATE

D TAS

Pass 020 X5080000Pass 455 X4110000

64

USSGL 438400 with Reduction Type "SEQ", Fund Type "EG" Authority Type "P"

USSGL 4384000 with Reduction Type "SEQ", Fund Type "EG", and Authority Type Code "P" is limited to certain TAS. Fail

USSGL 

ACCOUNT 

NUMBER

AUTHORITY 

TYPE FUND TYPE 

=438400 =P =EG 

64E

USSGL 438400 with Reduction Type "SEQ", Fund Type "EG" Authority Type "P"

USSGL 4384000 with Reduction Type "SEQ", Fund Type "EG", and Authority Type Code "P" is limited to certain TAS.

USSGL 

ACCOUNT 

NUMBER

AUTHORITY 

TYPE

CONCATENATE

D TAS 

Fail 438400 P

01220112011 

1143000 

Fail 438400 P

01220122012 

1143000 

65

Limited Use of USSGL 4119 with Prior Year Adjustment "X" on Expired TAS

Use of USSGL 4119 with PYA "X" on expired TAS is limited to certain TAS'. Fail

USSGL 

ACCOUNT 

NUMBER

PRIOR YEAR 

ADJUSTMENT 

CODE TAS STATUS

=411900 =X =E

65E

Limited Use of USSGL 4119 with Prior Year Adjustment "X" on Expired TAS

Use of USSGL 4119 with PYA "X" on expired TAS is limited to certain TAS'.

USSGL 

ACCOUNT 

NUMBER

PRIOR YEAR 

ADJUSTMENT 

CODE TAS STATUS 

Pass 411900 X E Pass 411900 X E Pass 411900 X E 

Bulletin No. 2018-04 VII VDR - 27 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass 411900 X E Pass 411900 X E 

66

Limited Use of Borrowing Authority from Treasury Indicator "N" and Borrowing Source "T"

The use of Borrowing Source "T" (Treasury) when Borrowing Authority from Treasury Indicator equals "N" is limited to specific TAS'. Fail

BORROWING 

SOURCE

BORROWING 

AUTHORITY 

FROM 

TREASURY

=T =N

66E

Limited Use of Borrowing Authority from Treasury Indicator "N" and Borrowing Source "T"

The use of Borrowing Source "T" (Treasury) when Borrowing Authority from Treasury Indicator equals "N" is limited to specific TAS'.

BORROWING 

SOURCE

CONCATENATE

D TAS

BORROWING 

AUTHORITY 

FROM 

TREASURY

Pass T 012 X5531000 N

67

Limited use of specific USSGL Accounts with Authority Type Code "B"

The use of some USSGL Accounts with Authority Type Code "B" is limited to specific TAS. Fail

USSGL 

ACCOUNT 

NUMBER

AUTHORITY 

TYPE

=412600 =B=412800 =B=412900 =B=414600 =B

67E

Limited use of specific USSGL Accounts with Authority Type Code "B"

The use of some USSGL Accounts with Authority Type Code "B" is limited to specific TAS.

ALLOCATION 

TRANSFER 

AGENCY 

IDENTIFIER

AGENCY 

IDENTIFIER

MAIN ACCOUNT 

CODE

Pass (BLANK) 012 5531 Pass (BLANK) 012 5531 Pass (BLANK) 016 8042 Pass (BLANK) 016 8144 Pass (BLANK) 089 4404 Pass (BLANK) 089 4455 Pass (BLANK) 089 4576 Pass (BLANK) 089 4579 Pass (BLANK) 016 8042 Pass (BLANK) 075 8004 

68

Limited Use of 404700 with Authority Type Code "B", BEA of "M", Fund Type "ER/EP" and Finance Account Indicator "D"

The use of USSGL 404700 with Authority Type Code "B", BEA Category Indicator "M", Fund Type "ER/EP" and Financing Account Code "D" is limited to specific TAS. Fail

USSGL 

ACCOUNT 

NUMBER

AUTHORITY 

TYPE

BEA CATEGORY 

INDICATOR 

=404700 =B =M =404700 =B =M 

Bulletin No. 2018-04 VII VDR - 28 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

68E

Limited Use of 404700 with Authority Type Code "B", BEA of "M", Fund Type "ER/EP" and Finance Account Indicator "D"

The use of USSGL 404700 with Authority Type Code "B", BEA Category Indicator "M", Fund Type "ER/EP" and Financing Account Code "D" is limited to specific TAS.

CONCATENATE

D TAS

Pass 089 X4455000Pass 089 X4576000Pass 089 X4579000

69

Limited use of specific USSGL and Fund Type combinations

The use of some USSGL and GTAS Fund Type Code combinations is limited to specific Treasury Account Symbols. Fail

USSGL 

ACCOUNT 

NUMBER FUND TYPE

=411900 =ES=411900 =ET=412700 =EG=412800 =EG=412900 =EG=417100 =EG=417200 =EP=417300 =EG=417300 =EP

69E

Limited use of specific USSGL and Fund Type combinations

The use of some USSGL and GTAS Fund Type Code combinations is limited to specific Treasury Account Symbols.

ALLOCATION 

TRANSFER 

AGENCY 

IDENTIFIER

AGENCY 

IDENTIFIER

MAIN ACCOUNT 

CODE

Pass (BLANK) 012 5205 Pass (BLANK) 014 5132 Pass (BLANK) 014 5143 Pass (BLANK) 014 5241 Pass (BLANK) 014 5474 Pass (BLANK) 014 5485 Pass (BLANK) 014 5884 Pass (BLANK) 015 8526 Pass (BLANK) 015 8585 Pass (BLANK) 015 8594 Pass (BLANK) 015 8595 Pass (BLANK) 015 8596 Pass (BLANK) 015 8600 Pass (BLANK) 015 8602 Pass (BLANK) 015 8604 Pass (BLANK) 015 8608 

Bulletin No. 2018-04 VII VDR - 29 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass (BLANK) 089 5068 Pass (BLANK) 089 5369 Pass (BLANK) 487 5415 Pass (BLANK) 012 1143 Pass (BLANK) 016 0327 Pass (BLANK) 016 0327 Pass (BLANK) 031 0200 Pass (BLANK) 031 0200 Pass (BLANK) 031 0300 Pass (BLANK) 431 0500 Pass (BLANK) 012 1143 Pass (BLANK) 016 0327 Pass (BLANK) 096 3122 Pass (BLANK) 096 3123 Pass (BLANK) 089 4045 Pass (BLANK) 089 4045 Pass (BLANK) 096 3122 Pass (BLANK) 096 3123 Pass (BLANK) 015 5073 Pass (BLANK) 014 5015 Pass (BLANK) 014 5573 Pass (BLANK) 012 1143 Pass (BLANK) 075 0580 Pass (BLANK) 075 5551 Pass (BLANK) 015 5608 Pass (BLANK) 075 0580 

70

Limited Use of USSGL 415100 with Authority Type Code "P"

The use of USSGL 415100 with Authority Type Code "P" is limited to specific Treasury Account Symbols. Fail

USSGL 

ACCOUNT 

NUMBER

AUTHORITY 

TYPE

=415100 =P

70E

Limited Use of USSGL 415100 with Authority Type Code "P"

The use of USSGL 415100 with Authority Type Code "P" is limited to specific Treasury Account Symbols.

BEA CATEGORY 

INDICATOR

CONCATENATE

D TAS

Pass M 091 X5557000Pass M 014 X5656000Pass M 011 X5512000Pass M

01320122022 

8233000

Pass M

02020152016 

5445000

Bulletin No. 2018-04 VII VDR - 30 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass M

02020162017 

5445000

Pass M 020 X5581000Pass M

02020172018 

5445000

71

Limited use of specific USSGL and Fund Type combinations with Authority Type Code "S"

The use of USSGL 438200 with Fund Types "ES/ET", or USSGL 438400 with Fund Type "ES", and Authority Type Code "S" is limited to specific TAS. Fail

USSGL 

ACCOUNT 

NUMBER

AUTHORITY 

TYPE FUND TYPE

=438200 =S =ES=438200 =S =ET=438400 =S =ES=438400 =S =ET

71E

Limited use of specific USSGL and Fund Type combinations with Authority Type Code "S"

The use of USSGL 438200 with Fund Types "ES/ET", or USSGL 438400 with Fund Type "ES", and Authority Type Code "S" is limited to specific TAS.

CONCATENATE

D TAS

Pass 060 X8051001Pass 069 X5423000Pass 070 X5088000Pass 097 X8164000

72

Limited use of USSGL 412400 with Fund Type "EG".

The use of USSGL 412400 with GTAS Fund Type Code "EG" is limited to specific TAS. Fail

USSGL 

ACCOUNT 

NUMBER FUND TYPE

=412400 =EG

72E

Limited use of USSGL 412400 with Fund Type "EG".

The use of USSGL 412400 with GTAS Fund Type Code "EG" is limited to specific TAS.

AUTHORITY 

DURATION 

CODE TAS STATUS Fund Family

Pass A U 0121143

73

Limited use of USSGLs 415700 and 439700 with Fund Type "EG" and Authority Type Code "P"

The use of USSGLs 415700 and 439700 with Fund Type "EG" and Authority Type Code "P" is limited to specific TAS. Fail

USSGL 

ACCOUNT 

NUMBER

AUTHORITY 

TYPE FUND TYPE

=415700 =P =EG=439700 =P =EG

73E

Limited use of USSGLs 415700 and 439700 with Fund Type "EG" and Authority Type Code "P"

The use of USSGLs 415700 and 439700 with Fund Type "EG" and Authority Type Code "P" is limited to specific TAS.

USSGL 

ACCOUNT 

NUMBER

BEA CATEGORY 

INDICATOR

CONCATENATE

D TAS

Pass 415700 (BLANK) 012 X1002000Pass 415700 (BLANK) 012 X1004000Pass 439700 M 012 X1002000Pass 439700 M 012 X1004000

Bulletin No. 2018-04 VII VDR - 31 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

74

Limited Use of USSGL 439100 with PYA "X" on Expired TAS

The use of USSGL 439100 with PYA "X" on an expired TAS is limited to specific TAS. Fail

USSGL 

ACCOUNT 

NUMBER

PRIOR YEAR 

ADJUSTMENT 

CODE TAS STATUS

=439100 =X =E

74E

Limited Use of USSGL 439100 with PYA "X" on Expired TAS

The use of USSGL 439100 with PYA "X" on an expired TAS is limited to specific TAS.

CONCATENATE

D TAS

Pass

01620102011 0327000

75

Prohibited Use of Exchange Activity with the General Fund of the U.S. Government

The General Fund of the U.S. Government does not engage in exchange activity therefore the Fed/NonFed of "G" can not be used with Exch/Nonexch of "E" or "X" Fail

FEDERAL 

NONFEDERAL 

INDICATOR

EXCHANGE OR 

NONEXCHANGE 

INDICATOR

=G =E=G =X

76 USSGLs Limited to IMF

Some USSGL accounts are restricted to IMF TAS only. Fail

USSGL 

ACCOUNT 

NUMBER

=119090=119305=119306=119307=119309=119333=135090=135990=411990=411991=411992=411993=411994=417590=417690=420190=429590=435190=462090=462091=729090

76E USSGLs Limited to IMF

Some USSGL accounts are restricted to IMF TAS only.

CONCATENATE

D TAS

Pass 011 X0003000

Bulletin No. 2018-04 VII VDR - 32 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass 011 X0004000Pass 011 X0074000Pass

020011 X0003000

Pass

020011 X0074000

77E Financing Account Code

The USSGL account must be valid for the Financing Account Code assigned to the TAS.

USSGL 

ACCOUNT 

NUMBER

CONCATENATE

D TAS

Pass 417000 091 X4300000

78

TFM 2-4700 Appendix 7 Fed-NonFed and Exchange-NonExchange Limitations

Specific combinations of USSGL, Federal NonFederal Code, and Exchange Nonexchange 

Code are not valid. Fail

USSGL 

ACCOUNT 

NUMBER

FEDERAL 

NONFEDERAL 

INDICATOR

EXCHANGE OR 

NONEXCHANGE 

INDICATOR

=590000 =F =T=590900 =F =T=719000 =F =T=721200 =F =T=729000 =F =T

79

Prohibited Use of USSGL 240000 and FedNonFed of "Z" for Deposit Funds

Deposit Funds are not permitted to use the Federal Nonfederal Code of "Z" with USSGL account 240000. Fail

USSGL 

ACCOUNT 

NUMBER

FEDERAL 

NONFEDERAL 

INDICATOR FUND TYPE

=240000 =Z =DF

80 Limited Use of USSGL 579001

The use of USSGL 579001 is limited to specific Treasury TAS. Fail

USSGL 

ACCOUNT 

NUMBER

=579001

80E Limited Use of USSGL 579001

The use of USSGL 579001 is limited to specific Treasury TAS. Fund Family

Pass 0200550Pass 0201875

81 Limited Use of 415900 and 415901

The use of USSGLs 415900 and 415901 is limited to specific TAS. Fail

USSGL 

ACCOUNT 

NUMBER

=415900=415901

81E Limited Use of 415900 and 415901

The use of USSGLs 415900 and 415901 is limited to specific TAS.

CONCATENATE

D TAS

Pass 016 X8042000Pass 075 X8004000

82 Limited Use of USSGL 439701

The use of USSGL 439701 is limited to specific TAS. Fail

USSGL 

ACCOUNT 

NUMBER

Bulletin No. 2018-04 VII VDR - 33 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

=439701

82E Limited Use of USSGL 439701

The use of USSGL 439701 is limited to specific TAS.

CONCATENATE

D TAS

Pass 011 X5512000Pass 011 X8242000

83

Limited Use of 439700 with Authority Type "B" and/or Fund Type "EP"

The use of USSGL 439700 with Authority Type Code "B" and/or Fund Type "EP" is restricted to specific TAS. Fail

USSGL 

ACCOUNT 

NUMBER

AUTHORITY 

TYPE FUND TYPE

=439700 =B =EP=439700 =B <>EP=439700 <>B =EP

83E

Limited Use of 439700 with Authority Type "B" and/or Fund Type "EP"

The use of USSGL 439700 with Authority Type Code "B" and/or Fund Type "EP" is restricted to specific TAS.

AUTHORITY 

TYPE

BEA CATEGORY 

INDICATOR

CONCATENATE

D TAS

Pass B M 012 X4336000

84

Limited Use of USSGL 419000 with Financing Account Code "G"

The use of USSGL account 419000 with Financing Account Code "G" is limited to specific TAS. Fail

USSGL 

ACCOUNT 

NUMBER

FINANCING 

ACCOUNT 

CODE

=419000 =G

84E

Limited Use of USSGL 419000 with Financing Account Code "G"

The use of USSGL account 419000 with Financing Account Code "G" is limited to specific TAS.

CONCATENATE

D TAS

Pass 086 X4240000

85 Limited Use of USSGL 292000 on a C-TAS

The use of USSGL account 292000 on a C-TAS is restricted to the Department of Defense. Fail

USSGL 

ACCOUNT 

NUMBER TAS STATUS

=292000 =C

85E Limited Use of USSGL 292000 on a C-TAS

The use of USSGL account 292000 on a C-TAS is restricted to the Department of Defense.

AGENCY 

IDENTIFIER

Pass 017Pass 021Pass 057Pass 096Pass 097

88 Limited Use of USSGL 151600

The use USSGL account 151600 is restricted to DoD TAS. Fail

USSGL 

ACCOUNT 

NUMBER

=151600

88E Limited Use of USSGL 151600

The use USSGL account 151600 is restricted to DoD TAS.

AGENCY 

IDENTIFIER

Pass 017

Bulletin No. 2018-04 VII VDR - 34 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass 021Pass 057Pass 096Pass 097

89 Limited Use of USSGL 153200

The use of USSGL account 153200 is limited to specific TAS. Fail

USSGL 

ACCOUNT 

NUMBER

=153200

89E Limited Use of USSGL 153200

The use of USSGL account 153200 is limited to specific TAS.

CONCATENATE

D TAS

Pass 015 X6874000Pass 020 X6511006Pass 070 X6511004

90

Disaster Emergency Fund Code Domain Value Restrictions

The use of DEF Code domain values other than "Q" is limited to specific fund families. Fail

PROGRAM 

COST 

INDICATOR

=A

=B=C=D=E=F=G=H

90E

Disaster Emergency Fund Code Domain Value Restrictions

The use of DEF Code domain values other than "Q" is limited to specific fund families.

PROGRAM 

COST 

INDICATOR Fund Family

Pass A 0360110

Pass A 0700702Pass A 0700719Pass A 0730100Pass A 0731152Pass A 0860162Pass A 0860338Pass B 0100920Pass B 0100932Pass B 0121115Pass B 0121120Pass B 0123505Pass B 0141119Pass B 0141120

Bulletin No. 2018-04 VII VDR - 35 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass B 0141125Pass B 0700200Pass B 0700702Pass B 0700703Pass B 0700719Pass C 0050107Pass C 0120019Pass C 0120115Pass C 0120120Pass C 0120121Pass C 0120122Pass C 0120124Pass C 0120125Pass C 0120126Pass C 0120127Pass C 0120128Pass C 0120129Pass C 0120130Pass C 0120131Pass C 0120132Pass C 0120150Pass C 0120601Pass C 0120803Pass C 0120900Pass C 0121103Pass C 0121105Pass C 0121106Pass C 0121401Pass C 0121980Pass C 0122081Pass C 0123316Pass C 0123507Pass C 0123510Pass C 0123701Pass C 0130110Pass C 0130125Pass C 0130126Pass C 0131450Pass C 0131460Pass C 0132050

Bulletin No. 2018-04 VII VDR - 36 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass C 0132055Pass C 0140104Pass C 0140412Pass C 0140804Pass C 0141612Pass C 0145055Pass C 0145140Pass C 0145477Pass C 0150200Pass C 0150324Pass C 0151003Pass C 0151060Pass C 0151100Pass C 0160174Pass C 0160181Pass C 0160182Pass C 0160184Pass C 0171106Pass C 0171804Pass C 0171806Pass C 0171205Pass C 0171206Pass C 0171810Pass C 0200501Pass C 0212020Pass C 0212065Pass C 0212080Pass C 0212085Pass C 0212094Pass C 0360111Pass C 0360152Pass C 0360160Pass C 0360162Pass C 0490100Pass C 0573400Pass C 0573740Pass C 0474542Pass C 0680103Pass C 0688145Pass C 0688153

Bulletin No. 2018-04 VII VDR - 37 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass C 0690500Pass C 0690550Pass C 0691140Pass C 0691301Pass C 0691303Pass C 0691750Pass C 0698107Pass C 0700200Pass C 0700503Pass C 0700504Pass C 0700508Pass C 0700509Pass C 0700414Pass C 0700510Pass C 0700530Pass C 0700532Pass C 0700540Pass C 0700541Pass C 0700545Pass C 0700550Pass C 0700610Pass C 0700611Pass C 0700613Pass C 0700700Pass C 0700702Pass C 0700703Pass C 0705087Pass C 0705089Pass C 0705126Pass C 0705378Pass C 0705382Pass C 0705390Pass C 0705451Pass C 0705542Pass C 0705545Pass C 0705694Pass C 0705695Pass C 0708529Pass C 0708598Pass C 0730100

Bulletin No. 2018-04 VII VDR - 38 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass C 0730200Pass C 0730201Pass C 0731152Pass C 0750124Pass C 0750128Pass C 0750140Pass C 0750330Pass C 0750350Pass C 0750352Pass C 0750353Pass C 0750600Pass C 0750603Pass C 0750807Pass C 0750819Pass C 0750838Pass C 0750843Pass C 0750844Pass C 0750846Pass C 0750849Pass C 0750851Pass C 0750862Pass C 0750872Pass C 0750873Pass C 0750875Pass C 0750884Pass C 0750885Pass C 0750886Pass C 0750887Pass C 0750888Pass C 0750889Pass C 0750890Pass C 0750891Pass C 0750892Pass C 0750893Pass C 0750894Pass C 0750896Pass C 0750898Pass C 0750943Pass C 0750947Pass C 0750948

Bulletin No. 2018-04 VII VDR - 39 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

Pass C 0750949Pass C 0750950Pass C 0750951Pass C 0750952Pass C 0750953Pass C 0750954Pass C 0750955Pass C 0750956Pass C 0750958Pass C 0750959Pass C 0750960Pass C 0751362Pass C 0751363Pass C 0751364Pass C 0751365Pass C 0751536Pass C 0753966Pass C 0800130Pass C 0860162Pass C 0860189Pass C 0860190Pass C 0890218Pass C 0890318Pass C 0910013Pass C 0910241Pass C 0911901Pass C 0963112Pass C 0963121Pass C 0963122Pass C 0963123Pass C 0963124Pass C 0963125Pass C 0970100Pass C 0970130Pass C 0974930

91 Main Account 3601 USSGL Restrictions

TAS with Main Account 3601 are only permitted to report specific USSGL accounts. Pass

MAIN ACCOUNT 

CODE

USSGL 

ACCOUNT 

NUMBER

<>3601 =132500<>3601 <>132500

Bulletin No. 2018-04 VII VDR - 40 
Part 2

SUPPLEMENT

No Name Description Rule Attribute Combination

U.S. Standard General Ledger

Data Validations - Detail

<>3601 =132900<>3601 <>132900<>3601 =298000<>3601 <>298000<>3601 =582000<>3601 <>582000<>3601 =583000<>3601 <>583000<>3601 =590000<>3601 <>590000<>3601 =599100<>3601 <>599100<>3601 =599800<>3601 <>599800=3601 =132500=3601 =132900=3601 =298000=3601 =582000=3601 =583000=3601 =590000=3601 =599100=3601 =599800

91E Main Account 3601 USSGL Restrictions

TAS with Main Account 3601 are only permitted to report specific USSGL accounts.

USSGL 

ACCOUNT 

NUMBER

DOLLAR 

AMOUNT

Pass 101000 0

Bulletin No. 2018-04 VII VDR - 41