GPFR_DA_4S_SRCH

(SQL View)
 Index Back

Extract Data by EE Situation

DADS related view: access to the extracted data by employee situation.

SELECT SEC.OPRID , A.GPFR_DA_SNDREF ,A.GPFR_DA_RECIP , A.GPFR_DA_COMPANY , A.GPFR_DA_EMPLID , A.GPFR_DA_BGNDT , A.GPFR_DA_ENDDT FROM PS_GPFR_DA_DAT A , PS_PERS_SRCH_GBL SEC WHERE A.EMPLID = SEC.EMPLID AND A.GPFR_DA_SNDREF <> ' ' AND A.GPFR_DA_COMPANY <> ' ' AND A.GPFR_DA_EMPLID <> ' ' AND A.GPFR_DA_BGNDT IS NOT NULL AND A.GPFR_DA_ENDDT IS NOT NULL AND A.GPFR_DA_FEEREF = ' ' AND A.GPFR_DA_ESTAB = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 GPFR_DA_SNDREF Character(10) VARCHAR2(10) NOT NULL DADS related field

Prompt Table: GPFR_DA_SNDREF

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

Prompt Table: GPFR_DA_1_SRCH

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

Prompt Table: GPFR_DA_2_SRCH

5 GPFR_DA_EMPLID Character(16) VARCHAR2(16) NOT NULL DADS related field

Prompt Table: GPFR_DA_3S_SRCH

6 GPFR_DA_BGNDT Date(10) DATE DADS related field
7 GPFR_DA_ENDDT Date(10) DATE DADSD related field