INQ_CRIT_CF_HDR

(SQL View)
Index Back

Inq Criteria - Journal CFs


select oprid, inquiry, field_sequence, chartfield, chartfield_value, shortname from PS_INQ_CRIT_CF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 INQUIRY Character(10) VARCHAR2(10) NOT NULL Inquiry Name
3 FIELD_SEQUENCE Number(3,0) SMALLINT NOT NULL Field Sequence Number
4 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
5 CHARTFIELD_VALUE Character(30) VARCHAR2(30) NOT NULL ChartField Value
6 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name