GP_PIN_ADS

(SQL Table)
 Index Back

Pay Item Name Definition

This is the main record for setting up/maintaining Pay Item Name elements in the Global Payroll system.

  • Related Language Record: GP_PIN_LANG_ADS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
    2 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.
    3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    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 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 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
    9 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
    10 CHECK_GENER_IND Character(1) VARCHAR2(1) NOT NULL Check Generation Indicator
    11 RECALC_IND Character(1) VARCHAR2(1) NOT NULL Always Recalculate indicator
    12 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
    A=All Countries
    C=Specific Country
    13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    14 PIN_CATEGORY Character(4) VARCHAR2(4) NOT NULL Element Category
    15 PIN_INDUSTRY Character(4) VARCHAR2(4) NOT NULL Element Industry
    16 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
    17 PIN_CLASS Character(2) VARCHAR2(2) NOT NULL Element Class
    CU=Customary
    NC=Not Classified
    SM=Sample Data
    ST=Statutory
    SY=System Data
    18 OVRD_IND_CAL Character(1) VARCHAR2(1) NOT NULL Calendar Level Override Ind
    19 OVRD_IND_PYENT Character(1) VARCHAR2(1) NOT NULL Pay Entity Override Ind
    20 OVRD_IND_PG Character(1) VARCHAR2(1) NOT NULL Pay Group Override Indicator
    21 OVRD_IND_PYE Character(1) VARCHAR2(1) NOT NULL Payee Level Override Indicator
    22 OVRD_IND_PI Character(1) VARCHAR2(1) NOT NULL Positive Input Override Ind
    23 OVRD_IND_ELEM Character(1) VARCHAR2(1) NOT NULL Element Level Override Ind
    24 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
    25 STORE_RSLT Character(1) VARCHAR2(1) NOT NULL Store Results
    26 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
    27 PIN_PARENT_NUM Number(8,0) INTEGER NOT NULL Parent Element Number
    28 PIN_CUSTOM1 Character(20) VARCHAR2(20) NOT NULL Customer FIelds
    29 PIN_CUSTOM2 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM2
    30 PIN_CUSTOM3 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM3 fields
    31 PIN_CUSTOM4 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM4
    32 PIN_CUSTOM5 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM5
    33 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.
    34 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.
    35 PIN_DRIVER_NUM Number(8,0) INTEGER NOT NULL Element number field
    36 ENTRY_TYPE_USER_F1 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    37 PIN_USER_FLD1_NUM Number(8,0) INTEGER NOT NULL Element number field
    38 ENTRY_TYPE_USER_F2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    39 PIN_USER_FLD2_NUM Number(8,0) INTEGER NOT NULL Element number field
    40 ENTRY_TYPE_USER_F3 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    41 PIN_USER_FLD3_NUM Number(8,0) INTEGER NOT NULL Element number field
    42 ENTRY_TYPE_USER_F4 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    43 PIN_USER_FLD4_NUM Number(8,0) INTEGER NOT NULL Element number field
    44 ENTRY_TYPE_USER_F5 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    45 PIN_USER_FLD5_NUM Number(8,0) INTEGER NOT NULL Element number field
    46 ENTRY_TYPE_USER_F6 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    47 PIN_USER_FLD6_NUM Number(8,0) INTEGER NOT NULL Pin Number
    48 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
    49 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp
    50 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name
    51 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
    52 COMMENTS Long Character CLOB Comment