RS_SOSTAT_VW (SQL View)	Index Back
Service Order Status View Used to provide SO information for the Service Order Component Search View. SUJ--This view is modified for Resource Management to list only RS requests.

RS_SOSTAT_VW

(SQL View)

Service Order Status View

Used to provide SO information for the Service Order Component Search View. SUJ--This view is modified for Resource Management to list only RS requests.

SELECT A.BUSINESS_UNIT , A.SO_ID , AC.SETID , A.CUST_ID , B.SO_STATUS , A.ENTERED_BY , A.ASSIGNED_TO , A.PROJECT_ID , A.DESCR60 FROM %Table(RS_SO_HDR) A , %Table(RS_SO_STATUS) B , %Table(SET_CNTRL_REC) AC WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND A.SYSTEM_SOURCE = 'RS' AND B.LASTUPDDTTM = ( SELECT MAX(BB.LASTUPDDTTM) FROM PS_RS_SO_STATUS BB WHERE B.BUSINESS_UNIT = BB.BUSINESS_UNIT AND B.SO_ID = BB.SO_ID) AND AC.SETCNTRLVALUE = A.BUSINESS_UNIT AND AC.RECNAME = 'CUSTOMER' AND A.EXPRESS_SEARCH_FLG = 'N'

# 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
Default Value: NEXT

3 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

4 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Default Value: CUSTOMER.CUST_ID
Prompt Table: CUSTOMER_FS

5 SO_STATUS Character(1) VARCHAR2(1) NOT NULL Service Order Status
C=Closed
D=Draft
I=In Process
N=New
O=Open
X=Canceled

6 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
Prompt Table: OPRID_VW

7 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To
Prompt Table: RS_OPR_NAME_VW

8 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: SP_PROJ_NONVW

9 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

#	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 Default Value: NEXT
3	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
4	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Default Value: CUSTOMER.CUST_ID Prompt Table: CUSTOMER_FS
5	SO_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Service Order Status C=Closed D=Draft I=In Process N=New O=Open X=Canceled
6	ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered by Prompt Table: OPRID_VW
7	ASSIGNED_TO	Character(30)	VARCHAR2(30) NOT NULL	Assigned To Prompt Table: RS_OPR_NAME_VW
8	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: SP_PROJ_NONVW
9	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description