GPAU_STP_LA_IND

(SQL Table)
Index Back

Lump A Indicator

Lump A Indicator

# 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 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
4 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
7 EMPLID_BGRP Character(14) VARCHAR2(14) NOT NULL Emplid
8 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
9 GPAU_TAX_YEAR Number(4,0) SMALLINT NOT NULL Tax Year - End of Year Processing
10 BALANCE_GRP_NUM Character(3) VARCHAR2(3) NOT NULL This field will be used to determine the grouping of balances from the different jobs of the employee.
11 GPAU_STP_EVENT Character(1) VARCHAR2(1) NOT NULL Event Type is used to determine if it is Update Event or Payee Override.
P=Payee Override
U=Update Event
12 GPAU_LUMPA_IND Character(1) VARCHAR2(1) NOT NULL Lump sum A payment indicator
13 GPAU_STP_VERSION Number(3,0) SMALLINT NOT NULL Version for STP Update Event
14 GPAU_STP_UPDEVT_DT Date(10) DATE Update Event Date