RYEDOC_VAR_VW(SQL View) |
Index Back |
|---|---|
View for RYEDOC and RYEDOC_VARSQL view for joining RYEDOC and RYEDOC_VAR tables |
| SELECT PS_RYEDOC.RY_DOC_ID , PS_RYEDOC.RY_MD_ID , PS_RYEDOC.DIALOG_ID , PS_RYEDOC.RY_PGTEMPL_ID , PS_RYEDOC.RY_TITLE254 , PS_RYEDOC.LANGUAGE_CD , PS_RYEDOC.RY_STATUS , PS_RYEDOC.SETID , PS_RYEDOC.ROW_ADDED_DTTM , PS_RYEDOC.ROW_ADDED_OPRID , PS_RYEDOC.ROW_LASTMANT_DTTM , PS_RYEDOC.ROW_LASTMANT_OPRID , PS_RYEDOC.SYNCID , PS_RYEDOC.SYNCDTTM , PS_RYEDOC.REDIR_URL , PS_RYEDOC_VAR.RY_DOC_VAR_ID , PS_RYEDOC_VAR.RY_VARIANT_ID , PS_RYEDOC_VAR.RY_NAME254 , PS_RYEDOC_VAR.DESCR254 , PS_RYEDOC_VAR.RY_DOC_TYPE , PS_RYEDOC_VAR.RY_LEFT_MARGIN , PS_RYEDOC_VAR.RY_TOP_MARGIN , PS_RYEDOC_VAR.RY_BACKGRND_COLOR , PS_RYEDOC_VAR.RY_BACKGRND_IMAGE , PS_RYEDOC_VAR.RY_TEXT_COLOR , PS_RYEDOC_VAR.RY_VISIT_LINK_CLR , PS_RYEDOC_VAR.RY_UNVISITLINK_CLR , PS_RYEDOC_VAR.RY_FROM_MAIL_ID , PS_RYEDOC_VAR.RY_RPLY_MAIL_ID , PS_RYEDOC_VAR.RY_BOUN_MAIL_ID , PS_RYEDOC_VAR.RY_EMAIL_SUBJECT , PS_RYEDOC.RY_IS_SURVEY_DOC FROM PS_RYEDOC , PS_RYEDOC_VAR WHERE PS_RYEDOC.RY_MD_ID=PS_RYEDOC_VAR.RY_MD_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 | RY_MD_ID | Number(18,0) | DECIMAL(18) NOT NULL | Metadata ID - Dialog document metadata table |
| 3 | DIALOG_ID | Number(18,0) | DECIMAL(18) NOT NULL | Dialog ID field to identify both design time and run time dialog. |
| 4 | RY_PGTEMPL_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 5 | RY_TITLE254 | Character(254) | VARCHAR2(254) NOT NULL | Document Title - Dialog Document |
| 6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | RY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status for objects in the Dialog application.
A=Active C=Archived D=Design I=Inactive |
| 8 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 9 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 10 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 11 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 12 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 13 | 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. |
| 14 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
| 15 | REDIR_URL | Long Character(2000) | VARCHAR2(2000) | Alternate URL |
| 16 | RY_DOC_VAR_ID | Number(19,0) | DECIMAL(19) NOT NULL | Document Variant Id - RYEDOC_VAR |
| 17 | RY_VARIANT_ID | Number(4,0) | SMALLINT NOT NULL | Field used by Online Marketing. |
| 18 | RY_NAME254 | Character(254) | VARCHAR2(254) NOT NULL | 254 character name field for names. |
| 19 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 20 | RY_DOC_TYPE | Number(4,0) | SMALLINT NOT NULL | Document Type for Dialog Document, Either Email or Web |
| 21 | RY_LEFT_MARGIN | Number(4,0) | SMALLINT NOT NULL | Field used by Online Marketing. |
| 22 | RY_TOP_MARGIN | Number(4,0) | SMALLINT NOT NULL | Field used by Online Marketing. |
| 23 | RY_BACKGRND_COLOR | Character(50) | VARCHAR2(50) NOT NULL | Field used by Online Marketing. |
| 24 | RY_BACKGRND_IMAGE | Character(150) | VARCHAR2(150) NOT NULL | Field used by Online Marketing. |
| 25 | RY_TEXT_COLOR | Character(50) | VARCHAR2(50) NOT NULL | Field used by Online Marketing. |
| 26 | RY_VISIT_LINK_CLR | Character(50) | VARCHAR2(50) NOT NULL | Field used by Online Marketing. |
| 27 | RY_UNVISITLINK_CLR | Character(50) | VARCHAR2(50) NOT NULL | Field used by Online Marketing. |
| 28 | RY_FROM_MAIL_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 29 | RY_RPLY_MAIL_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 30 | RY_BOUN_MAIL_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 31 | RY_EMAIL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | OLM Email Document Subject Area |
| 32 | RY_IS_SURVEY_DOC | Character(1) | VARCHAR2(1) NOT NULL | Survey Document : identify if the documention is a survey document. |