Definition of table scan-form-batch
Scan form batch. Each set of scan forms printed becomes a 'batch' that can be reviewed later using a browser. , Table Dump Name scn-bath

Alphabetical Field Summary

  • batch-id: (INTG) Internally assigned batch ID [DEFINE KEY]
  • bldg-id: (INTG) Building ID for this form
  • cre-date: (DATE) Date record was created
  • cre-time: (CHAR) Time record was created at
  • cre-user-name: (CHAR) User name of user who creatd this record
  • delete-batch: (LOGC) Should this batch be deleted later?
  • description: (CHAR) Description of this batch
  • end-date: (DATE) Ending date this form is valid for
  • extern-guid: (CHAR) External Global Unique ID for this record
  • form-id: (INTG) Internally assigned form ID
  • last-printed-on: (DATE) Date form was last printed on
  • last-read-on: (DATE) Date form was last read on
  • misc-id: (INTG) Misc ID for this batch (i.e. period ID for grading, etc)
  • misc-name: (CHAR) Set only when misc-id is set. Descriptive text for ID
  • school-year-id: (INTG) School year ID associated with this record
  • start-date: (DATE) Starting date this form is valid for
  • upd-date: (DATE) Date this records was last updated on
  • upd-time: (CHAR) Time the record was last updated at
  • upd-user-name: (CHAR) Name of user who last updated this record

    Alphabetical Index Summary

  • description: school-year-id, bldg-id, form-id, description, batch-id
  • extern-guid: extern-guid
  • scan-batch-date: school-year-id, bldg-id, form-id, start-date, end-date, batch-id
  • scan-batch-id: (UNIQUE, PRIMARY) school-year-id, bldg-id, form-id, batch-id
  • scan-delete: delete-batch, start-date, batch-id

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-sfb.p (SOURCE NOT AVAILABLE)
  • DELETE: Overridable, Procedure is tr-d-sfb.p (SOURCE NOT AVAILABLE)
  • REPLICATION-CREATE: Procedure is rp-c-sfb.p (SOURCE NOT AVAILABLE)
  • REPLICATION-DELETE: Procedure is rp-d-sfb.p (SOURCE NOT AVAILABLE)
  • REPLICATION-WRITE: Procedure is rp-u-sfb.p (SOURCE NOT AVAILABLE)
  • WRITE: Overridable, Procedure is tr-u-sfb.p (SOURCE NOT AVAILABLE)

    Other tables who reference scan-form-batch

  • scan-form-dataset - Scan form datasets. Many forms are simple and only have one
  • scan-form-line - Scan Form Line info
  • scan-form-sheet - Scan Form Sheets

    Tables scan-form-batch references

  • building - One record for each building, for each scheduling version, f
  • form-bldg - Form definitions, on a per building level
  • form-def - Forms Definitions
  • grading-setup - Grading setup controls building level setup/policy issues wi
  • school-year - School year file
  • user-bldg - User Restricted to building list

    Detailed Alphabetical Field Listing
    batch-id Data type: INTEGER
    Format: zzzzzzzzzz9
    Description: Internally assigned batch ID [DEFINE KEY]
    Attributes: Index Component

    bldg-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Building ID for this form
    Attributes: Index Component

    cre-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Help: Date record was created

    cre-time Data type: CHARACTER
    Format: x(8)
    Help: Time record was created at

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Help: User name of user who creatd this record

    delete-batch Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Should this batch be deleted later?
    Attributes: Index Component

    description Data type: CHARACTER
    Format: x(28)
    Help: Description of this batch
    Attributes: Index Component

    end-date Data type: DATE
    Format: 99/99/9999
    Help: Ending date this form is valid for
    Attributes: Index Component

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record
    Attributes: Index Component

    form-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Internally assigned form ID
    Attributes: Index Component

    last-printed-on Data type: DATE
    Format: 99/99/9999
    Help: Date form was last printed on

    last-read-on Data type: DATE
    Format: 99/99/9999
    Help: Date form was last read on

    misc-id Data type: INTEGER
    Format: zzzzzzzzzz9
    Description: Misc ID for this batch (i.e. period ID for grading, etc)

    misc-name Data type: CHARACTER
    Format: x(12)
    Description: Set only when misc-id is set. Descriptive text for ID

    school-year-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: School year ID associated with this record
    Attributes: Index Component

    start-date Data type: DATE
    Format: 99/99/9999
    Help: Starting date this form is valid for
    Attributes: Index Component

    upd-date Data type: DATE
    Format: 99/99/9999
    Help: Date this records was last updated on

    upd-time Data type: CHARACTER
    Format: x(8)
    Help: Time the record was last updated at

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Help: Name of user who last updated this record

    Created on 05/07/2012 by DBHTML V1.2