EX_PRJ_PRJ_VW1

(SQL View)
 Index Back

Projects for Traveler EC VW

This is the view used to create the projects used as control data in the mobile client.

SELECT DISTINCT 'EXPROJPROJ' , A.BUSINESS_UNIT ,B.DESCR , 0 , 'O' ,A.PROJECT_ID ,'A' FROM PS_PROJ_ACTIVITY A ,PS_PROJECT B ,PS_INSTALLATION C WHERE A.PROJECT_ID = B.PROJECT_ID AND C.PC = 'Y' AND A.EFF_STATUS = 'A' AND B.EFF_STATUS = 'A' AND B.SUMMARY_PRJ = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
5 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
6 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
7 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups