| Field | Description | Type | Null | Limits | Size | Key | Default | Authority | Source |
|---|---|---|---|---|---|---|---|---|---|
| ID | Unique ID for each record in the map. The values here should not be assigned by external programs. Instead it can either be ignored, or NULL can be inserted, and the database will automatically assign the next ID. | INT(10) unsigned auto_increment | Not Null | Primary Key | db server | ||||
| SOURCE_FILE_NAME | The source filename should be the DAT file derived from the out (or im) file. This should only be the name of the file, no paths should be included here. This field matches the Source_File_Name field in the EDR_Products table. | VARCHAR(255) | EDR SIS | EDRgen | |||||
| Source_Pathname | The full path and filename of the .out (or .im) file that the DAT files are created from. The data in this field should match the Source_Pathname column found in the EDRgen_Sources table. | TEXT | Not Null | EDR SIS | EDRgen | ||||
| LAST_UPDATE | This column records the last time that a record was updated. | TIMESTAMP | db server |
Table Options:
This page was generated from the XML HiCat Data Dictionary.
Please send comments to: HiCat@pirlmail.lpl.arizona.edu.