PC_IM_ISSUE_LN(SQL View) |
Index Back |
---|---|
PC Issue Management IssuesRelated Language Table |
SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.PC_IM_ISSUE_ID , A.LANGUAGE_CD , B.DESCR , A.PC_IM_SUMMARY FROM PS_PC_IM_ISSUE_LNG A , PS_PROJECT_LANG B WHERE A.PROJECT_ID = B.PROJECT_ID AND A.LANGUAGE_CD = B.LANGUAGE_CD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
2 | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField | |
3 | Character(15) | VARCHAR2(15) NOT NULL | Issue ID | |
4 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Description
Default Value: PROJECT.DESCR |
6 | PC_IM_SUMMARY | Character(100) | VARCHAR2(100) NOT NULL | Issue Summary |