GPFR_AF_RUNSRCH

(SQL View)
 Index Back

Search record for Extr Defn

Application Framework - This record is used as a search view for Extraction definition component

SELECT A.GPFR_AF_EXTRACT_ID , B.DESCR , A.COUNTRY , A.GPFR_AF_APPL , A.GPFR_AF_NODE_SET FROM PS_GPFR_AF_RUN_DFN A , PS_GPFR_AF_RUN_LNG B WHERE A.GPFR_AF_EXTRACT_ID = B.GPFR_AF_EXTRACT_ID UNION SELECT A.GPFR_AF_EXTRACT_ID , A.DESCR , A.COUNTRY , A.GPFR_AF_APPL , A.GPFR_AF_NODE_SET FROM PS_GPFR_AF_RUN_DFN A WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPFR_AF_RUN_LNG B WHERE A.GPFR_AF_EXTRACT_ID = B.GPFR_AF_EXTRACT_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPFR_AF_EXTRACT_ID Character(18) VARCHAR2(18) NOT NULL Application Framework - Extraction ID

Prompt Table: GPFR_AF_RUN_DFN

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

4 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application

Prompt Table: GPFR_AF_APPL

5 GPFR_AF_NODE_SET Character(16) VARCHAR2(16) NOT NULL Application Framework - Node Set

Prompt Table: GPFR_AF_NTSR_VW