Name: FinancesResultsCSV

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

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: esriFieldTypeDouble, alias: Start time, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Completion_time (type: esriFieldTypeDouble, alias: Completion time, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_an_ARS_Fund_Holder__Lea (type: esriFieldTypeString, alias: Are you an ARS Fund Holder (Lead PI on a CRIS ""D"" project; signature authority for approving requisitions; and/or ARS PI on an incoming soft funds account), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_Roles___R (type: esriFieldTypeString, alias: Do you understand the Roles & Responsibilities of a Fund Holder?, 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 Status of Funds (SOF)?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_currently_use_the_CRIS_A (type: esriFieldTypeString, alias: Do you currently use the CRIS Allocation Tracking System (CATS) to track Unit/scientific budgets or do you rely on other methods?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_how_to_read_the_Sta (type: esriFieldTypeString, alias: Do you know how to read the Status of Funds Report?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_how_to_read_the_Lia (type: esriFieldTypeString, alias: Do you know how to read the Liability by Management Unit (LMBU) report?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_trust_monthly_Status_of_ (type: esriFieldTypeString, alias: Do you trust monthly Status of Funds reports received from Location Budget Staff?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• If_you_answered___No___to_the_p (type: esriFieldTypeString, alias: If you answered ""No"" to the previous question; what information is lacking? NOTE: If Other please type in your response., SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Does_your_Location_Budget_Staff (type: esriFieldTypeString, alias: Does your Location Budget Staff provide you with the right information to effectively spend your appropriated funding related to federal policy?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Does_your_Location_and_Area_Bud (type: esriFieldTypeString, alias: Does your Location and Area Budget Staff provide you with necessary information to effectively spend your incoming soft funds related to federal policy and the agreement?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_Salary_La (type: esriFieldTypeString, alias: Do you understand the Salary Lapse Policy and how to manage at your location effectively?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_Annual_Re (type: esriFieldTypeString, alias: Do you understand the Annual Resource Management Program (ARMP) process and what is required from the Fund Holder to prepare for ARMPS?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_your_Location (type: esriFieldTypeString, alias: Do you understand your Location's Indirect Research Costs (O&M & IRC)?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_Federal_A (type: esriFieldTypeString, alias: Do you understand the Federal Appropriation Laws and consequences for mismanagement of funds?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• From_your_perspective__is_the_L (type: esriFieldTypeString, alias: From your perspective; is the Location's Indirect Research Costs assessed in a fair and equitable manner that is easily understood?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Based_on_the_Financial_Manageme (type: esriFieldTypeString, alias: Based on the Financial Management systems you have access to; are there any shortfalls with system functionality?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_are_your_recommendations_f (type: esriFieldTypeString, alias: What are your recommendations for addressing the shortfalls within the Financial Management systems you have access to?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_a_Purchase_Cardholder_a (type: esriFieldTypeString, alias: Are you a Purchase Cardholder and/or do you complete CATS data entry (IAS requisitions; Travel; Etc.), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_Understand_the_Purpose_o (type: esriFieldTypeString, alias: Do you Understand the Purpose of CATS?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Have_you_received_adequate_tr_1 (type: esriFieldTypeString, alias: Have you received adequate training to enter purchases into CATS?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Does_your_Location_Budget_Sta_1 (type: esriFieldTypeString, alias: Does your Location Budget Staff provide you with help/instructions when it comes to making purchases?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_Federal_Appro (type: esriFieldTypeString, alias: Do you understand Federal Appropriation Law and consequences for mismanagement of funds?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Based_on_the_Financial_Manage_1 (type: esriFieldTypeString, alias: Based on the Financial Management systems you have access to; are there any shortfalls with system functionality?3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_are_your_recommendations_1 (type: esriFieldTypeString, alias: What are your recommendations for addressing the shortfalls within the Financial Management systems you have access to?3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_in_charge_of_the_reconc (type: esriFieldTypeString, alias: Are you in charge of the reconciliation process for either Appropriated or Soft Funds in FMMI/CATS?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Have_you_taken_the_Financial_Ma (type: esriFieldTypeString, alias: Have you taken the Financial Management Training Course provided by FMAD?, 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 processes; policy; standard procedures? Please check all that apply, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_the_training_materials_on_A (type: esriFieldTypeString, alias: Are the training materials on Axon helpful and up to date?, 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 from the Area Budget Staff?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_feel_like_FMAD_provides_ (type: esriFieldTypeString, alias: Do you feel like FMAD provides current/applicable standard operating procedures; policies; guidance/instructions across the agency?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_find_the_coffee_talks_in (type: esriFieldTypeString, alias: Do you find the coffee talks informative and useful?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Suggestions_for_future_coffee_t (type: esriFieldTypeString, alias: Suggestions for future coffee talk topics?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_get_conflicting_informat (type: esriFieldTypeString, alias: Do you get conflicting information between the coffee talks; Axon; and the information received from the AAOD?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• POC_for_Reconciliation__Do_you_ (type: esriFieldTypeString, alias: POC for Reconciliation) Do you provide yearly training to your location Fund Holders; Cardholders and others who enter transactions into CATS?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_Salary__1 (type: esriFieldTypeString, alias: Do you understand the Salary Lapse Policy and how to manage at your location?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_ARMPS_pro (type: esriFieldTypeString, alias: Do you understand the ARMPS process and what is required for providing accurate salary and cost projections?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Does_your_location_follow_the_s (type: esriFieldTypeString, alias: Does your location follow the standard recommended processes?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• When_providing_a_Status_of_Fund (type: esriFieldTypeString, alias: When providing a Status of Funds; do you feel confident in the information you provide to your Fund Holders?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• When_you_provide_the_SOF_to_the (type: esriFieldTypeString, alias: When you provide the SOF to the Fund Holder; do you provide information related to monthly balance changes?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_able_to_answer_Fund_Hol (type: esriFieldTypeString, alias: Are you able to answer Fund Holder questions related to changes on their accounts?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Have_you_taken_an_Appropriation (type: esriFieldTypeString, alias: Have you taken an Appropriations Law Class (not including the AgLearn Training)?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_aware_of_the_obligation (type: esriFieldTypeString, alias: Are you aware of the obligation process?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_how_to_read_and_und (type: esriFieldTypeString, alias: Do you know how to read and understand the different columns (Commitment; Obligation; Expensed; Disbursed) on the SDR and how they relate to which step of the obligation process an order is on?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_review_your_Unliquidated (type: esriFieldTypeString, alias: Do you review your Unliquidated Obligation Reports monthly?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_billing_p (type: esriFieldTypeString, alias: Do you understand the billing process for Reimbursable Agreements?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• At_your_location__are_Fund_Hold (type: esriFieldTypeString, alias: At your location; are Fund Holders appropriately managing their funds?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_can_FMAD_and_your_Area_Bud (type: esriFieldTypeString, alias: What can FMAD and your Area Budget Staff do to better help support you?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Based_on_the_Financial_Manage_2 (type: esriFieldTypeString, alias: Based on the Financial Management systems you have access to; are there any shortfalls with system functionality?4, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_are_your_recommendations_2 (type: esriFieldTypeString, alias: What are your recommendations for addressing the shortfalls within the Financial Management systems you have access to?4, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_an_Administrative_Offic (type: esriFieldTypeString, alias: Are you an Administrative Officer?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Have_you_taken_the_Financial__1 (type: esriFieldTypeString, alias: Have you taken the Financial Management Training Course provided by FMAD?3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• How_do_you_receive_communicat_1 (type: esriFieldTypeString, alias: How do you receive communications related to changes in processes; policy; standard procedures? Please select all that apply., SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_the_training_materials_on_1 (type: esriFieldTypeString, alias: Are the training materials on Axon helpful and up to date?3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_being_provided_accura_1 (type: esriFieldTypeString, alias: Are you being provided accurate guidance and support from the Area Budget Staff?3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_feel_like_FMAD_provides1 (type: esriFieldTypeString, alias: Do you feel like FMAD provides updates to standard processes; policies; guidance/instructions across the agency in a timely manner?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_the_updates_received_from_F (type: esriFieldTypeString, alias: Are the updates received from FMAD clear and concise?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_provide_yearly_training_ (type: esriFieldTypeString, alias: Do you provide yearly training to your location Fund Holders; Cardholders and others who enter transactions into CATS., SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_how_to_catch_and_fi (type: esriFieldTypeString, alias: Do you know how to catch and find mistakes related to the budget reconciliation?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Are_you_confident_in_reviewing_ (type: esriFieldTypeString, alias: Are you confident in reviewing and understanding the SOF (looking for mistakes; issues; duplicates; etc..), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_have_the_correct_access_ (type: esriFieldTypeString, alias: Do you have the correct access and knowledge to support your Financial Technician on daily reconciliation activities if needed?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_review_your_Unliquidat_1 (type: esriFieldTypeString, alias: Do you review your Unliquidated Obligation Reports monthly?3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_understand_the_billing_1 (type: esriFieldTypeString, alias: Do you understand the billing process for Reimbursable Agreements?3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• At_your_location__are_Fund_Ho_1 (type: esriFieldTypeString, alias: At your location; are Fund Holders appropriately managing their funds?3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_can_FMAD_and_your_Area_B_1 (type: esriFieldTypeString, alias: What can FMAD and your Area Budget Staff do to better help support you?3, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Based_on_the_Financial_Manage_3 (type: esriFieldTypeString, alias: Based on the Financial Management systems you have access to; are there any shortfalls with system functionality?5, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_are_your_recommendations_3 (type: esriFieldTypeString, alias: What are your recommendations for addressing the shortfalls within the Financial Management systems you have access to?5, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• If_you_are_NOT_a_Fund_Holder__P (type: esriFieldTypeString, alias: If you are NOT a Fund Holder; Purchase Cardholder; CATS Data Entry Clerk; or Reconciler; what is your role in the financial management process?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_who_the_fund_holder (type: esriFieldTypeString, alias: Do you know who the fund holder(s) is/are for your Unit/Location?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_who_your_points_of_ (type: esriFieldTypeString, alias: Do you know who your points of contact are for completing purchases and/or contracts for obtaining materials and supplies; services; construction; maintenance; repairs; etc., SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Do_you_know_where_to_find_Agenc (type: esriFieldTypeString, alias: Do you know where to find Agency; Departmental or Federal resources related to Financial Management that is relevant to your role in the process?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_additional_trainings_are_y (type: esriFieldTypeString, alias: What additional trainings are you interested in receiving in relation to Financial Management as it relates to your current position and/or future career progression goals?, 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 Financial Management 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 Financial Management?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_can_AAOD_Staff__AFM_Budget (type: esriFieldTypeString, alias: What can AAOD Staff (AFM Budget Analyst; AFM Budget Fiscal Officer) do to better support you as it relates to Financial Management?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• What_can_FMAD_Staff__HQ_Level__ (type: esriFieldTypeString, alias: What can FMAD Staff (HQ Level) do to better support you as it relates to Financial Management?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• If_you_could_change_one_thing_a (type: esriFieldTypeString, alias: If you could change one thing about the financial management process within your Unit/Location/Area/Agency what would it be?, 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 8:32:42 PM

Schema Last Edit Date: 1/28/2022 8:32:42 PM

Data Last Edit Date: 1/28/2022 8:32:42 PM

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