GPFR_DT_44004

(SQL View)
 Index Back

DSN44.004 Values

Prompt table for data type DSN44.004

SELECT DISTINCT GPFR_DA_CODE AS DATA_TYP_CD_FRA ,%Substring(DESCR254 ,1 ,60) AS DATA_CD_TYP_DESCR FROM PS_GPFR_DT_VALUES A WHERE COUNTRY='FRA' AND GPFR_AF_APPL='DSN' AND GPFR_DA_DATTYP = 'DSN44.004' AND GPFR_DA_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPFR_DA_CODE Character(10) VARCHAR2(10) NOT NULL DADS related field
2 DATA_CD_TYP_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field