TC_PLAN_LNG

(SQL Table)
Index Back

Total Comp Plan Definition

This record allows the user to define a Total Compensation Plan which logically groups compensation and business units as well as logical unit of separation of Total Compensation extracts.

  • Related Language Record for TC_PLAN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Total Comp Plan ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 COMMENTS Long Character CLOB Comment