GPMY_NRP_RST_VW

(SQL View)
 Index Back

Payslip Absence result values

GP Malaysia Online and Hardcopy Payslip Absence result values.

SELECT A.EMPLID ,A.CAL_RUN_ID ,A.EMPL_RCD ,A.GP_PAYGROUP ,A.CAL_ID ,A.PIN_NUM + 50000000 ,A.GPMY_ACUM_VAL1+ 50000000 ,A.GPMY_ACUM_VAL2+ 50000000 ,A.GPMY_ACUM_VAL3+ 50000000 ,A.GPMY_ACUM_VAL4+ 50000000 ,A.GPMY_DESC_TYPE ,A.DESCR FROM PS_GPMY_ABS_RSLT A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
7 GPMY_ACUM_VAL1 Signed Number(20,6) DECIMAL(18,6) NOT NULL This field will be used to store the value of accumulator 1 used for on-line and hard-copy payslips.
8 GPMY_ACUM_VAL2 Signed Number(20,6) DECIMAL(18,6) NOT NULL This field will be used to store the value of accumulator 2 used for on-line and hard-copy payslips.
9 GPMY_ACUM_VAL3 Signed Number(20,6) DECIMAL(18,6) NOT NULL This field will be used to store the value of accumulator 3 used for on-line and hard-copy payslips.
10 GPMY_ACUM_VAL4 Signed Number(20,6) DECIMAL(18,6) NOT NULL This field will be used to store the value of accumulator 4 used for on-line and hard-copy payslips
11 GPMY_DESC_TYPE Character(2) VARCHAR2(2) NOT NULL This field will be used to identify which of the earnings/deductions description will be included on the on-line and hard-copy payslips. The options are Element Description, Element Name, or Custom (user entered).
10=Description
20=Custom
30=Element Name
12 DESCR Character(30) VARCHAR2(30) NOT NULL Description