SPA_TL_TRC_VW

(SQL View)
 Index Back

TRC Table

A Time Reporting Code (TRC) is used to classify a worker's time, primarily as the time is applied to a worker's compensation.

SELECT TRC , EFFDT , EFF_STATUS ,DESCR , DESCRSHORT , TRC_TYPE , UNIT_OF_MEASURE , CURRENCY_CD , SEND_TO_PAYROLL , MAX_QTY , MIN_QTY , FACTOR_MULT , FACTOR_RATE_ADJ , PER_INSTANCE , PER_INST_OVR_FLAG , RATE , RATE_OVR_FLAG , ADD_GROSS , DILUTE_LBDST_FLAG , HRS_REPRESENT_IND , SEND_TO_TCD , COMP_LEAV_IND , USED_COPY_FROM , TL_COPY_FROM , GP_ABSENCE_FLG , COMMENTS FROM PS_TL_TRC_TBL WHERE TRC_TYPE = 'H'

  • Related Language Record: TL_TRC_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %Date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 TRC_TYPE Character(1) VARCHAR2(1) NOT NULL TRC Type
    A=Amount
    H=Hours
    U=Units

    Default Value: H

    7 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    9 SEND_TO_PAYROLL Character(1) VARCHAR2(1) NOT NULL Send to Payroll?

    Y/N Table Edit

    Default Value: N

    10 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
    11 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
    12 FACTOR_MULT Signed Number(11,4) DECIMAL(9,4) NOT NULL Multiplication Factor
    13 FACTOR_RATE_ADJ Signed Number(11,4) DECIMAL(9,4) NOT NULL Rate Adjustment Factor
    14 PER_INSTANCE Signed Number(20,6) DECIMAL(18,6) NOT NULL Quantity per instance
    15 PER_INST_OVR_FLAG Character(1) VARCHAR2(1) NOT NULL Is per_instance overridable?

    Y/N Table Edit

    Default Value: N

    16 RATE Number(8,5) DECIMAL(7,5) NOT NULL Rate
    17 RATE_OVR_FLAG Character(1) VARCHAR2(1) NOT NULL Is rate overridable?

    Y/N Table Edit

    18 ADD_GROSS Character(1) VARCHAR2(1) NOT NULL Add to Gross Pay

    Y/N Table Edit

    19 DILUTE_LBDST_FLAG Character(1) VARCHAR2(1) NOT NULL Dilute Labor Distribution Flag

    Y/N Table Edit

    20 HRS_REPRESENT_IND Character(1) VARCHAR2(1) NOT NULL Hours Represent Indicator
    A=Actual Hours
    C=Compensation Only Hours

    Default Value: A

    21 SEND_TO_TCD Character(1) VARCHAR2(1) NOT NULL Send To TCD

    Y/N Table Edit

    Default Value: N

    22 COMP_LEAV_IND Character(4) VARCHAR2(4) NOT NULL Is TRC related to Comp Time?
    CERN=Comp Time Earned
    CTKN=Comp Time Taken
    LTKN=Leave Taken
    NO=No Comp Time Effect

    Default Value: NO

    23 USED_COPY_FROM Character(1) VARCHAR2(1) NOT NULL Copy From Payroll

    Default Value: N

    24 TL_COPY_FROM Character(3) VARCHAR2(3) NOT NULL Map To NA Earning Code

    Prompt Table: EARNINGS_TBL
    Set Control Field: ERNCD

    25 GP_ABSENCE_FLG Character(1) VARCHAR2(1) NOT NULL GP Absence Flag

    Y/N Table Edit

    26 COMMENTS Long Character CLOB Comment