Database Table: BUSPROF

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000324 REQUISITIONERID Non-Unique Index
SQL030416034846020 USERS_ID Primary Key
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable