ERE_DEPTS_ESP(SQL Table) |
Index Back |
---|---|
ERE DepartmentsCompany departments affected by an ERE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ERE_ID_ESP | Character(10) | VARCHAR2(10) NOT NULL | ERE ID |
2 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
3 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_01 |
4 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
5 | EMPL_COUNT | Number(12,0) | DECIMAL(12) NOT NULL | Employee Count |