TL_RPTD_TIME_VW

(SQL View)
 Index Back

Reported Time view

Reported Elapsed and Reported Punch time storage. Punch Time Storage Punch Type = '0' for elapsed Dur = Local time zone Date for Punch time Time = Local time zone Time for Punch time Punch Dttm = Base time zone Punch Date time for Punch time

SELECT RT.EMPLID , RT.EMPL_RCD , RT.DUR , RT.SEQ_NBR , RT.PUNCH_TYPE , RT.PUNCH_TIME , RT.PUNCH_DTTM , RT.PUNCH_END , RT.TIMEZONE , RT.TIMEZONE2 , RT.ST_INSTANCE , RT.BADGE_ID , RT.TCD_ID , RT.RULE_ELEMENT_1 , RT.RULE_ELEMENT_2 , RT.RULE_ELEMENT_3 , RT.RULE_ELEMENT_4 , RT.RULE_ELEMENT_5 , RT.TASKGROUP , RT.OPRID , RT.TASK_PROFILE_ID , RT.TCD_SUPERVISR_ID , RT.OVERRIDE_RSN_CD , RT.RT_SOURCE , RT.REPORTED_STATUS , RT.OPRID_LAST_UPDT , RT.DTTM_MODIFIED , RT.DTTM_CREATED , RT.TRC , RT.TL_QUANTITY , RT.CURRENCY_CD , RT.COUNTRY , RT.STATE , RT.LOCALITY , RT.COMP_RATECD , RT.BILLABLE_IND , RT.OVERRIDE_RATE , RT.COMPANY , RT.BUSINESS_UNIT , RT.SETID_LOCATION , RT.LOCATION , RT.SETID_DEPT , RT.DEPTID , RT.SETID_JOBCODE , RT.JOBCODE , RT.POSITION_NBR , RT.PRODUCT , RT.CUSTOMER , RT.ACCT_CD , RT.BUSINESS_UNIT_PC , RT.BUSINESS_UNIT_PF , RT.PROJECT_ID , RT.SETID_ACTIVITY , RT.ACTIVITY_ID , RT.RESOURCE_TYPE , RT.SETID_RESOURCE , RT.RESOURCE_CATEGORY , RT.RESOURCE_SUB_CAT , RT.TASK , RT.USER_FIELD_1 , RT.USER_FIELD_2 , RT.USER_FIELD_3 , RT.USER_FIELD_4 , RT.USER_FIELD_5 , RT.TL_GPS_IND , RT.TL_LATITUDE , RT.TL_LONGITUDE , RT.SYNCID , RT.LASTUPDDTTM , RT.SIGNED_DTTM , RT.SIGNED_OPRID , A.DESCR , A.TRC_TYPE FROM PS_TL_RPTD_TIME RT , PS_TL_TRC_TBL A WHERE A.TRC = RT.TRC AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_TL_TRC_TBL A1 WHERE A1.TRC = A.TRC AND A1.EFFDT <= RT.DUR)

  • Audit Record: AUDIT_TLRPTTIME

    • # 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 DUR Date(10) DATE NOT NULL Date Under Report associates time being reported, scheduled or paid, to a specific date.
    4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    5 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
    0=Elapsed
    1=In
    2=Out
    3=Meal
    4=Break
    5=Transfer
    6 PUNCH_TIME Time(15) TIMESTAMP punch time
    7 PUNCH_DTTM DateTime(26) TIMESTAMP Date and time when the punch occurred.
    8 PUNCH_END DateTime(26) TIMESTAMP Field typically used to record the end of a given punch (which is generally defined as the time of the consecutive punch, unless it is an OUT punch in which case BEGIN and END time is set to the same time).
    9 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Default Value: TL_EMPL_DATA.TIMEZONE

    Prompt Table: PSTIMEZONE

    10 TIMEZONE2 Character(9) VARCHAR2(9) NOT NULL Time Zone
    11 ST_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Submit Time Instance
    12 BADGE_ID Character(20) VARCHAR2(20) NOT NULL Badge ID
    13 TCD_ID Character(10) VARCHAR2(10) NOT NULL Time Collection Device Identification.
    14 RULE_ELEMENT_1 Character(10) VARCHAR2(10) NOT NULL Rule Element 1

    Prompt Table: TL_RULE_ELEMNT1

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

    Prompt Table: TL_RULE_ELEMNT2

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

    Prompt Table: TL_RULE_ELEMNT3

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

    Prompt Table: TL_RULE_ELEMNT4

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

    Prompt Table: TL_RULE_ELEMNT5

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

    Prompt Table: TL_TASKGRP_TBL

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

    Prompt Table: TL_TASKGRP_PRFL

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

    Prompt Table: TL_OVRD_RSN_TBL

    24 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
    25 REPORTED_STATUS Character(2) VARCHAR2(2) NOT NULL Reported Status
    AP=Approved
    DN=Denied
    IP=Approval In Process
    NA=Needs Approval
    NW=New
    PB=Pushed Back
    PR=Processed
    SB=Submitted
    SV=Saved
    26 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last Operator to Update
    27 DTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
    28 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
    29 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor

    Prompt Table: TL_TRC_TBL

    30 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
    31 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

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

    Prompt Table: LOCAL_TAX_TBL

    35 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

    Prompt Table: COMP_RT_REG_VW

    36 BILLABLE_IND Character(1) VARCHAR2(1) NOT NULL Billable Indicator
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    37 OVERRIDE_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Override Rate.
    38 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: TL_BUS_UNIT_VW

    40 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    41 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: TL_LOCATION_VW

    42 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    43 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: TL_DEPT_TBL_VW

    44 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    45 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: TL_JOBCODE_VW

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

    Prompt Table: POSITION_DATA

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

    Prompt Table: TL_PRODUCT_TBL

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

    Prompt Table: TL_CUSTOMER

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

    Prompt Table: TL_ACCTCD_BU_VW

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

    Prompt Table: BUS_UNIT_PRJ_VW

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

    Prompt Table: BUS_UNIT_TBL_PF

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

    Prompt Table: %EDIT_PROJECT

    53 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity Set ID
    54 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: %EDIT_ACTIVITY

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

    Prompt Table: TL_PROJ_RTYPE_V

    56 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource Set ID
    57 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Category

    Prompt Table: %EDIT_RES_CAT

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

    Prompt Table: %EDIT_RES_SUB

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

    Prompt Table: TL_TASK

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

    Prompt Table: TL_USER_FIELD_1

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

    Prompt Table: TL_USER_FIELD_2

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

    Prompt Table: TL_USER_FIELD_3

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

    Prompt Table: TL_USER_FIELD_4

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

    Prompt Table: TL_USER_FIELD_5

    65 TL_GPS_IND Character(1) VARCHAR2(1) NOT NULL GPS tracking indicator. Value Y or N

    Default Value: N

    66 TL_LATITUDE Signed Number(20,15) DECIMAL(18,15) NOT NULL GPS Latitude
    67 TL_LONGITUDE Signed Number(20,15) DECIMAL(18,15) NOT NULL GPS Longitude
    68 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    69 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    70 SIGNED_DTTM DateTime(26) TIMESTAMP Field introduced to enable tracking of the employee signature on the timesheet.
    71 SIGNED_OPRID Character(30) VARCHAR2(30) NOT NULL Field introduced to capture the OPRID of the user signing off on reported time.
    72 TRC_DESCR Character(30) VARCHAR2(30) NOT NULL Time Reporting Code Descriptio
    73 TRC_TYPE Character(1) VARCHAR2(1) NOT NULL This defines TRC Type of Hours,Amounts ,Units
    A=Amount
    H=Hours
    U=Units