| Name | Description | Type | Additional information | 
|---|---|---|---|
| id | 
                         Primary Key  | 
                    globally unique identifier | |
| code | 
                         Status code  | 
                    string | |
| name | 
                         Status name  | 
                    string | |
| system_job_status_id | globally unique identifier | ||
| system_job_status_code | string | ||
| sequence | 
                         Status order  | 
                    integer | |
| color_text | 
                         Status color  | 
                    string | |
| archived | 
                         Status archived?  | 
                    boolean | |
| is_readonly_on_api | 
                         Gives the possibility to alter the row using the API  | 
                    boolean | |
| usable_on_api | 
                         Specifies if can be used when create, update or changestatus of jobs  | 
                    boolean | |
| modified_dateutc | 
                         Readonly system field managed by database, filled with GetUtcDate when adding,updating.  | 
                    date |