HRS_POSDTA_BU_I

(SQL View)
Index Back

Position Data

Position data by business unit

SELECT BUSINESS_UNIT , POSITION_NBR , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , GVT_ORG_TTL_DESCR , JOBCODE FROM PS_HRS_POSN_DTA_I2 A WHERE POSN_STATUS = 'A' AND ((%EffdtCheck(HRS_POSN_DTA_I2, A, %CurrentDateIn) AND A.EFF_STATUS = 'A') OR (A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_HRS_POSN_DTA_I2 E WHERE E.POSITION_NBR = A.POSITION_NBR AND E.EFFDT > %CurrentDateIn AND E.EFF_STATUS = 'A') AND NOT EXISTS ( SELECT 'Y' FROM PS_HRS_POSN_DTA_I2 F WHERE F.POSITION_NBR = A.POSITION_NBR AND %EffdtCheck(HRS_POSN_DTA_I2, F, %CurrentDateIn) AND F.EFF_STATUS = 'A')))

  • Related Language Record: HRS_PSNDTBU_LNI
  • # 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 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Default Value: 00000000

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
    8 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code