INQ_CRIT_CF_TRN

(SQL View)
 Index Back

Inq Criteria - Transaction CFs


SELECT OPRID , INQUIRY , FIELD_SEQUENCE , CHARTFIELD , CHARTFIELD_VALUE , SHORTNAME , RECNAME_NO_EFFDT , CFV_SET ,SUM_BY_SW ,VALUE_REQUIRED , ORDERBYNUM 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

Prompt Table: %EDITTABLE2

6 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
7 RECNAME_NO_EFFDT Character(15) VARCHAR2(15) NOT NULL View - No Effective Date
8 CFV_SET Character(20) VARCHAR2(20) NOT NULL ChartField Value Set
9 SUM_BY_SW Character(1) VARCHAR2(1) NOT NULL Sum By

Y/N Table Edit

10 VALUE_REQUIRED Character(1) VARCHAR2(1) NOT NULL Value Required
N=Not Required
O=Optional
Y=Required
11 ORDERBYNUM Number(3,0) SMALLINT NOT NULL Order-By Number