PR_CONVER_VW

(SQL View)
 Index Back

Conversation View

Conversation View

SELECT A.CONVER_SEQ_NUM , A.CONVER_HDR_SEQ_NUM , B.CONVER_LN_SEQ_NUM , A.KEY1_FLDNAME , A.KEY1_FLD_VAL , A.CONVER_HDR_DTTM , A.CONVER_TOPIC , A.OPRID_FROM , A.OPRID_TO , B.OPRID , B.CONVER_LN_DTTM FROM PS_PR_CONVER_HDR A , PS_PR_CONVER_LINE B , PS_PR_REQUEST R WHERE A.CONVER_SEQ_NUM = B.CONVER_SEQ_NUM AND A.KEY1_FLDNAME = B.KEY1_FLDNAME AND A.KEY1_FLD_VAL = B.KEY1_FLD_VAL AND A.KEY1_FLD_VAL = R.REQUEST_ID AND A.CONVER_HDR_SEQ_NUM = B.CONVER_HDR_SEQ_NUM AND B.CONVER_LN_SEQ_NUM = ( SELECT MAX(C1.CONVER_LN_SEQ_NUM) FROM PS_PR_CONVER_LINE C1 WHERE C1.CONVER_SEQ_NUM = B.CONVER_SEQ_NUM AND C1.KEY1_FLDNAME = B.KEY1_FLDNAME AND C1.KEY1_FLD_VAL = B.KEY1_FLD_VAL AND C1.CONVER_HDR_SEQ_NUM = B.CONVER_HDR_SEQ_NUM )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONVER_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Sequence Number
2 CONVER_HDR_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Header Sequence Number
3 CONVER_LN_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Sequence Number
4 KEY1_FLDNAME Character(18) VARCHAR2(18) NOT NULL Key 1 Field Name
5 KEY1_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 1 Field Value
6 CONVER_HDR_DTTM DateTime(26) TIMESTAMP Conversation Datetime
7 CONVER_TOPIC Character(30) VARCHAR2(30) NOT NULL Conversation Topic
8 OPRID_FROM Character(30) VARCHAR2(30) NOT NULL A user's ID
9 OPRID_TO Character(30) VARCHAR2(30) NOT NULL A user's ID
10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
11 CONVER_LN_DTTM DateTime(26) TIMESTAMP Conversation Datetime