EX_ED_POL_TIME

(SQL View)
 Index Back

Time Report Detail

This record contains all of the policy information for a Time Card.

SELECT POL.TIME_SHEET_ID , POL.VERSION_NUM , POL.LINE_NBR , HDR.BUSINESS_UNIT_GL , HDR.PERIOD_END_DT , HDR.EMPLID , PER.NAME , HDR.TIME_SHEET_STATUS , XLAT.XLATLONGNAME , HDR.BILLING_ACTION , HDR.CREATION_DT , HDR.APPROVAL_DT , HDR.SUBMISSION_DATE , HDR.RESUBMISSION_DT , SUM(DLY.TIME_QUANTITY) , POL.TRC , MAP.DESCR , POL.DESCR60 , HDR.POST_STATUS_EX , HDR.LASTUPDDTTM FROM PS_EX_TIME_POL POL , PS_EX_TIME_HDR HDR , PS_EX_TIME_POL_DLY DLY , XLATTABLE_VW XLAT , PS_PERSONAL_DATA PER , PS_EX_TRC_MAP_TBL MAP , PS_EID_ETL_LASTRUN LR WHERE HDR.TIME_SHEET_ID = POL.TIME_SHEET_ID AND HDR.VERSION_NUM = POL.VERSION_NUM AND HDR.VERSION_NUM = ( SELECT MAX(X.VERSION_NUM) FROM PS_EX_TIME_HDR X WHERE HDR.TIME_SHEET_ID = X.TIME_SHEET_ID) AND POL.TIME_SHEET_ID = DLY.TIME_SHEET_ID AND POL.VERSION_NUM = DLY.VERSION_NUM AND POL.LINE_NBR = DLY.LINE_NBR AND XLAT.FIELDNAME = 'TIME_SHEET_STATUS' AND XLAT.FIELDVALUE = HDR.TIME_SHEET_STATUS AND PER.EMPLID = HDR.EMPLID AND HDR.TIME_SHEET_STATUS NOT IN ('DEN', 'DNA', 'DNU', 'MFS', 'PND') AND HDR.SETID = MAP.SETID AND POL.TRC = MAP.TRC AND %DateDiff(HDR.CREATION_DT, %CurrentDateIn) < 1826 AND LR.EID_DS_ID = 'Expenses' AND POL.LASTUPDDTTM >= LR.LAST_RUN_DTM GROUP BY POL.TIME_SHEET_ID , POL.VERSION_NUM , POL.LINE_NBR , HDR.BUSINESS_UNIT_GL , HDR.PERIOD_END_DT , HDR.EMPLID , PER.NAME , HDR.TIME_SHEET_STATUS , XLAT.XLATLONGNAME , HDR.BILLING_ACTION , HDR.CREATION_DT , HDR.APPROVAL_DT , HDR.SUBMISSION_DATE , HDR.RESUBMISSION_DT , POL.TRC , MAP.DESCR , POL.DESCR60 , HDR.POST_STATUS_EX , HDR.LASTUPDDTTM

  • Parent record: EX_TIME_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
    2 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number

    Default Value: 1

    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

    Default Value: 1

    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    7 NAME Character(50) VARCHAR2(50) NOT NULL Name
    8 TIME_SHEET_STATUS Character(3) VARCHAR2(3) NOT NULL Time Sheet Status
    ADJ=Adjusted
    APR=Approved
    DEN=Denied
    DNA=Denied by Approver
    DNU=Denied by Project Manager
    HDA=Hold by Approver
    HDU=Hold by Project Manager
    HLD=Hold
    MFS=Marked for Submit
    PAR=Approvals in Process
    PND=Pending
    PRO=In Process
    SFA=Submission in Process
    SUB=Submitted for Approval
    XML=Submitted, Pending Validation
    9 STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL Status Description
    10 BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
    B=Billable
    I=Internal
    P=Personal
    U=Nonbillable

    Default Value: EX_TIME_HDR.BILLING_ACTION

    11 CREATION_DT Date(10) DATE Creation Date
    12 APPROVAL_DT Date(10) DATE Date of Approval
    13 SUBMISSION_DATE Date(10) DATE Submission Date
    14 RESUBMISSION_DT Date(10) DATE Resubmission Date
    15 TIME_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Time Quantity
    16 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
    17 TRC_DESCR Character(30) VARCHAR2(30) NOT NULL TRC (time reporting code) Description
    18 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    19 POST_STATUS_EX Character(1) VARCHAR2(1) NOT NULL Expenses Post Status
    C=Closed
    M=Marked for Unpost
    N=Not Applied
    O=Unpost In Process
    P=Posted
    S=Close In Process
    U=Unposted

    Default Value: N

    20 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.

    Default Value: %datetime