LIST_TYPE0=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
LIST_IDVALUEGROUPWRK_TL_TA_LIST(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | LIST_ID |
Character(12) | VARCHAR2(12) NOT NULL | List ID |
| 3 | VALUEGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Group of Values for "Value List' |