Project Element

Project Element is a parent-child tree structure that can include 99 levels in Infor LN. In Birst, the tree structure is limited to 15 levels. It is a flattened structure and the tree can be formed using drill maps in Birst Visualizer.

This table shows the LN tables from which fields are retrieved for the dimension:

Table Description
tpptc100 Elements
tpptc101 Element Relations

This table shows the attribute mapping to LN table fields for the dimension:

Attribute Mapping
Actual Element Flag 1 if actual element, else 0
Billable tpptc100.blbl
Billable Filter tpptc100.blbl
Billable Sort tpptc100.blbl
Budget Quantity tpptc100.qanc
Budget Status tpptc100.stat
Budget Status Filter tpptc100.stat
Budget Status Sort tpptc100.stat
Capital Element tpptc100.cape
Capital Element Filter tpptc100.cape
Capital Element Sort tpptc100.cape
Company tpptc100.compnr
Cost Control tpptc100.cctr
Cost Control Filter tpptc100.cctr
Cost Control Sort tpptc100.cctr
Cost Control Status tpptc100.ccst
Cost Control Status Filter tpptc100.ccst
Cost Control Status Sort tpptc100.ccst
Current Hierarchy Level Indicates the level no. of the element
Element for Headers tpptc100.txsp
Element for Headers Filter tpptc100.txsp
Element for Headers Sort tpptc100.txsp
Extension tpptc100.cstl
Finish Time tpptc100.dldt
Hierarchy Max Level Indicates the max no. of levels
Linked Activity tpptc101.cact
Linked Plan tpptc101.cpla
Number of Time Units tpptc100.qutm
Parent Element tpptc101.cspp
Physical Progress Quantity tpptc100.qans
Project tpptc100.cprj
Project Element tpptc100.cspa
Project Element Desc tpptc100.desc
Project Element ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level01 tpptc100.cspa or tpptc100.cspp
Project Element Level01 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level02 tpptc100.cspa or tpptc100.cspp
Project Element Level02 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level03 tpptc100.cspa or tpptc100.cspp
Project Element Level03 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level04 tpptc100.cspa or tpptc100.cspp
Project Element Level04 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level05 tpptc100.cspa or tpptc100.cspp
Project Element Level05 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level06 tpptc100.cspa or tpptc100.cspp
Project Element Level06 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level07 tpptc100.cspa or tpptc100.cspp
Project Element Level07 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level08 tpptc100.cspa or tpptc100.cspp
Project Element Level08 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level09 tpptc100.cspa or tpptc100.cspp
Project Element Level09 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level10 tpptc100.cspa or tpptc100.cspp
Project Element Level10 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level11 tpptc100.cspa or tpptc100.cspp
Project Element Level11 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level12 tpptc100.cspa or tpptc100.cspp
Project Element Level12 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level13 tpptc100.cspa or tpptc100.cspp
Project Element Level13 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level14 tpptc100.cspa or tpptc100.cspp
Project Element Level14 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Project Element Level15 tpptc100.cspa or tpptc100.cspp
Project Element Level15 ID Desc tpptc100.cspa or tpptc100.cspp + tpptc100.desc
Quantity in Budget Structure tpptc100.qust
Start Time tpptc100.stdt
Time Unit tpptc100.cuti
Total Element Flag 1 if parent element, else 0
Unit tpptc100.cuni
Unknown 1 for null records, else 0
Work Authorization Status tpptc100.wast
Work Authorization Status Filter tpptc100.wast
Work Authorization Status Sort tpptc100.wast
deleted 1 if deleted in LN, else 0
Customer Defined Fields Standard list of fields