GM_XML_FRMER_PI

(SQL View)
 Index Back

Name inform for Former PI


SELECT B.BUSINESS_UNIT , B.PROPOSAL_ID , B.VERSION_ID , A.EMPLID , A.NAME ,A.FIRST_NAME , A.MIDDLE_NAME , A.LAST_NAME , A.NAME_SUFFIX , A.NAME_PREFIX FROM PS_PERS_DATA_EFFDT A , PS_GM_PROPOSAL B WHERE A.EFFDT = ( SELECT MAX(F.EFFDT) FROM PS_PERS_DATA_EFFDT F WHERE A.EMPLID = F.EMPLID) AND B.EMPLID_OLD = A.EMPLID

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
7 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
9 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
10 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
1=Mr.
2=Mrs.
3=Ms.