Field Name Type Use Definition Business Rule SERVICE_CODE VARCHA2(2) Mandatory Service and Agency Code. the service • Per MILSTRIP Appendix 2.2, Designates the military service and agency (S/A) code is a one or two or other government element of character alphanumeric. ownership or sponsorship. The code is used to identify the service or agency monitoring the fund code. SIGNAL_CODE VARCHAR2(1) Mandatory Allowed values are A, B, C, J, K and L Signal Code. A code Refer to MILSTRIP Appendix 2.10 for an designation identifying explanation of signal code. the intended consignee and activity to receive and effect bill payment. FUND_CODE VARCHAR2(2) Mandatory Must be unique per SERVICE_CODE and • Fund Code. Designation of SIGNAL_CODE. the fund account to be A fund code of ** is an indicator of the • charged (disbursed) or default account. One per S/A + Signal code. credited (refunded). When *When used with Signal Code C or L an used with Signal Code C entry is required on the Fund Code to Billed or L also designates the Office DoDAAC Table. Billed Office DoDAAC. APPROPRIATION VARCHAR2(11) Constructed/ Constructed from: Last 2 characters of • Appropriation/Fund *Conditional DEPARTMENT_REGULAR_CODE + Account. Constructed line FISCAL_YEAR_INDICATOR + of accounting MAIN_ACCOUNT_CODE + APPROPRIATION_LIMIT_SUBHEAD. (NOTE that DEPTARTMENT_REGULAR_Code is actually 3 characters, but the leading zero is concatenated for purposes of this element.) Blank appropriation data displays as • NONINTERFUND on reports AGENCY_NARR VARCHAR2(20) Optional Agency Narrative. Name or Web Application input is limited to 5.This is to common acronym for further conform to report format limitations. agency delineation from the Service code. Generally, a breakdown for H-series fund code assignments.
Field Name Type Use Definition Business Rule SERVICE_CODE VARCHA2(2) Mandatory Service and Agency Code. Designates the military service or other government element of ownership or sponsorship. The code is used to identify the service or agency monitoring the fund code. • Per MILSTRIP Appendix 2.2, the service and agency (S/A) code is a one or two character alphanumeric. SIGNAL_CODE VARCHAR2(1) Mandatory Signal Code. A code designation identifying the intended consignee and activity to receive and effect bill payment. Allowed values are A, B, C, J, K and L Refer to MILSTRIP Appendix 2.10 for an explanation of signal code. FUND_CODE VARCHAR2(2) Mandatory Fund Code. Designation of the fund account to be charged (disbursed) or credited (refunded). When used with Signal Code C or L also designates the Billed Office DoDAAC. • Must be unique per SERVICE_CODE and SIGNAL_CODE. • A fund code of ** is an indicator of the default account. One per S/A + Signal code. *When used with Signal Code C or L an entry is required on the Fund Code to Billed Office DoDAAC Table. APPROPRIATION VARCHAR2(11) Constructed/ *Conditional Appropriation/Fund Account. Constructed line of accounting • Constructed from: Last 2 characters of DEPARTMENT_REGULAR_CODE + FISCAL_YEAR_INDICATOR + MAIN_ACCOUNT_CODE + APPROPRIATION_LIMIT_SUBHEAD. (NOTE that DEPTARTMENT_REGULAR_Code is actually 3 characters, but the leading zero is concatenated for purposes of this element.) • Blank appropriation data displays as NONINTERFUND on reports AGENCY_NARR VARCHAR2(20) Optional Agency Narrative. Name or common acronym for further agency delineation from the Service code. Generally, a breakdown for H-series fund code assignments. Web Application input is limited to 5.This is to conform to report format limitations.
FundCodeMasterFileLayout.docx