SET_JOBCDVW_LNG(SQL View) |
Index Back |
---|---|
Jobcode view/*bu/setid 09/19/1997 */ View to get the values from jobcode_tbl on careerpath_tbl.next_posn_jobcd carresponding to careerpath_tbl.setid_jobcode. |
SELECT DISTINCT SETID ,JOBCODE ,LANGUAGE_CD ,DESCRSHORT ,DESCR FROM PS_JOBCODE_LANG |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
2 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |