KCRT_FLS_VISIBILITY

This table stores information about the existence of visibility security on a request. It stores the request's type, header type, and user data context, and indicates whether field-level security has been set on any of the fields. This is a one-to-one table with KCRT_REQUESTS.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_REQUEST_HEADER_TYPES_NLS

REQUEST_HEADER_TYPE_ID

REQUEST_HEADER_TYPE_ID

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

USER_DATA_SET_CONTEXT_ID

Column Descriptions

Column Name

Null?

Data Type

Description

FLS_VISIBILITY_ID

NOT NULL

NUMBER

System-generated identifier

REQUEST_ID

NOT NULL

NUMBER

ID of the request for which security information is stored

REQUEST_TYPE_ID

NOT NULL

NUMBER

ID of the request's type

REQUEST_HEADER_TYPE_ID

NOT NULL

NUMBER

ID of the request's header type

USER_DATA_SET_CONTEXT_ID

NOT NULL

NUMBER

Parameter-set context identifier for the user data fields

RHT_VISIBILITY_SEC_EXISTS_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether the request header type has field-level security set

RT_VISIBILITY_SEC_EXISTS_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether the request type has field-level security set

UD_VISIBILITY_SEC_EXISTS_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether request user data has field-level security set

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FLS_VISIBILITY_N1

NONUNIQUE

1

REQUEST_TYPE_ID

KCRT_FLS_VISIBILITY_N2

NONUNIQUE

1

REQUEST_HEADER_TYPE_ID

KCRT_FLS_VISIBILITY_N3

NONUNIQUE

1

USER_DATA_SET_CONTEXT_ID

KCRT_FLS_VISIBILITY_U1

UNIQUE

1

FLS_VISIBILITY_ID

KCRT_FLS_VISIBILITY_U2

UNIQUE

1

REQUEST_ID

Sequences

Sequence Name

Sequence Type

KCRT_FLS_VISIBILITY_S

FLS_VISIBILITY_ID