RY_DOC_IDLANGUAGE_CDRYEDOC_SRCHL_VW(SQL View) |
Index Back |
|---|---|
Document Search ViewDocument Search View - RY_DOC_SRCH component |
| SELECT A.RY_DOC_ID , C.LANGUAGE_CD , B.RY_NAME254 , C.DESCR80 , D.RY_DIALOG_NAME FROM PS_RYEDOC A , PS_RYEDOC_VAR B , PS_RYEDOC_TYPE_LNG C , PS_RYEDIALOG D WHERE A.RY_MD_ID = B.RY_MD_ID AND B.RY_DOC_TYPE = C.RY_DOC_TYPE AND A.DIALOG_ID = D.DIALOG_ID(+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_DOC_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Document ID - Dialog Document Main Sys ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | RY_NAME254 | Character(254) | VARCHAR2(254) NOT NULL | 254 character name field for names. |
| 4 | DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | This generic field stores the description and used used on various tables. |
| 5 | RY_DIALOG_NAME | Character(254) | VARCHAR2(254) NOT NULL | Field is used to capture a Dialog Name. |