GPMX_NRP_PTU_AD

(SQL Table)
Index Back

PTU Earnings and Deduction

Store PTU Eligible Earning/Deduction

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
3 EFFDT Date(10) DATE Effective Date
4 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element
5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
6 ACM_SIGN Character(1) VARCHAR2(1) NOT NULL Accumulator Sign
A=Add
S=Subtract
7 GPMX_ACM_TYPE Character(4) VARCHAR2(4) NOT NULL PTU :Amount or Units Accumulation
0010=Units
0020=Amount