SP_ITYPE_OPRVW(SQL View) |
Index Back |
|---|---|
Sec Vw - Item type - Operator |
| select a.setid, a.item_type, d.oprid, a.descr, a.item_type_cd, a.keyword1, a.keyword2, a.keyword3 from ps_item_type_tbl a ,PSOPRDEFN d ,ps_sec_item_opr k where a.eff_status='A' and a.effdt= (select max(b.effdt) from ps_item_type_tbl b where a.setid=b.setid and a.item_type=b.item_type and b.effdt <= %currentdatein) 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 | ITEM_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 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 |