Data Dictionary -- Collaborator

Srl. No.	Table Name	Comment
1	COLAB_TAD_MSGE_FILE_DTL	For collaborate attached file details
2	COLAB_TMD_TRAN_MSGE_DTL	For Collaborate post details
3	COLAB_TSD_TRAN_SUBJ_DTL	For Collaborate subject details
4	COLAB_TUD_MSGE_USER_DTL	For Collaborate shared to user details

Table Name :	COLAB_TAD_MSGE_FILE_DTL
Comment :	For collaborate attached file details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TAD_MSGE_ID	udd_seqno	int(4)	No	MESSAGE ID	Yes
TAD_MSGE_OU	udd_ctxt_ouinstance	int(4)	No	MESSAGE OU	No
TAD_ATTACHMENT	udd_filename	varchar(50)	No	ATTACHMENT	Yes
TAD_CREATED_BY	udd_ctxt_user	varchar(30)	No	CREATED BY	No
TAD_CREATED_DATE	udd_time	datetime(8)	No	CREATED DATE	No
TAD_MODIFIED_BY	udd_ctxt_user	varchar(30)	No	MODIFIED BY	No
TAD_MODIFIED_DATE	udd_time	datetime(8)	No	MODIFIED DATE	No

Table Name :	COLAB_TMD_TRAN_MSGE_DTL
Comment :	For Collaborate post details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TMD_MSGE_ID	udd_seqno	int(4)	No	MESSAGE ID	Yes
TMD_MSGE_OU	udd_ctxt_ouinstance	int(4)	No	MESSAGE OU	No
TMD_SUBJ_ID	udd_refcode	varchar(20)	No	SUBJECT ID	No
TMD_ENTITY_TYPE	udd_typecode	varchar(10)	No	ENTITY TYPE	No
TMD_ENTITY_OU	udd_ctxt_ouinstance	int(4)	No	ENTITY OU	No
TMD_ENTITY	udd_documentno	varchar(40)	No	ENTITY	No
TMD_MSGE_TEXT	udd_txt2000	varchar(2000)	No	MESSAGE TEXT	No
TMD_FLAG	udd_designparamcode	varchar(5)	No	FLAG	No
TMD_POSTED_BY	udd_ctxt_user	varchar(30)	No	POSTED BY	No
TMD_POSTED_DATE	udd_time	datetime(8)	No	POSTED DATE	No
TMD_MODIFIED_BY	udd_ctxt_user	varchar(30)	No	MODIFIED BY	No
TMD_MODIFIED_DATE	udd_time	datetime(8)	No	MODIFIED DATE	No
TMD_PARENT_MSGE_ID	udd_seqno	int(4)	No	PARENT MESSAGE ID	No
TMD_STATUS	udd_designparamcode	varchar(5)	No	STATUS	No

Table Name :	COLAB_TSD_TRAN_SUBJ_DTL
Comment :	For Collaborate subject details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSD_SUBJ_ID	udd_refcode	varchar(20)	No	SUBJECT ID	No
TSD_SUBJ_OU	udd_ctxt_ouinstance	int(4)	No	SUBJECT OU	No
TSD_SUBJ_DESC	udd_desc255	varchar(255)	No	SUBJECT DESCRIPTION	No
TSD_ENTITY_TYPE	udd_typecode	varchar(10)	No	ENTITY TYPE	No
TSD_ENTITY_OU	udd_ctxt_ouinstance	int(4)	No	ENTITY OU	No
TSD_ENTITY	udd_documentno	varchar(40)	No	ENTITY	No
TSD_CREATED_BY	udd_ctxt_user	varchar(30)	No	CREATED BY	No
TSD_CREATED_DATE	udd_time	datetime(8)	No	CREATED DATE	No
TSD_MODIFIED_BY	udd_ctxt_user	varchar(30)	No	MODIFIED BY	No
TSD_MODIFIED_DATE	udd_time	datetime(8)	No	MODIFIED DATE	No
TSD_STATUS	udd_designparamcode	varchar(5)	No	STATUS	No
TSD_SEQ_NO	udd_seqno	int(4)	No	SEQUENCE NO	No

Table Name :	COLAB_TUD_MSGE_USER_DTL
Comment :	For Collaborate shared to user details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TUD_MSGE_ID	udd_seqno	int(4)	No	MESSAGE ID	No
TUD_MSGE_OU	udd_ctxt_ouinstance	int(4)	No	MESSAGE OU	No
TUD_SHARED_TO	udd_ctxt_user	varchar(30)	No	SHARED TO	No
TUD_CREATED_BY	udd_ctxt_user	varchar(30)	No	CREATED BY	No
TUD_CREATED_DATE	udd_time	datetime(8)	No	CREATED DATE	No
TUD_MODIFIED_BY	udd_ctxt_user	varchar(30)	No	MODIFIED BY	No
TUD_MODIFIED_DATE	udd_time	datetime(8)	No	MODIFIED DATE	No
TUD_READ_FLAG	udd_designparamcode	varchar(5)	No	READ FLAG	No
TUD_MSGE_FOR	udd_flag	varchar(25)	No	MESSAGE FOR	No
TUD_SHARED_TYPE	udd_flag	varchar(25)	No	SHARED TYPE	No