RS_SO_BIDREC_VW

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.DESCR , A.EMPLID , C.NAME , A.START_DT , A.END_DT , A.PROJ_ROLE , A.DESCR2 FROM PS_RS_MYBIDS_VW A , PS_PERSONAL_DATA C WHERE A.EMPLID = C.EMPLID UNION SELECT B.BUSINESS_UNIT , B.SO_ID , B.SO_LINE , B.DESCR , B.EMPLID , D.NAME , B.START_DT , B.END_DT , B.PROJ_ROLE , B.DESCR2 FROM PS_RS_SO_RECOM_VW B , PS_PERSONAL_DATA D WHERE B.EMPLID = D.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 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 START_DT Date(10) DATE Start Date
8 END_DT Date(10) DATE End Date
9 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
10 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2