Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.SEC_W_GROUPS
Table FPSINPUT.SEC_W_GROUPS"
Contains the list of user groups associated with each application. (Ex: Administrators, Super Users).
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: GROUP_ID
-
Foreign keys: SEC_W_GROUPS_APPLICATION_FK: APPLICATION_ID REFERENCES FPSAPP.SEC_G_APPLICATIONS (APPLICATION_ID)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
GROUP_ID |
VARCHAR2(10) |
N |
|
|
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. (* from FPSAPP.SEC_G_APPLICATIONS) |
|
GROUP_NAME |
VARCHAR2(50) |
N |