GPMY_TER_PYE(SQL Table) |
Index Back |
---|---|
Termination Details RecordUsed 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 |