Name: survey
Display Field:
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)
Drawing Info:
{"labelingInfo":null,"renderer":{"label":"Survey Point","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false
HasM: false
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: objectid
Unique ID Field:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field:
Fields:
- objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- organisation (type: esriFieldTypeString, alias: Organisation: , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- name_of_organisation_representa (type: esriFieldTypeString, alias: Name of Organisation Representative: , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- position_held_in_organisation (type: esriFieldTypeString, alias: Position held in Organisation: , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- date_ (type: esriFieldTypeDate, alias: Date: , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- what_program_are_you_applying_f (type: esriFieldTypeString, alias: What program are you applying for?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Your School, Your Club: Your School, Your Club], [Building Better Sports Faciliti: Building Better Sports Facilities], [Safety at Sports Grounds: Safety at Sports Grounds], ... 1 more ...)
- field_20_0 (type: esriFieldTypeString, alias: List of current committee members/trustees/directors?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No_: No ], [Not Sure_: Not Sure ])
- field_20_1 (type: esriFieldTypeString, alias: Financial Procedures Policy within your organisation? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No_: No ], [Not Sure_: Not Sure ])
- field_20_2 (type: esriFieldTypeString, alias: Policy on Fraud Prevention?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No_: No ], [Not Sure_: Not Sure ])
- field_20_4 (type: esriFieldTypeString, alias: Procurement Policy in relation to purchasing goods and services? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No_: No ], [Not Sure_: Not Sure ])
- is_the_organisations_policy_on (type: esriFieldTypeString, alias: Is the organisation's policy on travel expenses set out in writing? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes_: Yes ], [No_: No ], [Not Sure_: Not Sure ])
- does_include_agreed_rates (type: esriFieldTypeString, alias: Does include agreed rates? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- _can_you_confirm_the_following (type: esriFieldTypeString, alias: Can you confirm the following: , SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- are_payments_made_in_arrears_an (type: esriFieldTypeString, alias: Are payments made in arrears and receipts included in an organisation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- have_all_policies_and_procedure (type: esriFieldTypeString, alias: Have all policies and procedures been approved and signed off as fit for purpose by the Management Committee?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- is_there_separation_of_key_fina (type: esriFieldTypeString, alias: Is there separation of key financial duties within the organisation (For example; Order, Receipt & Payment), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No_: No ], [Not Sure_: Not Sure ])
- where_such_controls_do_not_exis (type: esriFieldTypeString, alias: Where such controls do not exist, detail any relevant compensatory controls:, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- can_payments_be_traced_from_inv (type: esriFieldTypeString, alias: Can payments be traced from invoice to cheque journal to bank statement?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No_: No ], [Not Sure_: Not Sure ])
- are_all_invoicesbills_original (type: esriFieldTypeString, alias: Are all invoices/bills original and fully detailed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure_: Not Sure ])
- what_are_your_procedures_for_en (type: esriFieldTypeString, alias: What are your procedures for endorsing bills/invoices and are they endorsed with the required information i.e. Date paid, Cheque number etc., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- are_invoices_reconciled_to_good (type: esriFieldTypeString, alias: Are invoices reconciled to - goods received, purchase orders etc?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure_: Not Sure ])
- what_documentation_do_the_autho (type: esriFieldTypeString, alias: What documentation do the authorised signatories see before signing a cheque? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- is_income_received_promptly_and (type: esriFieldTypeString, alias: Is income received promptly and do adequate controls exist for pursuing bad debts?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- what_are_the_banking_arrangemen (type: esriFieldTypeString, alias: What are the banking arrangements for the project i.e. separate bank account for the project or cost centre approach?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- does_the_organisation_have_any (type: esriFieldTypeString, alias: Does the organisation have any other bank accounts and if so what are they used for?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No_: No ], [Not Sure: Not Sure])
- what_are_the_other_bank_account (type: esriFieldTypeString, alias: What are the other bank accounts used for? , SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- have_redundant_bank_accounts_be (type: esriFieldTypeString, alias: Have redundant Bank Accounts been closed? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
- what_are_the_arrangements_for_t (type: esriFieldTypeString, alias: What are the arrangements for the security of financial stationary and instruments?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- field_50 (type: esriFieldTypeString, alias: What are the arrangements for the storage of cancelled cheques?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- does_your_organisation_use_inte (type: esriFieldTypeString, alias: Does your organisation use internet banking? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure_: Not Sure ])
- field_53_0 (type: esriFieldTypeString, alias: Can a clear payment audit trail be traced?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- field_53_1 (type: esriFieldTypeString, alias: Is there a separation of key duties with regards to request and approval of payment?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- field_53_2 (type: esriFieldTypeString, alias: Is there adequate security within the organisation for passwords to access the banking system?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- does_the_organisation_use_a_deb (type: esriFieldTypeString, alias: Does the organisation use a debit card to make payments from the official account?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No_: No ], [Not Sure_: Not Sure ])
- field_58 (type: esriFieldTypeString, alias: If YES;, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- does_the_organisation_use_a_cre (type: esriFieldTypeString, alias: Does the organisation use a credit card for official purchases?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- field_60_0 (type: esriFieldTypeString, alias: Has the credit card been declared to the funder and approval been granted for use?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure_: Not Sure ])
- field_60_1 (type: esriFieldTypeString, alias: Is there an appropriate policy in place to monitor and control the use of the credit card?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure_: Not Sure ])
- who_within_the_organisation_has (type: esriFieldTypeString, alias: Who within the organisation has payment authority? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- is_this_confirmed_by_the_bank_m (type: esriFieldTypeString, alias: Is this confirmed by the Bank Mandate?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure_: Not Sure ])
- can_you_confirm_the_practice_fo (type: esriFieldTypeString, alias: Can you confirm the practice for receiving, retaining and filing bank statements?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- how_often_is_the_bank_reconcili (type: esriFieldTypeString, alias: How often is the bank reconciliation carried out and by whom? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Weekly: Weekly], [Fortnightly: Fortnightly], [Monthly: Monthly], ... 2 more ...)
- what_system_is_in_place_to_moni (type: esriFieldTypeString, alias: What system is in place to monitor budget spend?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- how_often_is_the_budget_spend_m (type: esriFieldTypeString, alias: How often is the budget spend monitored?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Weekly: Weekly], [Fortnightly: Fortnightly], [Monthly: Monthly], ... 2 more ...)
- is_budget_information_password (type: esriFieldTypeString, alias: Is budget information password protected, held securely and access limited to only those who require it?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- how_often_are_budget_reports_re (type: esriFieldTypeString, alias: How often are budget reports reviewed by the management committee?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Weekly: Weekly], [Fortnightly: Fortnightly], [Monthly: Monthly], ... 2 more ...)
- are_major_variances_documented (type: esriFieldTypeString, alias: Are major variances documented, appropriate action taken and approved by management committee?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- what_payroll_system_does_the_or (type: esriFieldTypeString, alias: What payroll system does the organisation operate?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Manual: Manual], [Computerised: Computerised], [Not Sure: Not Sure])
- is_there_a_record_to_confirm_th (type: esriFieldTypeString, alias: Is there a record to confirm that National Insurance and PAYE payments are made on the due dates?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure_: Not Sure ])
- is_payroll_information_password (type: esriFieldTypeString, alias: Is payroll information password protected, held securely and access limited to only those who require it? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure_: Not Sure ])
- does_the_organisation_operate_a (type: esriFieldTypeString, alias: Does the organisation operate a petty cash system?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No_: No ], [Not Sure_: Not Sure ])
- how_is_petty_cash_recorded (type: esriFieldTypeString, alias: How is petty cash recorded?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- how_often_is_the_petty_cash_sys (type: esriFieldTypeString, alias: How often is the petty cash system reconciled?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Strongly disagree: Strongly disagree], [Disagree: Disagree], [Neutral: Neutral], ... 2 more ...)
- is_the_system_monitored_and_rev (type: esriFieldTypeString, alias: Is the system monitored and reviewed by the Management Committee?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure_: Not Sure ])
- field_88 (type: esriFieldTypeString, alias: Does the organisation operate any cash transactions?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure_: Not Sure ])
- how_are_the_cash_transactions_r (type: esriFieldTypeString, alias: How are the cash transactions recorded?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- how_often_is_the_cash_transacti (type: esriFieldTypeString, alias: How often is the cash transaction system reconciled? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Strongly disagree: Strongly disagree], [Disagree: Disagree], [Neutral: Neutral], ... 2 more ...)
- field_92 (type: esriFieldTypeString, alias: Is the system monitored and reviewed by the Management Committee?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure_: Not Sure ])
- how_does_the_organisation_recor (type: esriFieldTypeString, alias: How does the organisation record income & expenditure and cheque journal entries i.e. manual / computerised or both?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Manual_: Manual ], [Computerised: Computerised], [Both: Both])
- entered_in_permenant_ink (type: esriFieldTypeString, alias: Entered in permenant ink?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- how_are_alterations_made (type: esriFieldTypeString, alias: How are alterations made?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- have_blank_lines_on_ledger_page (type: esriFieldTypeString, alias: Have blank lines on ledger pages been ruled through?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Sure: Not Sure])
- if_held_electronically_how_ofte (type: esriFieldTypeString, alias: If held electronically, how often is a back-up copy of the information maintained and by what means? , SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- is_the_organisation_aware_that (type: esriFieldTypeString, alias: Is the organisation aware that financial records must be retained for inspection for 7 years from the receipt of the final payment? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- any_other_comments (type: esriFieldTypeString, alias: Any Other Comments:, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/15/2023 11:11:38 AM
Schema Last Edit Date: 9/15/2023 11:11:47 AM
Data Last Edit Date: 9/15/2023 11:11:38 AM
Supported Operations:
Add Features
Apply Edits
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat