GP_PKG_PIN_VW

(SQL View)
 Index Back

Pay Item Names

Global Payroll Package Pay Item Names view record.

SELECT PIN_NUM + 50000000 , 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)

    Default Value: GP_PIN.PIN_NM

    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

    Default Value: E

    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

    Default Value: N

    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

    Default Value: ALL

    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

    Default Value: P

    15 PIN_CLASS Character(2) VARCHAR2(2) NOT NULL Element Class
    CU=Customary
    NC=Not Classified
    SM=Sample Data
    ST=Statutory
    SY=System Data

    Default Value: NC

    16 OVRD_IND_CAL Character(1) VARCHAR2(1) NOT NULL Calendar Level Override Ind

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    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

    Y/N Table Edit

    Default Value: N

    23 STORE_RSLT Character(1) VARCHAR2(1) NOT NULL Store Results

    Y/N Table Edit

    Default Value: N

    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

    Default Value: N

    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

    Prompt Table: GP_PIN_ACD_VW

    34 ENTRY_TYPE_USER_F1 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

    Prompt Table: GP_ENT_USERF_VW

    35 PIN_USER_FLD1_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: %GP_EDIT_FLD1

    36 ENTRY_TYPE_USER_F2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

    Prompt Table: GP_ENT_USERF_VW

    37 PIN_USER_FLD2_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: %GP_EDIT_FLD2

    38 ENTRY_TYPE_USER_F3 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

    Prompt Table: GP_ENT_USERF_VW

    39 PIN_USER_FLD3_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: %GP_EDIT_FLD3

    40 ENTRY_TYPE_USER_F4 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

    Prompt Table: GP_ENT_USERF_VW

    41 PIN_USER_FLD4_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: %GP_EDIT_FLD4

    42 ENTRY_TYPE_USER_F5 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

    Prompt Table: GP_ENT_USERF_VW

    43 PIN_USER_FLD5_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: %GP_EDIT_FLD5

    44 ENTRY_TYPE_USER_F6 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

    Prompt Table: GP_ENT_USERF_VW

    45 PIN_USER_FLD6_NUM Number(8,0) INTEGER NOT NULL User Field 6

    Prompt Table: %GP_EDIT_FLD6

    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

    Default Value: 0

    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