HRS_POS_DTA_VW2

(SQL View)
Index Back

Position Data HTML Email

Position Data View for HTML Email approvals.

SELECT A.POSITION_NBR , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.GVT_ORG_TTL_DESCR , A.JOBCODE FROM PS_POSITION_DATA A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_POSITION_DATA B WHERE B.POSITION_NBR = A.POSITION_NBR AND A.EFF_STATUS = 'A')

  • Related Language Record: HRS_POS_DTAVW2L
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    2 EFFDT Date(10) DATE NOT NULL Effective Date
    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
    7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code