[evla-sw-discuss] Scheduling block

[Walter Brisken]

If you include constraints such as maximum wind speeds and API, then also 
including minimum solar separation seems wise (or equivalently and 
possibly more generally, black-out date range(s) -- is this covered under 
date_code, etc?)

I worry that "project" and "program" meaning different things may cause 
confusion.

-W

On Tue, 8 Nov 2005, Barry Clark wrote:

> Here is the scheduling block currently used by the dynamic scheduler.
>
> create table sb (
>    /* Proposal code */
>    proposal   varchar2(12) not null,
>
>    /* Project code - projects are selected by Proposal Selection Committee */
>    project    varchar2(4) not null,
>
>    /* Program code - distinguish different array configurations */
>    program    varchar2(4) not null,
>
>    /* Scheduling block ID */
>    sb         varchar2(4) not null,
>
>    /* VLA configuration code */
>    config     varchar2(8) not null,
>
>    /* Proposal could also be run in this configuration */
>    alt_config varchar2(8),
>
>    /* or this one */
>    alt_config2 varchar2(8),
>
>    /* Authorized number of times SB is to be run */
>    auth_count number not null,
>
>    /* Number of times remaining */
>    count      number not null,
>
>    /* Length of time SB will require */
>    hours      float not null,
>
>    /* SB may not start earlier than this LST */
>    start_early float not null,
>
>    /* SB may not start later than this LST */
>    start_late  float not null,
>
>    /* Date needs - 'R' = fixed date scheduling, 'S' = general preference,
>       'M' monitoring observations, 'P' preferred phase of periodic phenom
>       At the moment, only 'R' is used - may move the others into the
>       project */
>    date_code   varchar2(12),
>
>    /* If date code not null, Local Sideral Day preferred */
>    date_req    number,
>
>    /* interval in days if monitoring or periodic phenomenon */
>    date_interval number,
>
>    /* Band Codes - single characters concatenated */
>    bands	varchar2(12),
>
>    /* do not schedule with higher winds */
>    wind_limit   float not null,
>
>    /* do not schedule if Atmospheric Phase Interferometer indicates
>       greater instability */
>    api_limit    float not null,
>
>    /* Priority based on referee ratings */
>    priority_ref float not null,
>
>    /* Priority class assigned by PSC */
>    priority_sch float not null,
>
>    /* Computed priority (by project manager, etc.) */
>    priority_cmp float not null,
>
>    /* Special priority - assigned by scheduling officer for special purpose */
>    priority_sp  float not null,
>
>    /* If non-zero temporary hold placed on scheduling by scheduling officer */
>    hold number not null
>    );
> _______________________________________________
> evla-sw-discuss mailing list
> evla-sw-discuss at listmgr.cv.nrao.edu
> http://listmgr.cv.nrao.edu/mailman/listinfo/evla-sw-discuss
>