POSN_DATA_VW

(SQL View)
 Index Back

Position Data - Prompt View

This view is used as a prompt view of POSITION_DATA for the Position Number in Job Data. POSITION_DATA is the main data record for the Position Management application. It is also used in Succession Planning to establish key positions.

SELECT POSITION_NBR , EFFDT , EFF_STATUS , DESCR , BUSINESS_UNIT , DEPTID , JOBCODE , POSN_STATUS , JOB_SHARE , REPORTS_TO FROM PS_POSITION_DATA

  • Related Language Record: POSN_DATA_VW_LN

    • # 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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
    9 JOB_SHARE Character(1) VARCHAR2(1) NOT NULL Job Sharing Permitted

    Y/N Table Edit

    10 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

    Prompt Table: POSITION_DATA