COUNTRYPrompt Table: GP_CNTRY_OP_VW
PIN_TAKE_NUMPrompt Table: GP_ABS_SS_ADD
EFFDTDefault Value: %date
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
GPMX_NRP_ABS_VW(SQL View) |
Index Back |
|---|---|
Absences Take MEXAbsences Take MEX |
| SELECT COUNTRY , PIN_TAKE_NUM +50000000 , EFFDT , GPMX_ABSCONSEQ_FLD , GPMX_ABSCNTRL_FLD FROM PS_GPMX_ABS_SS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_CNTRY_OP_VW |
| 2 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_ABS_SS_ADD |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | GPMX_ABSCONSEQ_FLD | Character(1) | VARCHAR2(1) NOT NULL |
Absence Consequence Field
Y/N Table Edit Default Value: N |
| 5 | GPMX_ABSCNTRL_FLD | Character(1) | VARCHAR2(1) NOT NULL |
Absence Control Field
Y/N Table Edit Default Value: N |