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
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyD_COST_ACCOUNTbigintD_COST_ACCOUNT.skey maps to DIM_COST_ACCOUNT.skey
objectidD_COST_ACCOUNTintegerD_COST_ACCOUNT.objectid maps to DIM_COST_ACCOUNT.objectid
nameD_COST_ACCOUNTstringD_COST_ACCOUNT.name maps to DIM_COST_ACCOUNT.name
idD_COST_ACCOUNTstringD_COST_ACCOUNT.id maps to DIM_COST_ACCOUNT.id
parentobjectidD_COST_ACCOUNTintegerD_COST_ACCOUNT.parentobjectid maps to DIM_COST_ACCOUNT.parentobjectid
currentprocesscycledateD_COST_ACCOUNTdateD_COST_ACCOUNT.currentprocesscycledate maps to DIM_COST_ACCOUNT.currentprocesscycledate
snapshotidD_COST_ACCOUNTintegerID of star snapshot
etlprocessD_COST_ACCOUNTdateD_COST_ACCOUNT.etlprocess maps to DIM_COST_ACCOUNT.etlprocess
D_COST_ACCOUNT_HIERARCHYTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyD_COST_ACCOUNT_HIERARCHYbigintD_COST_ACCOUNT_HIERARCHY.skey maps to DIM_COST_ACCOUNT_HIERARCHY.skey
parentobjectidD_COST_ACCOUNT_HIERARCHYintegerD_COST_ACCOUNT_HIERARCHY.parentobjectid maps to DIM_COST_ACCOUNT_HIERARCHY.parentobjectid
parentsequencenumberD_COST_ACCOUNT_HIERARCHYintegerD_COST_ACCOUNT_HIERARCHY.parentsequencenumber maps to DIM_COST_ACCOUNT_HIERARCHY.parentsequencenumber
parentnameD_COST_ACCOUNT_HIERARCHYstringD_COST_ACCOUNT_HIERARCHY.parentname maps to DIM_COST_ACCOUNT_HIERARCHY.parentname
parentidD_COST_ACCOUNT_HIERARCHYstringD_COST_ACCOUNT_HIERARCHY.parentid maps to DIM_COST_ACCOUNT_HIERARCHY.parentid
parentdescriptionD_COST_ACCOUNT_HIERARCHYclobD_COST_ACCOUNT_HIERARCHY.parentdescription maps to DIM_COST_ACCOUNT_HIERARCHY.parentdescription
childobjectidD_COST_ACCOUNT_HIERARCHYintegerD_COST_ACCOUNT_HIERARCHY.childobjectid maps to DIM_COST_ACCOUNT_HIERARCHY.childobjectid
childsequencenumberD_COST_ACCOUNT_HIERARCHYintegerD_COST_ACCOUNT_HIERARCHY.childsequencenumber maps to DIM_COST_ACCOUNT_HIERARCHY.childsequencenumber
childnameD_COST_ACCOUNT_HIERARCHYstringD_COST_ACCOUNT_HIERARCHY.childname maps to DIM_COST_ACCOUNT_HIERARCHY.childname
childidD_COST_ACCOUNT_HIERARCHYstringD_COST_ACCOUNT_HIERARCHY.childid maps to DIM_COST_ACCOUNT_HIERARCHY.childid
childdescriptionD_COST_ACCOUNT_HIERARCHYclobD_COST_ACCOUNT_HIERARCHY.childdescription maps to DIM_COST_ACCOUNT_HIERARCHY.childdescription
parentlevelsbelowrootD_COST_ACCOUNT_HIERARCHYintegerD_COST_ACCOUNT_HIERARCHY.parentlevelsbelowroot maps to DIM_COST_ACCOUNT_HIERARCHY.parentlevelsbelowroot
childlevelsbelowrootD_COST_ACCOUNT_HIERARCHYintegerD_COST_ACCOUNT_HIERARCHY.childlevelsbelowroot maps to DIM_COST_ACCOUNT_HIERARCHY.childlevelsbelowroot
levelsbetweenD_COST_ACCOUNT_HIERARCHYintegerD_COST_ACCOUNT_HIERARCHY.levelsbetween maps to DIM_COST_ACCOUNT_HIERARCHY.levelsbetween
childhaschildrenD_COST_ACCOUNT_HIERARCHYstringD_COST_ACCOUNT_HIERARCHY.childhaschildren maps to DIM_COST_ACCOUNT_HIERARCHY.childhaschildren
fullpathnameD_COST_ACCOUNT_HIERARCHYstringD_COST_ACCOUNT_HIERARCHY.fullpathname maps to DIM_COST_ACCOUNT_HIERARCHY.fullpathname
currentprocesscycledateD_COST_ACCOUNT_HIERARCHYdateD_COST_ACCOUNT_HIERARCHY.currentprocesscycledate maps to DIM_COST_ACCOUNT_HIERARCHY.currentprocesscycledate
snapshotidD_COST_ACCOUNT_HIERARCHYintegerID of star snapshot
etlprocessD_COST_ACCOUNT_HIERARCHYdateD_COST_ACCOUNT_HIERARCHY.etlprocess maps to DIM_COST_ACCOUNT_HIERARCHY.etlprocess
D_DATETop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyD_DATEbigintD_DATE.skey maps to PSTG_DATE.skey
datenameD_DATEintegerD_DATE.datename maps to PSTG_DATE.datename
daydateD_DATEdateD_DATE.daydate maps to PSTG_DATE.daydate
daynameD_DATEstringD_DATE.dayname maps to PSTG_DATE.dayname
dayofmonthD_DATEintegerD_DATE.dayofmonth maps to PSTG_DATE.dayofmonth
dayofyearD_DATEintegerD_DATE.dayofyear maps to PSTG_DATE.dayofyear
ordinaldayofmonthD_DATEstringD_DATE.ordinaldayofmonth maps to PSTG_DATE.ordinaldayofmonth
ordinaldayofyearD_DATEstringD_DATE.ordinaldayofyear maps to PSTG_DATE.ordinaldayofyear
weekbegindateD_DATEdateD_DATE.weekbegindate maps to PSTG_DATE.weekbegindate
dayofweekD_DATEintegerD_DATE.dayofweek maps to PSTG_DATE.dayofweek
weeknumberD_DATEintegerD_DATE.weeknumber maps to PSTG_DATE.weeknumber
monthnumberD_DATEintegerD_DATE.monthnumber maps to PSTG_DATE.monthnumber
monthnameD_DATEstringD_DATE.monthname maps to PSTG_DATE.monthname
monthshortnameD_DATEcharacterD_DATE.monthshortname maps to PSTG_DATE.monthshortname
monthenddateD_DATEdateD_DATE.monthenddate maps to PSTG_DATE.monthenddate
daysinmonthD_DATEintegerD_DATE.daysinmonth maps to PSTG_DATE.daysinmonth
yearmonthD_DATEintegerD_DATE.yearmonth maps to PSTG_DATE.yearmonth
quarternumberD_DATEintegerD_DATE.quarternumber maps to PSTG_DATE.quarternumber
quarternameD_DATEcharacterD_DATE.quartername maps to PSTG_DATE.quartername
yearD_DATEintegerD_DATE.year maps to PSTG_DATE.year
etlprocessD_DATEdateD_DATE.etlprocess maps to PSTG_DATE.etlprocess
etluserD_DATEstringD_DATE.etluser maps to PSTG_DATE.etluser
D_EPSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyD_EPSbigintD_EPS.skey maps to DIM_EPS.skey
objectidD_EPSintegerD_EPS.objectid maps to DIM_EPS.objectid
nameD_EPSstringD_EPS.name maps to DIM_EPS.name
parentobjectidD_EPSintegerD_EPS.parentobjectid maps to DIM_EPS.parentobjectid
currentprocesscycledateD_EPSdateD_EPS.currentprocesscycledate maps to DIM_EPS.currentprocesscycledate
snapshotidD_EPSintegerID of star snapshot
etlprocessD_EPSdateD_EPS.etlprocess maps to DIM_EPS.etlprocess
D_EPS_HIERARCHYTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyD_EPS_HIERARCHYbigintD_EPS_HIERARCHY.skey maps to DIM_EPS_HIERARCHY.skey
parentobjectidD_EPS_HIERARCHYintegerD_EPS_HIERARCHY.parentobjectid maps to DIM_EPS_HIERARCHY.parentobjectid
parentprojectidD_EPS_HIERARCHYintegerD_EPS_HIERARCHY.parentprojectid maps to DIM_EPS_HIERARCHY.parentprojectid
parentsequencenumberD_EPS_HIERARCHYintegerD_EPS_HIERARCHY.parentsequencenumber maps to DIM_EPS_HIERARCHY.parentsequencenumber
parentnameD_EPS_HIERARCHYstringD_EPS_HIERARCHY.parentname maps to DIM_EPS_HIERARCHY.parentname
parentidD_EPS_HIERARCHYstringD_EPS_HIERARCHY.parentid maps to DIM_EPS_HIERARCHY.parentid
parentoriginalbudgetD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.parentoriginalbudget maps to DIM_EPS_HIERARCHY.parentoriginalbudget
parentindependentetctotalcostD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.parentindependentetctotalcost maps to DIM_EPS_HIERARCHY.parentindependentetctotalcost
parentindependentetclaborunitsD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.parentindependentetclaborunits maps to DIM_EPS_HIERARCHY.parentindependentetclaborunits
parentcurrentbudgetD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.parentcurrentbudget maps to DIM_EPS_HIERARCHY.parentcurrentbudget
parentcurrentvarianceD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.parentcurrentvariance maps to DIM_EPS_HIERARCHY.parentcurrentvariance
parentdistributedcurrentbudgetD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.parentdistributedcurrentbudget maps to DIM_EPS_HIERARCHY.parentdistributedcurrentbudget
parentproposedbudgetD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.parentproposedbudget maps to DIM_EPS_HIERARCHY.parentproposedbudget
parentstartdateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.parentstartdate maps to DIM_EPS_HIERARCHY.parentstartdate
parentfinishdateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.parentfinishdate maps to DIM_EPS_HIERARCHY.parentfinishdate
parentanticipatedstartdateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.parentanticipatedstartdate maps to DIM_EPS_HIERARCHY.parentanticipatedstartdate
parentanticipatedfinishdateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.parentanticipatedfinishdate maps to DIM_EPS_HIERARCHY.parentanticipatedfinishdate
parentlastsummarizeddateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.parentlastsummarizeddate maps to DIM_EPS_HIERARCHY.parentlastsummarizeddate
parentplannedstartdateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.parentplannedstartdate maps to DIM_EPS_HIERARCHY.parentplannedstartdate
parentobsobjectidD_EPS_HIERARCHYintegerD_EPS_HIERARCHY.parentobsobjectid maps to DIM_EPS_HIERARCHY.parentobsobjectid
parentobsnameD_EPS_HIERARCHYstringD_EPS_HIERARCHY.parentobsname maps to DIM_EPS_HIERARCHY.parentobsname
childobjectidD_EPS_HIERARCHYintegerD_EPS_HIERARCHY.childobjectid maps to DIM_EPS_HIERARCHY.childobjectid
childprojectidD_EPS_HIERARCHYintegerD_EPS_HIERARCHY.childprojectid maps to DIM_EPS_HIERARCHY.childprojectid
childsequencenumberD_EPS_HIERARCHYintegerD_EPS_HIERARCHY.childsequencenumber maps to DIM_EPS_HIERARCHY.childsequencenumber
childnameD_EPS_HIERARCHYstringD_EPS_HIERARCHY.childname maps to DIM_EPS_HIERARCHY.childname
childidD_EPS_HIERARCHYstringD_EPS_HIERARCHY.childid maps to DIM_EPS_HIERARCHY.childid
childoriginalbudgetD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.childoriginalbudget maps to DIM_EPS_HIERARCHY.childoriginalbudget
childindependentetctotalcostD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.childindependentetctotalcost maps to DIM_EPS_HIERARCHY.childindependentetctotalcost
childindependentetclaborunitsD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.childindependentetclaborunits maps to DIM_EPS_HIERARCHY.childindependentetclaborunits
childcurrentbudgetD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.childcurrentbudget maps to DIM_EPS_HIERARCHY.childcurrentbudget
childcurrentvarianceD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.childcurrentvariance maps to DIM_EPS_HIERARCHY.childcurrentvariance
childdistributedcurrentbudgetD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.childdistributedcurrentbudget maps to DIM_EPS_HIERARCHY.childdistributedcurrentbudget
childproposedbudgetD_EPS_HIERARCHYdoubleD_EPS_HIERARCHY.childproposedbudget maps to DIM_EPS_HIERARCHY.childproposedbudget
childstartdateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.childstartdate maps to DIM_EPS_HIERARCHY.childstartdate
childfinishdateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.childfinishdate maps to DIM_EPS_HIERARCHY.childfinishdate
childanticipatedstartdateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.childanticipatedstartdate maps to DIM_EPS_HIERARCHY.childanticipatedstartdate
childanticipatedfinishdateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.childanticipatedfinishdate maps to DIM_EPS_HIERARCHY.childanticipatedfinishdate
childlastsummarizeddateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.childlastsummarizeddate maps to DIM_EPS_HIERARCHY.childlastsummarizeddate
childplannedstartdateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.childplannedstartdate maps to DIM_EPS_HIERARCHY.childplannedstartdate
childobsobjectidD_EPS_HIERARCHYintegerD_EPS_HIERARCHY.childobsobjectid maps to DIM_EPS_HIERARCHY.childobsobjectid
childobsnameD_EPS_HIERARCHYstringD_EPS_HIERARCHY.childobsname maps to DIM_EPS_HIERARCHY.childobsname
parentlevelsbelowrootD_EPS_HIERARCHYintegerD_EPS_HIERARCHY.parentlevelsbelowroot maps to DIM_EPS_HIERARCHY.parentlevelsbelowroot
childlevelsbelowrootD_EPS_HIERARCHYintegerD_EPS_HIERARCHY.childlevelsbelowroot maps to DIM_EPS_HIERARCHY.childlevelsbelowroot
levelsbetweenD_EPS_HIERARCHYintegerD_EPS_HIERARCHY.levelsbetween maps to DIM_EPS_HIERARCHY.levelsbetween
childhaschildrenD_EPS_HIERARCHYstringD_EPS_HIERARCHY.childhaschildren maps to DIM_EPS_HIERARCHY.childhaschildren
fullpathnameD_EPS_HIERARCHYstringD_EPS_HIERARCHY.fullpathname maps to DIM_EPS_HIERARCHY.fullpathname
currentprocesscycledateD_EPS_HIERARCHYdateD_EPS_HIERARCHY.currentprocesscycledate maps to DIM_EPS_HIERARCHY.currentprocesscycledate
snapshotidD_EPS_HIERARCHYintegerID of star snapshot
etlprocessD_EPS_HIERARCHYdateD_EPS_HIERARCHY.etlprocess maps to DIM_EPS_HIERARCHY.etlprocess
D_FINANCIAL_PERIODTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyD_FINANCIAL_PERIODbigintD_FINANCIAL_PERIOD.skey maps to DIM_FINANCIAL_PERIOD.skey
objectidD_FINANCIAL_PERIODintegerD_FINANCIAL_PERIOD.objectid maps to DIM_FINANCIAL_PERIOD.objectid
nameD_FINANCIAL_PERIODstringD_FINANCIAL_PERIOD.name maps to DIM_FINANCIAL_PERIOD.name
startdateD_FINANCIAL_PERIODdateD_FINANCIAL_PERIOD.startdate maps to DIM_FINANCIAL_PERIOD.startdate
enddateD_FINANCIAL_PERIODdateD_FINANCIAL_PERIOD.enddate maps to DIM_FINANCIAL_PERIOD.enddate
currentprocesscycledateD_FINANCIAL_PERIODdateD_FINANCIAL_PERIOD.currentprocesscycledate maps to DIM_FINANCIAL_PERIOD.currentprocesscycledate
snapshotidD_FINANCIAL_PERIODintegerID of star snapshot
etlprocessD_FINANCIAL_PERIODdateD_FINANCIAL_PERIOD.etlprocess maps to DIM_FINANCIAL_PERIOD.etlprocess
D_OBSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyD_OBSbigintD_OBS.skey maps to DIM_OBS.skey
objectidD_OBSintegerD_OBS.objectid maps to DIM_OBS.objectid
nameD_OBSstringD_OBS.name maps to DIM_OBS.name
parentobjectidD_OBSintegerD_OBS.parentobjectid maps to DIM_OBS.parentobjectid
currentprocesscycledateD_OBSdateD_OBS.currentprocesscycledate maps to DIM_OBS.currentprocesscycledate
snapshotidD_OBSintegerID of star snapshot
etlprocessD_OBSdateD_OBS.etlprocess maps to DIM_OBS.etlprocess
D_PROJECTTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyD_PROJECTbigintD_PROJECT.skey maps to DIM_PROJECT.skey
objectidD_PROJECTintegerD_PROJECT.objectid maps to DIM_PROJECT.objectid
idD_PROJECTstringD_PROJECT.id maps to DIM_PROJECT.id
currentprocesscycledateD_PROJECTdateD_PROJECT.currentprocesscycledate maps to DIM_PROJECT.currentprocesscycledate
snapshotidD_PROJECTintegerID of star snapshot
etlprocessD_PROJECTdateD_PROJECT.etlprocess maps to DIM_PROJECT.etlprocess
D_PROJECT_CODETop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyD_PROJECT_CODEbigintD_PROJECT_CODE.skey maps to DIM_PROJECT_CODE.skey
objectidD_PROJECT_CODEintegerD_PROJECT_CODE.objectid maps to DIM_PROJECT_CODE.objectid
codevalueD_PROJECT_CODEstringD_PROJECT_CODE.codevalue maps to DIM_PROJECT_CODE.codevalue
descriptionD_PROJECT_CODEstringD_PROJECT_CODE.description maps to DIM_PROJECT_CODE.description
codetypenameD_PROJECT_CODEstringD_PROJECT_CODE.codetypename maps to DIM_PROJECT_CODE.codetypename
codetypeobjectidD_PROJECT_CODEintegerD_PROJECT_CODE.codetypeobjectid maps to DIM_PROJECT_CODE.codetypeobjectid
sequencenumberD_PROJECT_CODEintegerD_PROJECT_CODE.sequencenumber maps to DIM_PROJECT_CODE.sequencenumber
parentobjectidD_PROJECT_CODEintegerD_PROJECT_CODE.parentobjectid maps to DIM_PROJECT_CODE.parentobjectid
weightD_PROJECT_CODEdoubleD_PROJECT_CODE.weight maps to DIM_PROJECT_CODE.weight
currentprocesscycledateD_PROJECT_CODEdateD_PROJECT_CODE.currentprocesscycledate maps to DIM_PROJECT_CODE.currentprocesscycledate
snapshotidD_PROJECT_CODEintegerID of star snapshot
etlprocessD_PROJECT_CODEdateD_PROJECT_CODE.etlprocess maps to DIM_PROJECT_CODE.etlprocess
D_PROJECT_CODE_ASSIGNMENTTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyD_PROJECT_CODE_ASSIGNMENTbigintD_PROJECT_CODE_ASSIGNMENT.skey maps to DIM_PROJECT_CODE_ASSIGNMENT.skey
projectskeyD_PROJECT_CODE_ASSIGNMENTintegerD_PROJECT_CODE_ASSIGNMENT.projectskey maps to DIM_PROJECT_CODE_ASSIGNMENT.projectskey
projectobjectidD_PROJECT_CODE_ASSIGNMENTintegerD_PROJECT_CODE_ASSIGNMENT.projectobjectid maps to DIM_PROJECT_CODE_ASSIGNMENT.projectobjectid
projectcodetypeobjectidD_PROJECT_CODE_ASSIGNMENTintegerD_PROJECT_CODE_ASSIGNMENT.projectcodetypeobjectid maps to DIM_PROJECT_CODE_ASSIGNMENT.projectcodetypeobjectid
projectcodeskeyD_PROJECT_CODE_ASSIGNMENTintegerD_PROJECT_CODE_ASSIGNMENT.projectcodeskey maps to DIM_PROJECT_CODE_ASSIGNMENT.projectcodeskey
projectcodeobjectidD_PROJECT_CODE_ASSIGNMENTintegerD_PROJECT_CODE_ASSIGNMENT.projectcodeobjectid maps to DIM_PROJECT_CODE_ASSIGNMENT.projectcodeobjectid
isbaselineD_PROJECT_CODE_ASSIGNMENTcharacterD_PROJECT_CODE_ASSIGNMENT.isbaseline maps to DIM_PROJECT_CODE_ASSIGNMENT.isbaseline
projectcodedescriptionD_PROJECT_CODE_ASSIGNMENTstringD_PROJECT_CODE_ASSIGNMENT.projectcodedescription maps to DIM_PROJECT_CODE_ASSIGNMENT.projectcodedescription
projectcodetypenameD_PROJECT_CODE_ASSIGNMENTstringD_PROJECT_CODE_ASSIGNMENT.projectcodetypename maps to DIM_PROJECT_CODE_ASSIGNMENT.projectcodetypename
projectcodevalueD_PROJECT_CODE_ASSIGNMENTstringD_PROJECT_CODE_ASSIGNMENT.projectcodevalue maps to DIM_PROJECT_CODE_ASSIGNMENT.projectcodevalue
projectnameD_PROJECT_CODE_ASSIGNMENTstringD_PROJECT_CODE_ASSIGNMENT.projectname maps to DIM_PROJECT_CODE_ASSIGNMENT.projectname
currentprocesscycledateD_PROJECT_CODE_ASSIGNMENTdateD_PROJECT_CODE_ASSIGNMENT.currentprocesscycledate maps to DIM_PROJECT_CODE_ASSIGNMENT.currentprocesscycledate
snapshotidD_PROJECT_CODE_ASSIGNMENTintegerID of star snapshot
etlprocessD_PROJECT_CODE_ASSIGNMENTdateD_PROJECT_CODE_ASSIGNMENT.etlprocess maps to DIM_PROJECT_CODE_ASSIGNMENT.etlprocess
D_PROJECT_CODE_HIERARCHYTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyD_PROJECT_CODE_HIERARCHYbigintD_PROJECT_CODE_HIERARCHY.skey maps to DIM_PROJECT_CODE_HIERARCHY.skey
codetypeobjectidD_PROJECT_CODE_HIERARCHYintegerD_PROJECT_CODE_HIERARCHY.codetypeobjectid maps to DIM_PROJECT_CODE_HIERARCHY.codetypeobjectid
codetypenameD_PROJECT_CODE_HIERARCHYstringD_PROJECT_CODE_HIERARCHY.codetypename maps to DIM_PROJECT_CODE_HIERARCHY.codetypename
codetypesequencenumberD_PROJECT_CODE_HIERARCHYintegerD_PROJECT_CODE_HIERARCHY.codetypesequencenumber maps to DIM_PROJECT_CODE_HIERARCHY.codetypesequencenumber
codetypeissecureD_PROJECT_CODE_HIERARCHYstringD_PROJECT_CODE_HIERARCHY.codetypeissecure maps to DIM_PROJECT_CODE_HIERARCHY.codetypeissecure
parentcodevalueobjectidD_PROJECT_CODE_HIERARCHYintegerD_PROJECT_CODE_HIERARCHY.parentcodevalueobjectid maps to DIM_PROJECT_CODE_HIERARCHY.parentcodevalueobjectid
parentcodevaluenameD_PROJECT_CODE_HIERARCHYstringD_PROJECT_CODE_HIERARCHY.parentcodevaluename maps to DIM_PROJECT_CODE_HIERARCHY.parentcodevaluename
parentcodevalueshortnameD_PROJECT_CODE_HIERARCHYstringD_PROJECT_CODE_HIERARCHY.parentcodevalueshortname maps to DIM_PROJECT_CODE_HIERARCHY.parentcodevalueshortname
parentcodevaluesequencenumberD_PROJECT_CODE_HIERARCHYintegerD_PROJECT_CODE_HIERARCHY.parentcodevaluesequencenumber maps to DIM_PROJECT_CODE_HIERARCHY.parentcodevaluesequencenumber
childcodevalueobjectidD_PROJECT_CODE_HIERARCHYintegerD_PROJECT_CODE_HIERARCHY.childcodevalueobjectid maps to DIM_PROJECT_CODE_HIERARCHY.childcodevalueobjectid
childcodevaluenameD_PROJECT_CODE_HIERARCHYstringD_PROJECT_CODE_HIERARCHY.childcodevaluename maps to DIM_PROJECT_CODE_HIERARCHY.childcodevaluename
childcodevalueshortnameD_PROJECT_CODE_HIERARCHYstringD_PROJECT_CODE_HIERARCHY.childcodevalueshortname maps to DIM_PROJECT_CODE_HIERARCHY.childcodevalueshortname
childcodevaluesequencenumberD_PROJECT_CODE_HIERARCHYintegerD_PROJECT_CODE_HIERARCHY.childcodevaluesequencenumber maps to DIM_PROJECT_CODE_HIERARCHY.childcodevaluesequencenumber
parentlevelsbelowrootD_PROJECT_CODE_HIERARCHYintegerD_PROJECT_CODE_HIERARCHY.parentlevelsbelowroot maps to DIM_PROJECT_CODE_HIERARCHY.parentlevelsbelowroot
childlevelsbelowrootD_PROJECT_CODE_HIERARCHYintegerD_PROJECT_CODE_HIERARCHY.childlevelsbelowroot maps to DIM_PROJECT_CODE_HIERARCHY.childlevelsbelowroot
levelsbetweenD_PROJECT_CODE_HIERARCHYintegerD_PROJECT_CODE_HIERARCHY.levelsbetween maps to DIM_PROJECT_CODE_HIERARCHY.levelsbetween
childhaschildrenD_PROJECT_CODE_HIERARCHYstringD_PROJECT_CODE_HIERARCHY.childhaschildren maps to DIM_PROJECT_CODE_HIERARCHY.childhaschildren
fullpathnameD_PROJECT_CODE_HIERARCHYstringD_PROJECT_CODE_HIERARCHY.fullpathname maps to DIM_PROJECT_CODE_HIERARCHY.fullpathname
codetypeweightD_PROJECT_CODE_HIERARCHYdoubleD_PROJECT_CODE_HIERARCHY.codetypeweight maps to DIM_PROJECT_CODE_HIERARCHY.codetypeweight
maxcodevalueweightD_PROJECT_CODE_HIERARCHYdoubleD_PROJECT_CODE_HIERARCHY.maxcodevalueweight maps to DIM_PROJECT_CODE_HIERARCHY.maxcodevalueweight
parentcodevalueweightD_PROJECT_CODE_HIERARCHYdoubleD_PROJECT_CODE_HIERARCHY.parentcodevalueweight maps to DIM_PROJECT_CODE_HIERARCHY.parentcodevalueweight
childcodevalueweightD_PROJECT_CODE_HIERARCHYdoubleD_PROJECT_CODE_HIERARCHY.childcodevalueweight maps to DIM_PROJECT_CODE_HIERARCHY.childcodevalueweight
currentprocesscycledateD_PROJECT_CODE_HIERARCHYdateD_PROJECT_CODE_HIERARCHY.currentprocesscycledate maps to DIM_PROJECT_CODE_HIERARCHY.currentprocesscycledate
snapshotidD_PROJECT_CODE_HIERARCHYintegerID of star snapshot
etlprocessD_PROJECT_CODE_HIERARCHYdateD_PROJECT_CODE_HIERARCHY.etlprocess maps to DIM_PROJECT_CODE_HIERARCHY.etlprocess
D_TIMETop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
civiliantimeD_TIMEstringD_TIME.civiliantime maps to PSTG_TIME.civiliantime
militarytimeD_TIMEcharacterD_TIME.militarytime maps to PSTG_TIME.militarytime
skeyD_TIMEbigintD_TIME.skey maps to PSTG_TIME.skey
twocharD_TIMEcharacterD_TIME.twochar maps to PSTG_TIME.twochar
timenameD_TIMEstringD_TIME.timename maps to PSTG_TIME.timename
timeofdayD_TIMEintegerD_TIME.timeofday maps to PSTG_TIME.timeofday
etlprocessD_TIMEdateD_TIME.etlprocess maps to PSTG_TIME.etlprocess
etluserD_TIMEstringD_TIME.etluser maps to PSTG_TIME.etluser
F_PROJECTSTop
STAR Field NameSTAR Table NameAPI Table NameAPI Field NamePMDB Table NamePMDB Field NameData TypeDescription
skeyF_PROJECTSbigintF_PROJECTS.skey maps to STG_F_PROJECT.skey
projectskeyF_PROJECTSbigintF_PROJECTS.projectskey maps to STG_F_PROJECT.projectskey
financialperiodskeyF_PROJECTSbigintF_PROJECTS.financialperiodskey maps to STG_F_PROJECT.financialperiodskey
costaccountskeyF_PROJECTSbigintF_PROJECTS.costaccountskey maps to STG_F_PROJECT.costaccountskey
epsskeyF_PROJECTSbigintF_PROJECTS.epsskey maps to STG_F_PROJECT.epsskey
obsskeyF_PROJECTSbigintF_PROJECTS.obsskey maps to STG_F_PROJECT.obsskey
startdateskeyF_PROJECTSbigintF_PROJECTS.startdateskey maps to STG_F_PROJECT.startdateskey
finishdateskeyF_PROJECTSbigintF_PROJECTS.finishdateskey maps to STG_F_PROJECT.finishdateskey
anticipatedfinishdateskeyF_PROJECTSbigintF_PROJECTS.anticipatedfinishdateskey maps to STG_F_PROJECT.anticipatedfinishdateskey
anticipatedstartdateskeyF_PROJECTSbigintF_PROJECTS.anticipatedstartdateskey maps to STG_F_PROJECT.anticipatedstartdateskey
isbaselineF_PROJECTScharacterF_PROJECTS.isbaseline maps to STG_F_PROJECT.isbaseline
currentprocesscycledateF_PROJECTSdateF_PROJECTS.currentprocesscycledate maps to STG_F_PROJECT.currentprocesscycledate
ActivityDefaultPricePerUnitF_PROJECTSActivityDefaultPricePerUnitprojectdef_cost_per_qtynumberThe 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.
AnnualDiscountRateF_PROJECTSAnnualDiscountRateprojwbsann_dscnt_rate_pctnumberThe user-defined number field that identifies the discount rate for the project.
CheckOutDateF_PROJECTSCheckOutDateprojectcheckout_datedateThe date on which the project was checked out of the Project Management database.
CriticalActivityFloatLimitF_PROJECTSCriticalActivityFloatLimitprojectcritical_drtn_hr_cntnumberThe 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.
CurrentBudgetF_PROJECTSCurrentBudgetnumberThe sum of the original budget plus the approved and pending budgets from the budget change log.
CurrentVarianceF_PROJECTSCurrentVariancenumberThe difference between the current budget and the total spending plan. Calculated as current budget - total spending plan. Not rolled up
DataDateF_PROJECTSDataDatedateThe 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.
DateAddedF_PROJECTSDateAddedprojectadd_datedateThe date on which the project was added to the Project Management database.
DistributedCurrentBudgetF_PROJECTSDistributedCurrentBudgetnumberThe current budget values from one level lower.
EarnedValueUserPercentF_PROJECTSEarnedValueUserPercentprojwbsev_user_pctnumberThe 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.
FiscalYearStartMonthF_PROJECTSFiscalYearStartMonthprojectfy_start_month_numintegerThe month that marks the beginning of the fiscal year for the project.
ForecastFinishDateF_PROJECTSForecastFinishDatedateThe 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.
ForecastStartDateF_PROJECTSForecastStartDatedateThe 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.
IndependentETCLaborUnitsF_PROJECTSIndependentETCLaborUnitsprojwbsindep_remain_work_qtynumberThe user-entered ETC total labor.
IndependentETCTotalCostF_PROJECTSIndependentETCTotalCostprojwbsindep_remain_total_costnumberThe user-entered ETC total cost.
lastbaselineupdatedateF_PROJECTSdateF_PROJECTS.lastbaselineupdatedate maps to STG_F_PROJECT.lastbaselineupdatedate
LastSummarizedDateF_PROJECTSLastSummarizedDateprojectlast_tasksum_datedateThe date the project was last summarized.
LevelingPriorityF_PROJECTSLevelingPriorityprojectpriority_numintegerThe priority for scheduling.
MustFinishByDateF_PROJECTSMustFinishByDateprojectplan_end_datedateThe date by which all project activities must finish. If entered, it is used as the project late finish date by the project scheduler.
OverallProjectScoreF_PROJECTSOverallProjectScorenumberThe project score calculated based on all project code types assigned to this project.
PlannedStartDateF_PROJECTSPlannedStartDateprojectplan_start_datedateThe planned start date of the project. Used by the project scheduler.
ProjectForecastStartDateF_PROJECTSProjectForecastStartDateprojectfcst_start_datedateThe 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.
ProposedBudgetF_PROJECTSProposedBudgetnumberThe Proposed Budget, which is the sum of the original budget plus the approved and pending budgets from the budget change log.
ScheduledFinishDateF_PROJECTSScheduledFinishDateprojectscd_end_datedateThe early finish date of the latest activity in the project, as computed by the project scheduler.
StrategicPriorityF_PROJECTSStrategicPriorityprojectstrgy_priority_numintegerThe project's priority. The range is from 1 to 10,000.
SummarizedDataDateF_PROJECTSSummarizedDataDateprojectsum_data_datedateThe data date of the project when it was last summarized-only updated by summarizer.
StatusF_PROJECTSStatusprojwbsstatus_codestringThe project status: 'Planned', 'Active', 'Inactive', 'What-If', or 'Requested'.
SumAccountingVarByLaborUnitsF_PROJECTSSummaryAccountingVarianceByLaborUnitsPROJECTnumberthe Planned Value Labor Units minus the Actual Units. Negative value indicates that Actual Units have exceeded the Planned Value Labor Units.
SumAccountingVarianceByCostF_PROJECTSSummaryAccountingVarianceByCostPROJECTnumberthe Planned Value minus the Actual Cost. A negative value indicates that the Actual Cost has exceeded the Planned Value.
SumActivityCountF_PROJECTSSummaryActivityCountPROJECTnumberthe number of activities that are currently in progress.
SumActThisPeriodMaterialCostF_PROJECTSSummaryActualThisPeriodMaterialCosttasksumact_this_per_mat_costnumberThe actual this period material cost.
SumActThisPeriodNonLaborCostF_PROJECTSSummaryActualThisPeriodNonLaborCosttasksumact_this_per_equip_costnumberThe actual this period nonlabor cost.
SumActThisPeriodNonLaborUnitsF_PROJECTSSummaryActualThisPeriodNonLaborUnitstasksumact_this_per_equip_qtynumberThe actual this period nonlabor units.
SumActualDurationF_PROJECTSSummaryActualDurationtasksumact_drtn_hr_cntnumberThe actual duration.
SumActualExpenseCostF_PROJECTSSummaryActualExpenseCosttasksumact_expense_costnumberThe actual costs for all project expenses associated with the project.
SumActualFinishDateF_PROJECTSSummaryActualFinishDatetasksumact_end_datedateThe latest actual finish date of all activities in the project.
SumActualLaborCostF_PROJECTSSummaryActualLaborCosttasksumact_work_costnumberThe actual cost for all labor resources assigned to the activity.
SumActualLaborUnitsF_PROJECTSSummaryActualLaborUnitstasksumact_work_qtynumberThe actual labor units.
SumActualMaterialCostF_PROJECTSSummaryActualMaterialCosttasksumact_mat_costnumberThe actual units for all material resources assigned to the activity.
SumActualNonLaborCostF_PROJECTSSummaryActualNonLaborCosttasksumact_equip_costnumberThe actual units for all nonlabor resources assigned to the activity.
SumActualNonLaborUnitsF_PROJECTSSummaryActualNonLaborUnitstasksumact_equip_qtynumberThe actual nonlabor units.
SumActualStartDateF_PROJECTSSummaryActualStartDatetasksumact_start_datedateThe earliest actual start date of all activities in the project.
SumActualThisPeriodCostF_PROJECTSSummaryActualThisPeriodCostPROJECTnumberThe actual this period cost (will be labor or nonlabor).
SumActualThisPeriodLaborCostF_PROJECTSSummaryActualThisPeriodLaborCosttasksumact_this_per_work_costnumberThe actual this period labor cost
SumActualThisPeriodLaborUnitsF_PROJECTSSummaryActualThisPeriodLaborUnitstasksumact_this_per_work_qtynumberThe actual this period labor units.
sumactualtotalcostF_PROJECTSnumberF_PROJECTS.sumactualtotalcost maps to STG_F_PROJECT.sumactualtotalcost
SumActualValueByCostF_PROJECTSSummaryActualValueByCostPROJECTnumberthe 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.
SumActualValueByLaborUnitsF_PROJECTSSummaryActualValueByLaborUnitstasksumact_work_qtynumberthe actual total labor units for the activity as of the project data date (i.e., actual total cost by labor units).
SumAtCompletionDurationF_PROJECTSSummaryAtCompletionDurationtasksumtotal_drtn_hr_cntnumberThe duration at completion.
SumAtCompletionExpenseCostF_PROJECTSSummaryAtCompletionExpenseCostPROJECTnumberthe sum of the actual plus remaining cost for all project expenses associated with the cost account. Computed as Actual Expense Cost + Remaining Expense Cost.
SumAtCompletionLaborCostF_PROJECTSSummaryAtCompletionLaborCostPROJECTnumberThe 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.
SumAtCompletionLaborUnitsF_PROJECTSSummaryAtCompletionLaborUnitsPROJECTnumberThe 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.
SumAtCompletionMaterialCostF_PROJECTSSummaryAtCompletionMaterialCostPROJECTnumberThe 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.
SumAtCompletionNonLaborCostF_PROJECTSSummaryAtCompletionNonLaborCostPROJECTnumberThe 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.
SumAtCompletionNonLaborUnitsF_PROJECTSSummaryAtCompletionNonLaborUnitsPROJECTnumberThe 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.
SumAtCompletionTotalCostF_PROJECTSSummaryAtCompletionTotalCostPROJECTnumberThe 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.
SumAtCompletionTotalCostVarF_PROJECTSSummaryAtCompletionTotalCostVariancePROJECTnumberthe Baseline Planned Total Cost - At Completion Total Cost.
SumBaselineCompActivityCountF_PROJECTSSummaryBaselineCompletedActivityCounttasksumbase_complete_cntnumberThe number of completed activities in the baseline.
SumBaselineDurationF_PROJECTSSummaryBaselineDurationtasksumbase_drtn_hr_cntnumberthe 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.
SumBaselineExpenseCostF_PROJECTSSummaryBaselineExpenseCosttasksumbase_expense_costnumberthe 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.
SumBaselineFinishDateF_PROJECTSSummaryBaselineFinishDatetasksumbase_end_datedateThe current latest finish date of all activities in the project for the current baseline.
SumBaselineLaborCostF_PROJECTSSummaryBaselineLaborCosttasksumbase_work_costnumberthe 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.
SumBaselineLaborUnitsF_PROJECTSSummaryBaselineLaborUnitstasksumbase_work_qtynumberthe 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.
SumBaselineMaterialCostF_PROJECTSSummaryBaselineMaterialCosttasksumbase_mat_costnumberthe 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.
SumBaselineNonLaborCostF_PROJECTSSummaryBaselineNonLaborCosttasksumbase_equip_costnumberthe 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.
SumBaselineNonLaborUnitsF_PROJECTSSummaryBaselineNonLaborUnitstasksumbase_equip_qtynumberthe 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.
SumBaselineNotStartedActCntF_PROJECTSSummaryBaselineNotStartedActivityCounttasksumbase_notstarted_cntnumberThe number of activities not started in the baseline.
SumBaselineStartDateF_PROJECTSSummaryBaselineStartDatetasksumbase_start_datedateThe current earliest start date of all activities in the Project for the current baseline.
SumBaselineTotalCostF_PROJECTSSummaryBaselineTotalCostPROJECTnumberthe 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.
SumBLInProgressActivityCountF_PROJECTSSummaryBaselineInProgressActivityCounttasksumbase_active_cntnumberThe number of in-progress activities in the baseline.
SumBudgetAtCmpByLaborUnitsF_PROJECTSSummaryBudgetAtCompletionByLaborUnitstasksumbase_work_qtynumberthe Baseline Labor Units
SumBudgetAtCompletionByCostF_PROJECTSSummaryBudgetAtCompletionByCostPROJECTnumberthe Planned Total Cost through activity completion. Computed as Planned Labor Cost + Planned Nonlabor Cost + Planned Expense Cost, same as the Planned Total Cost.
SumCompletedActivityCountF_PROJECTSSummaryCompletedActivityCounttasksumcomplete_cntnumberthe number of activities that have an Actual Finish in the Project.
SumCostPercentCompleteF_PROJECTSSummaryCostPercentCompletenumberThe 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.
SumCostPercentOfPlannedF_PROJECTSSummaryCostPercentOfPlannednumberThe 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.
SumCostPerfIndexByCostF_PROJECTSSummaryCostPerformanceIndexByCostnumberthe Earned Value divided by the Actual Cost. A value less than 1 indicates that the Actual Cost has exceeded the Planned Value.
SumCostPerfIndexByLaborUnitsF_PROJECTSSummaryCostPerformanceIndexByLaborUnitsnumberthe Earned Value Labor Units / Actual Labor Units.
SumCostVarianceByCostF_PROJECTSSummaryCostVarianceByCostPROJECTnumberthe Earned Value minus the Actual Cost. A negative value indicates that the Actual Cost has exceeded the Planned Value.
SumCostVarianceByLaborUnitsF_PROJECTSSummaryCostVarianceByLaborUnitsPROJECTnumberthe Earned Value Labor Cost minus Actual Value Labor Cost.
SumCostVarianceIndexF_PROJECTSSummaryCostVarianceIndexnumberThe value that is calculated as the Cost Variance divided by Earned Value.
SumCostVarianceIndexByCostF_PROJECTSSummaryCostVarianceIndexByCostnumberthe Cost Variance divided by Earned Value.
SumCostVarIndexByLaborUnitsF_PROJECTSSummaryCostVarianceIndexByLaborUnitsnumberthe Cost Variance Labor Units divided by Earned Value Labor Units.
SumDurationPercentCompleteF_PROJECTSSummaryDurationPercentCompletenumberThe 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.
SumDurationPercentOfPlannedF_PROJECTSSummaryDurationPercentOfPlannednumberThe 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.
SumDurationVarianceF_PROJECTSSummaryDurationVariancePROJECTnumberThe duration between the activity's baseline duration and the at complete duration. Computed as baseline planned duration - at completion duration.
SumEACByCostF_PROJECTSSummaryEstimateAtCompletionByCostPROJECTnumberthe 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.
SumEACByLaborUnitsF_PROJECTSSummaryEstimateAtCompletionByLaborUnitsPROJECTnumberthe 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.)
SumEACHighPctByLaborUnitsF_PROJECTSSummaryEstimateAtCompletionHighPercentByLaborUnitsnumberthe high forecast of Estimate At Completion (EAC) by labor units.
SumEACLowPctByLaborUnitsF_PROJECTSSummaryEstimateAtCompletionLowPercentByLaborUnitsnumberthe low forecast of Estimate At Completion (EAC) by labor units.
SumEarnedValueByCostF_PROJECTSSummaryEarnedValueByCosttasksumbcwpnumberthe 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.
SumEarnedValueByLaborUnitsF_PROJECTSSummaryEarnedValueByLaborUnitstasksumperfm_work_qtynumberthe 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.
SumETCByCostF_PROJECTSSummaryEstimateToCompleteByCosttasksumetcnumberthe 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).
SumETCByLaborUnitsF_PROJECTSSummaryEstimateToCompleteByLaborUnitstasksumetc_work_qtynumberthe 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.
SumExpenseCostPctCompleteF_PROJECTSSummaryExpenseCostPercentCompletenumberThe 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.
SumExpenseCostVarianceF_PROJECTSSummaryExpenseCostVariancePROJECTnumberthe Baseline Planned Expense Cost - At Completion Expense Cost (At Completion Expense Cost = Actual Expense Cost + Remaining Expense Cost).
SumFinishDateVarianceF_PROJECTSSummaryFinishDateVariancenumberThe duration between the finish date in the current project and the baseline finish date. Calculated as finish date - baseline finish date.
SumInProgressActivityCountF_PROJECTSSummaryInProgressActivityCounttasksumactive_cntnumberthe number of activities that are currently in progress.
SumLaborCostPercentCompleteF_PROJECTSSummaryLaborCostPercentCompletenumberThe 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.
SumLaborCostVarianceF_PROJECTSSummaryLaborCostVariancePROJECTnumberthe Baseline Planned Labor Cost - At Completion Labor Cost.
SumLaborUnitsPercentCompleteF_PROJECTSSummaryLaborUnitsPercentCompletenumberThe 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.
SumLaborUnitsVarianceF_PROJECTSSummaryLaborUnitsVariancePROJECTnumberThe difference between baseline labor units and at completion labor units. Calculated as baseline labor units - at completion labor units.
SumMaterialCostPctCompleteF_PROJECTSSummaryMaterialCostPercentCompletenumberThe 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.
SumMaterialCostVarianceF_PROJECTSSummaryMaterialCostVariancePROJECTnumberThe variance that is calculated as Baseline Material Cost - At Completion Material Cost.
SumNonLaborCostPctCompleteF_PROJECTSSummaryNonLaborCostPercentCompletenumberThe 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.
SumNonLaborCostVarianceF_PROJECTSSummaryNonLaborCostVariancePROJECTnumberthe Baseline Planned Nonlabor Cost - At Completion Nonlabor Cost.
SumNonLaborUnitsPctCompleteF_PROJECTSSummaryNonLaborUnitsPercentCompletePROJECTnumberThe 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.
SumNonLaborUnitsVarianceF_PROJECTSSummaryNonLaborUnitsVariancePROJECTnumberThe difference between baseline nonlabor units and at completion non labor units. Calculated as baseline nonlabor units - at completion nonlabor units.
SumNotStartedActivityCountF_PROJECTSSummaryNotStartedActivityCounttasksumnotstarted_cntnumberthe number of activities that are currently not started.
SumPerfPctCmpByLaborUnitsF_PROJECTSSummaryPerformancePercentCompleteByLaborUnitsnumberthe 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.
SumPlannedValueByCostF_PROJECTSSummaryPlannedValueByCosttasksumbcwsnumberthe 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
SumPlannedValueByLaborUnitsF_PROJECTSSummaryPlannedValueByLaborUnitstasksumsched_work_qtynumberthe 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.
SumProgressFinishDateF_PROJECTSSummaryProgressFinishDatedatethe 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.
SumRemainingDurationF_PROJECTSSummaryRemainingDurationtasksumremain_drtn_hr_cntnumberThe total working time from the Project remaining start date to the remaining finish date.
SumRemainingExpenseCostF_PROJECTSSummaryRemainingExpenseCosttasksumremain_expense_costnumberThe remaining costs for all project expenses associated with the activities in the Project.
SumRemainingFinishDateF_PROJECTSSummaryRemainingFinishDatetasksumreend_datedateThe 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.
SumRemainingLaborCostF_PROJECTSSummaryRemainingLaborCosttasksumremain_work_costnumberThe remaining costs for all labor resources assigned to the activities. The remaining cost reflects the cost remaining for the Project.
SumRemainingLaborUnitsF_PROJECTSSummaryRemainingLaborUnitstasksumremain_work_qtynumberThe remaining units for all labor resources assigned to the activities. The remaining units reflects the work remaining to be done for the Project.
SumRemainingMaterialCostF_PROJECTSSummaryRemainingMaterialCosttasksumremain_mat_costnumberThe remaining material costs for all project expenses associated with the activities in the Project.
SumRemainingNonLaborCostF_PROJECTSSummaryRemainingNonLaborCosttasksumremain_equip_costnumberThe remaining nonlabor costs for all project expenses associated with the activities in the Project.
SumRemainingNonLaborUnitsF_PROJECTSSummaryRemainingNonLaborUnitstasksumremain_equip_qtynumberThe remaining units for all nonlabor resources assigned to the activities. The remaining units reflects the work remaining to be done for the Project.
SumRemainingStartDateF_PROJECTSSummaryRemainingStartDatetasksumrestart_datedateThe earliest remaining start of all activities assigned to the Project.
SumRemainingTotalCostF_PROJECTSSummaryRemainingTotalCostPROJECTnumberThe sum of all remaining total costs in the Project.
SumSchdPctCmpByLaborUnitsF_PROJECTSSummarySchedulePercentCompleteByLaborUnitsnumberthe 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.
SumSchdPerfIndexByLaborUnitsF_PROJECTSSummarySchedulePerformanceIndexByLaborUnitsnumberthe Earned Value Labor Units divided by Planned Value Labor Units.
SumSchdVarianceByLaborUnitsF_PROJECTSSummaryScheduleVarianceByLaborUnitsPROJECTnumberthe Earned Value Labor Units minus the Planned Value Labor Units.
SumSchdVarianceIndexByCostF_PROJECTSSummaryScheduleVarianceIndexByCostnumberthe Schedule Variance divided by the Planned Value.
SumSchdVarIndexByLaborUnitsF_PROJECTSSummaryScheduleVarianceIndexByLaborUnitsnumberthe Schedule Variance Labor Units divided by the Planned Value Labor Units.
SumSchedulePctCompleteByCostF_PROJECTSSummarySchedulePercentCompleteByCostnumberthe 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.
SumSchedulePercentCompleteF_PROJECTSSummarySchedulePercentCompletenumberThe 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.
SumSchedulePerfIndexByCostF_PROJECTSSummarySchedulePerformanceIndexByCostnumberthe Earned Value divided by the Planned Value. A value less than 1 indicates that less work was actually performed than was scheduled.
SumScheduleVarianceByCostF_PROJECTSSummaryScheduleVarianceByCostPROJECTnumberthe Earned Value divided by the Planned Value. A negative value indicates that less work was actually performed than was scheduled.
SumScheduleVarianceIndexF_PROJECTSSummaryScheduleVarianceIndexnumberThe value that is calculated as the Schedule Variance Labor Units divided by Planned Value Labor Units.
SumStartDateVarianceF_PROJECTSSummaryStartDateVariancenumberThe duration between the start date in the current project and the baseline start date. Calculated as start date - baseline start date.
SumToCompletePerfIndexByCostF_PROJECTSSummaryToCompletePerformanceIndexByCostnumberthe (Budget at Completion - Earned Value) divided by (Estimate at Completion - Actual Cost).
SumTotalCostVarianceF_PROJECTSSummaryTotalCostVariancePROJECTnumberThe value that is calculated as baseline total cost - total cost.
SumTotalFloatF_PROJECTSSummaryTotalFloattasksumtotal_float_hr_cntnumberThe 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.
SumUnitsPercentCompleteF_PROJECTSSummaryUnitsPercentCompletenumberThe 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.
SumVarAtCmpByLaborUnitsF_PROJECTSSummaryVarianceAtCompletionByLaborUnitsPROJECTnumberthe Baseline Planned Total Labor Units minus Estimate at Completion Labor Units.
TotalBenefitPlanF_PROJECTSTotalBenefitPlannumberThe sum of the monthly benefit plan.
TotalBenefitPlanTallyF_PROJECTSTotalBenefitPlanTallynumberThe sum of the monthly benefit plan tally.
TotalFundingF_PROJECTSTotalFundingnumberThe total amount of funding contributed to the project by your funding sources.
TotalSpendingPlanF_PROJECTSTotalSpendingPlannumberThe sum of the monthly spending plan.
TotalSpendingPlanTallyF_PROJECTSTotalSpendingPlanTallynumberThe sum of the monthly spending plan tally.
UnallocatedBudgetF_PROJECTSUnallocatedBudgetnumberThe total current budget minus the distributed current budget.
UndistributedCurrentVarianceF_PROJECTSUndistributedCurrentVariancenumberThe total spending plan minus the total spending plan tally.
snapshotidF_PROJECTSintegerID of star snapshot
etlprocessF_PROJECTSdateF_PROJECTS.etlprocess maps to STG_F_PROJECT.etlprocess