TL_VALLST_AL_VW (SQL View)	Index Back
TL Value List View

TL_VALLST_AL_VW

(SQL View)

TL Value List View

SELECT DISTINCT LIST_TYPE ,LIST_ID ,DESCR ,DESCRSHORT FROM PS_TL_VAL_LIST_TBL

# 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
17=Attendance Violations
18=Absence Take
19=Compensatory Time Off Plan
2=Time Reporting Codes
20=Plan Type
21=Payable Status
22=Reported Status
23=Absence Status
24=Exception
25=Severity
26=Benefit Plan
27=Absence Entitlement
3=WorkGroup
4=Union Code
5=Jobcode
6=Department
7=Position number
8=Location
9=Shift

2 LIST_ID Character(12) VARCHAR2(12) NOT NULL List ID

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: TL_VAL_LIST_TBL.DESCR

#	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 17=Attendance Violations 18=Absence Take 19=Compensatory Time Off Plan 2=Time Reporting Codes 20=Plan Type 21=Payable Status 22=Reported Status 23=Absence Status 24=Exception 25=Severity 26=Benefit Plan 27=Absence Entitlement 3=WorkGroup 4=Union Code 5=Jobcode 6=Department 7=Position number 8=Location 9=Shift
2	LIST_ID	Character(12)	VARCHAR2(12) NOT NULL	List ID
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: TL_VAL_LIST_TBL.DESCR