HRS_G_PR_PL_TBL

(SQL Table)
Index Back

Priority Placement Code Table

GVT: This table is used to record valid Priority Placement code values. Priority Placement is used during the Recruiting/Hire/Promote processes as well as other staffing processes to ensure that employees who have been separated/RIFed/Changed to Lower Grade are given priority consideration for new placement actions.

  • Related Language Record: HRS_G_PR_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_PRIO_PLCMNT_CD Character(3) VARCHAR2(3) NOT NULL Priority Placement Code
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 GVT_PRIO_WEIGHT Number(3,0) SMALLINT NOT NULL Priority Placement Weight
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    7 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    8 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    9 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id