GPFR_DA_SNDREFPrompt Table: GPFR_DA_SNDREF
GPFR_DA_RECIPPrompt Table: GPFR_DA_1_SRCH
GPFR_DA_COMPANYPrompt Table: GPFR_DA_2_SRCH
GPFR_DA_EMPLIDPrompt Table: GPFR_DA_3_SRCH
GPFR_DA_BGNDTGPFR_DA_ENDDTGPFR_DA_4_SRCH(SQL View) |
Index Back |
|---|---|
Extract Data by EE SituationDADS related view: access to the extracted data by employee situation. |
| SELECT GPFR_DA_SNDREF ,GPFR_DA_RECIP , GPFR_DA_COMPANY , GPFR_DA_EMPLID , GPFR_DA_BGNDT , GPFR_DA_ENDDT FROM PS_GPFR_DA_DAT WHERE GPFR_DA_SNDREF <> ' ' AND GPFR_DA_COMPANY <> ' ' AND GPFR_DA_EMPLID <> ' ' AND GPFR_DA_BGNDT IS NOT NULL AND GPFR_DA_ENDDT IS NOT 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_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_EMPLID |
Character(16) | VARCHAR2(16) NOT NULL |
DADS related field
Prompt Table: GPFR_DA_3_SRCH |
| 5 | GPFR_DA_BGNDT |
Date(10) | DATE | DADS related field |
| 6 | GPFR_DA_ENDDT |
Date(10) | DATE | DADSD related field |