A period, or periods, of time where the resource is unavailable for work.
Syntax:
[ DynamicComponentDependency ] ramunavailability RAMUnavailabilityName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | A unique id. | |
ram_resource_id | String(32) | The id of the resource this applies to. | |
ram_time_pattern_id | String(32) | The periods of time for which the resource is unavailable. | |
ram_unavailability_category_id | String(32) | The category of unavailability. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
description | String(2000) | A description of the unavailability. | |
group_id | String(32) | Used to apply the same unavailability to multiple resources. | |
ram_location_id | String(32) | The location where the resource will be when unavailable. |
ramunavailability RAMUnavailability {{SelectName}} { SELECT .. id, .. ram_resource_id, .. ram_time_pattern_id, .. ram_unavailability_category_id, -- optional columns .. description, .. group_id, .. ram_location_id FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMUnavailability.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.