[evla-sw-discuss] Scheduling block

[Barry Clark]

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 
    );