Table: Pre Appointment Documents
Primary Key: Pre
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Pre Appointment Document ID | Long | 4 | ✓ | |
| Pre Appointment Document Category ID | Long | 4 | ||
| Pre Appointment Document | Text | 50 | ||
| Source | Text | 255 | ||
| Version | Double | 8 | ||
| Quantity | Long | 4 | ||
| Document Type | Long | 4 | ||
| Cost | Double | 8 | ||
| Default Document | Boolean | 1 | ||
| Sort Order | Long | 4 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Pre Appointment Documents$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Pre Appointment Documents$Telephone Interview Question ID
- Pre Appointment Documents$TI Question Category ID