ITEM_ACCT_VW2(SQL View) |
Index Back |
---|---|
Item Type for Acct Type W/Ref |
SELECT a.setid , a.item_type , a.descr , a.minimum_amt , a.maximum_amt , a.item_type_cd , a.tender_spec , a.tender_category , a.tuition_deposit , a.keyword1 , a.keyword2 , a.keyword3 , a.currency_cd FROM PS_ITEM_TYPE_TBL a WHERE a.effdt=( SELECT MAX(effdt) FROM PS_ITEM_TYPE_TBL c WHERE a.setid=c.setid AND a.item_type=c.item_type AND c.effdt <= %CurrentDateIn AND c.eff_status='A') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Item Type |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | MINIMUM_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Mininum Transaction Amount |
5 | MAXIMUM_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Maximum Transaction Amount |
6 | ITEM_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Item Type Code
A=Application Fee B=Billing Only C=Charge D=Deposit F=Financial Aid G=GL Interface Only H=Withholding I=Interest L=Pre-Paid Tuition P=Payment R=Refund T=Transfers V=Contributor Relations W=Waiver X=Write-off Z=Pay Plan Credit |
7 | TENDER_SPEC | Character(1) | VARCHAR2(1) NOT NULL | Tender Specific |
8 | 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 |
9 | TUITION_DEPOSIT | Character(1) | VARCHAR2(1) NOT NULL | Tuition Deposit |
10 | KEYWORD1 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word
Prompt Table: %EDITTABLE |
11 | KEYWORD2 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word 2
Prompt Table: %EDITTABLE2 |
12 | KEYWORD3 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word 3
Prompt Table: %EDITTABLE3 |
13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |