RS_HRCHY_PL_ID

(SQL View)
 Index Back

Resource Pools

ESA for IT Resource Pool Main table. Used for storing Pool's informations.

SELECT POOL_ID , DESCR , DESCR254 , MANAGER_ID , STATUS , LEVEL1 , LEVEL2 , LEVEL3 , LEVEL4 , LEVEL5 , LEVEL6 , LEVEL7 , LEVEL8 , LEVEL9 , LEVEL_NUM , LAST_MEMBER_ID , FMS_DTTM_STAMP , FMS_OPRID , FMS_LASTUPDDTTM , FMS_LASTUPDOPRID , UNASSIGNED , ROW_NUMBER_5 FROM %Table(RS_RES_POOL) WHERE STATUS = 'A'

  • Related Language Record: RS_RESPOOL_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    4 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID

    Prompt Table: RS_ACT_EMPL
    Set Control Field: EMPLID

    5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    6 LEVEL1 Number(5,0) INTEGER NOT NULL Level 1
    7 LEVEL2 Number(5,0) INTEGER NOT NULL Level 2
    8 LEVEL3 Number(5,0) INTEGER NOT NULL Level 3
    9 LEVEL4 Number(5,0) INTEGER NOT NULL Level 4
    10 LEVEL5 Number(5,0) INTEGER NOT NULL Level 5
    11 LEVEL6 Number(5,0) INTEGER NOT NULL Level 6
    12 LEVEL7 Number(5,0) INTEGER NOT NULL Level 7
    13 LEVEL8 Number(5,0) INTEGER NOT NULL Level 8
    14 LEVEL9 Number(5,0) INTEGER NOT NULL Level 9
    15 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level
    16 LAST_MEMBER_ID Number(6,0) INTEGER NOT NULL Last Member ID
    17 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    18 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    19 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    20 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
    21 UNASSIGNED Character(1) VARCHAR2(1) NOT NULL Field used to indicate an unassigned pool
    N=No
    Y=Yes

    Default Value: N

    22 ROW_NUMBER_5 Number(5,0) INTEGER NOT NULL Row Number