Expenditure Type Details for OTL Timecards not traceable in BIP Reports.
We are trying to extract timecard details for employees in BIP Report with major components as
timecard measures, project, task and expenditure type.
We are able to abstract the Project number/Name and Task Number/name from
HWM_EXT_ATTRB_DETAIL_V by joining to timecard tables.
project_id = ATTRIBUTE_NUMBER1
task_id = ATTRIBUTE_NUMBER2
but we are not able to extract the Expenditure type Id as ATTRIBUTE_NUMBER3 is blank and
ATTRIBUTE_NUMBER4 is holding project_unit_id (attribute values confirmed from table hwm_tm_rep_atrb_num_val_v).
Could someone please assist us to link timecards details with Expenditure Types?
Tagged:
0