RS_MYRECS_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , B.DESCR , A.EMPLID , B.START_DT , B.END_DT , B.PROJ_ROLE , B.SO_LINE_STATUS , 'REC' FROM %Table(RS_SO_LINE_REC) A , %Table(RS_SO_LINE) B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND A.SO_LINE = B.SO_LINE AND NOT EXISTS ( SELECT 'X' FROM %Table(RS_ASSIGNMENT) AA WHERE AA.BUSINESS_UNIT = A.BUSINESS_UNIT AND AA.SO_ID = A.SO_ID AND AA.SO_LINE = A.SO_LINE AND AA.EMPLID = A.EMPLID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 START_DT Date(10) DATE Start Date
7 END_DT Date(10) DATE End Date
8 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
9 SO_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
A=Closed
C=Cancel
O=Open
10 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2