Definition of table state-record
This table allows us to describe a state-specific reportable record type , Table Dump Name stat-rcd

Alphabetical Field Summary

  • 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
  • description: (CHAR) Description of this state record
  • extern-guid: (CHAR) External Global Unique ID for this record
  • is-conditionally-buildable: (LOGC) Is this an optional record
  • max-record-per-entity: (INTG) Maximum number of records any one entity can have
  • primary-record: (LOGC) Is this record tied to the primary source (student, employee
  • record-purgable: (LOGC) Can instances of this record be purged after build
  • record-source: (CHAR) SPM, HRS, FAS for primary record
  • state-record-code: (CHAR) Code for this record
  • state-record-id: (INTG) Index component
  • state-record-length: (INTG) Length of record when exported/reported, if appropriate
  • state-version-id: (INTG) Internally Assigned ID
  • tag-end: (CHAR) Export tag for the end of this record
  • tag-start: (CHAR) Export tag to mark the start of this record
  • 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
  • user-addable: (LOGC) 'Yes' if user can add records after build
  • user-deletable: (LOGC) 'Yes' if user is allowed to delete records after build
  • user-editable: (LOGC) 'Yes' if user is allowed to change records after build

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • primary-source: state-version-id, primary-record, record-source
  • record-source: state-version-id, record-source, state-record-id
  • state-record: (UNIQUE, PRIMARY) state-version-id, state-record-id
  • state-record-code: state-version-id, state-record-code, state-record-id

    Alphabetical Trigger Summary

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

    Other tables who reference state-record

  • extracted-item - Describes an 'extracted' item for export
  • extracted-record - A record extracted from the database, used to group extracte
  • state-record-item - Link between a state-item and a state-record
  • state-report-record - State Report Records

    Tables state-record references

  • state-version - Date versioning

    Detailed Alphabetical Field Listing
    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

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

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

    is-conditionally-buildable Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: Is this an optional record
    Help: 'No' to always build, 'Yes' to allow user to build or not bu

    max-record-per-entity Data type: INTEGER
    Format: z,zzz,zz9 (Initial Value: 1)
    Help: Maximum number of records any one entity can have

    primary-record Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Is this record tied to the primary source (student, employee
    Attributes: Index Component

    record-purgable Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Can instances of this record be purged after build

    record-source Data type: CHARACTER
    Format: x(3)
    Help: SPM, HRS, FAS for primary record
    Attributes: Index Component

    state-record-code Data type: CHARACTER
    Format: x(16)
    Help: Code for this record
    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-length Data type: INTEGER
    Format: z,zzz,zzz,zz9 (Initial Value: 0)
    Help: Length of record when exported/reported, if appropriate

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

    tag-end Data type: CHARACTER
    Format: x(32)
    Help: Export tag for the end of this record

    tag-start Data type: CHARACTER
    Format: x(32)
    Help: Export tag to mark the start of this record

    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

    user-addable Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if user can add records after build

    user-deletable Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if user is allowed to delete records after build

    user-editable Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if user is allowed to change records after build

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