SENIO_NOTIF_ITA(SQL Table) |
Index Back |
|---|---|
Anzianita - Notification TableItalian Table to setup the Number of days corresponding to all the combination of Anzianita and Notification |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_LAB_VLD_VW |
| 2 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table: EMPL_CTG |
| 3 | EMPL_CTG |
Character(6) | VARCHAR2(6) NOT NULL |
Employee Category
Prompt Table: EMPL_CTG_L1 |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | EMPL_CTG_L1 |
Character(6) | VARCHAR2(6) NOT NULL |
Employee Subcategory
Prompt Table: EMPL_CTG_L2 |
| 6 | EMPL_CTG_L2 |
Character(6) | VARCHAR2(6) NOT NULL |
Employee Subcategory 2
Prompt Table: EMPL_CTG_L3 |
| 7 | FROM_SENIORITY_ITA |
Number(3,0) | SMALLINT NOT NULL | From Seniority ITA |
| 8 | TO_SENIORITY_ITA | Number(3,0) | SMALLINT NOT NULL | To Seniority |
| 9 | NOTIF_DAYS_ITA | Number(5,0) | INTEGER NOT NULL | Notification Days ITA |
| 10 | DAY_TYPE_ITA | Character(1) | VARCHAR2(1) NOT NULL |
Day Type
C=Calendar W=Working |