Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            WFUSRPROFL FILE

                         Workflow User Profile

The Workflow User Profile file contains the basic user information for each
user allowed to use Enterprise Workflow. The information in this file includes
the user ID, E-mail address, and position in the company. Company and position
information can be taken from the Human Resources system.

REFERENCED BY

BL546     IC550

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WFU-USER             Alpha 10  (Lower Case)
User                 The user ID of the user being profiled.

WFU-DESCRIPTION      Alpha 30  (Lower Case)
Description          A description of the user.

WFU-COMPANY          Numeric 4
Company              The company number. This number can be
                     taken from the Human Resources system.

WFU-EMPLOYEE         Numeric 9
Employee             Contains the employee number. Each
                     person employed by the company is
                     assigned a unique number. The
                     system uses the employee number to
                     correlate all of the information related
                     to that person.

WFU-E-MAIL-ADDRESS   Alpha 60  (Lower Case)
E Mail Address       A valid E-mail address of the user.

WFU-HOME-PAGE-URL    Alpha 70  (Lower Case)
Home Page Url        The Universal Resource Locator (URL)
                     for the user's World Wide Web home page.

WFU-FN-DOMAIN        Alpha 30  (Lower Case)
Fn Domain            A domain assigned to the user as part
                     of the FileNET PANAGON Visual WorkFlo
                     3.0 system. This
                     information is used for security
                     purposes.

WFU-FN-USERGRPNAME   Alpha 14  (Lower Case)
Fn Usergrpname       A user group name assigned as part of
                     FileNET PANAGON Visual WorkFlo 3.0
                     security.

WFU-FN-ISOLATD-RGN   Numeric 3
Fn Isolatd Rgn       A region assigned to the user as part
                     of FileNET PANAGON Visual WorkFlo 3.0.

WFU-FN-MACH-ID       Numeric 3
Fn Mach Id           A unique number identifying the user's
                     computer. This value is used by FileNET
                     to identify client
                     computers.

WFU-FILTER-CATGORY   Alpha 1
Filter Catgory       A category assigned to the user. This
                     category and its value are used to limit
                     the number of work units in
                     the user's Inbasket.
                     Y = Yes
                     N = No

WFU-FAX-NMBR         Alpha 15
Fax Number           A telephone number for the user's Fax
                     machine.

WFU-PHONE-MOBILE     Alpha 15
Phone Mobile         A telephone number for the user's
                     cellular phone.

WFU-PHONE-HOME       Alpha 15
Phone Home           The telephone number for the user's
                     home.

WFU-PHONE-BUSINESS   Alpha 15
Phone Business       The telephone number for the user's
                     business or office.

WFU-PHONE-PAGER      Alpha 15
Phone Pager          The telephone number for the user's
                     pager.

WFU-ADDR1            Alpha 30  (Lower Case)
Address 1            The first line of the user's address.

WFU-ADDR2            Alpha 30  (Lower Case)
Address 2            The second line of the user's address.

WFU-ADDR3            Alpha 30  (Lower Case)
Address 3            The third line of the user's address.

WFU-ADDR4            Alpha 30  (Lower Case)
Address 4            The fourth line of the user's address.

WFU-CITY             Alpha 18  (Lower Case)
City                 The user's city.

WFU-STATE            Alpha 2
State or Province    The user's two character state or
                     province abbreviation.

WFU-ZIP              Alpha 10
Postal Code          The user's postal code.

WFU-COUNTRY          Alpha 30  (Lower Case)
Country or Other     The user's country. This field may also
                     be used as an attention line.

WFU-FN-USER-ID       Alpha 10  (Lower Case)
Fn User Id           The user's FileNET User ID. The FileNET
                     Values located on WF01.1 (Configuration)
                     are the default login
                     and password into the workflow engine
                     which is used by all users, unless
                     determined otherwise on the
                     Domain form tab of WF12.1 (User Profile
                     Definition). The FileNET User ID value
                     must be added to FileNET
                     IMS as a valid user.

WFU-FN-ACCESS-ID     Alpha 10  (Lower Case)
Fn Access Id         The user's FileNET Access ID. The
                     FileNET Values located on WF01.1
                     (Configuration) are the default login
                     and password into the workflow engine
                     which is used by all users, unless
                     determined otherwise on the
                     Domain form tab of WF12.1 (User Profile
                     Definition). The FileNET Access ID value
                     must be added to
                     FileNET IMS as a valid password.

WFU-INBASKET-PWD     Alpha 30  (Lower Case)
Inbasket Pwd

WFU-PAGER-EMAIL      Alpha 60  (Lower Case)
Pager Email

WFU-DIRECTORY-ID     Numeric 15
Directory Id         The identification number for the
                     user's resource directory entry.

WFU-DISPLAY-ALL      Alpha 1
Display All          Determines if all available entries in
                     a user's queue are displayed by default.
                     N = No
                     Y = Yes

                         WFUSRPROFL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WFUSET1   USER                                                   BL546   IC550

WFUSET2   COMPANY       KeyChange, Subset
          EMPLOYEE      Where COMPANY  != Zeroes
                        And   EMPLOYEE != Zeroes

                         WFUSRPROFL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            WFU-COMPANY         -> EMP-COMPANY  (EMPSET1)
                            WFU-EMPLOYEE        -> EMP-EMPLOYEE

Wfrdidhdr      WFRDIDHDR    Required

                            WFU-DIRECTORY-ID    -> WDR-DIRECTORY-ID

                         WFUSRPROFL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfusercat      WFUSERCAT    Delete Cascades

                            WFU-USER            -> WFT-USER
                                                   WFT-WORK-CATEGORY
                                                   WFT-WORK-CAT-VALUE

Wfusrrole      WFUSRROLE    Delete Cascades

                            WFU-USER            -> WFB-USER
                                                   WFB-ROLE

Wfusrxref      WFUSRXREF    Delete Cascades

                            WFU-USER            -> WXX-USER
                                                   WXX-OBJECT-NAME
                                                   WXX-KEY-STRING