AUDIT_TLRPTTIME

(SQL Table)
 Index Back

Audit for Reported Time

Audit Table for Reported time

  • Audit Record Of TL_RPTD_TIME TL_RPT_TIME_HST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
    2 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp
    3 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
    A=Add
    C=Change Old (PPR Only)
    D=Delete
    K=Change - Old Values
    N=Change - New Values
    O=Change - Original Values
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    6 DUR Date(10) DATE NOT NULL Date Under Report associates time being reported, scheduled or paid, to a specific date.
    7 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    8 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
    0=Elapsed
    1=In
    2=Out
    3=Meal
    4=Break
    5=Transfer
    9 PUNCH_TIME Time(15) TIMESTAMP Punch Time
    10 PUNCH_DTTM DateTime(26) TIMESTAMP Date and time when the punch occurred.
    11 PUNCH_END DateTime(26) TIMESTAMP Punch out
    12 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
    13 TIMEZONE2 Character(9) VARCHAR2(9) NOT NULL Time Zone
    14 ST_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Session Number
    15 BADGE_ID Character(20) VARCHAR2(20) NOT NULL Badge ID
    16 TCD_ID Character(10) VARCHAR2(10) NOT NULL Time Collection Device Identification.
    17 RULE_ELEMENT_1 Character(10) VARCHAR2(10) NOT NULL Rule Element 1
    18 RULE_ELEMENT_2 Character(10) VARCHAR2(10) NOT NULL Rule Element 2
    19 RULE_ELEMENT_3 Character(10) VARCHAR2(10) NOT NULL Rule Element 3
    20 RULE_ELEMENT_4 Character(10) VARCHAR2(10) NOT NULL Rule Element 4
    21 RULE_ELEMENT_5 Character(10) VARCHAR2(10) NOT NULL Rule Element 5
    22 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

    Prompt Table: TL_TASKGRP_TBL

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

    Prompt Table: TL_TSKPRF

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

    Prompt Table: TL_OVRD_RSN_TBL

    27 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 Source
    SYS=Time and Labor System
    TCD=Time Collection Device
    28 REPORTED_STATUS Character(2) VARCHAR2(2) NOT NULL Reported Status
    AP=Approved
    CN=Cancelled
    DN=Denied
    IE=In Error
    NA=Needs Approval
    NW=New
    PB=Pushed Back
    PR=Processed
    SB=Submitted
    SV=Saved
    VD=Voided
    29 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last Operator to Update
    30 DTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
    31 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
    32 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor

    Prompt Table: TL_TRC_TBL

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

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

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

    Prompt Table: LOCAL_TAX_TBL

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

    Prompt Table: COMP_RT_REG_VW

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

    Y/N Table Edit

    Default Value: N

    40 OVERRIDE_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Override Rate.
    41 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    42 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    43 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
    44 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    45 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
    46 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    47 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
    48 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    49 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    50 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    51 CUSTOMER Character(10) VARCHAR2(10) NOT NULL Customer
    52 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
    53 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    54 BUSINESS_UNIT_PF Character(5) VARCHAR2(5) NOT NULL Perf Meas Business Unit
    55 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
    56 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity SetID
    57 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    58 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Resource Type
    59 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource SetID
    60 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Resource Category
    61 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Resource Sub Category
    62 TASK Character(5) VARCHAR2(5) NOT NULL Task
    63 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1
    64 USER_FIELD_2 Character(10) VARCHAR2(10) NOT NULL User Field 2
    65 USER_FIELD_3 Character(15) VARCHAR2(15) NOT NULL User Field 3
    66 USER_FIELD_4 Character(20) VARCHAR2(20) NOT NULL User Field 4
    67 USER_FIELD_5 Character(20) VARCHAR2(20) NOT NULL User Field 5