SSF_PPL_INQ_VW

(SQL View)
 Index Back

Payment Plan Contract View

This view will be used to display the valid Payment Plan Contracts - TP_CON_TYPE = 'P'

SELECT A.BUSINESS_UNIT ,A.CONTRACT_NUM ,A.STRM ,A.DESCR ,A.PLAN_TYPE_SF ,A.TP_CON_PLAN_FEE ,A.TP_CON_NUM_PAYMENT ,A.TP_CON_BILL_CYCLE ,A.TP_CON_BILL_DT ,A.TP_STATUS FROM PS_TP_CONTRACT A WHERE (A.TP_CON_TYPE = 'P' OR A.TP_CON_TYPE = 'D') AND EXISTS ( SELECT 'X' FROM PS_SSF_TP_STUNT_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CONTRACT_NUM = B.CONTRACT_NUM)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

Prompt Table: SP_BU_SF_NONVW

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

Prompt Table: TP_PAYP_CONT_VW

3 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_VAL_TBL

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 PLAN_TYPE_SF Character(1) VARCHAR2(1) NOT NULL Plan Type
1=Existing Charges Only
2=Lump Sum
3=Calculated
6 TP_CON_PLAN_FEE Signed Number(12,2) DECIMAL(10,2) NOT NULL Plan Fee Amount
7 TP_CON_NUM_PAYMENT Number(3,0) SMALLINT NOT NULL Number Of Payments
8 TP_CON_BILL_CYCLE Character(1) VARCHAR2(1) NOT NULL Billing Cycle
B=Bi-Monthly
M=Monthly
O=One Time
U=User Selected
W=Weekly
9 TP_CON_BILL_DT Date(10) DATE First Billing Date
10 TP_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Active
C=Cancelled
H=Hold
I=Inactive
U=Not Posted