Definition of table form-bldg
Form definitions, on a per building level , Table Dump Name form-bld

Alphabetical Field Summary

  • bldg-id: (INTG) Building ID for this form
  • cre-date: (DATE) Date record was created
  • cre-time: (CHAR) Time record was created
  • cre-user-name: (CHAR) Name of user who created the record
  • data-lines: (INTG) # of data lines per sheet
  • dataset-cnt: (INTG) Usually 1, possibly more for daily attendance sheets (Grand
  • dataset-offset: (INTG) Offset for each dataset on multi-dataset forms
  • description: (CHAR) Description of this form
  • enable-align-mode: (LOGC) Yes to enable support for alignment mode, No if not needed
  • extern-guid: (CHAR) External Global Unique ID for this record
  • form-cpi: (DECM) Characters per inch (0 for default, <0 for >= ABS(CPI))
  • form-graph-model: (CHAR) Printer Graphics Model requried by this form (if any)
  • form-height: (DECM) Height of form (0 to use default)
  • form-id: (INTG) Internally assigned form ID
  • form-init-file: (CHAR) Printer initialization file for this form (if any)
  • form-is-portrait: (LOGC) Select whether the form is laid out as landscape or portrait
  • form-lpi: (DECM) Lines per inch (0 for default, <0 for >= ABS(LPI))
  • form-mod: (CHAR) Moduel to use for form printing
  • form-opt: (INTG) Form option # (if any)
  • form-parm: (CHAR) Form parameter (if any)
  • form-width: (DECM) Form width (0 to use default)
  • last-form-seq: (INTG) Last form Sequence #
  • primary-key: (INTG) Unique, Primary key for record
  • require-binary: (LOGC) Yes is form requires a binary printer to print (laser forms.
  • scanner-form-num: (INTG) Optional scanner form # for this form
  • scanner-form-path: (CHAR) Optional scanner form definition file path
  • scanner-init-mod: (CHAR) Optional reader initialization module
  • scanner-model-id: (INTG) Model of scanner to use or ? if no scanner
  • scanner-read-mod: (CHAR) Name of the sheet reader module
  • scanner-reset-mod: (CHAR) Optional reset reader module
  • slug-column-cnt: (INTG) # of slug columns for scan sheet header
  • slug-column-spacing: (INTG) Spacing between slugs (1=no spacing, 2=every other, etc)
  • slug-row-cnt: (INTG) # of slug rows for scan sheet headers
  • slug-row-spacing: (INTG) Row spacing (1=every row, 2=skip row between slugs, etc)
  • upd-date: (DATE) Date record was last updated
  • upd-time: (CHAR) Record last updated at
  • upd-user-name: (CHAR) Name of user record was updated by

    Alphabetical Index Summary

  • bldg-form: (PRIMARY) bldg-id, form-id
  • extern-guid: extern-guid
  • form-bldg: form-id, bldg-id

    Alphabetical Trigger Summary

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

    Tables form-bldg references

  • building - One record for each building, for each scheduling version, f
  • email-info - (no description available)
  • form-def - Forms Definitions
  • grading-setup - Grading setup controls building level setup/policy issues wi
  • scanner-device - Scanner device file
  • scanner-model - Scanner model definitions file
  • spm-prof - SPM Profile/Base record. Only 1 per system!
  • user-bldg - User Restricted to building list

    Detailed Alphabetical Field Listing
    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)
    Description: Date record was created

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

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user who created the record

    data-lines Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Help: # of data lines per 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

    dataset-offset Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Help: Offset for each dataset on multi-dataset forms

    description Data type: CHARACTER
    Format: x(28)
    Help: Description of this form

    enable-align-mode Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to enable support for alignment mode, No if not needed

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

    form-cpi Data type: DECIMAL (Decimals: 2)
    Format: -zz9.99 (Initial Value: 0)
    Help: Characters per inch (0 for default, <0 for >= ABS(CPI))

    form-graph-model Data type: CHARACTER
    Format: x(12)
    Help: Printer Graphics Model requried by this form (if any)

    form-height Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 0)
    Help: Height of form (0 to use default)

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

    form-init-file Data type: CHARACTER
    Format: x(32)
    Help: Printer initialization file for this form (if any)

    form-is-portrait Data type: LOGICAL
    Format: Portrait/Landscape (Initial Value: Yes)
    Help: Select whether the form is laid out as landscape or portrait

    form-lpi Data type: DECIMAL (Decimals: 2)
    Format: -zz9.99 (Initial Value: 0)
    Help: Lines per inch (0 for default, <0 for >= ABS(LPI))

    form-mod Data type: CHARACTER
    Format: x(12)
    Help: Moduel to use for form printing

    form-opt Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Help: Form option # (if any)

    form-parm Data type: CHARACTER
    Format: x(32)
    Help: Form parameter (if any)

    form-width Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 0)
    Help: Form width (0 to use default)

    last-form-seq Data type: INTEGER
    Format: zzzzzzzzzz9 (Initial Value: 0)
    Description: Last form Sequence #

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

    require-binary Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes is form requires a binary printer to print (laser forms.

    scanner-form-num Data type: INTEGER
    Format: zzzz9 (Initial Value: 0)
    Help: Optional scanner form # for this form

    scanner-form-path Data type: CHARACTER
    Format: x(32)
    Help: Optional scanner form definition file path

    scanner-init-mod Data type: CHARACTER
    Format: x(12)
    Help: Optional reader initialization module

    scanner-model-id Data type: INTEGER
    Format: zzzzzzzzz9
    Help: Model of scanner to use or ? if no scanner

    scanner-read-mod Data type: CHARACTER
    Format: x(12)
    Help: Name of the sheet reader module

    scanner-reset-mod Data type: CHARACTER
    Format: x(12)
    Help: Optional reset reader module

    slug-column-cnt Data type: INTEGER
    Format: z9 (Initial Value: 0)
    Help: # of slug columns for scan sheet header

    slug-column-spacing Data type: INTEGER
    Format: z9 (Initial Value: 1)
    Help: Spacing between slugs (1=no spacing, 2=every other, etc)

    slug-row-cnt Data type: INTEGER
    Format: z9 (Initial Value: 0)
    Help: # of slug rows for scan sheet headers

    slug-row-spacing Data type: INTEGER
    Format: z9 (Initial Value: 1)
    Help: Row spacing (1=every row, 2=skip row between slugs, etc)

    upd-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Description: Record last updated at

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user record was updated by

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