Definition of table user-prof
User profile record. Contains miscellaneous information keyed by user ID. , Table Dump Name user-pro

Alphabetical Field Summary

  • cre-date: (DATE) Date record was created
  • cre-time: (CHAR) Time record was created at
  • cre-user-name: (CHAR) User who created this record
  • extern-guid: (CHAR) External Global Unique ID for this record
  • group-name: (CHAR) Group name to associate with user
  • upd-date: (DATE) Date record was last updated
  • upd-time: (CHAR) Time record was last updated
  • upd-user-name: (CHAR) User who last updated this record
  • user-active: (LOGC) Select active or inactive user (inactive = no access)
  • user-advanced: (LOGC) Users relative skill level (Novice/Advanced)
  • user-disppath: (LOGC) Enables menu depth/program display
  • user-email-addr: (CHAR) Users email address - NORMALLY BLANK
  • user-expirdate: (DATE) Expiration date for user (or ? for none)
  • user-ext: (CHAR) User's extension (if any)
  • user-fullname: (CHAR) Users full name
  • user-gui-menu: (CHAR) Menu to use for GUI (if blank, use ChUI menu)
  • user-home-base-path: (CHAR) Special path to users home directory - NORMALLY BLANK!
  • user-home-base-www-path: (CHAR) Path to users private WWW directory - NORMALL BLANK!
  • user-home-www-base-url: (CHAR) Base URL for users private WWW files - NORMALLY BLANK
  • user-initdate: (DATE) Date of user record's creation
  • user-logincnt: (INTG) Number of times user has logged in
  • user-logindate: (DATE) Last Date user logged in
  • user-logintime: (CHAR) Last time user logged in
  • user-menu: (CHAR) Menu to display for user
  • user-moddate: (DATE) Date of last Profile Modification
  • user-name: (CHAR) Login name of user
  • user-passwd: (CHAR) User Password (for DOS and OS/2 only)
  • user-phone: (CHAR) User's phone # (If any)
  • user-term: (CHAR) Terminal Type, leave blank to user system default

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • full-name: user-fullname
  • user-group: group-name
  • user-menu: user-menu
  • user-name: (UNIQUE, PRIMARY) user-name

    Other tables who reference user-prof

  • audit - The audit trail keeps a history of user activities and any o
  • company - Micro Sage Company Profile information
  • dbinfo - Database names, paths and ancillary information. Used by the
  • device - System printer devices
  • error-text - Error message texts go in this file
  • group-desc - Group Descriptions
  • group-perm - Group Permissions files. Possible entries in here for each o
  • menu - A file consisting of a list of menus. This includes any sub-
  • menu-item - Contains pointers for contructing menu items. If the menuite
  • object - Object definitions for the system. This includes programs or
  • printer - Printer definitions for attributes, extensions, and abilitie
  • printer-line - Printer Line Graphics support/definition file
  • program - one entry for each program that can be run in association wi
  • site-prof - This is the site profile record. There is only one and it co
  • user-color - Color definitions. If you can't find one for a users termina
  • user-default - User defaults file. This contains object/attribute pairs wit
  • _User - (no description available)

    Tables user-prof references

  • audit - The audit trail keeps a history of user activities and any o
  • group-desc - Group Descriptions
  • user-color - Color definitions. If you can't find one for a users termina

    Detailed Alphabetical Field Listing
    cre-date Data type: DATE
    Format: 99/99/9999
    Help: Date record was created

    cre-time Data type: CHARACTER
    Format: x(8)
    Help: Time record was created at

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Help: User who created this record

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

    group-name Data type: CHARACTER
    Format: x(12) (Initial Value: DEFAULT)
    Help: Group name to associate with user
    Attributes: Index Component

    upd-date Data type: DATE
    Format: 99/99/9999
    Help: Date record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Help: Time record was last updated

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Help: User who last updated this record

    user-active Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Select active or inactive user (inactive = no access)

    user-advanced Data type: LOGICAL
    Format: Advanced/Novice (Initial Value: Novice)
    Help: Users relative skill level (Novice/Advanced)

    user-disppath Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Enables menu depth/program display

    user-email-addr Data type: CHARACTER
    Format: x(40)
    Help: Users email address - NORMALLY BLANK

    user-expirdate Data type: DATE
    Format: 99/99/9999
    Help: Expiration date for user (or ? for none)

    user-ext Data type: CHARACTER
    Format: ~xxxxx
    Help: User's extension (if any)

    user-fullname Data type: CHARACTER
    Format: x(32)
    Help: Users full name
    Attributes: Index Component

    user-gui-menu Data type: CHARACTER
    Format: x(16)
    Help: Menu to use for GUI (if blank, use ChUI menu)

    user-home-base-path Data type: CHARACTER
    Format: x(40)
    Help: Special path to users home directory - NORMALLY BLANK!

    user-home-base-www-path Data type: CHARACTER
    Format: x(40)
    Help: Path to users private WWW directory - NORMALL BLANK!

    user-home-www-base-url Data type: CHARACTER
    Format: x(40)
    Help: Base URL for users private WWW files - NORMALLY BLANK

    user-initdate Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Help: Date of user record's creation

    user-logincnt Data type: INTEGER
    Format: zz,zzz,zz9 (Initial Value: 0)
    Help: Number of times user has logged in

    user-logindate Data type: DATE
    Format: 99/99/9999
    Help: Last Date user logged in

    user-logintime Data type: CHARACTER
    Format: x(8)
    Help: Last time user logged in

    user-menu Data type: CHARACTER
    Format: x(16) (Initial Value: DEFAULT)
    Help: Menu to display for user
    Attributes: Index Component, Mandatory

    user-moddate Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Help: Date of last Profile Modification

    user-name Data type: CHARACTER
    Format: x(16)
    Help: Login name of user
    Attributes: Index Component, Mandatory

    user-passwd Data type: CHARACTER
    Format: x(16)
    Help: User Password (for DOS and OS/2 only)

    user-phone Data type: CHARACTER
    Format: (xxx) 999-9999
    Help: User's phone # (If any)

    user-term Data type: CHARACTER
    Format: x(16)
    Help: Terminal Type, leave blank to user system default

    Created on 03/01/2019 by DBHTML V1.2