GP_PIN_VW

(SQL View)
 Index Back

View of GP_PIN table

This is a view of the main record for setting up/maintaining Pay Item Name elements in the Global Payroll system. It is used when a field from GP_PIN is needed but we don not want the peoplecode in the GP_PIN record being executed.

SELECT PIN_NUM , PIN_CODE , PIN_NM , PIN_TYPE , DESCR , FLD_FMT , DEFN_ASOFDT_OPTN , CHECK_GENER_IND , RECALC_IND , USED_BY , COUNTRY , PIN_CATEGORY , PIN_INDUSTRY , PIN_OWNER , PIN_CLASS , OVRD_IND_CAL , OVRD_IND_PYENT , OVRD_IND_PG , OVRD_IND_PYE , OVRD_IND_PI , OVRD_IND_ELEM , OVRD_IND_SOVR , STORE_RSLT , STORE_RSLT_IF_ZERO , PIN_PARENT_NUM , PIN_CUSTOM1 , PIN_CUSTOM2 , PIN_CUSTOM3 , PIN_CUSTOM4 , PIN_CUSTOM5 , FCST_IND , FCST_REQ_IND , PIN_DRIVER_NUM , ENTRY_TYPE_USER_F1 , PIN_USER_FLD1_NUM , ENTRY_TYPE_USER_F2 , PIN_USER_FLD2_NUM , ENTRY_TYPE_USER_F3 , PIN_USER_FLD3_NUM , ENTRY_TYPE_USER_F4 , PIN_USER_FLD4_NUM , ENTRY_TYPE_USER_F5 , PIN_USER_FLD5_NUM , ENTRY_TYPE_USER_F6 , PIN_USER_FLD6_NUM , RTO_DELTA_UF_LVL , LAST_UPDT_DTTM , LAST_UPDT_OPRID , AUTO_ASSIGNED_TYPE , GP_VERSION , COMMENTS FROM PS_GP_PIN

  • Related Language Record: GP_PIN_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Default Value: 999999

    2 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)
    3 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    4 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type

    Prompt Table: GP_PIN_TYPE

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 FLD_FMT Character(1) VARCHAR2(1) NOT NULL Field format for Global Payroll elements
    1=Character
    2=Date
    3=Monetary
    4=Decimal
    5=Element Pointer
    6=Not Applicable
    7 DEFN_ASOFDT_OPTN Character(1) VARCHAR2(1) NOT NULL DEFN_ASOFDT_OPTN
    B=Calendar Period Begin Date
    E=Calendar Period End Date
    N=Not Applicable
    P=Payment Date
    R=Process Begin Date
    S=Process End Date
    8 CHECK_GENER_IND Character(1) VARCHAR2(1) NOT NULL Check Generation Indicator
    9 RECALC_IND Character(1) VARCHAR2(1) NOT NULL Always Recalculate indicator

    Y/N Table Edit

    10 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
    A=All Countries
    C=Specific Country
    11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    12 PIN_CATEGORY Character(4) VARCHAR2(4) NOT NULL Element Category

    Prompt Table: GP_PIN_CATEGORY

    13 PIN_INDUSTRY Character(4) VARCHAR2(4) NOT NULL Element Industry

    Prompt Table: GP_PIN_INDUSTRY

    14 PIN_OWNER Character(1) VARCHAR2(1) NOT NULL Element Owner
    C=Customer Maintained
    M=PS Delivered/Customer Modified
    N=PS Delivered / Not Maintained
    P=PS Delivered / Maintained
    S=PS Delivered/Maintained/Secure
    15 PIN_CLASS Character(2) VARCHAR2(2) NOT NULL Element Class
    CU=Customary
    NC=Not Classified
    SM=Sample Data
    ST=Statutory
    SY=System Data
    16 OVRD_IND_CAL Character(1) VARCHAR2(1) NOT NULL Calendar Level Override Ind

    Y/N Table Edit

    17 OVRD_IND_PYENT Character(1) VARCHAR2(1) NOT NULL Pay Entity Override Ind

    Y/N Table Edit

    18 OVRD_IND_PG Character(1) VARCHAR2(1) NOT NULL Pay Group Override Indicator

    Y/N Table Edit

    19 OVRD_IND_PYE Character(1) VARCHAR2(1) NOT NULL Payee Level Override Indicator

    Y/N Table Edit

    20 OVRD_IND_PI Character(1) VARCHAR2(1) NOT NULL Positive Input Override Ind

    Y/N Table Edit

    21 OVRD_IND_ELEM Character(1) VARCHAR2(1) NOT NULL Element Level Override Ind

    Y/N Table Edit

    22 OVRD_IND_SOVR Character(1) VARCHAR2(1) NOT NULL This field is used on GP_PIN page to determine if any element definition overrides are allowed
    23 STORE_RSLT Character(1) VARCHAR2(1) NOT NULL Store Results

    Y/N Table Edit

    24 STORE_RSLT_IF_ZERO Character(1) VARCHAR2(1) NOT NULL Store Results if Zero
    N=If Element Or Comp Is Non-Zero
    X=If Element Is Non-Zero
    Y=Always Store

    Y/N Table Edit

    25 PIN_PARENT_NUM Number(8,0) INTEGER NOT NULL Parent Element Number
    26 PIN_CUSTOM1 Character(20) VARCHAR2(20) NOT NULL Customer FIelds
    27 PIN_CUSTOM2 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM2
    28 PIN_CUSTOM3 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM3 fields
    29 PIN_CUSTOM4 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM4
    30 PIN_CUSTOM5 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM5
    31 FCST_IND Character(1) VARCHAR2(1) NOT NULL This field is used on the GP_PIN record to indicate whether or not the element should be processed during Forecasting.
    32 FCST_REQ_IND Character(1) VARCHAR2(1) NOT NULL The field is used on GP_PIN to indicate whether forecasting is required for this element.
    33 PIN_DRIVER_NUM Number(8,0) INTEGER NOT NULL Element number field
    34 ENTRY_TYPE_USER_F1 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    35 PIN_USER_FLD1_NUM Number(8,0) INTEGER NOT NULL Element number field
    36 ENTRY_TYPE_USER_F2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    37 PIN_USER_FLD2_NUM Number(8,0) INTEGER NOT NULL Element number field
    38 ENTRY_TYPE_USER_F3 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    39 PIN_USER_FLD3_NUM Number(8,0) INTEGER NOT NULL Element number field
    40 ENTRY_TYPE_USER_F4 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    41 PIN_USER_FLD4_NUM Number(8,0) INTEGER NOT NULL Element number field
    42 ENTRY_TYPE_USER_F5 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    43 PIN_USER_FLD5_NUM Number(8,0) INTEGER NOT NULL Element number field
    44 ENTRY_TYPE_USER_F6 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    45 PIN_USER_FLD6_NUM Number(8,0) INTEGER NOT NULL User Field 6
    46 RTO_DELTA_UF_LVL Character(1) VARCHAR2(1) NOT NULL Used to defined what user fields to consider when summing retro or deltas
    0=None
    1=Through User Field 1
    2=Through User Field 2
    3=Through User Field 3
    4=Through User Field 4
    5=Through User Field 5
    A=All User Fields Defined
    47 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp
    48 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name
    49 AUTO_ASSIGNED_TYPE Character(2) VARCHAR2(2) NOT NULL Auto-Assigned Element Type
    AR=Add to Arrears
    BS=Base
    NT=Amount Not Taken
    PB=Payback
    PC=Percent
    RT=Rate
    UN=Unit
    50 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.
    51 COMMENTS Long Character CLOB Comment