KK_PC_SEL

(SQL Table)
Index Back

Chartfield Value Selector

CF selector table used in CC inquiry pages to support parent/child. Budget Details: INQUIRY_ID = 001 Budgets Overview: INQUIRY_ID = 002

# 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_ID Character(3) VARCHAR2(3) NOT NULL Inquiry ID
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 RANGE_FROM Character(30) VARCHAR2(30) NOT NULL Lower boundary for detail value that contains a range of values
5 RANGE_TO Character(30) VARCHAR2(30) NOT NULL Upper boundary for detail value that contains a range of values