EMPLIDEMPL_RCDORIG_BEGIN_DTGPFR_AT_REASONAT=Industrial Accident
MP=Occupational Illness
LANGUAGE_CDGPFR_AT_ADM_LNG(SQL Table) |
Index Back |
|---|---|
ATMP Admin info. Related langATMP Administrative information. |
| # | 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 Rcd Nbr |
| 3 | ORIG_BEGIN_DT |
Date(10) | DATE | original begin date |
| 4 | GPFR_AT_REASON |
Character(2) | VARCHAR2(2) NOT NULL |
GPFR: Reason for Absence
AT=Industrial Accident MP=Occupational Illness |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | GPFR_DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | GPFR: Description |
| 7 | GPFR_ASS_ESTB_DESC | Character(30) | VARCHAR2(30) NOT NULL | GPFR: Establishment |