Name: Louisville_Metro_KY_Total_Hours_Worked

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:

• L_ACCT (type: esriFieldTypeInteger, alias: L_ACCT, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• L_FUND (type: esriFieldTypeInteger, alias: L_FUND, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• WORKED_HRS_TYPE (type: esriFieldTypeString, alias: WORKED_HRS_TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• L_DIVISION (type: esriFieldTypeInteger, alias: L_DIVISION, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• DivName (type: esriFieldTypeString, alias: DivName, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DEPTID (type: esriFieldTypeInteger, alias: DEPTID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Dept (type: esriFieldTypeString, alias: Dept, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SubDept (type: esriFieldTypeString, alias: SubDept, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• BIWEEKLY_PAY_PERIOD_END_DATE (type: esriFieldTypeDate, alias: BIWEEKLY_PAY_PERIOD_END_DATE, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• FiscalYear (type: esriFieldTypeInteger, alias: FiscalYear, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• EARN_CODE (type: esriFieldTypeString, alias: EARN_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• EARN_DESCR (type: esriFieldTypeString, alias: EARN_DESCR, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• AMOUNT_HOURS (type: esriFieldTypeDouble, alias: AMOUNT_HOURS, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• AMOUNT_DOLLARS (type: esriFieldTypeDouble, alias: AMOUNT_DOLLARS, SQL Type: sqlTypeFloat, 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: 5/23/2024 3:41:28 PM

Schema Last Edit Date: 5/23/2024 3:41:28 PM

Data Last Edit Date: 11/12/2023 1:31:22 PM

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