Data Dictionary -- Time Management Master

Srl. No.	Table Name	Comment
1	ta_am_activity_map_dtl	Activity mapping details
2	ta_am_activity_map_dtl	Activity mapping details
3	ta_bcd_book_code_dtl	Booking code details
4	ta_bcd_book_code_dtl	Booking code details
5	ta_booktype_met	Booking Type
6	ta_booktype_met	Booking Type
7	ta_bti_book_type_info	Booking Type information
8	ta_bti_book_type_info	Booking Type information
9	ta_ma_activity_dtl	activity details
10	ta_ma_activity_dtl	activity details
11	ta_parameter_dtl	Parameter details
12	ta_parameter_dtl	Parameter details
13	ta_qc_quick_code	Quick code
14	ta_qc_quick_code	Quick code
15	ta_set_proc_param_mst	Set procedure parameter details master
16	ta_set_proc_param_mst	Set procedure parameter details master
17	ta_spp_set_proc_param_dtl	Set procedure parameter details
18	ta_spp_set_proc_param_dtl	Set procedure parameter details
19	ta_tm_tame_map_info	Mapping information
20	ta_tm_tame_map_info	Mapping information

Table Name :	ta_am_activity_map_dtl
Comment :	Activity mapping details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
am_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	Yes
am_book_type	fin_booktype	Varchar(40)	No	Booking type	Yes
am_book_code	fin_bookcode	Varchar(40)	No	Booking code	Yes
am_activity_code	fin_activity	Varchar(40)	No	Activity code	Yes
am_bookcode_ou	fin_ctxt_ouinstance	Int(4)	Yes	Booking code ou	No
am_activitymap_id	fin_unique_id	Bigint(8)	Yes	Activity mapping id	No
am_est_hrs	fin_hrshours	Numeric(28)	Yes	Estimated hours	No
am_est_elapse_time	fin_hrshours	Numeric(28)	Yes	Estimated elapse time	No
am_acc_usage	fin_accountcode	Varchar(32)	Yes	Accounting usage	No
am_accusage_ou	fin_ctxt_ouinstance	Int(4)	Yes	Accounting usage ou	No
am_cost_center	fin_maccost	Varchar(32)	Yes	Cost center	No
am_costcenter_ou	fin_ctxt_ouinstance	Int(4)	Yes	Cost center ou	No
am_billable	fin_designparamcode	Varchar(5)	Yes	Billable	No
am_status	fin_designparamcode	Varchar(5)	Yes	status	No
am_createdby	fin_ctxt_user	Varchar(30)	Yes	Created by	No
am_create_date	fin_date	Datetime(8)	Yes	Create date	No
am_modifiedby	fin_ctxt_user	Varchar(30)	Yes	Modified by	No
am_modified_date	fin_date	Datetime(8)	Yes	Modified date	No
am_sourceflag	fin_designparamcode	Varchar(5)	Yes	Sourceflag	No
am_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No

Table Name :	ta_bcd_book_code_dtl
Comment :	Booking code details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bcd_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	No
bcd_book_type	fin_booktype	Varchar(40)	Yes	Booking type	No
bcd_book_code	fin_bookcode	Varchar(40)	No	Booking code	No
bcd_bookcode_ou	fin_ctxt_ouinstance	Int(4)	No	Booking code ou	No
bcd_bcdescription	fin_bcdescription	Varchar(2000)	Yes	bookingcode description	No
bcd_cost_center	fin_maccost	Varchar(32)	Yes	Cost center	No
bcd_costcenter_ou	fin_ctxt_ouinstance	Int(4)	Yes	Costcenter ou	No
bcd_plnd_strt_date	fin_date	Datetime(8)	Yes	planned start date	No
bcd_plnd_end_date	fin_date	Datetime(8)	Yes	planned end date	No
bcd_owner	fin_employee_code	Varchar(60)	Yes	Owner	No
bcd_owner_ou	fin_ctxt_ouinstance	Int(4)	Yes	Owner_ou	No
bcd_status	fin_designparamcode	Varchar(5)	Yes	Status	No
bcd_identifiertype1	fin_identifiertype	Varchar(40)	Yes	identifiertype1	No
bcd_identifiervalue1	fin_identifiervalue	Varchar(100)	Yes	identifiervalue1	No
bcd_identifiertype2	fin_identifiertype	Varchar(40)	Yes	identifiertype2	No
bcd_identifiervalue2	fin_identifiervalue	Varchar(100)	Yes	identifiervalue2	No
bcd_identifiertype3	fin_identifiertype	Varchar(40)	Yes	identifiertype3	No
bcd_identifiervalue3	fin_identifiervalue	Varchar(100)	Yes	identifiervalue3	No
bcd_createdby	fin_ctxt_user	Varchar(30)	Yes	Created by	No
bcd_created_date	fin_date	Datetime(8)	Yes	Created date	No
bcd_modifiedby	fin_ctxt_user	Varchar(30)	Yes	Modified by	No
bcd_modified_date	fin_date	Datetime(8)	Yes	Modified date	No
bcd_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
bcd_sourceflag	fin_designparamcode	Varchar(5)	Yes	Source flag	No
bcd_fb	fin_financebookid	Varchar(20)	Yes	finance booking	No

