SP_ITEMCH_NONVW(SQL View) |
Index Back |
|---|---|
Item Type Charges View |
| SELECT a.setid , b.account_type_sf , a.item_type , a.descr , a.item_type_cd , a.keyword1 , a.keyword2 , a.keyword3 , a.tax_cd FROM PS_ITEM_TYPE_TBL a , ps_item_acct_type b WHERE a.setid=b.setid AND a.item_type=b.item_type AND a.effdt=b.effdt AND a.eff_status='A' AND a.effdt= ( SELECT MAX(c.effdt) FROM PS_ITEM_TYPE_TBL c WHERE a.setid=c.setid AND a.item_type=c.item_type AND c.effdt <= %CurrentDateIn) AND a.item_type_cd = 'C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ACCOUNT_TYPE_SF |
Character(3) | VARCHAR2(3) NOT NULL | Account Type |
| 3 | ITEM_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | 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 |
| 6 | KEYWORD1 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word
Prompt Table: %EDITTABLE |
| 7 | KEYWORD2 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word 2
Prompt Table: %EDITTABLE2 |
| 8 | KEYWORD3 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word 3
Prompt Table: %EDITTABLE3 |
| 9 | TAX_CD | Character(8) | VARCHAR2(8) NOT NULL | Tax Code |