TC_SRC_COMPIDS

(SQL Table)
Index Back

Comp Sources valid for CompID

Tells what are the valid Compensation sources for a particular type of Compensation

  • Parent record: TC_COMPID_MAPS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPENSATION_ID Character(10) VARCHAR2(10) NOT NULL Compensation ID
    2 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
    3 TC_COMP_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Compensation Source

    Prompt Table: TC_COMP_SRC_VW