RY_EE_BUDLG_VW(SQL View) |
Index Back |
|---|---|
WFC Dialog ViewWorkforce Connect - A view used to display Dialog Name for reports |
| SELECT D.BUSINESS_UNIT %Concat '.' %Concat %NumToChar(D.DIALOG_ID) , D.DESCR254 FROM PS_RY_DIALOG D UNION SELECT D.BUSINESS_UNIT %Concat '.' %Concat %NumToChar(D.DIALOG_ID) , D.DESCR254 FROM PS_RYEDIALOG D |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SID_DIALOG | Character(25) | VARCHAR2(25) NOT NULL | SID for BU and DIALOG combination |
| 2 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |