This table stores business profile information for a user.
Column Description(s):
Column Name | Column Type | Description |
USERS_ID |
BIGINT NOT NULL |
Foreign key to the USERS table for this business user. |
EMPLOYEEID |
VARCHAR(20) |
A method to identify the employee, such as by employee number. |
ORG_ID |
BIGINT |
Identifies the organization to which the business user owning this business profile is associated with. |
ORGUNIT_ID |
BIGINT |
Identifies the organizational unit to which the business user owning this business profile is associated with. If there are multiple organizational units, it is usually the lowest one that is referred to here. |
EMPLOYEETYPE |
VARCHAR(128) |
The employee type, such as regular, part time, special part time, supplemental, and contractor. |
DEPARTMENTNUM |
VARCHAR(128) |
The department number for the business user. |
ALTERNATEID |
VARCHAR(20) |
A special ID assigned by the organization or organizational unit to which this business user belongs. |
MANAGER |
VARCHAR(256) |
The name of the manager or supervisor or this his business user. |
SECRETARY |
VARCHAR(256) |
The name of the secretary or administrative assistant of the business user. |
REQUISITIONERID |
VARCHAR(128) |
A unique ID for identifying the requisitioner. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031203750 |
USERS_ID |
Primary Key |
I0000324 |
REQUISITIONERID |
Non-Unique Index |
I0000486 |
ORGUNIT_ID |
Non-Unique Index |
I0000487 |
ORG_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_132 |
ORG_ID |
ORGENTITY |
ORGENTITY_ID |
Cascade |
F_133 |
ORGUNIT_ID |
ORGENTITY |
ORGENTITY_ID |
Cascade |
F_134 |
USERS_ID |
USERS |
USERS_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.