Project Triggering Activity
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 |
---|---|
Activity Position | tppss200.actp |
Activity Type | tppss200.tact |
Activity Type Filter | tppss200.tact |
Activity Type Sort | tppss200.tact |
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 |
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 |
Company | tppss200.compnr |
Company Desc | tcemm170.desc |
Financial Company | tcemm170.desc |
Critical Capacity Type |
tppss200.capt |
Critical Capacity Type Filter | tppss200.capt |
Critical Capacity Type Sort | tppss200.capt |
Current Hierarchy Level | Indicates the level number 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 |
Free Float | tppss200.fref |
Free Float in Hours | tppss200.ffhr |
Frequency | tppss200.freq |
Hierarchy Max Level | Indicates the maximum number of levels |
Latest Start Date | tppss200.lsdt |
Level Number | tppss200.levl |
Linked Activity | tppss200.lact |
Linked Activity Desc | tppss200.desc |
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 Desc | tppdm600.dsca |
Project Activity ID Desc | tppss200.cact + tppss200.desc |
Project Location | tppss200.cloc |
Project Triggering Activity | tppss200.cact |
Project Triggering Activity Desc | tppss200.desc |
Project Triggering Activity ID Desc | tppss200.cact + desc |
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 |
Schedule 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 | 1 if it is a parent activity, else 0 |
Total Float | tppss200.totf |
Total Float in Hours | tppss200.tfhr |
Unit | tppss200.cuni |
Work Authorization Status | tppss200.wast |
Work Authorization Status Filter | tppss200.wast |
Work Authorization Status Sort | tppss200.wast |
Unknown | 1 for null records, else 0 |
deleted | 1 if deleted in LN, else 0 |
Customer Defined Fields | Standard list of fields |