TL_PAY_HIST_HST

(SQL Table)
 Index Back

Archive Rec - Payable History

Archive Record for Payable History.

  • Parent record: TL_PAYABLE_HIST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    6 DUR Date(10) DATE 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 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

    Prompt Table: TL_TASKGRP_TBL

    9 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID
    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 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

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

    Prompt Table: LOCAL_TAX_TBL

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

    Prompt Table: COMP_RT_REG_VW

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

    Y/N Table Edit

    Default Value: N

    18 OVERRIDE_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Override Rate.
    19 EST_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Estimated Gross
    20 LBR_DIST_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Labor Distribution Amount
    21 DILUTED_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Diluted Labor Distribution Amt
    22 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code
    23 PAYABLE_STATUS Character(2) VARCHAR2(2) NOT NULL Payable Status
    AP=Approved
    CL=Closed
    DL=Diluted
    DN=Denied
    ES=Estimated
    IG=Ignore
    NA=Needs Approval
    NP=No Pay
    OE=Online Estimate
    PB=Pushed Back
    PD=Distributed
    RP=Rejected by Payroll
    RV=Reversed Check
    SP=Sent to Payroll
    TP=Taken by Payroll
    24 PAY_SYSTEM Character(4) VARCHAR2(4) NOT NULL Payroll System
    GP=Global Payroll
    NA=Payroll for North America
    25 PAYROLL_REQ_NUM Number(6,0) INTEGER NOT NULL Last payroll request number.
    26 FROZEN_SW Character(1) VARCHAR2(1) NOT NULL Frozen
    N=Not Frozen
    Y=Frozen
    27 FROZEN_DATE Date(10) DATE Frozen Date
    28 RECORD_ONLY_ADJ Character(1) VARCHAR2(1) NOT NULL Record Only Adjustment
    29 PUBLISH_SW Character(1) VARCHAR2(1) NOT NULL If Data was published
    I=Ignore
    N=Not Publish
    Y=Published
    30 ACTUAL_PUB_DATE Date(10) DATE Publish Date
    31 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    32 APPRV_PRCS_DTTM DateTime(26) TIMESTAMP Approval Process Time
    33 SOURCE_IND Character(1) VARCHAR2(1) NOT NULL Indicates the source of payable time. S - system generated U - User entered O - Offset
    O=Offset
    S=System Generated
    U=User Reported
    34 ORIG_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Original Sequence Number
    35 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: TL_BUS_UNIT_VW

    37 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    38 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: TL_LOCATION_VW

    39 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    40 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: TL_DEPT_TBL_VW

    41 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    42 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: TL_JOBCODE_VW

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

    Prompt Table: POSITION_DATA

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

    Prompt Table: TL_PRODUCT_TBL

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

    Prompt Table: TL_CUSTOMER

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

    Prompt Table: TL_ACCTCD_BU_VW

    47 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL Project Costing Business Unit

    Prompt Table: BUS_UNIT_PRJ_VW

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

    Prompt Table: BUS_UNIT_TBL_PF

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

    Prompt Table: %EDIT_PROJECT

    50 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity Set ID
    51 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: %EDIT_ACTIVITY

    52 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Type

    Prompt Table: TL_PROJ_RTYPE_V

    53 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource Set ID
    54 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Category

    Prompt Table: %EDIT_RES_CAT

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

    Prompt Table: %EDIT_RES_SUB

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

    Prompt Table: TL_TASK

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

    Prompt Table: TL_USER_FIELD_1

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

    Prompt Table: TL_USER_FIELD_2

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

    Prompt Table: TL_USER_FIELD_3

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

    Prompt Table: TL_USER_FIELD_4

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

    Prompt Table: TL_USER_FIELD_5

    62 DEPTID_CF Character(10) VARCHAR2(10) NOT NULL Department
    63 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    64 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    65 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
    66 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
    67 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
    68 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
    69 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    70 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
    71 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
    72 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
    73 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
    74 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    75 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate2
    76 TL_RULE_ID Character(12) VARCHAR2(12) NOT NULL Rule ID
    77 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
    78 TL_PYBL_REASON_CD Character(3) VARCHAR2(3) NOT NULL Payable Reason Code
    CAN=Cancelled
    CRV=Reversed
    MRJ=Manual Reject
    NDS=Not Distributed
    NOP=Not OK to Pay
    NSP=Not Sent to Payroll
    NUS=Not Used
    PNP=Not Processed in Payroll
    PPS=Prior Period Adjustment
    RAJ=Record Adjustment
    79 INITIAL_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Original sequence number of payable time row.