RTE_REQUEST_VIEW (Request View)
This view contains the current record of each request.
Column | Description |
---|---|
Request ID | Primary Key (Generated GUID) |
Request Version | The Version of the Request. Each modification to a Request automatically increments the version. |
Program Area | The Program Area of the Requestor Role. |
Current Record | Indicates whether this is latest version of a Request. 1 = Yes, 0 = No it's historical record |
Request Status | Status of the Request |
Request Category | Categories are 'New Request' or 'Additional Information' |
Based On Request ID | If this is a child request (a request for additional information) then this will be a reference to the parent request |
Completed DateTime | When the Client System marked this Request as complete |
Location Name | The location name of the location associated with the Request |
Questionnaire Code | The code for the questionnaire that was completed by the user |
Questionnaire Version | The version of the questionnaire that this request is associated with |
Questionnaire Last Updated | The date the version of the questionnaire that this request is associated with was last updated on. |
Questionnaire | The name of the questionnaire that was completed by the user |
Requestor Role ID | Foriegn Key to the Practitioner Role View |
Applicant First Name | First Name of the Patient/Applicant |
Applicant Last Name | Last Name of the Patient/Applicant |
Applicant Birth Date | Birth Date of the Patient/Applicant |
Client Request Status | A status the client has assigned to this request. This could be anything, there are no restrictions |
Client Detail One | Some information the client wants associated with this request |
Client Detail Two | Some information the client wants associated with this request |
Created DateTime | The date and time(EST) the request was created. |
Created Role ID | Foriegn Key to the Practitioner Role View |
Last Updated DateTime | The date and time(EST) the request was last updated. |
Last Updated Role ID | Foriegn Key to the Practitioner Role View |
Submitted DateTime | The date and time(EST) the request was submitted. |
Submitted User Role ID | Foriegn Key to the Practitioner Role View |