GP_PIN_REN_SRCH

(SQL View)
 Index Back

PIN Rename Search

Global Payroll Pay Item Rename Search Record

SELECT c.oprid , b.pin_type , d.descr , b.pin_code , b.pin_nm , b.descr , b.used_by , b.country ,b.pin_num FROM ps_gp_pin b , ps_gp_opr_rule_prf c , ps_gp_pin_type d , PS_INSTALLATION e WHERE b.pin_type=d.pin_type AND (e.gp_cst_install_ind='N' OR (e.gp_cst_install_ind='Y' AND b.pin_owner='C')) AND (b.used_by = 'A' OR (b.used_by = 'C' AND c.used_by= 'A') OR (b.used_by = 'C' AND b.country = c.country))

  • Related Language Record: GP_PIN_SRCH_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type

    Prompt Table: GP_PIN_TYPE

    3 PIN_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL PIN Type
    4 PIN_CODE Character(22) VARCHAR2(22) NOT NULL Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
    5 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
    A=All Countries
    C=Specific Country
    8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    9 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number