Definition of table scan-form-line
Scan Form Line info , Table Dump Name scn-line

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-num: (INTG) Data set #
  • extern-guid: (CHAR) External Global Unique ID for this record
  • form-id: (INTG) Internally assigned form ID
  • form-seq: (INTG) Form Sequence #
  • line-num: (INTG) Line number of this scan item [DEFINE KEY]
  • misc-id: (INTG) Misc ID for this line
  • misc-name: (CHAR) Set only when misc-id is set. Descriptive text for ID
  • primary-key: (INTG) Unique, Primary key for record
  • scan-raw-data[64]: (CHAR) Raw Scan data (one 'token' per extent entry)
  • school-year-id: (INTG) School year ID associated with this record
  • stu-seq: (INTG) Set only if line 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-line: (UNIQUE, PRIMARY) school-year-id, bldg-id, form-id, batch-id, form-seq, dataset-num, line-num
  • scan-line-by-stu: school-year-id, bldg-id, stu-seq, form-id, batch-id, form-seq, dataset-num, line-num

    Alphabetical Trigger Summary

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

    Tables scan-form-line 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-dataset - Scan form datasets. Many forms are simple and only have one
  • scan-form-sheet - Scan Form Sheets
  • 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

    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-num Data type: INTEGER
    Format: z9
    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

    line-num Data type: INTEGER
    Format: zzz9
    Description: Line number of this scan item [DEFINE KEY]
    Attributes: Index Component

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

    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

    scan-raw-data Data type: CHARACTER (Extent: 64)
    Format: x(8)
    Help: Raw Scan data (one 'token' per extent entry)

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

    stu-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Set only if line 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