GPFR_DA_STR_VW

(SQL View)
 Index Back

DADS Structure View

DADS related record: view on structure definition

SELECT GPFR_DA_STRUCT , %Substring(GPFR_DA_DESCR,1,30) , GPFR_DA_STATUS , GPFR_DA_OPTION FROM PS_GPFR_DA_STRUCT WHERE GPFR_DA_STATUS = 'A'

  • Related Language Record: GPFR_DA_STRVWLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPFR_DA_STRUCT Character(10) VARCHAR2(10) NOT NULL DADS related field
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 GPFR_DA_STATUS Character(1) VARCHAR2(1) NOT NULL DADS related field
    A=Active
    I=Inactive

    Default Value: A

    4 GPFR_DA_OPTION Character(1) VARCHAR2(1) NOT NULL DADS related field
    D=Display Only
    E=Edit
    I=Invisible

    Default Value: E