QUESTION (SQL Table)	Index Back
Question Definition QUESTION is a record that defines the format and structure of a specific question that is presented as part of a Certificate.

QUESTION

(SQL Table)

Question Definition

QUESTION is a record that defines the format and structure of a specific question that is presented as part of a Certificate.

Related Language Record: QUESTION_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CERTIFICATE_ID Character(10) VARCHAR2(10) NOT NULL The CERTIFICATE_ID is the unique identifier for a Certificate definition.
Prompt Table: CERTIFICATE

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 QUESTION_NUM Number(3,0) SMALLINT NOT NULL The QUESTION_NUM provides a unique value for each question on a Certificate.

4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

5 QUESTION_TYPE_CD Character(1) VARCHAR2(1) NOT NULL The QUESTION_TYPE_CD specifies the display format and structure for a Question.
M=Multiple Choice
R=Rating
Y=Yes / No
Default Value: Y

6 QUESTION_WEIGHT Number(3,0) SMALLINT NOT NULL The QUESTION_WEIGHT specifies the weighting values that is to be applied for a Question.

7 QUESTION_STMT_TEXT Character(100) VARCHAR2(100) NOT NULL The QUESTION_STMT_TEXT string defines the text value to be presented on the Certificate page that poses a specific question to the User.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CERTIFICATE_ID	Character(10)	VARCHAR2(10) NOT NULL	The CERTIFICATE_ID is the unique identifier for a Certificate definition. Prompt Table: CERTIFICATE
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	QUESTION_NUM	Number(3,0)	SMALLINT NOT NULL	The QUESTION_NUM provides a unique value for each question on a Certificate.
4	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	QUESTION_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	The QUESTION_TYPE_CD specifies the display format and structure for a Question. M=Multiple Choice R=Rating Y=Yes / No Default Value: Y
6	QUESTION_WEIGHT	Number(3,0)	SMALLINT NOT NULL	The QUESTION_WEIGHT specifies the weighting values that is to be applied for a Question.
7	QUESTION_STMT_TEXT	Character(100)	VARCHAR2(100) NOT NULL	The QUESTION_STMT_TEXT string defines the text value to be presented on the Certificate page that poses a specific question to the User.