GPMY_TER_PYE

(SQL Table)
Index Back

Termination Details Record

Used to store the terminations details of an employee.

# 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 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 NOTIFIED_DT Date(10) DATE Date First Notified
5 TERMINATION_DT Date(10) DATE Termination Date
6 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
7 EXPECTED_RETURN_DT Date(10) DATE Expected Return Date
8 GPMY_NOTIFCTN_ORIG Character(1) VARCHAR2(1) NOT NULL Notification Origin
E=Employer
P=Payee

Default Value: P

9 GPMY_WITHHOLDNOTIF Character(1) VARCHAR2(1) NOT NULL Withhold Notification flag

Y/N Table Edit

Default Value: Y

10 GPMY_FREEZE_PYMNT Character(1) VARCHAR2(1) NOT NULL Freeze Net Pay

Y/N Table Edit

Default Value: Y

11 GPMY_REFUND Character(1) VARCHAR2(1) NOT NULL Refund

Y/N Table Edit

Default Value: Y

12 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

Prompt Table: CURRENCY_CD_TBL

14 GPMY_CTRY_LFT_FLG Character(1) VARCHAR2(1) NOT NULL The field is used as a flag to indicate whether employee is departing MYS.

Y/N Table Edit

Default Value: N

15 GPMY_CESSN_RPT_FLG Character(1) VARCHAR2(1) NOT NULL The field is used as a flag to indicate whether cessation has been reported to IRB MYS.

Y/N Table Edit

Default Value: N

16 GPMY_DEPART_DT Date(10) DATE Expected Departure Date
17 GPMY_DEPART_REASON Character(25) VARCHAR2(25) NOT NULL Reason for Departure