SP_ITWH_S_NONVW(SQL View) |
Index Back |
|---|---|
ItemType Withhold State View |
| select a.setid, b.account_type_sf, a.item_type, a.descr, a.item_type_cd, a.keyword1, a.keyword2, a.keyword3 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.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') and a.item_type_cd = 'H' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ACCT_TYPE_STATE |
Character(3) | VARCHAR2(3) NOT NULL | State Withholding Account |
| 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 |