SCD_KPI_DEF (SQL Table)	Index Back
Scorecarding KPI Definition Scorecarding KPI Definition

SCD_KPI_DEF

(SQL Table)

Scorecarding KPI Definition

Related Language Record: SCD_KPI_DEF_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCD_KPI_DEF_ID Character(10) VARCHAR2(10) NOT NULL KPI ID

2 SCD_KPI_CATEGORY Character(15) VARCHAR2(15) NOT NULL KPI Category
Prompt Table: SCD_KPI_CAT

3 SCD_KPI_DEF_NAME Character(30) VARCHAR2(30) NOT NULL KPI Name

4 SCD_KPI_DEF_DESC Long Character(1000) VARCHAR2(1000) KPI Description

5 SCD_COMMENTS_LONG Long Character CLOB Long Description

6 SCD_KPI_DEF_STATUS Character(2) VARCHAR2(2) NOT NULL KPI Definition Status
AV=Available
NA=Not Available
PE=Pending

7 SCD_KPI_TYPE Character(2) VARCHAR2(2) NOT NULL KPI Type
MA=Manual
QR=Query

8 SCD_KPI_MAP_METHOD Character(1) VARCHAR2(1) NOT NULL KPI Mapping Method
A=Actual
L=Linear
S=Scoring Model
U=User Defined
Default Value: A

9 SCD_USE_PR_HIS_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate if procurement history is used
N=No
Y=Yes
Y/N Table Edit
Default Value: N

10 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
Prompt Table: SCD_QRYPRMPT_VW

11 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

12 CREATED_BY Character(30) VARCHAR2(30) NOT NULL Created By

13 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

14 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCD_KPI_DEF_ID	Character(10)	VARCHAR2(10) NOT NULL	KPI ID
2	SCD_KPI_CATEGORY	Character(15)	VARCHAR2(15) NOT NULL	KPI Category Prompt Table: SCD_KPI_CAT
3	SCD_KPI_DEF_NAME	Character(30)	VARCHAR2(30) NOT NULL	KPI Name
4	SCD_KPI_DEF_DESC	Long Character(1000)	VARCHAR2(1000)	KPI Description
5	SCD_COMMENTS_LONG	Long Character	CLOB	Long Description
6	SCD_KPI_DEF_STATUS	Character(2)	VARCHAR2(2) NOT NULL	KPI Definition Status AV=Available NA=Not Available PE=Pending
7	SCD_KPI_TYPE	Character(2)	VARCHAR2(2) NOT NULL	KPI Type MA=Manual QR=Query
8	SCD_KPI_MAP_METHOD	Character(1)	VARCHAR2(1) NOT NULL	KPI Mapping Method A=Actual L=Linear S=Scoring Model U=User Defined Default Value: A
9	SCD_USE_PR_HIS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate if procurement history is used N=No Y=Yes Y/N Table Edit Default Value: N
10	QRYNAME	Character(30)	VARCHAR2(30) NOT NULL	Query Name Prompt Table: SCD_QRYPRMPT_VW
11	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
12	CREATED_BY	Character(30)	VARCHAR2(30) NOT NULL	Created By
13	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
14	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.