job_notes_v1
Job Notes are used to raise queries or log interaction to improve communication, understanding and traceability of activities related to job.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the job note. |
| reference | VARCHAR(80) | The reference of the job note that is auto populated or inputted as free text. |
| subject | VARCHAR(200) | The subject of the job note inputted as free text. |
| creator | VARCHAR(100) | The creator of the job note. |
| created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the job note creation. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset when the job note was deleted. |
| owner | VARCHAR(100) | The owner of the job note. |
| progress_percentage | NUMBER(38,0) | The percentage progress indicator of the job note. |
| progressed_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the job note progress update. |
| due_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset when the job note is due. |
| completed_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the job note completion. |
| completion_details | VARCHAR(16777216) | Any comments related to the completion of the task or activity represented on the note. |
| type | VARCHAR(100) | The type of the job note as configured by the user in Administration panel. |
| status | VARCHAR(50) | The status of the job note. Possible values: 'Open', 'Completed', 'Cancelled'. |
| flag | VARCHAR(100) | The 'Note Flag' field is used to indicate the status or stage of a note in a process, or to signal if input is needed from another department or identify areas of interest quickly. |
| priority | VARCHAR(100) | The 'Note Priority' field is used to classify the importance or urgency of a note. This field helps in prioritising tasks or actions based on the value assigned to each note. |
| description | VARCHAR(16777216) | The note description that is inputted as free text. |
| open_in_hours | NUMBER(38,2) | The duration that the job note was open for (in hours) since its creation. |
| open_in_days | NUMBER(38,2) | The duration that the job note was open for (in days) since its creation. |
| completed_in_hours | NUMBER(38,2) | The time to completion of the job note in hours. |
| completed_in_days | NUMBER(38,2) | The time to completion of the job note in days. |
| overdue_in_hours | NUMBER(38,2) | Time the job note is overdue by, in hours. |
| overdue_in_days | NUMBER(38,2) | Time the job note is overdue by, in days. |
| _person_id | VARCHAR(256) | The identifier of the person associated with the job note. |
| _job_id | NUMBER(38,0) | The identifier of the job associated with the job note. |
| _parent_contact_note_id | NUMBER(38,0) | The identifier of the parent contact note associated with the job note. |
| _parent_job_note_id | NUMBER(38,0) | The identifier of the parent job note associated with the job note. |
| _parent_stock_item_note_id | NUMBER(38,0) | The identifier of the parent stock item note associated with the job note. |
| _parent_resource_note_id | NUMBER(38,0) | The identifier of the parent resource note associated with the job note. |
| _parent_vehicle_note_id | NUMBER(38,0) | The identifier of the parent vehicle note associated with the job note. |
| _parent_sales_opportunity_note_id | NUMBER(38,0) | The identifier of the parent sales opportunity note associated with the job note. |
| _parent_contract_note_id | NUMBER(38,0) | The identifier of the parent contract note associated with the job note. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the job note record was last refreshed. |