RG_NOTE_TSK_LVW(SQL View) |
Index Back |
---|---|
Task Look Up ViewLanguage View Tasks for a Change Request in order to link to a Note |
SELECT A.CHANGE_REQUEST_ID , A.BUSINESS_UNIT , C.TASK_ID , C.LANGUAGE_CD , C.DESCR60 FROM PS_RG_CHANGE_REQ_L A , PS_RG_CHG_TASK_LVW B , PS_RB_TSK_LANG C WHERE A.CHANGE_REQUEST_ID = B.CHANGE_REQUEST_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(15) | VARCHAR2(15) NOT NULL | change request identification is key to change request | |
2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
3 | Number(15,0) | DECIMAL(15) NOT NULL | TaskIID field. Key for RB_TSK record. Used by Task Management. | |
4 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |