FO_Species
Each record in this table represents a single species definition. The species code value must be a unique entry in this table.
| Field | Type | Notes |
|---|---|---|
|
Species_ID |
int |
ID field, a counter. Unique |
|
Code |
varchar(50) |
Enter a unique species code. |
|
Name |
varchar(50) |
Species name. |
|
Need_DOB |
int |
Flag that determines if DOB is required. Enter 0 or 1 0 = DOB is not required 1 = DOB is required Informational - Future Use |
|
Need_Sex |
int |
Flag that determines if gender is required. Enter 0 or 1 0 = gender is not required 1 = gender is required Informational - Future Use |
|
Need_Marital |
int |
Flag that determines if marital status is required. Enter 0 or 1 0 = marital status is not required 1 = marital status is required Informational - Future Use |
|
Need_Address |
int |
Flag that determines if address is required. Enter 0 or 1 0 = address is not required 1 = address is required Informational - Future Use |
|
veterinary |
varchar(1) |
Flag that determines if veterinary specimen is required. Enter N or Y N = veterinary specimen is not required Y = veterinary specimen is required Informational - Future Use |
|
SourceSystem |
varchar(50) |
Default system/vendor/version ID for this species. Enter a valid ID. Connects to the organization source system definitions. |