region_kid | Unsigned | 0x000000 | 0x000000 | Region identification number for this record |
region_parent | Unsigned | 0x000008 | 0x000000 | Region owning this region |
region_enabled | Boolean | 0x000010 | 0x000000 | Is this region enabled? |
region_name | String | 0x000011 | 0x000000 | Displayable name of the region |
region_symbol | String | 0x000052 | 0x000000 | Short name of the region for reports |
region_home | String | 0x00005B | 0x000000 | URL of the regions home page |
region_url | String | 0x0000C0 | 0x000000 | URL of the regions entry pages |
score_rule_prelim | Unsigned | 0x000128 | 0x000000 | Rules for handling preliminary score calculations |
score_rule_finals | Unsigned | 0x000130 | 0x000000 | Rules for handling final score calculations |
coord_user_kid | Unsigned | 0x000138 | 0x000000 | Regional Coordinator user_kid |
coord_name | String | 0x000834 | 0x000000 | Regional Coordinator name |
coord_email | String | 0x000875 | 0x000000 | Regional Coordinator email address |
coord_phone | Phone Number | 0x000140 | 0x000000 | Regional Coordinator phone number |
judge_user_kid | Unsigned | 0x000158 | 0x000000 | Regional judging coordinator user_kid |
judge_name | String | 0x0008B6 | 0x000000 | Regional judging coordinator name |
judge_email | String | 0x0008F7 | 0x000000 | Regional judging coordinator address |
judge_phone | Phone Number | 0x000160 | 0x000000 | Regional judging coordinator phone number |
school_user_kid | Unsigned | 0x000178 | 0x000000 | Regional school coordinator user_kid |
school_name | String | 0x000938 | 0x000000 | Regional school coordinator name |
school_email | String | 0x000979 | 0x000000 | Regional school coordinator address |
school_phone | Phone Number | 0x000180 | 0x000000 | Regional school coordinator phone number |
mail_server | String | 0x000214 | 0x000000 | Mail server to use to send the email |
mail_port | Unsigned | 0x000298 | 0x000000 | Mail server port number |
mail_ssl | Boolean | 0x0002A0 | 0x000000 | Use SSL when sending the meail message? (Y/N) |
mail_username | String | 0x0002A8 | 0x000000 | Username for signing into the mailbox |
mail_password | String | 0x0002E9 | 0x000000 | Password for signing into the mailbox |
mail_address | String | 0x000193 | 0x000000 | EMail address for this region |
options | 32-bit bitmap | 0x000330 | 0x000000 | Region options |
promote_limit | Unsigned | 0x000338 | 0x000000 | Number of teames accepted from sub-regions |
competition_type | Unsigned | 0x000340 | 0x000000 | What competition is held in this region |
finals_dt | Date | 0x000348 | 0x000000 | Final competition date |
awards_dt | Date | 0x000350 | 0x000000 | Special awards competition date |
release_dt | Date | 0x000358 | 0x000000 | When are scores released to judges and teachers |
region_prefix | String | 0x000360 | 0x000000 | URL and File prefix to access region |
finals_location | String | 0x000381 | 0x000000 | Location of finals competition |
map_link | String | 0x0004AE | 0x000000 | Link to map for finals location |
path | String | 0x0005DB | 0x000000 | A shorthand representation of the linkage of thi category |
name_path | String | 0x00062C | 0x000000 | The full name of this category with all parent and children names |
depth | Unsigned | 0x000680 | 0x000000 | The number of levels deep for this cetegory |
child_count | Unsigned | 0x000688 | 0x000000 | Number of child categories for this category |
modified_user | String | 0x000690 | 0x000000 | Who modified this record last |
modified_ts | Timestamp | 0x0006E0 | 0x000000 | When was this record last modified |
upload_path | String | 0x0006E8 | 0x000000 | Location to store file uploaded |
download_path | String | 0x000769 | 0x000000 | Logical path to files for download |
parent_name | String | 0x0007EA | 0x000000 | Name of the region owning this region |
action | Char | 0x0009BA | 0x000000 | Used in the editing process |