SCD_QUESTION_IDDefault Value: NEXT
AV=Available
NA=Not Available
PE=Pending
SCD_ADD_QUES_VW(SQL View) |
Index Back |
|---|---|
Questions Add ViewQuestions Add View - used by Questions Pivot Grid for adding new Questions |
| SELECT SCD_QUESTION_ID , SCD_QUESTION_GROUP , SCD_QUESTN_STATUS , SCD_QUESTION_TEXT FROM PS_SCD_QUESTIONS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCD_QUESTION_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Question ID
Default Value: NEXT |
| 2 | SCD_QUESTION_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Question Group |
| 3 | SCD_QUESTN_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Question Status
AV=Available NA=Not Available PE=Pending |
| 4 | SCD_QUESTION_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Question Text |