BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_SP_NONVW
WORK_ORDER_IDPrompt Table: SPF_WORDERREC
SP_SURVEY_IDPrompt Table: SP_SUR_DEFN
USERIDPrompt Table: PSOPRDEFN
SEQNBRPrompt Table: SP_SUR_RESVAL
SPF_WO_SUR_USRS(SQL Table) |
Index Back |
|---|---|
Survey Work Order User ResponsPerformance Work Order Survey Responses by User |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_SP_NONVW |
| 2 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Work Order ID
Prompt Table: SPF_WORDERREC |
| 3 | SP_SURVEY_ID |
Character(18) | VARCHAR2(18) NOT NULL |
sPro Work Order Survey Identifier
Prompt Table: SP_SUR_DEFN |
| 4 | USERID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID
Prompt Table: PSOPRDEFN |
| 5 | SEQNBR |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 6 | SP_SUR_RESANSW | Character(50) | VARCHAR2(50) NOT NULL |
Response Value Text (Answer)
Prompt Table: SP_SUR_RESVAL |
| 7 | COMMENTS | Long Character | CLOB | Comment |