E-hailing App Provider Registration - Excel Test Pack (open these CSVs in Excel)

This folder contains CSV sheets you can open in Microsoft Excel (Data > From Text/CSV):

1) TestCases.csv            → Master list of executable test cases (one row per case)
2) TestData_Providers.csv   → Sample provider and proxy data for use in cases
3) TestData_Certificates.csv→ Sample certificate expectations
4) SQL_Probes.sql           → Reusable SQL statements to validate DB state after tests

Tips for Excel:
- When importing CSVs, set the delimiter to comma and text qualifier to double quotes.
- After opening, Save As an .xlsx workbook if you want multiple sheets in one file.
- Freeze Panes on the header row, apply filters, and use conditional formatting for quick triage.

Assumptions:
- ApplicationRequestTypeIDs: 60 (New), 61 (Renewal), 62 (Amend Conditions)
- Required documents (IDs): 1047, 5001, 2007, 1059 (POP), 6001 (Type Approval)
- Certificate number format: NPTR-EHP-YYYY-#### (sequential per year)
- Registry view: Verified.Vw_ProviderRegistry uses latest certificate per provider

Execution order suggestion:
1) Run a quick smoke with TC-001..TC-007 to validate navigation & start flow
2) Execute New → Verify → Approve → Issue certificate (TC-010..TC-018)
3) Execute Registry search validations (TC-030..TC-036)
4) Execute Renewal and reissue checks (TC-040..TC-048)
5) Execute Amend Conditions (TC-050..TC-056)
6) Negative/security/audit (TC-060+)