GPFR_DA_REC_VW

(SQL View)
 Index Back

Def Act&Visible Rec for Struct

DADS related view: created in order to access the active and visible records for a given structure.

SELECT GPFR_DA_STRUCT , GPFR_DA_RECORD , GPFR_DA_DESCR FROM PS_GPFR_DA_RECORD WHERE GPFR_DA_STATUS = 'A' AND GPFR_DA_OPTION IN ('E', 'D')

  • Related Language Record: GPFR_DA_REC_LNG

    • # 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