Name: AgreementsResultsCSV

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• ID (type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Start_time (type: esriFieldTypeDate, alias: Start time, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Completion_time (type: esriFieldTypeDate, alias: Completion time, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Are_you_currently_an_ARS_Princi (type: esriFieldTypeString, alias: Are you currently an ARS Principal Investigator (Cat 1, Cat 4 or Cat 6 permanent employee who is currently or has been an ARS PI or Co-PI on an agreement action in the past (2) years)?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Have_you_received_adequate_trai (type: esriFieldTypeString, alias: Have you received adequate training to manage your agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_can_your_Grants_Management (type: esriFieldTypeString, alias: What can your Grants Management Specialist do to better support you with your agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_use_AXON_as_a_resource_f (type: esriFieldTypeString, alias: Do you use AXON as a resource for agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_use_the_agreement_templa (type: esriFieldTypeString, alias: Do you use the agreement templates available on AXON when preparing agreement actions, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_what_P_Ps_apply_to_ (type: esriFieldTypeString, alias: Do you know what P&Ps apply to agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_how_to_develop_an_a (type: esriFieldTypeString, alias: Do you know how to develop an agreement statement of work and budget?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_restricti (type: esriFieldTypeString, alias: Do you understand the restrictions associated with the different agreement types (examples of restrictions: tuition remission, equipment, indirect costs, cooperator contribution requirements, etc.):, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_what_the_SBIR_fee_i (type: esriFieldTypeString, alias: Do you know what the SBIR fee is and when it is charged to the outgoing agreement?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_what_the_IPSC_fee_i (type: esriFieldTypeString, alias: Do you know what the IPSC fee is and when it is collected from the incoming agreement?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_familiar_with_interpret (type: esriFieldTypeString, alias: Are you familiar with interpreting the different parts of the financial status reports?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_inquire_with_Cooperators (type: esriFieldTypeString, alias: Do you inquire with Cooperators to request performance and/or financial reports after the due dates?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Who_do_you_go_to_inquire_as_to_ (type: esriFieldTypeString, alias: Who do you go to inquire as to the agreement status after the agreement is released from the RL level in ARIS?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• If_you_have_a_question_related_ (type: esriFieldTypeString, alias: If you have a question related to a pre-award action for an incoming agreement (in which ARS receives funding from a Sponsor) who would you contact?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_your_responsi (type: esriFieldTypeString, alias: Do you understand your responsibilities once an agreement has been fully executed?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_receive_a_monthly_Status (type: esriFieldTypeString, alias: Do you receive a monthly Status of Funds report to review amounts remaining on your active incoming awards?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Please_select_the_resources_tha (type: esriFieldTypeString, alias: Please select the resources that you currently utilize to complete your duties associated with the agreements process:, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_aware_of_the_ORISE_prog (type: esriFieldTypeString, alias: Are you aware of the ORISE program and understand the benefit to the Agency?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_how_to_determine_if (type: esriFieldTypeString, alias: Do you know how to determine if an Outgoing Interagency Agreement with the Forest Service is required when bringing a Foreign Visitor into the Agency?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Did_you_complete_the_ARS_PI_tra (type: esriFieldTypeString, alias: Did you complete the ARS PI training in ARIS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Was_the_PI_training_helpful_in_ (type: esriFieldTypeString, alias: Was the PI training helpful in your understanding of the agreement process?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• If_it_was_not_helpful_in_your_u (type: esriFieldTypeString, alias: If it was not helpful in your understanding, please explain why:, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Would_you_like_additional_agree (type: esriFieldTypeString, alias: Would you like additional agreement training? If so, mark the areas you would like training in:, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_have_a_process_in_place_ (type: esriFieldTypeString, alias: Do you have a process in place to monitor agreements and ensure reports are received from Cooperators (outgoing) and provided to Sponsors (incoming), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_impact_th (type: esriFieldTypeString, alias: Do you understand the impact the Continuing Resolution has on the agreements process?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_have_any_foreign_agreeme (type: esriFieldTypeString, alias: Do you have any foreign agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_can_Grants_and_Agreements_ (type: esriFieldTypeString, alias: What can Grants and Agreements Management Branch (GAMB) staff do to better support your foreign agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• As_an_ARS_PI__do_you_submit_you (type: esriFieldTypeString, alias: As an ARS PI, do you submit your IFR template to the Unit PSA prior to submitting your proposal/budget to the Cooperator (when you are Co-PI) and/or Sponsor (when you are primary PI)?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_currently_an_Administra (type: esriFieldTypeString, alias: Are you currently an Administrative Officer, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• How_do_you_receive_communicatio (type: esriFieldTypeString, alias: How do you receive communications related to changes in agreement processes, policies, and standard procedures/guidance documents? Select all that apply:, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Have_you_taken_the_ARS_Extramur (type: esriFieldTypeString, alias: Have you taken the ARS Extramural Agreements Training for the Level 1 ADO in Aglearn, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Have_you_received_adequate_tr_1 (type: esriFieldTypeString, alias: Have you received adequate training in ARIS/AIMS for agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Would_you_like_additional_agr_1 (type: esriFieldTypeString, alias: Would you like additional agreement training? If so, mark the areas you would like training in:2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_use_AXON_as_a_resource_1 (type: esriFieldTypeString, alias: Do you use AXON as a resource for agreements?2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_what_P_Ps_apply_to1 (type: esriFieldTypeString, alias: Do you know what P&Ps apply to agreements?2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_being_provided_accurate (type: esriFieldTypeString, alias: Are you being provided accurate guidance and support about agreements from the Area GMS?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_feel_like_GAMB_provides_ (type: esriFieldTypeString, alias: Do you feel like GAMB provides updated agreement standard processes/policies/instructions across the Agency?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_support_your_ARS_PI_on_a (type: esriFieldTypeString, alias: Do you support your ARS PI on agreement related activities?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_your_role_in_ (type: esriFieldTypeString, alias: Do you understand your role in billing on foreign incoming agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_can_GAMB_and_or_your_Area_ (type: esriFieldTypeString, alias: What can GAMB and/or your Area GMS do better to help support you?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_what_to_look_for_wi (type: esriFieldTypeString, alias: Do you know what to look for within the ARIS agreement work record to ensure Agency requirements are met before approving the ARIS record?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_have_a_Level_1_ADO_Deleg (type: esriFieldTypeString, alias: Do you have a Level 1 ADO Delegation of Authority?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• As_a_Level_1_ADO__do_you_execut (type: esriFieldTypeString, alias: As a Level 1 ADO, do you execute Research Support Agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• As_a_Level_1_ADO__do_you_close_ (type: esriFieldTypeString, alias: As a Level 1 ADO, do you close RSAs in accordance with Agency policy, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• As_a_Level_1_ADO__do_you_exec_1 (type: esriFieldTypeString, alias: As a Level 1 ADO, do you execute Standard Cooperative Agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_a_Grants_Management_Spe (type: esriFieldTypeString, alias: Are you a Grants Management Specialist?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_different (type: esriFieldTypeString, alias: Do you understand the different types of agreements and which ones to use when?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_restric_1 (type: esriFieldTypeString, alias: Do you understand the restrictions associated with the different agreement types (example of restrictions: tuition remission, equipment, indirect costs, cooperator contribution requirements, etc.)?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_how_to_review (type: esriFieldTypeString, alias: Do you understand how to review the different types of agreement budgets, statement of work, etc. to ensure that they are legally sufficient?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_familiar_with_interpr_1 (type: esriFieldTypeString, alias: Are you familiar with interpreting the different parts of the financial status reports?2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Would_you_like_additional_agr_2 (type: esriFieldTypeString, alias: Would you like additional agreement training? If so, mark the areas you would like training in:3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_use_the___Transmittal_of (type: esriFieldTypeString, alias: Do you use the ""Transmittal of Invoice for Payment"" cover page when sending invoices to ARSOPS?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_could_be_improved_in_your_ (type: esriFieldTypeString, alias: What could be improved in your collaborations with your Budget Analyst, Program Analyst, and Scientists?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_review_your_GONE_Act_Rep (type: esriFieldTypeString, alias: Do you review your GONE Act Reports Monthly?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_close_agreements_accordi (type: esriFieldTypeString, alias: Do you close agreements according to Agency policy?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_use_receive_a_closeout_c (type: esriFieldTypeString, alias: Do you use/receive a closeout checklist?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_receive__review_and_reco (type: esriFieldTypeString, alias: Do you receive, review and reconcile your FMMI/ARIS Expiring Agreements Report Monthly?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_can_GAMB_and_your_Area_Tea (type: esriFieldTypeString, alias: What can GAMB and your Area Team Leader do to better support you?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Does_the_agreement_execution__m (type: esriFieldTypeString, alias: Does the agreement execution, monitoring and closeout process work well in your Area?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_would_you_do_to_improve_th (type: esriFieldTypeString, alias: What would you do to improve the agreement execution, monitoring or closeout processes?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Have_you_received_sufficient_tr (type: esriFieldTypeString, alias: Have you received sufficient training to perform your job?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• If_you_answered_no_to_the_previ (type: esriFieldTypeString, alias: If you answered no to the previous question, what training or resources do you need to better perform your duties?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_enter_agreement_actions_ (type: esriFieldTypeString, alias: Do you enter agreement actions in ARIS (Unit Admin)?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_utilize_the_Forms___Temp (type: esriFieldTypeString, alias: Do you utilize the Forms & Templates pages available on AXON to assist ARS PIs with agreement entries?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_utilize_the_ARIS_Manual_ (type: esriFieldTypeString, alias: Do you utilize the ARIS Manual if you are unsure of how to enter an action in ARIS (or what action is required)?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_what_P_Ps_apply_t_1 (type: esriFieldTypeString, alias: Do you know what P&Ps apply to the agreement process?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_differe_1 (type: esriFieldTypeString, alias: Do you understand the different types of agreements and which one to use when?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_various_t (type: esriFieldTypeString, alias: Do you understand the various terminologies used within the ARIS system and on the REE-451 and Interagency Agreements documents?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Who_is_responsible_for_marking_ (type: esriFieldTypeString, alias: Who is responsible for marking the record expired from the Active side of ARIS once the agreement reaches its term date?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Who_is_responsible_for_completi (type: esriFieldTypeString, alias: Who is responsible for completing your incoming agreement financial closeout checklists for expired agreements within your Unit/Location?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• As_the_Unit_Admin__how_often_do (type: esriFieldTypeString, alias: As the Unit Admin, how often do you review ARIS to ensure SYs are aware of agreements that will be reaching their term date?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• As_the_Unit_Admin__do_you_consi (type: esriFieldTypeString, alias: As the Unit Admin, do you consider ARIS a user-friendly system for entering and monitoring agreement information?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_method_of_communication_do (type: esriFieldTypeString, alias: What method of communication do you prefer to receive updates and/or guidance related to agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Where_do_you_initially_go_to_fo (type: esriFieldTypeString, alias: Where do you initially go to for guidance regarding Agreement inquiries?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• In_relation_to_the_previous_que (type: esriFieldTypeString, alias: In relation to the previous question, if the individual you go to does not know the answer to your inquiry, what is their response? NOTE: If Other - please type in your response., SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_can_Location_Support_Staff (type: esriFieldTypeString, alias: What can Location Support Staff do to better support you as it relates to Agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_can_AAOD_Staff__AFM_Area_B (type: esriFieldTypeString, alias: What can AAOD Staff (AFM/Area Budget Analyst, Area Program Analyst and AFM/Area Grants Management Specialist) do to better support you as it relates to Agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_aware_of_any_shortfalls (type: esriFieldTypeString, alias: Are you aware of any shortfalls with the agreements process? If so, please describe:, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Based_on_your_response_to_the_a (type: esriFieldTypeString, alias: Based on your response to the above question, please provide a recommendation for how to address the shortfalls identified in the prior question., SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Please_provide_any_additional_i (type: esriFieldTypeString, alias: Please provide any additional input you have regarding this survey., SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/28/2022 6:19:57 PM

Schema Last Edit Date: 1/28/2022 6:19:57 PM

Data Last Edit Date: 1/28/2022 6:19:57 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat