EQRY_OUTPUT_DEF (SQL Table)	Index Back
eQuery Output Column selection eQuery Output Column selection

EQRY_OUTPUT_DEF

(SQL Table)

eQuery Output Column selection

Related Language Record: EQRY_OUTPUT_LNG

Parent Record Of EQRY_OUTPUT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EQRY_OUTPUT_NAME Character(20) VARCHAR2(20) NOT NULL Output definition name

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 EQRY_ORIG_CLASSID Character(12) VARCHAR2(12) NOT NULL Target class ID when query was saved

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

5 PRIVATE_QUERY_FLAG Character(1) VARCHAR2(1) NOT NULL Yes/No Flag to indicate if its a private query
Default Value: Y

6 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EQRY_OUTPUT_NAME	Character(20)	VARCHAR2(20) NOT NULL	Output definition name
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	EQRY_ORIG_CLASSID	Character(12)	VARCHAR2(12) NOT NULL	Target class ID when query was saved
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	PRIVATE_QUERY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Flag to indicate if its a private query Default Value: Y
6	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Y/N Table Edit