SSF_ST_GN_PR_VW(SQL View) |
Index Back |
|---|---|
Student Purch Item (All) ViewStudent General Purchase Item (All) View |
| SELECT A.BUSINESS_UNIT ,A.SSF_PUR_ITEM_CODE ,A.DESCR ,A.DESCRLONG ,B.SSF_PUR_CATEGORY ,D.DESCR ,B.ACCOUNT_TYPE_SF ,B.ITEM_TYPE ,B.FLAT_AMT ,E.INSTITUTION_SET ,G.INSTITUTION FROM PS_SSF_PUR_ITEM_CD A ,PS_SSF_PURCH_ITEM B ,PS_SSF_PUR_CATGRY D ,PS_ISET_BU_DTL E ,PS_BUS_UNIT_TBL_SF G WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.SSF_PUR_ITEM_CODE = A.SSF_PUR_ITEM_CODE AND B.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SSF_PURCH_ITEM A1 WHERE A1.BUSINESS_UNIT = A.BUSINESS_UNIT AND A1.SSF_PUR_ITEM_CODE = A.SSF_PUR_ITEM_CODE AND A1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND B.SSF_EXP_DATE > %CurrentDateIn AND A.SSF_PUR_ITM_OPTION = 'A' AND D.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.SSF_PUR_CATEGORY = B.SSF_PUR_CATEGORY AND E.BUSINESS_UNIT = A.BUSINESS_UNIT AND G.BUSINESS_UNIT = A.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SSF_PUR_ITEM_CODE | Character(6) | VARCHAR2(6) NOT NULL | Purchase Item Code |
| 3 | SSF_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Student Financials' Description |
| 4 | DESCRLONG | Long Character | CLOB | Long Description |
| 5 | SSF_PUR_CATEGORY | Character(10) | VARCHAR2(10) NOT NULL | Puchase Category |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | ACCOUNT_TYPE_SF | Character(3) | VARCHAR2(3) NOT NULL | Account Type |
| 8 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 9 | FLAT_AMT | Number(17,2) | DECIMAL(16,2) NOT NULL | Flat Amount |
| 10 | INSTITUTION_SET | Character(5) | VARCHAR2(5) NOT NULL | Institution Set |
| 11 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |