HRS_POS_DTA_G_1

(SQL View)
Index Back

Position Data Interface View

Comercial Position Data Interface View

SELECT A.POSITION_NBR , A.EFFDT , A.EFF_STATUS , A.GVT_ORG_TTL_DESCR , A.JOBCODE FROM PS_POSITION_DATA A WHERE A.EFF_STATUS = 'A'

  • Related Language Record: HCR_POSDTAG_LNI
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Default Value: 00000000

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
    5 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code