SETIDDefault Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_14
LABOR_AGREEMENTEFFDTDefault Value: %date
D=Work Days
M=Months
N=Natural Days
W=Weeks
Prompt Table: SOCS_AGRMNT_ESP
EMPL_CTG_ESP(SQL Table) |
Index Back |
|---|---|
Employee Categorization - ESPEmployee Categorization - ESP |
| # | 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_VLD_HR_14 |
| 2 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | WORKING_HOURS | Number(8,2) | DECIMAL(7,2) NOT NULL | Working hours |
| 5 | WRK_HRS_DAY | Number(5,2) | DECIMAL(4,2) NOT NULL | Working hours per day |
| 6 | VACATION_PERIOD | Number(3,0) | SMALLINT NOT NULL | Vacation period |
| 7 | VACN_PERIOD_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Vacation period unit
D=Work Days M=Months N=Natural Days W=Weeks |
| 8 | ADDTL_PTO_ESP | Number(2,0) | SMALLINT NOT NULL | Additional PTO - ESP |
| 9 | SOCS_LBR_AGRMT_ESP | Character(14) | VARCHAR2(14) NOT NULL |
Social Security Labor Agreement.
Special codification following Social Security tables.
This info is needed for AFI File.
Prompt Table: SOCS_AGRMNT_ESP |