This database table contains the reference to the Assignment Manager Rule Id that created the corresponding row in ZCA_OBJECT_SHARE. This row is interpreted as the reason an object share record was created. Functionally this represents the reason an access group was provided access to an object. In case such access was granted manually, this row will be created with a Rule Id of '-1'.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
zca_object_share_reason_PK |
OBJECT_TYPE, OBJECT_SHARE_REASON_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OBJECT_SHARE_REASON_ID | NUMBER | 18 | Yes | Primary Key of the Object Share Reason (surrogate). | |
| ASSIGNMENT_RULE_GROUP_ID | NUMBER | 18 | This is used to store the Access Group Id which is referenced in the Assignment Manager Rule Candidate table to identify which Candidate was responsible for this Share. This value will be -1 for manually created Shares | ||
| OBJECT_SHARE_ID | NUMBER | 18 | Yes | Reference to the Object Share for which this record was created. | |
| OBJECT_TYPE | VARCHAR2 | 30 | Yes | Copied over from ZCA_OBJECT_SHARE so that this table may also be partitioned in the same lines as ZCA_OBJECT_SHARE. This table will be partitioned using the list partition scheme with this column as a the partition key. | |
| ASSIGNMENT_RULE_GUID | VARCHAR2 | 64 | Yes | Reference to the Assignment Manager Rule that was met, which led to creation of this share. This value will be -1 for manually created Shares. | |
| SRC_OBJECT_SHARE_REASON_ID | NUMBER | 18 | Foreign key to ZCA_OBJECT_SHARE_REASON record from the Source Object | ||
| SRC_RELATIONSHIP_DN_ID | NUMBER | 18 | Foreign key to ZCA_AG_RELATIONSHIP_DN record from the Source Object | ||
| SRC_ACC_EXT_RULE_DN_ID | NUMBER | 18 | Foreign key to ZCA_AG_ACC_EXT_RULE_DN record from the Source Object | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| ZCA_OBJECT_SHARE_REASON_N1 | Non Unique | Default | OBJECT_SHARE_ID, OBJECT_TYPE, ASSIGNMENT_RULE_GUID, ASSIGNMENT_RULE_GROUP_ID | |
| ZCA_OBJECT_SHARE_REASON_N2 | Non Unique | Default | ASSIGNMENT_RULE_GUID, ASSIGNMENT_RULE_GROUP_ID, OBJECT_SHARE_ID, OBJECT_TYPE | |
| ZCA_OBJECT_SHARE_REASON_N3 | Non Unique | Default | SRC_OBJECT_SHARE_REASON_ID, SRC_RELATIONSHIP_DN_ID, SRC_ACC_EXT_RULE_DN_ID, OBJECT_TYPE | |
| ZCA_OBJECT_SHARE_REASON_PK | Unique | Default | OBJECT_SHARE_REASON_ID, OBJECT_TYPE | Obsolete |
| ZCA_OBJECT_SHARE_REASON_U2 | Unique | Default | OBJECT_TYPE, OBJECT_SHARE_REASON_ID |