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

QUESTION_LANG

(SQL Table)

Question - Related Language

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 for QUESTION

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	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.