SETIDINTEGRATION_TMPLDEPTIDLANGUAGE_CDDEPTID_PCAM_LVW(SQL View) |
Index Back |
|---|---|
Departments PC AM Lang ViewUsed to display Departments used in the Filter Criteria for the Projects to Assets integration. |
| SELECT DISTINCT A.SETID , A.INTEGRATION_TMPL , C.DEPTID , D.LANGUAGE_CD , D.DESCR FROM PS_PC_INT_TMPL_GL A , PS_SET_CNTRL_REC B , PS_DEPT_TBL C , PS_DEPT_TBL_LANG D WHERE A.BUSINESS_UNIT_GL = B.SETCNTRLVALUE AND B.RECNAME = 'DEPT_TBL' AND B.SETID = C.SETID AND %Join(COMMON_KEYS, DEPT_TBL C, DEPT_TBL_LANG D) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | INTEGRATION_TMPL |
Character(15) | VARCHAR2(15) NOT NULL | Integration |
| 3 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |