BUSPROF

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:

NameTypeDescription
USERS_IDBIGINT NOT NULLForeign key to the USERS table for this business user.
EMPLOYEEIDVARCHAR (20)A method to identify the employee, such as by employee number.
ORG_IDBIGINTIdentifies the organization to which the business user owning this business profile is associated with.
ORGUNIT_IDBIGINTIdentifies 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.
EMPLOYEETYPEVARCHAR (128)The employee type, such as regular, part time, special part time, supplemental, and contractor.
DEPARTMENTNUMVARCHAR (128)The department number for the business user.
ALTERNATEIDVARCHAR (20)A special ID assigned by the organization or organizational unit to which this business user belongs.
MANAGERVARCHAR (256)The name of the manager or supervisor of this business user.
SECRETARYVARCHAR (256)The name of the secretary or administrative assistant of the business user.
REQUISITIONERIDVARCHAR (128)A unique ID for identifying the requisitioner.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>USERS_IDPrimary Key
I0000324REQUISITIONERIDNon-Unique Index
I0000486ORGUNIT_IDNon-Unique Index
I0000487ORG_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_132ORG_IDORGENTITYORGENTITY_IDCascade
F_133ORGUNIT_IDORGENTITYORGENTITY_IDCascade
F_134USERS_IDUSERSUSERS_IDCascade