View the Transaction Code Decision Table
The TRANSACTION CODE DECISION TABLE MAINTENANCE/INQUIRY
screen S031 shows transaction codes,
their respective data field/elements and whether they are required, optional,
or not allowed, and how transactions will be posted to the STARS financial
files. The State Controller's Office (SCO) maintains the Transaction Code Decision Table.
This information is available in the DAFR4640 Transaction Code Decision Table Report on Online Reporting.
On Transaction Code Decision Table S031
1. On the FAS Main Menu, enter 31 and then press ENTER.2. On the S031 screen, type R in the FUNCTION field.
3. Type the transaction code (e.g., AP1) in the FAS TC field. 3. Press ENTER.
Figure 1 - FAS Transaction Code Decision Table example
VERSION 3.1 FAS - TRANSACTION CODE DECISION TABLE
FUNCTION: R (A=ADD,
C=CHANGE, D=DELETE, N=NEXT, R=RECALL)
FAS TC AP1 TITLE: RECORD THE PURCHASE OF LAND - FAS
LOCAT1 R PRP NO R CMP NO R QUANTY R QTY UN R CLS CD R
CAPIND R CON CD R U LIFE R FUND R FDTL
ACQMTH R ST MTH R
ADT DT R DEPRDT N ADTAMT R ST DPR N AGYDPR N REP VL R
RESPNM RMBILL R CDOC R DISPMD N DISP % N OWNER R INSERV R
SAL VL N STATUS R LOCAT2
TRANTP 1 BUDU R FNMTCH
RCMTCH N APPLVL 3
GEN-GVT TC: 8GD GEN-PRO TC: 8FD GVTFND: 0700 GOV GL: 1701
PROP GL 1701
FILE A/S FIELD A/S FIELD
ACQ/DISP: + 01
STWD ACCUM DEPR:
AGY ACCM DEPR:
REPLACEMENT VAL: + 08
The following table describes the data elements and
identifies the transaction types for which they are required, optional, etc.
The FAS transaction code
Descriptive title of the transaction code
Below the FAS TC and
TITLE are several data elements. Each will have an indicator signifying if the
data element is required, optional, etc. The indicators are:
Agency Suffix is an informational field that may be used
by the agencies for indexing assets.
Location 1 is used by agencies to record where an asset
is located and to report to Risk Management for insurance purposes
Property Number is an identifier for each asset
Component Number uniquely identifies the Property Number
Quantity is an information field typically used with real
property to define the number of units, such as how many acres, square feet,
Quantity Unit is an information field used to define the
unit of measurement (i.e. ACRE, SQFT, etc.).
Class Code is used to categorize the asset and determine
which general ledger asset account should be impacted by transactions against
Class Suffix is used by the agency to give more detail to
the class codes.
Insurance Indicator is used by to identify how an asset
is to be insured and to describe the type of coverage.
Capital Indicator indicates if an asset is to be
Condition Code is an information field used by agencies
to record the general condition of the asset.
Useful Life is a field used to calculate depreciation. It
is usually looked up from the Class Code Descriptor (FD02) table.
The Fund indicator is used with interfaces to STARS and ACFR reporting.
Fund Detail uniquely identifies the Fund and is used with
interfaces to STARS.
Acquisition Method is used to record the original method
used to acquire the asset.
State Depreciation Method is a field used to determine
the depreciation method used for the calculated statewide depreciation.
Agency Depreciation Method is a field used by an agency
to book depreciation using a different depreciation method than the method
used for statewide depreciation.
The Acquisition, Disposition, Transaction
Date indicator is a field necessary for any transaction impacting the History
Depreciation Date is a field used to indicate the
transaction date of a depreciation expense and to populate the last
depreciation date on the Property File.
The ADT Amount field is used for the Acquisition, Disposition,
and Transaction Amount. It is required on most financial transactions
other than depreciation.
The State Depreciation Amount is used for Statewide
Depreciation. Typically, depreciation transactions will be system-generated.
The Agency Depreciation amount is used for the Agency
Depreciation Method. Agencies have the option to use a different depreciation
method, or capitalization threshold, thereby having different depreciation
amounts. Typically, depreciation transactions will be system-generated.
Replacement Value is the field used to record the cost to
replace the asset. This value is used for insurance purposes.
Reference Property Number contains the Property Number
entered in STARS and passed to the FAS Hold File. It is typically required
for all transactions processed through STARS and all system-generated
transactions. It is automatically added as the same number as the Property
Number when entering transactions directly into FAS
Reference Component Number contains the component number
that was entered in STARS and passed to the FAS Hold File.
Responsible Last Name is that is recommended to track
Risk Management Bill code is required for data download
to Risk Management. Agencies can accept the default of 1000, or they may choose
to set up cost center codes for the insurance billing process.
Current Document Number represents the current document
number used on the original purchase transaction in STARS. Agencies can use
the field to correlate a property record to the original STARS transaction.
Disposition Method is used to record the method used to
dispose of an asset. The table entries should tie to the Board of Examiners
Asset Disposal Form disposition options.
Disposition Percentage is a field used to record the
percentage of an asset being disposed. During data entry, if less than 100%
is entered in the field, it is a partial disposition and transactions are
generated to remove partial depreciation and potentially gains and losses.
The Ownership indicator is to record the ownership of the
asset. The ownership information is needed for statewide reporting, federal
property inventory reports, etc.
In-Service Date is a field used to record the date the
asset was placed in service, which is used for reporting and depreciation
Salvage Value is a field used when calculating
Status Code is a field used to specify if the asset is
“in use”, “idle”, “stored”, or “disposed”.
Location 2 is an information field used by agencies to
identify the physical location of an asset.
Generated Transactions codes are those generated automatically by a transaction. This table shows the generated
transaction codes (if any), and the related/affected funds and general ledgers.
The Register Number identifies transactions types
(Acquisitions, Dispositions, Adjustments, etc.). It is also used to determine
which subobject will be used for a STARS interface transaction. (Register 8,
non-financial transactions, does not create STARS interface transactions.)
Register 1 - Acquisition (from STARS)
Register 2 - Acquisition (from FAS)
Register 3 - Replacement Revaluation
Register 4 - Gain / Loss / Depreciation Removal
Register 5 - Disposition
Register 6 - Depreciation
Register 7 - Adjustment to Original Amount (230R)
Register 8 - Non-Financial Change
Register A - Current Year Asset Removal
Register B - Prior Year Asset Removal
Register C – Add a
property previously Removed
Transaction Type – The transaction type identifies
the origin of the transaction.
Type “0” indicates that the transaction originated in
STARS – the transaction must be processed through the S033 screen.
Type “1” indicates the transaction originated in FAS –
the transaction must be processed through the S035 screen.
Budget Unit – Edit Indicator for the Funding
Source Screen Budget Unit Field.
Fund Match – Edit Indicator for Fund Match. If the
transaction requires that the FAS Hold File Fund Source matches the FAS
Property File Fund Source then this indicator will be a ‘M’.
Record Match – Processing edit indicator for
matching records to the FAS Property File.
If this field is ‘M’, then the Property Number and Component Number
used on the transaction must exist on the FAS Property File. This is required
for transactions such as dispositions, because you cannot dispose of a
property that is not on the system.
Approval Level – Indicates the required release
approval level for posting the transaction.
Generally Non-financial changes (Replacement Revaluation)
transaction codes have an approval level of 2.
Acquisition transaction codes have an approval level of
3. Dispositions have an approval level of 4.
Inactivate Adjustments (correction to a record)
transaction codes have an approval level of 7.
System Generated transactions codes have an approval
level of 8.
Generated Governmental Transaction Code – The
STARS Transaction code generated for transactions with a governmental funding
Generated Proprietary Transaction Code – The STARS
Transaction code generated for transactions with a proprietary funding
Governmental Fund – Fund number used to post
assset information in the STARS General Ledger.
Governmental General Ledger Account
Proprietary General Ledger Account
The General Ledger account passed to STARS with the
generated transaction codes. The generated transaction codes contain one
general ledger account and FAS provides the offsetting entry general ledger
GEN FAS TC
Generated FAS Transaction Code – A FAS Transaction
Code may generate another FAS transaction code, such as removing depreciation
on a disposition, gains or losses on sales, etc. FAS transaction codes may also be generated
due to Register processing logic and the use of descriptor tables FD16 and/or
There are five transaction amount fields in the File Posting
Original Amount (positive balance)
Agency Disposition Adjustment Amount (negative balance)
Not currently used
Salvage Amount (negative balance)
State Accumulated Depreciation Amount (negative balance)
Agency Accumulated Depreciation Amount (negative balance)
Disposition Amount (negative balance)
Replacement Amount (positive balance)
Positive Adjustment Amount (positive balance)
Negative Adjustment Amount (negative balance)
Statewide Liquidated Depreciation (positive balance)