PY_PFF_STCALCVW

(SQL View)
 Index Back

Calcrule prompt table

Calcrule prompt table

SELECT DISTINCT A.PY_PFF_CALCRULE ,A.EFFDT ,B.DESCR FROM PS_PY_PFF_CALC_DTL A , PS_PY_PFF_CALC_TBL B WHERE A.PY_PFF_CALCRULE = B.PY_PFF_CALCRULE

  • Related Language Record: PY_PFF_SCAL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PY_PFF_CALCRULE Character(10) VARCHAR2(10) NOT NULL Calc Rule Id
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description