TP_CONTRACT_VW4

(SQL View)
 Index Back

Third Party Contracts View


SELECT A.BUSINESS_UNIT ,A.CONTRACT_NUM ,A.TP_CON_TYPE ,A.START_DT ,A.END_DT ,A.ORG_CODE ,A.ORG_CONTACT ,A.TP_CAP_CONTRACT ,A.TP_STATUS ,A.TP_CON_LAST_COR_DT ,A.ITEM_TYPE ,A.PMT_ITEM_TYPE ,A.ACCOUNT_TYPE_SF ,A.TP_CAP_STUDENT ,A.TP_CONTRACT_TYPE ,A.TP_CON_PLAN_FEE ,A.TP_MAX_AMOUNT ,A.LUMP_SUM_AMT ,A.PLAN_TYPE_SF ,A.PAY_PLAN_TYPE ,A.GUESS_AMT ,A.GUESS_AMT_EXPIR_DT FROM PS_TP_CONTRACT A WHERE A.TP_STATUS = 'A' AND (TP_CON_TYPE = 'T' OR (TP_CON_TYPE = 'P' AND PLAN_TYPE_SF IN ('2', '3'))) AND TP_CON_LAST_COR_DT >= %CURRENTDATEIN

# 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
3 TP_CON_TYPE Character(1) VARCHAR2(1) NOT NULL Third Party Contract Type
C=Collection Agreement
D=Deferral Contract
M=Multi-year Payment Plan
P=Payment Plan
R=Pre-Payment Plan
T=Third Party
4 START_DT Date(10) DATE Start Date
5 END_DT Date(10) DATE end date
6 ORG_CODE Character(6) VARCHAR2(6) NOT NULL Organization Code
7 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr
8 TP_CAP_CONTRACT Number(15,2) DECIMAL(14,2) NOT NULL Contract Max
9 TP_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Active
C=Cancelled
H=Hold
I=Inactive
U=Not Posted

Default Value: A

10 TP_CON_LAST_COR_DT Date(10) DATE Last Date to Enter Corrections
11 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

Prompt Table: ITEM_TYPE_CH_VW

12 PMT_ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Payment Item Type

Prompt Table: ITEM_TYPE_PY_VW

13 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type

Prompt Table: ACCT_TYP_TBL_SF

14 TP_CAP_STUDENT Number(15,2) DECIMAL(14,2) NOT NULL Third Party Student Maximum
15 TP_CONTRACT_TYPE Character(1) VARCHAR2(1) NOT NULL Third Party Contract Type
C=Specific Course
L=Specific Course List
P=Specific Year or Period
T=Specific Term
16 TP_CON_PLAN_FEE Signed Number(12,2) DECIMAL(10,2) NOT NULL Plan Fee Amount
17 TP_MAX_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Maximum Amount
18 LUMP_SUM_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Lump Sum Amt
19 PLAN_TYPE_SF Character(1) VARCHAR2(1) NOT NULL Plan Type
1=Existing Charges Only
2=Lump Sum
3=Calculated
20 PAY_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Plan Type
B=Create Billing Entries
C=Credit Original Account
21 GUESS_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Guess Amt
22 GUESS_AMT_EXPIR_DT Date(10) DATE Guess Amt Exp. DT