TP_STDNT_DATEVW

(SQL View)
 Index Back

Contract Date


select a.business_unit ,a.contract_num ,a.tp_seq_nbr ,a.from_date ,a.transfer_amt ,a.transfer_dt ,a.actual_trans_amt ,a.transfer_status ,a.emplid ,c.strm ,b.gen_transfer_item ,b.transfer_nbr ,b.transfer_item_type ,b.tp_con_pay_credit ,b.deficit_flg ,b.deficit_amt ,c.account_type_sf 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 = 'R'

# 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 TRANSFER_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Transfer Amt
6 TRANSFER_DT Date(10) DATE Transfer Date
7 ACTUAL_TRANS_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Actual Transfer Amt
8 TRANSFER_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Status
C=Complete Transfer
N=No Transfer
P=Partial Transfer

Default Value: N

9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: TP_STUDENT.EMPLID

10 STRM Character(4) VARCHAR2(4) NOT NULL Term
11 GEN_TRANSFER_ITEM Character(1) VARCHAR2(1) NOT NULL Generate Transfer Item
12 TRANSFER_NBR Number(3,0) SMALLINT NOT NULL Number to Transfer
13 TRANSFER_ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Transfer Item Type
14 TP_CON_PAY_CREDIT Character(12) VARCHAR2(12) NOT NULL Payment Credit
15 DEFICIT_FLG Character(1) VARCHAR2(1) NOT NULL Deficit Flag
16 DEFICIT_AMT Number(15,2) DECIMAL(14,2) NOT NULL Deficit Amount
17 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type