GPFR_DA_REC_VW1

(SQL View)
 Index Back

Struct Rcd Defn

DADS related record: to retrieve structure record definition.

SELECT A.GPFR_DA_STRUCT , A.GPFR_DA_RECORD , A.GPFR_DA_DESCR FROM PS_GPFR_DA_RECORD A WHERE A.GPFR_DA_CUSTOM <> 'C' AND A.GPFR_DA_DATSRC IN ('0','1','2','3','4','5','8','9') AND NOT EXISTS ( SELECT 'X' FROM PS_GPFR_DA_PIN_CST WHERE GPFR_DA_STRUCT = A.GPFR_DA_STRUCT AND GPFR_DA_RECORD = A.GPFR_DA_RECORD)

  • Related Language Record: GPFR_DA_RLNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPFR_DA_STRUCT Character(10) VARCHAR2(10) NOT NULL DADS related field
    2 GPFR_DA_RECORD Character(10) VARCHAR2(10) NOT NULL DADS related record
    3 GPFR_DA_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field