POR_CZ_SECURITY_ASSIGNMENTS

This table stores the Id's of the Workers and Requisitioning BU's assigned to Content Zones.

Details

• Schema: FUSION

• Object owner: POR

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
POR_CZ_SECURITY_ASSIGN_PK	CZ_SECURITY_ASSIGNMENT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CZ_SECURITY_ASSIGNMENT_ID	NUMBER		18	Yes	Primary Key for this table. Unique identifier of the assignment.
CONTENT_ZONE_ID	NUMBER		18	Yes	Unique identifier of the Content zone.
WORKER_ID	NUMBER		18	Yes	ID of the Worker assigned to the content zone or '-2' if not applicable.
REQ_BU_ID	NUMBER		18	Yes	ID of the Requisitioning BU assigned to the content zone or '-2' if not applicable.
DELIVER_TO_LOCATION_ID	NUMBER		18	Yes	ID of the Deliver-to location assigned to the content zone or '-2' if not applicable.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
POR_CZ_SECURITY_ASSIGNMENTS	por_content_zones_all_b	CONTENT_ZONE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
POR_CZ_SECURITY_ASSIGN_N1	Non Unique	Default	WORKER_ID
POR_CZ_SECURITY_ASSIGN_N2	Non Unique	Default	REQ_BU_ID
POR_CZ_SECURITY_ASSIGN_N3	Non Unique	Default	DELIVER_TO_LOCATION_ID
POR_CZ_SECURITY_ASSIGN_U1	Unique	Default	CONTENT_ZONE_ID, WORKER_ID, REQ_BU_ID, DELIVER_TO_LOCATION_ID
POR_CZ_SECURITY_ASSIGN_U2	Unique	Default	CZ_SECURITY_ASSIGNMENT_ID