Asset Management Parks System (AMPS) – Comments
Asset Management Parks System (AMPS) – Comments
This table all comments for all tables in AMPS. The record for each comment indicates which record and table the comment pertains to. Each record is a single comment. The ADD_CODE field can be joined to another table according to the value in ADD_ENTITY.
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 |
|---|---|---|---|---|
| ADD_TEXT | add_text | add_text | Text | |
| ADD_UPDATECOUNT | add_updatecount | add_updatecount | Text | |
| ADD_LANG | add_lang | add_lang | Text | |
| ADD_CODE | add_code | add_code | Text | |
| ADD_ENTITY | add_entity | add_entity | Text | |
| ADD_CREATED | add_created | add_created | Text | |
| ADD_SQLIDENTITY | add_sqlidentity | add_sqlidentity | Number | |
| ADD_UPDATED | add_updated | add_updated | Text | |
| ADD_PRINT | add_print | add_print | Text | |
| ADD_LINE | add_line | add_line | Text |