GL_PE_FLD

(SQL Table)
Index Back

GL Pagelet Field values

GL Pagelet Field values

# 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 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: %EDITTABLE2

4 VALUE_BY Character(1) VARCHAR2(1) NOT NULL Select value by
D=Detailed single value
S=By chartfield Value Set
5 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value

Prompt Table: %EDITTABLE

6 SHOW_DETAIL Character(1) VARCHAR2(1) NOT NULL Show Detail Values
N=No Detail
Y=Show Detail