PAYMENT_TBL_VW

(SQL View)
 Index Back

Payment Item Type VW


SELECT a.business_unit ,a.common_id ,a.common_id ,a.item_type ,a.payment_id_nbr ,a.payment_amt ,a.payment_method ,a.encumbrance_dt ,a.encumbered_amt ,a.check_num_sf ,a.third_party ,a.credit_card_nbr ,a.credit_card_type ,a.credit_card_exp_dt ,a.credit_card_issuer ,a.credit_card_holder ,a.fed_rsrv_bank_id ,a.SSF_BNK_ACCT_NUM ,a.bank_acct_typ ,a.bank_acct_name ,a.sf_reversal_ind ,a.ref1_descr ,a.tender_spec ,a.tender_category ,a.tracer_nbr ,a.accounting_dt ,a.posted_date ,a.strm ,a.session_code ,a.payment_category ,a.acad_year ,a.disbursement_date FROM PS_PAYMENT_TBL a WHERE sa_id_type = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
5 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
6 PAYMENT_AMT Number(19,3) DECIMAL(18,3) NOT NULL Payment Amount
7 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
CC=Credit Card
CHK=Check
CSH=Cash
DB=Debit Card
EC=Electronic Check
EFT=Electronic Funds Transfer
LBX=Lockbox
TPC=Third Party Check
WIR=Wire Transfer
8 ENCUMBRANCE_DT Date(10) DATE Encumbrance Date
9 ENCUMBERED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Amount Encumbered
10 CHECK_NUM_SF Character(30) VARCHAR2(30) NOT NULL Check Nbr
11 THIRD_PARTY Character(30) VARCHAR2(30) NOT NULL Third Party Check Name
12 CREDIT_CARD_NBR Character(44) VARCHAR2(44) NOT NULL Card Number
13 CREDIT_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL Credit Card Type
AE=American Express
DC=Diners' Club
DI=Diners Club
MC=MasterCard
VI=VISA
14 CREDIT_CARD_EXP_DT Date(10) DATE Expiration Date
15 CREDIT_CARD_ISSUER Character(20) VARCHAR2(20) NOT NULL Credit Card Issuer
16 CREDIT_CARD_HOLDER Character(30) VARCHAR2(30) NOT NULL Credit Card Holder
17 FED_RSRV_BANK_ID Character(10) VARCHAR2(10) NOT NULL Federal Reserve Bank ID
18 SSF_BNK_ACCT_NUM Character(44) VARCHAR2(44) NOT NULL Bank Account Number
19 BANK_ACCT_TYP Character(1) VARCHAR2(1) NOT NULL Bank Account Type
C=Checking
S=Savings
20 BANK_ACCT_NAME Character(30) VARCHAR2(30) NOT NULL Bank Account Holder Name
21 SF_REVERSAL_IND Character(1) VARCHAR2(1) NOT NULL Reversal Indicator
22 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr
23 TENDER_SPEC Character(1) VARCHAR2(1) NOT NULL Tender Specific
24 TENDER_CATEGORY Character(3) VARCHAR2(3) NOT NULL Tender Category
CC=Credit Card
CCI=Credit Card In
CCO=Credit Card Out
CK=Check
CKI=Check In
CKO=Check Out
CS=Cash
CSI=Cash In
CSO=Cash Out
DB=Debit Card
DBI=Debit Card In
DBO=Debit Card Out
DD=Direct Deposit
DDI=Direct Debit
DDO=Direct Deposit
EC=Electronic Check
TP=Third Party Check
TPI=Third Party Check In
WIR=Wire Transfer
25 TRACER_NBR Character(30) VARCHAR2(30) NOT NULL Tracer Number
26 ACCOUNTING_DT Date(10) DATE Accounting Date
27 POSTED_DATE Date(10) DATE Date Posted
28 STRM Character(4) VARCHAR2(4) NOT NULL Term
29 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
1=Regular Academic Session
10W=10 Week
12W=Twelve Week
4W1=Four Week - First
4W2=Four Week - Second
4W3=Four Week - Third
4W4=Four Week - Fourth
6W1=Six Week - First
6W2=Six Week - Second
8W1=Eight Week - First
8W2=Eight Week - Second
A11=Medical Period 1, 4 Weeks
A12=Medical Period 1, 8 Weeks
A13=Medical Pd 1, 12 Weeks
A21=Medical Period 2, 4 Weeks
A22=Medical Period 2, 8 Weeks
A23=Medical Period 2, 12 Week
FYR=Full Year
MIN=Mini Session
OEE=Open Entry/Open Exit
SM1=Semester 1
SM2=Semester 2
30 PAYMENT_CATEGORY Character(1) VARCHAR2(1) NOT NULL Payment Category
31 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
32 DISBURSEMENT_DATE Date(10) DATE Disbursement Date