Asset Management Parks System (AMPS) – Transactions
This table contains information about transactions. A transaction tracks the movement of parts and materials between store houses and work orders. Each record represents a single transaction. The primary key is TRA_CODE. When TRA_TOENTITY is “EVNT” then you can use the TRA_TOCODE field to join to the Work Orders table on EVT_CODE to know which transactions are associated with each work order.
For the User Guide, please follow <a href="https://docs.google.com/document/d/1UwyGGncb6oFMiOfgz73G-iM8Yea9ubz4931hPeBO9YQ/edit?usp=sharing">this link</a>
For the Data Dictionary, please follow <a href="https://docs.google.com/spreadsheets/d/1pDr-BUe4LS7DvATfbOnd8UrV6s77krJgzqdq_gVYWqc/edit?usp=sharing">this link </a>
Columns
Name | Socrata field name | Column name in sgr mount | Data type | Description |
---|---|---|---|---|
TRA_CODE | tra_code | tra_code | Number | |
TRA_DATE | tra_date | tra_date | Text | |
TRA_FROMENTITY | tra_fromentity | tra_fromentity | Text | |
TRA_STATUS | tra_status | tra_status | Text | |
TRA_FROMCODE | tra_fromcode | tra_fromcode | Text | |
TRA_REQ | tra_req | tra_req | Text | |
TRA_DESC | tra_desc | tra_desc | Text | |
TRA_TOCODE | tra_tocode | tra_tocode | Text | |
TRA_UPDATED | tra_updated | tra_updated | Text | |
TRA_UPDATECOUNT | tra_updatecount | tra_updatecount | Text | |
TRA_SQLIDENTITY | tra_sqlidentity | tra_sqlidentity | Number | |
TRA_CREATED | tra_created | tra_created | Text | |
TRA_TOENTITY | tra_toentity | tra_toentity | Text | |
TRA_TYPE | tra_type | tra_type | Text |