RYEVC_USAGETYPE (SQL Table)	Index Back
VC Use Types VC Use Types - Links a Usage context to specific VC Types

RYEVC_USAGETYPE

(SQL Table)

VC Use Types

VC Use Types - Links a Usage context to specific VC Types

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 USAGE_ID Number(5,0) INTEGER NOT NULL Usage ID

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

3 ORDER_NBR Number(3,0) SMALLINT NOT NULL Order Number

4 USAGE_CODE Character(3) VARCHAR2(3) NOT NULL Usage

5 CLASS_NAME_1 Character(80) VARCHAR2(80) NOT NULL Class Name

6 SHOW_ADAPTER Character(1) VARCHAR2(1) NOT NULL SHOW_ADAPTER - when 'Y', call the Show method, when 'N' call the Apply method
N=No
Y=Yes
Default Value: Y

7 RY_ELEM_RESTRICT Character(254) VARCHAR2(254) NOT NULL VC usage restriction for element type

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	USAGE_ID	Number(5,0)	INTEGER NOT NULL	Usage ID
2	RY_VC_TYPE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Custom Variable Contentt Type ID.
3	ORDER_NBR	Number(3,0)	SMALLINT NOT NULL	Order Number
4	USAGE_CODE	Character(3)	VARCHAR2(3) NOT NULL	Usage
5	CLASS_NAME_1	Character(80)	VARCHAR2(80) NOT NULL	Class Name
6	SHOW_ADAPTER	Character(1)	VARCHAR2(1) NOT NULL	SHOW_ADAPTER - when 'Y', call the Show method, when 'N' call the Apply method N=No Y=Yes Default Value: Y
7	RY_ELEM_RESTRICT	Character(254)	VARCHAR2(254) NOT NULL	VC usage restriction for element type