Table Name :	ta_booktype_met
Comment :	Booking Type

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ta_attributetype	fin_designparamcode	Varchar(5)	No	Attribute type	Yes
ta_attributevalue	fin_quickcodes	Varchar(25)	No	Attribute value	Yes
ta_identifiertype1	fin_identifiertype	Varchar(40)	Yes	identifiertype1	No
ta_identifiertype2	fin_identifiertype	Varchar(40)	Yes	identifiertype2	No
ta_identifiertype3	fin_identifiertype	Varchar(40)	Yes	identifiertype3	No

Table Name :	ta_bti_book_type_info
Comment :	Booking Type information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bti_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	Yes
bti_book_type	fin_booktype	Varchar(40)	No	Booking type	Yes
bti_description	fin_description	Varchar(100)	Yes	Description	No
bti_status	fin_designparamcode	Varchar(5)	Yes	Status	No
bti_identifiertype1	fin_identifiertype	Varchar(40)	Yes	identifiertype1	No
bti_identifiertype2	fin_identifiertype	Varchar(40)	Yes	identifiertype2	No
bti_identifiertype3	fin_identifiertype	Varchar(40)	Yes	identifiertype3	No
bti_createdby	fin_ctxt_user	Varchar(30)	Yes	Created by	No
bti_created_date	fin_date	Datetime(8)	Yes	Created date	No
bti_modifiedby	fin_ctxt_user	Varchar(30)	Yes	Modified by	No
bti_modified_date	fin_date	Datetime(8)	Yes	Modified date	No
bti_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No

Table Name :	ta_ma_activity_dtl
Comment :	activity details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ma_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	Yes
ma_activity_code	fin_activity	Varchar(40)	No	Activity code	Yes
ma_activity_category	fin_quickcodes	Varchar(25)	Yes	Activity category	No
ma_status	fin_designparamcode	Varchar(5)	Yes	status	No
ma_est_hrs	fin_WrkHours	Numeric(28)	Yes	Estimated hours	No
ma_elapse_time	fin_WrkHours	Numeric(28)	Yes	Elapse time	No
ma_createdby	fin_ctxt_user	Varchar(30)	Yes	Created by	No
ma_created_date	fin_date	Datetime(8)	Yes	created date	No
ma_modifiedby	fin_ctxt_user	Varchar(30)	Yes	Modified by	No
ma_modified_date	fin_date	Datetime(8)	Yes	Modified date	No
ma_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
ma_activity_desc	fin_chrdesc	Varchar(150)	Yes	Activity description	No

Table Name :	ta_parameter_dtl
Comment :	Parameter details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ta_component_name	fin_ctxt_component	Varchar(20)	No	Component name	Yes
ta_parameter_type	fin_paramtype	Varchar(25)	No	Parameter type	Yes
ta_parameter_category	fin_category	Varchar(15)	No	Parameter category	Yes
ta_parameter_code	fin_designparamcode	Varchar(5)	No	Parameter code	Yes
ta_parameter_desc	fin_remarks	Varchar(100)	Yes	Parameter description	No
ta_lang_id	fin_ctxt_language	Int(4)	Yes	Language id	No
ta_sort_by	fin_count	Int(4)	Yes	sort by	No

