Definition of table dev-request-note

Table Description

Notes/Text bodies associated with the request

Table Dump Name: dev-rnot

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
note-done: (LOGC) For Todo Notes, is this done?
note-order: (INTG) Order of the notes within a note type
note-text: (CHAR) Message to record for this note
note-type: (CHAR) Type of note (NOTE, REQUEST, WORK, RELEASE, TODO)
request-id: (INTG) Request this note is associated with
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

Alphabetical Index Summary

request-note: (PRIMARY) request-id, note-type, note-order

Alphabetical Trigger Summary

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

Tables dev-request-note references

dev-request - A request of development for resources to fix a bug and/or e

Detailed Alphabetical Field Listing

cre-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of record creation

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

note-done Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: For Todo Notes, is this done?

note-order Data type: INTEGER
Format: zzz9 (Initial Value: 1)
Help: Order of the notes within a note type
Attributes: Index Component

note-text Data type: CHARACTER
Format: x(60)
Help: Message to record for this note

note-type Data type: CHARACTER
Format: x(10) (Initial Value: NOTE)
Help: Type of note (NOTE, REQUEST, WORK, RELEASE, TODO)
Attributes: Index Component

request-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Request this note is associated with
Attributes: Index Component

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