GPFR_DA_BSIT_VW

(SQL View)
 Index Back

Begin Situation Code

DADS related record: returns begin situation codes

SELECT A.GPFR_DA_SNDREF , A.GPFR_DA_COMPANY , A.GPFR_DA_EMPLID , A.GPFR_DA_BGNDT , A.GPFR_DA_RECORD , A.GPFR_DA_CODE , B.GPFR_DA_DESCR FROM PS_GPFR_DA_DAT_RC A , PS_GPFR_DA_CODE B WHERE A.GPFR_DA_STRUCT = 'S41.G01.00' AND A.GPFR_DA_RECORD IN ('002.001','002.002','002.003','002.004','002.005') AND B.GPFR_DA_DATTYP = 'STREAS' AND A.GPFR_DA_CODE = B.GPFR_DA_CODE AND B.GPFR_DA_STATUS = 'A'

  • Related Language Record: GPFR_DA_BSTILNG

    • # 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 GPFR_DA_EMPLID Character(16) VARCHAR2(16) NOT NULL DADS related field
    4 GPFR_DA_BGNDT Date(10) DATE DADS related field
    5 GPFR_DA_RECORD Character(10) VARCHAR2(10) NOT NULL DADS related record
    6 GPFR_DA_CODE Character(10) VARCHAR2(10) NOT NULL DADS related field
    7 GPFR_DA_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field