SP_ITWH_F_CLSVW(SQL View) |
Index Back |
|---|---|
ItemType Withhold Federal View |
| select distinct a.setid, b.account_type_sf, a.item_type, d.oprclass, a.descr, a.item_type_cd, a.keyword1, a.keyword2, a.keyword3 from ps_item_type_tbl a, ps_item_acct_type b, PSOPRDEFN d, ps_sec_item_cls k 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' and k.setid = a.setid and k.item_type = a.item_type and k.oprclass = d.oprclass |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ACCT_TYPE_NRA_TAX |
Character(3) | VARCHAR2(3) NOT NULL | Federal Withholding Account |
| 3 | ITEM_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 4 | OPRCLASS |
Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 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 | KEYWORD1 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word
Prompt Table: %EDITTABLE |
| 8 | KEYWORD2 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word 2
Prompt Table: %EDITTABLE2 |
| 9 | KEYWORD3 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word 3
Prompt Table: %EDITTABLE3 |