GM_XML_OTHER15

(SQL View)
 Index Back

SBIR_STTR schema


SELECT BUSINESS_UNIT , PROPOSAL_ID , VERSION_ID , CASE IS_SMALL_BUS_ELIG WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE SUB_CONTRCT_INCL WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , SUB_CONTRACT_NAME , CASE LOCAL_HUB_ZONE WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE DOMESTIC_PERF WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE EQV_PROP_SUBMITED WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , FED_AGENCY_NAMES , CASE DISCLOSURE_PERM WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , CASE SBIR_PII_RECE WHEN 'Y' THEN 'Y: Yes' WHEN 'N' THEN 'N: No' ELSE ' ' END , CASE SBIR_PDPI_EMPL WHEN 'Y' THEN 'Y: Yes' WHEN 'N' THEN 'N: No' ELSE ' ' END , CASE SBIR_PDPI_COMMIT WHEN 'Y' THEN 'Y: Yes' WHEN 'N' THEN 'N: No' ELSE ' ' END , CASE SBIR_PDPI_JOINT WHEN 'Y' THEN 'Y: Yes' WHEN 'N' THEN 'N: No' ELSE ' ' END FROM PS_GM_PROPSL_FORMS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
4 IS_SML_BUS_ELIG_D Character(14) VARCHAR2(14) NOT NULL Small Business Eligibility
5 SUB_CONTRCT_INCL_D Character(18) VARCHAR2(18) NOT NULL Subcontracts Included
6 SUB_CONTRACT_NAME Character(250) VARCHAR2(250) NOT NULL Subcontract Names
7 LOCAL_HUB_ZONE_D Character(18) VARCHAR2(18) NOT NULL Located In HUB Zone
8 DOMESTIC_PERF_D Character(18) VARCHAR2(18) NOT NULL Domestic Performance
9 Y_PI_DESC Character(18) VARCHAR2(18) NOT NULL PI
10 FED_AGENCY_NAMES Character(250) VARCHAR2(250) NOT NULL Federal Agency Names
11 Y_COLL_DESC Character(18) VARCHAR2(18) NOT NULL Collaborator
12 Y_COPI_DESC Character(18) VARCHAR2(18) NOT NULL CO-PI
13 Y_EQU_DESC Character(14) VARCHAR2(14) NOT NULL Equipment
14 Y_FAC_DESC Character(14) VARCHAR2(14) NOT NULL Facility
15 INTER_PART_DESC Character(14) VARCHAR2(14) NOT NULL International Participation