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 |