GPFR_DA_3A_SRCH

(SQL View)
Index Back

Extract Data by Employee

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

SELECT A.GPFR_DA_SNDREF , A.GPFR_DA_COMPANY , B.EMPLID , B.EMPL_RCD , A.GPFR_DA_EMPLID FROM PS_GPFR_DA_DAT A , PS_PER_ORG_ASGN B 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 = ' ' AND B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD

# 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: COMPANY_TBL

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
5 GPFR_DA_EMPLID Character(16) VARCHAR2(16) NOT NULL DADS related field