Table Name :	ta_qc_quick_code
Comment :	Quick code

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
qc_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	Yes
qc_type	fin_designparamcode	Varchar(5)	No	Type	Yes
qc_code	fin_quickcodes	Varchar(25)	No	Code	Yes
qc_description	fin_description	Varchar(100)	Yes	Description	No
qc_status	fin_designparamcode	Varchar(5)	Yes	Status	No
qc_createdby	fin_ctxt_user	Varchar(30)	Yes	Createdby	No
qc_created_date	fin_date	Datetime(8)	Yes	Created date	No
qc_modifiedby	fin_ctxt_user	Varchar(30)	Yes	Modified by	No
qc_modified_date	fin_date	Datetime(8)	Yes	Modified date	No
qc_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No

Table Name :	ta_set_proc_param_mst
Comment :	Set procedure parameter details master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ta_param_code	fin_designparamcode	Varchar(5)	Yes	Parameter code	No
ta_param_desc	fin_desc255	Varchar(225)	Yes	Parameter description	No
ta_permitted_val_desc	fin_desc255	Varchar(225)	Yes	Permitted value description	No
ta_lang_id	fin_count	Int(4)	Yes	language id	No
ta_sortby	fin_ctxt_language	Int(4)	Yes	Sort by	No
ta_setting_level	fin_designparamcode	Varchar(5)	Yes	Setting level	No

Table Name :	ta_spp_set_proc_param_dtl
Comment :	Set procedure parameter details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
spp_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	Yes
spp_param_type	fin_designparamcode	Varchar(5)	No	Parameter type	Yes
spp_param_value	fin_param_value	Varchar(100)	No	Parameter value	Yes
spp_param_code	fin_designparamcode	Varchar(5)	No	Parameter code	Yes
spp_value	fin_designparamcode	Varchar(5)	Yes	Value	No
spp_flag	fin_designparamcode	Varchar(5)	Yes	Flag	No

Table Name :	ta_tm_tame_map_info
Comment :	Mapping information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tmm_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	Yes
tmm_booktype	fin_booktype	Varchar(40)	No	Booking type	Yes
tmm_attributetype	fin_designparamcode	Varchar(5)	No	Attribute type	Yes
tmm_attributevalue	fin_quickcodes	Varchar(25)	No	Attribute value	Yes
tmm_attribute_ou	fin_ctxt_ouinstance	Int(4)	No	Attribute ou	Yes

Table Name :	ta_am_activity_map_dtl
Comment :	Activity mapping details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
am_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	Yes
am_book_type	fin_booktype	Varchar(40)	No	Booking type	Yes
am_book_code	fin_bookcode	Varchar(40)	No	Booking code	Yes
am_activity_code	fin_activity	Varchar(40)	No	Activity code	Yes
am_bookcode_ou	fin_ctxt_ouinstance	Int(4)	Yes	Booking code ou	No
am_activitymap_id	fin_unique_id	Bigint(8)	Yes	Activity mapping id	No
am_est_hrs	fin_hrshours	Numeric(28)	Yes	Estimated hours	No
am_est_elapse_time	fin_hrshours	Numeric(28)	Yes	Estimated elapse time	No
am_acc_usage	fin_accountcode	Varchar(32)	Yes	Accounting usage	No
am_accusage_ou	fin_ctxt_ouinstance	Int(4)	Yes	Accounting usage ou	No
am_cost_center	fin_maccost	Varchar(32)	Yes	Cost center	No
am_costcenter_ou	fin_ctxt_ouinstance	Int(4)	Yes	Cost center ou	No
am_billable	fin_designparamcode	Varchar(5)	Yes	Billable	No
am_status	fin_designparamcode	Varchar(5)	Yes	status	No
am_createdby	fin_ctxt_user	Varchar(30)	Yes	Created by	No
am_create_date	fin_date	Datetime(8)	Yes	Create date	No
am_modifiedby	fin_ctxt_user	Varchar(30)	Yes	Modified by	No
am_modified_date	fin_date	Datetime(8)	Yes	Modified date	No
am_sourceflag	fin_designparamcode	Varchar(5)	Yes	Sourceflag	No
am_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No

