PP_SYSFUNC_VW

(SQL View)
 Index Back

Payment Predictor func prompt


SELECT %Substring(X.FIELDVALUE,1,1) , E.ENTRY_USE_ID , X.EFFDT , X.EFF_STATUS , E.DESCR FROM PSXLATITEM X , PS_ENTRY_USE_TBL E WHERE X.FIELDNAME = 'PP_USAGE' AND ( ( X.FIELDVALUE IN ('1') AND ENTRY_USE_ID IN ( 'WS-05' ) ) OR ( X.FIELDVALUE IN ('2' ,'3' ,'4') AND ENTRY_USE_ID IN ( 'WS-04' , 'WS-05' , 'WS-06' ,'WS-10' ) ) OR ( X.FIELDVALUE IN ('5' ,'6' ,'7') AND ENTRY_USE_ID IN ( 'WS-07' , 'WS-08' ,'WS-11' ) ) )

  • Related Language Record: PP_SYSFUNC_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PP_USAGE Character(1) VARCHAR2(1) NOT NULL Usage
    1=First...
    2=Any Overpayment
    3=Overpayment Exceeds
    4=Overpayment Is Less Than
    5=Any Underpayment
    6=Underpayment Exceeds
    7=Underpayment Is Less Than
    2 ENTRY_USE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the System Function or type of processing associated with an entry type.
    3 EFFDT Date(10) DATE Effective Date
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description