DIALOG_IDRY_DOC_LST_VW(SQL View) |
Index Back |
|---|---|
Document List View.Document List View for Overall Doc report. |
| SELECT A.DIALOG_ID , A.RY_DOC_ID , A.RY_MD_ID , B.RY_NAME254 , A.ROW_ADDED_OPRID , A.ROW_ADDED_DTTM FROM PS_RY_DOC A , PS_RY_DOC_VAR B WHERE A.RY_MD_ID = B.RY_MD_ID AND B.RY_DOC_TYPE IN (1,2,3,4) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DIALOG_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Dialog ID field to identify both design time and run time dialog. |
| 2 | RY_DOC_ID | Number(18,0) | DECIMAL(18) NOT NULL | Document ID - Dialog Document Main Sys ID |
| 3 | RY_MD_ID | Number(18,0) | DECIMAL(18) NOT NULL | Metadata ID - Dialog document metadata table |
| 4 | RY_NAME254 | Character(254) | VARCHAR2(254) NOT NULL | 254 character name field for names. |
| 5 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 6 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |