data-dictionary

FPSAPP.SEC_P_USER_ROLES_ALL

Data Dictionary

>

FPSAPP Views

> FPSAPP.WIP_WAFER_HIST_LOOP

View FPSAPP.SEC_P_USER_ROLES_ALL

This view returns all effective roles configured in the security application

Column

Comment

USER_ID

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

ROLE_ID

ROLE_NAME

This is used to define the role name. (* inherited from FPSAPP.APP_W_USERS_ROLES)

APPLICATION_ID

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. (* inherited from FPSAPP.SEC_G_APPLICATIONS)

APPLICATION_NAME

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. (* inherited from FPSAPP.SEC_G_APPLICATIONS)