GM_PROP_OP_6_VW

(SQL View)
 Index Back

Proposal Prof Other Support VW

This View contains the proposal specific details of a professionals pending other support (in other proposals).

SELECT D.BUSINESS_UNIT , D.PROPOSAL_ID , D.VERSION_ID , D.SUB_PROP_NBR , D.ROW_NUMBER , D2.BUSINESS_UNIT , D2.PROPOSAL_ID , D2.VERSION_ID , D2.SUB_PROP_NBR , D2.ROW_NUMBER , D2.PROF_ROLE_TYPE , D2.PROJECT_ROLE , P.PROPOSAL_TYPE , P.PROPOSAL_STATUS_GR , P.TITLE56 , P.BEGIN_DT , P.END_DT , P.SUBMIT_STATUS FROM PS_GM_PROP_PROF D , PS_GM_PROP_PROF D2 , PS_GM_PROPOSAL P WHERE ((D.EMPLID <> ' ' AND D.EMPLID = D2.EMPLID) OR (D.EMPLID=' ' AND D.NAME = D2.NAME)) AND P.BUSINESS_UNIT=D2.BUSINESS_UNIT AND P.PROPOSAL_ID=D2.PROPOSAL_ID AND P.VERSION_ID=D2.VERSION_ID AND P.PROPOSAL_STATUS_GR IN ('APR','AWP','DRF','PEF','PEN')

# 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 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
5 ROW_NUMBER Number(3,0) SMALLINT NOT NULL Row_Number
6 BUSINESS_UNIT_PROP Character(5) VARCHAR2(5) NOT NULL Proposal Business Unit
7 PROPOSAL_ID_TO Character(25) VARCHAR2(25) NOT NULL Proposal ID
8 VERSION_ID_TO Character(7) VARCHAR2(7) NOT NULL Version ID To
9 SUB_PROP_NBR_TO Character(15) VARCHAR2(15) NOT NULL Sub Proposal ID To
10 ROW_NUMBER_TO Number(3,0) SMALLINT NOT NULL Personnel/Professional Number
11 PROF_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type

Prompt Table: GM_PROF_ROLE_TY

12 PROJECT_ROLE Character(30) VARCHAR2(30) NOT NULL Project Role
13 PROPOSAL_TYPE Character(3) VARCHAR2(3) NOT NULL PROPOSAL_TYPE
AMD=Amendment
CNT=Continuation
CON=Competing Continuation
INT=Internal
MOD=Modification
NEW=New
NOC=No-Cost Extension
NON=Non-Competing Continuation
NRS=NRSA
PRE=Pre-Proposal
RCA=Research Career Award
REN=Renewal
RES=Resubmission
REV=Revision
SB1=SBIR I
SB2=SBIR II
ST1=STTR I
ST2=STTR II
SUP=Supplemental
14 PROPOSAL_STATUS_GR Character(4) VARCHAR2(4) NOT NULL PROPOSAL_STATUS_GR
ACP=Accepted Award
APR=Institution Approved
AWD=Awarded
AWP=Award Pending
DEC=Declined by Sponsor
DIS=Discontinued
DRF=Draft
NOT=Not Funded
PEF=Pending Funding
PEN=Pending Approval
REF=Refused by Institution
REJ=Rejected
SUBM=Submitted
WIT=Withdrawn
15 TITLE56 Character(56) VARCHAR2(56) NOT NULL TITLE56
16 BEGIN_DT Date(10) DATE Begin Date
17 END_DT Date(10) DATE End Date
18 SUBMIT_STATUS Character(4) VARCHAR2(4) NOT NULL Proposal Submission Status
CMTD=03 - Committed
CNCL=05 - Canceled
DENY=04 - Denied
DRAF=01 - Draft
NSUB=Not Submitted
RDY=02 - Ready
SUBM=Submitted
SUBR=Submitted With Error