TC_SRCADHORG_VW

(SQL View)
 Index Back

TC Prompt View Ad-hoc Org.

Total Comp Prompt View for Organizational level Ad-hoc on compensation source in the search record

SELECT A.TC_COMP_SOURCE_ID ,A.DESCR50 FROM PS_TC_COMP_SOURCE A WHERE DATA_SOURCE = 'AO'

  • Related Language Record: TC_SRCADHORG_LN

    • # 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