POSN_DATA_VW1

(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 ,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

    Default Value: 00000000

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUSUNIT_HR_VW

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: POSN_JOBCODE_VW

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

    Default Value: A

    8 JOB_SHARE Character(1) VARCHAR2(1) NOT NULL Job Sharing Permitted

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: POSITION_DATA