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 |