CERTIFICATE_IDPrompt Table: CERTIFICATE
EFFDTDefault Value: %date
QUESTION_NUMRESPONSE_NUMDefault Value: 0
RESPONSE(SQL Table) |
Index Back |
|---|---|
Response DefinitionRESPONSE is a record that defines the format and structure of the response to a specific question that is presented as part of a Certificate |
| # | 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 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 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. |
| 7 | RESPONSE_VALUE | Number(3,0) | SMALLINT NOT NULL |
The RESPONSE_VALUE specifies the value to be associated with the Response if selected by the User as the desired answer to a Certificate's Question.
Default Value: 0 |