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 MAINTENANCE/INQUIRY S031
FUNCTION: R (A=ADD, C=CHANGE, D=DELETE, N=NEXT, R=RECALL)
FAS TC AP1 TITLE: RECORD THE PURCHASE OF LAND - FAS
AGYSFX LOCAT1 R PRP NO R CMP NO R QUANTY R QTY UN R CLS CD R CLSSFX
INSIND CAPIND R CON CD R U LIFE R FUND R FDTL ACQMTH R ST MTH R
AGYMTH ADT DT R DEPRDT N ADTAMT R ST DPR N AGYDPR N REP VL R REFPRP
REFCMP RESPNM RMBILL R CDOC R DISPMD N DISP % N OWNER R INSERV R
SAL VL N STATUS R LOCAT2
REGIST 2 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
GEN-FAS TC:
FILE A/S FIELD A/S FIELD
POSTING ACQ/DISP: + 01
STWD ACCUM DEPR:
AGY ACCM DEPR:
REPLACEMENT VAL: + 08
SALVAGE VAL:
The following table describes the data elements and identifies the transaction types for which they are required, optional, etc.
Data Field
Description
FAS TC
The FAS transaction code
TITLE
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:
Data Element
AGY SFX
Agency Suffix is an informational field that may be used by the agencies for indexing assets.
LOCAT 1
Location 1 is used by agencies to record where an asset is located and to report to Risk Management for insurance purposes
PROP NO
Property Number is an identifier for each asset
COMP NO
Component Number uniquely identifies the Property Number
QTY
Quantity is an information field typically used with real property to define the number of units, such as how many acres, square feet, etc.
QTY UNT
Quantity Unit is an information field used to define the unit of measurement (i.e. ACRE, SQFT, etc.).
CLS CD
Class Code is used to categorize the asset and determine which general ledger asset account should be impacted by transactions against the property.
CLS SFX
Class Suffix is used by the agency to give more detail to the class codes.
INS IND
Insurance Indicator is used by to identify how an asset is to be insured and to describe the type of coverage.
CAP IND
Capital Indicator indicates if an asset is to be capitalized.
COND CD
Condition Code is an information field used by agencies to record the general condition of the asset.
U LIFE
Useful Life is a field used to calculate depreciation. It is usually looked up from the Class Code Descriptor (FD02) table.
FUND
The Fund indicator is used with interfaces to STARS and ACFR reporting.
FUND DT
Fund Detail uniquely identifies the Fund and is used with interfaces to STARS.
ACQ MTH
Acquisition Method is used to record the original method used to acquire the asset.
ST MTH
State Depreciation Method is a field used to determine the depreciation method used for the calculated statewide depreciation.
AGY MTH
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.
ADT DT
The Acquisition, Disposition, Transaction Date indicator is a field necessary for any transaction impacting the History File.
DEPR DT
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.
ADT AMT
The ADT Amount field is used for the Acquisition, Disposition, and Transaction Amount. It is required on most financial transactions other than depreciation.
ST DPR
The State Depreciation Amount is used for Statewide Depreciation. Typically, depreciation transactions will be system-generated.
AGY DPR
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.
REP VL
Replacement Value is the field used to record the cost to replace the asset. This value is used for insurance purposes.
REF PRP
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
REF CMP
Reference Component Number contains the component number that was entered in STARS and passed to the FAS Hold File.
RESP NM
Responsible Last Name is that is recommended to track inventory responsibility.
RM BILL
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.
CDOC
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.
DISP MD
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.
DISP %
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.
OWNRSHP
The Ownership indicator is to record the ownership of the asset. The ownership information is needed for statewide reporting, federal property inventory reports, etc.
INSRV DT
In-Service Date is a field used to record the date the asset was placed in service, which is used for reporting and depreciation expense.
SAL VAL
Salvage Value is a field used when calculating depreciation expense.
STATUS
Status Code is a field used to specify if the asset is “in use”, “idle”, “stored”, or “disposed”.
LOCAT 2
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.
Definition
REGIST
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
TRANTP
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.
BUDU
Budget Unit – Edit Indicator for the Funding Source Screen Budget Unit Field.
FNMATCH
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’.
RCMATCH
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.
APPLVL
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.
GEN-GVT-TC
Generated Governmental Transaction Code – The STARS Transaction code generated for transactions with a governmental funding source.
GEN-PRO-TC
Generated Proprietary Transaction Code – The STARS Transaction code generated for transactions with a proprietary funding source.
GVTFUND
Governmental Fund – Fund number used to post assset information in the STARS General Ledger.
GOV GL
PRO GL
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 account number.
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 FD02
There are five transaction amount fields in the File Posting section:
Field
01
Original Amount (positive balance)
02
Agency Disposition Adjustment Amount (negative balance)
03
Not currently used
04
Salvage Amount (negative balance)
05
State Accumulated Depreciation Amount (negative balance)
06
Agency Accumulated Depreciation Amount (negative balance)
07
Disposition Amount (negative balance)
08
Replacement Amount (positive balance)
09
Gain Amount (positive balance)
10
Loss Amount (negative balance)
11
Positive Adjustment Amount (positive balance)
12
Negative Adjustment Amount (negative balance)
13
Statewide Liquidated Depreciation (positive balance)