Definition of table state-version
Date versioning , Table Dump Name st-vers

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
  • effective-date: (DATE) Date this version becomes effective
  • extern-guid: (CHAR) External Global Unique ID for this record
  • report-type: (CHAR) Type of report this version is associated with (SRSD, REP, e
  • reportable-version: (LOGC) 'Yes' if this version will be reported on, no for internal u
  • 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
  • version-name: (CHAR) Enter a name for this version

    Alphabetical Index Summary

  • report-type-date: (UNIQUE, PRIMARY) report-type, effective-date, state-version-id
  • report-type-name: report-type, version-name, state-version-id
  • state-version: (UNIQUE) state-version-id

    Alphabetical Trigger Summary

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

    Other tables who reference state-version

  • extracted-item - Describes an 'extracted' item for export
  • extracted-record - A record extracted from the database, used to group extracte
  • mass-update-status - Keep track of progress of mass updates
  • rep-assign-code - REP Assignment Codes
  • state-item - Describes a reportable element
  • state-record - This table allows us to describe a state-specific reportable
  • state-record-item - Link between a state-item and a state-record
  • state-report-period - Describes the intersection of a report and a period in time
  • state-table-code - State table codes
  • state-table-name - State table names

    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

    effective-date Data type: DATE
    Format: 99/99/9999
    Help: Date this version becomes effective
    Attributes: Index Component

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

    report-type Data type: CHARACTER
    Format: x(8)
    Help: Type of report this version is associated with (SRSD, REP, e
    Attributes: Index Component

    reportable-version Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: 'Yes' if this version will be reported on, no for internal u

    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

    version-name Data type: CHARACTER
    Format: x(16)
    Help: Enter a name for this version
    Attributes: Index Component

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