This table stores business profile information for
a user. It is populated by the user registration commands. It is
intended to be populated for users with profile type
(USERS.PROFILETYPE) of "B", signifying that this is business
user.
Column Descriptions:
Name | 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 of this
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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | USERS_ID | Primary Key |
I0000324 | REQUISITIONERID | Non-Unique Index |
I0000486 | ORGUNIT_ID | Non-Unique Index |
I0000487 | ORG_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | 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 |