GM_PT_EE_VW

(SQL View)
 Index Back

Employee Search View


SELECT DISTINCT %Substring(A.TEAM_MEMBER, 1, 11) , B.ACCESS_CD , %subrec(NAMEGBL_NPC_SBR,D) FROM PS_PROJECT_TEAM A , PS_GM_PT_ACCESS B , PS_PERSONAL_DATA D WHERE A.TEAM_MEMBER_CLASS = 'L' AND A.TEAM_MEMBER_IND = 'E' AND A.PLAN_PROJROLE = B.PROJ_ROLE AND B.AWARD_FLAG = 'Y' AND B.ACCESS_CD <> 'N' AND %Substring(A.TEAM_MEMBER, 1, 11) = D.EMPLID UNION SELECT DISTINCT A1.GM_ADMIN_CNTCT , B1.ACCESS_CD , %subrec(NAMEGBL_NPC_SBR,D1) FROM PS_GM_AWARD A1 , PS_GM_PT_ACCESS B1 , PS_PERSONAL_DATA D1 WHERE B1.PROJ_ROLE = 'ADM' AND B1.AWARD_FLAG = 'Y' AND B1.ACCESS_CD <> 'N' AND A1.GM_ADMIN_CNTCT <> ' ' AND A1.GM_ADMIN_CNTCT = A1.EMPLID UNION SELECT A3.EMPLID , 'Y' , %subrec(NAMEGBL_NPC_SBR,D3) FROM PS_GM_PT_ACC_LVL1 A3 , PS_PERSONAL_DATA D3 WHERE A3.ADMIN_FLAG = 'Y' AND A3.EMPLID = D3.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
N=No Access
R=Read Only Access
Y=Read/Write Access
3 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Format for Country
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
6 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
1=Mr.
2=Mrs.
3=Ms.
7 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
8 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
9 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
10 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
11 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
12 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
13 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
14 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
15 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
16 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
17 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
18 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
19 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name