SPF_WO_SUR_USR

(SQL Table)
Index Back

sPro WO Survey Users

This record stores the recipient list for the Work Order Performance Survey

# 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_SVTYP_VW

4 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

Prompt Table: SPF_WOSURUSR_VW

5 SP_SUR_FILL_STATUS Character(1) VARCHAR2(1) NOT NULL Survey Completion Status
C=Cancelled
D=Completed
I=In Process
N=Not Started

Default Value: N

6 NOTIFY_DATE Date(10) DATE Notification Date
7 COMPL_BY_USERID Character(30) VARCHAR2(30) NOT NULL Completed by User ID
8 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time

Default Value: %DateTime

9 ROW_MODIFY_DATE DateTime(26) TIMESTAMP Modified Date Time

Default Value: %DateTime

10 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
11 ROW_MODIFY_USER Character(30) VARCHAR2(30) NOT NULL Modified User