RC_CM_PTYPE_VW (SQL View)	Index Back
Contact Method Purpose Type This View is clone of CM_PURP_TYPE_VW. Contact Method Purpose Type. This Record is created to display Purpose Type Descr has non-required in RC_CASE_CONT_INFO Page. Otherwise this view is same as CM_PURP_TYPE_VW.

RC_CM_PTYPE_VW

(SQL View)

Contact Method Purpose Type

This View is clone of CM_PURP_TYPE_VW. Contact Method Purpose Type. This Record is created to display Purpose Type Descr has non-required in RC_CASE_CONT_INFO Page. Otherwise this view is same as CM_PURP_TYPE_VW.

SELECT A.CM_TYPE_ID , A.CM_PURPOSE_TYPE_ID , A.DESCR , A.DESCRSHORT FROM PS_CM_PURP_TYPE A

Related Language Record: CM_PURP_TYP_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID
Prompt Table: CM_TYPE

2 CM_PURPOSE_TYPE_ID Number(6,0) INTEGER NOT NULL Relationship Contact Method Purpose ID
Default Value: 999999

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: CM_PURP_TYPE.DESCR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CM_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Contact Method Type ID Prompt Table: CM_TYPE
2	CM_PURPOSE_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Relationship Contact Method Purpose ID Default Value: 999999
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: CM_PURP_TYPE.DESCR