EX_TIME_HDR

(SQL Table)
 Index Back

Time Report Header

This is one of the core records for Expenses. It is the highest level definition for a Time Report. The key is

  • Parent Record Of EX_ED_POL_TIME EX_ED_PRJ_TIME EX_PRJTIME_VW EX_TIME_ADJ_VW EX_TIME_DTL EX_TIME_DTL_H EX_TIME_POL EX_TIME_POL_H EX_TIME_QUIK_VW EX_TMDTL_ADJ_VW

    • # 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)

    Default Value: NEXT

    2 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number

    Default Value: 1

    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 PERIOD_END_DT Date(10) DATE NOT NULL Represents the date termination point for a given time set utilized in cash worksheet processing.
    5 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

    Default Value: PND

    6 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

    7 EX_ORIGIN Character(1) VARCHAR2(1) NOT NULL Origin of Entry (Expenses)
    A=Asset Lifecycle Management
    H=Mobile Hand Held Device
    M=Mobile Time and Expense
    N=NUI
    P=Primavera P6
    W=Web

    Default Value: W

    8 APPROVAL_LEVEL Character(1) VARCHAR2(1) NOT NULL Approval Level
    A=Approver Only
    B=Pre- and Post-Pay Audit
    E=Approver & Pre-Pay Auditor
    I=Approve, Pre- & Post-Pay Audit
    N=None
    S=Approver & Post-Pay Auditor
    T=Auditor Only - Post-Payment
    U=Auditor Only - Pre-Payment
    9 CREATION_DT Date(10) DATE Creation Date

    Default Value: %date

    10 APPROVAL_DT Date(10) DATE Date of Approval
    11 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
    12 AUDIT_DT Date(10) DATE Date of Audit
    13 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
    14 SUBMISSION_DATE Date(10) DATE Submission Date
    15 SUBMIT_OPRID Character(30) VARCHAR2(30) NOT NULL Report Submitted By - Character (30)
    16 RESUBMISSION_DT Date(10) DATE Resubmission Date
    17 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update
    18 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL

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

    Default Value: EX_AA_EE_ORG_VW.DEPTID

    20 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

    Default Value: EX_AA_EE_ORG_VW.EMPL_RCD

    21 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    22 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
    A=Purge All
    S=Only purge items with at least

    Default Value: N

    23 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
    24 PROJ_MGR_FLAG Character(1) VARCHAR2(1) NOT NULL Project Manager Review

    Default Value: N

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

    27 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    28 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

    Prompt Table: LOCAL_TAX_VW

    29 BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
    B=Billable
    I=Internal
    P=Personal
    U=Nonbillable

    Default Value: B

    30 COMMENTS Long Character CLOB Comment
    31 OPRID_SUBMITTED_BY Character(30) VARCHAR2(30) NOT NULL Operator Id of user submitting the transaction
    32 ACKNOWLEDGE_DTTM DateTime(26) TIMESTAMP Acknowledge Date Time
    33 DTL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL Total
    34 POL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL PolTotal
    35 VERSION_LBL Character(1) VARCHAR2(1) NOT NULL Used to show version in search pages
    O=Original Version
    P=Partial Submit
    R=Revision

    Default Value: O

    36 APPR_PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Approval in Process Flag

    Y/N Table Edit

    Default Value: N

    37 DATE_TIME_HM DateTime(26) TIMESTAMP Date Timestamp
    38 OPRID_LAST_ACTION Character(30) VARCHAR2(30) NOT NULL Last User to Take Action
    39 ACTION_NAME Character(3) VARCHAR2(3) NOT NULL Action taken on a transaction
    APR=Approved
    AUT=Auto Approved
    BUD=Budget Checked
    DEL=Deleted
    DNY=Denied
    HLD=On Hold
    PAS=Post Approval Submit
    REC=Receipt Verified
    RES=Resubmitted
    REV=Reviewed
    RSN=Reassigned
    SBR=Sent Back For Revision
    SUB=Submitted
    WDR=Withdrawn
    40 OUT_OF_POLICY Character(1) VARCHAR2(1) NOT NULL Authorized Amount Exceeded

    Y/N Table Edit

    Default Value: N

    41 RISK_EXISTS_FLG Character(1) VARCHAR2(1) NOT NULL Risk Exists

    Y/N Table Edit

    Default Value: N

    42 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