RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FRBPROP Finance Composite View Reports
SGHE Operational Data Store Composite View Source: FRBPROP

Source Column Source Form Target Type Target Target Column Calculation Formula
FRBPROP_AGENCY_PIDM NA COMPOSITE VIEW

AF_PROPOSAL

AGENCY_UID

NA
FRBPROP_CATEGORY FRAPROP COMPOSITE VIEW

AF_PROPOSAL

CATEGORY

NA
FRBPROP_CFDA_INTERNAL_ID_NO FRAPROP COMPOSITE VIEW

AF_PROPOSAL

AF_PROPOSAL

FEDERAL_IDENTIFICATION

FEDERAL_IDENTIFICATION_UID

NA
FRBPROP_COAS_CODE FRAPROP COMPOSITE VIEW

AF_PROPOSAL

CHART_OF_ACCOUNTS

NA
FRBPROP_CODE FRAPROP COMPOSITE VIEW

AF_PROPOSAL

PROPOSAL_CODE

NA
FRBPROP_GRNT_CODE FRAPROP COMPOSITE VIEW

AF_PROPOSAL

GRANT_ID

NA
FRBPROP_LONG_TITLE FRAPROP COMPOSITE VIEW

AF_GRANT

AF_GRANT_FUND

AF_PROPOSAL

PROPOSAL_LONG_TITLE

PROPOSAL_LONG_TITLE

PROPOSAL_LONG_TITLE

NA
FRBPROP_ORGN_CODE_RESP_OFFICE FRAPROP COMPOSITE VIEW

AF_PROPOSAL

ORGANIZATION_CODE

NA
FRBPROP_PI_PIDM NA COMPOSITE VIEW

AF_PROPOSAL

PRINCIPAL_INVESTIGATOR_UID

NA
FRBPROP_PROPOSAL_TYPE FRAPROP COMPOSITE VIEW

AF_PROPOSAL

PROPOSAL_TYPE

NA
FRBPROP_REQUESTED_AMT FRAPROP COMPOSITE VIEW

AF_PROPOSAL

REQUESTED_AMOUNT

NA
FRBPROP_SPONSOR_ID FRAPROP COMPOSITE VIEW

AF_PROPOSAL

SPONSOR_NUMBER

NA
FRBPROP_STATUS_CODE FRAPROP COMPOSITE VIEW

AF_PROPOSAL

CURRENT_STATUS

NA
FRBPROP_STATUS_DATE FRAPROP COMPOSITE VIEW

AF_PROPOSAL

CURRENT_STATUS_DATE

NA
FRBPROP_SUB_CATEGORY FRAPROP COMPOSITE VIEW

AF_PROPOSAL

SUBCATEGORY

NA
FRBPROP_TITLE FRAPROP COMPOSITE VIEW

AF_GRANT

AF_GRANT_FUND

AF_PROPOSAL

PROPOSAL_SHORT_TITLE

PROPOSAL_SHORT_TITLE

PROPOSAL_SHORT_TITLE

NA


Ver: 3.1