Project Activity
In Infor LN, Project Activity is a parent-child tree structure that can include 99 levels. 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 table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tppss200 | Activities |
This table shows the attribute mapping to LN table fields for the dimension:
| Attribute | Mapping |
|---|---|
| Active Plan Flag | 1 if active plan, else 0 |
| Activity Manager | tppss200.acmn |
| Activity Manager Name | tccom130.nama |
| Activity Position | tppss200.actp |
| Activity Type | tppss200.tact |
| Activity Type Filter | tppss200.tact |
| Activity Type Sort | tppss200.tact |
| Actual Activity Flag | 1 if actual activity else 0 |
| Actual Finish Date | tppss200.afdt |
| Actual Start Date | tppss200.asdt |
| Apply Frequency to | tppss200.afrt |
| Apply Frequency to Filter | tppss200.afrt |
| Apply Frequency to Sort | tppss200.afrt |
| Asset Extension | tppss200.aext |
| Asset Number | tppss200.anbr |
| Billable | tppss200.blbl |
| Billable Filter | tppss200.blbl |
| Billable Sort | tppss200.blbl |
| Budget Status | tppss200.stat |
| Budget Status Filter | tppss200.stat |
| Budget Status Sort | tppss200.stat |
| Calendar | tppss200.ccal |
| Capital Activity | tppss200.capa |
| Capital Activity Filter | tppss200.capa |
| Capital Activity Sort | tppss200.capa |
| Company | tppss200.compnr |
| Company Desc | tcemm170.desc |
| Constraint Date | tppss200.cnsd |
| Constraint Type | tppss200.cnst |
| Constraint Type Filter | tppss200.cnst |
| Constraint Type Sort | tppss200.cnst |
| Cost Control | tppss200.cctr |
| Cost Control Filter | tppss200.cctr |
| Cost Control Sort | tppss200.cctr |
| Critical Capacity Type | tppss200.capt |
| Critical Capacity Type Filter | tppss200.capt |
| Critical Capacity Type Sort | tppss200.capt |
| Current Hierarchy Level | Indicates the level no. of the activity |
| Customized Item | tppss200.litm |
| Deadline Date | tppss200.ddln |
| Duration | tppss200.dura |
| Earliest Finish Date | tppss200.efdt |
| Earliest Start Date | tppss200.esdt |
| Earned Value Method | tppss200.mevl |
| Earned Value Method Filter | tppss200.mevl |
| Earned Value Method Sort | tppss200.mevl |
| End Percentage | tppss200.prnd |
| Extension | tppss200.cstl |
| Financial Company Desc | tcemm170.desc |
| Free Float | tppss200.fref |
| Free Float in Hours | tppss200.ffhr |
| Frequency | tppss200.freq |
| Hierarchy Max Level | Indicates the max no. of levels |
| Latest Start Date | tppss200.lsdt |
| Level Number | tppss200.levl |
| Linked Activity | tppss200.lact |
| Linked Activity Desc | tppss200.desc for tpss200.lact |
| Low Level Number | tppss200.llnr |
| Milestone Amount | tppss200.mamt |
| Milestone Percentage | tppss200.prms |
| Number of Time Units | tppss200.qutm |
| OBS Element | tppss200.coel |
| OBS Element Desc | tppdm096.dsca |
| On Hold Date | tppss200.ohdt |
| Organization Breakdown Structure | tppss200.pcom |
| Organization Breakdown Structure Desc | tppdm095.dsca |
| Parent Activity | tppss200.qans |
| Parent Activity Desc | tppss200.desc |
| Percentage Completed | tppss200.lvps |
| Physical Progress Quantity | tppss200.qans |
| Physical Progress Registration | tppss200.lvps |
| Physical Progress Registration Filter | tppss200.lvps |
| Physical Progress Registration Sort | tppss200.lvps |
| Plan | tppss200.cpla |
| Plan Desc | tppss010.desc |
| Production Rate | tppss200.prsp |
| Project | tppss200.cprj |
| Project Activity | tppss200.cact |
| Project Activity Desc | tppss200.desc |
| Project Activity ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level01 | tppss200.cact |
| Project Activity Level01 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level02 | tppss200.cact |
| Project Activity Level02 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level03 | tppss200.cact |
| Project Activity Level03 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level04 | tppss200.cact |
| Project Activity Level04 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level05 | tppss200.cact |
| Project Activity Level05 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level06 | tppss200.cact |
| Project Activity Level06 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level07 | tppss200.cact |
| Project Activity Level07 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level08 | tppss200.cact |
| Project Activity Level08 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level09 | tppss200.cact |
| Project Activity Level09 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level10 | tppss200.cact |
| Project Activity Level10 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level11 | tppss200.cact |
| Project Activity Level11 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level12 | tppss200.cact |
| Project Activity Level12 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level13 | tppss200.cact |
| Project Activity Level13 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level14 | tppss200.cact |
| Project Activity Level14 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level15 | tppss200.cact |
| Project Activity Level15 ID Desc | tppss200.cact + tppss200.desc |
| Project Activity Level16 | tppss200.cact |
| Project Activity Level16 ID Desc | tppss200.cact + tppss200.desc |
| Project Desc | tppdm600.dsca |
| Project Location | tppss200.cloc |
| Quantity | tppss200.quan |
| Reason | tppss200.rcod |
| Reason Desc | tcmcs005.dsca |
| Reference Activity | tppss200.rfac |
| Sales Currency | tppss200.sacu |
| Sales Price | tppss200.pris |
| Scheduled Finish Date | tppss200.sfdt |
| Scheduled Start Date | tppss200.ssdt |
| Scheduled Start Date Is Changed Filter | tppss200.sdch |
| Scheduled Start Date Is Changed Sort | tppss200.sdch |
| Scheduled Start Date is Changed | tppss200.sdch |
| Settlement Currency | tppss200.secu |
| Settlement Price | tppss200.prss |
| Start Percentage | tppss200.prst |
| Time Unit | tppss200.cuti |
| Time Unit Duration | tppss200.tmud |
| To be Settled | tppss200.setl |
| To be Settled Filter | tppss200.setl |
| To be Settled Sort | tppss200.setl |
| Top Activity Flag | 1 if top activity, else 0 |
| Total Activity Flag | 1 if it is a parent activity, else 0 |
| Total Float | tppss200.totf |
| Total Float in Hours | tppss200.tfhr |
| Unit | tppss200.cuni |
| Unknown | 1 for null records, else 0 |
| Work Authorization Status | tppss200.wast |
| Work Authorization Status Filter | tppss200.wast |
| Work Authorization Status Sort | tppss200.wast |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |