RS_TMPLTSRCH_VW

(SQL View)
Index Back

TMPL SRCH View

TMPL search view

SELECT A.BUSINESS_UNIT , A.SO_ID , A.ENTERED_BY FROM PS_RS_SO_TMPLT A

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

2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
3 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by

Prompt Table: OPRID_VW