HCR_POS_DTA_G_I

(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.GVT_OCC_SERIES , A.GVT_PAY_PLAN , A.JOBCODE , A.ENCUMBER_INDC FROM PS_POSITION_DATA 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

    Default Value: A

    4 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
    5 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
    6 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
    7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    8 ENCUMBER_INDC Character(1) VARCHAR2(1) NOT NULL Encumbrance Indicator
    I=Encumber Immediately
    N=No Encumbrance
    R=Encumber on Requisition