LIST_ID0=TCD Group
1=TaskGroup
10=Company
11=Paygroup
12=Grade
13=Step
14=Punch Type
15=Employee Status
16=Employee Type
2=TRC
3=WorkGroup
4=Union Code
5=Jobcode
6=Deptid
7=Position number
8=Location
9=Shift
TL_OT_LIST_VW(SQL View) |
Index Back |
|---|---|
List of TRC's from Value list |
| SELECT LIST_ID , LIST_TYPE , DESCR , DESCRSHORT FROM PS_TL_VAL_LIST_TBL WHERE LIST_TYPE = '2' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LIST_ID |
Character(12) | VARCHAR2(12) NOT NULL | List ID |
| 2 | LIST_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
List type for Values
0=TCD Group 1=TaskGroup 10=Company 11=Paygroup 12=Grade 13=Step 14=Punch Type 15=Employee Status 16=Employee Type 2=TRC 3=WorkGroup 4=Union Code 5=Jobcode 6=Deptid 7=Position number 8=Location 9=Shift |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |