Below is the glossary for the reports available within the Play Football Administration portal. 

 

Report

Fields within report

Admin User List

 

Found through REPORTS > Enterprise Reports > Organisation Reports

More information available here

Registration Transaction Report

 

Found through REPORTS > Enterprise Reports > Transaction Reports

More information available here

Registration Product Report

 

Found through REPORTS > Enterprise Reports > Transaction Reports

player_id, player_name, entity_name, entity_id, purchased_item_Id, customer_id, invno, item_category_id, item_id, item_description, qty, price, currency, itemtotal, purchaser_comment, admin_comment, payment_method_id, update_user_id, date_updated, invoice_id, tax_amount, item_name, valid_from, valid_to, payment_status_id, date_shipped, sel_entity_id, sel_team_id, sel_team_name, submission_id, pricing_description, product_type, payment_status_desc, purchase_date, source_template_id, address1, address2, suburb, postcode, state, country, player_dob, home_phone, work_phone, mobile_phone, player_email, school_name, gender, emergency_contact_name, emergency_contact_number, pg_id, pg_first_name, pg_last_name, pg_dob, pg_email, pg_mobile, pg_address1, pg_address2, pg_suburb, pg_postcode, pg_state, pg_country

All Details Report

 

Found through REPORTS > Enterprise Reports > Transaction Reports

Member Federation, District Association, Association, Club, FFA Number, player_id, First Name, Middle Name, Last Name, DOB, Gender, Country Of Birth, Nationality, Disability, Indigenous, Marketing Opt Out (FFA), Marketing Opt Out (Fed), Marketing Opt Out (Region), Marketing Opt Out (Assoc), Marketing Opt Out (Club), Email, Mobile, Home Phone, Work Phone, Address1, Address2, Address3, Suburb, State, Postcode, Emergency 1 First Name, Emergency 1 Phone 1, Emergency 1 Phone 2, Emergency 1 Email, Emergency 2 First Name, Emergency 2 Phone 1, Emergency 2 Phone 2, Emergency 2 Email, Season, Registration Category, Age Group Applied, Notes, Registration Status, Registration Sub Status, Self Registered, Registration Date, Status Changed Date, Team Name, Age Group, Division, Team Number, School, Contract Start Date, Contract End Date, Previous National Association, Previous Club Name, Previous Year Played, Invoice No, Package, Payment Method, Add_ons, Package Amount, Payment Date, Role, Sub Role, Reg Type, reg_type_id, WWC Status, Current WWC Accreditation, State Body WWC held, WWC Number, WWC Expiry Date, WWC Type, Do you have a WWC Accreditation Exemption, WWC Accreditation Exemption Reason, Accept the Member Declaration Policy, WWC Accreditation Application #, WWC Accreditation Application Status Comment, Comp Level, Football Type, Has Photo

Financial Reports

 

Found through REPORTS > Enterprise Reports > Transactions Reports

Member Federation, District Association, Association, Club Name, FFA Number, First Name, Last Name, DOB, Gender, Reg Period, Football Type, Reg Type Name (FFA), Reg Type Name (MF), Reg Type Name (Assoc), Product Name, Total Payment, Transaction Fee - Registrant Paid, Transaction Fee - Org Absorbed, FFA Fee, MF Fee, Other Aff Fee, Assoc Fee, Club Fee, Additional Items Fee, GST, Discount FFA, Discount MF, Discount Other Affiliates, Discount Assoc, Discount Club, Role, registration_status, Reg Status, Reg Sub-Status, Reg Date, Active Date, Invoice Number, Payment Status, Payment Method, payment_method_id, Payment Date, Online Payment Reference, Disbursal Recipient, Zero $ Payments, Transaction Fee Absorbed

Registration Detail Report

 

Found through REPORTS > Enterprise Reports > Transactions Reports

reg_entry_id, FFA Number, Date Registered, Date Registered, Date Active, Date Deregistered, Club Entity ID, Member Federation Name, Assoc/Affiliate Name, Club Name, IAS ID, Firstname, Lastname, DOB, Age in years, Gender, Postcode, Email, Payment Status, Total invoice_Payable, FFA_Payable, MF_Payable, Assoc_Payable, Club_Payable, Add On, ZeroProduct, Nat Reg Type Name, State Reg Type Name, 

Detail Report

 

Found through REGISTRATION > Registration Management > Display Registrations > Download Detail Report

 

reg_entry_id, FFA Number, Date Registered, Date Active, Date Deregistered, Club Entity ID, Member Federation Name, Assoc/Affiliate Name, Club Name, IAS ID, Firstname, Lastname, DOB, Age in years, Gender, Postcode, Email, Payment Status, ZeroProduct, Nat Reg Type Name, State Reg Type Name, Assoc/Affiliate Reg Type Name, Product Name, Add On Name, Reg Status Primary, Reg Status Secondary, Football Type, Playing Level, Role Name, Registration Category, Registration Channel, Assoc/Affiliate Reg Type Name, Product Name, Add On Name, Reg Status Primary, Reg Status Secondary, Football Type, Playing Level, Role Name, Registration Category, Registration Channel

Summary Report

 

Found through REGISTRATION > Registration Management > Display Registrations > Download Summary Report

entity_id, entity_name, entity_type_id, tot_reg_fee, association_reg_fee, state_Reg_fee, nat_Reg_fee, invoice_total, association_fee_paid, state_fee_paid, national_fee_paid, total_reg_disburse, tot_proc_fee, club_disburse

Invoice Detail Report

 

Found through REPORTS> Invoice Detail

reg_entry_id, FFANumber, Firstname, Lastname, ClubEntityID, Member Federation Name, Association/Affiliate Name, Club Name, IPSIRef, invoice_id, Payment Method, Payment Date, Total Payable, FFA_paid, MF_paid, Assoc_paid, Club_paid, Processing fee, AKV#, Zero Product