GPJP_NRP_PP_VW

(SQL View)
Index Back

NRP:Pay Slip Print Data

Used by Element Relationship Map for record GPJP_PP_DATA.

SELECT EMPLID ,EMPL_RCD ,GPJP_POSITION ,JOBINSTANCE ,PIN_NUM + 50000000 ,GPJP_HEADING ,FLD_FMT ,CALC_RSLT_VAL ,CHR_PIN_VAL ,DATE_PIN_VAL FROM PS_GPJP_PP_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 GPJP_POSITION Character(6) VARCHAR2(6) NOT NULL Tracks the position of an element on a pay slip. The first two digits indicate the section that the element is displayed, the next two indicate the row, and the last two indicate the column.
4 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
6 GPJP_HEADING Character(16) VARCHAR2(16) NOT NULL This value is displayed on the pay slip as the heading for the associated element.
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 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
9 CHR_PIN_VAL Character(30) VARCHAR2(30) NOT NULL Calculation Character Result
10 DATE_PIN_VAL Date(10) DATE Calculation Date Result