{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 16, "name": "SWSBU.dbo.GLMasterPositiveNumberViewQL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "a_account_type", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "a_account_type", "type": "esriFieldTypeString", "alias": "a_account_type", "length": 1, "domain": null }, { "name": "a_fund_seg1", "type": "esriFieldTypeString", "alias": "a_fund_seg1", "length": 10, "domain": null }, { "name": "a_remaining_orgseg", "type": "esriFieldTypeString", "alias": "a_remaining_orgseg", "length": 30, "domain": null }, { "name": "a_object", "type": "esriFieldTypeString", "alias": "a_object", "length": 6, "domain": null }, { "name": "a_project", "type": "esriFieldTypeString", "alias": "a_project", "length": 10, "domain": null }, { "name": "a_org", "type": "esriFieldTypeString", "alias": "a_org", "length": 8, "domain": null }, { "name": "a_entity_code", "type": "esriFieldTypeString", "alias": "a_entity_code", "length": 1, "domain": null }, { "name": "a_account_desc", "type": "esriFieldTypeString", "alias": "a_account_desc", "length": 30, "domain": null }, { "name": "a_account_desc_sh", "type": "esriFieldTypeString", "alias": "a_account_desc_sh", "length": 10, "domain": null }, { "name": "a_bal_sheet_type", "type": "esriFieldTypeString", "alias": "a_bal_sheet_type", "length": 1, "domain": null }, { "name": "a_account_status", "type": "esriFieldTypeString", "alias": "a_account_status", "length": 1, "domain": null }, { "name": "d_encumb_bud_y_n", "type": "esriFieldTypeString", "alias": "d_encumb_bud_y_n", "length": 1, "domain": null }, { "name": "a_budgetary_y_n", "type": "esriFieldTypeString", "alias": "a_budgetary_y_n", "length": 1, "domain": null }, { "name": "a_grant_org", "type": "esriFieldTypeString", "alias": "a_grant_org", "length": 8, "domain": null }, { "name": "a_grant_object", "type": "esriFieldTypeString", "alias": "a_grant_object", "length": 6, "domain": null }, { "name": "a_grant_project", "type": "esriFieldTypeString", "alias": "a_grant_project", "length": 5, "domain": null }, { "name": "a_last_update", "type": "esriFieldTypeDate", "alias": "a_last_update", "length": 8, "domain": null }, { "name": "a_bal_sheet_sign", "type": "esriFieldTypeString", "alias": "a_bal_sheet_sign", "length": 1, "domain": null }, { "name": "a_segment_2", "type": "esriFieldTypeString", "alias": "a_segment_2", "length": 10, "domain": null }, { "name": "a_segment_3", "type": "esriFieldTypeString", "alias": "a_segment_3", "length": 10, "domain": null }, { "name": "a_segment_4", "type": "esriFieldTypeString", "alias": "a_segment_4", "length": 10, "domain": null }, { "name": "a_segment_5", "type": "esriFieldTypeString", "alias": "a_segment_5", "length": 10, "domain": null }, { "name": "a_segment_6", "type": "esriFieldTypeString", "alias": "a_segment_6", "length": 10, "domain": null }, { "name": "a_segment_7", "type": "esriFieldTypeString", "alias": "a_segment_7", "length": 10, "domain": null }, { "name": "a_segment_8", "type": "esriFieldTypeString", "alias": "a_segment_8", "length": 10, "domain": null }, { "name": "a_bud_yr", "type": "esriFieldTypeSmallInteger", "alias": "a_bud_yr", "domain": null }, { "name": "b_incept_bal", "type": "esriFieldTypeDouble", "alias": "b_incept_bal", "domain": null }, { "name": "d_bud_in_5years", "type": "esriFieldTypeDouble", "alias": "d_bud_in_5years", "domain": null }, { "name": "d_ny5_statistics", "type": "esriFieldTypeDouble", "alias": "d_ny5_statistics", "domain": null }, { "name": "d_bud_in_4years", "type": "esriFieldTypeDouble", "alias": "d_bud_in_4years", "domain": null }, { "name": "d_ny4_statistics", "type": "esriFieldTypeDouble", "alias": "d_ny4_statistics", "domain": null }, { "name": "d_bud_in_3years", "type": "esriFieldTypeDouble", "alias": "d_bud_in_3years", "domain": null }, { "name": "d_ny3_statistics", "type": "esriFieldTypeDouble", "alias": "d_ny3_statistics", "domain": null }, { "name": "d_bud_in_2years", "type": "esriFieldTypeDouble", "alias": "d_bud_in_2years", "domain": null }, { "name": "d_ny2_statistics", "type": "esriFieldTypeDouble", "alias": "d_ny2_statistics", "domain": null }, { "name": "d_bud_ny_level1", "type": "esriFieldTypeDouble", "alias": "d_bud_ny_level1", "domain": null }, { "name": "d_bud_ny_level2", "type": "esriFieldTypeDouble", "alias": "d_bud_ny_level2", "domain": null }, { "name": "d_bud_ny_level3", "type": "esriFieldTypeDouble", "alias": "d_bud_ny_level3", "domain": null }, { "name": "d_bud_ny_level4", "type": "esriFieldTypeDouble", "alias": "d_bud_ny_level4", "domain": null }, { "name": "d_bud_ny_level5", "type": "esriFieldTypeDouble", "alias": "d_bud_ny_level5", "domain": null }, { "name": "d_ny_stat_level1", "type": "esriFieldTypeDouble", "alias": "d_ny_stat_level1", "domain": null }, { "name": "d_ny_stat_level2", "type": "esriFieldTypeDouble", "alias": "d_ny_stat_level2", "domain": null }, { "name": "d_ny_stat_level3", "type": "esriFieldTypeDouble", "alias": "d_ny_stat_level3", "domain": null }, { "name": "d_ny_stat_level4", "type": "esriFieldTypeDouble", "alias": "d_ny_stat_level4", "domain": null }, { "name": "d_ny_stat_level5", "type": "esriFieldTypeDouble", "alias": "d_ny_stat_level5", "domain": null }, { "name": "d_bud_cy_level1", "type": "esriFieldTypeDouble", "alias": "d_bud_cy_level1", "domain": null }, { "name": "d_bud_cy_level2", "type": "esriFieldTypeDouble", "alias": "d_bud_cy_level2", "domain": null }, { "name": "d_bud_cy_level3", "type": "esriFieldTypeDouble", "alias": "d_bud_cy_level3", "domain": null }, { "name": "d_bud_cy_level4", "type": "esriFieldTypeDouble", "alias": "d_bud_cy_level4", "domain": null }, { "name": "d_bud_cy_level5", "type": "esriFieldTypeDouble", "alias": "d_bud_cy_level5", "domain": null }, { "name": "d_cy_orig_bud", "type": "esriFieldTypeDouble", "alias": "d_cy_orig_bud", "domain": null }, { "name": "d_cy_xfr_bud_in", "type": "esriFieldTypeDouble", "alias": "d_cy_xfr_bud_in", "domain": null }, { "name": "d_cy_xfr_bud_out", "type": "esriFieldTypeDouble", "alias": "d_cy_xfr_bud_out", "domain": null }, { "name": "d_carry_fwrd_cy", "type": "esriFieldTypeDouble", "alias": "d_carry_fwrd_cy", "domain": null }, { "name": "d_cary_fwrd_cy_xfr", "type": "esriFieldTypeDouble", "alias": "d_cary_fwrd_cy_xfr", "domain": null }, { "name": "d_cy_revised_bud", "type": "esriFieldTypeDouble", "alias": "d_cy_revised_bud", "domain": null }, { "name": "b_cy_memo_bal", "type": "esriFieldTypeDouble", "alias": "b_cy_memo_bal", "domain": null }, { "name": "b_cy_actual_bal", "type": "esriFieldTypeDouble", "alias": "b_cy_actual_bal", "domain": null }, { "name": "b_cy_actl_from_ly", "type": "esriFieldTypeDouble", "alias": "b_cy_actl_from_ly", "domain": null }, { "name": "b_cy_est_actual", "type": "esriFieldTypeDouble", "alias": "b_cy_est_actual", "domain": null }, { "name": "d_cy_statistics", "type": "esriFieldTypeDouble", "alias": "d_cy_statistics", "domain": null }, { "name": "b_cy_encumb", "type": "esriFieldTypeDouble", "alias": "b_cy_encumb", "domain": null }, { "name": "b_cy_encmb_frm_ly", "type": "esriFieldTypeDouble", "alias": "b_cy_encmb_frm_ly", "domain": null }, { "name": "b_cy_req_balance", "type": "esriFieldTypeDouble", "alias": "b_cy_req_balance", "domain": null }, { "name": "d_ly1_orig_bud", "type": "esriFieldTypeDouble", "alias": "d_ly1_orig_bud", "domain": null }, { "name": "d_ly1_xfr_bud_in", "type": "esriFieldTypeDouble", "alias": "d_ly1_xfr_bud_in", "domain": null }, { "name": "d_ly1_xfr_bud_out", "type": "esriFieldTypeDouble", "alias": "d_ly1_xfr_bud_out", "domain": null }, { "name": "d_carry_fwrd_ly1", "type": "esriFieldTypeDouble", "alias": "d_carry_fwrd_ly1", "domain": null }, { "name": "d_ly1_rev_bud", "type": "esriFieldTypeDouble", "alias": "d_ly1_rev_bud", "domain": null }, { "name": "b_ly_memo_bal", "type": "esriFieldTypeDouble", "alias": "b_ly_memo_bal", "domain": null }, { "name": "b_ly1_actual_bal", "type": "esriFieldTypeDouble", "alias": "b_ly1_actual_bal", "domain": null }, { "name": "b_closed_yr_bal", "type": "esriFieldTypeDouble", "alias": "b_closed_yr_bal", "domain": null }, { "name": "d_ly1_statistics", "type": "esriFieldTypeDouble", "alias": "d_ly1_statistics", "domain": null }, { "name": "b_ly1_encumb", "type": "esriFieldTypeDouble", "alias": "b_ly1_encumb", "domain": null }, { "name": "d_ly2_orig_bud", "type": "esriFieldTypeDouble", "alias": "d_ly2_orig_bud", "domain": null }, { "name": "d_ly2_rev_bud", "type": "esriFieldTypeDouble", "alias": "d_ly2_rev_bud", "domain": null }, { "name": "b_ly2_actual_bal", "type": "esriFieldTypeDouble", "alias": "b_ly2_actual_bal", "domain": null }, { "name": "d_ly2_statistics", "type": "esriFieldTypeDouble", "alias": "d_ly2_statistics", "domain": null }, { "name": "d_ly3_orig_bud", "type": "esriFieldTypeDouble", "alias": "d_ly3_orig_bud", "domain": null }, { "name": "d_ly3_rev_bud", "type": "esriFieldTypeDouble", "alias": "d_ly3_rev_bud", "domain": null }, { "name": "b_ly3_actual_bal", "type": "esriFieldTypeDouble", "alias": "b_ly3_actual_bal", "domain": null }, { "name": "d_ly3_statistics", "type": "esriFieldTypeDouble", "alias": "d_ly3_statistics", "domain": null }, { "name": "b_ly4_actual_bal", "type": "esriFieldTypeDouble", "alias": "b_ly4_actual_bal", "domain": null }, { "name": "b_ly5_actual_bal", "type": "esriFieldTypeDouble", "alias": "b_ly5_actual_bal", "domain": null }, { "name": "b_ly6_actual_bal", "type": "esriFieldTypeDouble", "alias": "b_ly6_actual_bal", "domain": null }, { "name": "b_ly7_actual_bal", "type": "esriFieldTypeDouble", "alias": "b_ly7_actual_bal", "domain": null }, { "name": "b_ly8_actual_bal", "type": "esriFieldTypeDouble", "alias": "b_ly8_actual_bal", "domain": null }, { "name": "b_ly9_actual_bal", "type": "esriFieldTypeDouble", "alias": "b_ly9_actual_bal", "domain": null }, { "name": "b_ly10_actual_bal", "type": "esriFieldTypeDouble", "alias": "b_ly10_actual_bal", "domain": null }, { "name": "d_incp_orig_bud", "type": "esriFieldTypeDouble", "alias": "d_incp_orig_bud", "domain": null }, { "name": "d_incp_rev_bud", "type": "esriFieldTypeDouble", "alias": "d_incp_rev_bud", "domain": null }, { "name": "b_ny_memo_bal", "type": "esriFieldTypeDouble", "alias": "b_ny_memo_bal", "domain": null }, { "name": "b_ny_encumb_bal", "type": "esriFieldTypeDouble", "alias": "b_ny_encumb_bal", "domain": null }, { "name": "b_ny_req_bal", "type": "esriFieldTypeDouble", "alias": "b_ny_req_bal", "domain": null }, { "name": "d_ny_rev_bud", "type": "esriFieldTypeDouble", "alias": "d_ny_rev_bud", "domain": null }, { "name": "d_budget_factor", "type": "esriFieldTypeSingle", "alias": "d_budget_factor", "domain": null }, { "name": "d_carry_fwd_unusd", "type": "esriFieldTypeDouble", "alias": "d_carry_fwd_unusd", "domain": null }, { "name": "d_filler", "type": "esriFieldTypeString", "alias": "d_filler", "length": 50, "domain": null }, { "name": "a_warn_level", "type": "esriFieldTypeDouble", "alias": "a_warn_level", "domain": null }, { "name": "d_req_buddet", "type": "esriFieldTypeString", "alias": "d_req_buddet", "length": 1, "domain": null }, { "name": "d_actual_from_ly2", "type": "esriFieldTypeDouble", "alias": "d_actual_from_ly2", "domain": null }, { "name": "d_spend_plan", "type": "esriFieldTypeString", "alias": "d_spend_plan", "length": 4, "domain": null }, { "name": "a_object_desc", "type": "esriFieldTypeString", "alias": "a_object_desc", "length": 30, "domain": null }, { "name": "a_object_desc_sh", "type": "esriFieldTypeString", "alias": "a_object_desc_sh", "length": 10, "domain": null }, { "name": "a_charcode", "type": "esriFieldTypeString", "alias": "a_charcode", "length": 2, "domain": null }, { "name": "ob_object_status", "type": "esriFieldTypeString", "alias": "ob_object_status", "length": 1, "domain": null }, { "name": "ob_budqty_label", "type": "esriFieldTypeString", "alias": "ob_budqty_label", "length": 10, "domain": null }, { "name": "ob_filler", "type": "esriFieldTypeString", "alias": "ob_filler", "length": 50, "domain": null }, { "name": "ob_status_label", "type": "esriFieldTypeString", "alias": "ob_status_label", "length": 5, "domain": null }, { "name": "ob_sub_object", "type": "esriFieldTypeSmallInteger", "alias": "ob_sub_object", "domain": null }, { "name": "a_charcode_desc", "type": "esriFieldTypeString", "alias": "a_charcode_desc", "length": 20, "domain": null }, { "name": "a_org_description", "type": "esriFieldTypeString", "alias": "a_org_description", "length": 30, "domain": null }, { "name": "a_org_desc_sh", "type": "esriFieldTypeString", "alias": "a_org_desc_sh", "length": 10, "domain": null }, { "name": "gp_deflt_year", "type": "esriFieldTypeSmallInteger", "alias": "gp_deflt_year", "domain": null }, { "name": "gp_deflt_period", "type": "esriFieldTypeSmallInteger", "alias": "gp_deflt_period", "domain": null }, { "name": "gp_curr_year", "type": "esriFieldTypeSmallInteger", "alias": "gp_curr_year", "domain": null }, { "name": "gp_curr_period", "type": "esriFieldTypeSmallInteger", "alias": "gp_curr_period", "domain": null }, { "name": "b_cy_encmb_frm_ly2", "type": "esriFieldTypeDouble", "alias": "b_cy_encmb_frm_ly2", "domain": null }, { "name": "b_desc_ny", "type": "esriFieldTypeString", "alias": "b_desc_ny", "length": 30, "domain": null }, { "name": "b_ctl_acct", "type": "esriFieldTypeString", "alias": "b_ctl_acct", "length": 4, "domain": null }, { "name": "b_contra", "type": "esriFieldTypeString", "alias": "b_contra", "length": 1, "domain": null }, { "name": "b_close_bal", "type": "esriFieldTypeString", "alias": "b_close_bal", "length": 1, "domain": null }, { "name": "b_bud_req5_ny2", "type": "esriFieldTypeDouble", "alias": "b_bud_req5_ny2", "domain": null }, { "name": "b_bud_req4_ny2", "type": "esriFieldTypeDouble", "alias": "b_bud_req4_ny2", "domain": null }, { "name": "b_bud_req3_ny2", "type": "esriFieldTypeDouble", "alias": "b_bud_req3_ny2", "domain": null }, { "name": "b_bud_req2_ny2", "type": "esriFieldTypeDouble", "alias": "b_bud_req2_ny2", "domain": null }, { "name": "b_full_account", "type": "esriFieldTypeString", "alias": "b_full_account", "length": 55, "domain": null }, { "name": "d_bud_ny6", "type": "esriFieldTypeDouble", "alias": "d_bud_ny6", "domain": null }, { "name": "d_bud_ny7", "type": "esriFieldTypeDouble", "alias": "d_bud_ny7", "domain": null }, { "name": "d_bud_ny8", "type": "esriFieldTypeDouble", "alias": "d_bud_ny8", "domain": null }, { "name": "d_bud_ny9", "type": "esriFieldTypeDouble", "alias": "d_bud_ny9", "domain": null }, { "name": "d_bud_ny10", "type": "esriFieldTypeDouble", "alias": "d_bud_ny10", "domain": null }, { "name": "my_orig_bud_fy", "type": "esriFieldTypeDouble", "alias": "my_orig_bud_fy", "domain": null }, { "name": "my_bud_xfr_in_fy", "type": "esriFieldTypeDouble", "alias": "my_bud_xfr_in_fy", "domain": null }, { "name": "my_bud_xfr_out_fy", "type": "esriFieldTypeDouble", "alias": "my_bud_xfr_out_fy", "domain": null }, { "name": "my_rev_bud_fy", "type": "esriFieldTypeDouble", "alias": "my_rev_bud_fy", "domain": null }, { "name": "my_orig_bud_ltd", "type": "esriFieldTypeDouble", "alias": "my_orig_bud_ltd", "domain": null }, { "name": "my_bud_xfr_in_ltd", "type": "esriFieldTypeDouble", "alias": "my_bud_xfr_in_ltd", "domain": null }, { "name": "my_bud_xfr_out_ltd", "type": "esriFieldTypeDouble", "alias": "my_bud_xfr_out_ltd", "domain": null }, { "name": "my_rev_bud_ltd", "type": "esriFieldTypeDouble", "alias": "my_rev_bud_ltd", "domain": null }, { "name": "glma_stat2_ny2", "type": "esriFieldTypeDouble", "alias": "glma_stat2_ny2", "domain": null }, { "name": "glma_stat3_ny2", "type": "esriFieldTypeDouble", "alias": "glma_stat3_ny2", "domain": null }, { "name": "glma_stat4_ny2", "type": "esriFieldTypeDouble", "alias": "glma_stat4_ny2", "domain": null }, { "name": "glma_stat5_ny2", "type": "esriFieldTypeDouble", "alias": "glma_stat5_ny2", "domain": null }, { "name": "glma_stat_ny6", "type": "esriFieldTypeDouble", "alias": "glma_stat_ny6", "domain": null }, { "name": "glma_stat_ny7", "type": "esriFieldTypeDouble", "alias": "glma_stat_ny7", "domain": null }, { "name": "glma_stat_ny8", "type": "esriFieldTypeDouble", "alias": "glma_stat_ny8", "domain": null }, { "name": "glma_stat_ny9", "type": "esriFieldTypeDouble", "alias": "glma_stat_ny9", "domain": null }, { "name": "glma_stat_ny10", "type": "esriFieldTypeDouble", "alias": "glma_stat_ny10", "domain": null }, { "name": "glma_charcode", "type": "esriFieldTypeString", "alias": "glma_charcode", "length": 2, "domain": null }, { "name": "glma_salary", "type": "esriFieldTypeString", "alias": "glma_salary", "length": 1, "domain": null }, { "name": "glma_beg_eff_dt", "type": "esriFieldTypeDate", "alias": "glma_beg_eff_dt", "length": 8, "domain": null }, { "name": "glma_end_eff_dt", "type": "esriFieldTypeDate", "alias": "glma_end_eff_dt", "length": 8, "domain": null }, { "name": "glma_orig_bud_ny", "type": "esriFieldTypeDouble", "alias": "glma_orig_bud_ny", "domain": null }, { "name": "glma_pa_required", "type": "esriFieldTypeString", "alias": "glma_pa_required", "length": 1, "domain": null }, { "name": "glma_grant_id", "type": "esriFieldTypeString", "alias": "glma_grant_id", "length": 10, "domain": null }, { "name": "d_rollup_budget", "type": "esriFieldTypeString", "alias": "d_rollup_budget", "length": 1, "domain": null }, { "name": "s_segment1_desc", "type": "esriFieldTypeString", "alias": "s_segment1_desc", "length": 30, "domain": null }, { "name": "s_segment2_desc", "type": "esriFieldTypeString", "alias": "s_segment2_desc", "length": 30, "domain": null }, { "name": "s_segment3_desc", "type": "esriFieldTypeString", "alias": "s_segment3_desc", "length": 30, "domain": null }, { "name": "s_segment4_desc", "type": "esriFieldTypeString", "alias": "s_segment4_desc", "length": 30, "domain": null }, { "name": "s_segment5_desc", "type": "esriFieldTypeString", "alias": "s_segment5_desc", "length": 30, "domain": null }, { "name": "s_segment6_desc", "type": "esriFieldTypeString", "alias": "s_segment6_desc", "length": 30, "domain": null }, { "name": "s_segment7_desc", "type": "esriFieldTypeString", "alias": "s_segment7_desc", "length": 30, "domain": null }, { "name": "s_segment8_desc", "type": "esriFieldTypeString", "alias": "s_segment8_desc", "length": 30, "domain": null }, { "name": "d_ny_xfr_bud_in", "type": "esriFieldTypeDouble", "alias": "d_ny_xfr_bud_in", "domain": null }, { "name": "d_ny_xfr_bud_out", "type": "esriFieldTypeDouble", "alias": "d_ny_xfr_bud_out", "domain": null }, { "name": "d_grant_id", "type": "esriFieldTypeInteger", "alias": "d_grant_id", "domain": null }, { "name": "a_account_id", "type": "esriFieldTypeInteger", "alias": "a_account_id", "domain": null }, { "name": "account_notes", "type": "esriFieldTypeString", "alias": "account_notes", "length": 1073741823, "domain": null }, { "name": "PositiveActualBal", "type": "esriFieldTypeDouble", "alias": "PositiveActualBal", "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a1ec52d2d60d4f969b232c5006dd8c14" }