Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.APP_W_USERS
Table FPSINPUT.APP_W_USERS"
app_W_USERS table used to store user information for each user
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: USER_LOGIN
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
USER_LOGIN |
VARCHAR2(50) |
N |
|
|
AUTHENTICATION_METHOD |
VARCHAR2(50) |
||
|
IS_ACTIVE |
CHAR(1) |
Flag to enable or disable the tag condition. (* from FPSBASE.MSO_TAG_CONDITIONS) |
|
|
IS_APPROVED |
CHAR(1) |
||
|
USER_DISPLAY_NAME |
VARCHAR2(100) |
||
|
USER_EMAIL |
VARCHAR2(100) |
||
|
USER_FIRST_NAME |
VARCHAR2(50) |
||
|
USER_ID |
VARCHAR2(50) |
N |
The user Id that initiated the last move of this carrier (* from FPSINPUT.MHS_CARRIERS) |
|
USER_LAST_NAME |
VARCHAR2(50) |
||
|
USER_PASSWORD |
VARCHAR2(100) |
N |