Name: Louisville_Metro_KY_HR_Requisition_Log

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)
• SLOT__ (type: esriFieldTypeString, alias: SLOT #, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• JOB_TITLE (type: esriFieldTypeString, alias: JOB TITLE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DEPARTMENT (type: esriFieldTypeString, alias: DEPARTMENT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DATE_REC_D (type: esriFieldTypeString, alias: DATE REC'D, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• APPROVAL_REC_D (type: esriFieldTypeString, alias: APPROVAL REC'D, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• JOB_CODE (type: esriFieldTypeInteger, alias: JOB CODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• UNION_ (type: esriFieldTypeString, alias: UNION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DATE_SLOT_VACATED (type: esriFieldTypeString, alias: DATE SLOT VACATED, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TO_HRIS (type: esriFieldTypeString, alias: TO HRIS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FROM_HRIS (type: esriFieldTypeString, alias: FROM HRIS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DATE_POSTED (type: esriFieldTypeString, alias: DATE POSTED, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CLOSING_DATE (type: esriFieldTypeString, alias: CLOSING DATE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• RECOMMENDATION_FOR_HIRE (type: esriFieldTypeDate, alias: RECOMMENDATION FOR HIRE, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• OFFER_DATE (type: esriFieldTypeDate, alias: OFFER DATE, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• DATE_ACCEPTED (type: esriFieldTypeDate, alias: DATE ACCEPTED, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• PERSON_HIRED (type: esriFieldTypeString, alias: PERSON HIRED, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• TYPE_OF_HIRE (type: esriFieldTypeString, alias: TYPE OF HIRE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• HIRE_STATUS (type: esriFieldTypeString, alias: HIRE STATUS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• RECRUITER (type: esriFieldTypeString, alias: RECRUITER, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• START_DATE (type: esriFieldTypeDate, alias: START DATE, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• WORK_STATUS (type: esriFieldTypeString, alias: WORK STATUS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STANDARD_HOURS (type: esriFieldTypeString, alias: STANDARD HOURS, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• WORK_LOCATION (type: esriFieldTypeString, alias: WORK LOCATION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• INACTIVE_CODE (type: esriFieldTypeString, alias: INACTIVE CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• INACTIVE_DATE (type: esriFieldTypeString, alias: INACTIVE DATE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• COPY_OF_REQ_AND_APPROVAL (type: esriFieldTypeString, alias: COPY OF REQ AND APPROVAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FINAL_REQ_SENT_TO_HRIS (type: esriFieldTypeString, alias: FINAL REQ SENT TO HRIS, SQL Type: sqlTypeNVarchar, length: 256, 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: 6/18/2022 2:23:49 AM

Schema Last Edit Date: 6/18/2022 2:23:49 AM

Data Last Edit Date: 6/18/2022 2:23:49 AM

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