POSITION_VW

(SQL View)
Index Back

Position_VW

POSITION_VW is a view of the Position Data record, which screens out most PeopleCode. It is used to bring in the Business Unit, Deptid, Jobcode, and Position Status information for the most effective-dated row.

SELECT POSITION_NBR , EFFDT , DESCR , DESCRSHORT , BUSINESS_UNIT , DEPTID , JOBCODE , POSN_STATUS FROM PS_POSITION_DATA

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

    Default Value: 0

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_HR

    6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    8 POSN_STATUS Character(1) VARCHAR2(1) NOT NULL Position Status
    A=Approved
    P=Proposed
    R=Frozen

    Default Value: A