RC_SS_ISSUES_VW (SQL View)	Index Back
Global Issue listing view Global Issue listing view for self service

RC_SS_ISSUES_VW

(SQL View)

Global Issue listing view

Global Issue listing view for self service

SELECT PS_RC_SS_ISSUES.DISP_TMPL_FAM_CD ,PS_RC_SS_ISSUES.BUSINESS_UNIT ,PS_RC_SS_ISSUES.CASE_ID ,PS_RC_SS_ISSUES.SELECT_FLG ,PS_RC_CASE.RC_SUMMARY ,PS_RC_CASE.RC_STATUS ,PS_RC_CASE.CREATION_DATE ,PS_RC_CASE.ROW_ADDED_DTTM ,PS_RC_CASE.ROW_ADDED_OPRID ,PS_RC_CASE.ROW_LASTMANT_DTTM ,PS_RC_CASE.ROW_LASTMANT_OPRID ,PS_RC_CASE.SYNCID ,PS_RC_CASE.SYNCDTTM FROM PS_RC_SS_ISSUES INNER JOIN PS_RC_CASE ON(PS_RC_SS_ISSUES.CASE_ID=PS_RC_CASE.CASE_ID AND PS_RC_SS_ISSUES.BUSINESS_UNIT=PS_RC_CASE.BUSINESS_UNIT AND PS_RC_SS_ISSUES.DISP_TMPL_FAM_CD=PS_RC_CASE.DISP_TMPL_FAM_CD) AND PS_RC_SS_ISSUES.SELECT_FLG='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
Prompt Table: RC_SELF_SERVICE

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: RC_CASEISSUES_V

3 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
Prompt Table: RC_CASEISSUES_V

4 SELECT_FLG Character(1) VARCHAR2(1) NOT NULL Field is a flag for selection .
Y/N Table Edit

5 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.

6 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status

7 CREATION_DATE Date(10) DATE Creation date of the case.

8 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

9 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

10 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

11 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

12 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

13 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code Prompt Table: RC_SELF_SERVICE
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: RC_CASEISSUES_V
3	CASE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table. Prompt Table: RC_CASEISSUES_V
4	SELECT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Field is a flag for selection . Y/N Table Edit
5	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
6	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status
7	CREATION_DATE	Date(10)	DATE	Creation date of the case.
8	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
9	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
10	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
11	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
12	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
13	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time