# Education Pre-Docket: Front-end findings (Ticket Number: 3136)
## Important reference links
- Jira ticket link: https://vajira.max.gov/browse/CASEFLOW-3136
- Current VHA flow Mural link: https://app.mural.co/t/bahdigitalexperience6902/m/workqueue2001/1634750324758/87af15845b74aeb4277e3cbc24f13c291aaddaf5?sender=u21c01a8f3c02aa7a47118741
- Projected Education flow Mural link: https://app.mural.co/t/bahdigitalexperience6902/m/bahdigitalexperience6902/1643307965059/d1485c52fc3958a2e27a639ec0182cd9984ee9e5?sender=u21c01a8f3c02aa7a47118741
- How 'Tasks' work in Caseflow: https://boozallen.enterprise.slack.com/files/WAZT52P2R/F0335P6GZC6/explaining_caseflow_tasks.pdf
# Pre-docketing a VHA appeal (Current process, after feature toggle)
### As BVA Intake user Deborah Wise
- Initial intake page, prompts us for form type. In order to get to pre-docket, we select original form type 10182.
- Selecting our veteran, Bob Smithdooley, via their Appeal ID number (Use of SSN will soon be deprecated).
- Here we fill out the details on the Intake of our appeal (Receipt date, Docket type, Appellant, SSOC Opt-In).
- Adding our issue, this is the primary trigger to pre-docket an appeal, although all VHA appeals are automatically set to pre-docket.
- This review page allows us to view our added issues, remove an issue, and add subsequent issues to our appeal before submitting to CAMO as pre-docket.
- After submitting the form, our veteran's appeal has successfully been pre-docketed when we get to this confirmation page.
## What we can repurpose/recycle
> [name=JackSinatra98] Add random initial findings here, and we can organize them later
* AddIssuesModal.jsx could be reused but needs radio buttons for if pre-docketing is needed so it can be bypassed if checked no
NonratingRequestIssueModal.jsx
* OrganizationQueue.jsx could be reused for the most part but requires an "Unassigned" tab on the queue for CAMO users
Tabs.jsx
* The actions dropdown used in CaseDetailsView.jsx may need to be changed to "Assign to Regional Processing Office" instead of "Assign to Program Office" and the modal when selecting it must also be changed accordingly so there can be options to select the RPO and not the Program Office
QueueApp.jsx
* The dropdown in the CaseDetailsView.jsx also just needs a change in options where we only get the options to "Return to Executive Management Office", "Mark Task in Progress" and "Send to Board Intake"
* The modal for "Ready for Review" can just be repurposed and be used for "Send to Board Intake" so it can just go directly to the intake team
CompleteTaskModal.jsx
* The task actions from BVA intake team just have to replace "Return appeal to VHA" for "Return appeal to Education" so it would be sent back to the correct team
* The modal for returning the appeal to VHA and docketing can just be repurposed for it to align to education
* Overall many of these UI components can be reused for education because they seem to be modular and the content inside and backend functionalty mostly needs to be changed
# Fixed issues
## Intake Process
#### Selecting an Intake User and clicking "Start" inside the "Mail Intake" menu
#### Beginning to process an intake form by selecting VA Form 10182
#### Choosing a Veteran ID
> [name=JackSinatra98] Note that this screen asks for Veteran ID or SSN... Will the veteran SSNs still be available within the veteran database, and the new process would just no longer require them? If so, I'd imagine each Form 10182 would have the Veteran ID on it if that is how an intake user searches for a veteran to use.
#### Selecting options for a hearing request
#### Page to add new issues
Note the banner stating the VHA issue will go to pre-docket
#### Page displaying all the issues on the intake appeal
Note the banner here as well, stating the VHA issue will go to pre-docket
### **Confirmation screen showing appeal has been sent to pre-docket**
---
> ### **Confirmation screen if no pre-docket feature is enabled**
> 
>
---
### **Intaking a new appeal with Alec's information**
#### Checking a CAMO Admin User
##### Chekcing in "Your Cases"
##### Checking in "VHA CAMO Team Cases"
##### Current Case Details Page
## Potential Blockers
>[name=JackSinatra98] According to the Mural, this appeal should have been submitted to a CAMO user under the pre-docketing state. In the test environment however, this appeal appears to have been fully established rather than going to CAMO.
-- **CAMO, PO, and VISN Admins all show similar screens:**
---
## Front-end Findings
## Code Calls When Intaking Appeal
```
clear
[[::1]] [46b4a6da-e1b2-4734-ad8a-5300871d2c4e] [localhost] [BVAISHAW ] Started POST "/intake" for ::1 at 2022-02-17 10:58:05 -0600
[2022-02-17 10:58:05 -0600] Processing by IntakesController#create as JSON
[2022-02-17 10:58:05 -0600] Parameters: {"file_number"=>"000100005", "form_type"=>"appeal"}
[2022-02-17 10:58:05 -0600] User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 18], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] (0.5ms) BEGIN
[2022-02-17 10:58:05 -0600] User Update (0.7ms) UPDATE "users" SET "last_login_at" = $1, "updated_at" = $2 WHERE "users"."id" = $3 [["last_login_at", "2022-02-17 16:58:05.799425"], ["updated_at", "2022-02-17 16:58:05.801822"], ["id", 18]]
[2022-02-17 10:58:05 -0600] (5.8ms) COMMIT
[2022-02-17 10:58:05 -0600] Intake Load (0.6ms) SELECT "intakes".* FROM "intakes" WHERE "intakes"."completed_at" IS NULL AND "intakes"."started_at" BETWEEN $1 AND $2 AND "intakes"."user_id" = $3 LIMIT $4 [["started_at", "2022-02-16 16:58:05.856374"], ["started_at", "2022-02-17 16:58:05.856483"], ["user_id", 18], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] Veteran Load (0.6ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[[::1]] [46b4a6da-e1b2-4734-ad8a-5300871d2c4e] [localhost] [BVAISHAW ] find_by_file_number_and_sync veteran:000100005 accessible:true
[2022-02-17 10:58:05 -0600] Veteran Load (0.9ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."id" = $1 LIMIT $2 [["id", 1913], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] BvaIntake Load (0.8ms) SELECT "organizations".* FROM "organizations" WHERE "organizations"."type" IN ('BvaIntake') AND "organizations"."status" = $1 ORDER BY "organizations"."id" ASC LIMIT $2 [["status", "active"], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] User Exists (2.1ms) SELECT 1 AS one FROM "users" INNER JOIN "organizations_users" ON "users"."id" = "organizations_users"."user_id" WHERE "organizations_users"."organization_id" = $1 AND "users"."id" = $2 LIMIT $3 [["organization_id", 4], ["id", 18], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] Intake Load (1.0ms) SELECT "intakes".* FROM "intakes" WHERE "intakes"."completed_at" IS NULL AND "intakes"."started_at" BETWEEN $1 AND $2 AND "intakes"."type" = $3 AND "intakes"."veteran_file_number" = $4 LIMIT $5 [["started_at", "2022-02-16 16:58:05.888309"], ["started_at", "2022-02-17 16:58:05.888448"], ["type", "AppealIntake"], ["veteran_file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] Intake Load (0.9ms) SELECT "intakes".* FROM "intakes" WHERE "intakes"."completed_at" IS NULL AND "intakes"."started_at" >= $1 AND "intakes"."started_at" < $2 [["started_at", "1970-01-01 00:00:00"], ["started_at", "2022-02-16 16:58:05.893294"]]
[2022-02-17 10:58:05 -0600] EndProductEstablishment Load (1.2ms) SELECT "end_product_establishments".* FROM "end_product_establishments" WHERE NOT (established_at IS NULL) AND "end_product_establishments"."veteran_file_number" = $1 [["veteran_file_number", "000100005"]]
[2022-02-17 10:58:05 -0600] (0.5ms) BEGIN
[2022-02-17 10:58:05 -0600] Appeal Create (1.1ms) INSERT INTO "appeals" ("created_at", "updated_at", "veteran_file_number") VALUES ($1, $2, $3) RETURNING "id" [["created_at", "2022-02-17 16:58:05.905162"], ["updated_at", "2022-02-17 16:58:05.905162"], ["veteran_file_number", "000100005"]]
[2022-02-17 10:58:05 -0600] Claimant Load (0.8ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] Appeal Update (1.0ms) UPDATE "appeals" SET "stream_type" = $1, "updated_at" = $2 WHERE "appeals"."id" = $3 [["stream_type", "original"], ["updated_at", "2022-02-17 16:58:05.917868"], ["id", 1624]]
[2022-02-17 10:58:05 -0600] AppealIntake Create (1.6ms) INSERT INTO "intakes" ("created_at", "detail_id", "detail_type", "started_at", "type", "updated_at", "user_id", "veteran_file_number", "veteran_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", "2022-02-17 16:58:05.928527"], ["detail_id", 1624], ["detail_type", "Appeal"], ["started_at", "2022-02-17 16:58:05.902075"], ["type", "AppealIntake"], ["updated_at", "2022-02-17 16:58:05.928527"], ["user_id", 18], ["veteran_file_number", "000100005"], ["veteran_id", 1913]]
[2022-02-17 10:58:05 -0600] (4.2ms) COMMIT
[2022-02-17 10:58:05 -0600] Veteran Load (0.7ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] CACHE Veteran Load (0.1ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] CACHE Veteran Load (0.1ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] Claimant Load (1.7ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] CACHE Claimant Load (0.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] CACHE Claimant Load (0.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] CACHE Claimant Load (0.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] CACHE Claimant Load (0.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:58:05 -0600] CACHE Claimant Load (0.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[[::1]] [46b4a6da-e1b2-4734-ad8a-5300871d2c4e] [localhost] [BVAISHAW ] STARTED VACOLS: appeals_by_vbms_id
[[::1]] [46b4a6da-e1b2-4734-ad8a-5300871d2c4e] [localhost] [BVAISHAW ] FINISHED VACOLS: appeals_by_vbms_id: 0.000162 0.000024 0.000186 ( 0.000181)
[2022-02-17 10:58:05 -0600] VACOLS::Case Load (1.9ms) SELECT "BRIEFF".* FROM "BRIEFF" WHERE "BRIEFF"."BFCORLID" = :a1 [["bfcorlid", "000100005S"]]
[2022-02-17 10:58:05 -0600] Intake Load (0.8ms) SELECT "intakes".* FROM "intakes" WHERE "intakes"."detail_id" = $1 AND "intakes"."detail_type" = $2 LIMIT $3 [["detail_id", 1624], ["detail_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:58:06 -0600] Veteran Load (0.7ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."id" = $1 LIMIT $2 [["id", 1913], ["LIMIT", 1]]
[2022-02-17 10:58:06 -0600] RequestIssue Load (0.8ms) SELECT "request_issues".* FROM "request_issues" WHERE "request_issues"."decision_review_id" = $1 AND "request_issues"."decision_review_type" = $2 AND ("request_issues"."ineligible_reason" IS NULL AND "request_issues"."closed_at" IS NULL OR "request_issues"."closed_status" = $3) [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["closed_status", "ineligible"]]
[2022-02-17 10:58:06 -0600] CACHE Veteran Load (0.1ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 10:58:06 -0600] RequestIssue Load (2.5ms) SELECT "request_issues".* FROM "request_issues" WHERE "request_issues"."decision_review_id" = $1 AND "request_issues"."decision_review_type" = $2 [["decision_review_id", 1624], ["decision_review_type", "Appeal"]]
[2022-02-17 10:58:06 -0600] RequestIssue Load (0.8ms) SELECT "request_issues".* FROM "request_issues" WHERE "request_issues"."contested_rating_issue_reference_id" IS NULL AND "request_issues"."contested_rating_decision_reference_id" IS NULL AND ("request_issues"."is_unidentified" = $1 OR "request_issues"."is_unidentified" IS NULL) AND ("request_issues"."verified_unidentified_issue" = $2 OR "request_issues"."verified_unidentified_issue" IS NULL) AND "request_issues"."nonrating_issue_category" IS NOT NULL AND "request_issues"."ineligible_reason" IS NULL AND "request_issues"."closed_at" IS NULL AND "request_issues"."veteran_participant_id" = $3 AND 1=1 [["is_unidentified", false], ["verified_unidentified_issue", false], ["veteran_participant_id", "500001909"]]
[2022-02-17 10:58:06 -0600] Appeal Load (0.8ms) SELECT "appeals".* FROM "appeals" WHERE "appeals"."id" = $1 LIMIT $2 [["id", 1624], ["LIMIT", 1]]
[2022-02-17 10:58:06 -0600] Claimant Load (1.2ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:58:06 -0600] Completed 200 OK in 341ms (Views: 0.6ms | ActiveRecord: 85.7ms)
#Entered Veteran ID, now beginning intake process
[[::1]] [e77f37f8-7077-4d1a-8ee7-bd81ff5bf808] [localhost] [BVAISHAW ] Started PATCH "/intake/5/review" for ::1 at 2022-02-17 10:59:34 -0600
[2022-02-17 10:59:34 -0600] Processing by IntakesController#review as JSON
[2022-02-17 10:59:34 -0600] Parameters: {"docket_type"=>"direct_review", "receipt_date"=>"2022-02-01", "filed_by_va_gov"=>nil, "claimant"=>nil, "claimant_type"=>"veteran", "payee_code"=>nil, "legacy_opt_in_approved"=>false, "id"=>"5"}
[2022-02-17 10:59:34 -0600] User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 18], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] (0.5ms) BEGIN
[2022-02-17 10:59:34 -0600] (2.1ms) COMMIT
[2022-02-17 10:59:34 -0600] Intake Load (1.0ms) SELECT "intakes".* FROM "intakes" WHERE "intakes"."user_id" = $1 AND "intakes"."id" = $2 LIMIT $3 [["user_id", 18], ["id", 5], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] (0.5ms) BEGIN
[2022-02-17 10:59:34 -0600] Appeal Load (1.3ms) SELECT "appeals".* FROM "appeals" WHERE "appeals"."id" = $1 LIMIT $2 [["id", 1624], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] Unpermitted parameters: :claimant, :claimant_type, :payee_code, :id
[2022-02-17 10:59:34 -0600] Claimant Load (0.8ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_type" = $1 AND "claimants"."decision_review_id" = $2 LIMIT $3 [["decision_review_type", "Appeal"], ["decision_review_id", 1624], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] Veteran Load (0.7ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."id" = $1 LIMIT $2 [["id", 1913], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] Claimant Exists (0.9ms) SELECT 1 AS one FROM "claimants" WHERE "claimants"."participant_id" = $1 AND "claimants"."decision_review_id" = $2 AND "claimants"."decision_review_type" = $3 LIMIT $4 [["participant_id", "500001909"], ["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] VeteranClaimant Create (0.7ms) INSERT INTO "claimants" ("created_at", "decision_review_id", "decision_review_type", "participant_id", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" [["created_at", "2022-02-17 16:59:34.384484"], ["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["participant_id", "500001909"], ["type", "VeteranClaimant"], ["updated_at", "2022-02-17 16:59:34.384484"]]
[2022-02-17 10:59:34 -0600] Claimant Load (2.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] CACHE Claimant Load (0.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] Person Load (0.7ms) SELECT "people".* FROM "people" WHERE "people"."participant_id" = $1 LIMIT $2 [["participant_id", "500001909"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] Person Create (1.0ms) INSERT INTO "people" ("created_at", "participant_id", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["created_at", "2022-02-17 16:59:34.406953"], ["participant_id", "500001909"], ["updated_at", "2022-02-17 16:59:34.406953"]]
[2022-02-17 10:59:34 -0600] Veteran Load (0.9ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."participant_id" = $1 LIMIT $2 [["participant_id", "500001909"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] Person Update (0.8ms) UPDATE "people" SET "date_of_birth" = $1, "email_address" = $2, "first_name" = $3, "last_name" = $4, "ssn" = $5, "updated_at" = $6 WHERE "people"."id" = $7 [["date_of_birth", "1992-02-01"], ["email_address", "Bob.Smithklocko@test.com"], ["first_name", "Bob"], ["last_name", "Smithklocko"], ["ssn", "878642992"], ["updated_at", "2022-02-17 16:59:34.435776"], ["id", 1579]]
[2022-02-17 10:59:34 -0600] Intake Load (0.9ms) SELECT "intakes".* FROM "intakes" WHERE "intakes"."detail_id" = $1 AND "intakes"."detail_type" = $2 LIMIT $3 [["detail_id", 1624], ["detail_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 18], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] Claimant Load (0.8ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 [["decision_review_id", 1624], ["decision_review_type", "Appeal"]]
[2022-02-17 10:59:34 -0600] Appeal Update (1.2ms) UPDATE "appeals" SET "receipt_date" = $1, "docket_type" = $2, "legacy_opt_in_approved" = $3, "veteran_is_not_claimant" = $4, "updated_at" = $5 WHERE "appeals"."id" = $6 [["receipt_date", "2022-02-01"], ["docket_type", "direct_review"], ["legacy_opt_in_approved", false], ["veteran_is_not_claimant", false], ["updated_at", "2022-02-17 16:59:34.456647"], ["id", 1624]]
[2022-02-17 10:59:34 -0600] Appeal Update (1.1ms) UPDATE "appeals" SET "stream_docket_number" = $1, "updated_at" = $2 WHERE "appeals"."id" = $3 [["stream_docket_number", "220201-1624"], ["updated_at", "2022-02-17 16:59:34.466530"], ["id", 1624]]
[2022-02-17 10:59:34 -0600] (3.9ms) COMMIT
[2022-02-17 10:59:34 -0600] Veteran Load (0.7ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] CACHE Veteran Load (0.1ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] CACHE Veteran Load (0.2ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] Claimant Load (0.6ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] CACHE Claimant Load (0.2ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] CACHE Claimant Load (0.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] CACHE Claimant Load (0.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] Person Load (1.9ms) SELECT "people".* FROM "people" WHERE "people"."participant_id" = $1 LIMIT $2 [["participant_id", "500001909"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] CACHE Claimant Load (0.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] Veteran Load (0.8ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."participant_id" = $1 LIMIT $2 [["participant_id", "500001909"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] CACHE Veteran Load (0.1ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."participant_id" = $1 LIMIT $2 [["participant_id", "500001909"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] CACHE Claimant Load (0.2ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[[::1]] [e77f37f8-7077-4d1a-8ee7-bd81ff5bf808] [localhost] [BVAISHAW ] STARTED VACOLS: appeals_by_vbms_id
[[::1]] [e77f37f8-7077-4d1a-8ee7-bd81ff5bf808] [localhost] [BVAISHAW ] FINISHED VACOLS: appeals_by_vbms_id: 0.000247 0.000036 0.000283 ( 0.000280)
[2022-02-17 10:59:34 -0600] VACOLS::Case Load (2.4ms) SELECT "BRIEFF".* FROM "BRIEFF" WHERE "BRIEFF"."BFCORLID" = :a1 [["bfcorlid", "000100005S"]]
[2022-02-17 10:59:34 -0600] CACHE Veteran Load (0.1ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] Veteran Load (0.5ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."id" = $1 LIMIT $2 [["id", 1913], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] RequestIssue Load (1.1ms) SELECT "request_issues".* FROM "request_issues" WHERE "request_issues"."decision_review_id" = $1 AND "request_issues"."decision_review_type" = $2 AND ("request_issues"."ineligible_reason" IS NULL AND "request_issues"."closed_at" IS NULL OR "request_issues"."closed_status" = $3) [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["closed_status", "ineligible"]]
[2022-02-17 10:59:34 -0600] RequestIssue Load (1.0ms) SELECT "request_issues".* FROM "request_issues" WHERE "request_issues"."decision_review_id" = $1 AND "request_issues"."decision_review_type" = $2 [["decision_review_id", 1624], ["decision_review_type", "Appeal"]]
[2022-02-17 10:59:34 -0600] RequestIssue Load (0.9ms) SELECT "request_issues".* FROM "request_issues" WHERE "request_issues"."contested_rating_issue_reference_id" IS NULL AND "request_issues"."contested_rating_decision_reference_id" IS NULL AND ("request_issues"."is_unidentified" = $1 OR "request_issues"."is_unidentified" IS NULL) AND ("request_issues"."verified_unidentified_issue" = $2 OR "request_issues"."verified_unidentified_issue" IS NULL) AND "request_issues"."nonrating_issue_category" IS NOT NULL AND "request_issues"."ineligible_reason" IS NULL AND "request_issues"."closed_at" IS NULL AND "request_issues"."veteran_participant_id" = $3 AND 1=1 [["is_unidentified", false], ["verified_unidentified_issue", false], ["veteran_participant_id", "500001909"]]
[[::1]] [e77f37f8-7077-4d1a-8ee7-bd81ff5bf808] [localhost] [BVAISHAW ] Retrieving cached value for Appeal#cached_serialized_ratings
[2022-02-17 10:59:34 -0600] DecisionIssue Load (1.0ms) SELECT "decision_issues".* FROM "decision_issues" WHERE "decision_issues"."deleted_at" IS NULL AND "decision_issues"."participant_id" = $1 [["participant_id", "500001909"]]
[2022-02-17 10:59:34 -0600] Appeal Load (0.6ms) SELECT "appeals".* FROM "appeals" WHERE "appeals"."id" = $1 LIMIT $2 [["id", 1624], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] Claimant Load (0.8ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] BgsPowerOfAttorney Load (0.8ms) SELECT "bgs_power_of_attorneys".* FROM "bgs_power_of_attorneys" WHERE "bgs_power_of_attorneys"."claimant_participant_id" = $1 LIMIT $2 [["claimant_participant_id", "500001909"], ["LIMIT", 1]]
[2022-02-17 10:59:34 -0600] (0.6ms) BEGIN
[2022-02-17 10:59:34 -0600] BgsPowerOfAttorney Create (2.3ms) INSERT INTO "bgs_power_of_attorneys" ("claimant_participant_id", "created_at", "file_number", "last_synced_at", "legacy_poa_cd", "poa_participant_id", "representative_name", "representative_type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["claimant_participant_id", "500001909"], ["created_at", "2022-02-17 16:59:34.757270"], ["file_number", "00001234"], ["last_synced_at", "2022-02-17 16:59:34.757190"], ["legacy_poa_cd", "100"], ["poa_participant_id", "600153863"], ["representative_name", "Clarence Darrow"], ["representative_type", "Attorney"], ["updated_at", "2022-02-17 16:59:34.757270"]]
[2022-02-17 10:59:34 -0600] (2.1ms) COMMIT
[2022-02-17 10:59:34 -0600] Completed 200 OK in 471ms (Views: 0.5ms | ActiveRecord: 97.7ms)
# Adding Issues to the Form
# Establishing Appeal
[[::1]] [5146f9a0-4632-4c9b-aaf2-a01e17127557] [localhost] [BVAISHAW ] Started PATCH "/intake/5/complete" for ::1 at 2022-02-17 11:01:48 -0600
[2022-02-17 11:01:48 -0600] Processing by IntakesController#complete as JSON
[2022-02-17 11:01:48 -0600] Parameters: {"request_issues"=>[{"benefit_type"=>"compensation", "nonrating_issue_category"=>"Income/Net Worth (Pension)", "decision_text"=>"Appellant states he should receive more payment ", "decision_date"=>"2022-01-01", "ineligible_due_to_id"=>nil, "ineligible_reason"=>nil, "withdrawal_date"=>nil}], "id"=>"5"}
[2022-02-17 11:01:48 -0600] User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 18], ["LIMIT", 1]]
[2022-02-17 11:01:48 -0600] (0.5ms) BEGIN
[2022-02-17 11:01:48 -0600] (0.5ms) COMMIT
[2022-02-17 11:01:48 -0600] Intake Load (0.8ms) SELECT "intakes".* FROM "intakes" WHERE "intakes"."user_id" = $1 AND "intakes"."id" = $2 LIMIT $3 [["user_id", 18], ["id", 5], ["LIMIT", 1]]
[2022-02-17 11:01:48 -0600] (0.5ms) BEGIN
[2022-02-17 11:01:48 -0600] AppealIntake Update (0.9ms) UPDATE "intakes" SET "completion_started_at" = $1, "updated_at" = $2 WHERE "intakes"."id" = $3 [["completion_started_at", "2022-02-17 17:01:48.873527"], ["updated_at", "2022-02-17 17:01:48.873999"], ["id", 5]]
[2022-02-17 11:01:48 -0600] Appeal Load (0.6ms) SELECT "appeals".* FROM "appeals" WHERE "appeals"."id" = $1 LIMIT $2 [["id", 1624], ["LIMIT", 1]]
[2022-02-17 11:01:48 -0600] RequestIssue Exists (1.3ms) SELECT 1 AS one FROM "request_issues" WHERE "request_issues"."decision_review_id" = $1 AND "request_issues"."decision_review_type" = $2 LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 11:01:48 -0600] Intake Load (0.9ms) SELECT "intakes".* FROM "intakes" WHERE "intakes"."detail_id" = $1 AND "intakes"."detail_type" = $2 LIMIT $3 [["detail_id", 1624], ["detail_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 11:01:48 -0600] User Load (1.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 18], ["LIMIT", 1]]
[2022-02-17 11:01:48 -0600] Veteran Load (1.1ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 11:01:48 -0600] RequestIssue Create (1.2ms) INSERT INTO "request_issues" ("benefit_type", "created_at", "decision_date", "decision_review_id", "decision_review_type", "nonrating_issue_category", "nonrating_issue_description", "updated_at", "veteran_participant_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["benefit_type", "compensation"], ["created_at", "2022-02-17 17:01:48.908931"], ["decision_date", "2022-01-01"], ["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["nonrating_issue_category", "Income/Net Worth (Pension)"], ["nonrating_issue_description", "Appellant states he should receive more payment "], ["updated_at", "2022-02-17 17:01:48.908931"], ["veteran_participant_id", "500001909"]]
[2022-02-17 11:01:48 -0600] RequestIssue Load (0.9ms) SELECT "request_issues".* FROM "request_issues" WHERE "request_issues"."decision_review_id" = $1 AND "request_issues"."decision_review_type" = $2 [["decision_review_id", 1624], ["decision_review_type", "Appeal"]]
[2022-02-17 11:01:48 -0600] Appeal Update (1.1ms) UPDATE "appeals" SET "established_at" = $1, "updated_at" = $2 WHERE "appeals"."id" = $3 [["established_at", "2022-02-17 17:01:48.920674"], ["updated_at", "2022-02-17 17:01:48.921366"], ["id", 1624]]
[2022-02-17 11:01:48 -0600] Appeal Update (0.9ms) UPDATE "appeals" SET "target_decision_date" = $1, "updated_at" = $2 WHERE "appeals"."id" = $3 [["target_decision_date", "2023-02-01"], ["updated_at", "2022-02-17 17:01:48.928427"], ["id", 1624]]
[2022-02-17 11:01:48 -0600] RequestIssue Load (1.1ms) SELECT "request_issues".* FROM "request_issues" WHERE "request_issues"."decision_review_id" = $1 AND "request_issues"."decision_review_type" = $2 AND "request_issues"."ineligible_reason" IS NULL AND "request_issues"."closed_at" IS NULL [["decision_review_id", 1624], ["decision_review_type", "Appeal"]]
[2022-02-17 11:01:48 -0600] RootTask Load (0.9ms) SELECT "tasks".* FROM "tasks" WHERE "tasks"."type" IN ('RootTask') AND "tasks"."appeal_type" = $1 AND "tasks"."appeal_id" = $2 LIMIT $3 [["appeal_type", "Appeal"], ["appeal_id", 1624], ["LIMIT", 1]]
[2022-02-17 11:01:48 -0600] Bva Load (0.8ms) SELECT "organizations".* FROM "organizations" WHERE "organizations"."type" IN ('Bva') AND "organizations"."status" = $1 ORDER BY "organizations"."id" ASC LIMIT $2 [["status", "active"], ["LIMIT", 1]]
[2022-02-17 11:01:48 -0600] Task Exists (1.9ms) SELECT 1 AS one FROM "tasks" WHERE "tasks"."appeal_id" = $1 AND "tasks"."appeal_type" = $2 AND "tasks"."status" IN ($3, $4, $5) AND "tasks"."type" = $6 AND "tasks"."assigned_to_type" = $7 AND "tasks"."assigned_to_id" = $8 AND "tasks"."parent_id" IS NULL LIMIT $9 [["appeal_id", 1624], ["appeal_type", "Appeal"], ["status", "assigned"], ["status", "in_progress"], ["status", "on_hold"], ["type", "RootTask"], ["assigned_to_type", "Organization"], ["assigned_to_id", 5], ["LIMIT", 1]]
[2022-02-17 11:01:48 -0600] Task Exists (0.8ms) SELECT 1 AS one FROM "tasks" WHERE "tasks"."appeal_id" = $1 AND "tasks"."appeal_type" = $2 AND "tasks"."type" = $3 LIMIT $4 [["appeal_id", 1624], ["appeal_type", "Appeal"], ["type", "RootTask"], ["LIMIT", 1]]
[2022-02-17 11:01:48 -0600] RootTask Create (1.3ms) INSERT INTO "tasks" ("appeal_id", "appeal_type", "assigned_at", "assigned_to_id", "assigned_to_type", "created_at", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id" [["appeal_id", 1624], ["appeal_type", "Appeal"], ["assigned_at", "2022-02-17 17:01:48.952944"], ["assigned_to_id", 5], ["assigned_to_type", "Organization"], ["created_at", "2022-02-17 17:01:48.952944"], ["type", "RootTask"], ["updated_at", "2022-02-17 17:01:48.952944"]]
[2022-02-17 11:01:48 -0600] Claimant Load (0.8ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 [["decision_review_id", 1624], ["decision_review_type", "Appeal"]]
[2022-02-17 11:01:48 -0600] BgsPowerOfAttorney Load (0.8ms) SELECT "bgs_power_of_attorneys".* FROM "bgs_power_of_attorneys" WHERE "bgs_power_of_attorneys"."claimant_participant_id" = $1 LIMIT $2 [["claimant_participant_id", "500001909"], ["LIMIT", 1]]
[2022-02-17 11:01:48 -0600] Representative Load (1.1ms) SELECT "organizations".* FROM "organizations" WHERE "organizations"."type" IN ('Representative', 'Vso', 'PrivateBar', 'FieldVso') AND "organizations"."status" = $1 AND "organizations"."participant_id" = $2 [["status", "active"], ["participant_id", "600153863"]]
[2022-02-17 11:01:48 -0600] Task Load (2.0ms) SELECT "tasks".* FROM "tasks" WHERE "tasks"."appeal_id" = $1 AND "tasks"."appeal_type" = $2 AND "tasks"."status" IN ($3, $4, $5) AND "tasks"."type" = $6 LIMIT $7 [["appeal_id", 1624], ["appeal_type", "Appeal"], ["status", "assigned"], ["status", "in_progress"], ["status", "on_hold"], ["type", "DistributionTask"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] Bva Load (1.2ms) SELECT "organizations".* FROM "organizations" WHERE "organizations"."type" IN ('Bva') AND "organizations"."status" = $1 ORDER BY "organizations"."id" ASC LIMIT $2 [["status", "active"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] Task Exists (1.1ms) SELECT 1 AS one FROM "tasks" WHERE "tasks"."appeal_id" = $1 AND "tasks"."appeal_type" = $2 AND "tasks"."status" IN ($3, $4, $5) AND "tasks"."type" = $6 AND "tasks"."assigned_to_type" = $7 AND "tasks"."assigned_to_id" = $8 AND "tasks"."parent_id" = $9 LIMIT $10 [["appeal_id", 1624], ["appeal_type", "Appeal"], ["status", "assigned"], ["status", "in_progress"], ["status", "on_hold"], ["type", "DistributionTask"], ["assigned_to_type", "Organization"], ["assigned_to_id", 5], ["parent_id", 7010], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] DistributionTask Create (2.2ms) INSERT INTO "tasks" ("appeal_id", "appeal_type", "assigned_at", "assigned_to_id", "assigned_to_type", "created_at", "parent_id", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["appeal_id", 1624], ["appeal_type", "Appeal"], ["assigned_at", "2022-02-17 17:01:49.008288"], ["assigned_to_id", 5], ["assigned_to_type", "Organization"], ["created_at", "2022-02-17 17:01:49.008288"], ["parent_id", 7010], ["type", "DistributionTask"], ["updated_at", "2022-02-17 17:01:49.008288"]]
[2022-02-17 11:01:49 -0600] RootTask Update (11.2ms) UPDATE "tasks" SET "placed_on_hold_at" = $1, "status" = $2, "updated_at" = $3 WHERE "tasks"."id" = $4 [["placed_on_hold_at", "2022-02-17 17:01:49.038060"], ["status", "on_hold"], ["updated_at", "2022-02-17 17:01:49.038750"], ["id", 7010]]
[2022-02-17 11:01:49 -0600] PaperTrail::Version Create (0.8ms) INSERT INTO "versions" ("created_at", "event", "item_id", "item_type", "object", "object_changes", "request_id", "whodunnit") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id" [["created_at", "2022-02-17 17:01:49.038750"], ["event", "update"], ["item_id", 7010], ["item_type", "Task"], ["object", "---\nid: 7010\nappeal_id: 1624\nappeal_type: Appeal\nassigned_at: &1 2022-02-17 17:01:48.952944164 Z\nassigned_by_id: \nassigned_to_id: 5\nassigned_to_type: Organization\ncancellation_reason: \ncancelled_by_id: \nclosed_at: \ncreated_at: *1\ninstructions: []\nparent_id: \nplaced_on_hold_at: \nstarted_at: \nstatus: assigned\ntype: RootTask\nupdated_at: *1\n"], ["object_changes", "---\nplaced_on_hold_at:\n- \n- 2022-02-17 17:01:49.038060030 Z\nstatus:\n- assigned\n- on_hold\nupdated_at:\n- 2022-02-17 17:01:48.952944164 Z\n- 2022-02-17 17:01:49.038750589 Z\n"], ["request_id", "5146f9a0-4632-4c9b-aaf2-a01e17127557"], ["whodunnit", "18"]]
[2022-02-17 11:01:49 -0600] AppellantSubstitution Load (0.9ms) SELECT "appellant_substitutions".* FROM "appellant_substitutions" WHERE "appellant_substitutions"."target_appeal_id" = $1 LIMIT $2 [["target_appeal_id", 1624], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] Representative Load (1.0ms) SELECT "organizations".* FROM "organizations" WHERE "organizations"."type" IN ('Representative', 'Vso', 'PrivateBar', 'FieldVso') AND "organizations"."status" = $1 AND "organizations"."participant_id" = $2 [["status", "active"], ["participant_id", "600153863"]]
[2022-02-17 11:01:49 -0600] DistributionTask Update (1.3ms) UPDATE "tasks" SET "assigned_at" = $1, "updated_at" = $2 WHERE "tasks"."id" = $3 [["assigned_at", "2022-02-17 17:01:49.080993"], ["updated_at", "2022-02-17 17:01:49.084579"], ["id", 7011]]
[2022-02-17 11:01:49 -0600] PaperTrail::Version Create (1.3ms) INSERT INTO "versions" ("created_at", "event", "item_id", "item_type", "object", "object_changes", "request_id", "whodunnit") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id" [["created_at", "2022-02-17 17:01:49.084579"], ["event", "update"], ["item_id", 7011], ["item_type", "Task"], ["object", "---\nid: 7011\nappeal_id: 1624\nappeal_type: Appeal\nassigned_at: &1 2022-02-17 17:01:49.008288379 Z\nassigned_by_id: \nassigned_to_id: 5\nassigned_to_type: Organization\ncancellation_reason: \ncancelled_by_id: \nclosed_at: \ncreated_at: *1\ninstructions: []\nparent_id: 7010\nplaced_on_hold_at: \nstarted_at: \nstatus: assigned\ntype: DistributionTask\nupdated_at: *1\n"], ["object_changes", "---\nassigned_at:\n- &1 2022-02-17 17:01:49.008288379 Z\n- 2022-02-17 17:01:49.080993822 Z\nupdated_at:\n- *1\n- 2022-02-17 17:01:49.084579875 Z\n"], ["request_id", "5146f9a0-4632-4c9b-aaf2-a01e17127557"], ["whodunnit", "18"]]
[2022-02-17 11:01:49 -0600] Appeal Update (1.3ms) UPDATE "appeals" SET "establishment_last_submitted_at" = $1, "establishment_submitted_at" = $2, "updated_at" = $3 WHERE "appeals"."id" = $4 [["establishment_last_submitted_at", "2022-02-17 17:01:49.129823"], ["establishment_submitted_at", "2022-02-17 17:01:49.129847"], ["updated_at", "2022-02-17 17:01:49.131568"], ["id", 1624]]
[[::1]] [5146f9a0-4632-4c9b-aaf2-a01e17127557] [localhost] [BVAISHAW ] [ActiveJob] [DecisionReviewProcessJob] [d0264ba2-a79f-448a-b63c-d6e4ac08e6f2] Performing DecisionReviewProcessJob (Job ID: d0264ba2-a79f-448a-b63c-d6e4ac08e6f2) from Shoryuken(caseflow_development_low_priority) with arguments: #<GlobalID:0x00007f7a08577090 @uri=#<URI::GID gid://caseflow-certification/Appeal/1624>>
[2022-02-17 11:01:49 -0600] Appeal Update (1.0ms) UPDATE "appeals" SET "establishment_attempted_at" = $1, "updated_at" = $2 WHERE "appeals"."id" = $3 [["establishment_attempted_at", "2022-02-17 17:01:49.144116"], ["updated_at", "2022-02-17 17:01:49.144835"], ["id", 1624]]
[2022-02-17 11:01:49 -0600] LegacyIssueOptin Load (0.9ms) SELECT "legacy_issue_optins".* FROM "legacy_issue_optins" WHERE "legacy_issue_optins"."request_issue_id" = $1 LIMIT $2 [["request_issue_id", 3013], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] Appeal Update (1.2ms) UPDATE "appeals" SET "establishment_processed_at" = $1, "updated_at" = $2 WHERE "appeals"."id" = $3 [["establishment_processed_at", "2022-02-17 17:01:49.163802"], ["updated_at", "2022-02-17 17:01:49.164532"], ["id", 1624]]
[[::1]] [5146f9a0-4632-4c9b-aaf2-a01e17127557] [localhost] [BVAISHAW ] [ActiveJob] [DecisionReviewProcessJob] [d0264ba2-a79f-448a-b63c-d6e4ac08e6f2] Performed DecisionReviewProcessJob (Job ID: d0264ba2-a79f-448a-b63c-d6e4ac08e6f2) from Shoryuken(caseflow_development_low_priority) in 29.03ms
[2022-02-17 11:01:49 -0600] AppealIntake Update (1.5ms) UPDATE "intakes" SET "completed_at" = $1, "completion_status" = $2, "updated_at" = $3 WHERE "intakes"."id" = $4 [["completed_at", "2022-02-17 17:01:49.175302"], ["completion_status", "success"], ["updated_at", "2022-02-17 17:01:49.176183"], ["id", 5]]
[2022-02-17 11:01:49 -0600] (7.4ms) COMMIT
[2022-02-17 11:01:49 -0600] Veteran Load (1.6ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."id" = $1 LIMIT $2 [["id", 1913], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] Veteran Load (0.9ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] CACHE Veteran Load (0.1ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] CACHE Veteran Load (0.1ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."file_number" = $1 LIMIT $2 [["file_number", "000100005"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] Claimant Load (0.9ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] CACHE Claimant Load (0.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] CACHE Claimant Load (0.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] CACHE Claimant Load (0.2ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] Person Load (1.7ms) SELECT "people".* FROM "people" WHERE "people"."participant_id" = $1 LIMIT $2 [["participant_id", "500001909"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] CACHE Claimant Load (0.1ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] Veteran Load (1.6ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."participant_id" = $1 LIMIT $2 [["participant_id", "500001909"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] CACHE Veteran Load (0.1ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."participant_id" = $1 LIMIT $2 [["participant_id", "500001909"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] CACHE Claimant Load (0.4ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[[::1]] [5146f9a0-4632-4c9b-aaf2-a01e17127557] [localhost] [BVAISHAW ] STARTED VACOLS: appeals_by_vbms_id
[[::1]] [5146f9a0-4632-4c9b-aaf2-a01e17127557] [localhost] [BVAISHAW ] FINISHED VACOLS: appeals_by_vbms_id: 0.001053 0.000155 0.001208 ( 0.001198)
[2022-02-17 11:01:49 -0600] VACOLS::Case Load (0.8ms) SELECT "BRIEFF".* FROM "BRIEFF" WHERE "BRIEFF"."BFCORLID" = :a1 [["bfcorlid", "000100005S"]]
[2022-02-17 11:01:49 -0600] CACHE Veteran Load (0.1ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."id" = $1 LIMIT $2 [["id", 1913], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] RequestIssue Load (1.0ms) SELECT "request_issues".* FROM "request_issues" WHERE "request_issues"."decision_review_id" = $1 AND "request_issues"."decision_review_type" = $2 AND ("request_issues"."ineligible_reason" IS NULL AND "request_issues"."closed_at" IS NULL OR "request_issues"."closed_status" = $3) [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["closed_status", "ineligible"]]
[2022-02-17 11:01:49 -0600] RequestIssue Load (0.9ms) SELECT "request_issues".* FROM "request_issues" WHERE "request_issues"."contested_rating_issue_reference_id" IS NULL AND "request_issues"."contested_rating_decision_reference_id" IS NULL AND ("request_issues"."is_unidentified" = $1 OR "request_issues"."is_unidentified" IS NULL) AND ("request_issues"."verified_unidentified_issue" = $2 OR "request_issues"."verified_unidentified_issue" IS NULL) AND "request_issues"."nonrating_issue_category" IS NOT NULL AND "request_issues"."ineligible_reason" IS NULL AND "request_issues"."closed_at" IS NULL AND "request_issues"."veteran_participant_id" = $3 AND "request_issues"."id" != $4 [["is_unidentified", false], ["verified_unidentified_issue", false], ["veteran_participant_id", "500001909"], ["id", 3013]]
[[::1]] [5146f9a0-4632-4c9b-aaf2-a01e17127557] [localhost] [BVAISHAW ] Retrieving cached value for Appeal#cached_serialized_ratings
[2022-02-17 11:01:49 -0600] DecisionIssue Load (0.9ms) SELECT "decision_issues".* FROM "decision_issues" WHERE "decision_issues"."deleted_at" IS NULL AND "decision_issues"."participant_id" = $1 [["participant_id", "500001909"]]
[2022-02-17 11:01:49 -0600] Appeal Load (0.8ms) SELECT "appeals".* FROM "appeals" WHERE "appeals"."id" = $1 LIMIT $2 [["id", 1624], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] Claimant Load (0.8ms) SELECT "claimants".* FROM "claimants" WHERE "claimants"."decision_review_id" = $1 AND "claimants"."decision_review_type" = $2 ORDER BY "claimants"."id" DESC LIMIT $3 [["decision_review_id", 1624], ["decision_review_type", "Appeal"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] BgsPowerOfAttorney Load (0.7ms) SELECT "bgs_power_of_attorneys".* FROM "bgs_power_of_attorneys" WHERE "bgs_power_of_attorneys"."claimant_participant_id" = $1 LIMIT $2 [["claimant_participant_id", "500001909"], ["LIMIT", 1]]
[2022-02-17 11:01:49 -0600] Completed 200 OK in 607ms (Views: 1.0ms | ActiveRecord: 166.8ms)
```
Sign in with Wallet
Connect another wallet