GPFR_DA_CD_VW2

(SQL View)
 Index Back

Cd Related to a Data Type Dfn

DADS related record: store the codes related to a data type definition used in the DADS process.

SELECT GPFR_DA_DATTYP , %Substring(GPFR_DA_CODE, 1, 3) , GPFR_DA_STATUS , GPFR_DA_DESCR FROM PS_GPFR_DA_CODE

  • Related Language Record: GPFR_DA_CD_LVW2

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

    Default Value: A

    4 GPFR_DA_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field