GM_X_KEY_PEOPLE

(SQL View)
 Index Back

SELECT DISTINCT A.OPRID , A.RUN_CNTL_ID , A.PROPOSAL_ID , A.VERSION_ID , B.NAME , C.DESCR , C.PROJECT_ROLE , B.EMPLID , B.BIRTHDATE , B.DESCR BUSINESS_TITLE , B.NATIONAL_ID , C.PROF_ROLE_TYPE , B.NAME_PREFIX , B.NAME_SUFFIX , B.FIRST_NAME , B.LAST_NAME , B.MIDDLE_NAME , %Substring(N.DESCR120, 1, 60) , N.DESCR , B.DESCR_2 , F.ADDRESS1_OTHER , F.ADDRESS2_OTHER , F.ADDRESS3_OTHER , F.ADDRESS4_OTHER , F.CITY_OTHER , F.COUNTRY_OTHER , F.COUNTY_OTHER , F.POSTAL_OTHER , F.STATE_OTHER , ' ' , ' ' , ' ' , B.CREDENTIAL , B.CO_ITYPE , B.US_GOVT_EMP_IND , CASE B.US_GOVT_EMP_IND WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , B.FORN_ORG_EMP_IND , CASE B.FORN_ORG_EMP_IND WHEN 'Y' THEN 'Y: Yes' ELSE 'N: No' END , ' ' , B.USA_AGY_NAME , B.AMOUNT_REQUEST FROM PS_GM_XML_PROP_TBL A , PS_GM_EC_PERS_KP B , PS_GM_EC_ROLE C , PS_GM_PERS_ADDR_VW F , PS_GM_EC_INST N WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID AND A.PROPOSAL_ID = B.PROPOSAL_ID AND A.VERSION_ID = B.VERSION_ID AND A.SUB_PROP_NBR = B.SUB_PROP_NBR AND B.RECORD_ID = C.RECORD_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROPOSAL_ID = C.PROPOSAL_ID AND B.SUB_PROP_NBR = C.SUB_PROP_NBR AND B.ROW_NUMBER = C.ROW_NUMBER AND B.EMPLID = C.EMPLID AND B.VERSION_ID = C.VERSION_ID AND F.EMPLID = B.EMPLID AND A.OPRID = N.OPRID AND A.RUN_CNTL_ID = N.RUN_CNTL_ID

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 PROJECT_ROLE Character(30) VARCHAR2(30) NOT NULL Project Role
8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
9 BIRTHDATE Date(10) DATE Date of Birth
10 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title
11 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
12 PROF_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type

Prompt Table: GM_PROF_ROLE_TY

13 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
1=Mr.
2=Mrs.
3=Ms.
14 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
15 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
16 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
17 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
18 ORG_LEG_NAME Character(60) VARCHAR2(60) NOT NULL Organization Legal Name
19 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
20 DESCR_2 Character(30) VARCHAR2(30) NOT NULL Description
21 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
22 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
23 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
24 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
25 CITY Character(30) VARCHAR2(30) NOT NULL City
26 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
27 COUNTY Character(30) VARCHAR2(30) NOT NULL County
28 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
29 STATE Character(6) VARCHAR2(6) NOT NULL State
30 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
31 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
32 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
33 CREDENTIAL Character(60) VARCHAR2(60) NOT NULL Credentials
34 CO_ITYPE Character(40) VARCHAR2(40) NOT NULL NASA Co-Itype
35 US_GOVT_EMP_IND Character(1) VARCHAR2(1) NOT NULL US Government Employee
36 US_GOVT_EMP_IND_D Character(18) VARCHAR2(18) NOT NULL US Government Employee
37 FORN_ORG_EMP_IND Character(1) VARCHAR2(1) NOT NULL Foreign Organization Employee
38 FORN_ORG_EMP_IND_D Character(18) VARCHAR2(18) NOT NULL Foreign Organization Employee
39 OTH_PROJ_ROLE Character(30) VARCHAR2(30) NOT NULL Project Role
40 USA_AGY_NAME Character(80) VARCHAR2(80) NOT NULL US Government Agency Name
41 AMOUNT_REQUEST Number(27,3) DECIMAL(26,3) NOT NULL Amount Requested