Data Element / Size / Description / Type
of Field /
Reportable Level
/ 2 / With STARS Department no. will identify the agency as known in STARS structure of accounts. If created for a proprietary fund or similar trust enter the fund number, otherwise leave blank. / Text, CharDepartment / 3 / Required. Enter the STARS department number this asset was reported under. / Text, Char
Fixed Asset Number Prefix / 2 / Required. A 2 character prefix that identifies the Fixed Asset category within an agency, cabinet, or department. / Text, Char
Fixed Asset Number / 13 / Required. With Type and FA # Prefix, forms the unique identifier of the fixed asset. For vehicles, assign a tag # other than the plate #. Plate # will be a internal tracking #. Tracking #s are recorded in 6th descriptive field. / Text, Char
Fixed Asset Type / 1 / Required. Enter a valid type for this fixed asset. Valid values are E for equipment, and V for vehicles. / Text, Char
Fixed Betterment / 2 / Required. Enter a number between 01 and 99. This number, along with fixed asset number and type uniquely identify each betterment. Note: Always enter a two-digit number; for example, 01,02,03. / Text, Char
Units / 8 / Default is 1 . This field allows you to capitalize several identical fixed assets acquired at the same time in one entry. Enter the number of fixed assets recorded in this transaction / Text, Char
Description / 30 / Required. Enter a description of the fixed asset. / Text, Char
Vendor Code / 11 / Optional. Enter the vendor from whom the fixed asset was purchased. See Vendor Index (VEND) for valid values. / Text, Char
Vendor Name / 30 / Default is inferred from Vendor Inquiry (VEN2). Optional when miscellaneous vendor code is used. / Text, Char
Acquisition Year / 2 / Required. Enter the date ( yy mm dd ) when the fixed asset was acquired. For depreciable assets, this is the date the depreciation process recognizes as the first day of the asset's useful life. / Text, Char
Acquisition Month / 2 / Required. Enter the date ( yy mm dd ) when the fixed asset was acquired. For depreciable assets, this is the date the depreciation process recognizes as the first day of the asset's useful life. / Text, Char
Acquisition Day / 2 / Required. Enter the date ( yy mm dd ) when the fixed asset was acquired. For depreciable assets, this is the date the depreciation process recognizes as the first day of the asset's useful life. / Text, Char
Acquisition Method / 1 / Required. See Acquisition/Disposition (FADM) for valid values. / Text, Char
Serial Number / 22 / Conditional. Optional, if Type is E (equipment) or V (vehicle). Enter the serial number. Leave this field blank for all other types of fixed assets. / Text, Char
Manufacturer / 20 / Conditional. Optional, if Type is E (equipment) or V (vehicle). Enter the manufacturer. Leave this field blank for all other types of fixed assets. / Text, Char
Model Number / 15 / Conditional. Optional, if Type is E (equipment) or V (vehicle). Enter the model number. Leave this field blank for all other types of fixed assets. / Text, Char
Purchase Authority / 13 / Required. Enter the purchase order number used to purchase the fixed asset / Text, Char
In Service Year / 2 / Optional. Enter the date (yy mm dd ) that the fixed asset was entered into service. / Text, Char
In Service Month / 2 / Optional. Enter the date (yy mm dd ) that the fixed asset was entered into service. / Text, Char
In Service Day / 2 / Optional. Enter the date (yy mm dd ) that the fixed asset was entered into service. / Text, Char
Closing Costs / 14 / Optional. Enter any closing costs associated to the betterment. For example, enter: 00000002837.00 / NUM
Salvage Value / 14 / Optional. Enter the salvage value of the asset. This number is used by the depreciation process. For example, enter: 00000002837.00 / NUM
Total Betterment Cost / 14 / Required. Enter the cost of the betterment(s). For example, enter: 00000002837.00 / NUM
Cost Type / 1 / Required. Valid values are A (actual cost from invoice), E (estimated cost from invoice), F (calculated recognized formula), H (historical), and I (index appraisal to acquisition date). / Text, Char
Commodity Code / 14 / Optional. Enter the commodity code for these assets. See the NIGP Commodity Code Table (COMM) for valid values. / Text, Char
Ins Policy Type / 2 / Required. Enter the insurance policy type for fixed assets. See the Insurance Type Table (ITYP) for valid values. / Text, Char
Agency / 3 / Required. Enter the MARS agency that is responsible for the fixed asset. Fixed assets will be generated at this level. See Agency Table (AGCY) for valid values. / Text, Char
Organization / 4 / Required. Enter the MARS organization number associated to the fixed asset. See Organization Table (ORG2) for valid values. / Text, Char
Program Budget Unit / 4 / Required. Enter the MARS Program Budget Unit for this asset. See the PRFT Table for valid values. The appropriation program element and Allotment program will be inferred form PRFT based on the Program. / Text, Char
Activity / 4 / Optional. Enter the activity that is primarily associated with the fixed asset. See Activity Index (ACTV) for valid values / Text, Char
Warranty Type / 30 / Optional. Enter the type of warranty obtained when the asset was acquired. / Text, Char
Duration Days / 4 / Optional. Enter the duration days of the warranty. / Text, Char
Agreement Number / 11 / Optional. Enter the maintenance number. / Text, Char
Effective Year / 2 / Optional. Enter the date (yy mm dd) the agreement is effective. / Text, Char
Effective Month / 2 / Optional. Enter the date (yy mm dd) the agreement is effective. / Text, Char
Effective Day / 2 / Optional. Enter the date (yy mm dd) the agreement is effective. / Text, Char
Expiration Year / 2 / Optional. Enter the date (yy mm dd) the agreement expires. / Text, Char
Expiration Month / 2 / Optional. Enter the date (yy mm dd) the agreement expires. / Text, Char
Expiration Day / 2 / Optional. Enter the date (yy mm dd) the agreement expires. / Text, Char
Desc Field 1 / 12 / Optional. Enter descriptive text in the five description fields / Text, Char
Desc Field 2 / 12 / Optional. Enter descriptive text in the five description fields / Text, Char
Desc Field 3 / 12 / Optional. Enter descriptive text in the five description fields / Text, Char
Desc Field 4 / 12 / Optional. Enter descriptive text in the five description fields / Text, Char
Desc Field 5 / 12 / Optional. Enter descriptive text in the five description fields / Text, Char
Desc Field 6 / 12 / Optional. Enter descriptive text in the five description fields / Text, Char
Fund1 / 4 / Required. Conditional. Required by Central Finance for assets with a cost of $5000 or more. Some agencies require for any asset. Enter the STARS fund number that paid for the asset. Up to four funds may be used. / Text, Char
Asset Percentage FS1 / 3 / Required. Conditional. Must be entered when fund source as entered. Enter the percent this funding source contributed to the purchase of this asset. Up to 4 fund sources when multiple funds are used. For example, enter: 050 for 50% / NUM
Job Number1 / 8 / Optional. Enter the grant number or project number associated with the asset. Must be a valid value on MARS AGPR table or SPDT table. / Text, Char
Fund2 / 4 / Conditional. Required by Central Finance for assets with a cost of $5000 or more. Some agencies require for any asset. Enter the STARS fund number that paid for the asset. Up to four funds may be used. / Text, Char
Asset Percentage FS2 / 3 / Conditional. Must be entered when fund source as entered. Enter the percent this funding source contributed to the purchase of this asset. Up to 4 fund sources when multiple funds are used. For example, enter: 050 for 50% / NUM
Job Number2 / 8 / Optional. Enter the grant number or project number associated with the asset. Must be a valid value on MARS AGPR table or SPDT table. / Text, Char
Fund3 / 4 / Conditional. Required by Central Finance for assets with a cost of $5000 or more. Some agencies require for any asset. Enter the STARS fund number that paid for the asset. Up to four funds may be used. / Text, Char
Asset Percentage FS3 / 3 / Conditional. Must be entered when fund source as entered. Enter the percent this funding source contributed to the purchase of this asset. Up to 4 fund sources when multiple funds are used. For example, enter: 050 for 50% / NUM
Job Number3 / 8 / Optional. Enter the grant number or project number associated with the asset. Must be a valid value on MARS AGPR table or SPDT table. / Text, Char
Fund4 / 4 / Conditional. Required by Central Finance for assets with a cost of $5000 or more. Some agencies require for any asset. Enter the STARS fund number that paid for the asset. Up to four funds may be used. / Text, Char
Asset Percentage FS4 / 3 / Conditional. Must be entered when fund source as entered. Enter the percent this funding source contributed to the purchase of this asset. Up to 4 fund sources when multiple funds are used. For example, enter: 050 for 50% / NUM
Job Number4 / 8 / Optional. Enter the grant number or project number associated with the asset. Must be a valid value on MARS AGPR table or SPDT table. / Text, Char
3