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

Create Sequence Number Logic in SQL file #56

Open

Kibrael opened this issue Feb 21, 2019 · 0 comments

Assignees

Contributor

Kibrael commented Feb 21, 2019

The LAR data from 2016 and prior had a Sequence Number element. Sequence Number is a stand-in for Loan ID which is redacted for privacy reasons.

Create a SQL script to populate a Sequence Number in the 2017 LAR data.

The logic for a Sequence Number is either:

a serial integer from 1 to N for all LAR records
an integer that is serial 1 to N for each ARID combination

Determine what was done in 2016 and 2015 and match that approach for consistency of use.

Kibrael assigned MichaelFurey17

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment