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