GM_XML_COPI_ADD

(SQL View)
Index Back

xml PI NAME


SELECT A.OPRID , A.RUN_CNTL_ID , A.PROPOSAL_ID , A.VERSION_ID , B.EMPLID , F.ADDRESS1_OTHER , F.ADDRESS2_OTHER , F.CITY_OTHER , F.COUNTRY_OTHER , F.COUNTY_OTHER , F.POSTAL_OTHER , F.STATE_OTHER FROM PS_GM_XML_PROP_TBL A , PS_GM_EC_PERS_PI B , PS_GM_EC_PROJ_PI_2 G , PS_GM_PERS_ADDR_VW F WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID AND F.EMPLID = B.EMPLID AND B.ECTRANSID = G.ECTRANSID AND B.ECQUEUEINSTANCE = G.ECQUEUEINSTANCE AND B.ECTRANSINOUTSW = G.ECTRANSINOUTSW AND B.OPRID = G.OPRID AND B.RUN_CNTL_ID = G.RUN_CNTL_ID AND B.BUSINESS_UNIT = G.BUSINESS_UNIT AND B.PROPOSAL_ID = G.PROPOSAL_ID AND B.EMPLID = G.EMPLID AND A.SUB_PROP_NBR = G.SUB_PROP_NBR AND G.PROF_ROLE_TYPE = 'CPI'

  • Parent record: GM_XML_PROP_TBL
  • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    7 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    8 CITY Character(30) VARCHAR2(30) NOT NULL City
    9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    10 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    11 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    12 STATE Character(6) VARCHAR2(6) NOT NULL State