GM_XML_CO_NAME

(SQL View)
 Index Back

xml PI NAME


SELECT A.OPRID , A.RUN_CNTL_ID , A.PROPOSAL_ID , A.VERSION_ID , B.NAME , B.EMPLID , B.NAME_PREFIX , B.NAME_SUFFIX , B.FIRST_NAME , B.LAST_NAME , B.MIDDLE_NAME FROM PS_GM_XML_PROP_TBL A , PS_GM_EC_PERS_PI B , PS_GM_EC_PROJ_PI_2 G WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID 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 NAME Character(50) VARCHAR2(50) NOT NULL Name
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    7 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
    1=Mr.
    2=Mrs.
    3=Ms.
    8 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
    9 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    10 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    11 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name