PY_PFF_CALC_DTL

(SQL Table)
Index Back

Calculation Rule Details

Calculation Rule Details Record

  • Related Language Record: PY_PFF_CLC_LANG
  • # 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 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    5 MAINT_RESPONSBLTY Character(1) VARCHAR2(1) NOT NULL Maintenance Responsibility
    C=Customer
    P=PeopleSoft

    Default Value: C

    6 PY_PFF_SLF_ADJ Character(1) VARCHAR2(1) NOT NULL Self Adjust
    M=MTD
    N=NA
    Q=QTD
    Y=YTD

    Default Value: N

    7 PY_PFF_RULE_APL Character(1) VARCHAR2(1) NOT NULL Calculation Basis
    A=Always
    B=UI Jurisdiction or Resident
    R=Resident
    U=UI Jurisdiction

    Default Value: A

    8 PY_PFF_ROUND_IND Character(1) VARCHAR2(1) NOT NULL Calculation Basis
    A=Two Decimals (Default)
    B=Three Decimals

    Default Value: A

    9 DESCRLONG Long Character CLOB Long Description