RY_OVR_RPT_VW(SQL View) |
Index Back |
|---|---|
Overall Doc Report.Overall Doc Rpt config search view. |
| SELECT DISTINCT A.BUSINESS_UNIT , A.DIALOG_ID , A.RY_DIALOG_NAME , A.RY_DIALOG_STATUS , A.RYE_OWNER , AA.OPRID FROM PS_RY_DIALOG A LEFT OUTER JOIN PS_RY_AGG_SCRTY_VW AA ON (A.DIALOG_ID = AA.DIALOG_ID) , PS_RY_DOC B , PS_RY_DOC_VAR C WHERE A.DIALOG_ID = B.DIALOG_ID AND B.RY_MD_ID = C.RY_MD_ID AND C.RY_DOC_TYPE IN (1,2,3,4) AND A.RY_DIALOG_STATUS <> 'D' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT |
| 2 | DIALOG_ID | Number(18,0) | DECIMAL(18) NOT NULL | Dialog ID field to identify both design time and run time dialog. |
| 3 | RY_DIALOG_NAME | Character(254) | VARCHAR2(254) NOT NULL | Field is used to capture a Dialog Name. |
| 4 | 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 |
| 5 | RYE_OWNER | Character(30) | VARCHAR2(30) NOT NULL | Dialog Designer:Owner ID used for Dialogs |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |