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. |