EOQF_SMART_ANS_IDEOQF_CATEGORYPrompt Table: EOQF_CAT_TBL
EOQF_QSTNR_CODELANGUAGE_CDEOQF_SAN_USE_LN(SQL View) |
Index Back |
|---|---|
Answer Use ViewAnswer Use |
| SELECT DISTINCT A.EOQF_SMART_ANS_ID ,A.EOQF_CATEGORY , A.EOQF_QSTNR_CODE , B.LANGUAGE_CD , B.EOQF_QSTNR_NAME FROM PS_EOQF_QQSTN_TBL A , PS_EOQF_QSTNR_LANG B , PS_EOQF_SMANS_LNG C WHERE A.EOQF_QSTNR_CODE = B.EOQF_QSTNR_CODE AND C.EOQF_SMART_ANS_ID = A.EOQF_SMART_ANS_ID AND B.LANGUAGE_CD = C.LANGUAGE_CD |
| # | 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_CATEGORY |
Character(30) | VARCHAR2(30) NOT NULL |
Category Field
Prompt Table: EOQF_CAT_TBL |
| 3 | EOQF_QSTNR_CODE |
Character(30) | VARCHAR2(30) NOT NULL | Questionnaire Code |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | EOQF_QSTNR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Questionnaire Name |