Complete Loan Status

Owned by Katie Macpherson (Deactivated)
Feb 20, 2018

In order to be considered "Complete" the loan must:
1. Must have First Name and Last Name and it be valid (passed the Regular Expression ([0-9A-Z-'\\s
.]){1,12} meaning no punctuation characters etc.)
2. Must have an SSN (9 digit of 0-9) and it be between 1010001 and 999999998
3. Must have a Date of Birth and it be between 01/01/1910 and 12/31/2001
4. Must have an "Original" address (Address Line 1, City, State, Postal Code)
5. If the Loan is a Plus or GradPlus Loan it must have the Borrower information filled out

  1. Must have First Name and Last Name and it be valid (passed the Regular Expression ([0-9A-Z-'\\s
    .]){1,12} meaning no punctuation characters etc)
  2. Borrower must have SSN and it be valid (SSN (9 digit of 0-9) and it be between 1010001 and 999999998)
  3. Must have a Date of Birth and it be between 01/01/1910 and 12/31/2001
  4. Must have Address Line 1, City, State, Postal Code
  5. If a phone number is listed it needs to be valid ([0-9]{0,17})
  6. Borrower must have a Citizenship value.
  7. If the Default Overpay Code exists make sure it's Y/N/Z
  8. If there is an email address make sure it's valid. (^[_A-Za-z0-9-](
    .[_A-Za-z0-9-]    )@[A-Za-z0-9-](\\.[A-Za-z0-9-])(
    .([A-Za-z]){2,4})$ and < 128 in length

6. Require CPSTransactionNumber (should be set if student has an ISIR)
7. If Origination Fee Percent exists, make sure it's between 0 and 100
8. If Interest Rebate Percent exists, make sure it's between 0 and 100
9. Federal Award Year value required
10. Financial Award Id required
11. Financial Award Amount should be between 0 and 99999999.99
12. Financial Award Create Date should exist and be between 01/01/1901 and 12/31/2099
13. Financial Award Number should be between 1 and 999
14. Fund setup of Loan should not have FundType of "Other"
15. Dependency Status Code must be set
a. For GradPLUS, status must not be Independent
b. For Plus, status must not be Dependent
16. Default Overpay Code must be set and be valid [Y/N/Z]
17. For Sub and Unsub, first Disbursement should "number" should be between 1 and 20
18. For Plus and GradPLUS, first disbursement should be between 1 and 4
19. Disbursement sequence numbers should be between 1 and 65
20. Disbursement Amount, Net Amount, Fee Amount, and Rebate amount should be between 0 and 99999999.99