TL_PCH_DUR_WRK

(SQL Table)
 Index Back

Reported Punch Time

This table contains reported punch time.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 PUNCH_DTTM DateTime(26) TIMESTAMP Date and time when the punch occurred.
4 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
5 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer

Prompt Table: SCH_PUNCH4_VW

6 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

Default Value: TL_EMPL_DATA.TIMEZONE

Prompt Table: PSTIMEZONE

7 TCD_ID Character(10) VARCHAR2(10) NOT NULL Time Collection Device Identification.

Prompt Table: TL_TCD_TBL

8 BADGE_ID Character(20) VARCHAR2(20) NOT NULL Badge ID
9 RULE_ELEMENT_1 Character(10) VARCHAR2(10) NOT NULL Rule Element 1

Prompt Table: TL_RULE_ELEMNT1

10 RULE_ELEMENT_2 Character(10) VARCHAR2(10) NOT NULL Rule Element 2

Prompt Table: TL_RULE_ELEMNT2

11 RULE_ELEMENT_3 Character(10) VARCHAR2(10) NOT NULL Rule Element 3

Prompt Table: TL_RULE_ELEMNT3

12 RULE_ELEMENT_4 Character(10) VARCHAR2(10) NOT NULL Rule Element 4

Prompt Table: TL_RULE_ELEMNT4

13 RULE_ELEMENT_5 Character(10) VARCHAR2(10) NOT NULL Rule Element 5

Prompt Table: TL_RULE_ELEMNT5

14 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

Prompt Table: TL_TASKGRP_TBL

15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

16 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

17 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

Prompt Table: LOCAL_TAX_TBL

18 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
19 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID

Prompt Table: TL_TASKGRP_PRFL

20 TCD_SUPERVISR_ID Character(20) VARCHAR2(20) NOT NULL TCD Supervisor ID
21 OVERRIDE_RSN_CD Character(5) VARCHAR2(5) NOT NULL Override Reason Code

Prompt Table: TL_OVRD_RSN_TBL

22 RT_SOURCE Character(3) VARCHAR2(3) NOT NULL Reported Time Source. the originator of Reported Time
AM=Absence Management
MD=Mobile Device
ONL=Online
SCH=Schedule
SYS=Time and Labor System
TCD=Time Collection Device
23 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

24 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: TL_BUS_UNIT_VW

25 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
26 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: TL_LOCATION_VW

27 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
28 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: TL_DEPT_TBL_VW

29 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
30 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: TL_JOBCODE_VW

31 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

Prompt Table: POSITION_DATA

32 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product

Prompt Table: TL_PRODUCT_TBL

33 CUSTOMER Character(10) VARCHAR2(10) NOT NULL Customer

Prompt Table: TL_CUSTOMER

34 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

Prompt Table: TL_ACCTCD_BU_VW

35 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL Project Costing Business Unit

Prompt Table: BUS_UNIT_PRJ_VW

36 BUSINESS_UNIT_PF Character(5) VARCHAR2(5) NOT NULL Perf Meas Business Unit

Prompt Table: BUS_UNIT_TBL_PF

37 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant

Prompt Table: %EDIT_PROJECT

38 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity Set ID
39 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

40 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Type

Prompt Table: TL_PROJ_RTYPE_V

41 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource Set ID
42 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Category

Prompt Table: %EDIT_RES_CAT

43 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Sub Category

Prompt Table: %EDIT_RES_SUB

44 TASK Character(5) VARCHAR2(5) NOT NULL Task

Prompt Table: TL_TASK

45 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1

Prompt Table: TL_USER_FIELD_1

46 USER_FIELD_2 Character(10) VARCHAR2(10) NOT NULL User Field 2

Prompt Table: TL_USER_FIELD_2

47 USER_FIELD_3 Character(15) VARCHAR2(15) NOT NULL User Field 3

Prompt Table: TL_USER_FIELD_3

48 USER_FIELD_4 Character(20) VARCHAR2(20) NOT NULL User Field 4

Prompt Table: TL_USER_FIELD_4

49 USER_FIELD_5 Character(20) VARCHAR2(20) NOT NULL User Field 5

Prompt Table: TL_USER_FIELD_5

50 TL_COMMENTS Character(254) VARCHAR2(254) NOT NULL Comments