data-dictionary
data-dictionary
Breadcrumbs

FPSBASE.GEN_USERS

Data Dictionary

>

FPSBASE Tables

> FPSBASE.GEN_USERS

Table FPSBASE.GEN_USERS"

Detailed information about users that can log events in various input systems. User information is optional and we will always show the username or operator that logs the event if there is no record here.

  • Schema: FPSBASE

  • Tablespace: FPSDATA

  • Primary key: USERNAME

  • Referenced by: FPSINPUT.MNT_TECHNICIANS (USERNAME)


Column

Type

Nullable

Comment

USERNAME

VARCHAR2(64)

N

Field that uniquely identifies a user.

APPLICATION

VARCHAR2(30)

Application that the user is allowed or able to log events.

EMAIL

VARCHAR2(128)

Email address of the user.

FIRST_NAME

VARCHAR2(36)

First name of the user.

LAST_NAME

VARCHAR2(36)

Last name of the user.

PHONE

VARCHAR2(24)

Phone number of the user.

UPDATED_INST

DATE

Time when the record was updated according to the source data. Note this is not the time when the record was actually updated in this table - it will almost always be earlier. (* from FPSINPUT.GEN_FACILITIES)