HRS_POS_JP_LNP

(SQL View)
Index Back

Position Data

Position data limited by business unit and job family

SELECT A.BUSINESS_UNIT , A.JOB_PROFILE_ID , A.POSITION_NBR , A.EFFDT , A.LANGUAGE_CD , A.DESCR , A.DESCRSHORT , A.GVT_ORG_TTL_DESCR FROM PS_HRS_PSNDTJP_LNI A UNION SELECT B.BUSINESS_UNIT , B.JOB_PROFILE_ID , B.POSITION_NBR , B.EFFDT , B.LANGUAGE_CD , B.DESCR , B.DESCRSHORT , B.GVT_ORG_TTL_DESCR FROM PS_HRS_POS_JP_LI2 B UNION SELECT C.BUSINESS_UNIT , C.JOB_PROFILE_ID , C.POSITION_NBR , C.EFFDT , C.LANGUAGE_CD , C.DESCR , C.DESCRSHORT , C.GVT_ORG_TTL_DESCR FROM PS_HRS_POS_JP_LI3 C

  • Related Language Record for HRS_POS_JP_PRT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    2 JOB_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL Job Profile ID
    3 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Default Value: 00000000

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title