Name: PT.dbo.vwPTProjects

Display Field: CSJ_NBR

Type: Table

Description:

Copyright Text:

Max Record Count: 25000

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: ESRI_OID

Unique ID Field:

Name : ESRI_OID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• CSJ_NBR (type: esriFieldTypeString, alias: CSJ_NBR, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• PT_PHASE (type: esriFieldTypeString, alias: PT_PHASE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PRJ_TIER (type: esriFieldTypeString, alias: PRJ_TIER, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ENERGY (type: esriFieldTypeString, alias: ENERGY, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• FREIGHT (type: esriFieldTypeString, alias: FREIGHT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• TRUNK_SYS_FLAG (type: esriFieldTypeString, alias: TRUNK_SYS_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• HWY_NBR (type: esriFieldTypeString, alias: HWY_NBR, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• DIST_NM (type: esriFieldTypeString, alias: DIST_NM, SQL Type: sqlTypeOther, length: 27, nullable: true, editable: true)
• CNTY_NM (type: esriFieldTypeString, alias: CNTY_NM, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• LIMITS_FROM_DSCR (type: esriFieldTypeString, alias: LIMITS_FROM_DSCR, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LIMITS_TO_DSCR (type: esriFieldTypeString, alias: LIMITS_TO_DSCR, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• PROJ_DSCR (type: esriFieldTypeString, alias: PROJ_DSCR, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• CNSTR_EST_AMT (type: esriFieldTypeDouble, alias: CNSTR_EST_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJ_NOTE (type: esriFieldTypeString, alias: PROJ_NOTE, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• PROJ_LENGTH (type: esriFieldTypeDouble, alias: PROJ_LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DIST_LET_DATE (type: esriFieldTypeString, alias: DIST_LET_DATE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• TYPE_OF_WORK (type: esriFieldTypeString, alias: TYPE_OF_WORK, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• PROJ_CLASS (type: esriFieldTypeString, alias: PROJ_CLASS, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• LAST_PROJ_UPDATE_DT (type: esriFieldTypeDate, alias: LAST_PROJ_UPDATE_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TXDOT_CNTCT_NM (type: esriFieldTypeString, alias: TXDOT_CNTCT_NM, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• TXDOT_CNTCT_PH_NBR (type: esriFieldTypeString, alias: TXDOT_CNTCT_PH_NBR, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• TXDOT_CNTCT_LAST_UPDATE_DT (type: esriFieldTypeDate, alias: TXDOT_CNTCT_LAST_UPDATE_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CNSTR_CMPNY_NM (type: esriFieldTypeString, alias: CNSTR_CMPNY_NM, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• CNSTR_CMPNY_PH_NBR (type: esriFieldTypeString, alias: CNSTR_CMPNY_PH_NBR, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• CNSTR_CMPNY_LAST_UPDATE_DT (type: esriFieldTypeDate, alias: CNSTR_CMPNY_LAST_UPDATE_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CNSTR_NTPD_DT (type: esriFieldTypeDate, alias: CNSTR_NTPD_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CNSTR_WKBG_DT (type: esriFieldTypeDate, alias: CNSTR_WKBG_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CNST_EST_CMPLT_DT (type: esriFieldTypeDate, alias: CNST_EST_CMPLT_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CNSTR_PCT_TIME_USED (type: esriFieldTypeSingle, alias: CNSTR_PCT_TIME_USED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CNSTR_PCT_COMPLETE (type: esriFieldTypeSingle, alias: CNSTR_PCT_COMPLETE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAST_CNSTR_UPDATE_DT (type: esriFieldTypeDate, alias: LAST_CNSTR_UPDATE_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DSGN_START_TRGT_DT (type: esriFieldTypeDate, alias: DSGN_START_TRGT_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DSGN_START_ACTL_DT (type: esriFieldTypeDate, alias: DSGN_START_ACTL_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PSE_30_TRGT_DT (type: esriFieldTypeDate, alias: PSE_30_TRGT_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PSE_30_ACTL_DT (type: esriFieldTypeDate, alias: PSE_30_ACTL_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PSE_60_TRGT_DT (type: esriFieldTypeDate, alias: PSE_60_TRGT_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PSE_60_ACTL_DT (type: esriFieldTypeDate, alias: PSE_60_ACTL_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PSE_100_TRGT_DT (type: esriFieldTypeDate, alias: PSE_100_TRGT_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PSE_100_ACTL_DT (type: esriFieldTypeDate, alias: PSE_100_ACTL_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ENVCLR_TRGT_DT (type: esriFieldTypeDate, alias: ENVCLR_TRGT_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ENVCLR_ACTL_DT (type: esriFieldTypeDate, alias: ENVCLR_ACTL_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• UTIL_TRGT_DT (type: esriFieldTypeDate, alias: UTIL_TRGT_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• UTIL_ACTL_DT (type: esriFieldTypeDate, alias: UTIL_ACTL_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ROW_TRGT_DT (type: esriFieldTypeDate, alias: ROW_TRGT_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ROW_ACTL_DT (type: esriFieldTypeDate, alias: ROW_ACTL_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RTL_TRGT_DT (type: esriFieldTypeDate, alias: RTL_TRGT_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RTL_ACTL_DT (type: esriFieldTypeDate, alias: RTL_ACTL_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LAST_MLSTN_UPDATE_DT (type: esriFieldTypeDate, alias: LAST_MLSTN_UPDATE_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PE_SPENT_AMT (type: esriFieldTypeDouble, alias: PE_SPENT_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CNSTR_SPENT_AMT (type: esriFieldTypeDouble, alias: CNSTR_SPENT_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CE_SPENT_AMT (type: esriFieldTypeDouble, alias: CE_SPENT_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_SPENT_AMT (type: esriFieldTypeDouble, alias: TOT_SPENT_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAST_FIN_UPDATE_DT (type: esriFieldTypeDate, alias: LAST_FIN_UPDATE_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FUND_CAT1_DSCR (type: esriFieldTypeString, alias: FUND_CAT1_DSCR, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FUND_CAT1_PID (type: esriFieldTypeString, alias: FUND_CAT1_PID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FUND_CAT1_AMT (type: esriFieldTypeDouble, alias: FUND_CAT1_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUND_CAT2_DSCR (type: esriFieldTypeString, alias: FUND_CAT2_DSCR, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FUND_CAT2_PID (type: esriFieldTypeString, alias: FUND_CAT2_PID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FUND_CAT2_AMT (type: esriFieldTypeDouble, alias: FUND_CAT2_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUND_CAT3_DSCR (type: esriFieldTypeString, alias: FUND_CAT3_DSCR, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FUND_CAT3_PID (type: esriFieldTypeString, alias: FUND_CAT3_PID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FUND_CAT3_AMT (type: esriFieldTypeDouble, alias: FUND_CAT3_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUND_CAT4_DSCR (type: esriFieldTypeString, alias: FUND_CAT4_DSCR, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FUND_CAT4_PID (type: esriFieldTypeString, alias: FUND_CAT4_PID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FUND_CAT4_AMT (type: esriFieldTypeDouble, alias: FUND_CAT4_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUND_CAT5_DSCR (type: esriFieldTypeString, alias: FUND_CAT5_DSCR, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FUND_CAT5_PID (type: esriFieldTypeString, alias: FUND_CAT5_PID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FUND_CAT5_AMT (type: esriFieldTypeDouble, alias: FUND_CAT5_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUND_CAT6_DSCR (type: esriFieldTypeString, alias: FUND_CAT6_DSCR, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FUND_CAT6_PID (type: esriFieldTypeString, alias: FUND_CAT6_PID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FUND_CAT6_AMT (type: esriFieldTypeDouble, alias: FUND_CAT6_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUND_CAT7_DSCR (type: esriFieldTypeString, alias: FUND_CAT7_DSCR, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FUND_CAT7_PID (type: esriFieldTypeString, alias: FUND_CAT7_PID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FUND_CAT7_AMT (type: esriFieldTypeDouble, alias: FUND_CAT7_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUND_CAT8_DSCR (type: esriFieldTypeString, alias: FUND_CAT8_DSCR, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FUND_CAT8_PID (type: esriFieldTypeString, alias: FUND_CAT8_PID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FUND_CAT8_AMT (type: esriFieldTypeDouble, alias: FUND_CAT8_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUND_CAT9_DSCR (type: esriFieldTypeString, alias: FUND_CAT9_DSCR, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FUND_CAT9_PID (type: esriFieldTypeString, alias: FUND_CAT9_PID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FUND_CAT9_AMT (type: esriFieldTypeDouble, alias: FUND_CAT9_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUND_CAT10_DSCR (type: esriFieldTypeString, alias: FUND_CAT10_DSCR, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FUND_CAT10_PID (type: esriFieldTypeString, alias: FUND_CAT10_PID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FUND_CAT10_AMT (type: esriFieldTypeDouble, alias: FUND_CAT10_AMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAST_FUND_UPDATE_DT (type: esriFieldTypeDate, alias: LAST_FUND_UPDATE_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• UTP_ID (type: esriFieldTypeString, alias: UTP_ID, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PT_TOP100 (type: esriFieldTypeString, alias: PT_TOP100, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ESRI_OID (type: esriFieldTypeOID, alias: ESRI_OID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)

Templates:

Name: PT.dbo.vwPTProjects
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/14/2025 2:05:18 PM

Schema Last Edit Date: 7/14/2025 2:05:18 PM

Data Last Edit Date: 7/14/2025 2:05:18 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat