Definition of table staff

Table Description

Table Dump Name: staff

Alphabetical Field Summary

• comments: (CHAR) Comments about this staff member
• 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
• staff-active: (LOGC) Is this staff person active?
• staff-email: (CHAR) Email address for staff member
• staff-id: (INTG) Internally assigned Staff ID
• staff-initials: (CHAR)
• staff-name: (CHAR) Name of staff member
• staff-nickname: (CHAR) Nickname for staff member (for browsers/listers)
• 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
• user-name: (CHAR) Name this staff member logs in with

Alphabetical Index Summary

• staff-id: (UNIQUE, PRIMARY) staff-id
• staff-name: staff-name
• user-name: user-name

Alphabetical Trigger Summary

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

Other tables who reference staff

• call-browse - Denormalized Call Log Browsing table
• call-event - One entry per event for a call
• call-log - Log of customer calls
• course-offering - A specific date/time a course is offered
• 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

staff-active Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Is this staff person active?

staff-email Data type: CHARACTER
Format: x(32)
Help: Email address for staff member

staff-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned Staff ID
Attributes: Index Component

staff-initials Data type: CHARACTER
Format: x(3)
Description:
Help: Initials of this staff member

staff-name Data type: CHARACTER
Format: x(32)
Help: Name of staff member
Attributes: Index Component

staff-nickname Data type: CHARACTER
Format: X(8)
Help: Nickname for staff member (for browsers/listers)

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

user-name Data type: CHARACTER
Format: x(16)
Help: Name this staff member logs in with
Attributes: Index Component

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