Definition of table test-record-layout
No table description available , Table Dump Name test-rec

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
  • item-start-pos: (INTG) Position in the record that this item starts (Fixed width on
  • item-width: (INTG) Length of this item in the import (Fixed width only)
  • primary-key: (INTG) Unique, Primary key for record
  • record-item-order: (INTG) Order that this field appears in the 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) 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

  • item-record: std-test-id, std-test-date-id, std-test-item-id, std-test-record-id
  • record-item: (PRIMARY) std-test-id, std-test-date-id, std-test-record-id, std-test-item-id
  • record-order: std-test-id, std-test-date-id, std-test-record-id, record-item-order

    Alphabetical Trigger Summary

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

    Tables test-record-layout references

  • email-info - (no description available)
  • imported-item -
  • 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)

    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

    item-start-pos Data type: INTEGER
    Format: zzz9 (Initial Value: 0)
    Help: Position in the record that this item starts (Fixed width on

    item-width Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Help: Length of this item in the import (Fixed width only)

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

    record-item-order Data type: INTEGER
    Format: zzzz9 (Initial Value: 0)
    Help: Order that this field appears in the record
    Attributes: Index Component

    std-test-date-id Data type: INTEGER
    Format: 999999999999 (Initial Value: 0)
    Description: Internally assigned identifier
    Help: Test date that this record item 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 item 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 record-item is associated with
    Attributes: Index Component

    std-test-record-id Data type: INTEGER
    Format: 999999999999 (Initial Value: 0)
    Description: Internally assigned identifier
    Help: Record that this record item is associated with
    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