EE_ALLERGY

(SQL Table)
Index Back

EE - Allergy Table

This is the Employee related Allergy Table. It is used to maintain multiple REG_REGION information for an employee.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

Default Value: OPR_DEF_TBL_HR.REG_REGION

Prompt Table: REG_REGION_TBL