CAFP EDIT ERROR MESSAGE SUMMARY

This information is intended to provide explanations of the error messages received on the monthly CAFP edit reports. Please refer to the Corporate Account Fund Profile: Campus Input Specifications, for further information.

General Edit Errors:

Record Type

Fund Record Errors:

Award

 

UC Loc Code 1

 

Budgeted Fund Code

 

UC Loc Code 2

 

CFDA

 

 

 

Endowment Restriction

Account Record Errors:

Account Name

 

Flow Through Code

 

Account Group Code

 

Fund Group

 

Account Number

 

Fund Name

 

Annual Report Code

 

Fund Number

 

NSF Code

 

Fund Restriction Code

 

Organizational Codes

 

Indirect Cost Base/Rate

 

Systemwide Administrative Unit (SAU)

 

Method of Payment Code

 

UAS Code

 

On/Off Campus Code

 

UAS Academic Discipline

 

Sponsor Category

 

UC Loc Code 3

 

Sponsor Code

 

Error Message

Msg #

Severity Level

Logic/Comments

 

 

 

 


General Errors

 

 

 

Blank record type

2

2

Record type must be A (account records) or F (fund records)

Invalid record type

3

2

Record type must be A (account records) or F (fund records)

Blank UC Loc Code 1

4

2

Table lookup - refer to list of valid values

Invalid UC Loc Code 1

5

2

Table lookup - refer to list of valid values

Blank UC Loc Code 2

6

2

Value must be 1 (indicating local activity) or 2 (indicating universitywide activity)

Invalid UC Loc Code 2

7

2

Value must be 1 (indicating local activity) or 2 (indicating universitywide activity)

 

 

 

 

Account Record Errors

 

 

 

UC Loc Code 3

 

 

 

Blank UC Loc Code 3

8

3

Value must be 1 (general campus) or 2 (health sciences)

Invalid UC Loc Code 3

9

3

Value must be 1 (general campus) or 2 (health sciences)

SAU

 

 

 

SAU must be valid number

10

2

If UC Loc Code 2 is 2 and account type is 3 (Expenditure), SAU is required. Refer to list of valid values.

SAU must be blank

11

2

If UC Loc Code 2 is not 2, SAU field should be blank.

Account Number

 

 

 

Blank accnt number

12

2

Required field.

Non-numeric accnt number

13

2

Account number must be six digits for balance sheet and revenue accounts. For expenditure accounts alphanumeric values are allowed.

Duplicate accnt number

14

4-Fatal

Each account record must be unique. Campuses will need to resubmit the file if this error is encountered.

Non-blank accnt num fill

15

2

The 12th digit of the account record entry must be blank. Refer to the Account Record Layout.

Blank accnt name

16

2

Account name must not be blank.

Acct group 999999 assigned

17

3

Account group code required. Cannot be blank or spaces. Refer to valid values in Appendix E: Accounts of the CAFP input specifications. Edit program assigns value 999999.

Annual Report Code

 

 

 

Blank annual report code

18

2

Annual report code required for account groups within the 300010 to 300140 range (Current Expenditures).

Invalid annual report code

19

2

Annual report code valid values are from the range 100000 to 999999.

Non-blank annual rpt code

20

1

If account group is not within the 300010 to 300140 range (Current Expenditures), the annual report code field should be blank.

UAS Code

 

 

 

Blank UAS code

21

2

UAS code required for accounts in account group codes 300010 - 300151, 300159, 300160

Invalid UAS code

22

2

Table lookup. Refer to list of valid values.

Non-blank UAS code

24

1

UAS code should be blank for accounts with account group codes less than 300010 or greater than 300159, or if account group code is 300155 or 300156.

UAS Academic Discipline

 

 

 

Non-blank UAS acad dscpln

23

1

UAS academic discipline code required for UAS code values 400100, 440100, or 440500 only. All other values for UAS code should have a blank UAS academic discipline code.

