PASTDUE_SUM_VW

(SQL View)
Index Back

Past Due Itens

Past Due Itens

SELECT I.OPRID , I.SETID , I.RESP_PART , ' ' , COUNT(*) FROM PS_PASTD_OP_SUM_VW I GROUP BY I.OPRID , I.SETID , I.RESP_PART

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 RESP_PART Character(15) VARCHAR2(15) NOT NULL Responsible Party
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 COUNT_LINES Number(15,0) DECIMAL(15) NOT NULL Count of Lines