INSTITUTIONITEM_TYPESFA_SAP_ITEM_VW(SQL View) |
Index Back |
|---|---|
SAP Item Type FA ViewView of PS_ITEM_TYPE_FA, used as prompt table in SAP Set up on table SFA_SAP_AWD_TBL |
| SELECT DISTINCT A.SETID , A.ITEM_TYPE , A.DESCR FROM PS_ITEM_TYPE_FA A WHERE A.EFFDT = ( SELECT MAX(AX.EFFDT) FROM PS_ITEM_TYPE_FA AX WHERE A.SETID = AX.SETID AND A.ITEM_TYPE = AX.ITEM_TYPE AND A.AID_YEAR = AX.AID_YEAR AND AX.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | ITEM_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |