GPFR_DA_6_SRCH

(SQL View)
 Index Back

Extract Data by Establishment

DADS related view: access to the extracted data by establishment.

SELECT A.GPFR_DA_SNDREF ,A.GPFR_DA_RECIP , A.GPFR_DA_COMPANY , A.GPFR_DA_ESTAB FROM PS_GPFR_DA_DAT A , PS_ESTAB_TBL B WHERE A.GPFR_DA_SNDREF <> ' ' AND A.GPFR_DA_COMPANY <> ' ' AND A.GPFR_DA_EMPLID = ' ' AND A.GPFR_DA_BGNDT IS NULL AND A.GPFR_DA_ENDDT IS NULL AND A.GPFR_DA_FEEREF = ' ' AND A.GPFR_DA_ESTAB <> ' ' AND A.GPFR_DA_COMPANY = B.COMPANY AND A.GPFR_DA_ESTAB = B.ESTABID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPFR_DA_SNDREF Character(10) VARCHAR2(10) NOT NULL DADS related field

Prompt Table: GPFR_DA_SNDREF

2 GPFR_DA_RECIP Character(10) VARCHAR2(10) NOT NULL DADS related field

Prompt Table: GPFR_DA_1_SRCH

3 GPFR_DA_COMPANY Character(3) VARCHAR2(3) NOT NULL DADS related field

Prompt Table: GPFR_DA_2_SRCH

4 GPFR_DA_ESTAB Character(12) VARCHAR2(12) NOT NULL DADS related field

Prompt Table: GPFR_DA_6_SRCH