AP_SEARCH_FLDVW

(SQL View)
Index Back

SELECT B.FIELDNAME , B.LABEL_ID , C.LONGNAME FROM PS_AP_SEARCH_LIST B , PSDBFLDLABL C WHERE B.FIELDNAME = C.FIELDNAME AND B.LABEL_ID = C.LABEL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: PSDBFIELD

2 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

Prompt Table: AP_FLD_LABEL_VW

3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name