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:
1) a serial integer from 1 to N for all LAR records
2) 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.
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: 1) a serial integer from 1 to N for all LAR records 2) 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.