SP_ITEMWV_OPRVW(SQL View) |
Index Back |
|---|---|
Item Type Waivers - Opr |
| select a.setid, b.account_type_sf, a.item_type, d.oprid, 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_opr k 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 = 'W' and k.item_type = a.item_type and k.setid = a.setid and k.oprid = d.oprid |
| # | 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 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 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 |