GP_NRP_PSMSG_VW

(SQL View)
 Index Back

Payslip Messages

Payslip messages

SELECT GP_CNTRY_PSLP_MSG , GP_PSLP_MSG_NBR , DESCR , DESCRSHORT , GP_PSLP_MSG_AVAIL , GP_PSLP_POPUL_SEL , GP_PSLP_MSG_METHOD , CAL_RUN_ID , EFF_STATUS , GP_FROM_DT , GP_TO_DT , DEFN_ASOFDT_OPTN , GB_GROUP_ID , GROUP_LIST_ID , PIN_FRML_NUM + 50000000 , EMPLID , GP_PSLP_MSG_PRIOTY , GP_PSLP_MSG_TEXT , LASTUPDOPRID , LASTUPDDTTM FROM PS_GP_PSLP_MSG

  • Related Language Record: GP_PSLP_MSG_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_CNTRY_PSLP_MSG Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: GP_COUNTRY

    2 GP_PSLP_MSG_NBR Number(5,0) INTEGER NOT NULL This field will be used to identify the message number of the message that will be include on the on-line and hard-copy payslips,
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 GP_PSLP_MSG_AVAIL Character(1) VARCHAR2(1) NOT NULL Message Availability
    A=Always Active
    C=Calendar Group ID
    D=Date Range

    Default Value: A

    6 GP_PSLP_POPUL_SEL Character(1) VARCHAR2(1) NOT NULL Payslip Population Selection
    A=All Payees
    E=Payee
    F=Formula Element
    G=Human Resources Group
    O=Other Criteria
    P=Global Payroll Payee List

    Default Value: A

    7 GP_PSLP_MSG_METHOD Character(1) VARCHAR2(1) NOT NULL Payslip Message Method
    C=Payroll Calculation
    P=Payslip Processing

    Default Value: P

    8 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

    Prompt Table: %EDITTABLE

    9 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    10 GP_FROM_DT Date(10) DATE From Date
    11 GP_TO_DT Date(10) DATE To Date
    12 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
    13 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

    Prompt Table: GB_GROUP_SRCH

    14 GROUP_LIST_ID Character(10) VARCHAR2(10) NOT NULL Group List

    Prompt Table: GP_GRP_LIST_VW

    15 PIN_FRML_NUM Number(8,0) INTEGER NOT NULL Element number field
    16 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: GP_PERS_SRCH

    17 GP_PSLP_MSG_PRIOTY Number(3,0) SMALLINT NOT NULL Payslip Message Priority

    Default Value: 999

    18 GP_PSLP_MSG_TEXT Character(254) VARCHAR2(254) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
    19 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    20 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.