ERE_DEPTS_ESP

(SQL Table)
Index Back

ERE Departments

Company 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