WCS_QB_SCH_VW

(SQL View)
Index Back

SELECT EQRY_COMBO_NAME ,EQRY_ORIG_CLASSID ,DESCR FROM PS_EQRY_COMBO_DEF WHERE EQRY_ORIG_CLASSID = 'JOB_HISTORY'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EQRY_COMBO_NAME Character(20) VARCHAR2(20) NOT NULL Output/criteria combination
2 EQRY_ORIG_CLASSID Character(12) VARCHAR2(12) NOT NULL Target class ID when query was saved

Prompt Table: HCMD_META_TBL

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