SCC_LOV_UIDSCC_SL_LOV_VW(SQL View) |
Index Back |
|---|---|
LOV Name ViewThis view is used to search for LOV values to be used in the rules engine. |
| SELECT SCC_LOV_UID , DESCR , SCC_SL_LOV_CONTEXT , EDITTABLE , PROMPTFIELD , FIELDNAME_DESCR FROM PS_SCC_SL_LOV_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_LOV_UID |
Character(40) | VARCHAR2(40) NOT NULL | LOV Unique ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | SCC_SL_LOV_CONTEXT | Character(25) | VARCHAR2(25) NOT NULL | LOV Context |
| 4 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL | Edit Table |
| 5 | PROMPTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Dropdown Prompt Field |
| 6 | FIELDNAME_DESCR | Character(18) | VARCHAR2(18) NOT NULL | Fieldname Journal Line Descr |