SPEEDCHART_VW

(SQL View)
 Index Back

Prompt for SpeedCharts


SELECT a.setid , b.oprid , b.oprclass , a.speedchart_key , a.effdt , a.eff_status , a.descr FROM ps_speedchart_hdr a , PSOPRDEFN b WHERE (a.oprid = b.oprid OR a.oprid = ' ') AND (a.oprclass = b.oprclass OR a.oprclass = ' ') AND a.effdt = ( SELECT MAX(i.effdt) FROM ps_speedchart_hdr i WHERE i.setid = a.setid AND i.speedchart_key = a.speedchart_key AND i.oprid = a.oprid AND i.oprclass = a.oprclass AND i.effdt <= %CurrentDateIn AND i.eff_status = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 USER_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
3 USER_OPRCLASS Character(30) VARCHAR2(30) NOT NULL User Operator Class
4 SPEEDCHART_KEY Character(10) VARCHAR2(10) NOT NULL SpeedChart Key
5 EFFDT Date(10) DATE Effective Date
6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description