GM_SP_BCAT_VW2(SQL View) |
Index Back |
|---|---|
Sponsor Budget Cats Grants |
| SELECT A.SETID ,A.CUST_ID ,A.EFFDT ,A.BUDGET_CATEGORY ,A.EFF_STATUS ,B.DESCR ,B.BUD_CAT_TYPE , B.GM_BUD_GROUP FROM PS_GM_SP_BUD_CAT A , PS_GM_BUD_CATEGORY B WHERE A.SETID = B.SETID AND A.BUDGET_CATEGORY = B.BUDGET_CATEGORY AND B.GM_BUD_GROUP <> ' ' AND %Sql(GM_BUDCAT_TYP_GM, B.) AND B.EFFDT =( SELECT MAX(EFFDT) FROM PS_GM_BUD_CATEGORY C WHERE B.SETID=C.SETID AND B.BUDGET_CATEGORY=C.BUDGET_CATEGORY) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUSTOMER |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: GM_SP_BUDCAT_DT.EFFDT |
| 4 | BUDGET_CATEGORY |
Character(15) | VARCHAR2(15) NOT NULL |
BUDGET_CATEGORY
Prompt Table: GM_BUD_CATEGORY |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | BUD_CAT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Budget Item Type |
| 8 | GM_BUD_GROUP | Character(4) | VARCHAR2(4) NOT NULL |
Grants.Gov Grouping Type
DTRV=Domestic Travel EQUP=Equipment FEE=Fee FTRV=Foreign Travel ODIR=Other Direct Cost PERS=Personnel PTRN=Participant/Trainee Support |