ACTIONPrompt Table: GPMX_ACTN_RSN_V
ACTION_REASONPrompt Table: ACTN_REASON_TBL
Prompt Table: GPMX_TERM_VERS
0010=Termination
0020=Layoff
Default Value: 0010
GPMX_TER_ACTRSN(SQL Table) |
Index Back |
|---|---|
Termination Action/Reason MEXGPMX_TER_ACTRSN Use it to record combinations of action and reason codes with the corresponding Termination Version and Termination / Layoff |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACTION |
Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: GPMX_ACTN_RSN_V |
| 2 | ACTION_REASON |
Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
| 3 | GPMX_TERM_VERSION | Character(10) | VARCHAR2(10) NOT NULL |
Termination Version
Prompt Table: GPMX_TERM_VERS |
| 4 | GPMX_TER_LOF | Character(4) | VARCHAR2(4) NOT NULL |
Termination Layoff
Use this field to identify the termination reason as (Termination or Layoff)
0010=Termination 0020=Layoff Default Value: 0010 |