Definition of table event-code
No table description available , Table Dump Name event-co

Alphabetical Field Summary

  • allow-multiple-events: (LOGC) Yes to allow multiple instances of this code, No for only on
  • cre-date: (DATE) Date this record was created
  • cre-time: (CHAR) Creation time of this record
  • cre-user-name: (CHAR) Name of user who created this record
  • description: (CHAR) Description of this event code
  • does-event-expire: (LOGC) Yes if this events data can eventually be considered expired
  • event-active: (LOGC) Is this event code currently in use?
  • event-code: (CHAR) Name of this event code
  • event-code-id: (INTG) Event Group Code ID [DEFINE]
  • event-expires-after: (INTG) Typical # of days from an events date till it's expires
  • event-group-id: (INTG) Event Group this code is associated with
  • extern-guid: (CHAR) External Global Unique ID for this record
  • primary-key: (INTG) Unique, Primary key for record
  • require-event-time: (LOGC) Require a time for this event
  • require-event-who: (LOGC) Yes to require the "Who" name in an event of this code
  • require-expire-date: (LOGC) Is expiration date required?
  • site-date-label[10]: (CHAR) Label for the date, if any
  • site-flag-format[10]: (CHAR) Format to be used for this flag
  • site-flag-label[10]: (CHAR) Label for flag, if any
  • site-inuse-count: (INTG) Number of site defined entries in use
  • site-require-date[10]: (LOGC) Yes to require a date be entered
  • site-require-table-code[10]: (LOGC) Yes to require table code to be filled in
  • site-require-time[10]: (LOGC) Yes to require the time be filled in
  • site-table-label[10]: (CHAR) Label for the table code prompt for this entry
  • site-table-name-id[10]: (INTG) Table Name ot use for this table code based entry
  • site-use-date[10]: (LOGC) Yes to use dates for this entry, No to disabled them
  • site-use-flag[10]: (LOGC) Use/allow a flag to be set for this entry?
  • site-use-table[10]: (LOGC) Yes to allow tables codes to be entered for this entry
  • site-use-time[10]: (LOGC) Yes to record times with this entry
  • upd-date: (DATE) Date this record was last updated
  • upd-time: (CHAR) Time of last update to this record
  • upd-user-name: (CHAR) Name of user who last updated this record
  • use-event-time: (LOGC) Yes to allow time to be recorded with the event
  • use-event-who: (LOGC) Yes if a person related to the event can be recorded
  • use-info-complete-flag: (LOGC) Yes to allow the info complete flag to be used

    Alphabetical Index Summary

  • description: event-group-id, description
  • event-code: event-group-id, event-code
  • event-code-id: (UNIQUE, PRIMARY) event-group-id, event-code-id
  • extern-guid: extern-guid

    Alphabetical Trigger Summary

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

    Other tables who reference event-code

  • emp-event - (no description available)

    Tables event-code references

  • emp-event - (no description available)
  • event-group - (no description available)


    Detailed Alphabetical Field Listing
    allow-multiple-events Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to allow multiple instances of this code, No for only on

    cre-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date this record was created

    cre-time Data type: CHARACTER
    Format: x(8)
    Help: Creation time of this record

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

    description Data type: CHARACTER
    Format: x(28)
    Help: Description of this event code
    Attributes: Index Component

    does-event-expire Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if this events data can eventually be considered expired

    event-active Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Is this event code currently in use?

    event-code Data type: CHARACTER
    Format: x(8)
    Help: Name of this event code
    Attributes: Index Component

    event-code-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Event Group Code ID [DEFINE]
    Attributes: Index Component

    event-expires-after Data type: INTEGER
    Format: zzz9 (Initial Value: 90)
    Help: Typical # of days from an events date till it's expires

    event-group-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Event Group this code is associated with
    Attributes: Index Component

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

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

    require-event-time Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Require a time for this event

    require-event-who Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to require the "Who" name in an event of this code

    require-expire-date Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Is expiration date required?

    site-date-label Data type: CHARACTER (Extent: 10)
    Format: x(16)
    Help: Label for the date, if any

    site-flag-format Data type: CHARACTER (Extent: 10)
    Format: x(16) (Initial Value: Yes/No)
    Help: Format to be used for this flag

    site-flag-label Data type: CHARACTER (Extent: 10)
    Format: x(16)
    Help: Label for flag, if any

    site-inuse-count Data type: INTEGER
    Format: z9 (Initial Value: 0)
    Help: Number of site defined entries in use

    site-require-date Data type: LOGICAL (Extent: 10)
    Format: Yes/No (Initial Value: No)
    Help: Yes to require a date be entered

    site-require-table-code Data type: LOGICAL (Extent: 10)
    Format: Yes/No (Initial Value: No)
    Help: Yes to require table code to be filled in

    site-require-time Data type: LOGICAL (Extent: 10)
    Format: Yes/No (Initial Value: No)
    Help: Yes to require the time be filled in

    site-table-label Data type: CHARACTER (Extent: 10)
    Format: x(16)
    Help: Label for the table code prompt for this entry

    site-table-name-id Data type: INTEGER (Extent: 10)
    Format: zzzzzzzzzzz9
    Help: Table Name ot use for this table code based entry

    site-use-date Data type: LOGICAL (Extent: 10)
    Format: Yes/No (Initial Value: No)
    Help: Yes to use dates for this entry, No to disabled them

    site-use-flag Data type: LOGICAL (Extent: 10)
    Format: Yes/No (Initial Value: No)
    Help: Use/allow a flag to be set for this entry?

    site-use-table Data type: LOGICAL (Extent: 10)
    Format: Yes/No (Initial Value: No)
    Help: Yes to allow tables codes to be entered for this entry

    site-use-time Data type: LOGICAL (Extent: 10)
    Format: Yes/No (Initial Value: No)
    Help: Yes to record times with this entry

    upd-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date this record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Help: Time of last update to this record

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

    use-event-time Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to allow time to be recorded with the event

    use-event-who Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes if a person related to the event can be recorded

    use-info-complete-flag Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Yes to allow the info complete flag to be used

    Created on 12/28/2020 by DBHTML V1.2