RY_EXT_ACT_PRMT (SQL View)	Index Back
VC Extension view VC Extension view for those Extensions, which allow be used in the document.

RY_EXT_ACT_PRMT

(SQL View)

VC Extension view

VC Extension view for those Extensions, which allow be used in the document.

SELECT RY_VC_TYPE_ID , RY_NAME254 , RY_IMPL_TYPE FROM PS_RY_VC_TYPE A WHERE A.DEVELOPER = 'U' AND A.RY_VC_TYPE_STATUS = 'A' AND A.RY_IMPL_TYPE = 'J' AND A.RY_ALLOW_DOC_ELEM = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RY_VC_TYPE_ID Number(18,0) DECIMAL(18) NOT NULL Custom Variable Contentt Type ID.

2 RY_NAME254 Character(254) VARCHAR2(254) NOT NULL 254 character name field for names.

3 RY_IMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Field used by Online Marketing.
J=Java
P=People Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RY_VC_TYPE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Custom Variable Contentt Type ID.
2	RY_NAME254	Character(254)	VARCHAR2(254) NOT NULL	254 character name field for names.
3	RY_IMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Field used by Online Marketing. J=Java P=People Code