RY_BULK_JOB_IDLANGUAGE_CDRY_MAILJOB_LNG(SQL View) |
Index Back |
|---|---|
Language SQL viewLanguage mail job report SQL view |
| SELECT bjob.RY_BULK_JOB_ID , dlg.LANGUAGE_CD , dlg.RY_DIALOG_NAME FROM PS_RY_BULK_JOB bjob ,PS_RY_ACT_TASK act ,PS_RYEDIALOG_LNG dlg ,PS_RY_ACT_TASK ms WHERE bjob.RY_ACTION_ID=act.RY_ACTION_ID AND act.DIALOG_ID=dlg.DIALOG_ID AND act.RY_MILESTN_ID=ms.RY_ACTION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_BULK_JOB_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | RY_DIALOG_NAME | Character(254) | VARCHAR2(254) NOT NULL | Field is used to capture a Dialog Name. |