CONVR_RVW_DT_VW (SQL View)	Index Back
Convers by Review Date

CONVR_RVW_DT_VW

(SQL View)

Convers by Review Date

SELECT A.review_next_dt , A.review_oprid , C.setid , C.cust_id , C.conver_dt , C.conver_seq_num FROM PS_CUST_CONVER_HDR A , PS_Cust_Conver C WHERE A.SETID = C.SETID AND A.CUST_ID = C.CUST_ID AND A.CONVER_DTTM_INIT = C.CONVER_DTTM_INIT AND A.CONVER_DT = C.CONVER_DT AND A.review_comp = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REVIEW_NEXT_DT Date(10) DATE Next Review Date

2 REVIEW_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

4 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUST_SRCH_VW

5 CONVER_DT Date(10) DATE Conversation Date

6 CONVER_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REVIEW_NEXT_DT	Date(10)	DATE	Next Review Date
2	REVIEW_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
4	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUST_SRCH_VW
5	CONVER_DT	Date(10)	DATE	Conversation Date
6	CONVER_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Conversation Sequence Number