Definition of table scan-form-sheet
Scan Form Sheets , Table Dump Name scn-shet

Alphabetical Field Summary

  • batch-id: (INTG) Internally assigned batch ID
  • bldg-id: (INTG) Building ID for this form
  • course-id: (INTG) Set only if sheet is 'course' based. Otherwise ?
  • 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
  • data-line-cnt: (INTG) # of data lines printed on the sheet
  • dataset-cnt: (INTG) Usually 1, possibly more for daily attendance sheets (Grand
  • extern-guid: (CHAR) External Global Unique ID for this record
  • form-id: (INTG) Internally assigned form ID
  • form-seq: (INTG) [DEFINE KEY]
  • last-printed-on: (DATE) Date form was last printed on
  • last-read-on: (DATE) Date form was last read on
  • misc-id: (INTG) Set only if sheet is not course or student based
  • misc-name: (CHAR) Set only when misc-id is set. Mnemonic for sheet basis
  • primary-key: (INTG) Unique, Primary key for record
  • school-year-id: (INTG) School year ID associated with this record
  • section-id: (INTG) Set only if sheet is course/section based. Otherwise ?
  • sheet-printed: (LOGC) Yes if sheet has been printed, No if not
  • stu-seq: (INTG) Set only if sheet is 'student' based. Otherwise ?
  • 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-sheet: (UNIQUE, PRIMARY) school-year-id, bldg-id, form-id, batch-id, form-seq
  • sheet-by-course: school-year-id, bldg-id, course-id, section-id, form-id, batch-id, form-seq
  • sheet-by-misc: school-year-id, bldg-id, misc-name, misc-id, form-id, batch-id, form-seq
  • sheet-by-stu: school-year-id, bldg-id, stu-seq, form-id, batch-id, form-seq
  • sheet-printed: school-year-id, bldg-id, form-id, batch-id, sheet-printed, form-seq

    Alphabetical Trigger Summary

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

    Other tables who reference scan-form-sheet

  • form-bldg - Form definitions, on a per building level
  • scan-form-dataset - Scan form datasets. Many forms are simple and only have one
  • scan-form-line - Scan Form Line info

    Tables scan-form-sheet references

  • building - One record for each building, for each scheduling version, f
  • course-catalog - Course Catalog
  • course-stats - Course Request statistics
  • credential-area-course - (no description available)
  • 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
  • master-schd - Master Schedule records One entry per course, per section fo
  • master-schd-display - This is a transient table used for master schedule display s
  • scan-form-batch - Scan form batch. Each set of scan forms printed becomes a 'b
  • school-year - School year file
  • spm-prof - SPM Profile/Base record. Only 1 per system!
  • stu-assign - (no description available)
  • stu-base - Student Base record
  • stu-request-master - Student Request Master Controls
  • stu-year - One record for each year a student exists in the district
  • 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

    course-id Data type: INTEGER
    Format: zzzzzzzzz9
    Description: Set only if sheet is 'course' based. Otherwise ?
    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

    data-line-cnt Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Help: # of data lines printed on the sheet

    dataset-cnt Data type: INTEGER
    Format: zz9 (Initial Value: 1)
    Description: Usually 1, possibly more for daily attendance sheets (Grand
    Help: Number of datasets on form

    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
    Description: [DEFINE KEY]
    Help: Form Sequence #
    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: Set only if sheet is not course or student based
    Attributes: Index Component

    misc-name Data type: CHARACTER
    Format: x(12)
    Description: Set only when misc-id is set. Mnemonic for sheet basis
    Attributes: Index Component

    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

    section-id Data type: INTEGER
    Format: zzzzzzzz9
    Description: Set only if sheet is course/section based. Otherwise ?
    Attributes: Index Component

    sheet-printed Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if sheet has been printed, No if not
    Attributes: Index Component

    stu-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Set only if sheet is 'student' based. Otherwise ?
    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