HRS_POSN_DTA_I2

(SQL View)
 Index Back

Position Data

HRS_POSN_DTA_I2 is an interface view for the POSITION_DATA HR table. Thie view is created for use only by ERP

SELECT POSITION_NBR , EFFDT , CLASS_INDC , COMPANY , CONFIDENTIAL_POSN , FTE , JOB_SHARE , KEY_POSITION , LOCATION , ORGCODE , ORGCODE_FLAG , POSITION_POOL_ID , REG_REGION , REG_TEMP , SHIFT , UNION_CD , EFF_STATUS , DESCR , DESCRSHORT , GVT_ORG_TTL_DESCR , BUSINESS_UNIT , DEPTID , JOBCODE , POSN_STATUS FROM PS_POSITION_DATA

  • Related Language Record: HRS_POSDTAC_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 CLASS_INDC Character(1) VARCHAR2(1) NOT NULL Classified/Unclassified Ind
    B=All
    C=Classified
    T=Temporary
    U=Unclassified
    4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    5 CONFIDENTIAL_POSN Character(1) VARCHAR2(1) NOT NULL Confidential Position
    6 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
    7 JOB_SHARE Character(1) VARCHAR2(1) NOT NULL Job Sharing Permitted
    8 KEY_POSITION Character(1) VARCHAR2(1) NOT NULL Key Position
    N=No
    Y=Yes
    9 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    10 ORGCODE Character(60) VARCHAR2(60) NOT NULL Organization Hierarchy Code
    11 ORGCODE_FLAG Character(1) VARCHAR2(1) NOT NULL Organization Hierarchy Flag
    12 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID
    13 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    14 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    15 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=Day
    2=Evening
    3=Night
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating
    16 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code
    17 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    18 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    19 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    20 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
    21 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUSUNIT_HR_VW

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: %RECNAME_EDIT

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

    Default Value: A