SCD_MAN_KPI_VW

(SQL View)
 Index Back

SELECT KQ.SCD_EVALUATION_ID ,KQ.SCD_SECTION_ID , BS.SCD_SEQ_NBR * 100 + BQ.SCD_SEQ_NBR ,KQ.SCD_QUESTION_ID , BS.SCD_SECTION_NAME , BQ.SCD_QUESTION_TEXT , KQ.SCD_KPI_TYPE ,KQ.SCD_KPI_DEF_NAME ,KQ.SCD_KPI_MAP_METHOD , KQ.SCD_ACTUAL_KPI_VAL ,KQ.SCD_ACCEPT_KPI_VAL , KQ.SCD_SCORE ,KQ.SCD_KPIAPPL_UPDTTM , KQ.SCD_KPIACCP_UPDTTM FROM PS_SCD_BLD_SECTS BS INNER JOIN PS_SCD_BLD_SCT_QST BQ ON BS.SCD_EVALUATION_ID=BQ.SCD_EVALUATION_ID AND BS.SCD_SECTION_ID=BQ.SCD_SECTION_ID INNER JOIN PS_SCD_KPIEVAL_QST KQ ON BQ.SCD_EVALUATION_ID=KQ.SCD_EVALUATION_ID AND BQ.SCD_SECTION_ID=KQ.SCD_SECTION_ID AND BQ.SCD_QUESTION_ID=KQ.SCD_QUESTION_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCD_EVALUATION_ID Character(10) VARCHAR2(10) NOT NULL Evaluation ID
2 SCD_SECTION_ID Character(10) VARCHAR2(10) NOT NULL Section ID
3 SCD_SEQ_NBR Number(5,0) INTEGER NOT NULL Sequence Number
4 SCD_QUESTION_ID Character(10) VARCHAR2(10) NOT NULL Question ID
5 SCD_SECTION_NAME Character(30) VARCHAR2(30) NOT NULL Section Name
6 SCD_QUESTION_TEXT Character(254) VARCHAR2(254) NOT NULL Question Text
7 SCD_KPI_TYPE Character(2) VARCHAR2(2) NOT NULL KPI Type
MA=Manual
QR=Query
8 SCD_KPI_DEF_NAME Character(30) VARCHAR2(30) NOT NULL KPI Name
9 SCD_KPI_MAP_METHOD Character(1) VARCHAR2(1) NOT NULL KPI Mapping Method
A=Actual
L=Linear
S=Scoring Model
U=User Defined
10 SCD_ACTUAL_KPI_VAL Signed Number(11,6) DECIMAL(9,6) NOT NULL Scorecarding Score
11 SCD_ACCEPT_KPI_VAL Signed Number(11,6) DECIMAL(9,6) NOT NULL Scorecarding Score
12 SCD_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Scorecarding Score
13 SCD_KPIAPPL_UPDTTM DateTime(26) TIMESTAMP Last Updated
14 SCD_KPIACCP_UPDTTM DateTime(26) TIMESTAMP Last update date time of KPI Accepted Value