MULTYR_STD_DTVW

(SQL View)
 Index Back

Contract Date


select a.business_unit ,a.contract_num ,a.tp_seq_nbr ,a.from_date ,a.emplid ,a.strm ,a.max_term_amt ,a.adjust_until_date ,a.adjust_amount ,a.sent_dt ,a.sent_amt ,a.payment_id_nbr ,c.account_type_sf ,c.item_type ,c.pmt_item_type ,c.interest_item_type ,c.transfer_item_type ,c.tp_con_pay_credit ,c.item_type_group ,c.item_type_grp_off ,b.pre_plan_amt ,b.deficit_flg ,b.deficit_amt ,a.term_deficit_amt from ps_tp_stdnt_date a, PS_TP_STUDENT b, ps_tp_contract c where a.business_unit = b.business_unit and a.contract_num = b.contract_num and a.emplid = b.emplid and b.business_unit = c.business_unit and b.contract_num = c.contract_num and c.tp_con_type = 'M' and b.tp_status = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
3 TP_SEQ_NBR Number(7,0) INTEGER NOT NULL TP Sequence Number
4 FROM_DATE Date(10) DATE NOT NULL From Date
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: TP_STUDENT.EMPLID

6 STRM Character(4) VARCHAR2(4) NOT NULL Term
7 MAX_TERM_AMT Number(15,2) DECIMAL(14,2) NOT NULL Max Term Amount
8 ADJUST_UNTIL_DATE Date(10) DATE Adjust Until Date
9 ADJUST_AMOUNT Signed Number(13,2) DECIMAL(11,2) NOT NULL Adjust Amount
10 SENT_DT Date(10) DATE Date Supplier Data Sent
11 SENT_AMT Number(15,2) DECIMAL(14,2) NOT NULL Sent Amount
12 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
13 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type
14 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
15 PMT_ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Payment Item Type
16 INTEREST_ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Interest Item Type
17 TRANSFER_ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Transfer Item Type
18 TP_CON_PAY_CREDIT Character(12) VARCHAR2(12) NOT NULL Payment Credit
19 ITEM_TYPE_GROUP Character(10) VARCHAR2(10) NOT NULL Item Type Group
20 ITEM_TYPE_GRP_OFF Character(10) VARCHAR2(10) NOT NULL Offset Item Type Group
21 PRE_PLAN_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Pre-Payment Plan Amount
22 DEFICIT_FLG Character(1) VARCHAR2(1) NOT NULL Deficit Flag
23 DEFICIT_AMT Number(15,2) DECIMAL(14,2) NOT NULL Deficit Amount
24 TERM_DEFICIT_AMT Number(15,2) DECIMAL(14,2) NOT NULL Deficit Amount