Definition of table state-record-item
Link between a state-item and a state-record , Table Dump Name state-re

Alphabetical Field Summary

  • comments: (CHAR) Comments for/about this entry
  • cre-date: (DATE) Date this record was created
  • cre-time: (CHAR) Time this record was created
  • cre-user-name: (CHAR) Name of user who created this record
  • export-format: (CHAR) Format mask
  • export-start-pos: (INTG) Starting position/column for this field when exported
  • export-width: (INTG) Width of this field when exported, 0 for variable width
  • extern-guid: (CHAR) External Global Unique ID for this record
  • state-item-id: (INTG) Index Component
  • state-record-id: (INTG) Index component
  • state-record-item-id: (INTG) Internally assigned ID
  • state-record-item-order: (INTG) Order this item should be exported in for the associated rec
  • state-version-id: (INTG) Internally Assigned ID
  • upd-date: (DATE) Date this record was last updated on
  • upd-time: (CHAR) Date this record was last updated
  • upd-user-name: (CHAR) Name of user who last updated this record

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • state-record-item: (UNIQUE, PRIMARY) state-version-id, state-record-id, state-item-id, state-record-item-id
  • state-record-item-order: state-version-id, state-record-id, state-record-item-order, state-record-item-id

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-srm.p
  • DELETE: Overridable, Procedure is tr-d-srm.p
  • WRITE: Overridable, Procedure is tr-u-srm.p

    Other tables who reference state-record-item

  • extracted-item - Describes an 'extracted' item for export

    Tables state-record-item references

  • state-item - Describes a reportable element
  • state-record - This table allows us to describe a state-specific reportable
  • state-version - Date versioning

    Detailed Alphabetical Field Listing
    comments Data type: CHARACTER
    Format: x(60)
    Help: Comments for/about this entry

    cre-date Data type: DATE
    Format: 99/99/99
    Help: Date this record was created

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

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

    export-format Data type: CHARACTER
    Format: x(16)
    Description: Format mask
    Help: Format for this item, when it is displayed on a report

    export-start-pos Data type: INTEGER
    Format: zz9 (Initial Value: 1)
    Help: Starting position/column for this field when exported

    export-width Data type: INTEGER
    Format: zz9 (Initial Value: 1)
    Help: Width of this field when exported, 0 for variable width

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

    state-item-id Data type: INTEGER
    Format: zzzzzzzzz9
    Description: Index Component
    Help: Internally assigned item id
    Attributes: Index Component

    state-record-id Data type: INTEGER
    Format: zzzzzzzzz9
    Description: Index component
    Help: Internally assigned state record ID
    Attributes: Index Component

    state-record-item-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Internally assigned ID
    Attributes: Index Component

    state-record-item-order Data type: INTEGER
    Format: zzz9 (Initial Value: 1)
    Help: Order this item should be exported in for the associated rec
    Attributes: Index Component

    state-version-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Internally Assigned ID
    Attributes: Index Component

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

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

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Help: Name of user who last updated this record

    Created on 11/14/2011 by DBHTML V1.2