Table Name :	ta_bcd_book_code_dtl
Comment :	Booking code details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bcd_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	No
bcd_book_type	fin_booktype	Varchar(40)	Yes	Booking type	No
bcd_book_code	fin_bookcode	Varchar(40)	No	Booking code	No
bcd_bookcode_ou	fin_ctxt_ouinstance	Int(4)	No	Booking code ou	No
bcd_bcdescription	fin_bcdescription	Varchar(2000)	Yes	bookingcode description	No
bcd_cost_center	fin_maccost	Varchar(32)	Yes	Cost center	No
bcd_costcenter_ou	fin_ctxt_ouinstance	Int(4)	Yes	Costcenter ou	No
bcd_plnd_strt_date	fin_date	Datetime(8)	Yes	planned start date	No
bcd_plnd_end_date	fin_date	Datetime(8)	Yes	planned end date	No
bcd_owner	fin_employee_code	Varchar(60)	Yes	Owner	No
bcd_owner_ou	fin_ctxt_ouinstance	Int(4)	Yes	Owner_ou	No
bcd_status	fin_designparamcode	Varchar(5)	Yes	Status	No
bcd_identifiertype1	fin_identifiertype	Varchar(40)	Yes	identifiertype1	No
bcd_identifiervalue1	fin_identifiervalue	Varchar(100)	Yes	identifiervalue1	No
bcd_identifiertype2	fin_identifiertype	Varchar(40)	Yes	identifiertype2	No
bcd_identifiervalue2	fin_identifiervalue	Varchar(100)	Yes	identifiervalue2	No
bcd_identifiertype3	fin_identifiertype	Varchar(40)	Yes	identifiertype3	No
bcd_identifiervalue3	fin_identifiervalue	Varchar(100)	Yes	identifiervalue3	No
bcd_createdby	fin_ctxt_user	Varchar(30)	Yes	Created by	No
bcd_created_date	fin_date	Datetime(8)	Yes	Created date	No
bcd_modifiedby	fin_ctxt_user	Varchar(30)	Yes	Modified by	No
bcd_modified_date	fin_date	Datetime(8)	Yes	Modified date	No
bcd_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
bcd_sourceflag	fin_designparamcode	Varchar(5)	Yes	Source flag	No
bcd_fb	fin_financebookid	Varchar(20)	Yes	finance booking	No

Table Name :	ta_booktype_met
Comment :	Booking Type

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ta_attributetype	fin_designparamcode	Varchar(5)	No	Attribute type	Yes
ta_attributevalue	fin_quickcodes	Varchar(25)	No	Attribute value	Yes
ta_identifiertype1	fin_identifiertype	Varchar(40)	Yes	identifiertype1	No
ta_identifiertype2	fin_identifiertype	Varchar(40)	Yes	identifiertype2	No
ta_identifiertype3	fin_identifiertype	Varchar(40)	Yes	identifiertype3	No

Table Name :	ta_bti_book_type_info
Comment :	Booking Type information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bti_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	Yes
bti_book_type	fin_booktype	Varchar(40)	No	Booking type	Yes
bti_description	fin_description	Varchar(100)	Yes	Description	No
bti_status	fin_designparamcode	Varchar(5)	Yes	Status	No
bti_identifiertype1	fin_identifiertype	Varchar(40)	Yes	identifiertype1	No
bti_identifiertype2	fin_identifiertype	Varchar(40)	Yes	identifiertype2	No
bti_identifiertype3	fin_identifiertype	Varchar(40)	Yes	identifiertype3	No
bti_createdby	fin_ctxt_user	Varchar(30)	Yes	Created by	No
bti_created_date	fin_date	Datetime(8)	Yes	Created date	No
bti_modifiedby	fin_ctxt_user	Varchar(30)	Yes	Modified by	No
bti_modified_date	fin_date	Datetime(8)	Yes	Modified date	No
bti_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No

