EODP_QRY_FLDUSE (SQL Table)	Index Back
Use type for fields Data Privacy Framework: Table which stores the way field is used in a query

EODP_QRY_FLDUSE

(SQL Table)

Use type for fields

Data Privacy Framework: Table which stores the way field is used in a query

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EODP_OPRID Character(30) VARCHAR2(30) NOT NULL Sensitive Data Framework: UserID

2 EODP_QUERYNAME Character(30) VARCHAR2(30) NOT NULL Query Name Field

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

5 EODP_QRY_USETYPE Character(1) VARCHAR2(1) NOT NULL Added new Translate value for Order by References Field for finding whether query field exists in select or where clause
O=OrderBy
S=Select
W=Where

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EODP_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Sensitive Data Framework: UserID
2	EODP_QUERYNAME	Character(30)	VARCHAR2(30) NOT NULL	Query Name Field
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	EODP_QRY_USETYPE	Character(1)	VARCHAR2(1) NOT NULL	Added new Translate value for Order by References Field for finding whether query field exists in select or where clause O=OrderBy S=Select W=Where