Definition of table note-code

Table Description

Table Dump Name: note-cod

Alphabetical Field Summary

• cre-date: (DATE) Date of record creation
• cre-time: (CHAR) Time of record creation
• cre-user-name: (CHAR) Login name of user who created the record
• date-label: (CHAR) Description of the date field for the note code
• description: (CHAR) Description of this note code
• flag-label: (CHAR) Label for the flag field
• note-code-id: (INTG) Internally assigned note code ID
• note-code-name: (CHAR) Name of this note code
• note-group-id: (INTG) Internally assigned note group ID
• require-date: (LOGC) Should dates be required when using this note?
• upd-date: (DATE) Date of records last modification
• upd-time: (CHAR) Time of records last modification
• upd-user-name: (CHAR) Login name of user who last modified the record
• use-date: (LOGC) Allow the use of dates with this note
• use-flag: (LOGC) Allow use of a Yes/No flag for the note?

Alphabetical Index Summary

• description: note-group-id, description
• note-code-id: (UNIQUE, PRIMARY) note-group-id, note-code-id
• note-code-name: note-group-id, note-code-name

Alphabetical Trigger Summary

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

Other tables who reference note-code

• site-note - Notes for a site

Tables note-code references

• note-group - Note Groups

Detailed Alphabetical Field Listing

cre-time Data type: CHARACTER
Format: X(8)
Description: Time of record creation

cre-user-name Data type: CHARACTER
Format: x(16)
Description: Login name of user who created the record

date-label Data type: CHARACTER
Format: x(16) (Initial Value: Date)
Help: Description of the date field for the note code

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

flag-label Data type: CHARACTER
Format: x(16)
Help: Label for the flag field

note-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Internally assigned note code ID
Attributes: Index Component

note-code-name Data type: CHARACTER
Format: X(8)
Help: Name of this note code
Attributes: Index Component

note-group-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Internally assigned note group ID
Attributes: Index Component

require-date Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Should dates be required when using this note?

upd-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of records last modification

upd-time Data type: CHARACTER
Format: X(8)
Description: Time of records last modification

upd-user-name Data type: CHARACTER
Format: x(16)
Description: Login name of user who last modified the record

use-date Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Allow the use of dates with this note

use-flag Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Allow use of a Yes/No flag for the note?

Created on 04/03/2003 by DBHTML V1.1c