TL_RPT_LNGRD_VW

(SQL View)
 Index Back

Reported Time view

Reported Elapsed and Reported Punch time storage For Reported time Fluid approvals. Time details data in the line details page.

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

  • 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 TIMEZONE2 Character(9) VARCHAR2(9) NOT NULL Time Zone
    10 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor

    Prompt Table: TL_TRC_TBL

    11 TRC_DESCR Character(30) VARCHAR2(30) NOT NULL Time Reporting Code Descriptio
    12 TRC_TYPE Character(1) VARCHAR2(1) NOT NULL This defines TRC Type of Hours,Amounts ,Units
    A=Amount
    H=Hours
    U=Units
    13 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
    14 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

    Prompt Table: TL_TASKGRP_TBL

    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: COMP_RT_REG_VW

    20 OVERRIDE_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Override Rate.
    21 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Default Value: TL_EMPL_DATA.TIMEZONE

    Prompt Table: PSTIMEZONE

    22 OVERRIDE_RSN_CD Character(5) VARCHAR2(5) NOT NULL Override Reason Code

    Prompt Table: TL_OVRD_RSN_TBL

    23 BADGE_ID Character(20) VARCHAR2(20) NOT NULL Badge ID
    24 TCD_ID Character(10) VARCHAR2(10) NOT NULL Time Collection Device Identification.
    25 RULE_ELEMENT_1 Character(10) VARCHAR2(10) NOT NULL Rule Element 1

    Prompt Table: TL_RULE_ELEMNT1

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

    Prompt Table: TL_RULE_ELEMNT2

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

    Prompt Table: TL_RULE_ELEMNT3

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

    Prompt Table: TL_RULE_ELEMNT4

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

    Prompt Table: TL_RULE_ELEMNT5

    30 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
    31 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: TL_BUS_UNIT_VW

    33 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: TL_LOCATION_VW

    34 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: TL_DEPT_TBL_VW

    35 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: TL_JOBCODE_VW

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

    Prompt Table: POSITION_DATA

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

    Prompt Table: TL_CUSTOMER

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

    Prompt Table: TL_TASK

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

    Prompt Table: TL_PRODUCT_TBL

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

    Prompt Table: %EDIT_PROJECT

    41 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: %EDIT_ACTIVITY

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

    Prompt Table: TL_USER_FIELD_1

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

    Prompt Table: TL_USER_FIELD_2

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

    Prompt Table: TL_USER_FIELD_3

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

    Prompt Table: TL_USER_FIELD_4

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

    Prompt Table: TL_USER_FIELD_5

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

    Prompt Table: TL_ACCTCD_BU_VW

    48 ST_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Submit Time Instance
    49 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    50 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID

    Prompt Table: TL_TASKGRP_PRFL

    51 TCD_SUPERVISR_ID Character(20) VARCHAR2(20) NOT NULL TCD Supervisor ID
    52 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
    53 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last Operator to Update
    54 DTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
    55 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
    56 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

    Prompt Table: LOCAL_TAX_TBL

    57 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    58 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    59 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    60 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL Project Costing Business Unit

    Prompt Table: BUS_UNIT_PRJ_VW

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

    Prompt Table: BUS_UNIT_TBL_PF

    62 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity Set ID
    63 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Type

    Prompt Table: TL_PROJ_RTYPE_V

    64 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource Set ID
    65 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Category

    Prompt Table: %EDIT_RES_CAT

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

    Prompt Table: %EDIT_RES_SUB

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

    Default Value: N

    68 TL_LATITUDE Signed Number(20,15) DECIMAL(18,15) NOT NULL GPS Latitude
    69 TL_LONGITUDE Signed Number(20,15) DECIMAL(18,15) NOT NULL GPS Longitude
    70 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.
    71 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.
    72 SIGNED_DTTM DateTime(26) TIMESTAMP Field introduced to enable tracking of the employee signature on the timesheet.
    73 SIGNED_OPRID Character(30) VARCHAR2(30) NOT NULL Field introduced to capture the OPRID of the user signing off on reported time.