GM_PCL_SPO_VW

(SQL View)
Index Back

SELECT A.SETID ,B.DEPTID , A.EMPLID , A.DESCRSHORT , A.DESCR FROM PS_GM_SPO_OFFICIAL A , PS_GM_DEPT_SUBDIV B WHERE B.SETID = A.SETID AND B.GM_SPO_ID = A.GM_SPO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description