TL_SRCH_VAL_VW(SQL View) |
Index Back |
|---|---|
TL Srch Idx Value ListFetches TRC from Value List for Work Vs Non Work Type |
| SELECT R.DESCR , D.VALUEGROUP FROM PS_TL_VAL_LIST_TBL R , PS_TL_VAL_LIST_DTL D WHERE R.LIST_ID =D.LIST_ID AND R.LIST_TYPE =D.LIST_TYPE AND R.LIST_ID IN ('WRKTRC','NONWRKTRC') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 2 | VALUEGROUP | Character(20) | VARCHAR2(20) NOT NULL | This field contains the value of an item in a Value List; a List Item if you will. |