Blank UAS acad dscpln

25

2

UAS academic discipline code required for UAS code values 400100, 440100, or 440500.

Invalid UAS acad dscpln

26

2

Table lookup. Refer to list of valid values.

Invalid NSF code

27

2

Table lookup. Refer to list of valid values.

Organizational Codes

 

 

 

Blank org level one

28

2

Required for all expenditure accounts (300010 - 300159 account group range).

Blank org name one

29

2

Required for all expenditure accounts (300010 - 300159 account group range).

Blank org level two

30

2

Required for all expenditure accounts (300010 - 300159 account group range).

Blank org name two

31

2

Required for all expenditure accounts (300010 - 300159 account group range).

Blank org level three

32

2

Required for all expenditure accounts (300010 - 300159 account group range).

Blank org name three

33

2

Required for all expenditure accounts (300010 - 300159 account group range).

 

 

 

 

Fund Record Errors

 

 

 

Fund Number

 

 

 

Blank fund number

34

2

Required field.

Fund chars(s) not uppercas

82

4-Fatal

Fund number may not contain lowercase characters.

Fund Nbr not num or upper

83

4-Fatal

Fund number must contain digits or alphabetic uppercase characters.

Duplicate fund number

36

4-Fatal

Each fund number must be unique. Campuses will need to resubmit the file if this error is encountered.

Blank fund name

37

2

Fund name must not be blank.

Fund Group

 

 

 

Fund group 999999 assigned

38

3

Fund group code required. Cannot be blank or spaces. Refer to valid values in Appendix E: Funds of the CAFP input specifications. Edit program assigns value 999999.

Invalid fund group code (this message currently disabled)

75

2

Refer to Appendix E: Funds of the CAFP input specifications for a list of valid fund group codes.

Budgeted Fund Code

 

 

 

Blank budgtd fund code

39

2

Required field.

Invalid budgtd fund code

40

2

Budgeted fund code must be B (budgeted) or N (non-budgeted).

Fund Restriction Code

 

 

 

Blank fund restrctn code

42

2

Fund restriction code required for certain fund groups. Refer to Appendix C of the CAFP input specifications.

Invalid fund restrctn

43

2

Valid values of the fund restriction code are U, R, and G.

Inapprop fund restrctn

44

2

Fund restriction codes are checked against valid value for the fund group. Refer to Appendix C of the CAFP input specifications for valid values. If in the endowment fund group, (301000, 302000, 303000, 304000, 407100, 407210, 407220, 407230 and 407300), the value is checked against the first two digits of the endowment restriction code. Table of valid combinations is here.

Endowment Restriction Code

 

 

 

Non-blank endwmnt restrct

41

1

Endowment restriction code required for funds assigned to the (301000, 302000, 303000, 304000, 407100, 407210, 407220, 407230 and 407300) endowment fund group codes only. Refer to Appendix C of the CAFP input specifications.

Blank endwmnt restrctn

45

2

Endowment restriction code required for funds assigned to the (301000, 302000, 303000, 304000, 407100, 407210, 407220, 407230 and 407300) endowment fund group fund group codes. Refer to Appendix C of the fund group codes. Note that an "X" in the Endowment Restriction Code Appendix C table cell applies to all of the Fund Group Codes listed in the cell.

Invalid endwmnt restrctn

46

2

The 1st and 2nd digits of the endowment restriction code, specific restriction, must be in this table. The 3rd and 4th digits, specifying the purpose, must be numeric. The 5th digit, specifying campus location, must not be blank.

Method of Payment

 

 

 

Blank method of payment

47

2

Required for funds in the 406xxx Current Funds: Federal fund group range.

Invalid method of payment

48

2

Refer to list of valid values.

Non-blank method of payment

49

1

Required for funds in the 406xxx fund group range only.

Sponsor Code

 

 

 

Invalid sponsor code

50

2

Validation is performed against sponsor code table from CGX.

