Concepts for the TLA Program

1. need to be able to deal with two types of TLA announcements. May require two different entry forms.

1. individual tournament TLA
2. multiple tournament TLA

2. Basic Single tournament information

1. Must be able to generate properly formatted magazine ad
2. Must be able to calculate Grand Prix points
3. Should be able to used by two or more users
4. Recommend linked forms for tournament and section information
5. Web design to have good explanation or help with lots of error checking
6. Will be used to produce fide registration reports
7. Goal here is to get form that will work for most events and then add specialty events

Multiple entry forms – first tournament information, then section information.

Fields needs and comments Tournament information form

Field	Type	Required	comments
TLA #	numeric	y	unique #, should be provided by computer yymmddxxx (ending date plus axx) a is character, x is number.
Sponsoring Affiliate #	char	y	should access our database to insure valid number (exists and current) – notify operator if not valid and set invalid AFF.
Affiliate name	text		look up from affiliate file
Affiliate email address	Text		Append to affiliate file if not there
Affilliate phone #	Number or text	y	Required so we can contact if necessary
Affiliate authorizing officer name	Text	Y	Name of person responsible for event – should be someone in affiliate list.
Name of Event	Text	Y
State	Text	Y	Select: State where event will be held
Site name	Text
Site address	Text		Multiple fields
Site phone	?		Phone number of site
Hotel rates	Text
Directions	Text		Directions to site
Format	Text	Y	Select: Swiss, RR, other?
Rating System	Text	Y	Select: Regular or Quick - if R, enable K field
Rating K value	Text		Select: Full or Half – full is default
GP	Logic	na	Computer will calculate if yes or no
EGP	Logic		Enhanced Grand Prix - Check if yes – changes GP calculation
USCF Tour	Logic		Check if yes – automatic yes if EGP is yes
CTD ID #	Number		Optional USCF ID# of Chief TD - notify operator if not valid set invalid td
Starting Date	Date	Y	Starting date of event
Ending date	Date	Y	Ending date of event
Start issue	Text	Y	Select month - 1^st issue tla appears - error check, notify operator if problem
# of issues	Number	Y	# of issues to appear repeat error check if >1
Magazines	Text	Y	Select: CL, SM, both
Heritage event	Logic		Check if yes
# of rounds	Number	Y	Enter number or ? if varies by section – if ? will ask in section forms
# of sections	Number	Y	Use to control entry of section information.
NS	Logic		Check if no smoking
NC	Logic		Check if no computers allowed
LS	Logic		Check if limited smoking
W	Logic		Check if wheelchair access available
Total Prize Fund	Number	na	Calculated from prize fields
Prize conditions	Text		Select : guaranteed, partial guar. Or Based on – may have separate b/o for sections with ability to include based on count
GP Points	Number		Calculated from prize fields and EGP field refer to GP table
Primary Time control Three fields	Text	*1	Primary time control or ? if varies by section. – if ? will ask in section forms see time control note
Second time control Three fields	text	*1	Secondary time control or ? if varies by section. – if ? will ask in section forms see time control note
Final time control One field	Text	*1	Final time control or ? if varies by section. – if ? will ask in section forms see time control note
Address for advance entrees	Text	Y	Multiple fields – should have capability to duplicate affiliate info
Name for advance entries	Text	Y	should have capability to duplicate affiliate info if operator says yes
Phone # for advance entries	?		should have capability to duplicate affiliate info if operator says yes
e-mail for advance entries	Text
State membership req	Logic		Check if yes – enable how much if yes
State how much	Text		Cost of state membership(s)
Other States OK	Logic		Check if yes.
Other information end	Text		This text will appear at end of event area of tla
Other membership req	Logic		Check if yes
Other information start	Text		Comments to appear between name and #rds/type designation
Compliance agreement	Logic	Y	Must be checked yes to indicate compliance with statement

*1 Time control note – one of three must be filled out. First two will be for moves per minute or hour. third for sudden death. First two will actually be three fields ( moves, time, select hr or min.)

Allow capability to check block to correct information in our database such as affiliate address etc. set change of address and enter information. Security implications.

When affiliate # is inputed, a screen is displayed with information. Allow operator to add missing information. Tell them to contact uscf if incorrect or see previous paragraph.

Section information

Field	Type	Required	comments
Section Name	Text	Y
Open to all	Logic		Check if NO entry restrictions – must be checked to qualify prizes for GP events
Additional information start	Text		Follows section name – usually description of who can enter section
Early Entry fee	Number
EEF Date	Date		Cutoff for receipt of early entries for reduced EF
Site Entry Fee
1^st prize	Number		Overall prize
2^nd prize	Number		Overall prize
nnth prize	Number		Last overall prize - may more then 3 overall prizes
1^st restricted prize	Number		Prize restricted by rating
1^st rp restriction type	Text		Select: upper boundary, upper and lower, unrated, other
Upper boundary	number
Lower boundary	number
@@@@ repeat for other restricted prizes
Rounds	Text		Round times
Add info end	Text		At end of section info – can be used for complete description

Prize information must be completed in correct boxes for the GP calculations to work. See GP calculation sheet for GP calculations and GP chart

May want a box to cause entered information except for selected fields to be carried over into next section form. My Idea is to fill out a form for each section.

All entry form – used where everything is the same for all sections or for

Field	Type	Required	comments
Additional information start	Text		Follows end of last section – operator can enter any special information
Early Entry fee	Number
EEF Date	Date		Cutoff for receipt of early entries for reduced EF
Site Entry Fee
Registration times			Use info area of section form for special times to that section
Round times			Use info area of section form for special times to that section
Add info end	Text		At end of section info – can be used for complete description