GPFR_DA_5_SRCH

(SQL View)
 Index Back

Extract Data by Fee

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

SELECT GPFR_DA_SNDREF , GPFR_DA_COMPANY , GPFR_DA_FEEREF FROM PS_GPFR_DA_DAT WHERE GPFR_DA_SNDREF <> ' ' AND GPFR_DA_COMPANY <> ' ' AND GPFR_DA_EMPLID = ' ' AND GPFR_DA_BGNDT IS NULL AND GPFR_DA_ENDDT IS NULL AND GPFR_DA_FEEREF <> ' ' AND GPFR_DA_ESTAB = ' '

# 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_COMPANY Character(3) VARCHAR2(3) NOT NULL DADS related field

Prompt Table: GPFR_DA_COMREF

3 GPFR_DA_FEEREF Character(20) VARCHAR2(20) NOT NULL DADS related field