data-dictionary

FPSADMIN.SEC_G_APPLICATIONS

Data Dictionary

>

FPSADMIN Tables

> FPSADMIN.SEC_G_APPLICATIONS

Table FPSADMIN.SEC_G_APPLICATIONS"

Contains the applications (ex: Dashboard, NextMove, Factory Forum).

  • Schema: FPSADMIN

  • Tablespace: FPSDATA

  • Primary key: APPLICATION_ID

  • Referenced by: FPSAPP.SEC_W_GROUPS (APPLICATION_ID) FPSAPP.SEC_W_ROLES (APPLICATION_ID)


Column

Type

Nullable

Comment

APPLICATION_ID

VARCHAR2(10)

N

The id of the application used for joining with other SEC tables. This field is a string field but we normally populate it with a number.

APPLICATION_NAME

VARCHAR2(50)

N

The name of the application used for display purposes only. Since we join by application_id, this can be changed as desired without any negative consequences to the behavior of the application or its security features.