SCD_QUESTIONS (SQL Table)	Index Back
Questions Evaluation Questions

SCD_QUESTIONS

(SQL Table)

Questions

Evaluation Questions

Related Language Record: SCD_QUESTN_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCD_QUESTION_ID Character(10) VARCHAR2(10) NOT NULL Question ID

2 SCD_DESCR30 Character(30) VARCHAR2(30) NOT NULL 30 Character Description

3 SCD_QUEST_TYPE Character(2) VARCHAR2(2) NOT NULL Question Type
K=KPI
S=Subjective
Default Value: S

4 SCD_QUESTION_GROUP Character(15) VARCHAR2(15) NOT NULL Question Group
Prompt Table: SCD_QUEST_GRPS

5 SCD_QUESTN_STATUS Character(2) VARCHAR2(2) NOT NULL Question Status
AV=Available
NA=Not Available
PE=Pending
Default Value: PE

6 SCD_QUESTION_TEXT Character(254) VARCHAR2(254) NOT NULL Question Text

7 SCD_DESCR_LONG Long Character CLOB Long Description

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

9 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

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

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

12 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_QUESTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Question ID
2	SCD_DESCR30	Character(30)	VARCHAR2(30) NOT NULL	30 Character Description
3	SCD_QUEST_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Question Type K=KPI S=Subjective Default Value: S
4	SCD_QUESTION_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Question Group Prompt Table: SCD_QUEST_GRPS
5	SCD_QUESTN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Question Status AV=Available NA=Not Available PE=Pending Default Value: PE
6	SCD_QUESTION_TEXT	Character(254)	VARCHAR2(254) NOT NULL	Question Text
7	SCD_DESCR_LONG	Long Character	CLOB	Long Description
8	SCD_KPI_DEF_ID	Character(10)	VARCHAR2(10) NOT NULL	KPI ID
9	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
10	CREATED_BY	Character(30)	VARCHAR2(30) NOT NULL	Created By
11	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.
12	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.