PSC_COM_CC_TEMPL_ATTACH

Contains communication template attachment information

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: TABLE

• Tablespace: psc_com_cc_templ_attach

Primary Key

Name	Columns
PSC_COM_CC_TEMPL_ATTACH_PK	DOCUMENT_KEY

Columns

Name	Datatype	Length	Precision	Not-null	Comments
DOCUMENT_KEY	NUMBER		18	Yes	System generated Unique ID to identify template attachments
TEMPLATE_ID	NUMBER		18	Yes	Template Identifier FORIEGN KEY to PSC_COM_CC_TEMPLATES_B.TEMPLATE_ID
ATTACHMENT_ID	NUMBER		18	Yes	Unique Attachment ID FORIEGN KEY to PSC_COM_ATTACHMENT.ATTACHMENT_ID
AGENCY_ID	NUMBER		8	Yes	Agency ID asociated to the template attachment
ATTACHMENT_TYPE	VARCHAR2	15			This field stores the document attachment type information
DOC_CATEGORY	VARCHAR2	30			This field is used to store the document category information
DOC_SUBCATEGORY	VARCHAR2	30			This field is used to store the document subcategory information
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.
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
PSC_COM_CC_TEMPL_ATTACH	psc_com_cc_templates_b	TEMPLATE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PSC_COM_CC_TEMPL_ATTACH_FK1	Non Unique	PSC_COM_CC_TEMPL_ATTACH_FK1	TEMPLATE_ID
PSC_COM_CC_TEMPL_ATTACH_PK	Unique	PSC_COM_CC_TEMPL_ATTACH_PK	DOCUMENT_KEY