GPSC_EB_PIN_VW

(SQL View)
 Index Back

EB Compare View

Element Browser Compare View

SELECT B.OPRID , B.PIN_NUM_TGT , C.PIN_CODE , C.PIN_NM , C.PIN_TYPE , C.DESCR , C.FLD_FMT , C.DEFN_ASOFDT_OPTN , C.CHECK_GENER_IND , C.RECALC_IND , C.USED_BY , C.COUNTRY , C.PIN_CATEGORY , C.PIN_INDUSTRY , C.PIN_OWNER , C.PIN_CLASS , C.OVRD_IND_CAL , C.OVRD_IND_PYENT , C.OVRD_IND_PG , C.OVRD_IND_PYE , C.OVRD_IND_PI , C.OVRD_IND_ELEM , C.OVRD_IND_SOVR , C.STORE_RSLT , C.STORE_RSLT_IF_ZERO , C.PIN_PARENT_NUM , C.PIN_CUSTOM1 , C.PIN_CUSTOM2 , C.PIN_CUSTOM3 , C.PIN_CUSTOM4 , C.PIN_CUSTOM5 , C.FCST_IND , C.FCST_REQ_IND , C.PIN_DRIVER_NUM , C.ENTRY_TYPE_USER_F1 , C.PIN_USER_FLD1_NUM , C.ENTRY_TYPE_USER_F2 , C.PIN_USER_FLD2_NUM , C.ENTRY_TYPE_USER_F3 , C.PIN_USER_FLD3_NUM , C.ENTRY_TYPE_USER_F4 , C.PIN_USER_FLD4_NUM , C.ENTRY_TYPE_USER_F5 , C.PIN_USER_FLD5_NUM , C.ENTRY_TYPE_USER_F6 , C.PIN_USER_FLD6_NUM , C.RTO_DELTA_UF_LVL , C.LAST_UPDT_DTTM , C.LAST_UPDT_OPRID , C.AUTO_ASSIGNED_TYPE , C.GP_VERSION , C.COMMENTS FROM PS_GP_PKG_ELEMENTS A , PS_GPSC_ELM_CMPLST B , PS_GP_PIN C WHERE A.GP_PKG_ID =B.GP_PKG_ID AND A.PIN_NUM=B.PIN_NUM AND A.PIN_NUM+50000000=C.PIN_NUM AND (A.GP_PKG_NEW_PIN_FLG='Y' OR (GP_PKG_UPG_ACTION='U' AND A.GP_PKG_NEW_PIN_FLG='N'))

  • Related Language Record: GPSC_EB_PN_LANG

    • # 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_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Default Value: 999999

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

    Prompt Table: GP_PIN_TYPE

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 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
    8 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
    9 CHECK_GENER_IND Character(1) VARCHAR2(1) NOT NULL Check Generation Indicator
    10 RECALC_IND Character(1) VARCHAR2(1) NOT NULL Always Recalculate indicator

    Y/N Table Edit

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: GP_PIN_CATEGORY

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

    Prompt Table: GP_PIN_INDUSTRY

    15 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
    16 PIN_CLASS Character(2) VARCHAR2(2) NOT NULL Element Class
    CU=Customary
    NC=Not Classified
    SM=Sample Data
    ST=Statutory
    SY=System Data
    17 OVRD_IND_CAL Character(1) VARCHAR2(1) NOT NULL Calendar Level Override Ind

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    23 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
    24 STORE_RSLT Character(1) VARCHAR2(1) NOT NULL Store Results

    Y/N Table Edit

    25 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

    26 PIN_PARENT_NUM Number(8,0) INTEGER NOT NULL Parent Element Number
    27 PIN_CUSTOM1 Character(20) VARCHAR2(20) NOT NULL Customer FIelds
    28 PIN_CUSTOM2 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM2
    29 PIN_CUSTOM3 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM3 fields
    30 PIN_CUSTOM4 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM4
    31 PIN_CUSTOM5 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM5
    32 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.
    33 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.
    34 PIN_DRIVER_NUM Number(8,0) INTEGER NOT NULL Element number field
    35 ENTRY_TYPE_USER_F1 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    36 PIN_USER_FLD1_NUM Number(8,0) INTEGER NOT NULL Element number field
    37 ENTRY_TYPE_USER_F2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    38 PIN_USER_FLD2_NUM Number(8,0) INTEGER NOT NULL Element number field
    39 ENTRY_TYPE_USER_F3 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    40 PIN_USER_FLD3_NUM Number(8,0) INTEGER NOT NULL Element number field
    41 ENTRY_TYPE_USER_F4 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    42 PIN_USER_FLD4_NUM Number(8,0) INTEGER NOT NULL Element number field
    43 ENTRY_TYPE_USER_F5 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    44 PIN_USER_FLD5_NUM Number(8,0) INTEGER NOT NULL Element number field
    45 ENTRY_TYPE_USER_F6 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    46 PIN_USER_FLD6_NUM Number(8,0) INTEGER NOT NULL Pin Number
    47 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
    48 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp
    49 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name
    50 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
    51 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.
    52 COMMENTS Long Character CLOB Comment