ZCA_AG_DISPOSITION_FINAL_GT
This Global Temp Table for a transaction. It stores one batch of records to be inserted in ZCA_OBJECT_SHARE table
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | 18 | This column stores the OBJECT_ID value | |
OBJECT_NUMBER | VARCHAR2 | 300 | This stores Object Number of the record. | |
ACCESS_GROUP_ID | NUMBER | 18 | This is a placeholder for access group id column in ZCA_ACCESS_GROUPS table | |
ACCESS_GROUP_NUMBER | VARCHAR2 | 4000 | This is a placeholder for PUID column of ZCA_ACCESS_GROUPS table | |
ACCESS_GROUP_TYPE_CODE | VARCHAR2 | 30 | This is a place holder for group type column in ZCA_ACCESS_GROUPS table | |
ACCESS_LEVEL_CODE | VARCHAR2 | 50 | This is a placeholder for access level code column in ZCA_ACCESS_GROUPS table | |
ASSIGNMENT_RULE_GUID | VARCHAR2 | 64 | ASSIGNMENT_RULE_GUID. This is placeholder of the rule | |
ASSIGNMENT_RULE_GROUP_ID | NUMBER | 18 | This is a placeholder for the candidate enabled for the given rule. It contains the value of the Access Group Id | |
EXT_RULE_DN_ID | NUMBER | 18 | This is a placeholder for extention rule denorm id column in ZCA_AG_ACC_EXT_RULE_DN table | |
OBJECT_SHARE_REASON_ID | NUMBER | 18 | This is a placeholder for object share reason id. |