EMPLIDEMPL_RCDCOMPANYSETIDDEPTIDPrompt Table: DEPT_TBL
NL_FROM_YEARNL_FROM_MONTHBEGIN_DTF=Female
M=Male
U=Unknown
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
ABS_STAT_NLD(SQL Table) |
Index Back |
|---|---|
Absence History Statistics NLDThis table contains illness statistics for The Netherlands. This table will only be referenced by the SQR's: ABS005NL, ABS006NL and ABS702NL. |
| # | 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 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 6 | NL_FROM_YEAR |
Number(4,0) | SMALLINT NOT NULL | Year from |
| 7 | NL_FROM_MONTH |
Number(2,0) | SMALLINT NOT NULL | Month from |
| 8 | BEGIN_DT |
Date(10) | DATE | Begin Date |
| 9 | CREATION_DT | Date(10) | DATE | Creation Date |
| 10 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 11 | ABSENCE_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
| 12 | AGE_NLD | Number(3,0) | SMALLINT NOT NULL | Age |
| 13 | EMPL_RCD_ILI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Number of Employments Incl LI |
| 14 | EMPL_RCD_ELI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Number of Employments Excl LI |
| 15 | FTE_ILI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Number of FTE's Incl LI |
| 16 | FTE_ELI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Number of FTE's Excl LI |
| 17 | ILL_AVDAYS_ILI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Available days Incl LI |
| 18 | ILL_AVDAYS_ELI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Available days Excl LI |
| 19 | ILL_START_FULL_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Illness Started Fulltime
Y/N Table Edit |
| 20 | ILL_START_PART_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Illness Start Partial
Y/N Table Edit |
| 21 | ILL_ENDEPI_ELI_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Ind Illn Ended Excl PI Excl LI
Y/N Table Edit |
| 22 | ILL_ENDEPI_ILI_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Ind Illn Ended Excl PI Incl LI
Y/N Table Edit |
| 23 | ILL_ENDIPI_ELI_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Ind Illn Ended Incl PI Excl LI
Y/N Table Edit |
| 24 | ILL_ENDIPI_ILI_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Ind Illn Ended Incl PI Incl LI
Y/N Table Edit |
| 25 | ILL_DAYEPI_ELI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Days Ill Excl PI Excl LI |
| 26 | ILL_DAYEPI_ILI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Days Ill Excl PI Incl LI |
| 27 | ILL_DAYIPI_ELI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Days Ill Incl PI Excl LI |
| 28 | ILL_DAYIPI_ILI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Days Ill Incl PI Excl LI |
| 29 | ILL_LENEPI_ELI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Ill Leng Excl PI Excl LI |
| 30 | ILL_LENEPI_ILI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Ill Leng Excl PI Incl LI |
| 31 | ILL_LENIPI_ELI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Ill Leng Incl PI Excl LI |
| 32 | ILL_LENIPI_ILI_NLD | Number(14,3) | DECIMAL(13,3) NOT NULL | Ill Leng Incl PI Incl LI |