PP_MET_TBL_VW (SQL View)	Index Back
Payment Predictor Methods View Payment selections prompt view

PP_MET_TBL_VW

(SQL View)

Payment Predictor Methods View

Payment selections prompt view

SELECT DISTINCT M.SETID , P.DEPOSIT_BU , M.PP_METHOD , M.DESCR FROM PS_PP_MET_TBL M , PS_PAYMENT_SEL_VW P WHERE M.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = P.DEPOSIT_BU AND RECNAME = 'PP_MET_TBL') AND M.EFF_STATUS = 'A' AND M.EFFDT = ( SELECT MAX(EFFDT) FROM PS_PP_MET_TBL WHERE SETID = M.SETID AND PP_METHOD = M.PP_METHOD AND EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
Default Value: PAYMENT_SEL_VW.DEPOSIT_BU

3 PP_METHOD Character(15) VARCHAR2(15) NOT NULL Payment Predictor Method
Prompt Table: PP_MET_TBL

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted. Default Value: PAYMENT_SEL_VW.DEPOSIT_BU
3	PP_METHOD	Character(15)	VARCHAR2(15) NOT NULL	Payment Predictor Method Prompt Table: PP_MET_TBL
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description