FO_CSF_DTL_VW

(SQL View)
 Index Back

Bonus field details


SELECT DTL.FO_CSF_ID ,DTL.EFFDT ,DTL.FO_CSF_DESCR ,DTL.DESCR ,DTL.DEFAULT_FLAG FROM PS_FO_CSF_FLD_DTL DTL ,PS_FO_CSF_DEFN DEF WHERE DTL.FO_CSF_ID = DEF.FO_CSF_ID AND DTL.EFFDT = DEF.EFFDT AND DEF.EFF_STATUS='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FO_CSF_ID Character(15) VARCHAR2(15) NOT NULL Definition ID
2 EFFDT_USED Date(10) DATE Effective Date
3 FO_CSF_DESCR Character(30) VARCHAR2(30) NOT NULL Customer Field Name
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default

Y/N Table Edit