SAS_AUTHZ_PROJ_SNAPSHOTS
Control table for active immutable cache projection snapshot versions by projection family and scope. Projection builders validate complete snapshots before activation. SAS_AUTHZ_PROJ_SNAPSHOTS_PK is the disabled primary-key constraint for projection, scope, and snapshot version. SAS_AUTHZ_PROJ_SNAPSHOTS_U1 enforces that key. SAS_AUTHZ_PROJ_SNAPSHOTS_N1 supports active-version lookup by projection and scope. SAS_AUTHZ_PROJ_SNAPSHOTS_U2 allows only one active version per projection and scope; its ELSE NULL function expressions let inactive versions remain as history. SAS_AUTHZ_PROJ_SNAPS_CHK1 constrains ACTIVE_FLAG to 0 or 1.
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SAS_AUTHZ_PROJ_SNAPSHOTS_PK |
PROJECTION_NAME, SCOPE_TYPE, SCOPE_KEY, SNAPSHOT_VERSION |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROJECTION_NAME | VARCHAR2 | 128 | Yes | Logical projection family, such as seeded role closure, permission membership, or implicit permission closure. | |
| SCOPE_TYPE | VARCHAR2 | 32 | Yes | Projection scope type. Expected values include GLOBAL and DEPLOYMENT. | |
| SCOPE_KEY | VARCHAR2 | 256 | Yes | Stable scope identifier. Use GLOBAL for global projections and the API-facing deployment name for deployment-scoped projections. | |
| SNAPSHOT_VERSION | NUMBER | 18 | Yes | Immutable projection generation selected by the control plane for Valkey publication and DB fallback reads. | |
| ACTIVE_FLAG | NUMBER | 1 | Yes | Indicates whether this snapshot version is the active version for the projection and scope. Exactly one row may be active for a projection and scope. | |
| ACTIVATION_DATE | TIMESTAMP | Timestamp when the projection builder marked this snapshot version active. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SAS_AUTHZ_PROJ_SNAPSHOTS_N1 | Non Unique | Default | PROJECTION_NAME, SCOPE_TYPE, SCOPE_KEY, ACTIVE_FLAG, SNAPSHOT_VERSION |
| SAS_AUTHZ_PROJ_SNAPSHOTS_U1 | Unique | Default | PROJECTION_NAME, SCOPE_TYPE, SCOPE_KEY, SNAPSHOT_VERSION |
| SAS_AUTHZ_PROJ_SNAPSHOTS_U2 | Unique | Default | CASE "ACTIVE_FLAG" WHEN 1 THEN "PROJECTION_NAME" ELSE NULL END, CASE "ACTIVE_FLAG" WHEN 1 THEN "SCOPE_TYPE" ELSE NULL END, CASE "ACTIVE_FLAG" WHEN 1 THEN "SCOPE_KEY" ELSE NULL END |