EOQF_SMART_ANS_IDEOQF_ANS_IDPrompt Table: EOQF_ANS_PT_VW
LANGUAGE_CDEOQF_ANS_PRM_LN(SQL View) |
Index Back |
|---|---|
Answer PoolAnswer Pool |
| SELECT B.EOQF_SMART_ANS_ID , A.EOQF_ANS_ID , A.LANGUAGE_CD , A.EOQF_ANSWER_TXT FROM PS_EOQF_ANSWER_LNG A , PS_EOQF_SMANS_MAP B WHERE A.EOQF_ANS_ID = B.EOQF_ANS_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOQF_SMART_ANS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Smart Answer Id |
| 2 | EOQF_ANS_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Answer ID
Prompt Table: EOQF_ANS_PT_VW |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EOQF_ANSWER_GRD | Character(254) | VARCHAR2(254) NOT NULL | Answer |