Definition of table dev-request

Table Description

A request of development for resources to fix a bug and/or enhance a product

Table Dump Name: dev-rqst

Alphabetical Field Summary

actual-end-date: (DATE) Actual end/last date of work on this request
actual-hours: (INTG) Actual # of hours this request took to complete
actual-start-date: (DATE) Actual starting date of work on request
assigned-to-staff-id: (INTG) Staff member assigned to complete this request, if any
base-affected: (INTG) Percentage of customer base affected
component-id: (INTG) Optional Component ID for this request
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
difficult: (INTG) Difficult to execute this request, 1-10
estimated-hours: (INTG) Estimated # of hours this request will take to complete
estimated-start-date: (DATE) Estimated start date of work on this request
expected-version-id: (INTG) Expected Release version for this request, if any
importance: (INTG) Importance of this request (1-10)
managed-by-staff-id: (INTG) Staff member assigned to manage this request, if any
needed-by: (DATE) Date request is needed by (if any)
product-id: (INTG) Product ID for this request
request-id: (INTG) Request ID/Order #
request-status: (CHAR) NEW,ACCEPTED,DECLINED,MOREINFO,ASSIGNED,INPROCESS,DONE
request-type: (CHAR) Request type, either ENHANCEMENT or BUG
schema-change: (LOGC) Yes if a schema change would be required to complete request
summary: (CHAR) A brief but helpful summary of this request.
task-num: (INTG) Roundtable Task #, if any, to use for this requests work
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
version-id: (INTG) Version ID of the product for this request
work-order: (INTG) Order to work on this request, in relation to other requests

Alphabetical Index Summary

request-by-assigned: assigned-to-staff-id, request-id
request-by-expected-version: product-id, expected-version-id, request-id
request-by-manager: managed-by-staff-id, request-id
request-by-product: product-id, component-id, request-id
request-by-status: request-status, request-id
request-by-version: product-id, version-id, request-id
request-id: (UNIQUE, PRIMARY) request-id

Alphabetical Trigger Summary

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

Other tables who reference dev-request

call-browse - Denormalized Call Log Browsing table
dev-request-call - List of call logs associated with this request
dev-request-note - Notes/Text bodies associated with the request
dev-request-vote - Tracking for development request votes

Tables dev-request references

component - Product Components
product - (no description available)
product-version - Version of the product
site-product - Products Installed at a site

Detailed Alphabetical Field Listing

actual-end-date Data type: DATE
Format: 99/99/9999
Help: Actual end/last date of work on this request

actual-hours Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Actual # of hours this request took to complete

actual-start-date Data type: DATE
Format: 99/99/9999
Help: Actual starting date of work on request

assigned-to-staff-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Staff member assigned to complete this request, if any
Attributes: Index Component

base-affected Data type: INTEGER
Format: zz9% (Initial Value: 0)
Help: Percentage of customer base affected

component-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Optional Component ID for this request
Attributes: Index Component

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

difficult Data type: INTEGER
Format: z9 (Initial Value: 1)
Help: Difficult to execute this request, 1-10

estimated-hours Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Estimated # of hours this request will take to complete

estimated-start-date Data type: DATE
Format: 99/99/9999
Help: Estimated start date of work on this request

expected-version-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Expected Release version for this request, if any
Attributes: Index Component

importance Data type: INTEGER
Format: z9 (Initial Value: 1)
Help: Importance of this request (1-10)

managed-by-staff-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Staff member assigned to manage this request, if any
Attributes: Index Component

needed-by Data type: DATE
Format: 99/99/9999
Help: Date request is needed by (if any)

product-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Product ID for this request
Attributes: Index Component

request-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Request ID/Order #
Attributes: Index Component

request-status Data type: CHARACTER
Format: x(10) (Initial Value: NEW)
Description: NEW,ACCEPTED,DECLINED,MOREINFO,ASSIGNED,INPROCESS,DONE
Help: Status of this request
Attributes: Index Component

request-type Data type: CHARACTER
Format: x(11) (Initial Value: Enhancement)
Help: Request type, either ENHANCEMENT or BUG

schema-change Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if a schema change would be required to complete request

summary Data type: CHARACTER
Format: x(80)
Help: A brief but helpful summary of this request.

task-num Data type: INTEGER
Format: zzzzz9
Help: Roundtable Task #, if any, to use for this requests work

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

version-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Version ID of the product for this request
Attributes: Index Component

work-order Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Order to work on this request, in relation to other requests