Alphabetical Field Summary
Alphabetical Index Summary
Alphabetical Trigger Summary
Other tables who reference event-code
Tables event-code references
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