Data Dictionary
>
FPSBASE Tables
> FPSBASE.SEC_W_USERS
Table FPSBASE.SEC_W_USERS"
Contains the list of users who can log in to the applications.
-
Schema: FPSBASE
-
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 |
|
|
|
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) |