CONT_JBTTL_DESC

(SQL View)
Index Back

Contact Jobtitles


SELECT A.SETID , A.CONTACT_ID ,B.DESCR100 FROM %Table(CONT_JBTTL_CUR) A , %Table(FO_JOBTITLE) B WHERE A.JOB_CAT = B.JOB_CAT AND A.FO_JOBTITLE = B.FO_JOBTITLE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description