SP_SUR_QUESTN(SQL Table) |
Index Back |
---|---|
Survey QuestionsAssociate Questions to a Survey |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
2 | SP_SURVEY_ID | Character(18) | VARCHAR2(18) NOT NULL |
sPro Work Order Survey Identifier
Prompt Table: SP_SUR_DEFN |
3 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
4 | SP_SUR_QUESTN | Character(254) | VARCHAR2(254) NOT NULL | s |
5 | SP_SUR_RESTYP_ID | Character(18) | VARCHAR2(18) NOT NULL |
Response Type ID
Prompt Table: SP_SUR_RESTYP |
6 | SP_ALLOW_COMMENTS | Character(1) | VARCHAR2(1) NOT NULL |
Allow Comments
N=No Y=Yes Y/N Table Edit Default Value: N |