| Column Name | Type | Length | Nullable | Description | Relationships | |
| Identity | ID | int identity | No | |||
| Medid | varchar | 16 | Yes | |||
| LastName | varchar | 20 | Yes | |||
| FirstName | varchar | 10 | Yes | |||
| MI | varchar | 1 | Yes | |||
| Confirmno | numeric | Yes | ||||
| Startdate | datetime | Yes | ||||
| STARTJDATE | numeric | Yes | ||||
| Stopdate | datetime | Yes | ||||
| STOPJDATE | numeric | Yes | ||||
| PROCED0 | varchar | 5 | Yes | |||
| QUANAPP | numeric | Yes | ||||
| AMNTAPP | money | Yes | ||||
| QUANUSE | numeric | Yes | ||||
| AMNTUSE | numeric | Yes | ||||
| PROVIDER | varchar | 4 | Yes | |||
| STATUS | varchar | 1 | Yes | |||
| INVNUM | varchar | 8 | Yes | |||
| PROVNUM | varchar | 8 | Yes | |||
| CATEGORY | varchar | 4 | Yes | |||
| REASON | varchar | 2 | Yes | |||
| PADELETE | varchar | 1 | Yes | |||
| LASTDATE | datetime | Yes | ||||
| DAYS | numeric | Yes | ||||
| RATE0 | money | Yes | ||||
| RENPROV | varchar | 8 | Yes | |||
| XUPDATE | datetime | Yes | ||||
| XUPJDATE | numeric | Yes | ||||
| LASTSTAT | varchar | 1 | Yes | |||
| OLDPROC | varchar | 5 | Yes | |||
| PROCED1 | varchar | 5 | Yes | |||
| CATEG1 | varchar | 4 | Yes | |||
| RATE1 | money | Yes | ||||
| QUANAPP1 | numeric | Yes | ||||
| DAYS1 | numeric | Yes | ||||
| AMNTAPP1 | money | Yes | ||||
| PROCED2 | varchar | 5 | Yes | |||
| CATEG2 | varchar | 4 | Yes | |||
| RATE2 | money | Yes | ||||
| QUANAPP2 | numeric | Yes | ||||
| DAYS2 | numeric | Yes | ||||
| AMNTAPP2 | money | Yes | ||||
| PROCED3 | varchar | 5 | Yes | |||
| CATEG3 | varchar | 4 | Yes | |||
| RATE3 | money | Yes | ||||
| QUANAPP3 | numeric | Yes | ||||
| DAYS3 | numeric | Yes | ||||
| AMNTAPP3 | money | Yes | ||||
| KEYDATE | numeric | Yes | ||||
| PADELETE1 | varchar | 1 | Yes | |||
| PADELETE2 | varchar | 1 | Yes | |||
| PADELETE3 | varchar | 1 | Yes | |||
| ESCORT | varchar | 1 | Yes | |||
| PCA | varchar | 1 | Yes | |||
| RENEW | bit | Yes | ||||
| CONVERT | varchar | 1 | Yes | |||
| ERRSTAT | varchar | 1 | Yes | |||
| NEWPA | numeric | Yes | ||||
| STATUS1 | varchar | 1 | Yes | |||
| STATUS2 | varchar | 1 | Yes | |||
| STATUS3 | varchar | 1 | Yes | |||
| LASTSTAT1 | varchar | 1 | Yes | |||
| LASTSTAT2 | varchar | 1 | Yes | |||
| LASTSTAT3 | varchar | 1 | Yes | |||
| KEYDELDATE | datetime | Yes | ||||
| PTMSUSER | varchar | 30 | Yes | |||
| FIRSTDATE | datetime | Yes | ||||
| Destination | varchar | 50 | Yes | |||
| FIRSTUSER | varchar | 30 | Yes | |||
| PREVUPDATE | datetime | Yes | ||||
| PREVSTATUS | varchar | 1 | Yes | |||
| PROVTYPE | varchar | 3 | Yes | |||
| PANUM | varchar | 15 | Yes | |||
| REQVER | varchar | 1 | Yes | |||
| CANCTR | numeric | Yes | ||||
| NPI | varchar | 12 | Yes | |||
| Verified | bit | Yes | ||||
| Timestamp | datetime | Yes | ||||
| DestinationID | numeric | Yes | ||||
| ClientID | varchar | 10 | Yes | |||
| ReferenceNumber | varchar | 20 | Yes |
| Index Name | Index Description | Index Keys |
| PK_NYPriorApprovals | clustered, unique, primary key located on PRIMARY | ID |
| U_MedidConfirmno | nonclustered, unique located on PRIMARY | Medid, Confirmno |