Field Map for Oracle Primavera Reporting Database

This documents the mapping from the Reporting Database persisted fields to the fields in the database from whence they are derived.

D_COST_ACCOUNTTop
skeyD_COST_ACCOUNT.skey maps to DIM_COST_ACCOUNT.skey
STAR TableD_COST_ACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
objectidD_COST_ACCOUNT.objectid maps to DIM_COST_ACCOUNT.objectid
STAR TableD_COST_ACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
nameD_COST_ACCOUNT.name maps to DIM_COST_ACCOUNT.name
STAR TableD_COST_ACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
idD_COST_ACCOUNT.id maps to DIM_COST_ACCOUNT.id
STAR TableD_COST_ACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
parentobjectidD_COST_ACCOUNT.parentobjectid maps to DIM_COST_ACCOUNT.parentobjectid
STAR TableD_COST_ACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
currentprocesscycledateD_COST_ACCOUNT.currentprocesscycledate maps to DIM_COST_ACCOUNT.currentprocesscycledate
STAR TableD_COST_ACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
snapshotidID of star snapshot
STAR TableD_COST_ACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessD_COST_ACCOUNT.etlprocess maps to DIM_COST_ACCOUNT.etlprocess
STAR TableD_COST_ACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
D_COST_ACCOUNT_HIERARCHYTop
skeyD_COST_ACCOUNT_HIERARCHY.skey maps to DIM_COST_ACCOUNT_HIERARCHY.skey
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
parentobjectidD_COST_ACCOUNT_HIERARCHY.parentobjectid maps to DIM_COST_ACCOUNT_HIERARCHY.parentobjectid
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
parentsequencenumberD_COST_ACCOUNT_HIERARCHY.parentsequencenumber maps to DIM_COST_ACCOUNT_HIERARCHY.parentsequencenumber
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
parentnameD_COST_ACCOUNT_HIERARCHY.parentname maps to DIM_COST_ACCOUNT_HIERARCHY.parentname
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
parentidD_COST_ACCOUNT_HIERARCHY.parentid maps to DIM_COST_ACCOUNT_HIERARCHY.parentid
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
parentdescriptionD_COST_ACCOUNT_HIERARCHY.parentdescription maps to DIM_COST_ACCOUNT_HIERARCHY.parentdescription
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeclob
childobjectidD_COST_ACCOUNT_HIERARCHY.childobjectid maps to DIM_COST_ACCOUNT_HIERARCHY.childobjectid
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childsequencenumberD_COST_ACCOUNT_HIERARCHY.childsequencenumber maps to DIM_COST_ACCOUNT_HIERARCHY.childsequencenumber
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childnameD_COST_ACCOUNT_HIERARCHY.childname maps to DIM_COST_ACCOUNT_HIERARCHY.childname
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
childidD_COST_ACCOUNT_HIERARCHY.childid maps to DIM_COST_ACCOUNT_HIERARCHY.childid
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
childdescriptionD_COST_ACCOUNT_HIERARCHY.childdescription maps to DIM_COST_ACCOUNT_HIERARCHY.childdescription
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeclob
parentlevelsbelowrootD_COST_ACCOUNT_HIERARCHY.parentlevelsbelowroot maps to DIM_COST_ACCOUNT_HIERARCHY.parentlevelsbelowroot
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childlevelsbelowrootD_COST_ACCOUNT_HIERARCHY.childlevelsbelowroot maps to DIM_COST_ACCOUNT_HIERARCHY.childlevelsbelowroot
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
levelsbetweenD_COST_ACCOUNT_HIERARCHY.levelsbetween maps to DIM_COST_ACCOUNT_HIERARCHY.levelsbetween
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childhaschildrenD_COST_ACCOUNT_HIERARCHY.childhaschildren maps to DIM_COST_ACCOUNT_HIERARCHY.childhaschildren
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
fullpathnameD_COST_ACCOUNT_HIERARCHY.fullpathname maps to DIM_COST_ACCOUNT_HIERARCHY.fullpathname
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
currentprocesscycledateD_COST_ACCOUNT_HIERARCHY.currentprocesscycledate maps to DIM_COST_ACCOUNT_HIERARCHY.currentprocesscycledate
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
snapshotidID of star snapshot
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessD_COST_ACCOUNT_HIERARCHY.etlprocess maps to DIM_COST_ACCOUNT_HIERARCHY.etlprocess
STAR TableD_COST_ACCOUNT_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
D_DATETop
skeyD_DATE.skey maps to PSTG_DATE.skey
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
datenameD_DATE.datename maps to PSTG_DATE.datename
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
daydateD_DATE.daydate maps to PSTG_DATE.daydate
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
daynameD_DATE.dayname maps to PSTG_DATE.dayname
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
dayofmonthD_DATE.dayofmonth maps to PSTG_DATE.dayofmonth
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
dayofyearD_DATE.dayofyear maps to PSTG_DATE.dayofyear
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ordinaldayofmonthD_DATE.ordinaldayofmonth maps to PSTG_DATE.ordinaldayofmonth
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ordinaldayofyearD_DATE.ordinaldayofyear maps to PSTG_DATE.ordinaldayofyear
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
weekbegindateD_DATE.weekbegindate maps to PSTG_DATE.weekbegindate
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
dayofweekD_DATE.dayofweek maps to PSTG_DATE.dayofweek
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
weeknumberD_DATE.weeknumber maps to PSTG_DATE.weeknumber
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
monthnumberD_DATE.monthnumber maps to PSTG_DATE.monthnumber
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
monthnameD_DATE.monthname maps to PSTG_DATE.monthname
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
monthshortnameD_DATE.monthshortname maps to PSTG_DATE.monthshortname
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typecharacter
monthenddateD_DATE.monthenddate maps to PSTG_DATE.monthenddate
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
daysinmonthD_DATE.daysinmonth maps to PSTG_DATE.daysinmonth
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
yearmonthD_DATE.yearmonth maps to PSTG_DATE.yearmonth
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
quarternumberD_DATE.quarternumber maps to PSTG_DATE.quarternumber
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
quarternameD_DATE.quartername maps to PSTG_DATE.quartername
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typecharacter
yearD_DATE.year maps to PSTG_DATE.year
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessD_DATE.etlprocess maps to PSTG_DATE.etlprocess
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
etluserD_DATE.etluser maps to PSTG_DATE.etluser
STAR TableD_DATE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
D_EPSTop
skeyD_EPS.skey maps to DIM_EPS.skey
STAR TableD_EPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
objectidD_EPS.objectid maps to DIM_EPS.objectid
STAR TableD_EPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
nameD_EPS.name maps to DIM_EPS.name
STAR TableD_EPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
parentobjectidD_EPS.parentobjectid maps to DIM_EPS.parentobjectid
STAR TableD_EPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
currentprocesscycledateD_EPS.currentprocesscycledate maps to DIM_EPS.currentprocesscycledate
STAR TableD_EPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
snapshotidID of star snapshot
STAR TableD_EPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessD_EPS.etlprocess maps to DIM_EPS.etlprocess
STAR TableD_EPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
D_EPS_HIERARCHYTop
skeyD_EPS_HIERARCHY.skey maps to DIM_EPS_HIERARCHY.skey
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
parentobjectidD_EPS_HIERARCHY.parentobjectid maps to DIM_EPS_HIERARCHY.parentobjectid
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
parentprojectidD_EPS_HIERARCHY.parentprojectid maps to DIM_EPS_HIERARCHY.parentprojectid
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
parentsequencenumberD_EPS_HIERARCHY.parentsequencenumber maps to DIM_EPS_HIERARCHY.parentsequencenumber
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
parentnameD_EPS_HIERARCHY.parentname maps to DIM_EPS_HIERARCHY.parentname
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
parentidD_EPS_HIERARCHY.parentid maps to DIM_EPS_HIERARCHY.parentid
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
parentoriginalbudgetD_EPS_HIERARCHY.parentoriginalbudget maps to DIM_EPS_HIERARCHY.parentoriginalbudget
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
parentindependentetctotalcostD_EPS_HIERARCHY.parentindependentetctotalcost maps to DIM_EPS_HIERARCHY.parentindependentetctotalcost
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
parentindependentetclaborunitsD_EPS_HIERARCHY.parentindependentetclaborunits maps to DIM_EPS_HIERARCHY.parentindependentetclaborunits
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
parentcurrentbudgetD_EPS_HIERARCHY.parentcurrentbudget maps to DIM_EPS_HIERARCHY.parentcurrentbudget
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
parentcurrentvarianceD_EPS_HIERARCHY.parentcurrentvariance maps to DIM_EPS_HIERARCHY.parentcurrentvariance
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
parentdistributedcurrentbudgetD_EPS_HIERARCHY.parentdistributedcurrentbudget maps to DIM_EPS_HIERARCHY.parentdistributedcurrentbudget
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
parentproposedbudgetD_EPS_HIERARCHY.parentproposedbudget maps to DIM_EPS_HIERARCHY.parentproposedbudget
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
parentstartdateD_EPS_HIERARCHY.parentstartdate maps to DIM_EPS_HIERARCHY.parentstartdate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
parentfinishdateD_EPS_HIERARCHY.parentfinishdate maps to DIM_EPS_HIERARCHY.parentfinishdate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
parentanticipatedstartdateD_EPS_HIERARCHY.parentanticipatedstartdate maps to DIM_EPS_HIERARCHY.parentanticipatedstartdate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
parentanticipatedfinishdateD_EPS_HIERARCHY.parentanticipatedfinishdate maps to DIM_EPS_HIERARCHY.parentanticipatedfinishdate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
parentlastsummarizeddateD_EPS_HIERARCHY.parentlastsummarizeddate maps to DIM_EPS_HIERARCHY.parentlastsummarizeddate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
parentplannedstartdateD_EPS_HIERARCHY.parentplannedstartdate maps to DIM_EPS_HIERARCHY.parentplannedstartdate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
parentobsobjectidD_EPS_HIERARCHY.parentobsobjectid maps to DIM_EPS_HIERARCHY.parentobsobjectid
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
parentobsnameD_EPS_HIERARCHY.parentobsname maps to DIM_EPS_HIERARCHY.parentobsname
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
childobjectidD_EPS_HIERARCHY.childobjectid maps to DIM_EPS_HIERARCHY.childobjectid
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childprojectidD_EPS_HIERARCHY.childprojectid maps to DIM_EPS_HIERARCHY.childprojectid
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childsequencenumberD_EPS_HIERARCHY.childsequencenumber maps to DIM_EPS_HIERARCHY.childsequencenumber
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childnameD_EPS_HIERARCHY.childname maps to DIM_EPS_HIERARCHY.childname
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
childidD_EPS_HIERARCHY.childid maps to DIM_EPS_HIERARCHY.childid
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
childoriginalbudgetD_EPS_HIERARCHY.childoriginalbudget maps to DIM_EPS_HIERARCHY.childoriginalbudget
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
childindependentetctotalcostD_EPS_HIERARCHY.childindependentetctotalcost maps to DIM_EPS_HIERARCHY.childindependentetctotalcost
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
childindependentetclaborunitsD_EPS_HIERARCHY.childindependentetclaborunits maps to DIM_EPS_HIERARCHY.childindependentetclaborunits
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
childcurrentbudgetD_EPS_HIERARCHY.childcurrentbudget maps to DIM_EPS_HIERARCHY.childcurrentbudget
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
childcurrentvarianceD_EPS_HIERARCHY.childcurrentvariance maps to DIM_EPS_HIERARCHY.childcurrentvariance
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
childdistributedcurrentbudgetD_EPS_HIERARCHY.childdistributedcurrentbudget maps to DIM_EPS_HIERARCHY.childdistributedcurrentbudget
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
childproposedbudgetD_EPS_HIERARCHY.childproposedbudget maps to DIM_EPS_HIERARCHY.childproposedbudget
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
childstartdateD_EPS_HIERARCHY.childstartdate maps to DIM_EPS_HIERARCHY.childstartdate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
childfinishdateD_EPS_HIERARCHY.childfinishdate maps to DIM_EPS_HIERARCHY.childfinishdate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
childanticipatedstartdateD_EPS_HIERARCHY.childanticipatedstartdate maps to DIM_EPS_HIERARCHY.childanticipatedstartdate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
childanticipatedfinishdateD_EPS_HIERARCHY.childanticipatedfinishdate maps to DIM_EPS_HIERARCHY.childanticipatedfinishdate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
childlastsummarizeddateD_EPS_HIERARCHY.childlastsummarizeddate maps to DIM_EPS_HIERARCHY.childlastsummarizeddate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
childplannedstartdateD_EPS_HIERARCHY.childplannedstartdate maps to DIM_EPS_HIERARCHY.childplannedstartdate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
childobsobjectidD_EPS_HIERARCHY.childobsobjectid maps to DIM_EPS_HIERARCHY.childobsobjectid
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childobsnameD_EPS_HIERARCHY.childobsname maps to DIM_EPS_HIERARCHY.childobsname
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
parentlevelsbelowrootD_EPS_HIERARCHY.parentlevelsbelowroot maps to DIM_EPS_HIERARCHY.parentlevelsbelowroot
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childlevelsbelowrootD_EPS_HIERARCHY.childlevelsbelowroot maps to DIM_EPS_HIERARCHY.childlevelsbelowroot
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
levelsbetweenD_EPS_HIERARCHY.levelsbetween maps to DIM_EPS_HIERARCHY.levelsbetween
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childhaschildrenD_EPS_HIERARCHY.childhaschildren maps to DIM_EPS_HIERARCHY.childhaschildren
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
fullpathnameD_EPS_HIERARCHY.fullpathname maps to DIM_EPS_HIERARCHY.fullpathname
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
currentprocesscycledateD_EPS_HIERARCHY.currentprocesscycledate maps to DIM_EPS_HIERARCHY.currentprocesscycledate
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
snapshotidID of star snapshot
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessD_EPS_HIERARCHY.etlprocess maps to DIM_EPS_HIERARCHY.etlprocess
STAR TableD_EPS_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
D_FINANCIAL_PERIODTop
skeyD_FINANCIAL_PERIOD.skey maps to DIM_FINANCIAL_PERIOD.skey
STAR TableD_FINANCIAL_PERIOD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
objectidD_FINANCIAL_PERIOD.objectid maps to DIM_FINANCIAL_PERIOD.objectid
STAR TableD_FINANCIAL_PERIOD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
nameD_FINANCIAL_PERIOD.name maps to DIM_FINANCIAL_PERIOD.name
STAR TableD_FINANCIAL_PERIOD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
startdateD_FINANCIAL_PERIOD.startdate maps to DIM_FINANCIAL_PERIOD.startdate
STAR TableD_FINANCIAL_PERIOD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
enddateD_FINANCIAL_PERIOD.enddate maps to DIM_FINANCIAL_PERIOD.enddate
STAR TableD_FINANCIAL_PERIOD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
currentprocesscycledateD_FINANCIAL_PERIOD.currentprocesscycledate maps to DIM_FINANCIAL_PERIOD.currentprocesscycledate
STAR TableD_FINANCIAL_PERIOD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
snapshotidID of star snapshot
STAR TableD_FINANCIAL_PERIOD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessD_FINANCIAL_PERIOD.etlprocess maps to DIM_FINANCIAL_PERIOD.etlprocess
STAR TableD_FINANCIAL_PERIOD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
D_OBSTop
skeyD_OBS.skey maps to DIM_OBS.skey
STAR TableD_OBS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
objectidD_OBS.objectid maps to DIM_OBS.objectid
STAR TableD_OBS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
nameD_OBS.name maps to DIM_OBS.name
STAR TableD_OBS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
parentobjectidD_OBS.parentobjectid maps to DIM_OBS.parentobjectid
STAR TableD_OBS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
currentprocesscycledateD_OBS.currentprocesscycledate maps to DIM_OBS.currentprocesscycledate
STAR TableD_OBS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
snapshotidID of star snapshot
STAR TableD_OBS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessD_OBS.etlprocess maps to DIM_OBS.etlprocess
STAR TableD_OBS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
D_PROJECTTop
skeyD_PROJECT.skey maps to DIM_PROJECT.skey
STAR TableD_PROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
objectidD_PROJECT.objectid maps to DIM_PROJECT.objectid
STAR TableD_PROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
idD_PROJECT.id maps to DIM_PROJECT.id
STAR TableD_PROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
currentprocesscycledateD_PROJECT.currentprocesscycledate maps to DIM_PROJECT.currentprocesscycledate
STAR TableD_PROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
snapshotidID of star snapshot
STAR TableD_PROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessD_PROJECT.etlprocess maps to DIM_PROJECT.etlprocess
STAR TableD_PROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
D_PROJECT_CODETop
skeyD_PROJECT_CODE.skey maps to DIM_PROJECT_CODE.skey
STAR TableD_PROJECT_CODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
objectidD_PROJECT_CODE.objectid maps to DIM_PROJECT_CODE.objectid
STAR TableD_PROJECT_CODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
codevalueD_PROJECT_CODE.codevalue maps to DIM_PROJECT_CODE.codevalue
STAR TableD_PROJECT_CODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
descriptionD_PROJECT_CODE.description maps to DIM_PROJECT_CODE.description
STAR TableD_PROJECT_CODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
codetypenameD_PROJECT_CODE.codetypename maps to DIM_PROJECT_CODE.codetypename
STAR TableD_PROJECT_CODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
codetypeobjectidD_PROJECT_CODE.codetypeobjectid maps to DIM_PROJECT_CODE.codetypeobjectid
STAR TableD_PROJECT_CODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
sequencenumberD_PROJECT_CODE.sequencenumber maps to DIM_PROJECT_CODE.sequencenumber
STAR TableD_PROJECT_CODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
parentobjectidD_PROJECT_CODE.parentobjectid maps to DIM_PROJECT_CODE.parentobjectid
STAR TableD_PROJECT_CODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
weightD_PROJECT_CODE.weight maps to DIM_PROJECT_CODE.weight
STAR TableD_PROJECT_CODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
currentprocesscycledateD_PROJECT_CODE.currentprocesscycledate maps to DIM_PROJECT_CODE.currentprocesscycledate
STAR TableD_PROJECT_CODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
snapshotidID of star snapshot
STAR TableD_PROJECT_CODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessD_PROJECT_CODE.etlprocess maps to DIM_PROJECT_CODE.etlprocess
STAR TableD_PROJECT_CODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
D_PROJECT_CODE_ASSIGNMENTTop
skeyD_PROJECT_CODE_ASSIGNMENT.skey maps to DIM_PROJECT_CODE_ASSIGNMENT.skey
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
projectskeyD_PROJECT_CODE_ASSIGNMENT.projectskey maps to DIM_PROJECT_CODE_ASSIGNMENT.projectskey
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
projectobjectidD_PROJECT_CODE_ASSIGNMENT.projectobjectid maps to DIM_PROJECT_CODE_ASSIGNMENT.projectobjectid
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
projectcodetypeobjectidD_PROJECT_CODE_ASSIGNMENT.projectcodetypeobjectid maps to DIM_PROJECT_CODE_ASSIGNMENT.projectcodetypeobjectid
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
projectcodeskeyD_PROJECT_CODE_ASSIGNMENT.projectcodeskey maps to DIM_PROJECT_CODE_ASSIGNMENT.projectcodeskey
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
projectcodeobjectidD_PROJECT_CODE_ASSIGNMENT.projectcodeobjectid maps to DIM_PROJECT_CODE_ASSIGNMENT.projectcodeobjectid
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
isbaselineD_PROJECT_CODE_ASSIGNMENT.isbaseline maps to DIM_PROJECT_CODE_ASSIGNMENT.isbaseline
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typecharacter
projectcodedescriptionD_PROJECT_CODE_ASSIGNMENT.projectcodedescription maps to DIM_PROJECT_CODE_ASSIGNMENT.projectcodedescription
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
projectcodetypenameD_PROJECT_CODE_ASSIGNMENT.projectcodetypename maps to DIM_PROJECT_CODE_ASSIGNMENT.projectcodetypename
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
projectcodevalueD_PROJECT_CODE_ASSIGNMENT.projectcodevalue maps to DIM_PROJECT_CODE_ASSIGNMENT.projectcodevalue
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
projectnameD_PROJECT_CODE_ASSIGNMENT.projectname maps to DIM_PROJECT_CODE_ASSIGNMENT.projectname
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
currentprocesscycledateD_PROJECT_CODE_ASSIGNMENT.currentprocesscycledate maps to DIM_PROJECT_CODE_ASSIGNMENT.currentprocesscycledate
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
snapshotidID of star snapshot
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessD_PROJECT_CODE_ASSIGNMENT.etlprocess maps to DIM_PROJECT_CODE_ASSIGNMENT.etlprocess
STAR TableD_PROJECT_CODE_ASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
D_PROJECT_CODE_HIERARCHYTop
skeyD_PROJECT_CODE_HIERARCHY.skey maps to DIM_PROJECT_CODE_HIERARCHY.skey
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
codetypeobjectidD_PROJECT_CODE_HIERARCHY.codetypeobjectid maps to DIM_PROJECT_CODE_HIERARCHY.codetypeobjectid
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
codetypenameD_PROJECT_CODE_HIERARCHY.codetypename maps to DIM_PROJECT_CODE_HIERARCHY.codetypename
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
codetypesequencenumberD_PROJECT_CODE_HIERARCHY.codetypesequencenumber maps to DIM_PROJECT_CODE_HIERARCHY.codetypesequencenumber
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
codetypeissecureD_PROJECT_CODE_HIERARCHY.codetypeissecure maps to DIM_PROJECT_CODE_HIERARCHY.codetypeissecure
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
parentcodevalueobjectidD_PROJECT_CODE_HIERARCHY.parentcodevalueobjectid maps to DIM_PROJECT_CODE_HIERARCHY.parentcodevalueobjectid
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
parentcodevaluenameD_PROJECT_CODE_HIERARCHY.parentcodevaluename maps to DIM_PROJECT_CODE_HIERARCHY.parentcodevaluename
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
parentcodevalueshortnameD_PROJECT_CODE_HIERARCHY.parentcodevalueshortname maps to DIM_PROJECT_CODE_HIERARCHY.parentcodevalueshortname
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
parentcodevaluesequencenumberD_PROJECT_CODE_HIERARCHY.parentcodevaluesequencenumber maps to DIM_PROJECT_CODE_HIERARCHY.parentcodevaluesequencenumber
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childcodevalueobjectidD_PROJECT_CODE_HIERARCHY.childcodevalueobjectid maps to DIM_PROJECT_CODE_HIERARCHY.childcodevalueobjectid
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childcodevaluenameD_PROJECT_CODE_HIERARCHY.childcodevaluename maps to DIM_PROJECT_CODE_HIERARCHY.childcodevaluename
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
childcodevalueshortnameD_PROJECT_CODE_HIERARCHY.childcodevalueshortname maps to DIM_PROJECT_CODE_HIERARCHY.childcodevalueshortname
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
childcodevaluesequencenumberD_PROJECT_CODE_HIERARCHY.childcodevaluesequencenumber maps to DIM_PROJECT_CODE_HIERARCHY.childcodevaluesequencenumber
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
parentlevelsbelowrootD_PROJECT_CODE_HIERARCHY.parentlevelsbelowroot maps to DIM_PROJECT_CODE_HIERARCHY.parentlevelsbelowroot
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childlevelsbelowrootD_PROJECT_CODE_HIERARCHY.childlevelsbelowroot maps to DIM_PROJECT_CODE_HIERARCHY.childlevelsbelowroot
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
levelsbetweenD_PROJECT_CODE_HIERARCHY.levelsbetween maps to DIM_PROJECT_CODE_HIERARCHY.levelsbetween
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
childhaschildrenD_PROJECT_CODE_HIERARCHY.childhaschildren maps to DIM_PROJECT_CODE_HIERARCHY.childhaschildren
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
fullpathnameD_PROJECT_CODE_HIERARCHY.fullpathname maps to DIM_PROJECT_CODE_HIERARCHY.fullpathname
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
codetypeweightD_PROJECT_CODE_HIERARCHY.codetypeweight maps to DIM_PROJECT_CODE_HIERARCHY.codetypeweight
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
maxcodevalueweightD_PROJECT_CODE_HIERARCHY.maxcodevalueweight maps to DIM_PROJECT_CODE_HIERARCHY.maxcodevalueweight
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
parentcodevalueweightD_PROJECT_CODE_HIERARCHY.parentcodevalueweight maps to DIM_PROJECT_CODE_HIERARCHY.parentcodevalueweight
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
childcodevalueweightD_PROJECT_CODE_HIERARCHY.childcodevalueweight maps to DIM_PROJECT_CODE_HIERARCHY.childcodevalueweight
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
currentprocesscycledateD_PROJECT_CODE_HIERARCHY.currentprocesscycledate maps to DIM_PROJECT_CODE_HIERARCHY.currentprocesscycledate
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
snapshotidID of star snapshot
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessD_PROJECT_CODE_HIERARCHY.etlprocess maps to DIM_PROJECT_CODE_HIERARCHY.etlprocess
STAR TableD_PROJECT_CODE_HIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
D_TIMETop
civiliantimeD_TIME.civiliantime maps to PSTG_TIME.civiliantime
STAR TableD_TIME
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
militarytimeD_TIME.militarytime maps to PSTG_TIME.militarytime
STAR TableD_TIME
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typecharacter
skeyD_TIME.skey maps to PSTG_TIME.skey
STAR TableD_TIME
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
twocharD_TIME.twochar maps to PSTG_TIME.twochar
STAR TableD_TIME
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typecharacter
timenameD_TIME.timename maps to PSTG_TIME.timename
STAR TableD_TIME
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
timeofdayD_TIME.timeofday maps to PSTG_TIME.timeofday
STAR TableD_TIME
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessD_TIME.etlprocess maps to PSTG_TIME.etlprocess
STAR TableD_TIME
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
etluserD_TIME.etluser maps to PSTG_TIME.etluser
STAR TableD_TIME
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
F_PROJECTSTop
skeyF_PROJECTS.skey maps to STG_F_PROJECT.skey
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
projectskeyF_PROJECTS.projectskey maps to STG_F_PROJECT.projectskey
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
financialperiodskeyF_PROJECTS.financialperiodskey maps to STG_F_PROJECT.financialperiodskey
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
costaccountskeyF_PROJECTS.costaccountskey maps to STG_F_PROJECT.costaccountskey
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
epsskeyF_PROJECTS.epsskey maps to STG_F_PROJECT.epsskey
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
obsskeyF_PROJECTS.obsskey maps to STG_F_PROJECT.obsskey
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
startdateskeyF_PROJECTS.startdateskey maps to STG_F_PROJECT.startdateskey
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
finishdateskeyF_PROJECTS.finishdateskey maps to STG_F_PROJECT.finishdateskey
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
anticipatedfinishdateskeyF_PROJECTS.anticipatedfinishdateskey maps to STG_F_PROJECT.anticipatedfinishdateskey
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
anticipatedstartdateskeyF_PROJECTS.anticipatedstartdateskey maps to STG_F_PROJECT.anticipatedstartdateskey
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
isbaselineF_PROJECTS.isbaseline maps to STG_F_PROJECT.isbaseline
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typecharacter
currentprocesscycledateF_PROJECTS.currentprocesscycledate maps to STG_F_PROJECT.currentprocesscycledate
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ActivityDefaultPricePerUnitThe price used to estimate resource costs for activities that have planned, actual, or remaining units, but no resource assignments. This price is also used to compute costs for activities in cases where resources are assigned but the resources have no prices. Resource cost is computed as the resource units multiplied by the price per time.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameActivityDefaultPricePerUnit
PMDB Tableproject
PMDB Field Namedef_cost_per_qty
Data Typenumber
AnnualDiscountRateThe user-defined number field that identifies the discount rate for the project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameAnnualDiscountRate
PMDB Tableprojwbs
PMDB Field Nameann_dscnt_rate_pct
Data Typenumber
CheckOutDateThe date on which the project was checked out of the Project Management database.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameCheckOutDate
PMDB Tableproject
PMDB Field Namecheckout_date
Data Typedate
CriticalActivityFloatLimitThe duration used to determine if an activity is critical. When an activity has total float that is less than or equal to this duration, the activity is marked as critical.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameCriticalActivityFloatLimit
PMDB Tableproject
PMDB Field Namecritical_drtn_hr_cnt
Data Typenumber
CurrentBudgetThe sum of the original budget plus the approved and pending budgets from the budget change log.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameCurrentBudget
PMDB Table
PMDB Field Name
Data Typenumber
CurrentVarianceThe difference between the current budget and the total spending plan. Calculated as current budget - total spending plan. Not rolled up
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameCurrentVariance
PMDB Table
PMDB Field Name
Data Typenumber
DataDateThe current data date for the project. The project status is up to date as of the data date. The data date is modified when project actuals are applied.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameDataDate
PMDB Table
PMDB Field Name
Data Typedate
DateAddedThe date on which the project was added to the Project Management database.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameDateAdded
PMDB Tableproject
PMDB Field Nameadd_date
Data Typedate
DistributedCurrentBudgetThe current budget values from one level lower.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameDistributedCurrentBudget
PMDB Table
PMDB Field Name
Data Typenumber
EarnedValueUserPercentThe user-defined percent complete for computing earned value for activities within the Project. A value of, say, 25 means that 25% of the planned amount is earned when the activity is started and the remainder is earned when the activity is completed.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameEarnedValueUserPercent
PMDB Tableprojwbs
PMDB Field Nameev_user_pct
Data Typenumber
FiscalYearStartMonthThe month that marks the beginning of the fiscal year for the project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameFiscalYearStartMonth
PMDB Tableproject
PMDB Field Namefy_start_month_num
Data Typeinteger
ForecastFinishDateThe alternate end date to be optionally used by the scheduler. The user sets the alternate end date by dragging the project bar in the Gantt Chart while manually leveling the resource profile in a resource analysis layout.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameForecastFinishDate
PMDB Table
PMDB Field Name
Data Typedate
ForecastStartDateThe alternate start date to be optionally used by the scheduler. The user sets the alternate start date by dragging the project bar in the Gantt Chart around while manually leveling the resource profile in a resource analysis layout.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameForecastStartDate
PMDB Table
PMDB Field Name
Data Typedate
IndependentETCLaborUnitsThe user-entered ETC total labor.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameIndependentETCLaborUnits
PMDB Tableprojwbs
PMDB Field Nameindep_remain_work_qty
Data Typenumber
IndependentETCTotalCostThe user-entered ETC total cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameIndependentETCTotalCost
PMDB Tableprojwbs
PMDB Field Nameindep_remain_total_cost
Data Typenumber
lastbaselineupdatedateF_PROJECTS.lastbaselineupdatedate maps to STG_F_PROJECT.lastbaselineupdatedate
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
LastSummarizedDateThe date the project was last summarized.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameLastSummarizedDate
PMDB Tableproject
PMDB Field Namelast_tasksum_date
Data Typedate
LevelingPriorityThe priority for scheduling.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameLevelingPriority
PMDB Tableproject
PMDB Field Namepriority_num
Data Typeinteger
MustFinishByDateThe date by which all project activities must finish. If entered, it is used as the project late finish date by the project scheduler.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameMustFinishByDate
PMDB Tableproject
PMDB Field Nameplan_end_date
Data Typedate
OverallProjectScoreThe project score calculated based on all project code types assigned to this project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameOverallProjectScore
PMDB Table
PMDB Field Name
Data Typenumber
PlannedStartDateThe planned start date of the project. Used by the project scheduler.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NamePlannedStartDate
PMDB Tableproject
PMDB Field Nameplan_start_date
Data Typedate
ProjectForecastStartDateThe alternate start date to be optionally used by the scheduler. The user sets the alternate start date by dragging the project bar in the Gantt Chart around while manually leveling the resource profile in a resource analysis layout.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameProjectForecastStartDate
PMDB Tableproject
PMDB Field Namefcst_start_date
Data Typedate
ProposedBudgetThe Proposed Budget, which is the sum of the original budget plus the approved and pending budgets from the budget change log.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameProposedBudget
PMDB Table
PMDB Field Name
Data Typenumber
ScheduledFinishDateThe early finish date of the latest activity in the project, as computed by the project scheduler.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameScheduledFinishDate
PMDB Tableproject
PMDB Field Namescd_end_date
Data Typedate
StrategicPriorityThe project's priority. The range is from 1 to 10,000.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameStrategicPriority
PMDB Tableproject
PMDB Field Namestrgy_priority_num
Data Typeinteger
SummarizedDataDateThe data date of the project when it was last summarized-only updated by summarizer.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummarizedDataDate
PMDB Tableproject
PMDB Field Namesum_data_date
Data Typedate
StatusThe project status: 'Planned', 'Active', 'Inactive', 'What-If', or 'Requested'.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameStatus
PMDB Tableprojwbs
PMDB Field Namestatus_code
Data Typestring
SumAccountingVarByLaborUnitsthe Planned Value Labor Units minus the Actual Units. Negative value indicates that Actual Units have exceeded the Planned Value Labor Units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryAccountingVarianceByLaborUnits
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumAccountingVarianceByCostthe Planned Value minus the Actual Cost. A negative value indicates that the Actual Cost has exceeded the Planned Value.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryAccountingVarianceByCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumActivityCountthe number of activities that are currently in progress.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActivityCount
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumActThisPeriodMaterialCostThe actual this period material cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualThisPeriodMaterialCost
PMDB Tabletasksum
PMDB Field Nameact_this_per_mat_cost
Data Typenumber
SumActThisPeriodNonLaborCostThe actual this period nonlabor cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualThisPeriodNonLaborCost
PMDB Tabletasksum
PMDB Field Nameact_this_per_equip_cost
Data Typenumber
SumActThisPeriodNonLaborUnitsThe actual this period nonlabor units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualThisPeriodNonLaborUnits
PMDB Tabletasksum
PMDB Field Nameact_this_per_equip_qty
Data Typenumber
SumActualDurationThe actual duration.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualDuration
PMDB Tabletasksum
PMDB Field Nameact_drtn_hr_cnt
Data Typenumber
SumActualExpenseCostThe actual costs for all project expenses associated with the project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualExpenseCost
PMDB Tabletasksum
PMDB Field Nameact_expense_cost
Data Typenumber
SumActualFinishDateThe latest actual finish date of all activities in the project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualFinishDate
PMDB Tabletasksum
PMDB Field Nameact_end_date
Data Typedate
SumActualLaborCostThe actual cost for all labor resources assigned to the activity.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualLaborCost
PMDB Tabletasksum
PMDB Field Nameact_work_cost
Data Typenumber
SumActualLaborUnitsThe actual labor units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualLaborUnits
PMDB Tabletasksum
PMDB Field Nameact_work_qty
Data Typenumber
SumActualMaterialCostThe actual units for all material resources assigned to the activity.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualMaterialCost
PMDB Tabletasksum
PMDB Field Nameact_mat_cost
Data Typenumber
SumActualNonLaborCostThe actual units for all nonlabor resources assigned to the activity.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualNonLaborCost
PMDB Tabletasksum
PMDB Field Nameact_equip_cost
Data Typenumber
SumActualNonLaborUnitsThe actual nonlabor units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualNonLaborUnits
PMDB Tabletasksum
PMDB Field Nameact_equip_qty
Data Typenumber
SumActualStartDateThe earliest actual start date of all activities in the project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualStartDate
PMDB Tabletasksum
PMDB Field Nameact_start_date
Data Typedate
SumActualThisPeriodCostThe actual this period cost (will be labor or nonlabor).
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualThisPeriodCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumActualThisPeriodLaborCostThe actual this period labor cost
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualThisPeriodLaborCost
PMDB Tabletasksum
PMDB Field Nameact_this_per_work_cost
Data Typenumber
SumActualThisPeriodLaborUnitsThe actual this period labor units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualThisPeriodLaborUnits
PMDB Tabletasksum
PMDB Field Nameact_this_per_work_qty
Data Typenumber
sumactualtotalcostF_PROJECTS.sumactualtotalcost maps to STG_F_PROJECT.sumactualtotalcost
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
SumActualValueByCostthe actual total cost incurred on the activity as of the project data date, computed as Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualValueByCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumActualValueByLaborUnitsthe actual total labor units for the activity as of the project data date (i.e., actual total cost by labor units).
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryActualValueByLaborUnits
PMDB Tabletasksum
PMDB Field Nameact_work_qty
Data Typenumber
SumAtCompletionDurationThe duration at completion.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryAtCompletionDuration
PMDB Tabletasksum
PMDB Field Nametotal_drtn_hr_cnt
Data Typenumber
SumAtCompletionExpenseCostthe sum of the actual plus remaining cost for all project expenses associated with the cost account. Computed as Actual Expense Cost + Remaining Expense Cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryAtCompletionExpenseCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumAtCompletionLaborCostThe sum of the actual plus remaining costs for all labor resources assigned to the activity. Computed as actual labor cost + remaining labor cost. Same as the planned labor costs if the activity is not started and the actual labor costs once the activity is completed.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryAtCompletionLaborCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumAtCompletionLaborUnitsThe sum of the actual plus remaining units for all labor resources assigned to the activity. Computed as actual labor units + remaining labor units. Same as the planned labor units if the activity is not started and the actual labor units once the activity is completed.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryAtCompletionLaborUnits
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumAtCompletionMaterialCostThe material cost at completion. It is the sum of the actual plus remaining costs for all material resources assigned to the activity. Computed as actual material cost + remaining material cost. Same as the planned material costs if the activity is not started and the actual material costs once the activity is completed.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryAtCompletionMaterialCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumAtCompletionNonLaborCostThe nonlabor cost at completion. It is the sum of the actual plus remaining costs for all nonlabor resources assigned to the activity. Computed as actual nonlabor cost + remaining nonlabor cost. Same as the planned nonlabor costs if the activity is not started and the actual nonlabor costs once the activity is completed.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryAtCompletionNonLaborCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumAtCompletionNonLaborUnitsThe nonlabor units at completion. It is the sum of the actual plus remaining units for all nonlabor resources assigned to the activity. Computed as actual nonlabor units + remaining nonlabor units. Same as the planned nonlabor units if the activity is not started and the actual nonlabor units once the activity is completed.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryAtCompletionNonLaborUnits
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumAtCompletionTotalCostThe estimated cost at completion for the activity. Computed as the actual total cost plus the estimate-to-complete cost; EAC = ACWP + ETC. Note that the method for computing ETC depends on the earned-value technique selected for the activity's WBS.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryAtCompletionTotalCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumAtCompletionTotalCostVarthe Baseline Planned Total Cost - At Completion Total Cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryAtCompletionTotalCostVariance
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumBaselineCompActivityCountThe number of completed activities in the baseline.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineCompletedActivityCount
PMDB Tabletasksum
PMDB Field Namebase_complete_cnt
Data Typenumber
SumBaselineDurationthe planned duration for the activity in the primary baseline. Planned duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineDuration
PMDB Tabletasksum
PMDB Field Namebase_drtn_hr_cnt
Data Typenumber
SumBaselineExpenseCostthe planned cost for all project expenses associated with the activity in the primary baseline. Computed as the baseline actual expense cost plus the baseline remaining expense cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineExpenseCost
PMDB Tabletasksum
PMDB Field Namebase_expense_cost
Data Typenumber
SumBaselineFinishDateThe current latest finish date of all activities in the project for the current baseline.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineFinishDate
PMDB Tabletasksum
PMDB Field Namebase_end_date
Data Typedate
SumBaselineLaborCostthe planned cost for all labor resources assigned to the activity in the primary baseline. Computed from the baseline At Completion labor units. If no resources are assigned, computed as the activity Baseline Planned Labor Units * Project Default Price / Time.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineLaborCost
PMDB Tabletasksum
PMDB Field Namebase_work_cost
Data Typenumber
SumBaselineLaborUnitsthe planned units for all labor resources assigned to the activity in the primary baseline. Computed as the baseline actual labor units plus the baseline remaining labor units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineLaborUnits
PMDB Tabletasksum
PMDB Field Namebase_work_qty
Data Typenumber
SumBaselineMaterialCostthe planned cost for all material resources assigned to the activity in the primary baseline. Computed from the baseline At Completion nonlabor units. If no resources are assigned.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineMaterialCost
PMDB Tabletasksum
PMDB Field Namebase_mat_cost
Data Typenumber
SumBaselineNonLaborCostthe planned cost for all nonlabor resources assigned to the activity in the primary baseline. Computed from the baseline At Completion nonlabor units. If no resources are assigned, computed as the activity Baseline Planned Nonlabor Units * Project Default Price / Time.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineNonLaborCost
PMDB Tabletasksum
PMDB Field Namebase_equip_cost
Data Typenumber
SumBaselineNonLaborUnitsthe planned units for all nonlabor resources assigned to the activity in the primary baseline. Computed as the baseline actual nonlabor units plus the baseline remaining nonlabor units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineNonLaborUnits
PMDB Tabletasksum
PMDB Field Namebase_equip_qty
Data Typenumber
SumBaselineNotStartedActCntThe number of activities not started in the baseline.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineNotStartedActivityCount
PMDB Tabletasksum
PMDB Field Namebase_notstarted_cnt
Data Typenumber
SumBaselineStartDateThe current earliest start date of all activities in the Project for the current baseline.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineStartDate
PMDB Tabletasksum
PMDB Field Namebase_start_date
Data Typedate
SumBaselineTotalCostthe Planned Total Cost for the activity in the primary baseline, including labor resources, nonlabor resources, and project expenses. Baseline Planned Total Cost = Baseline Planned Labor Cost + Baseline Planned Nonlabor Cost + Baseline Planned Expense Cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineTotalCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumBLInProgressActivityCountThe number of in-progress activities in the baseline.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBaselineInProgressActivityCount
PMDB Tabletasksum
PMDB Field Namebase_active_cnt
Data Typenumber
SumBudgetAtCmpByLaborUnitsthe Baseline Labor Units
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBudgetAtCompletionByLaborUnits
PMDB Tabletasksum
PMDB Field Namebase_work_qty
Data Typenumber
SumBudgetAtCompletionByCostthe Planned Total Cost through activity completion. Computed as Planned Labor Cost + Planned Nonlabor Cost + Planned Expense Cost, same as the Planned Total Cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryBudgetAtCompletionByCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumCompletedActivityCountthe number of activities that have an Actual Finish in the Project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryCompletedActivityCount
PMDB Tabletasksum
PMDB Field Namecomplete_cnt
Data Typenumber
SumCostPercentCompleteThe percent complete of cost for all nonlabor resources assigned. Computed as Actual Nonlabor Cost / At Completion Nonlabor Cost * 100. Always in the range 0 to 100.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumCostPercentOfPlannedThe activity actual cost percent of planned. Computed as actual total cost / baseline total cost * 100, or equivalently as ACWP / BAC * 100. The value can exceed 100. The baseline total cost is the activity's at completion cost from the current baseline. This field is named SummaryCostPercentOfBudget in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryCostPercentOfPlanned
PMDB Table
PMDB Field Name
Data Typenumber
SumCostPerfIndexByCostthe Earned Value divided by the Actual Cost. A value less than 1 indicates that the Actual Cost has exceeded the Planned Value.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryCostPerformanceIndexByCost
PMDB Table
PMDB Field Name
Data Typenumber
SumCostPerfIndexByLaborUnitsthe Earned Value Labor Units / Actual Labor Units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryCostPerformanceIndexByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumCostVarianceByCostthe Earned Value minus the Actual Cost. A negative value indicates that the Actual Cost has exceeded the Planned Value.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryCostVarianceByCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumCostVarianceByLaborUnitsthe Earned Value Labor Cost minus Actual Value Labor Cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryCostVarianceByLaborUnits
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumCostVarianceIndexThe value that is calculated as the Cost Variance divided by Earned Value.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryCostVarianceIndex
PMDB Table
PMDB Field Name
Data Typenumber
SumCostVarianceIndexByCostthe Cost Variance divided by Earned Value.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryCostVarianceIndexByCost
PMDB Table
PMDB Field Name
Data Typenumber
SumCostVarIndexByLaborUnitsthe Cost Variance Labor Units divided by Earned Value Labor Units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryCostVarianceIndexByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumDurationPercentCompleteThe activity actual duration percent of planned. Computed as actual duration / baseline planned duration * 100. The value can exceed 100. The baseline planned duration is the activity's at complete duration from the primary baseline.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryDurationPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumDurationPercentOfPlannedThe summary actual duration percent of planned of all activities under this project. Computed as actual duration / baseline duration * 100. The value can exceed 100. The Baseline duration is the activity's at complete duration from the current baseline.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryDurationPercentOfPlanned
PMDB Table
PMDB Field Name
Data Typenumber
SumDurationVarianceThe duration between the activity's baseline duration and the at complete duration. Computed as baseline planned duration - at completion duration.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryDurationVariance
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumEACByCostthe Actual Cost plus the Estimate to Complete Cost. The method for computing Estimate to Complete depends on the Earned Value technique selected for the activity's WBS.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryEstimateAtCompletionByCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumEACByLaborUnitsthe Actual Labor Units + Estimate To Complete Labor Units. (Estimate To Complete Labor Units is calculated based off of the Earned Value setting on the Project.)
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryEstimateAtCompletionByLaborUnits
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumEACHighPctByLaborUnitsthe high forecast of Estimate At Completion (EAC) by labor units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryEstimateAtCompletionHighPercentByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumEACLowPctByLaborUnitsthe low forecast of Estimate At Completion (EAC) by labor units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryEstimateAtCompletionLowPercentByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumEarnedValueByCostthe Budget at Completion * Performance % Complete. The method for computing the Performance Percent Complete depends on the Earned Value technique selected for the activity's WBS. Budget at Completion is computed from the primary baseline.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryEarnedValueByCost
PMDB Tabletasksum
PMDB Field Namebcwp
Data Typenumber
SumEarnedValueByLaborUnitsthe portion of the baseline labor units that is actually completed as of the project data date. Computed as Baseline Labor Units * Performance % Complete. The planned labor units performed is essentially the labor units Earned Value for the activity. The method for computing the Performance % Complete depends on the Earned Value technique selected for the activity's WBS. The Baseline Labor Units is taken from the current baseline.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryEarnedValueByLaborUnits
PMDB Tabletasksum
PMDB Field Nameperfm_work_qty
Data Typenumber
SumETCByCostthe Remaining Total Cost for the activity or the Performance Factor * (Budget at Completion - Earned Value), depending on the Earned Value technique selected for the activity's WBS (calculated from the primary baseline).
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryEstimateToCompleteByCost
PMDB Tabletasksum
PMDB Field Nameetc
Data Typenumber
SumETCByLaborUnitsthe estimated quantity to complete the activity. Computed as either the remaining total units for the activity, or as Performance Factor * (Baseline Planned Labor Units - Planned Quantity of Work Performed), depending on the Earned Value Technique selected for the activity's WBS.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryEstimateToCompleteByLaborUnits
PMDB Tabletasksum
PMDB Field Nameetc_work_qty
Data Typenumber
SumExpenseCostPctCompleteThe percent complete of cost for all expenses associated with the project. It is computed as Actual Expense Cost / At Complete Expense Cost * 100, and it is always in the range of 0 to 100.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryExpenseCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumExpenseCostVariancethe Baseline Planned Expense Cost - At Completion Expense Cost (At Completion Expense Cost = Actual Expense Cost + Remaining Expense Cost).
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryExpenseCostVariance
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumFinishDateVarianceThe duration between the finish date in the current project and the baseline finish date. Calculated as finish date - baseline finish date.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryFinishDateVariance
PMDB Table
PMDB Field Name
Data Typenumber
SumInProgressActivityCountthe number of activities that are currently in progress.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryInProgressActivityCount
PMDB Tabletasksum
PMDB Field Nameactive_cnt
Data Typenumber
SumLaborCostPercentCompleteThe percent complete of cost for all labor resources assigned to the project. It is computed as Actual Labor Cost / At Complete Labor Cost * 100, and it is always in the range of 0 to 100.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryLaborCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumLaborCostVariancethe Baseline Planned Labor Cost - At Completion Labor Cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryLaborCostVariance
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumLaborUnitsPercentCompleteThe percent complete of units for all labor resources for the Project. Computed as actual labor units / at complete labor units * 100. Always in the range 0 to 100.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryLaborUnitsPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumLaborUnitsVarianceThe difference between baseline labor units and at completion labor units. Calculated as baseline labor units - at completion labor units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryLaborUnitsVariance
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumMaterialCostPctCompleteThe percent complete of cost for all material resources assigned to the project. It is computed as Actual Material Cost / At Complete Material Cost * 100, and it is always in the range of 0 to 100.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryMaterialCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumMaterialCostVarianceThe variance that is calculated as Baseline Material Cost - At Completion Material Cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryMaterialCostVariance
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumNonLaborCostPctCompleteThe percent complete of cost for all non-labor resources assigned to the project. It is computed as Actual Nonlabor Cost / At Complete Nonlabor Cost * 100, and it is always in the range of 0 to 100.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryNonLaborCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumNonLaborCostVariancethe Baseline Planned Nonlabor Cost - At Completion Nonlabor Cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryNonLaborCostVariance
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumNonLaborUnitsPctCompleteThe percent complete of units for all nonlabor resources for the Project. Computed as Actual Nonlabor Cost / At Completion Nonlabor Cost * 100. Always in the range 0 to 100.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryNonLaborUnitsPercentComplete
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumNonLaborUnitsVarianceThe difference between baseline nonlabor units and at completion non labor units. Calculated as baseline nonlabor units - at completion nonlabor units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryNonLaborUnitsVariance
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumNotStartedActivityCountthe number of activities that are currently not started.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryNotStartedActivityCount
PMDB Tabletasksum
PMDB Field Namenotstarted_cnt
Data Typenumber
SumPerfPctCmpByLaborUnitsthe percent complete of performance for all labor resources. Computed as earned value labor units / baseline labor units * 100. Always in the range 0 to 100.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryPerformancePercentCompleteByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumPlannedValueByCostthe Budget at Completion * Schedule % Complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. Budget at Completion is computed from the primary baseline
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryPlannedValueByCost
PMDB Tabletasksum
PMDB Field Namebcws
Data Typenumber
SumPlannedValueByLaborUnitsthe portion of the baseline labor units that is scheduled to be completed as of the project data date. Computed as Baseline Labor Units * Schedule % Complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. The Baseline Labor Units is taken from the current baseline.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryPlannedValueByLaborUnits
PMDB Tabletasksum
PMDB Field Namesched_work_qty
Data Typenumber
SumProgressFinishDatethe date the activity is expected to be finished according to the progress made on the activity's work products. The expected finish date is entered manually by people familiar with progress of the activity's work products.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryProgressFinishDate
PMDB Table
PMDB Field Name
Data Typedate
SumRemainingDurationThe total working time from the Project remaining start date to the remaining finish date.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryRemainingDuration
PMDB Tabletasksum
PMDB Field Nameremain_drtn_hr_cnt
Data Typenumber
SumRemainingExpenseCostThe remaining costs for all project expenses associated with the activities in the Project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryRemainingExpenseCost
PMDB Tabletasksum
PMDB Field Nameremain_expense_cost
Data Typenumber
SumRemainingFinishDateThe date the resource is scheduled to finish the remaining work for the activity. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining finish date is the same as the planned finish date.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryRemainingFinishDate
PMDB Tabletasksum
PMDB Field Namereend_date
Data Typedate
SumRemainingLaborCostThe remaining costs for all labor resources assigned to the activities. The remaining cost reflects the cost remaining for the Project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryRemainingLaborCost
PMDB Tabletasksum
PMDB Field Nameremain_work_cost
Data Typenumber
SumRemainingLaborUnitsThe remaining units for all labor resources assigned to the activities. The remaining units reflects the work remaining to be done for the Project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryRemainingLaborUnits
PMDB Tabletasksum
PMDB Field Nameremain_work_qty
Data Typenumber
SumRemainingMaterialCostThe remaining material costs for all project expenses associated with the activities in the Project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryRemainingMaterialCost
PMDB Tabletasksum
PMDB Field Nameremain_mat_cost
Data Typenumber
SumRemainingNonLaborCostThe remaining nonlabor costs for all project expenses associated with the activities in the Project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryRemainingNonLaborCost
PMDB Tabletasksum
PMDB Field Nameremain_equip_cost
Data Typenumber
SumRemainingNonLaborUnitsThe remaining units for all nonlabor resources assigned to the activities. The remaining units reflects the work remaining to be done for the Project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryRemainingNonLaborUnits
PMDB Tabletasksum
PMDB Field Nameremain_equip_qty
Data Typenumber
SumRemainingStartDateThe earliest remaining start of all activities assigned to the Project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryRemainingStartDate
PMDB Tabletasksum
PMDB Field Namerestart_date
Data Typedate
SumRemainingTotalCostThe sum of all remaining total costs in the Project.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryRemainingTotalCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumSchdPctCmpByLaborUnitsthe percent complete of units for all labor resources. Computed as Actual Labor Units / At Completion Labor Units * 100. Always in the range 0 to 100.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummarySchedulePercentCompleteByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumSchdPerfIndexByLaborUnitsthe Earned Value Labor Units divided by Planned Value Labor Units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummarySchedulePerformanceIndexByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumSchdVarianceByLaborUnitsthe Earned Value Labor Units minus the Planned Value Labor Units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryScheduleVarianceByLaborUnits
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumSchdVarianceIndexByCostthe Schedule Variance divided by the Planned Value.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryScheduleVarianceIndexByCost
PMDB Table
PMDB Field Name
Data Typenumber
SumSchdVarIndexByLaborUnitsthe Schedule Variance Labor Units divided by the Planned Value Labor Units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryScheduleVarianceIndexByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumSchedulePctCompleteByCostthe percent complete of performance for all labor resources, nonlabor resources, and expenses. Computed as Earned Value / Budget At Completion * 100. Always in the range 0 to 100.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummarySchedulePercentCompleteByCost
PMDB Table
PMDB Field Name
Data Typenumber
SumSchedulePercentCompleteThe measure that indicates how much of the Project baseline duration has been completed so far. Computed based on where the current data date falls between the activity's baseline start and finish dates. If the data date is earlier than the baseline start, the schedule % complete is 0. If the data date is later than the baseline finish, the schedule % complete is 100. The schedule % complete indicates how much of the Project duration should be currently completed, relative to the selected baseline.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummarySchedulePercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumSchedulePerfIndexByCostthe Earned Value divided by the Planned Value. A value less than 1 indicates that less work was actually performed than was scheduled.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummarySchedulePerformanceIndexByCost
PMDB Table
PMDB Field Name
Data Typenumber
SumScheduleVarianceByCostthe Earned Value divided by the Planned Value. A negative value indicates that less work was actually performed than was scheduled.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryScheduleVarianceByCost
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumScheduleVarianceIndexThe value that is calculated as the Schedule Variance Labor Units divided by Planned Value Labor Units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryScheduleVarianceIndex
PMDB Table
PMDB Field Name
Data Typenumber
SumStartDateVarianceThe duration between the start date in the current project and the baseline start date. Calculated as start date - baseline start date.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryStartDateVariance
PMDB Table
PMDB Field Name
Data Typenumber
SumToCompletePerfIndexByCostthe (Budget at Completion - Earned Value) divided by (Estimate at Completion - Actual Cost).
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryToCompletePerformanceIndexByCost
PMDB Table
PMDB Field Name
Data Typenumber
SumTotalCostVarianceThe value that is calculated as baseline total cost - total cost.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryTotalCostVariance
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
SumTotalFloatThe amount of time the Project can be delayed before delaying the project finish date. Total float can be computed as late start - early start or as late finish - early finish; this option can be set when running the project scheduler.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryTotalFloat
PMDB Tabletasksum
PMDB Field Nametotal_float_hr_cnt
Data Typenumber
SumUnitsPercentCompleteThe percent complete of units for the resource assignments in the Project. Computed as Actual Units / At Complete Units * 100. Always in the range 0 to 100.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryUnitsPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumVarAtCmpByLaborUnitsthe Baseline Planned Total Labor Units minus Estimate at Completion Labor Units.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameSummaryVarianceAtCompletionByLaborUnits
PMDB TablePROJECT
PMDB Field Name
Data Typenumber
TotalBenefitPlanThe sum of the monthly benefit plan.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameTotalBenefitPlan
PMDB Table
PMDB Field Name
Data Typenumber
TotalBenefitPlanTallyThe sum of the monthly benefit plan tally.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameTotalBenefitPlanTally
PMDB Table
PMDB Field Name
Data Typenumber
TotalFundingThe total amount of funding contributed to the project by your funding sources.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameTotalFunding
PMDB Table
PMDB Field Name
Data Typenumber
TotalSpendingPlanThe sum of the monthly spending plan.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameTotalSpendingPlan
PMDB Table
PMDB Field Name
Data Typenumber
TotalSpendingPlanTallyThe sum of the monthly spending plan tally.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameTotalSpendingPlanTally
PMDB Table
PMDB Field Name
Data Typenumber
UnallocatedBudgetThe total current budget minus the distributed current budget.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameUnallocatedBudget
PMDB Table
PMDB Field Name
Data Typenumber
UndistributedCurrentVarianceThe total spending plan minus the total spending plan tally.
STAR TableF_PROJECTS
API Business ObjectProject
API Field NameUndistributedCurrentVariance
PMDB Table
PMDB Field Name
Data Typenumber
snapshotidID of star snapshot
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
etlprocessF_PROJECTS.etlprocess maps to STG_F_PROJECT.etlprocess
STAR TableF_PROJECTS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate