6
6. The OU Soccer club wants to have tournament. Every player must be registered with the club (Name, Phone, Address). A player can enter a team by registering and paying an entry fee, and registering all the players for the team. The club wants to record payments from the team and expenses paid out. Journal entries of each payment list Team Number, Date and Amount. Debit payments list Payee and Authorizing Person.
General Instructions:
Tables must be filled in as follows:
MEMBER: There should be a member for every person in your team, so if you are in a 6 person team, you should include them all in this table with their real names, but the rest of the information can be made up. The members of the other teams can contain fictitious names other than your team members’ names and should not be less than 3 person per team.
TEAM: There should be at least 5 teams to play in the tournament. You may use the following links for famous team names and players if you are not familiar with the sport:
or make up your own.
MEMBER-TEAM: Roles should be assigned for every team member. You may find this at: or make up your own.
JOURNAL: Payments are made by the teams for different charges and then spent for expenses such as energy drinks, playing gear, balls, etc. There should be a minimum of 12 journal records recorded. Same teams may have more than 1 payment for different dates. They can be a combination of either PAYMENT-IN or DEBIT-OUT.
Coding Specifics:
MEMBER:
ID (PK): Nine digit unique numerical value, every effort should be made to obtain the social security number. This item is used by the system to match and consolidate records. If the social security number is not available or unknown, enter 5 9's in this position and follow this by your last 4 digits of your OU ID number. Do not use 8's or 0's for an unknown social security number. Do not put dashes or slashes in this field. Dashes are automatically added.
Ex: If social security number available: 123456789
If social security number NOT available: 999991234
Name: Enter members last names, first, and middle. Must be in the format: last name, first name and middle initial. Hyphens, spaces, and other special characters are not allowed.
Ex: John Richard Smith = Smith, John R
Address: Enter address of the team member. Must be in the format: Number and Street, City, State, ZIP Code.
▪ Enter the number and street of the member at time of registration in 25 characters or less. Only use the post office box or the rural mailing address when the physical address is not available. Punctuation marks are not allowed in this field. If the address contains more than 25 characters, omit the least important elements, such as the apartment or space number. Do not omit elements needed to locate the address in a census tract, such as house number, street, direction or quadrant, and street type.
Ex: 1232 Southwest Independence Apartment 400
ENTER AS: 1232 SW Independence 400
▪ Enter the appropriate two letter abbreviation for state of residence at the time of admission. If resident of foreign country, enter the appropriate two letter abbreviation for country of residence at admission. If resident of a country other than Canada or the United States code “XX”. If it is known that the patient is not a resident of Canada or the United States, and the country of residence is unknown code “YY”.
AL Alabama
AK Alaska
AZ Arizona
AR Arkansas
CA California
CO Colorado
CT Connecticut
DE Delaware
DC District of
Columbia
FL Florida
GA Georgia
HI Hawaii
ID Idaho
CN Canada
IL Illinois
IN Indian
IA Iowa
KS Kansas
KY Kentucky
LA Louisiana
ME Maine
MD Maryland
MA
Massachusetts
MI Michigan
MN Minnesota
MS Mississippi
MO Missouri
MX Mexico
MT Montana
NE Nebraska
NV Nevada
NH New Hampshire
NJ New Jersey
NM New Mexico
NY New York
NC North Carolina
ND North Dakota
OH Ohio
OK Oklahoma
OR Oregon
PA Pennsylvania
RI Rhode Island
SC South Carolina
SD South Dakota
TN Tennessee
TX Texas
UT Utah
VT Vermont
VA Virginia
WA Washington
WV West Virginia
WI Wisconsin
WY Wyoming
Phone: Enter phone number of team member. Must be in numerical format and contain 3 digit area code and 7 digit phone number. No spaces must be left in between. Hyphens, spaces, and other special characters are not allowed.
Ex: 4053251234
TEAM
TeamNum (PK): Numeric value generated automatically every time a new team is introduced.
Name: Name used to identify the teams registered to play. Must contain 25 characters or less and Hyphens, spaces, and other special characters are allowed.
Ex: Manchester United
MEMBER-TEAM
ID (PK) (FK): Must be the same value as the one introduced for ID in table MEMBER.
TeamNum (PK) (FK): Must be the same value as the one introduced for TeamNum in table TEAM.
Role: Team members’ role description. There must be a role identified for every team member introduced. Role descriptions may include mid fielder, defender, goal keeper, forward or other.
Ex: goal keeper
JOURNAL
JNum (PK): Numeric value generated automatically every time a new journal is introduced.
TeamNum (FK): Must be the same value as the one introduced for TeamNum in table TEAM.
Date: Date the journal was recorded: (MMDDYYYY) Punctuation marks (slashes, dashes, etc) are not allowed in any date field. Date MUST BE CODED. Journals cannot be processed without the date. Enter month, day, and year accordingly. The year must be coded in full.
Ex: January 1, 1954 = 01011954
Amount: The numerical amount paid at the moment of registration.
Ex: 20
PAYMENT-IN
JNum (PK): Numeric value generated automatically every time a new journal is introduced that must match with corresponding JNum in table JOURNAL.
TeamNum (FK): Must be the same value as the one introduced for TeamNum in table TEAM.
DEBIT-OUT
Jnum (PK): Numeric value generated automatically every time a new journal is introduced that must match with corresponding JNum in table JOURNAL.
Payee: The person to whom money is to be, or has been, paid. Must contain 25 characters or less and Hyphens, spaces, and other special characters are NOT allowed.
AuthorizingPerson: Person authorizing the payment. Must contain 25 characters or less and Hyphens, spaces, and other special characters are NOT allowed.
-----------------------
MEMBER-TEAM
ID (PK) (FK)
TeamNum (PK) (FK)
Role
MEMBER
ID (PK)
Name
Address
Phone
JOURNAL
JNum (PK)
TeamNum (FK)
Date
Amount
TEAM
TeamNum (PK)
Name
PAYMENT-IN
JNum (PK)
TeamNum (FK)
DEBIT-OUT
JNum (PK)
Payee
AuthorizingPerson
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- 6.8 v10 vs 6.2 v8
- 6.2 ford vs 6.8 ford
- macmillan english 6 unit 6 wirksheet student key to correction
- macmillan english 6 unit 6 worksheet student key to correction
- 6 8 v10 vs 6 2 v8
- 6 2 ford vs 6 8 ford
- mark 6 1 6 commentary
- 6 5 vs 6 8 ballistics chart
- 6 6 liters to cubic inches
- dunkin donuts buy 6 get 6 free
- 6 6 prc ammo for sale
- is a 6 6 a1c good