This table stores business profile information for a user.
Column Name | Column Type | Column Description |
---|---|---|
ALTERNATEID | VARCHAR (20) NULL |
A special ID assigned by the organization or organizational unit to which this business user belongs. |
DEPARTMENTNUM | VARCHAR (128) NULL |
The department number for the business user. |
EMPLOYEEID | VARCHAR (20) NULL |
A method to identify the employee, such as by employee number. |
EMPLOYEETYPE | VARCHAR (128) NULL |
The employee type, such as regular, part time, special part time, supplemental, and contractor. |
MANAGER | VARCHAR (256) NULL |
The name of the manager or supervisor or this his business user. |
ORGUNIT_ID | BIGINT NULL |
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. |
ORG_ID | BIGINT NULL |
Identifies the organization to which the business user owning this business profile is associated with. |
REQUISITIONERID | VARCHAR (128) NULL |
A unique ID for identifying the requisitioner. |
SECRETARY | VARCHAR (256) NULL |
The name of the secretary or administrative assistant of the business user. |
USERS_ID | BIGINT NOT NULL |
Foreign key to the USERS table for this business user. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000324 | REQUISITIONERID | Non-Unique Index |
SQL030416034846020 | USERS_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | 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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|