Definition of table scan-form-dataset
Scan form datasets. Many forms are simple and only have one dataset (like a requests sheet). Other forms, like certain daily attendance forms will have multiple datasets on one sheet (like 1 per day of the week). , Table Dump Name scn-dset

Alphabetical Field Summary

  • batch-id: (INTG) Internally assigned batch ID
  • 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
  • dataset-date: (DATE) Date associated with this dataset, if any
  • dataset-num: (INTG) [DEFINE KEY]
  • extern-guid: (CHAR) External Global Unique ID for this record
  • form-id: (INTG) Internally assigned form ID
  • form-seq: (INTG) Form Sequence #
  • last-read-on: (DATE) Date sheet was last read on (if any)
  • misc-id: (INTG) Misc ID for this dataset
  • misc-name: (CHAR) Set only when misc-id is set. Descriptive text for ID
  • primary-key: (INTG) Unique, Primary key for record
  • school-year-id: (INTG) School year ID associated with this record
  • 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

  • extern-guid: extern-guid
  • scan-form-dataset: (UNIQUE, PRIMARY) school-year-id, bldg-id, form-id, batch-id, form-seq, dataset-num

    Alphabetical Trigger Summary

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

    Other tables who reference scan-form-dataset

  • scan-form-line - Scan Form Line info

    Tables scan-form-dataset references

  • building - One record for each building, for each scheduling version, f
  • email-info - (no description available)
  • form-bldg - Form definitions, on a per building level
  • form-def - Forms Definitions
  • grading-setup - Grading setup controls building level setup/policy issues wi
  • scan-form-batch - Scan form batch. Each set of scan forms printed becomes a 'b
  • scan-form-sheet - Scan Form Sheets
  • school-year - School year file
  • spm-prof - SPM Profile/Base record. Only 1 per system!
  • user-bldg - User Restricted to building list

    Detailed Alphabetical Field Listing
    batch-id Data type: INTEGER
    Format: zzzzzzzzzz9
    Description: Internally assigned batch ID
    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

    dataset-date Data type: DATE
    Format: 99/99/9999
    Description: Date associated with this dataset, if any

    dataset-num Data type: INTEGER
    Format: z9
    Description: [DEFINE KEY]
    Help: Data set #
    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

    form-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Form Sequence #
    Attributes: Index Component

    last-read-on Data type: DATE
    Format: 99/99/9999
    Help: Date sheet was last read on (if any)

    misc-id Data type: INTEGER
    Format: zzzzzzzzzz9
    Description: Misc ID for this dataset

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

    primary-key Data type: INTEGER
    Format: zzzzzzzzzzzz
    Help: Unique, Primary key for record

    school-year-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: School year ID associated with this record
    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