GM_XML_CD511

(SQL View)
 Index Back

xml file proposal header infor


SELECT A.OPRID , A.RUN_CNTL_ID , A.PROPOSAL_ID , A.VERSION_ID , %Substring(D.DESCR120, 1, 60) , B.CONTRACT_NUM , %Substring(G.DESCR254, 1, 200) , C.NAME_PREFIX , C.FIRST_NAME , C.MIDDLE_NAME , C.LAST_NAME , C.NAME_SUFFIX , C.NAME , C.DESCR , CASE WHEN B.SUBMIT_DTTM IS NULL THEN %CurrentDateTimeIn ELSE B.SUBMIT_DTTM END FROM PS_GM_XML_PROP_TBL A , PS_GM_EC_HDR B , PS_GM_EC_PERS_AD C , PS_GM_EC_INST D , PS_GM_PROP_PROJ G WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID AND C.OPRID = B.OPRID AND C.RUN_CNTL_ID = B.RUN_CNTL_ID AND C.ECTRANSID = B.ECTRANSID AND C.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND C.ECTRANSID = B.ECTRANSID AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.PROPOSAL_ID = B.PROPOSAL_ID AND B.ECTRANSID = D.ECTRANSID AND B.ECQUEUEINSTANCE = D.ECQUEUEINSTANCE AND B.ECTRANSINOUTSW = D.ECTRANSINOUTSW AND B.OPRID = D.OPRID AND B.RUN_CNTL_ID = D.RUN_CNTL_ID AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.PROPOSAL_ID = D.PROPOSAL_ID AND B.BUSINESS_UNIT = G.BUSINESS_UNIT AND B.PROPOSAL_ID = G.PROPOSAL_ID AND B.VERSION_ID = G.VERSION_ID AND G.PRIMARY_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
4 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
5 ORG_LEG_NAME Character(60) VARCHAR2(60) NOT NULL Organization Legal Name
6 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
7 GM_PROJ_DESC Character(254) VARCHAR2(254) NOT NULL Project Description
8 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
1=Mr.
2=Mrs.
3=Ms.
9 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
10 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
11 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
12 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
13 NAME Character(50) VARCHAR2(50) NOT NULL Name
14 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title
15 SUBMIT_DTTM DateTime(26) TIMESTAMP Report Submitted On - DateTime