OPSSkillTypes
Name: OPS Skill Types
Type: Ancillary
Modules: OPS-Bidding, OPS-Dispatch, OPS-Workforce Management
Description: Contains user-defined skill types.
| Field | Documentation |
|---|---|
| SkillTypeId | Unique identifier for a skill type. |
| SkillAbbr | Abbreviation of the skill type. |
| Description.OPSSkillTypes | Description of the skill type. |
| DriverLicenceFlag | If true, this skill will also reflect and display driver licence info. |
| TrainingThresholdDays | Number of training days required to grant new employees this skill. |
| ContainSkillList | Comma separated list of other skills that this parent skill will automatically check. |
| ExpirationFlag | If true, the skill can expire. |
| ExpirationThreshold | Number of days in advance of the expiration that warning notifications will be generated. |
| ThresholdMessageFlag | If true, warning notifications will be generated as Employee Messages. |
| DataCardFlag | Indicates where the skill's expiration date appears in the Employee Profile screen (Skills, and Skills and Data Card). |
| DormancyType | Dormancy type (0 = Skill cannot become Dormant, 1 = Work Dormancy, 2 = Vehicle Dormancy, 3 = Manual Dormancy/Suspension). |
| WorkStatusGroup | List of work types that we need to check the last date they had one or more of this type of work. |
| VehicleTypeGroup | List of vehicle types that are checked to determine the last time the employee operated this type of vehicle. |
| DormancyThreshold | Used in conjunction with the DormancyType (1, 2). If the DormancyType = 1, if the employee has not performed specific work assignments (contained in the WorkingStatusGroup) within this number of days, their skill will become dormant. If the DormancyType = 2, if the employee has not operated a vehicle type (contained in the VehicleTypeGroup) within this number of days, their skill will become dormant. |
| DormancyWarningThreshold | Number of days in advance of reaching the dormancy threshold that warning notifications will be generated. |
| DormancyMessageFlag | If true, dormancy warning notifications will be generated as Employee Messages. |
| ApplicationList | Comma separated list of OPS Modules where validation of this skill will occur (1 = Bidding, 2 = Work Planner, 3 = Assignment Assistant, 4 = Daily Activity, 5 = Activate Day). |
| ColumnName | Column from Employees table where the skill's expiration date is also defined. |
| ModBy | User who last modified the record. |
| ModDate | Date the record was last modified. |
| ModTime | Time the record was last modified. Value is in seconds from midnight. |
| ModAction | Last action performed on the record. |