Dataset: Referrals Log
Dataset name:
ds_referrals_log
Description
A record of all referrals made on behalf of the member (citizen) to service providers by other servi
Fields in this dataset
| Name | Field Name | Description | Field Type | Field Example |
|---|---|---|---|---|
| Action |
action
|
varchar | Referring | |
| End Time |
end_time
|
int | 1639153129 | |
| Referrals Log ID |
id
|
The primary identifier for this record. | serial | 2 |
| Referrals Log Instance |
instance
|
The instance this item relates to. | int | 1 |
| Responsible User ID |
responsible_user_id
|
int | 321 | |
| Service Order ID |
service_order_id
|
Link to the service order | int | 5046 |
| Referrals Log Source |
source
|
The source of the data - user or connection. | varchar | |
| Start Time |
start_time
|
int | 1638375529 | |
| Referral Status |
status
|
The status of the service order. | int | Status |
| User ID |
user_id
|
Link to the user who changed the order status. | int | 87 |