Table Name :	ta_ma_activity_dtl
Comment :	activity details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ma_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	Yes
ma_activity_code	fin_activity	Varchar(40)	No	Activity code	Yes
ma_activity_category	fin_quickcodes	Varchar(25)	Yes	Activity category	No
ma_status	fin_designparamcode	Varchar(5)	Yes	status	No
ma_est_hrs	fin_WrkHours	Numeric(28)	Yes	Estimated hours	No
ma_elapse_time	fin_WrkHours	Numeric(28)	Yes	Elapse time	No
ma_createdby	fin_ctxt_user	Varchar(30)	Yes	Created by	No
ma_created_date	fin_date	Datetime(8)	Yes	created date	No
ma_modifiedby	fin_ctxt_user	Varchar(30)	Yes	Modified by	No
ma_modified_date	fin_date	Datetime(8)	Yes	Modified date	No
ma_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
ma_activity_desc	fin_chrdesc	Varchar(150)	Yes	Activity description	No

Table Name :	ta_parameter_dtl
Comment :	Parameter details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ta_component_name	fin_ctxt_component	Varchar(20)	No	Component name	Yes
ta_parameter_type	fin_paramtype	Varchar(25)	No	Parameter type	Yes
ta_parameter_category	fin_category	Varchar(15)	No	Parameter category	Yes
ta_parameter_code	fin_designparamcode	Varchar(5)	No	Parameter code	Yes
ta_parameter_desc	fin_remarks	Varchar(100)	Yes	Parameter description	No
ta_lang_id	fin_ctxt_language	Int(4)	Yes	Language id	No
ta_sort_by	fin_count	Int(4)	Yes	sort by	No

Table Name :	ta_qc_quick_code
Comment :	Quick code

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
qc_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	Yes
qc_type	fin_designparamcode	Varchar(5)	No	Type	Yes
qc_code	fin_quickcodes	Varchar(25)	No	Code	Yes
qc_description	fin_description	Varchar(100)	Yes	Description	No
qc_status	fin_designparamcode	Varchar(5)	Yes	Status	No
qc_createdby	fin_ctxt_user	Varchar(30)	Yes	Createdby	No
qc_created_date	fin_date	Datetime(8)	Yes	Created date	No
qc_modifiedby	fin_ctxt_user	Varchar(30)	Yes	Modified by	No
qc_modified_date	fin_date	Datetime(8)	Yes	Modified date	No
qc_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No

Table Name :	ta_set_proc_param_mst
Comment :	Set procedure parameter details master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ta_param_code	fin_designparamcode	Varchar(5)	Yes	Parameter code	No
ta_param_desc	fin_desc255	Varchar(225)	Yes	Parameter description	No
ta_permitted_val_desc	fin_desc255	Varchar(225)	Yes	Permitted value description	No
ta_lang_id	fin_count	Int(4)	Yes	language id	No
ta_sortby	fin_ctxt_language	Int(4)	Yes	Sort by	No
ta_setting_level	fin_designparamcode	Varchar(5)	Yes	Setting level	No

Table Name :	ta_spp_set_proc_param_dtl
Comment :	Set procedure parameter details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
spp_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	Yes
spp_param_type	fin_designparamcode	Varchar(5)	No	Parameter type	Yes
spp_param_value	fin_param_value	Varchar(100)	No	Parameter value	Yes
spp_param_code	fin_designparamcode	Varchar(5)	No	Parameter code	Yes
spp_value	fin_designparamcode	Varchar(5)	Yes	Value	No
spp_flag	fin_designparamcode	Varchar(5)	Yes	Flag	No

Table Name :	ta_tm_tame_map_info
Comment :	Mapping information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tmm_ouinstance	fin_ctxt_ouinstance	Int(4)	No	OU instance	Yes
tmm_booktype	fin_booktype	Varchar(40)	No	Booking type	Yes
tmm_attributetype	fin_designparamcode	Varchar(5)	No	Attribute type	Yes
tmm_attributevalue	fin_quickcodes	Varchar(25)	No	Attribute value	Yes
tmm_attribute_ou	fin_ctxt_ouinstance	Int(4)	No	Attribute ou	Yes