RY_IND_RPT_VW

(SQL View)
 Index Back

Individual Doc Report Search.

Search view for Individual Document Report.

SELECT B.RY_FLOW_INS_ID , A.BAS_SYSID , C.DIALOG_ID , A.BO_ID , A.ROLE_TYPE_ID , C.BUSINESS_UNIT , C.RY_DIALOG_NAME , C.RY_DIALOG_STATUS , B.RY_SRVY_SCORE , B.RY_STATUS_SRVY , B.RY_STATUS_SRVY , B.RY_ORA_EXT_ID , B.RY_ORA_EXT_TYPE , B.RY_ORA_EXT_BU , B.RY_ORA_EXT_INS_ID , B.ROW_LASTMANT_DTTM , A.NAME , D.BO_NAME_DISPLAY , CC.OPRID FROM PS_BO_BASIC_IND A , PS_RY_FLOW_INST B , PS_RY_DIALOG C LEFT OUTER JOIN PS_RY_IND_SCRTY_VW CC ON (C.DIALOG_ID = CC.DIALOG_ID) , PS_BO_NAME_PRIM_VW D WHERE B.DIALOG_ID = C.DIALOG_ID AND A.BAS_SYSID = B.RY_IND_ID AND A.BO_ID = D.BO_ID AND B.RY_STATUS_SRVY <> 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RY_FLOW_INS_ID Number(18,0) DECIMAL(18) NOT NULL Dialog Flow Instance ID
2 BAS_SYSID Number(18,0) DECIMAL(18) NOT NULL Basic Data System ID
3 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
4 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
5 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

7 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.
8 RY_STATUS_TRN Character(1) VARCHAR2(1) NOT NULL Dialog Status field used to do translates.
A=Live
C=Archived
D=In Design
I=Completed
P=Paused
Q=Testing
S=Broadcast Hold
9 RY_SRVY_SCORE Signed Number(19,0) DECIMAL(18) NOT NULL Survey Overall score -- overall running score for a survey instance.
10 RY_STATUS_SRVY Character(1) VARCHAR2(1) NOT NULL Survey Status - 'Open' or 'Complete'
C=Complete
I=Initial
O=Open
11 STATUS_SRVY_CO Character(1) VARCHAR2(1) NOT NULL Survey Status - 'Open' or 'Complete'
C=Complete
O=Open
12 RY_ORA_EXT_ID Number(18,0) DECIMAL(18) NOT NULL Survey External Id - external system id for integration
13 RY_ORA_EXT_TYPE Character(8) VARCHAR2(8) NOT NULL Survey External Type -- external system type for integration
14 RY_ORA_EXT_BU Character(5) VARCHAR2(5) NOT NULL Survey External Business Unit for integration
15 RY_ORA_EXT_INS_ID Number(18,0) DECIMAL(18) NOT NULL Survey External Instance Id -- survey instance id from external system for integration
16 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
17 NAME Character(50) VARCHAR2(50) NOT NULL Name
18 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
19 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).