BUSINESS_UNITDefault Value: OPR_DEF_TBL_CA.BUSINESS_UNIT
Prompt Table: SP_BU_CA_NONVW
PROPOSAL_IDPrompt Table: GM_PROP_ID_VW
VERSION_IDPrompt Table: GM_PROPOSAL
GM_DISLOB_FED_V(SQL View) |
Index Back |
|---|---|
Disclosure of Lobby -Lobbying Registrant |
| SELECT A.BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID , A.FED_PROG_DESC , A.FED_ACT , A.AWD_AMT , A.FED_AG_DEPT , A.FED_PROG_NAME , B.CFDA FROM PS_GM_DISC_LOB_FED A , PS_GM_EC_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROPOSAL_ID = B.PROPOSAL_ID AND A.VERSION_ID = B.VERSION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
| 2 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Proposal ID
Prompt Table: GM_PROP_ID_VW |
| 3 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL |
Version ID
Prompt Table: GM_PROPOSAL |
| 4 | FED_PROG_DESC | Long Character(4096) | CLOB | Federal Program Description |
| 5 | FED_ACT | Character(110) | VARCHAR2(110) NOT NULL | Federal Action Number |
| 6 | AWD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Award Amount |
| 7 | FED_AG_DEPT | Character(40) | VARCHAR2(40) NOT NULL | *Federal Agency Department |
| 8 | FED_PROG_NAME | Character(120) | VARCHAR2(120) NOT NULL | Federal Program Name |
| 9 | CFDA | Character(15) | VARCHAR2(15) NOT NULL | CFDA |