BUSINESS_UNITDIALOG_IDRY_DIALOG_NAMEA=Live
C=Archived
D=In Design
I=Completed
P=Paused
Q=Testing
S=Broadcast Hold
N=No
Y=Yes
RY_DIAGRPT_VW(SQL View) |
Index Back |
|---|---|
Dialog ViewDialog View Record - OLM, used for the dialog component on Dialog Name Lookup field. |
| SELECT BUSINESS_UNIT , DIALOG_ID , RY_DIALOG_NAME , RY_DIALOG_STATUS , IS_STAGING , DESCR254 FROM PS_RY_DIALOG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | 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 | IS_STAGING | Character(1) | VARCHAR2(1) NOT NULL |
Staging Dialog
N=No Y=Yes |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |