Definition of table emp-event
No table description available , Table Dump Name emp-even

Alphabetical Field Summary

  • comments: (CHAR) Comments for this event
  • 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
  • emp-seq: (INTG) Employee's Unique Sequence #
  • event-code-id: (INTG) Event Group Code ID of this event
  • event-date: (DATE) Date of this event
  • event-expire-date: (DATE) Expiration date, if any, for this event
  • event-group-id: (INTG) Event Group Code ID of this event
  • event-info-complete: (LOGC) Yes if all information related to this event is complete
  • event-seq: (INTG) Event Sequence
  • event-time: (CHAR) Time of this event, if any
  • event-who-emp-seq: (INTG) Employee related to this event (reviewer, referal, etc)
  • extern-guid: (CHAR) External Global Unique ID for this record
  • primary-key: (INTG) Unique, Primary key for record
  • site-comments[10]: (CHAR) Comments for this entry, if any
  • site-date[10]: (DATE) Date for this entry
  • site-flag[10]: (LOGC) Flag value for this entry
  • site-table-code-id[10]: (INTG) Table Code for this entry
  • site-table-name-id[10]: (INTG) Table Name ot use for this table code based entry
  • site-time[10]: (CHAR) Entry time, if any
  • 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

    Alphabetical Index Summary

  • emp-event: (PRIMARY) emp-seq, event-group-id, event-code-id
  • event-by-date: emp-seq, event-date, event-group-id, event-code-id
  • events-by-group: event-group-id, event-code-id, emp-seq
  • extern-guid: extern-guid

    Alphabetical Trigger Summary

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

    Tables emp-event references

  • emp-dc - (no description available)
  • emp-demo - Employee Demographic Entry
  • emp-mpsers - (no description available)
  • emp-tdp - Employee DTL3 record
  • event-code - (no description available)
  • event-group - (no description available)
  • replicate-queue - (no description available)

    Detailed Alphabetical Field Listing
    comments Data type: CHARACTER
    Format: x(64)
    Help: Comments for this event

    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

    emp-seq Data type: INTEGER
    Format: zzzzzzzz9
    Description: Employee's Unique Sequence #
    Attributes: Index Component

    event-code-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Event Group Code ID of this event
    Attributes: Index Component

    event-date Data type: DATE
    Format: 99/99/9999
    Help: Date of this event
    Attributes: Index Component

    event-expire-date Data type: DATE
    Format: 99/99/9999
    Help: Expiration date, if any, for this event

    event-group-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Event Group Code ID of this event
    Attributes: Index Component

    event-info-complete Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if all information related to this event is complete

    event-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Event Sequence

    event-time Data type: CHARACTER
    Format: x(8)
    Help: Time of this event, if any

    event-who-emp-seq Data type: INTEGER
    Format: zzzzzzzzzzzz9
    Help: Employee related to this event (reviewer, referal, etc)

    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

    site-comments Data type: CHARACTER (Extent: 10)
    Format: x(32)
    Help: Comments for this entry, if any

    site-date Data type: DATE (Extent: 10)
    Format: 99/99/9999
    Help: Date for this entry

    site-flag Data type: LOGICAL (Extent: 10)
    Format: Yes/No (Initial Value: No)
    Help: Flag value for this entry

    site-table-code-id Data type: INTEGER (Extent: 10)
    Format: zzzzzzzzzzz9
    Help: Table Code 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-time Data type: CHARACTER (Extent: 10)
    Format: x(8)
    Help: Entry time, if any

    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

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