TC_COMP_SOURCE

(SQL Table)
 Index Back

TC Compensation Source Table

Total Compensation Source table. Describes the sources for compensation, how they define compensation, what they are, and how they measure compensation.

  • Related Language Record: TC_COMPSRC_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TC_COMP_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Compensation Source
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    3 DATA_SOURCE Character(2) VARCHAR2(2) NOT NULL Data Source
    AE=Ad-Hoc Employee
    AO=Ad-Hoc Organizational
    E=Extract
    4 EXTRACT_PROGRAM Character(12) VARCHAR2(12) NOT NULL Extract Program

    Prompt Table: TC_AE_APPL_VW

    5 MAP_BASED Character(1) VARCHAR2(1) NOT NULL Map Based On
    D=Benefits and Deductions
    E=Earnings
    M=Multiple Components
    N=No Mapping
    T=Taxes - United States
    U=Taxes - Canada
    V=Variable Compensation
    6 TC_MEASURE Character(1) VARCHAR2(1) NOT NULL Amount Type
    C=Compensation Amount
    P=Payroll Amount
    7 COMMENTS Long Character CLOB Comment