data-dictionary

FPSAPP.SEC_W_USERS

Data Dictionary

>

FPSAPP Tables

> FPSAPP.SEC_W_USERS

Table FPSAPP.SEC_W_USERS"

Contains the list of users who can log in to the applications.

  • Schema: FPSAPP

  • Tablespace: FPSDATA

  • Primary key: USER_ID


Column

Type

Nullable

Comment

USER_ID

VARCHAR2(50)

N

The user Id that initiated the last move of this carrier (* from FPSINPUT.MHS_CARRIERS)

AUTHENTICATION_TYPE

VARCHAR2(20)

N

DISPLAY_NAME

VARCHAR2(50)

N

EMAIL

VARCHAR2(128)

Email address of the user. (* from FPSINPUT.GEN_USERS)

FIRST_NAME

VARCHAR2(36)

First name of the user. (* from FPSINPUT.GEN_USERS)

LAST_NAME

VARCHAR2(36)

Last name of the user. (* from FPSINPUT.GEN_USERS)

LOGIN_PASSWORD

VARCHAR2(100)

PHONE_NUMBER

VARCHAR2(100)