AGC_SRCH_SFK_VW (SQL View)	Index Back
AGC Search Source Field View Actiivty Guide Composer Search Source Foreign Key View returns non-key fields that have a prompt table.

AGC_SRCH_SFK_VW

(SQL View)

AGC Search Source Field View

Actiivty Guide Composer Search Source Foreign Key View returns non-key fields that have a prompt table.

SELECT A.RECNAME , A.FIELDNAME , C.LONGNAME , A.USEEDIT FROM PSRECFIELDDB A , PSDBFIELD B , PSDBFLDLABL C WHERE %Sql(EOCF_BITAND_ALL_PLATFORMS, A.USEEDIT, 1) <> 1 AND A.FIELDNAME NOT IN ('LASTUPDOPRID', 'EFF_STATUS') AND B.FIELDNAME = A.FIELDNAME AND B.FIELDTYPE = 0 AND C.FIELDNAME = A.FIELDNAME AND C.DEFAULT_LABEL = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AGC_SRCH_SRC_TBL Character(15) VARCHAR2(15) NOT NULL Activity Guide Composer Search Source Table

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

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

4 USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AGC_SRCH_SRC_TBL	Character(15)	VARCHAR2(15) NOT NULL	Activity Guide Composer Search Source Table
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
3	LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name
4	USEEDIT	Number(10,0)	DECIMAL(10) NOT NULL	Field Use and Edit Flags- USEEDIT reference