SPA_TM_CAL_ADJV

(SQL View)
 Index Back

Time Report Detail adjust

This record contains all of the detail information for a Time Card adjustment for regular time.

SELECT D.BUSINESS_UNIT ,D.TIME_SHEET_ID ,D.WORK_ORDER_ID , D.HISTORY_DTTM ,D.LINE_NBR ,D.DISTRIB_LINE_NUM ,D.ACTIVITY_ID ,D.SHIFT_ID ,D.ASSIGNMENT_ID ,D.TIME_LINE_STATUS ,D.SPA_BILLING_ACTION ,D.SP_TIME_QTY ,D.TIME_AMOUNT ,D.TIME_AMOUNT_BSE ,D.APPROVAL_OPRID ,D.APPROVAL_DT ,D.APPR_RATINGS ,D.APPR_RATING_NUM ,D.TE_INVOICE_FLG ,D.INVOICE_ID ,D.INVOICE_LINE ,D.INV_LINE_STATUS ,D.SP_MSP_FEE ,D.SP_MSP_FEE_BSE ,D.PC_DISTRIB_STATUS ,D.CURRENCY_CD ,D.CURRENCY_CD_BASE ,D.DESCR60 ,D.DESCR254 FROM PS_SPA_TIM_DTL_ADJ D

  • Parent record: SPA_TIME_WO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
    3 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
    4 HISTORY_DTTM DateTime(26) TIMESTAMP History Date/Time
    5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

    Default Value: 1

    6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

    Prompt Table: SPF_WO_DIST_VW

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

    Prompt Table: SPF_ACTIVITY_VW

    8 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID

    Prompt Table: SPA_TIM_SHFT_VW

    9 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

    Prompt Table: SPA_TIM_ASGN_VW

    10 TIME_LINE_STATUS Character(3) VARCHAR2(3) NOT NULL Time Line Status
    ADJ=Adjusted
    APR=Approved
    DEN=Denied
    OPN=Open
    PND=Pending
    SUB=Submitted
    11 SPA_BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
    B=Billable
    U=Nonbillable

    Default Value: B

    12 SP_TIME_QTY Signed Number(18,4) DECIMAL(16,4) NOT NULL Time Quantity
    13 TIME_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Time Amount
    14 TIME_AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Time Amount Base Currency
    15 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
    16 APPROVAL_DT Date(10) DATE Date of Approval
    17 APPR_RATINGS Character(1) VARCHAR2(1) NOT NULL Approver ratings of contractor.
    E=Excellent
    F=Fair
    G=Good
    N=None
    P=Poor

    Default Value: N

    18 APPR_RATING_NUM Number(4,2) DECIMAL(3,2) NOT NULL Performance Rating

    Default Value: 0

    19 TE_INVOICE_FLG Character(1) VARCHAR2(1) NOT NULL Time and expense invoiced flag
    N=No
    Y=Yes

    Default Value: N

    20 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    21 INVOICE_LINE Number(5,0) INTEGER NOT NULL Invoice Line
    22 INV_LINE_STATUS Character(4) VARCHAR2(4) NOT NULL Invoice Line Status
    1=Generated
    10=Adjusted by Ent Approver
    11=Adjusted by Enterprise
    2=Approved by Enterprise
    3=Submitted to Enterprise
    4=Denied by Enterprise
    5=Submitted to Supplier
    6=Approved by Supplier
    7=Denied by Supplier
    8=Canceled
    9=Adjusted by Supplier
    23 SP_MSP_FEE Signed Number(28,3) DECIMAL(26,3) NOT NULL Managed Service Provider Fee
    24 SP_MSP_FEE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Managed Service Provider Fee (Base Currency)
    25 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
    B=Budget Check
    D=Distributed
    G=Generated
    H=Hold
    I=Ignore
    M=Modified
    N=Not Distributed
    S=Staged
    26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    27 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    28 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    29 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254