eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGW_PRPO_SUBJECT_INFO_V

Product:	IGW - Grants Proposal (Obsolete)
Description:	View displays details of human subjects involved in the proposal
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ST.PROPOSAL_ID
, ST.STUDY_TITLE
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '1'
, '1')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '2'
, '1')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '3'
, '1')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '4'
, '1')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '5'
, '1')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '6'
, '1')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '1'
, '2')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '2'
, '2')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '3'
, '2')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '4'
, '2')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '5'
, '2')
, IGW_REPORT_PROCESSING.GET_SUBJECTS(ST.PROPOSAL_ID
, ST.STUDY_TITLE_ID
, '6'
, '2')
FROM IGW_STUDY_TITLES ST

Columns

Name
PROPOSAL_ID
STUDY_TITLE
AMERICAN_INDIAN_FEMALES
ASIAN_FEMALES
BLACK_FEMALES
HISPANIC_FEMALES
WHITE_FEMALES
OTHER_FEMALES
AMERICAN_INDIAN_MALES
ASIAN_MALES
BLACK_MALES
HISPANIC_MALES
WHITE_MALES
OTHER_MALES