Layer: Request_for_Training

View In: Map Viewer

Name: Request_for_Training_1

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Request for Training 1","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
rtaexpense (type: esriFieldTypeString, alias: Is this an Request for Training or a Expense Worksheet?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [RTA: Request For Training], [EW: Expense Worksheet])
hrrep (type: esriFieldTypeString, alias: Human Resource Representative, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [HR Rep 1: HR Rep 1])
hrdate (type: esriFieldTypeDate, alias: HR Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
hrapproval (type: esriFieldTypeString, alias: HR Approval or Disapproval, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Approve: Approve], [Disapprove: Disapprove], [Pending: Pending])
hrnote (type: esriFieldTypeString, alias: If you selected to disapprove the training, please put in notes why and what changes the employee need to do., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
deptdirectorappdate (type: esriFieldTypeDate, alias: Department Director Approval/Disapproval Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
deptdirectorapproval (type: esriFieldTypeString, alias: Department Director Approved or Disapprove, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Approve: Approve], [Disapprove: Disapprove], [Pending: Pending])
deptdirectornote (type: esriFieldTypeString, alias: If you selected to disapprove the training, please put in notes why and what changes the employee need to do., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
submitdate (type: esriFieldTypeDate, alias: Date Submitted by Employee, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
officer (type: esriFieldTypeString, alias: Employee Requesting Training, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [dean.alexander@stcharlescitymo.gov: Alexander, Dean], [dan.allen@stcharlescitymo.gov: Allen, Dan], [michael.aulbert@stcharlescitymo.gov: Aulbert, Michael], ... 103 more ...)
department (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Police Department: Police Department])
platoon (type: esriFieldTypeString, alias: Assigned Platoon, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [A PLT: A PLT], [B PLT: B PLT], [C PLT: C PLT], ... 5 more ...)
supervisoremail (type: esriFieldTypeString, alias: Schedule Supervisor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Brian.Jurgensmeier@stcharlescitymo.gov: LT Jurgensmeier], [Susan.Shields@stcharlescitymo.gov: LT Shields], [Roderick.Jones@stcharlescitymo.gov: LT Jones], ... 6 more ...)
trainingtitle (type: esriFieldTypeString, alias: Title of Training, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
vendor (type: esriFieldTypeString, alias: Vendor / Sponsor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
vendornumber (type: esriFieldTypeString, alias: Vendor / Sponsor Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
startdate (type: esriFieldTypeDate, alias: Start of Training, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
enddate (type: esriFieldTypeDate, alias: End of Training, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
location (type: esriFieldTypeString, alias: Address of Training, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
hotelneed (type: esriFieldTypeString, alias: Will you have a hotel stay for this training?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
hotel_address (type: esriFieldTypeString, alias: Hotel Name and Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
hotel_daily (type: esriFieldTypeDouble, alias: Hotel Daily Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
othertrainees (type: esriFieldTypeString, alias: Employees Also Attending Training, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
totaldays (type: esriFieldTypeDouble, alias: Total Travel and Training Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
airfare (type: esriFieldTypeDouble, alias: Estimated Airfare Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
autoexpense (type: esriFieldTypeDouble, alias: Estimated Auto Expense (List road trip miles), SQL Type: sqlTypeOther, nullable: true, editable: true)
shuttle_taxi (type: esriFieldTypeDouble, alias: Shuttle, Uber, Lyft, Taxi, Parking, SQL Type: sqlTypeOther, nullable: true, editable: true)
hotel_room (type: esriFieldTypeDouble, alias: Hotel Room, SQL Type: sqlTypeOther, nullable: true, editable: true)
breakfast (type: esriFieldTypeDouble, alias: How many days will you need breakfast?, SQL Type: sqlTypeOther, nullable: true, editable: true)
lunch (type: esriFieldTypeDouble, alias: How many days will you need lunch?, SQL Type: sqlTypeOther, nullable: true, editable: true)
dinner (type: esriFieldTypeDouble, alias: How many days will you need dinner?, SQL Type: sqlTypeOther, nullable: true, editable: true)
totalmealcost (type: esriFieldTypeDouble, alias: Total Meal Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
registration (type: esriFieldTypeDouble, alias: Registration Fee, SQL Type: sqlTypeOther, nullable: true, editable: true)
registrationfee (type: esriFieldTypeString, alias: Are there any early registration fee discounts or any "must register" by dates?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
otherexpense (type: esriFieldTypeDouble, alias: Other Expenses (please list other expenses in below box), SQL Type: sqlTypeOther, nullable: true, editable: true)
otherexpensetext (type: esriFieldTypeString, alias: List Other Expenses Here, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
total (type: esriFieldTypeDouble, alias: Total Expense, SQL Type: sqlTypeOther, nullable: true, editable: true)
advancepay (type: esriFieldTypeString, alias: Do you require any Advance Payments for this training?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
airfareadvance (type: esriFieldTypeDouble, alias: Advanced Estimated Airfare Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
autoexpenseadvance (type: esriFieldTypeDouble, alias: Advanced Estimated Auto Expense (List road trip miles), SQL Type: sqlTypeOther, nullable: true, editable: true)
shuttle_taxiadvance (type: esriFieldTypeDouble, alias: Advanced Shuttle, Uber, Lyft, Taxi, Parking, SQL Type: sqlTypeOther, nullable: true, editable: true)
hotel_roomadvance (type: esriFieldTypeDouble, alias: Advanced Hotel Room, SQL Type: sqlTypeOther, nullable: true, editable: true)
meal_expenseadvance (type: esriFieldTypeDouble, alias: Advanced Meal Expenses (not provided by training/conference/hotel), SQL Type: sqlTypeOther, nullable: true, editable: true)
registrationadvance (type: esriFieldTypeDouble, alias: Advanced Registration Fee, SQL Type: sqlTypeOther, nullable: true, editable: true)
otherexpenseadvance (type: esriFieldTypeDouble, alias: Advanced Other Expenses (please list other expenses in below box), SQL Type: sqlTypeOther, nullable: true, editable: true)
otherexpensetextadvance (type: esriFieldTypeString, alias: Advanced List Other Expenses Here, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
totaladvance (type: esriFieldTypeDouble, alias: Advanced Total Expense, SQL Type: sqlTypeOther, nullable: true, editable: true)
trainingreason (type: esriFieldTypeString, alias: Describe specific needs for the training and how the department and the employee will benefit., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
localtraining (type: esriFieldTypeString, alias: Is the requested training offered locally within one (1) calendar year of this request?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
localreason (type: esriFieldTypeString, alias: If training is offered locally, what is the reason for requesting outside local area?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
attend_submit (type: esriFieldTypeString, alias: I agree to attend the required training and submit the Expense List Reimbursement for Travel (found on PD Intranet) within ten (10) days of my return to the Chiefs Office., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [I Agree: I Agree], [I Disagree: I Disagree])
supervisorfixyes (type: esriFieldTypeString, alias: Have you corrected the Schedule Supervisor requested changes?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
schedulecontinue (type: esriFieldTypeString, alias: Please ignore approval status questions and navigate to the "Submit" button immediately to submit., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bureaufixyes (type: esriFieldTypeString, alias: Have you corrected the Bureau Commander requested changes?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
bureaucontinue (type: esriFieldTypeString, alias: Please ignore approval status questions and navigate to the "Submit" button immediately to submit., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
traincoordfixyes (type: esriFieldTypeString, alias: Have you corrected the Training Coordinator requested changes?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
traincoordcontinue (type: esriFieldTypeString, alias: Please ignore approval status questions and navigate to the "Submit" button immediately to submit., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
deptdirfixyes (type: esriFieldTypeString, alias: Have you corrected the Department Director requested changes?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
deptdircontinue (type: esriFieldTypeString, alias: Please ignore approval status questions and navigate to the "Submit" button immediately to submit., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
hrfixyes (type: esriFieldTypeString, alias: Have you corrected the Human Resources requested changes?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
hrcontinue (type: esriFieldTypeString, alias: Please ignore approval status questions and navigate to the "Submit" button immediately to submit., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
supervisor (type: esriFieldTypeString, alias: Are you an approving supervisor?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
schedulesup (type: esriFieldTypeString, alias: Scheduling Supervisor Approval, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Brian.Jurgensmeier@stcharlescitymo.gov: LT Jurgensmeier], [Susan.Shields@stcharlescitymo.gov: LT Shields], [Roderick.Jones@stcharlescitymo.gov: LT Jones], ... 5 more ...)
scheduleappdate (type: esriFieldTypeDate, alias: Approval/Disapproval Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
scheduleapproval (type: esriFieldTypeString, alias: Approved or Disapprove, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Approve: Approve], [Disapprove: Disapprove], [Pending: Pending])
schedulenote (type: esriFieldTypeString, alias: If you selected to disapprove the training, please put in notes why and what changes the employee need to do., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
meetsreq (type: esriFieldTypeString, alias: Does training meet with Departmental objectives and will Department benefit from the employee attending the requested training?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
trainingcord (type: esriFieldTypeString, alias: Training Coordinator Approval, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Susan.Shields@stcharlescitymo.gov: LT Shields])
trainingcordappdate (type: esriFieldTypeDate, alias: Approval/Disapproval Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
trainingcordapproval (type: esriFieldTypeString, alias: Approved or Disapprove, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Approve: Approve], [Disapprove: Disapprove], [Pending: Pending])
traincoordnote (type: esriFieldTypeString, alias: If you selected to disapprove the training, please put in notes why and what changes the employee need to do., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bureaucommand (type: esriFieldTypeString, alias: Bureau Command Approval, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Raymond.Floyd@stcharlescitymo.gov: CPT Floyd], [George.Grove@stcharlescitymo.gov: CPT Grove], [Ray.Juengst@stcharlescitymo.gov: Chief Juengst])
bureaucommandcordappdate (type: esriFieldTypeDate, alias: Approval/Disapproval Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bureaucommandapproval (type: esriFieldTypeString, alias: Approved or Disapprove, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Approve: Approve], [Disapprove: Disapprove], [Pending: Pending])
bureaucommandnote (type: esriFieldTypeString, alias: If you selected to disapprove the training, please put in notes why and what changes the employee need to do., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day1 (type: esriFieldTypeString, alias: Day 1 Travel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day2 (type: esriFieldTypeString, alias: Day 2 Travel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day3 (type: esriFieldTypeString, alias: Day 3 Travel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day4 (type: esriFieldTypeString, alias: Day 4 Travel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day5 (type: esriFieldTypeString, alias: Day 5 Travel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day6 (type: esriFieldTypeString, alias: Day 6 Travel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day1to (type: esriFieldTypeString, alias: City To, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day2to (type: esriFieldTypeString, alias: City To, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day3to (type: esriFieldTypeString, alias: City To, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day4to (type: esriFieldTypeString, alias: City To, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day5to (type: esriFieldTypeString, alias: City To, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day6to (type: esriFieldTypeString, alias: City To, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day1from (type: esriFieldTypeString, alias: City From, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day2from (type: esriFieldTypeString, alias: City From, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day3from (type: esriFieldTypeString, alias: City From, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day4from (type: esriFieldTypeString, alias: City From, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day5from (type: esriFieldTypeString, alias: City From, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day6from (type: esriFieldTypeString, alias: City From, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
day1airfare (type: esriFieldTypeDouble, alias: Airfare, SQL Type: sqlTypeOther, nullable: true, editable: true)
day2airfare (type: esriFieldTypeDouble, alias: Airfare, SQL Type: sqlTypeOther, nullable: true, editable: true)
day3airfare (type: esriFieldTypeDouble, alias: Airfare, SQL Type: sqlTypeOther, nullable: true, editable: true)
day4airfare (type: esriFieldTypeDouble, alias: Airfare, SQL Type: sqlTypeOther, nullable: true, editable: true)
day5airfare (type: esriFieldTypeDouble, alias: Airfare, SQL Type: sqlTypeOther, nullable: true, editable: true)
day6airfare (type: esriFieldTypeDouble, alias: Airfare, SQL Type: sqlTypeOther, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
admintrain (type: esriFieldTypeString, alias: Approved or Disapprove, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Approve: Approve], [Disapprove: Disapprove], [Pending: Pending])
admintrainnote (type: esriFieldTypeString, alias: If you selected to disapprove the training, please put in notes why and what changes the employee need to do. , SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
totaldaystrain (type: esriFieldTypeDouble, alias: Total Training Days, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/26/2025 2:36:29 PM

Schema Last Edit Date: 11/26/2025 2:36:29 PM

Data Last Edit Date: 11/26/2025 2:36:29 PM

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

Layer: Request_for_Training_1 (ID:0)