Creating Prompt Edit Transaction Views for REG_REGION

Because there are two types of transactions in PeopleSoft Human Resources (STANDARD for employee transactions and HANDS for Health and Safety transactions), there are two different prompt views for those transactions. When you add a transaction to your system, you include a new prompt view that can be built from the views that are included in the system.

REG_STANDARD_VW

SELECT   

S.OPRID,  

R.REG_REGION,  

R.DESCR50, 

R.COUNTRY  

FROM PS_REG_REGION_TBL R,             

      PS_REG_TRX_REGION  T,            

      PSOPRDEFN S  

WHERE T.REG_TRX = 'STANDARD'      

AND T.REG_REGION =   R.REG_REGION

      AND (R.REG_AVAIL = 'ALL' 

          OR (R.REG_AVAIL = 'GBL' 

              AND S.OPRID = (SELECT OPRID FROM PS_SCRTY_TBL_GBL G

              WHERE S.OPRID = G.OPRID  

              AND G.COUNTRY = R.COUNTRY)))

REG_HANDS_VW

SELECT   

S.OPRID,  

R.REG_REGION,  

R.DESCR50, 

R.COUNTRY  

FROM PS_REG_REGION_TBL R,             

      PS_REG_TRX_REGION  T,            

      PSOPRDEFN S  

WHERE T.REG_TRX = 'HANDS'      

AND T.REG_REGION =   R.REG_REGION

      AND (R.REG_AVAIL = 'ALL' 

          OR (R.REG_AVAIL = 'GBL' 

              AND S.OPRID = (SELECT OPRID FROM PS_SCRTY_TBL_GBL G

              WHERE S.OPRID = G.OPRID  

              AND G.COUNTRY = R.COUNTRY)))

Note:

You can create new transaction views by doing a Save As and changing the hard-coded transaction name.