Definition of table emp-note

Employee Notes file , Table Dump Name emp-note

Alphabetical Field Summary

cre-date: (DATE) Date this record was created

cre-user-name: (CHAR) Name of user who created this record

emp-seq: (INTG) Employee's Unique Sequence #

extern-guid: (CHAR) External Global Unique ID for this record

note-code: (CHAR) Name of a note code to classify this note by

note-date: (DATE) Date attached to note

note-num: (INTG) The priority of this note

note-text[5]: (CHAR) Note about/for employee

primary-key: (INTG) Unique, Primary key for record

table-code-id: (INTG) Internally assigned Table Code ID

table-name-id: (INTG) Table Name to use with this note

table2-code-id: (INTG) Code for this table value

table2-name-id: (INTG) Second site table to associate with this note code

upd-date: (DATE) Date this record was last updated

upd-user-name: (CHAR) Name of user who last updated this record

Alphabetical Index Summary

date-note: emp-seq, note-date, note-code

emp-note: (PRIMARY) emp-seq, note-num, note-code, note-date

extern-guid: extern-guid

note-code: note-code

note-date: emp-seq, note-code, note-date

table-name: emp-seq, table-name-id, note-date

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-ent.p

DELETE: Overridable, Procedure is tr-d-ent.p

REPLICATION-CREATE: Procedure is rp-c-ent.p

REPLICATION-DELETE: Procedure is rp-d-ent.p

REPLICATION-WRITE: Procedure is rp-u-ent.p

WRITE: Overridable, Procedure is tr-u-ent.p

Tables emp-note references

emp-dc - (no description available)

emp-demo - Employee Demographic Entry

emp-mpsers - (no description available)

emp-tdp - Employee DTL3 record

note-code - Definition of each of the possible note codes

site-table-code - Site Table Codes

site-table-name - Site Table Names

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

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

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

note-code Data type: CHARACTER
Format: x(8)
Help: Name of a note code to classify this note by
Attributes: Index Component

note-date Data type: DATE
Format: 99/99/9999
Help: Date attached to note
Attributes: Index Component

note-num Data type: INTEGER
Format: zz9 (Initial Value: 1)
Help: The priority of this note
Attributes: Index Component

note-text Data type: CHARACTER (Extent: 5)
Format: x(68)
Help: Note about/for employee

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

table-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned Table Code ID
Help: Table code associated with this employee note

table-name-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Table Name to use with this note
Attributes: Index Component

table2-code-id Data type: INTEGER
Format: 999999999999
Help: Code for this table value

table2-name-id Data type: INTEGER
Format: 999999999999
Help: Second site table to associate with this note code

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

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