Definition of table imported-item
, Table Dump Name imp-item

Alphabetical Field Summary

  • cre-date: (DATE) Date of record creation
  • cre-time: (CHAR) Time of record creation
  • cre-user-name: (CHAR) Name of user who created this record
  • imp-record-seq: (INTG) Extracted record that this item is associated with.
  • item-char: (CHAR) Data field for character items
  • item-decimal: (DECM) Data field for decimal items
  • primary-key: (INTG) Unique, Primary key for record
  • std-test-date-id: (INTG) Internally assigned identifier
  • std-test-id: (INTG) Internally assigned identifier
  • std-test-item-id: (INTG) Internally assigned identifier
  • std-test-record-id: (INTG) Std Test Record that this extracted record belongs to
  • stu-seq: (INTG) Internally assigned identifier
  • upd-date: (DATE) Date this record was last updated
  • upd-time: (CHAR) Time this record was last updated
  • upd-user-name: (CHAR) User who last updated this record

    Alphabetical Index Summary

  • imp-item: (UNIQUE, PRIMARY) std-test-id, std-test-date-id, std-test-record-id, imp-record-seq, std-test-item-id
  • stu-test: stu-seq, std-test-item-id

    Alphabetical Trigger Summary

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

    Other tables who reference imported-item

  • std-test-item - (no description available)
  • test-record-layout - (no description available)

    Tables imported-item references

  • email-info - (no description available)
  • imported-record - (no description available)
  • spm-prof - SPM Profile/Base record. Only 1 per system!
  • std-test - Define a standardized test
  • std-test-date - One record for each instance of a standardized test
  • std-test-item - (no description available)
  • std-test-record - (no description available)
  • 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
  • test-record-layout - (no description available)

    Detailed Alphabetical Field Listing
    cre-date Data type: DATE
    Format: 99/99/9999
    Description: Date of record creation

    cre-time Data type: CHARACTER
    Format: x(8)
    Description: Time of record creation

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

    imp-record-seq Data type: INTEGER
    Format: 999999999999 (Initial Value: 0)
    Description: Extracted record that this item is associated with.
    Attributes: Index Component

    item-char Data type: CHARACTER
    Format: x(8)
    Description: Data field for character items

    item-decimal Data type: DECIMAL (Decimals: 2)
    Format: zzz9.99
    Description: Data field for decimal items

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

    std-test-date-id Data type: INTEGER
    Format: 999999999999 (Initial Value: 0)
    Description: Internally assigned identifier
    Help: Test date that this record is associated with
    Attributes: Index Component

    std-test-id Data type: INTEGER
    Format: 999999999999 (Initial Value: 0)
    Description: Internally assigned identifier
    Help: Test that this record is associated with
    Attributes: Index Component

    std-test-item-id Data type: INTEGER
    Format: 999999999999 (Initial Value: 0)
    Description: Internally assigned identifier
    Help: Item that this data is associated with
    Attributes: Index Component

    std-test-record-id Data type: INTEGER
    Format: 999999999999 (Initial Value: 0)
    Description: Std Test Record that this extracted record belongs to
    Attributes: Index Component

    stu-seq Data type: INTEGER
    Format: 999999999999 (Initial Value: 0)
    Description: Internally assigned identifier
    Attributes: Index Component

    upd-date Data type: DATE
    Format: 99/99/9999
    Description: Date this record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Description: Time this record was last updated

    upd-user-name Data type: CHARACTER
    Format: x(8)
    Description: User who last updated this record

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