RESPONSE_LANG (SQL Table)	Index Back
Response Definition RESPONSE is a record that defines the format and structure of the response to a specific question that is presented as part of a Certificate

RESPONSE_LANG

(SQL Table)

Response Definition

RESPONSE is a record that defines the format and structure of the response to a specific question that is presented as part of a Certificate

Related Language Record for RESPONSE

# 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 RESPONSE_NUM Number(3,0) SMALLINT NOT NULL The RESPONSE_NUM provides a unique value for each response on a Certificate's Question.

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

6 RESPONSE_LBL_TEXT Character(20) VARCHAR2(20) NOT NULL The RESPONSE_LBL_TEXT string specifies the text value to be presented for the Response control on a Certificate's 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	RESPONSE_NUM	Number(3,0)	SMALLINT NOT NULL	The RESPONSE_NUM provides a unique value for each response on a Certificate's Question.
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	RESPONSE_LBL_TEXT	Character(20)	VARCHAR2(20) NOT NULL	The RESPONSE_LBL_TEXT string specifies the text value to be presented for the Response control on a Certificate's Question.