Non-blank sponsor code

51

1

Should be blank for fund groups 401000, 404110, 404120, 404220, 405220, 406220, 406320, 408430, 407100. Refer to Appendix C of the CAFP input specifications.

Blank sponsor code

52

2

Required for fund groups 100200, 404210, 405210, 406210, 406230, 406310, 406340, 408300, 408410 and 408420. Refer to Appendix C of the CAFP input specifications.

Spon code not fed code

54

2

For fund groups 100200, 406210 and 406310, sponsor code must be associated with a federal entity. Validation is performed against sponsor code table from CGX.

Spon code not state code

55

2

For fund groups 404210, (fund not = 18999) and 406310 (fund not = 28999), sponsor code must be associated with a state entity. Validation is performed against sponsor code table from CGX.

Sponsor Category

 

 

 

Category should be blank

56

2

Should be blank for fund groups 401000, 404110, 404120, 404220, 405220, 406220, 406320, 408430, 407100, and for funds 18999, 20999, 24999, 28999 and 59999. Refer to Appendix C of the CAFP input specifications.

Blank sponsor category

57

2

Required for fund groups 100100, 102000, 100600, 404210, 405210, 406210, 406310, 408100, as well as for fund groups 408200, 408300, 408400 and 408430 where fund not = 59999. Refer to Appendix C of the CAFP input specifications.

Invalid sponsor category

58

2

Valid values are 03-10, 12 & 13. Refer to Appendix C of the CAFP input specifications for appropriate values for each fund group.

Spon cat not = cgx code

59

2

Value is compared to that provided in the CGX table.

Award Code

 

 

 

Award should be blank

60

2

Award code should be blank for fund groups 401000 and 407100.

Blank award code

61

2

Required for fund groups 100100, 102000, 100600, 404210, 405210, 406210, 406310, 408100, 408200, 408300, 408410 and 408420. Refer to Appendix C of the CAFP input specifications for appropriate values for each fund group.

Invalid award code

62

2

Valid values for award code are 1,2,3, and 4. Refer to Appendix C of the CAFP input specifications for appropriate values for each fund group.

Invalid type of awd code

63

2

Reported if value is not blank,1,2,3,or 4.

Invalid on/off camp code

64

2

Reported if value is not blank,1,or 2.

Flow Through Code

 

 

 

Invalid flow thru cd

65

2

Valid values for flow thru cd code are blank,1,2,3,4,5,6 or 7. Refer to Appendix C of the CAFP input specifications for appropriate values for each fund group.

Blank flow thru cd

66

2

Required for certain fund groups. Refer to Appendix C of the CAFP input specifications for appropriate values for each fund group.

Indirect Cost Base/Rate

 

 

 

Ind cost base is blank

67

2

Required for certain fund groups. Refer to Appendix C of the CAFP input specifications for appropriate values for each fund group.

Ind cost base is not valid

68

2

Value is compared to that in this table.

Ind cost base not blank

72

2

For funds where the indirect cost base is not required, the value should be G or blank. Refer to Appendix C of the CAFP input specifications for fund groups requiring indirect cost base code.

Ind cost rate is blank

70

2

Required for certain fund groups. Refer to Appendix C of the CAFP input specifications for fund groups requiring indirect cost rate.

Ind cost rate is not numeric

71

2

For funds where the indirect cost rate is required, the value must be numeric.

Ind cost rate not blank

74

2

For funds where the indirect cost rate is not required, the value should be blank or 0000.

CFDA must be blank

73

2

CFDA codes are required for all federal grants and funds with flow-through codes 2, 3, 6 or 7 established after 6/30/95. Refer to Appendix C of the CAFP input specifications for fund groups requiring CFDA codes.

CFDA begins with a zero

80

2

The CFDA code must begin with a digit greater than zero.

CFDA not numerics

81

2

The CFDA code must be numeric.

back to top


updated January 26, 2012