GP_PKG_IDCOUNTRYPIN_TAKE_NUMEFFDTDefault Value: %date
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
GPMX_NRP_ABS_AD(SQL Table) |
Index Back |
|---|---|
Absences Take MEXAbsences Take MEX |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL | Absence Take |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | GPMX_ABSCONSEQ_FLD | Character(1) | VARCHAR2(1) NOT NULL |
Absence Consequence Field
Y/N Table Edit Default Value: N |
| 6 | GPMX_ABSCNTRL_FLD | Character(1) | VARCHAR2(1) NOT NULL |
Absence Control Field
Y/N Table Edit Default Value: N |