Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Income Discrepancies in HAVEN (Deductions as well). #8

Open
pegasus4848 opened this issue Nov 26, 2018 · 1 comment
Open

Income Discrepancies in HAVEN (Deductions as well). #8

pegasus4848 opened this issue Nov 26, 2018 · 1 comment

Comments

@pegasus4848
Copy link

  1. Functional Requirements - Decide which Income (Deduction) records are to be extracted from CURAM: "verified" "in edit" "end dated" and "multiple identical income records for the same case"
  2. Technical Requirements - [translate "multiple identical income records for the same case" into use of DENSE_RANK over EVIDENCEDESCRIPTOR.SUCCESSIONID]. A sample:
    CASEID, PARTICIPANTID, STATUSCODE, RECEIVEDDATE,EFFECTIVEFROM, CORRECTIONSETID, SUCCESSIONID, RELATEDID, EVIDENCETYPE
    -9223245902255226880 2552893067132665856 EDS1 11-MAY-16 18027042 18015248 3901648845460733952 DET0026030
    -9223245902255226880 2552893067132665856 EDS1 11-MAY-16 01-JUL-16 18027043 18015248 472157729218101248 DET0026030
  3. Collect data samples for all cases and expected results.
  4. Test for expected results.
@pegasus4848
Copy link
Author

Corrections made to income and deduction procedures. Tests passed. (See attached files - Trevor know the password to open the files
IncomesTest.docx
DeductionsTest.docx

.)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@pegasus4848