RTE_REQUEST_ALL (Request)
This is same layout for both the RTE_REQUEST and RTE_REQUEST_ALL tables. The Request data is stored in the ServiceRequest Resource
| Column | FHIR Source | Description |
|---|---|---|
| Request_ID | ServiceRequest.id | Primary Key (GUID) |
| Request Version | ServiceRequest.Meta.versionId | The Version of the Request. Each modification to a Request increments the version |
| Current Record | n/a | Flag that this record is latest version. 1 = Yes, 2 = No |
| Based_On_Request_ID | ServiceRequest.basedOn | If this is a child request (a request for additional information) then this will be a reference to the parent request. |
| Status_Code | ServiceRequest.status | The status of the request. This is a foriegn key to the RTE_Code_Table_Lookup |
| Questionnaire_Form_Code | ServiceRequest.reasonCode | The Questionnaire Code |
| Category_ID | ServiceRequest. | The type of request, 'NEW-REQUEST' or 'ADDITIONAL-INFORMATION' |
| Requester_Role_ID | ServiceRequest.requester | The requestor role that owns the request, it is FK to the RTE_PRACTITIONER_ROLE table |
| Applicant_ID | ServiceRequest.subject | The applicant/subject of the request. This a foriegn key to the RTE_APPLICANT table. |
| Applicant_Name | ServiceRequest.extension:applicantName | The name of the applicant/subject. |
| Location_Status_Code | ServiceRequest.locationCode.coding.code | The location confirmation code. This is a foriegn key to the RTE_Code_Table_Lookup |
| Created Date | ServiceRequest.extension:requestCreatedDate | The date and time(EST) the request was last created |
| Created_User_Role_ID | ServiceRequest.extension:requestCreatedUser | This is the user role that created the request. It is FK to the RTE_PRACTITIONER_ROLE table |
| Last Updated Date | ServiceRequest.lastUpdated | The date and time(EST) the request was last updated |
| Last_Updated_Role_ID | ServiceRequest.performer | The user role that last updated the request. It is FK to the RTE_PRACTITIONER_ROLE table. |
| Submitted Date | ServiceRequest.extension:requestSubmittedDate | The date and time(EST) the request was submitted |
| Submitted_User_Role_ID | ServiceRequest.extension:requestSubmittedUser | The user role that submitted the request. It is FK to the RTE_PRACTITIONER_ROLE table. |
| Completed Date | ServiceRequest.extension:requestCompletedDate | The date and time(EST) the request was completed |
| Client Request Status | ServiceRequest.extension:requestClientStatus | This is the client's status for the Request. The client can update this with anything they want, typically it will be 'Rejected' or 'Approved'. |
| Client_Detail_One | ServiceRequest.orderDetail[1].text | This is used by the Program Area. |
| Client_Detail_Two | ServiceRequest.orderDetail[2].text | This is used by the Program Area. |