HR_CP_SPCPRJ_VW

(SQL View)
 Index Back

Employee Resume Special Projec

This view is created from the JPM_PROFILE, JPM_JP_ITEMS, HR_CP_INSTALL and HR_CP_CONTENT tables and is used in the Special Projects grid on the Employee Self-Service Internal Resume.

SELECT B.EMPLID ,A.EFFDT ,%Substring(A.JPM_TEXT254_4,1,30) ,A.JPM_TEXT1325_1 FROM PS_JPM_JP_ITEMS A , PS_JPM_PROFILE B , PS_HR_CP_INSTALL C , PS_HR_CP_CONTENT D WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = 'SPECL PROJ' AND B.JPM_JP_TYPE = C.JPM_JP_TYPE AND A.JPM_CAT_TYPE = D.JPM_CAT_TYPE

  • Related Language Record: SPECL_PROJ_LNG

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 DT_COMPLETED Date(10) DATE NOT NULL Date Completed
    3 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    4 DESCRLONG Long Character CLOB Long Description