ITEM_TYPE_FA_VW(SQL View) |
Index Back |
|---|---|
Item Type Search Record for FAItem Type Search Record for FA |
| SELECT A.SETID ,A.AID_YEAR ,A.ITEM_TYPE ,A.DESCR ,C.KEYWORD1 ,C.KEYWORD2 ,C.KEYWORD3 ,A.ITEM_TYPE ,A.ITEM_TYPE FROM PS_ITEM_TYPE_FA A , PS_ITEM_TYPE_TBL C WHERE A.SETID=C.SETID AND A.ITEM_TYPE=C.ITEM_TYPE AND A.EFFDT=( SELECT MAX (B.EFFDT) FROM PS_ITEM_TYPE_FA B WHERE A.SETID = B.SETID AND A.AID_YEAR = B.AID_YEAR AND A.ITEM_TYPE = B.ITEM_TYPE AND B.EFFDT <= %CurrentDateIn) AND C.EFFDT=( SELECT MAX (D.EFFDT) FROM PS_ITEM_TYPE_TBL D WHERE C.SETID = D.SETID AND C.ITEM_TYPE = D.ITEM_TYPE AND D.EFFDT <= %CurrentDateIn AND D.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: FED_AID_YR_TBL |
| 3 | ITEM_TYPE |
Character(12) | VARCHAR2(12) NOT NULL |
Item Type
Prompt Table: ITEM_TYPE_FA_SH |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | KEYWORD1 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word
Prompt Table: %EDITTABLE |
| 6 | KEYWORD2 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word 2
Prompt Table: %EDITTABLE2 |
| 7 | KEYWORD3 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word 3
Prompt Table: %EDITTABLE3 |
| 8 | ITEM_TYPE_FROM | Character(12) | VARCHAR2(12) NOT NULL | Item Type From |
| 9 | ITEM_TYPE_TO | Character(12) | VARCHAR2(12) NOT NULL | Item Type To |