Skip to Main Content
Return to Navigation

Fact Tables

This table lists the fact tables that are used in PeopleSoft Scorecard, with a description of the data they contain:

Fact Tables

Type of Data

BC_ASSESS_F00

Stores scorecard assessment results.

BC_COMMENTS_F00

Stores scorecard comments.

BC_COMMENTS_S00

Stores comments and approval status.

BC_PRSPCTV_F00

Stores perspective assessments.

KP_DATAVALS_F00

Stores KPI Data Element values.

KP_KPI_ASMT_F00

Stores KPI assessment results.

KP_KPI_CALC_F00

Stores calculated KPI values.

KP_KPI_OVRD_F00

Stores KPI assessment override information.

KP_OBJ_RULE_F00

Stores KPI dimension members, when they are defined by a rule.

KP_TRGTVALS_F00

Stores KPI target values.

KP_KPI_NODE_F00

Stores hierarchical KPI tree fact data and data that describes the relationship between a KPI and the associated tree.

KP_KPI_NODE_S00

Stores hierarchical KPI node-level values.

KP_KPI_DSCR_F00

Stores the KPI and dimension member descriptions for base language and all installed languages.